Excel Formulas

How to Subtract Military Time in Excel: 3 Suitable Ways

Method 1 - Apply Subtraction for Subtracting Military Time in Excel Step 1: Select cell E5 to subtract military time. Use the ...

How to Compare Two Columns to find Missing Values in Excel – 4 Methods

The sample dataset showcases Employee Name and Attended Office. Find the names of employees who didn't attend the office.   Method ...

How to Calculate Percentage Based on Conditional Formatting: 6 Methods

Method 1 - Calculate Percentages Based on Conditional Formatting Manually Steps: Put down the name of the background colors of the cells of ...

How to Calculate Average of Text in Excel (2 Ways)

Method 1 - Using SUM and COUNTIF Functions to Calculate Average of Text in Excel To calculate the average number of text, we have to first count the ...

How to Subtract Date and Time in Excel – 6 Methods

The datasheet contains start and end time. To calculate the duration of each project:   Method 1 - Getting Days, Hours, and Minutes ...

How to Calculate Percentage Change with Negative Numbers in Excel

Theoretically and even practically, it is not possible to find the percentage change for negative numbers. There are different formulas that can be ...

Calculate Elapsed Time Between Two Dates in Excel (5 Methods)

Dates and Times in Excel are considered integer and fractional numbers respectively. We can calculate the elapsed time between two dates in Excel. ...

How to Calculate Total Hours Worked in a Week in Excel (Top 5 Methods)

The following sample dataset will be used for illustration. Method 1 - Calculate the Total Hours Worked in a Week Using the Basic Method ...

How to Calculate the Percentage Increase from Zero in Excel – 4 Methods

Percentage Increase The formula to calculate percentage change is: Change(%)=(Final Value-Initial Value)/Initial Value*100 Mathematically ...

How to Calculate Average Percentage Increase for Marks in Excel Formula

Today we will discuss another important topic on how to calculate the average percentage increase for marks in Excel formula. Here, we took an Excel ...

How to Calculate Elapsed Time in Excel (5 Ways)

Method 1 - Calculate Elapsed Time in Excel by Subtracting Two Date Values In this example, we’re going to calculate the elapsed time of World War 2. ...

How to Calculate the Moving Average in a Dynamic Range in Excel – 3 Examples

What is the Moving Average? The Moving Average is the change in the average of a data series overtime. If you need to provide the moving average ...

Link Excel Workbooks for Automatic Update (5 Methods)

Method 1 - Use Paste Special to Automatically Update Workbook We will link Report-1.xlsx and Report-2.xlsx to the Link Excel Workbooks.xlsx file. ...

How to Remove a Formula in Excel and Keep Values (5 Ways)

We've shown a data set for calculating the yearly change in revenue percentage (%) in the screenshot below, but we do not wish to reveal the ...

How to Add 20 Percent to a Price in Excel – 2 Methods

The following dataset showcases clothes items’ prices. Method 1 - Using a Formula to Add 20 Percent to a Price in Excel A new column, ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo