Excel: calculate average

It is often helpful to calculate the mean or average value of a series of numbers in Excel. With a simple function, you even save yourself mental arithmetic.

Calculate average value in Excel

1. Create a series of numbers in Excel. The numbers do not necessarily have to be in a column or a row, but can be distributed anywhere.
2. Click on the field in which you want to calculate the mean.
3. Enter the formula "= AVERAGE VALUE (***)". Instead of the asterisks, you have to select the fields you want to calculate the average value from.
4. You can simply type in the fields. Mark an area between two fields with the notation "Field1: Field5". To specify multiple fields, separate the fields with a semicolon.
5. Alternatively, you can simply mark the desired fields with the left mouse pointer.
6. When you tap [Enter], Excel automatically calculates the average of all selected numbers.

In another practical tip you will find the 5 most annoying functions in Excel and what you can do about them.