Calculate Moving (or Rolling) Average In Excel | Add Rolling Average Chart

In this video I demonstrate how to perform moving (or rolling) average calculations. Typically rolling average calculations are performed over a seven day period, you might however perform the calculations over five or thirty days.

Table of Contents:

00:00 - Using formula to calculate moving averages and adding a chart to graphically display moving averages
02:12 - Using the Analysis ToolPak to perform the calculations and produce a chart
------------------------

[shiffamohammed]

Awesome! Thank you so much for demonstrating the various ways of calculating rolling average using excel.

[tommyharris]

Brilliant. It would be great if you can show a MA crossover strategy

[wayneedmondson]

Hi Chester. Great lesson! Thanks for showing several ways to calculate and display a moving average. My preference is always to do the calculations myself which can then provide the backup for the question.. how did you generate these numbers? Great tips! Thanks for sharing :)) Thumbs up!!

[sammygeorge]

This is what I am trying to do. I take blood medical readings twice per day and enter those in Excel. I would like to use only 3 cells to display the average of the last 10 days, the last 30 days and the last 60 days. The formula in those three (10, 30, 60 day) cells would drop off a day and pick up a day each day when I enter the current days readings. Is that possible? Thanks for your videos and help.