Excel automatically compiles these results for you by graphing it. However, please note that a simple moving average (SMA) is the unweighted mean of the previous n data points. Therefore, you calculate the mean of the last five years of data for each point. Likewise, you sum the values of the last five years for the moving total.