Latest Blog Posts

How to Change Page Orientation in Excel (2 Simple Methods)

If you are looking for simple ways to change page orientation in Excel, this article will serve the purpose. Excel by default uses the Portrait ...

How to Insert Page Number in Excel (7 Easy Methods)

Method 1 - Using Page Layout View Style to Insert Page Number Steps: Go to the View tab and from the Workbook Views section, select Page ...

How to Convert Entire Column to Number in Excel (9 Methods)

Let's use the following dataset, which contains some Subject and Marks. The numbers are showing errors (or error suggestions) because the format is ...

How to Remove Gridlines from Table in Excel (2 Examples)

There may be some instances where you need to remove gridlines from tables. In Microsoft Excel, you can do this type of task within seconds. This ...

How to Add Text to an Excel Spreadsheet – 6 Methods

  This is the sample dataset. Method 1- Using the Ampersand Operator to Add Text in Excel 1.1 Using the Ampersand Operator to Add ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo