Latest Blog Posts

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

How to Create a Debtors Ageing Report in Excel Format

Debtors Ageing is a tool by which business companies or financial institutions track the status of their accounts receivable. This is usually ...

Excel Formula to Return Zero If Negative Value is Found

Suppose we have a dataset of the amounts of two items and the Differences between them. There are some negative numeric values. Let's change each ...

Automation of Bank Reconciliation with Excel Macros: 3 Quick Steps

Method  1 - Create Dataset with Proper Parameters Our dataset contains information about several Transactions, including the Cheque Book Number, ...

How to Do Data Mapping in Excel (5 Handy Ways)

  Method 1 - Inserting VLOOKUP Function to Do Data Mapping in Excel Let’s assume a dataset with the Sales Quantity for three different models ...

How to Show Negative Numbers in Excel (5 Ways)

Method 1 - Using Parenthesis STEPS: Select the data range containing negative numbers. Click on the Number Format icon in the Number group. ...

How to Make Solid Grid Lines in Excel (2 Easy Ways)

The color of default grid lines is faded and not continuous. So, it doesn’t get feasible in some particular cases while using Excel. But no worries, ...

How to Calculate the Operating Cash Flow in Excel – 2 Methods

Method 1 - Using Direct Method to Calculate Operating Cash Flow in Excel The generic formula is: Operating Cash Flow = Cash Inflows - Cash Outflows ...

How to Move Negative Sign at End to Left of a Number in Excel

We have a column of random numbers as shown in the image below. We want to fix the negative signs’ positions in the entries. 3 Easy ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo