Latest Blog Posts

How to Rotate Data Labels in Excel (2 Simple Methods)

While working in Microsoft Excel you might need to show your data in different directions for better visualization. You can change the direction of ...

Excel Gantt Chart with Conditional Formatting (2 Examples)

Example 1 - Creating Simple Gantt Chart with Conditional Formatting Steps: Enter the dates 1 July-15 July in the range of cells E4:S4. ...

How to Link Multiple Checkboxes in Excel (3 Easy Methods)

  Method 1 - Using a Formula with a Cell Reference We have to prepare a dataset containing different tasks as shown below. Steps: ...

How to Calculate Interest Rate from EMI in Excel (with Easy Steps)

We'll use the RATE function: =RATE(nper, pmt, pv,, , ) Nper(required): total payment periods number (years, months) Pmt (required): the ...

How to Add Numbers 1 2 3 in Excel: 8 Suitable Methods

Method 1 - Use Excel Fill Handle Tool to Add Numbers 1 2 3 Steps: Insert 1 in cell B5 and 2 in cell B6. This initiates a pattern; the Fill ...

Excel Bubble Chart Size Based on Value (2 Suitable Examples)

The following table contains the Product, Cost Price, Selling Price, and Profit columns. We will create an Excel Bubble chart and adjust the bubble ...

How to Create Excel Radar Chart with Different Scales: 2 Methods

Method 1 - Using Insert Charts Feature to Plot Excel Radar Chart with Different Scales Steps: Select the cell range B4:D9. From the Insert ...

How to Use Pivot Chart in Excel (5 Different Uses)

A Pivot Chart is the visual representation of our raw data. Using a Pivot Chart is one of the best ways to present your data in Excel. It allows us ...

How to Create a 3D Pie Chart in Excel (with Easy Steps)

The 3D pie chart consists of a circle that is divided into segments, each representing a proportion of the share of each value in a dataset. The ...

How to Move Data Labels In Excel Chart (2 Easy Methods)

Excel is often used to make charts and graphs that show how data looks. We often put labels on charts to help us understand them better. Also we try ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo