Latest Blog Posts

How to Convert 5 Digit Number to Time in Excel (4 Quick Tricks)

When you work in an Excel sheet, especially with long data series, it often happens that you may forget the format in which you want to insert your ...

How to Sort Multiple Headings in Excel – 2 Methods

The dataset showcases Product Sales data. It has multiple headings.   Method 1 - Enabling the Filter Feature to Sort ...

Keep Row Headings in Excel When Scrolling Without Freeze (2 Ways)

We have selected a dataset with four columns detailing the Product, Brand, Model, and Price. The dataset has 24 rows of data. When scrolling down, ...

Subtotal Formula in Excel for Serial Number: 3 Suitable Methods

Method 1 - Use of SUBTOTAL Function for Serial Number Steps: Select Cell B5 and type the formula below. =SUBTOTAL(3,$C$5:C5) ...

How to Convert Fraction into Hours and Minutes in Excel (3 Ways)

In this article, we'll learn how to convert a fraction into hours, and minutes in Excel effectively with appropriate illustrations. While working ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo