It is easy to create a rolling 6 months average with Excel. But, there are different steps you’d need to follow, and we will do it together.
Rolling 6 months average
But first you need the data for those six months, and this is something like this:
Click on an empty cell (1), and type =AVERAGE($C$3:$C$3) (2), then press enter.
Click on cell D4 (1), then write =AVERAGE($C$3:$C$4), and press enter.
Note: Follow this step on the rest using $C$3:$C$5 (April), $C$3:$C$6 (May), $C$3:$C$7 (June), and $C$3:$C$8 (July).
In conclusion, the steps we just followed is the rolling average for the last six months. You can even use the result to create a chart, or as you wish.
How to calculate a Moving Average?
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 (shown 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.