How to remove blank rows in Excel using filters

How to remove blank rows in Excel using filters

Blank rows can be a not so small nuisance in data collection applications. In addition to making data management harder, an unorganized data set filled with blanks can mess with your calculations. Furthermore, Excel uses blanks as limits of ranges when you add a...
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 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...