Latest Blog Posts

How to Hide Filter Arrows from Pivot Table in Excel (3 Easy Ways)

When generating a Pivot Table in Excel, various Field Buttons including Filter Arrows appear automatically on the table headers. In this article, we ...

How to Create A Product Catalog in Excel: 5 Methods

Method 1 - Make the Dataset Ready Collect the information about the mobiles stored in the shop. Collect the images of the mobiles that are ...

How to Check If a Number Is Odd or Even with Excel VBA

In this article, we will demonstrate a step-by-step procedure to check if a number is odd or even with VBA in Excel. We used Office 365, but you may ...

How to Add Standard Deviation Error Bars in Excel: 5 Methods

Method 1 - Input a Dataset with Necessary Components Insert a dataset that will be populated with the necessary components. We have taken a ...

How to Sort Bar Chart in Descending Order in Excel (4 Easy Ways)

We will use the following dataset, which contains two columns named Student Name and Test Score. A bar chart is inserted using these two columns. ...

How to Make a Decision Tree Algorithm in Excel – 3 Easy Examples

“Product Price of ABC Beverage Limited” is the sample dataset. Example 1 - Creating a Decision Tree for 4 Events Step 1: Construct ...

How to Write X Bar or Hat in Excel (4 Methods)

The X Bar symbol is used in statistics frequently. Method 1 - Use Symbol Command to Write X Bar in Excel Steps:  Select the ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo