• Share

Discuss in my forum

Find the Average Value in Excel

Excel's AVERAGE, MODE, and MEDIAN Functions

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

The AVERAGE function can be used to find the arithmetic mean for a group of numbers.

Excel AVERAGEIF Function Step by Step Tutorial

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
As the name suggests, a weighted average places more weight or value on certain elements then on other elements being averaged. This tutorial uses the SUMPRODUCT function to find the weighted average.

Ignore Zeros when Finding the Average

Ignore Zeros when Finding the Average
This tutorial uses the AVERAGEIF function to ignore zero values when calculating the average or arithmetic mean in a range of data.

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
In Excel 2010, the MODE.SNGL function has replaced the MODE function found in previous versions of Excel. Despite its new name, MODE.SNGL still does the same job which is to show you the most frequently occurring value in a list of numbers.

Ted French