Excel Formulas

How to Calculate Mileage in Excel (Step-by-Step Guide)

Throughout this article, we’re going to use the dataset shown below. The dataset consists of a mileage log with the Date of the journey, the Distance ...

How to Calculate Volume in Excel (7 Different Ways)

Method 1 - Volume Calculation of a Sphere Volume of a Sphere = 4/3 * pi * r^3 Steps: We only need to know the radius of the sphere. ...

How to Calculate Euclidean Distance in Excel (2 Effective Methods)

The Euclidean distance is calculated for two vector points on a plane. However, the Euclidean distance is the distance between two locations in ...

How to Calculate MPG in Excel – 5 Steps

The dataset below showcases a Milage Log of 10 days in May 2022. Column B contains the Date, column C includes Odometer Readings, column D ...

How to Calculate Average Sales in Excel (5 Simple Approaches)

Average estimation is a very common factor in our everyday life. In the business section, it is an important factor to summarize the production or ...

How to Calculate the Distance Between Two Cities in Excel (5 Methods)

Dataset Overview To calculate the distance between two cities, we’ll start by preparing the dataset. Let’s consider two cities: Los Angeles (a major ...

How to Calculate Percentage Variance Between Two Numbers in Excel

The following dataset illustrates how to calculate the percentage variance between values in the Estimated Revenue and Actual Revenue columns. The ...

How to Calculate Age Between Two Dates in Excel (6 Methods)

To calculate the age between two dates, we have made a dataset based on the Date of Birth of employees of a company and the Current Date. ...

How to Use the IF Function for Discounts in Excel (4 Examples)

Dataset Overview In the dataset, we have prices of various products as well as a conditional discount percentage. Example 1 - Discount ...

How to Calculate Pooled Variance in Excel (with Easy Steps)

In this article, we will demonstrate how to calculate Pooled Variance in Excel. What Is Pooled Variance? Pooled Variance is a statistical ...

How to Filter Dates by Month and Year in Excel (4 Easy Methods)

Method 1 - Use Filter Command Steps: Select the column where you want to apply the filter. Go to the top ribbon and select the Sort & ...

How to Insert Excel Timestamp When Cell Changes Without VBA (3 Ways)

A timestamp is a record of the time and date of a particular event or task. In this article, we will learn to insert an Excel timestamp when a cell ...

How to Calculate Average Price in Excel (7 Useful Methods)

We need to calculate the average price in various business sectors or normal life frequently. Excel has made it easy to calculate the average price. ...

How to Calculate the Critical Z Score in Excel – 3 Examples

  This is the sample dataset. Example 1 - Calculating the Critical Z Score for a Right-Tailed Test Steps: Insert a column to ...

How to Calculate Negative Margin in Excel (4 Easy Methods)

If you want to calculate negative margin in Excel, this article is for you. Here, we will walk you through 4 easy and effective methods to do the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo