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

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

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.