How to Calculate Moving Average in Excel

Calculating a moving average is possible in different ways. It is needed for multiple reasons. However, it begins with having a data that looks something like this:

moving average data tables

Click on an empty cell (1), type =(B4+B5+B6)/3 (2), and press enter.

empty cell enter

 

Note: For the productiveness of performing a moving average, it is preferable that you put the first average value a few rows after the beginning, as you can see in the picture above (1).

If you look at the lower right corner (showing in the picture below), you will see a small square. Double-click on that small square.

double click small square

Note: This is for calculating the moving average for three years.

In conclusion, the result would look something like this:

moving average

The moving mean has been calculated in this easy way with Excel.