Formula List in Excel

Excel Area and Volume Formulas

In Excel, you can use the area and volume formulas very effectively. Area and volume formulas are used mostly in ...

Distance Formula in Excel (4 Examples to Calculate)

In this article, we will learn how to find distance using formulas in Excel. We will apply the basic arithmetic formula, the Euclidean formula, the ...

How to Calculate BMI with Formula in Excel: 3 Methods

Method 1 - Calculate BMI in Metric Unit Select cell E5 and type the following formula: =D5/C5^2 D5 is the weight, and C5 is a person's height. ...

Leave Calculation Formula in Excel (5 Leave Types)

Say you have a dataset containing working hours and leave types of an employee. You want to calculate half-day, casual, and ...

Excel Attendance Formula

Excel Attendance Formula: Knowledge Hub Track Attendance in Excel Calculate Attendance Percentage in Excel Make Daily Attendance Sheet ...

Partial Match Excel

Excel is a powerful tool for data analysis and manipulation, and mastering partial matches in Excel can greatly enhance your ability to work with ...

How to Lookup in Excel (12 Examples)

While using Microsoft Excel, you may frequently need to lookup data for different scenarios and find the matched values. Microsoft Excel offers some ...

Excel Copy Cell Value

Excel Copy Cell Value: Knowledge Hub Excel Formula to Copy Cell Value from Another Sheet Automatically Copy Data from One Cell to Another ...

Excel Overtime Formula

Excel Overtime Formula: Knowledge Hub Calculate Hours Worked and Overtime Using Excel Formula Excel Formula for Overtime over 8 Hours ...

Ageing Formula in Excel (All Things You Need to Know)

Download Practice Workbook Ageing Formula.xlsx Method 1 - Calculate Age in Years We can use the combination of several functions ...

How to Count Number of Columns in Excel: 5 Methods

Method 1 - Using Status Bar to Count Number of Columns in Excel Select the headers of the chart or dataset (or a particular row, which doesn’t ...

How to Use Formula for Tracking Weight Loss in Excel (2 Examples)

It is very necessary to track weight loss to keep fit and also not become sick. In Microsoft Excel, you can easily keep track of your weight loss and ...

How to Calculate Discount in Excel (2 Easy Methods)

  Method 1 - Creating an Excel Formula to Calculate a Discount Price Suppose we have a dataset of a Mobile selling shop with their product ...

How to Use the INDEX and the MATCH Functions in Excel – 14 Examples

This is an overview.   The INDEX and the MATCH Functions in Excel The INDEX function returns a value or a reference to a ...

How to Count Rows with a Formula in Excel (5 Methods)

  Method 1 - Using the ROWS Function to Count Rows in Excel Steps: Enter the below formula in Cell D12: =ROWS(B5:D10) Here, ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo