How to Find the Intersection of Two Columns in Excel (7 Methods)

Below is a monthly sales dataset of Products A, B, and C. Using simple tricks, we will find the intersection between these sales columns. ...

How to Create and Customize a Bar of Pie Chart in Excel – 6 Steps

  What Is the Bar of a Pie Chart in Excel? The Bar of pie is a type of chart that displays a bar chart with the pie chart. The sample ...

How to Do Union of Two Columns in Excel (5 Easy Ways)

We have the Addresses of Employees of a Company as our dataset. We have information on the Street and the City for each employee. We will do a union ...

Visualization Examples in Excel – 12 Examples

Example 1 - Column Chart The sample dataset showcases 3 people's leisure activities. To create a chart:  Steps: Select the entire ...

How to Find Sum of Squared Deviations in Excel (2 Easy Ways)

As financial analysts, we use Excel functions to calculate the sum of squared deviations in evaluating the variation in daily stock values. Moreover, ...

How to Create Overlapping Bar Chart in Excel (with Easy Steps)

Step 1 - Create Custom Combo Chart Select the dataset. Select “Create Custom Combo Chart” from the “Insert Combo Chart” menu under the ...

How to Evaluate String as Code with Excel VBA (2 Examples)

Are you looking for ways to evaluate string as code with Excel VBA? Visual Basic for Applications (VBA) is a versatile programming language widely ...

How to Create Bar Chart with Multiple Categories in Excel

STEP 1 - Create Dataset for Bar Chart with Multiple Categories Create a dataset for the bar chart that includes categories, sub-categories, and ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo