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

There's a lot going on in these formulaic conditional rules in Microsoft Excel that highlight the smallest and largest values within a period of years.

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.