Month: August 2015

new feature in Excel 2016: Forecasting

Posted on Updated on

Just read from Microsoft Blog, that Excel2016 will have forecasting feature! Previously I have only seen this feature was once in Office365′ PowerBI service though was quickly “mysteriously” disappeared – now it’s the first time at least for me – come back, in Excel?

New forecasting capabilities

We also revamped the forecasting capabilities provided in Excel 2016. In previous versions, only linear forecasting had been available. In Excel 2016, the FORECAST function has been extended to allow forecasting based on Exponential Smoothing (i.e. FORECAST.ETS() …). This functionality is also available as a new one-click forecasting button. On the Data tab, click the Forecast Sheet button to quickly create a forecast visualization of your data series. From the wizard, you can also find options to adjust common forecast parameters, like seasonality, which is automatically detected by default and confidence intervals.

Business Analytics 3 - b