Formula List in Excel

Calculate Salary in Excel

Calculate Salary in Excel: Knowledge Hub Calculate Basic Salary in Excel Calculate Gross Salary in Excel Calculate Net Salary in Excel ...

How to Create a Scoring Formula in Excel (System, Text, Grade, Z Score)

Scoring formulas in Excel are valuable for ranking and evaluating datasets. They allow us to calculate scores efficiently, consider weights, rewards, ...

Excel Sales Formula: All You Need to Know

In this article, we will explore several important Excel Sales formulas that can greatly improve your sales analysis and help you to find valuable ...

Excel If Time Between Range (4 Quick Ways)

Finding out if time is between range is used to make decisions for attendance tracking, event scheduling, project monitoring tasks, employee shift ...

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

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

How to Timesheet Formula in Excel: 5 Methods

Method 1 - Excel Timesheet Formula: Using Simple Subtraction Apply the simple arithmetic subtraction formula within this Excel timesheet. To do ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo