How to calculate mean in Excel

How to calculate mean in Excel

Calculating the mean of numbers is one of staples of statistical analysis processes. In this article, we’re going to show you how to calculate mean in Excel using the AVERAGE formula. Syntax =AVERAGE( array of numbers ) Steps Begin by creating the formula...
How to create a multi-level Excel lookup

How to create a multi-level Excel lookup

VLOOKUP, HLOOKUP or their predecessor LOOKUP are Excel’s most famous lookup functions. However, these functions can search a value only in a single dimension, meaning that you can’t search horizontally and vertically. Unfortunately, there are no formulas...
How to remove duplicates in Excel

How to remove duplicates in Excel

One of the essential tasks when cleaning up a data set is getting rid of duplicate values. In this article, we’re going to show you  how to remove duplicates in Excel using the Remove Duplicates feature. To find duplicate values using a formula please see: How...
How to sort in Excel in a custom order

How to sort in Excel in a custom order

You can sort data easily from A to Z, or 0 to 9, in ascending or descending order. But what if you want to sort data in a different way, say starting with “Low”, then “Medium”, and “High”? In this article, we’re going to show...