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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s