Latest Blog Posts

How to Reference Comments in Excel (3 Easy Methods)

Sometimes we need to create comments in Excel because it helps to remember any information for the user or the other users. If you don’t know how to ...

How to Print Notes in Excel (2 Simple Methods)

This tutorial will demonstrate how to print notes in Excel. In Microsoft Excel 365, we use notes as reminders. The notes in Excel 365 look like ...

How to Create a Google Map with Excel Data (With Easy Steps)

Step 1: Prepare the Worksheet Suppose we need to collect some employees' detailed addresses: Put their name in column A. Place the street ...

How to Change Background Color to Grey in Excel (Step by Step)

In this article, we will explain how to change the Excel background color to grey. Unfortunately we can’t simply change the Excel background color ...

How to Convert Feet to Meters in Excel: 4 Simple Methods

Method 1 - Converting Feet to Meters Using Arithmetic Operations Arithmetic Operations such as Multiplication (i.e., x) or Division (i.e., /) are ...

How to Calculate Mean Variance and Standard Deviation in Excel

The variance, standard deviation and mean deviation are closely related to each other. While working with large Microsoft Excel, now and then, we ...

How to Calculate the Variance Using a Pivot Table in Excel – Easy Steps

This is the dataset. To calculate the variance of sales between 2020 and 2021: Step 1 - Create a Pivot Table from a Data Range ...

How to Convert Meters to Miles in Excel (3 Simple Methods)

Converting one dimension to another dimension seems to be a difficult task most of the time. We need to convert inches to mm, mm to feet, kg to ...

How to Hide Notes in Excel: 3 Handy Approaches

Method 1 - Hiding Notes in Excel Through Review Tab 1.1 Hiding All Notes STEPS: Go to Review ➤ Notes. Select Show All Notes. All ...

How to Use Excel VBA to Save a Sheet as a New Workbook without Opening It (6 Examples)

Example 1 - Renaming a Sheet and Saving It as a New Workbook Open your workbook in Excel. Press Alt + F11 to open the Visual Basic for ...

How to Calculate Standard Error of Regression in Excel (with Easy Steps)

We use regression analysis when we have data from two variables from two different sources and want to build a relationship between them. Regression ...

Fill Handle Not Working in Excel (5 Solutions)

Solution 1 - Enable the Fill Handle Option When working with a dataset in Excel, you might encounter situations where the fill handle is not ...

How to Edit Drop Down List in Excel Macro (4 Easy Methods)

In this article, we will show you 4 methods of using Excel VBA to edit Drop Down List in Excel Macro. Time is very valuable, we can save a lot of ...

How to Convert Decimal Feet to Feet and Inches in Excel: 4 Methods

Method 1 - Using the INT & MOD Functions Steps: Select the D5 cell. Enter this formula in the D5 cell to directly convert decimal ...

How to Convert Meters to Feet in Excel – 4 Methods

This is the sample dataset.   Method 1 - Converting Meter to Feet Manually Steps: Select D5, enter the formula, and press ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo