Latest Blog Posts

How to Create Sparklines in Excel (2 Easy Ways)

You may have created a chart in Excel on the basis of some gathered data. But sometimes you may need to create Sparklines in your Excel worksheet to ...

How to Add a Data Table with Legend Keys in Excel

Step 1 - Create a Dataset We are going to create a dataset of a company’s total sales and the total amount of each month's sales. We will put ...

How to Color an Excel Bubble Chart Based on Value (2 Methods)

Method 1 - Color Bubble Chart Using Single Series Data Values This method of creating a bubble chart is quite simple. You can set the color of the ...

How to Create a Stacked Column Chart in Excel: 4 Examples

Example 1 - Create a Basic Stacked Column Chart in Excel Steps: Open the worksheet which contains the dataset. Select the required range of ...

How to Plot Normal Distribution in Excel (With Easy Steps)

We’ll use the NORM.DIST function to find the Normal Distribution in Excel. This function needs 4 arguments: x: The data for which we’ll determine ...

How to Track Time Spent on Projects in Excel (5 Useful Methods)

We have made a dataset named Dataset of Projects Finished in a Day. It has column headers as Project Name, Starting Time, and Ending Time. We’ll ...

How to Make a Cumulative Distribution Graph in Excel

We have the following data representing student heights in meters. We'll use it to make a cumulative distribution graph. How to Make a ...

How to Create Column and Line Chart Combo in Excel (Step by Step)

  Step 1 - Insert the Clustered Combo Chart in the Worksheet Select all the columns from the given data set Go to the Insert tab and ...

How to Make 3D Doughnut Chart in Excel (Create with Easy Steps)

If you are looking for ways to make a 3D doughnut chart in Excel, then this article will serve this purpose. We often use Doughnut Chart in Excel to ...

How to Calculate Net Salary in Excel: 6 Methods

Method 1: Employee Database & Basic Salary Structure The figure below shows basic salary structure of a company, and we want to calculate the ...

How to Make a Salary Comparison Chart in Excel (4 Easy Steps)

A salary comparison chart compares employee salaries across the various departments in an organization. Salaries are compared against survey data or ...

How to Create a Waterfall Chart in Excel (2 Easy Methods)

Looking for ways to know how to create a waterfall chart in Excel? Usually, we use waterfall charts to graphically visualize cumulative values. Here, ...

How to Consolidate Rows and Sum Data in Excel – 4 Methods

There are duplicate entries in the dataset below. Method 1 - Use the Consolidate Feature in Excel Steps: Copy the headers of the ...

Excel Pie Chart Not Grouping Data with Easy Fix: 3 Methods

Method 1 - Add a New Column to the Existing Dataset Start by entering a new column just by the side of the data table. Fill them with “1” to ...

How to Find Slope of Polynomial Trendline in Excel (with Detailed Steps)

Finding the slope of a linear trendline is relatively straightforward in Excel. You just have to find out the equation and declare the coefficient of ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo