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.

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

The Max and Min functions are two frequently used functions in Excel, to return the largest, smallest value of an argument or range of data containing numbers.

Want to know how to return the highest value using the VLOOKUP function in Excel? We've got you covered right here with our in-depth guide.

This could be useful for all sorts of reasons – finding the maximum sales in any particular month, or the lowest score achieved in a test, for example. Excel offers a simple way of doing this with the ...