Excel Formulas

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

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

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

How to Find Z Critical Value in Excel?

in this article, we’ll demonstrate 3 different examples of finding the Z Critical Value in Excel. The Z Critical Value plays a significant role in a ...

How to Calculate the Retirement Age in Excel – 4 Quick Methods

The dataset showcases Names, Date of Birth, and Date of Retirement. Method 1 - Using the DATEDIF Function to Calculate the Retirement Age ...

How to Calculate Time Range in Excel (4 Methods)

Below is an Employee Time Sheet dataset containing the "In Time" and "Out Time" of 10 employees for a certain day. Method 1 - Calculating ...

How to Count Specific Names in Excel (3 Useful Methods)

Let’s say we have a dataset that depicts the employee ID, the Year, and the Sales Person of the Year. We’ll use the dataset (in B4:D14 cells) shown ...

How to Calculate P Value from Z Score in Excel: 4 Methods

Method 1 - Calculate Mean of Dataset Select cell C13. Insert the following formula into the cell. =AVERAGE(C5:C11) Press ...

How to Group Age Range in Excel with VLOOKUP (with Quick Steps)

Suppose you have a dataset of 9 persons of different ages and want to put them inside particular age groups. Step 1 - Create a List of Age Ranges ...

How to Calculate Hours and Minutes in Excel (7 Handy Ways)

We have a dataset of an employee’s entry time and exit time to the office throughout the week. We need to calculate how much time they worked each ...

How to Convert Inches to Cm in Excel (2 Quick Ways)

We have a dataset of measurements of a box in 3 dimensions. We will convert them from inches to centimeters. Method 1 - Multiply by the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo