Latest Blog Posts

Excel VBA: Wait Until a Process Completes

VBA provides us with a built-in method called Wait. We’ll use this method to wait until the process completes. The problem is the method Wait takes a ...

Automatically Update a Pivot Table When Source Data Changes in Excel

We've included a data set with information on sales details in various regions in the image below. We need an automated process to update data in a ...

How to Insert Sign in Excel Formula (Arithmetic, Logical and Misc.)

Excel keeps track of data and calculates to manipulate this data. In calculations, Excel uses various formulas and these formulas include different ...

How to Count Words in Excel Column (5 Useful Ways)

Let’s consider a dataset with 2 columns, where the first column shows the Product ID and the second column shows a list of Best Seller Books. We’ll ...

How to Calculate Cost per Unit in Excel (With Easy Steps)

What Is Cost per Unit? The cost per unit includes all costs associated with production, delivery, marketing, sales, warehousing, management, etc. ...

How to Use IF Formula for Aging Buckets in Excel (3 Suitable Examples)

  Method 1 - Aging Buckets for Overdue Days We are going to use the following dataset. It consists of different reports with the dates issued ...

How to Use Stock Ageing Analysis Formula in Excel (2 Easy Ways)

Sometimes we need to identify the ages of our stock products. Excel has several functions by which we can estimate the age of our stocks. In this ...

How to Do Aging Analysis in Excel (with Quick Steps)

Step 1 - Create the Dataset In the following image, you can see the basic dataset of the Aging Analysis report. We have Customer names, ...

Convert Formula to Value Without Paste Special in Excel (5 Easy Methods)

Excel has an inbuilt data display orientation to indicate entries such as Numbers or Text. On occasions, we need to convert formulas to values ...

How to Calculate a Distance in Excel Using Google Maps

  Method 1 – Using a User-Defined Function Here, we’ll find the distance between the cities of Las Vegas and Philadelphia using Google Maps. ...

How to Calculate Coordinates from Bearing and Distance in Excel

What Are Coordinates (Northing and Easting)? The geographic Cartesian Coordinates of a point on earth are referred to as Easting (the x value), and ...

Types of Data Entry in Excel (A Quick Overview)

Microsoft Excel is one of the leading data organizing and analyzing programs. But to analyze data in Excel, you need to input data first. Data can be ...

How to Calculate Coupon Rate in Excel (3 Ideal Examples)

What Is a Coupon Rate? The coupon rate is the rate of interest that is paid on the bond’s face value by the issuer. The coupon rate is calculated by ...

How to Create a Map in Excel (2 Easy Methods)

    Method 1 - Utilizing a Filled Map Chart to Create a Map in Excel Example 1 - Creating a Map of Countries Here's a dataset of ...

How to Calculate Distance Between Two Addresses in Excel (3 Ways)

Here is an overview of how the distance between two addresses can be found in Excel. How to Calculate the Distance Between Two Addresses ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo