How to Calculate Simple Moving Average using a formula in Excel - Office 365

A moving average also called rolling average or running average is an average based on subsets of data at given intervals. A moving average is when you keep the time period of the average same but keeps moving as new data is added. Moving average calculations is a common way of smoothing data to reduce the effects of random, short term fluctuations. The larger the interval used to calculate moving average, the more smoothing that occurs since more data points are included in each calculated average. Simple moving average is the average of the data points in the given duration.

To download practice Excel file please click on the link below