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.
This exercise is part of the course
Data Analysis in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
