were going to show you one click forecasting in Excel 2016.
Don't forget to check out our main channel for more free how-to videos!
Join us on Facebook
Our App
To get started, we have a table of data, select it.
Then go to the Data tab and hit the Forecast Sheet button.
The lines marked orange represent the actual forecast. We can change where it ends and select some other options to change.
When finished, click Create.
Excel will create an entirely new sheet.
A new sheet should pop up with the entire Forecast Sheet on it
Natalia: Mine doesnt have forecast sheet as an option. Just what if analysis. I tried searching in excel too, no luck. Any advice? Date: 2023-07-08
