Learn different methods to find the arithmetic mean, median, mode, and other kinds of averages in Excel . See examples, syntax, and tips for using AVERAGE , AVERAGEA, AVERAGEIF, and more functions. Learn how to use the AVERAGE function in Microsoft Excel to find the mean of a range of values. This step-by-step guide explains the process simply and clearly. Learn how to use the AVERAGE function in Excel with Inside Excel 's step-by-step guide, examples, and practice exercises. Excel provides a variety of ways to find the average of a set of numbers. For example, you can use function to calculate a simple average , a weighted average , or an average that excludes specific values. Use the provided sample data and the following procedures to learn how to calculate averages . Copy the sample data To better understand the steps, copy the following sample data to cell A1 on a blank sheet. Create a blank workbook or sheet. Select the following sample data.