Latest Blog Posts

Return Non Blank Cells from a Range in Excel (3 Suitable Ways)

The following dataset consists of two columns labeled Area and Sales Rep. It has several records that are missing important information. We are going ...

How to Create a 3D Bar Chart in Excel – 3 Examples

Consider the Yearly Sales Data dataset, containing “Location”, and  “Years 2020”, “2021” and “2022” .   Example 1 - Creating a 3D ...

How to Shade Area Between Two Lines in a Chart in Excel 

We will use the sample dataset below for illustration. Step 1: Using Some Simple Formulas to Set Things Up In a new column, copy the ...

How to Create a Timer with Milliseconds in Excel VBA

Step 1 - Creating a Data Set with Timers Open a workbook and put your desired alert times, just like the screenshot below. Read More: ...

How to Use Advanced Filter with Wildcard in Excel

In this article, I will show you how to use the Advanced Filter with Wildcard in Excel. As we know, sometimes we need to use the Excel Advanced ...

How to Calculate Tracking Error in Excel: 4 Methods

Method 1 - Make a Dataset with Proper Parameters To calculate tracking errors, we will make a dataset. Method 2 - Determine Active ...

How to Stop Automatic Cell Formatting in Excel

This is an overview.   Unchecking the AutoCorrect Dialog Box Steps Click the arrow button above the ribbon and select More ...

How to Create Social Security Break Even Calculator in Excel: 6 Methods

Method 1 - Insert Primary Information Insert basic information to compare two ages and 100% benefits in the dataset. Method 2 - ...

How to Separate Odd and Even Numbers in Excel – 6 Methods

To separate odd and even numbers: Method 1 - Combining the  FILTER and the MOD Functions to Separate Odd and Even Numbers Steps: In ...

How to Find Standard Error of Estimate in Excel (3 Easy Ways)

In this tutorial, I am going to show you 3 easy methods of how to find the standard error of estimate in Excel. You can quickly use these methods to ...

How to Stop Excel from Auto Formatting Hyperlinks

Stopping Excel from auto-formatting hyperlinks refers to preventing Excel from generating hyperlinks automatically while pasting new links. Excel, by ...

How to Create a Networking Catalogue in Excel (with Easy Steps)

Networking equipment such as switches, routers, wireless, etc. is well-known in the technology industry. To promote the product, companies may often ...

How to Use DMIN Function in Excel (4 Suitable Examples)

In many situations, we need to use the DMIN function to find the minimum value in a range of cells based on criteria. In the following article, we ...

How to Calculate Realized Volatility in Excel (with Easy Steps)

Which type of stock we should invest in and how the performance of the stocks would be, have been some burning questions for millennia. Investors ...

Drawing Decision Trees in Excel (2 Easy Ways)

A decision tree is a kind of flow chart in Excel. It helps to visualize certain conditions clearly and take action according to them. There are ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo