How to Calculate the Average in Excel

This guide explains how to calculate the Average in Excel, with clear steps, practical tips, and important checks before you begin.

There are 2 ways to calculate an average:

- Calculate the average value according to the usual calculation formula.

- Calculate the average value using the Average function.

1. Calculate the average using the calculation formula

For example, there are transcripts that calculate the average of 3 subjects of the student:

- In the cell to calculate, enter the formula: = (E6 + F6 + G6) / 3

- Press Enter to get the results:

Here the odd average has too many decimal places you need to reformat for easy viewing. Right-click the cell containing the average score -> select Format Cells.

The dialog box appears to select the data type number, in the Decimal places section select the number of digits for the decimal part, for example, here choose 2 decimal places. Click OK to confirm your selection:

- Finally copying the formula to the remaining values results:

2. Calculate the average value using the Average function

In the cell to calculate enter the formula: = Average (E6, F6, G6)

In addition, with the Average function, you can enter parameters by selecting the data area to calculate the average value:

Pressing Enter results:

Copying the formula for the remaining values results in:

Above is a detailed guide on how to calculate an average in Excel. Good luck!