Excel Formulas

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

How to Perform Calculus in Excel? (Differentiation and Integration)

Calculus is an important part of mathematics. We may have to perform several calculus operations for practical analysis. Even though there are no ...

How to Check, Highlight & Return Value If Cell Contains Text?

In this Excel tutorial, we will cover all the scenarios we need to know if a cell contains text in Excel. We will discuss 13 different scenarios ...

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

Convert Number to Time in Excel (All Things to Know)

This context will cover many essential topics on converting numbers to time in Excel. We will walk you through applying format cells and using ...

How to Link Sheets in Excel? (Same and Different Workbooks)

In this Excel tutorial, you will learn various essential techniques to link sheets in Excel. You will learn to link sheets within a workbook using ...

Zip Code in Excel (Insert, Display, Format & Remove)

In this article, you will learn the process of formatting zip codes in Excel. This includes the application of ready-made postal code formats or the ...

How to Pad Zeros in Excel? (Complete Guideline)

In this Excel tutorial, you will learn how to pad zeros in Excel. We will use different Excel functions (TEXT, TEXTJOIN, CONCATENATE, REPT, BASE, and ...

How to Remove Comma in Excel

The comma makes texts and numbers easier to read by acting as a separator. But when importing data from other file types, Excel might change decimal ...

How to Find, Count & Fill Missing Values in Excel?

In this Excel tutorial, you will learn how to - Use several built-in Excel functions to find missing values. - Compare two lists for missing ...

Excel Date Range (Learn and Apply)

Want to know about a date range in Excel? Then, this is the right place for you. In this article, you will find ways to create date ranges, different ...

How to Convert to Date in Excel (3 Common Cases)

In this Excel tutorial, you will learn - How to convert any type of data to date in Excel - Convert text date to Date Format using ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo