Learn how to calculate Average, Minimum and Maximum in Excel. We show you how to use MIN, Max, and AVERAGE Functions in Excel.

Averaging in Microsoft Excel is easy, until you start excluding specific values. Here are three ways to average a data set when giving special consideration to the highest and lowest values.

If you need to average a list of values in Microsoft Excel that contain duplicates without including the duplicates, don't fret over a complex expression when you can easily remove those duplicates.

Learn how to calculate moving averages in Excel using dynamic arrays. Simplify rolling totals with custom functions for efficient analysis.

Sometimes you just want to tell Excel what it is you want your formula to do. It'd be a lot easier if you could just say "sort this data in ascending order and find its average" i ...

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...