Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise