This video demonstrates how to calculate a moving (rolling) average in Microsoft Excel 2016. Two separate methods are used to generate the statistic: data analysis tools and the AVERAGE function. The moving average smooths out peaks and valleys in time series data.