Microsoft Office 2016: The Complete Guide (2015)


In older versions of Excel, the only type of forecasting that was available was linear forecasting. To allow forecasting based on Exponential Smoothing, the 2016 Excel version of the FORECAST function has been extended. This new functionality has also been made available as a one-click forecasting button. The Forecast Sheet button is located on the Data tab. Just click it and you can speedily create forecast visualization of your series of data. Common forecast parameters like seasonality can be adjusted. It is detected automatically by default and confidence intervals. You can find this option on the wizard.