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 simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

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

Learn how to calculate moving averages in Excel using dynamic arrays. Simplify rolling totals with custom functions for efficient analysis.

Learn how to calculate cumulative averages in Excel with manual and dynamic methods. Master advanced functions like SCAN, LET, and MAP ...

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.