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 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 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 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 Use Nested IF and SUM Formula in Excel (2 Easy Methods)

Introduction to Nested Formulas in Excel Nesting simply implies combining functions such that one function controls the outcome of another. Here's ...

How to Calculate Margin of Error in Excel (7 Effective Ways)

We will be using two datasets for illustration. Method 1 - Calculate Margin of Error with Standard Deviation Steps: Select a cell for average. ...

How to Illustrate the Aging Formula in Excel using the IF Function (4 Methods)

Method 1 - Using a Nested IF Formula We’ll work with a dataset containing names and ages. Our goal is to determine the appropriate team for each ...

How to Insert Timestamp in Excel When Cell Changes (2 Effective Ways)

  Method 1 - Use IF, AND, NOW, and Other Functions to Insert Timestamp in Excel Steps Press Alt F T to open Excel Options. Go to the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo