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

In this tutorial, I’ll show you how to combine commonly used features and functions to return monthly averages for the last n years. The technique also lends itself well to a dashboard.