Explanation

The Forecast Sheet provides options that affect how the forecast is generated.

Important Options

Forecast End

Determines how far into the future Excel predicts.

Confidence Interval

Controls the confidence range displayed around the forecast.

Seasonality

Represents repeating patterns in the historical data.

For example:

  • Higher sales every December
  • Lower sales every January
  • Seasonal festival demand

Excel can automatically detect seasonality, or you can specify it when appropriate.

Practice

Use monthly sales data containing seasonal variations and compare the forecast with automatic seasonality.

PreviousNext