Excel Formulas

How to Calculate Altman Z Score in Excel (3 Suitable Examples)

If you are looking for some special tricks to calculate the Altman Z score in Excel, you've come to the right place. There are numerous ways to ...

How to Calculate BMI Z Score in Excel (with Quick Steps)

In statistics, the Z Score denotes a value's position or rank in the dataset relative to the mean. Calculating that dataset’s BMI and Z Score of that ...

How to Calculate Mahalanobis Distance in Excel (Step by Step)

Excel users who deal with Statistical data often calculate various properties regarding Statistics. So, users sometimes need to calculate Mahalanobis ...

How to Calculate Probability from Z-Score in Excel (with Quick Steps)

Z-Score is a parameter using which we can calculate the value of probability. Excel contains some formulas by which we can easily estimate the value ...

How to Calculate Retail Price in Excel (2 Suitable Ways)

This article illustrates how to calculate the retail price in Excel. Markup and Margin are two basic elements in sales when determining the retail ...

How to Calculate Projected Sales in Excel (2 Easy Ways)

In statistical analysis, we frequently need to predict results in order to plan ahead of time. Excel has some analytical functions and features for ...

How to Calculate Age in Excel in dd/mm/yyyy (2 Easy Ways)

It is one of the most frequent needs for us to calculate someone’s age for various purposes. We can use Excel in this regard very easily and quickly. ...

How to Find Critical Value in Excel?

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. In ...

How to Calculate Miles between Two Addresses in Excel (2 Methods)

Excel has a wide range of applications. It has a lot of practical uses, like if you want to find the distance between two addresses or multiple ...

How to Calculate Average Age in Excel (Including Criteria)

This article illustrates how to calculate the average age in Excel. The average age of a group of people can be easily calculated by adding their age ...

How to Calculate Levenshtein Distance in Excel (4 Easy Methods)

In this article, we will show you 4 methods of how to calculate Levenshtein distance in Excel. To demonstrate our methods, we have selected a dataset ...

How to Convert Feet to Meters in Excel (4 Simple Methods)

In Excel calculations, users often need unit conversions to fit their data depending on their customers. Therefore, users trying to convert feet to ...

How to Convert Decimal Feet to Feet and Inches in Excel (4 Handy Methods)

Unit conversion is a common task in our day-to-day lives. In countless situations, you may need to convert decimal feet to feet inches, and this is ...

How to Convert Meters to Feet in Excel (4 Useful Methods)

If you want to convert meter to feet or meter to feet and inches in Excel, you are in the right place. This article is for you. Here we will take you ...

How to Convert inch to mm in Excel (3 Simple Methods)

Converting one dimension to another dimension seems to be a difficult task most of the time. We need to convert inch to mm, mm to feet, kg to pound, ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo