Excel Average Function Tutorial

You can download here the worksheet from this video to practice it by yourself!

Calculating Average

The average function lets you select a range of numeric cells in your spreadsheet, gather up all of the numbers to calculate an average, and then drop it into the destination cell of your choosing.

Excel is perfect for math-related issues and you can even use it simply for help on everyday math problems.

Even when you don’t need it for a specific spreadsheet, it may be the quickest and easiest way to get a reliable average for a set of numbers, especially large groups of numbers.

Simply select a target cell for the answer, then press the small arrow of the Functions button (Greek letter Sigma, looks like an “E”), select Average, and highlight the cells you want to include in the number.