16
Oct
How to Build a Seasonal Forecast in Excel, Step by Step
A moving average will always be late to a seasonal peak. A seasonal index fixes that with one extra column and an AVERAGEIFS. Here is the method, tested on two years of data.
5 min read