Latest Blog Posts

How to Clear Print Area in Excel (2 Easy Ways)

A print area is a set of cells that will be printed out in full. Set a print area to only contain your selection if you don't want to print the ...

How to Make a Title in Excel (3 Suitable Methods)

Suppose we have a dataset containing some months and the temperature in degrees in two locations. The dataset has no titles. Let's add some. ...

How to Repeat the Formula in Each Row in Excel -7 Easy Methods

This is the sample dataset.   Method 1 - Dragging the Fill Handle Icon Steps: Select E5. Enter the following formula. ...

Debt to Income Ratio Calculator in Excel (Create with Easy Steps)

This article illustrates how to make a debt to income (DTI) ratio calculator in Excel. Lenders use the debt-to-income ratio to determine whether a ...

How to Plot a Particle Size Distribution (PSD) Curve in Excel

Step 1 - Data Preparation Gather your data, which typically includes the sieve number, particle size (in millimeters), and mass retained (in ...

How to Hide Gridlines in Excel When Printing (4 Quick Tricks)

In this tutorial, I am going to show you 4 quick tricks on how to hide gridlines in Excel when printing a worksheet. Although Excel hides the ...

How to Convert XML to XLSX Without Opening File

This tutorial will demonstrate how to convert XML to XLSX without opening the file. XML is a markup language. It is mainly used for giving ...

Excel VBA: Show Userform in Full Screen (4 Easy Ways)

In this article, we discuss how to display a Userform in full screen in Excel using VBA in four different ways. We'll use the dataset below to ...

How to Change Orientation of Text to 22 Degrees in Excel (3 Ways)

While working with Microsoft Excel, sometimes we have to change the orientation of some data. We may need to arrange the texts in the most accessible ...

How to Calculate Annual Debt Service in Excel (3 Ideal Examples)

In Microsoft Excel, users can perform various operations and find the value of different quantities. Today, we will learn to calculate annual debt ...

How to Add Same Header to All Sheets in Excel (5 Easy Methods)

Method 1 - Using the Page Setup Option to Add Same Header to All Sheets in Excel Select Page Setup sheet >> right-click on it. From the ...

How to Remove Quick Access Toolbar in Excel (4 Easy Ways)

The Quick Access Toolbar is a small customizable icon on the worksheet's upper-left side. It contains several commonly used commands. Removing the ...

How to Add a Comma Between City and State in Excel (6 Ways)

We like decorating our things, even in case of a dataset. Adding comma between city and state will help us to differentiate those two quite easily. ...

How to Hide Source Data in an Excel Pivot Table (With Easy Steps)

We have a dataset containing the company’s customer information about payment methods and amounts. We will create a pivot table from this dataset and ...

How to Open XML File in Excel for Income Tax (2 Easy Ways)

XML or "Extensible Markup Language" is a file format, which is mainly used for storing and transferring data. Microsoft Excel supports this file ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo