Let’s read in this article how to calculate the moving average of time series in Excel?

A moving average is used to smooth out irregularities (peaks and valleys) to easily identify trends

Step 1. First, let’s have a look at our time series. Download excel data demo file
Step 2. On the Data tab, in the Analysis group, click Data Analysis.
Step 3. Select the moving average and click OK.
Step 4. Click in the Input Range box and select B2: M2 Range.
Step 5. Click in the Interval box and type 6.
Step 6. Click in the Output Range box and select cell B3 and click OK
Step 7. Draw a graph of these values.
Step 8. Repeat steps 2 to 7 for interval = 2 and interval = 4.

Best understand through the snapshot

Moving Average in Excel