Latest Blog Posts

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

How to Prepare a Daily Cash Flow Statement Format in Excel – 9 Steps

Step 1 - Create a Header and Input Company Information Create a header for the cash flow statement. Add an input section for company ...

How to Repeat Formula in Excel for Whole Column (5 Easy Ways)

Sometimes, we apply a formula in a cell and then repeat the same formula to the entire column in Microsoft Excel. However repeating the same formula ...

How to Show Full Screen with No Title Bar in Excel (3 Easy Ways)

While working with a large dataset, you need to show the Excel in full screen with no title bar. In Microsoft Excel, you can do this quite easily and ...

How to Ignore Blank Cells with Formulas in Excel Chart

Sometimes we have some blank cells in our dataset. When we plot them in an Excel chart, we can’t get the desired chart for these blank cells. In that ...

How to Create Pay off Credit Card Debt Calculator in Excel

Pay off credit debt calculator is an essential staff for any person to check the amount of loan on his/her credit card. Using Microsoft Excel, you ...

How to Create Table of Contents Automatically in Excel: 4 Creative Methods

Method 1 - Utilizing Keyboard Shortcut to Create Table of Contents Steps: Type in the name of the worksheet. In this case, the name of our ...

How to Put a Negative Number in Excel Formula (4 Easy Methods)

We’ll use a sample dataset with random numbers in one column and will then convert them to negative numbers in the other one by applying negative ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo