Latest Blog Posts

How to Fix the Trendline Option Not Showing in Excel

In the below dataset there are Employee Names and their Total Sales volume. We will insert different charts and show you the reasons and solutions ...

How to Print Avery 8160 Labels in Excel – 2 Steps

Step 1 - Creating Avery 8160 Labels from Excel Using Microsoft Word Create a dataset. Here, the dataset contains Name, City, State and Zip. ...

How to Add A3 Paper Size in Excel (2 Quick Ways)

Download Practice Workbook Adding A3 Paper Size.xlsx Method 1 - Use Page Layout Tab to Add A3 Paper Size We have a sample dataset of ...

How to Print Labels in Excel Without Word (with Easy Steps)

The usual label printing process from Microsoft Excel involves mail merging spreadsheets with Microsoft Word. But some people prefer completing all ...

How to Make Doughnut Chart with Total in Middle in Excel

Method 1 - Create a Doughnut Chart Steps: Created a dataset with an institution’s average marks in different subjects. Categorize them into the ...

How to AutoFill in Excel with Repeated Sequential Numbers

In this article, we will demonstrate four simple approaches to Autofill a series of sequential numbers repeatedly in Excel. The dataset below has 3 ...

How to Filter Checkboxes in Excel (with Easy Steps)

In this article, we will demonstrate how to add checkboxes in Excel and then Filter them. Step 1 - Enable Developer Tab Before we delve into ...

How to Fix All Numbers Stored as Text in Excel – 6 Easy Methods

This is the sample dataset. Method 1 - Using the Flash Fill Feature Steps: Add a new column. Enter the three first numbers ...

How to Print Avery 5160 Labels from Excel (with Detailed Steps)

  Step 1 - Prepare Dataset Enter the Name, Address, and Column in the following dataset. In the Name column, enter each person’s name. ...

How to Make a Pareto Chart Using Pivot Tables in Excel

What Is a Pareto Chart? A Pareto chart combines columns sorted in descending order with a line representing cumulative total percentages. It’s a ...

How to Set Multiple Rows as Print Titles in Excel (4 Handy Ways)

Wouldn't it be great to have the Titles at the top of every page when printing in Excel? With this in mind, this article demonstrates how to set ...

How to Adjust Page Size for Printing in Excel (6 Quick Tricks)

A common problem when printing from Excel is that the page size or printing area does not look the way we want. This article will present 6 quick ...

How to Put a Title Across Cells in Excel (With Easy Steps)

While working in Microsoft Excel, we need to put a title across cells so that we can understand the dataset easily. Putting a title across cells in ...

Convert Number to Hours and Minutes in Excel (2 Easy Methods)

The following table has the Days and Number columns. We will use the Number column of this table to convert number to hours and minutes in Excel. ...

How to Convert Number to Text in Excel with Apostrophe

In this tutorial, we will demonstrate a quick but useful method to convert numbers to text format in Excel using the apostrophe. Furthermore, this ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo