Latest Blog Posts

SBI Home Loan EMI Calculator in Excel Sheet with Prepayment Option

    What Is Home Loan EMI? EMI stands for Equated Monthly Installment. It includes repayment of the principal amount and payment of ...

Stacked Area Chart with Line in Excel (2 Practical Examples)

While working in Microsoft Excel with the sales-related worksheets, sometimes we need to stack area charts with lines. The area chart shows you a ...

Excel Doughnut Chart with Multiple Rings (Create with Easy Steps)

Here's an overview of a doughnut chart with multiple rings, outlining sales data in different quarters. How to Create a Doughnut Chart ...

How to Add a Legend in Excel (2 Methods)

In the below example, the Legend is marked by the red outlined box. The Blue color represents Sales and the Orange color represents Profit. ...

Excel VBA: If Statement Based on Cell Value: 2 Practical Methods

Method 1 - If Statement Based on Cell Value of a Single Cell in Excel VBA We’ll learn to use an If statement based on the value of a single cell. ...

How to Show Data Labels in Excel 3D Maps: 2 Methods

Create a 3D Map in Excel Steps: Select any cell within the dataset. We selected cell D6. From the Insert tab >>> select 3D Map. ...

How to Make a Radar Chart in Excel (2 Easy Methods)

In this article, we'll show you how to make a Radar chart in Excel. Here, we will explain 2 methods to make the radar chart effortlessly. What ...

How to Group Small Values in an Excel Pie Chart (2 Methods)

Method 1 - Group Small Values with Pie of Pie Chart Prepare Your Data Input the names of the 12 months in cells B5:B15. Enter the total ...

How to Forecast Call Volume in Excel (with Quick Steps)

If you are working as a manager in a call center company then it is a must to forecast call volume. Sometimes it becomes difficult to calculate due ...

How to Explode a Pie Chart in Excel – 2 Methods

  This is the sample dataset. This is the corresponding pie chart: Method 1 - Exploding a Pie Chart Using the Mouse ...

How to Calculate Dividend Per Share in Excel (with 3 Easy Examples)

For every small or large business, if it has shares then it’s a mandatory task to calculate the Dividend Per Share. In Excel, we can do it easily ...

How to Remove Zero Data Labels in Excel Graph (3 Easy Ways)

We have the following dataset containing records of marks for 3 subjects of some students. Among the students, two of them got 0 in two different ...

How to Create Chart with Dynamic Date Range in Excel (2 Easy Ways)

You may have created Chart in Excel on the basis of some gathered data. But sometimes you may need to create a chart with a dynamic date range to ...

How to Create a Progress Chart in Excel – 2 Methods

The dataset showcases 5 students’ marks:   Method 1 - Using the Excel Charts Feature to Create a Progress Chart 1.1 Bar Chart ...

How to Create Graphs in Excel with Multiple Columns (5 Methods)

  Watch Video – Create Graphs in Excel with Multiple Columns Method 1 - Create 2-D Graph with Multiple Columns in Excel ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo