Aan de slagGa gratis aan de slag

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.

Deze oefening maakt deel uit van de cursus

Data Analysis in Excel

Cursus bekijken

Praktische interactieve oefening

Zet theorie om in actie met een van onze interactieve oefeningen.

Begin met trainen