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:
Click on an empty cell (1), type =(B4+B5+B6)/3 (2), and press 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.
Note: This is for calculating the moving average for three years.
In conclusion, the result would look something like this:
The moving mean has been calculated in this easy way with Excel.