Latest Blog Posts

How to Verify Odd and Even Using IF Function in Excel

Verifying whether a number is odd or even can be a useful task in a variety of situations, such as data analysis or creating formulas for ...

How to Use DEVSQ Function in Excel (3 Suitable Examples)

In this article, we will show how to use the DEVSQ function in Excel. The DEVSQ function is used to calculate the sum of squares of deviations of ...

How to Use DSTDEV Function in Excel (3 Practical Examples)

In this tutorial, I am going to show you 3 practical examples of how to use the DSTDEV function in Excel. Specifically, you can quickly use these ...

How to Sort Odd and Even Numbers in Excel (4 Easy Examples)

Example 1 - Using ISODD Function to Sort Odd and Even Numbers in Excel We have added a Helper Column in the dataset where we will use the ISODD ...

How to Use an Advanced Filter for a Date Range in Excel – 2 Methods

The dataset showcases the sales quantity of electronic products on different dates in January, February and March 2022. Method 1- Use the ...

How to Use Spin Button to Display Negative Values in Excel

A spin button helps to increase or decrease values easily by clicking on the button easily. But, you can not get negative values directly by using ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo