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: https://studio.youtube.com/video/H_N5_vxs8Tg/edit

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