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.

Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

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