Latest Blog Posts

How to Create Pipeline Chart in Excel (2 Easy Ways)

We have the sales number of different stores of a product arranged in descending order. We will use this data to create the pipeline chart. ...

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 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 Use EOMONTH Function in Excel (10 Ideal Examples)

In this tutorial, we’ll unpack the EOMONTH function, how to use it, and how to combine it with other functions. The screenshot above is an ...

How to Change an Axis to a Log Scale in Excel (3 Ways)

Month and Net Sales are columns in the following dataset. It is crucial to notice that the dataset we will work with has some numeric values that are ...

How to Remove an Advanced Filter in Excel – 5 Methods

The dataset represents a duty roster. Advanced Filters were applied. To know if a dataset is Advanced filtered, look at the row index numbers. If ...

Pivot Table Test for an Interview – 6 Exercises

  Problem Overview There are seven columns and 714 rows in the sample dataset. It represents sales data of a company from 2019 to ...

How to Create a Custom AutoFill List in Excel – 2 Methods

    Method 1 - Using the Advanced Excel Options to Create a Custom AutoFill List Create a dataset. Select the range to ...

How to Perform Tab Navigation in Excel (8 Easy Ways)

Here are two simple ways to navigate worksheet tabs in Excel: To move to the adjacent sheet tabs, press Ctrl+PgDn to move to the next sheet, and ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo