Trends in Excel: Moving Averages and Exponential Smoothing
This video discusses four ways. 1. Let VBA create a chart with a moving average trendline. 2. Let VBA calculate the moving averages with an R1C1 formula. 3. Use a formula with a nested OFFSET function. 4. Use a formula based an exponential smoothing equation