Forecasting & Time-Series Analysis in Excel
Growth rates, smoothing, seasonal indices, trend × season forecasts, accuracy metrics and driver-based scenarios: 8 labs on one consistent retail dataset.
The first lesson is free — no account needed.
Lessons
- Time-Series Basics: MoM, YoY and CAGRFree
- Moving Averages, Weighted Averages & Exponential Smoothing Pro
- Seasonality: a Seasonal Index for Every Month Pro
- Deseasonalising & Reseasonalising Pro
- Linear Trend: TREND, FORECAST.LINEAR, SLOPE & INTERCEPT Pro
- Trend × Seasonality: the 12-Month Forecast Pro
- Forecast Accuracy: MAE, MAPE, Bias & Tracking Signal Pro
- Driver-Based Scenarios vs the Statistical Forecast Pro