Latest Blog Posts

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

How to Set Character Limit in Excel

If you work with Microsoft Excel, you may be familiar with the character limit. The character limit is the maximum number of characters that can be ...

How to Include Standard Deviation in Excel Radar Chart

While working with Microsoft Excel, when we want to display demographic or regional capacity information, we may use the Radar Chart. This represents ...

How to Remove Column Headers in Excel: 2 Easy Methods

Method 1 - Using Excel Options to Remove Column Headers Steps: Go to the Files tab from the Ribbon. See the following image on your ...

How to Reduce Excel File Size Without Opening (with Easy Steps)

Sometimes, the size of an Excel file can be significant if it contains a large amount of data. If your Excel file contains a large amount of data, it ...

How to Reconcile Vendor Statements in Excel (2 Easy Methods)

The following Vendor’s Details table has Invoice No., Date, and Amount columns. The Amount column shows the vendor’s demand for a particular invoice. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo