Excel Formulas

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

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. ...

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)

Calculating cost per unit is very important in every business and an Excel template will be very useful for you. You can call it a Product Costing ...

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)

If you are looking for some special tricks to do aging analysis in Excel, you've come to the right place. There is one way to do aging analysis in ...

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)

The article will show you how to calculate the distance between two addresses in Excel. Microsoft Excel has this cool special feature and formula for ...

How to Find Z Critical Value in Excel?

We carry out various operations in Excel. We can also perform many different mathematical and statistical tasks in the Excel workbook. In some cases, ...

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

How to Calculate Time Range in Excel (4 Handy Methods)

This article will show you how to calculate the time range in Excel with a variety of methods. You will find a few useful functions and formulas to ...

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

While investigating large datasets in Excel, you might be required to count the number of cells containing a specific name. This article provides 3 ...

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)

In this article, I will show you 7 simple and effective ways to calculate hours and minutes in Excel. In Excel, if you simply enter a number and want ...

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

Conversion of units is very common in any kind of calculation in mathematics, engineering, and other fields. This is because different unit standards ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo