Trendline forecasts
Line charts make forecasting easy by offering many trendlines options. There are so many options that picking the right one can be difficult. However, understanding how Excel calculates these will make it easier.
You will explore some of the trendline options and pick one that fits your data the best.
If you've lost progress, open up 4_1_moving_averages.xlsx from the Workbooks folder.
Deze oefening maakt deel uit van de cursus
Data Analysis in Excel
Praktische interactieve oefening
Zet theorie om in actie met een van onze interactieve oefeningen.
Begin met trainen