Smooth a series by averaging each value with its neighbors.
Copy this formula
=AVERAGE(B2:B4)A moving average averages a sliding window of rows (here three) and is filled down so the window moves with each row. It smooths noisy trends like daily sales. Widen the range for a longer, smoother window.
=AVERAGE(B2:B8)→1,240A 7-period moving average.
Average rows on both sides, e.g. =AVERAGE(B1:B3) aligned to B2 for a 3-period centered window.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.