Excel Formulas

How to Calculate Average Age in Excel: 7 Methods

Method 1 - Calculate Average Age with Average Command Steps Select cell D14. This cell should be below the age column. If the data is in a row ...

How to Convert Feet and Inches to Decimal in Excel (2 Easy Methods)

We like to have our data both simple and gorgeous. Using too many units in a single datum makes it complicated to understand. It also looks horrible ...

How to Calculate Manhattan Distance in Excel (2 Suitable Ways)

This tutorial will show how to calculate Manhattan distance in Excel. From the name, we can get an assumption that it is named after the famous city ...

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

The Levenshtein Distance, also known as the Edit distance, is named after Soviet mathematician Vladimir Levenshtein, who in 1965 first shared the ...

How to Convert Feet to Meters in Excel: 4 Simple Methods

Method 1 - Converting Feet to Meters Using Arithmetic Operations Arithmetic Operations such as Multiplication (i.e., x) or Division (i.e., /) are ...

How to Calculate Mean Variance and Standard Deviation in Excel

The variance, standard deviation and mean deviation are closely related to each other. While working with large Microsoft Excel, now and then, we ...

How to Convert Meters to Miles 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 inches to mm, mm to feet, kg to ...

How to Calculate Standard Error of Regression in Excel (with Easy Steps)

We use regression analysis when we have data from two variables from two different sources and want to build a relationship between them. Regression ...

How to Convert Decimal Feet to Feet and Inches in Excel: 4 Methods

Method 1 - Using the INT & MOD Functions Steps: Select the D5 cell. Enter this formula in the D5 cell to directly convert decimal ...

How to Convert Meters to Feet in Excel – 4 Methods

This is the sample dataset.   Method 1 - Converting Meter to Feet Manually Steps: Select D5, enter the formula, and press ...

How to Convert Feet to Inches in Excel (4 Quick Methods)

Converting units is a common and necessary task in Excel for mathematical, engineering, or any other operations. Maybe the manual way to do it will ...

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

Dataset Overview To convert inches to mm in Excel, we have made a dataset of the vertical Distance (in Inch) of pumps from the basement of an ...

How to Convert Inches to Feet and Inches in Excel: 5 Methods

Method 1 - Applying INT and MOD Functions Steps: Select cell D5, type down the formula below, and press ENTER to get the result in feet and ...

How to Convert Kg to Lbs in Excel (4 Easy Methods)

Looking for ways to know how to convert kg to lbs? Then, this is the right place for you. Sometimes, we need to change kg to lbs. Such as, to ...

How to Plot a Log Scale in Excel (2 Methods)

The following table contains the Name, Month, and Salary columns. We want to plot a log scale in Excel for this table. Method 1 - Using ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo