Latest Blog Posts

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

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo