To optimize your forecast, whether moving average, exponential smoothing or another form of a forecast, you need to calculate and evaluate MAD, MSE, RMSE, and MAPE. With Excel 2016, this is easy to do.
View the video here:

Download a copy of the Excel workbook here: Use Excel to Calculate MAD, MSE, RMSE & MAPE