Latest Blog Posts

How to Add Data Labels in Excel: 2 Handy Methods

Method 1 - Inserting Chart Elements Command to Add Data Labels in Excel Step 1: Select your entire data set to create a chart or graph. The ...

How to Create a Number Sequence in Excel Without Dragging

Dragging is a quick and easy way to create a number sequence in Excel. But there are scenarios where you might want to create one without dragging ...

How to Create Column Sparklines in Excel (5 Suitable Examples)

In our everyday use of Microsoft Excel, it is important to visualize data. Sometimes it is enough to follow and measure the trend instead of going ...

How to Make a Doughnut Chart in Excel: 2 Suitable Methods

Method 1 - Making a Doughnut Chart in Excel with Single Data Series Step-01: Inserting Doughnut Chart Select the dataset that you want to ...

How to Add Trendline Equation in Excel (With Easy Steps)

A Trendline is a popular way to make predictions in Excel. Often, we need to find the Trendline equation to see the slope and the constant. Excel has ...

How to Find the Equation of a Trendline in Excel (3 Methods)

  Method 1 - Single Trendline Steps Choose your dataset using the mouse. Go to the Insert tab and select Scatter from the Insert ...

How to Group Checkboxes in Excel (3 Easy Ways)

Looking for ways to know how to group checkboxes in Excel? Usually, we use checkboxes to select or unselect an option in Excel. Here, you will find ...

Auto Generate Serial Number in Excel VBA (4 Ways)

The sample dataset Customer Credentials, into which serial numbers are to be inserted adjacent to those entries.   Method 1 - Using ...

How to Show Percentage and Value in Excel Pie Chart

To demonstrate how to show Percentage and Value in an Excel Pie Chart, we'll use the following sample dataset: Step 1 - Selecting the ...

How to Add Bullet Points to an Excel Text Box – 4 Methods

You have a list of four tasks. To add bullet points inside the text box: Method 1 - Add Bullet Points in Excel Text Box from Right-Click ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo