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

Excel Scoring Formula (System, Text, Grade, Z Score)

In this article, you will learn how to create a scoring formula in Excel. This includes the scoring system, scoring based on text, calculating grades ...

Excel Sales Formula: All You Need to Know

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

Excel If Time Between Range (4 Quick Ways)

In this Excel tutorial, I will show you 4 different ways to check in Excel if time is between range. Nested IF, IFS, VLOOKUP, and XLOOKUP are some ...

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 Cases)

BMI is an important term to assess an individual’s body fat based on height and weight. It can be used to screen people who are underweight, ...

Leave Calculation Formula in Excel (5 Types of Leave)

The Leave Calculation Formula in Excel is essential for accurately calculating and tracking employee leave balances. In ...

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

In this Excel tutorial, we will learn about the ageing formula in Excel. We will use these formulas to: - Calculate age in years, months, and/or ...

How to Count Number of Columns in Excel?

We may need to count the number of columns in a selection in Excel for a range of purposes including data validation, manipulation, management, ...

How to Calculate Discount in Excel (2 Easy Methods)

Discount is a term used in a pricing system that merges with the selling price to boost sales. This discount calculation system is used worldwide in ...

How to Use INDEX and MATCH Functions in Excel (14 Suitable Examples)

Using the combination of the INDEX and MATCH functions in Excel means using these two functions together as a powerful combination for looking up and ...

How to Count Rows with Formula in Excel?

In this tutorial, I will explain some methods to count the number of rows using Excel Formula.  Usually, we can get the row count by simply clicking ...

Timesheet Formula in Excel (5 Examples)

To calculate the time difference (e.g. work hours) between two time periods, we create a timesheet. There are several ways that we can use to keep ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo