How to Restrict Data Entry in Excel Cell (2 Simple Methods)

The following dataset contains the names of students in a column. We’ll restrict the data entry in the Project Code column. Method 1 - Using ...

How to Reverse Order of Columns Horizontally in Excel

Reversing the order simply means swapping the column values. Therefore indicates the very last item in the column should be the first value in the ...

How to Insert Symbol in Excel Header (4 Ideal Methods)

The article will show you some methods to insert symbol in the Excel Header. We need to use symbols to separate words or names and also we mean ...

How to Save Multiple Excel Sheets as One File (5 Methods)

  Method 1 - Using the Save As Command Steps: Select all of the spreadsheets you want to save in one file. Hold Ctrl and left-click ...

Excel VBA to Protect Range of Cells (3 Examples)

We have a dataset that contains formulas in the Savings column and the rest are values. Method 1 - Protect a Certain Range of Cells ...

Send Reminder Email Automatically from an Excel Worksheet Using VBA

The sample dataset below includes the emails of various people, as well as the deadlines they must meet for various reasons. We'll use a VBA macro to ...

Excel VBA: Turn Off Screen Update

It’s an important issue for all of us while working with VBA in Excel, to turn off the screen update. In this article, I’ll show you how you can turn ...

How to Calculate Logarithmic Growth in Excel (2 Easy Methods)

In this article, we will learn to calculate logarithmic growth in Excel. Mainly, there are two types of growth. They are logarithmic growth and ...

How to Track Attendance in Excel (with Detailed Steps)

  Elements of an Attendance Tracker To make an attendance tracker in Excel, you will need the following: Month Holidays Types ...

Convert Cubic Feet to Cubic Meters in Excel: 2 Easy Methods

Method 1 - Use CONVERT Function to Convert Cubic Feet to Cubic Meters in Excel Steps: Select a cell to apply the formula. We selected cell ...

How to Save a Worksheet in Excel to a Separate File (3 Handy Methods)

Method 1 - Save an Excel Worksheet to a Separate File with the ‘Move or Copy‘ Command Steps Click on the worksheet tab/name that you want to ...

2 Methods to Use Millimeter (mm) to Square Meter (m2) Formula in Excel

Suppose you have several square-shaped Exhibits with Dimensions in millimeters(mm) and you need to convert them to square meters. Method 1 - ...

How to Calculate the Average Ratio in Excel – 2 Methods

The sample Dataset showcases Products, Sales in January, and in February. Method 1 - Using the GCD Function to Calculate the Average Ratio ...

[Fixed!] Document Not Saved Excel Network Drive (5 Solutions)

You may find difficulties in saving the Excel file in the shared network drive. They often show the message Document not saved. If this problem ...

Excel VBA Save as File Format (12 Suitable Examples)

To illustrate how to Save as in various ways using VBA, we’ll use the following dataset containing the Salesman, Product, and Net Sales data of a ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo