Rolling Average

I recently found a simple way to calculate a rolling average in Microsoft Excel, and I thought I'd share it with you all. This method uses the AVERAGE function and relative references. Here's how you can do it: Enter Your Data: Put your data in column A (A1 to A100, for example). Calculate Rolling Average: In the cell where you want the rolling average to start (let's say, B3), enter the formula: =AVERAGE(A2:A4) Drag this formula down for the entire column. Adjust the Formula for Your Needs: If your data starts from a different row, adjust the cell references accordingly. If you want a different rolling window (e.g., 4 cells instead of 3), modify the range accordingly. Now, your rolling average will update automatically as you add or modify data in column A. Feel free to ask if you have any questions or need further clarification! Happy Excel-ing!