Latest Blog Posts

How to Convert Cm to Feet and Inches in Excel – 3 Methods

The dataset contains students' names and their height. To convert cm to feet and inches:   Method 1 - Using the CONVERT Function ...

How to Log Transform Data in Excel – 4 Methods

The dataset below showcases the number of deaths up to June 1st, 2022 in 6 different countries. What Is Log Transform? Log Transform ...

Create a Report as a Table in Excel – 4 Steps

This is the sample dataset. Step 1 - Create a Table Using the PivotTable Feature Select the whole worksheet. Go to Insert > ...

Why Does Excel Autosave Keep Turning Off (Reason & Solution)

If you are a Microsoft 365 subscriber, you will see the AutoSave button at the top left corner of the Excel window. But you need to store the Excel ...

How to Unlock Arrow Keys in Excel (2 Ways)

Method 1 - Using the Keyboard Key Almost all keyboards contain a dedicated Scroll Lock key that you can use to turn off the Scroll Lock and unlock ...

How to Drag Formula and Ignore Hidden Cells in Excel (2 Examples)

This is the sample dataset. Example 1 - Drag Formula and Ignore Hidden Cells Using SUBTOTAL Function Steps Press Ctrl and select row ...

How to Keep Track of Clients in Excel (Download Free Template)

  Step 1 - Make Dataset for Contact Details The contact details include specific information about that client, such as their contact number, ...

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo