Latest Blog Posts

How to Calculate the Average Salary in Excel – 6 Methods

The sample dataset showcases 10 employees and their monthly salaries. To calculate the average salaries: Method 1 - Use the ...

The Excel Bullets and Numbering Feature is Grayed Out – Reason and Solution

The Bullets and Numbering feature is not usually available on the Ribbon. To enable it: Right-click the Home tab and select Customize the ...

How to Create Dynamic Excel Charts with Drop-Down List (3 Ways)

When you are working with a dataset that needs to plot on a chart, you will try to create dynamic Excel charts with a drop-down list. A dynamic chart ...

How to Change Text Direction in Excel Chart (3 Easy Methods)

While working in Microsoft Excel with the sales-related worksheets, sometimes we need to change the text direction in an Excel chart. The chart shows ...

How to Create a Number Sequence in Excel Based on Criteria

  To demonstrate our methods, we have selected a dataset with 3 columns consisting of “Product,” “Brand,” and “Sequence.” The sequences will be ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo