Forecast Sheet
In the previous method, the trendlines didn't give us an output with numbers, only a graphic representation. While this is nice, having a worksheet with actual numbers can be better. Bananas would like actual numbers for a forecast that uses a sophisticated methodology and can consider seasonality and confidence levels.
Luckily, we don't need to be a data scientist to do all of this. As long as we understand fundamental forecasting concepts, we can use the Forecast Sheet tool to create a sophisticated prediction model in seconds!
If you've lost progress, open up 4_2_trendlines.xlsx
from the Workbooks folder.
This exercise is part of the course
Data Analysis in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
