How to Calculate the Mean in Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to find the average of a dataset using the Excel AVERAGE formula.

Quick summary

The AVERAGE function in Microsoft Excel lets you calculate the mean of any dataset instantly by entering a simple formula into a worksheet cell. Selecting a cell range and applying =AVERAGE() returns the arithmetic mean without manual calculation.

Steps

In your Microsoft Excel worksheet, select the cell where you want to display the mean, then type an equals sign (=) to begin the formula.
Type AVERAGE and select it from the autocomplete suggestions that appear.
Enter the cell range containing your values, then add a closing parenthesis to complete the formula.
Click anywhere on the worksheet to confirm the formula and process the result.
The mean of your selected dataset will be calculated and displayed instantly in the chosen cell.

📌 Why this matters

Knowing how to calculate the mean in Microsoft Excel is a fundamental data analysis skill used across finance, research, education, and business reporting. The built-in AVERAGE function eliminates manual arithmetic, reducing errors and saving time when working with large datasets. Excel's formula autocomplete and cell range selection make it accessible even for beginners, while remaining powerful enough for complex spreadsheet workflows. Mastering this function is an essential step toward confident, accurate data analysis in Excel.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel