Latest Blog Posts

How to Change Orientation from Horizontal to Vertical in Excel

Excel is the most widely used tool for dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, we ...

How to Change the Chart Data Range in Excel (5 Quick Methods)

In the sample dataset, there are 3 columns: Customer Name, Sales, and Profit. Method 1 – Using the Design Tab Steps: Select the ...

How to Add Automatic Serial Number with Formula in Excel

We will use a dataset that contains information about the Marks of some students. We will add automatic serial numbers to the dataset using some ...

How to Change Text Orientation in Excel (5 Easy Methods)

When you are working on a dataset for presenting to customers or stakeholders, you may need to organize the texts in the most easily readable way. In ...

How to Create a 2D Clustered Column Chart in Excel – 2 Methods

This is the sample dataset. Method 1 - Creating a Data Set to Create a 2D Clustered Column Chart Step 1: Select your entire ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo