Do you need to Forecast some data? This tip will give you the basics of using the Forecast function.

We will use the picture in our example:

1. In a blank cell (B11) type =Forecast(
2. Click on the cell (A11) where the month you want to forecast will be (this will enter the cell in your formula)
3. Hit , (comma)
4. Click and drag the range of Sales to forecast (B3:B7 or known_x’s)
5. Hit, (comma)
6. Click and drag the range of months to forecast (A3:A7 or known_y’s)
7. Hit enter

Sidenote: You can change the forecasted month (A11) to see the Forecast for additional months, or use Autofill.