Latest Blog Posts

How to Calculate Discount Factor in Excel (6 Common Ways)

For economics and business purposes, it is very frequently needed to calculate the time value of money. The discount factor is one of the most ...

How to Calculate Total Sales in Excel – 3 Easy Steps

Step 1- Create a List of Products in Excel Create a new worksheet and enter the product list, the product code and its price. Select ...

How to Create a Skewed Bell Curve in Excel (With Easy Steps)

For illustration, we will use the following dataset to create a bell curve to compare the results. Step 1 - Generate a Summary Statistics ...

How to Calculate Age in Excel in Years and Months (5 Ways)

We have the following dataset containing some workers' names and dates of Birth (DOB). We will show some step-by-step methods to calculate their age ...

How to Use Ageing Formula in Excel Excluding Weekends (4 Methods)

Dataset Overview In Microsoft Excel, we often need to determine the age or duration of various items. Additionally, there are cases where we want to ...

How to Calculate Price Per Pound in Excel (3 Easy Ways)

We have the amounts of some products, their prices, and their amounts in lbs. We will calculate the price per pound (lb). Method 1 - ...

How to Refresh Excel Sheet Automatically (3 Suitable Methods)

Method 1 - Apply a Keyboard Shortcut to Refresh a Sheet Automatically We have a dataset of some random numbers in a workbook. We have applied ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo