How to Create Forecast in Excel 2016

In this tutorial, we’re going to show you one click forecasting in Excel 2016.


To get started, we have a table of data, select it.

Create Forecast in Excel 2016

Then go to the Data tab and hit the Forecast Sheet button.

Create Forecast in Excel 2016

The lines marked orange represent the actual forecast. We can change where it ends and select some other options to change.

Create Forecast in Excel 2016

When finished, click Create.

Create Forecast in Excel 2016

Excel will create an entirely new sheet.

Create Forecast in Excel 2016

A new sheet should pop up with the entire Forecast Sheet on it.