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 Create Forecast in Excel 2016](https://howtech.tv/wp-content/images/005178/1.jpg)
Then go to the Data tab and hit the Forecast Sheet button.
![Create Forecast in Excel 2016 Create Forecast in Excel 2016](https://howtech.tv/wp-content/images/005178/2.jpg)
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 Create Forecast in Excel 2016](https://howtech.tv/wp-content/images/005178/3.jpg)
When finished, click Create.
![Create Forecast in Excel 2016 Create Forecast in Excel 2016](https://howtech.tv/wp-content/images/005178/4.jpg)
Excel will create an entirely new sheet.
![Create Forecast in Excel 2016 Create Forecast in Excel 2016](https://howtech.tv/wp-content/images/005178/5.jpg)
A new sheet should pop up with the entire Forecast Sheet on it.