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 lost progress, close any open files and load 4_2_trendlines.xlsx from the Workbooks folder.