How to Move Averages in Excel 2010

1. Enter the date, or other reference information, in column A, and enter its corresponding data in column B. Repeat for each data point. As an example, you might have 'Jan 1, 2011' in cell A1 and '$43.25' in cell B1. On the next row, you might have 'Jan 2, 2011' in cell A2 and '$44.50' in cell B2. This continues for however many data points you have, but you will need several data points to construct a moving average.
2. Click the cell in column C whose row number corresponds to the number of data points you want to include in the moving average. As an example, to include the last 20 data points, click cell C20.
3. Type '=AVERAGE(range)' and press 'Enter,' replacing 'range' with the actual range of data points. In the example, this would be 'B1:B20,' so you would enter '=AVERAGE(B1:B20)' in cell C20.
4. Click the cell you just modified, hold the 'Ctrl' key and press 'C' to copy the cell formula.
5. Hold the 'Shift' key and click the last cell in column C that corresponds to the last data point. This selects all the cells between those two cells. As an example, if your last data point was at B40, hold the 'Shift' button and click cell C40. This selects cells C20 through C40.
6. Hold the 'Ctrl' key and press 'V' to paste the formula in all the selected cells. The formulas are automatically altered to reflect their new positions and will include the same number of most recent data points. All these calculations are your moving averages for the corresponding data points.