Latest Blog Posts

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

How to Insert Border in Excel (3 Effective Methods)

Inserting borders in Excel refers to the process of adding lines or boundaries around cells, ranges, or tables to enhance the visual appearance of ...

How to Create a Cash Flow Projection Template in Excel

Step 1 - Record Time Intervals Enter the first time period at the top of the template. Use the Autofill Tool and drag to fill in the ...

How to Multiply Time by Money in Excel (with Easy Steps)

The managers in a company often find it difficult to multiply time by the rate of money to get the total daily payment. This can be easily done in ...

How to Hide Extra Columns in Excel – 4 Methods

This is the sample dataset. Method 1 - Utilizing Keyboard Shortcuts to Hide Extra Columns in Excel YStep 1: Select an entire column after ...

How to Add Paper Size in Excel (4 Easy Ways)

We'll use the following dataset which contains a Sales Overview. Method 1 - Using the Page Layout Tab to Add a Paper Size in Excel Steps: ...

How to Reduce Excel File Size with Pictures (2 Easy Ways)

To reduce file size and improve performance, it's always recommended to compress images in Excel files. Here are 2 methods to do so. Method 1 ...

How to Calculate Present Value of Future Cash Flows: 4 Methods

Method 1 - Use of PV Function to Calculate Present Value of Future Cash Flows Steps: Select a different cell, D6, where you want to calculate ...

How to Repeat Cell Values in Excel (6 Quick Methods)

Method 1 - Copy Cell Values and Paste Directly Steps: Right-click on the cell to open the context menu and select Copy. Select the ...

How to Repeat Rows While Printing in Excel- 3 Methods

Consider a dataset of 100 students’ marks in 3 subjects. To print it and display the header row on each page:   Method 1 - Using ...

How to Calculate Net Cash Flow in Excel (3 Suitable Examples)

Looking for ways to know how to calculate net cash flow in Excel? Sometimes, we have to calculate net cash flow of a company for a specific period. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo