MulaiMulai sekarang secara gratis

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.

Latihan ini adalah bagian dari kursus

Data Analysis in Excel

Lihat Kursus

Latihan interaktif praktis

Ubah teori menjadi tindakan dengan salah satu latihan interaktif kami.

Mulai berolahraga