These tutorials cover how to find the average value in Excel using a number of different functions. These tutorials includes step by step examples of using Excel's AVERAGE, AVERAGEIF, AVERAGEIFS, MEDIAN, and MODE functions.
Excel AVERAGE Function Tutorial
© Ted French
The AVERAGE function can be used to find the arithmetic mean for a group of numbers.
Excel AVERAGEIF Function Step by Step Tutorial
© Ted French
The AVERAGEIF function combines the IF function and AVERAGE function in Excel. This combination allows you to find the average or arithmetic mean of those values in a selected range of data that meets specific criteria.
Excel AVERAGEIFS Function Step by Step Tutorial
Excel's AVERAGEIFS Function
The AVERAGEIFS function extends the usefulness of the AVERAGEIF function listed above by allowing you to set conditions on two or more ranges of data rather than just one as in AVERAGEIF.
Calculate Weighted Average in Excel
Calculate Weighted Average in Excel
Ignore Zeros when Finding the Average
Ignore Zeros when Finding the Average
Excel AutoAVEREAGE
Excel AutoAVEREAGE
The AutoAVERAGE feature is a shortcut to using Excel's AVERAGE function. It provides a quick way to find the arithmetic mean for a group of numbers.
Excel MEDIAN Function
Excel MEDIAN Function
The MEDIAN can be used to find the middle value for a group of numbers in Excel.
Excel 2007 MODE Function
Excel 2007 MODE Function
The MODE Functions can be used to find the most frequently occurring value for a group of numbers in Excel.
Excel 2010 MODE.SNGL Function
Excel 2010 MODE.SNGL Function
