Latest Blog Posts

How to Calculate Present Value of Uneven Cash Flows in Excel: 3 Methods

Method 1 - Using Generic Formula to Calculate Present Value of Uneven Cash Flows in Excel Use a generic formula to calculate the present value of ...

How to Show Print Area in Excel: 4 Easy Methods

Method 1 - Using File Tab Option Steps: Select the whole data table. Go to the File tab option. Select the Print option. Go to ...

How to Apply All Borders in Excel (3 Methods)

The All Borders option is a formatting feature that allows you to apply a border around the entire selected range of cells. This means that a border ...

How to Calculate Future Value of Uneven Cash Flows in Excel

  What Is the Future Value of Uneven Cash Flows? Future Value is the total amount of the Present Value and Total Interest. To calculate the ...

How to Create Column Headers in Excel: 3 Methods

Method 1 - Creating Column Headers by Freezing a Row Steps: Click the View tab. Choose the frame right inside the row and column to ...

How to Make a Sales Comparison Chart in Excel – 4 Methods

Method 1 - Using the INDEX Function to Create a Sales Comparison Chart in Excel The following dataset showcases Monthly Sales of a Company. To ...

How to Change Page Number in Excel (With Easy Steps)

Download the Practice Workbook Change Page Number.xlsx 2 Easy Steps to Change the Page Number in Excel We have a dataset of some Product ...

How to Exclude Zero Values with Formula in Excel (3 Easy Ways)

Method 1 - Use Formula with IF Function to Exclude Zero Values in Excel Let’s say, we have a dataset displayed in the (B4:D8) cells. Here, the ...

How to Put Comma After 2 Digits in Excel (9 Quick Methods)

We will use a sample dataset of products and their quantities. Method 1 - Applying LEFT and MID Functions to Put a Comma After 2 Digits in ...

How to Add Markers for Each Month in Excel (With Easy Steps)

Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. Using various charts and graphs, you ...

How to Change Column Headings in Excel (2 Ways)

Here's a sample dataset containing PC parts, prices, and available quantities. We'll change the column headings in the file from letters to numbers. ...

How to Compare Two Sets of Data in an Excel Chart – 5 Examples

  The sample dataset showcases Name of Company, Branch Location, Sales, and Cost.   Example 1 - Using a 2-D Column Chart ...

How to Print a Full Page of an Excel Sheet in A4 Size (5 Methods)

Dataset Overview We’ll be working with a dataset containing employee information, including columns for Employee ID, Name, Gender, Department, and ...

[Solved:] Print Area Is Grayed Out in Excel (2 Easy Solutions)

Excel is the most useful tool to deal with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. While working in Excel, ...

Unhide Columns Is Not Working in Excel (4 Issues & Solutions)

In many cases, you might find that the unhide columns option is not working in Excel. Sometimes, the solutions to this problem are very easy but hard ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo