Question

How to create a forecasting model

Answer 1

Create a forecast

1. In a worksheet, enter two data series that correspond to each other:
   • A series with date or time entries for the timeline
   • A series with corresponding values

These values will be predicted for future dates.

1. Select both data series.

1. On the Data tab, in the Forecast group, click Forecast Sheet.

1. In the Create Forecast Worksheet box, pick either a line chart or a column chart for the visual representation of the forecast.

1. In the Forecast End box, pick an end date, and then click Create.

Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data.

You'll find the new worksheet just to the left ("in front of") the sheet where you entered the data series.