An “Excel jet forecast” is not a built-in feature—it is a custom forecasting model you build in Microsoft Excel to predict future values (like sales, demand, or inventory) using historical data. The fastest way to create one is to select your data, go to Data > Forecast Sheet, and let Excel generate a forecast with a confidence interval. For more control, use the FORECAST.ETS function, which applies exponential smoothing—the same statistical approach used in many commercial forecasting tools.
What “Jet Forecast” Actually Means
The term “jet forecast” is informal. It usually refers to a fast, automated forecasting method in Excel that requires minimal manual setup—hence the “jet” speed. It is not an official Microsoft feature name. People also use it to describe the Forecast Sheet tool or the FORECAST.ETS family of functions. These tools are part of Excel’s built-in time-series forecasting, introduced in Excel 2016 and refined in Microsoft 365.
How the Forecast Sheet Works
The Forecast Sheet is the easiest entry point. It uses the FORECAST.ETS algorithm behind the scenes. Here is how to use it:
- Arrange your data in two columns: one for dates (or time periods) and one for values.
- Select both columns, including headers.
- Go to Data > Forecast Sheet.
- In the dialog, set the forecast end date and choose options like seasonality (automatic, manual, or none).
- Click Create. Excel inserts a new worksheet with a line chart, a forecast line, and upper/lower confidence bounds.
The confidence interval default is 95%, meaning Excel expects the actual future value to fall within the shaded band 95% of the time. You can adjust this in the options.
Using FORECAST.ETS for Custom Models
If you prefer formulas, FORECAST.ETS gives you the same result but inside a cell. The syntax is:
=FORECAST.ETS(target_date, values, dates, [seasonality], [data_completion], [aggregation])
For example, with dates in A2:A20 and sales in B2:B20, and a target date in D2, the formula is:
=FORECAST.ETS(D2, B2:B20, A2:A20)
This returns a single forecasted value. To get a confidence interval, use FORECAST.ETS.CONFINT:
=FORECAST.ETS.CONFINT(D2, B2:B20, A2:A20, 0.95)
Add and subtract this from the point forecast to get the lower and upper bounds. These functions require Excel 2016 or later; in Microsoft 365 they are fully supported. On Mac, the same functions exist, and the ribbon path is identical.
Choosing the Right Method
Not every dataset suits exponential smoothing. Here is a quick guide:
- Forecast Sheet / FORECAST.ETS: Best for data with clear trends and seasonality, like monthly sales or website traffic.
- FORECAST.LINEAR: Use for simple linear trends without seasonality. Syntax:
=FORECAST.LINEAR(x, known_ys, known_xs). - TREND: Similar to linear regression but returns multiple values if entered as an array formula.
- Moving average (via AVERAGE with OFFSET): Good for smoothing noise, but not a true forecast—it lags behind.
If your data has missing dates, FORECAST.ETS can handle them if you set the data completion argument to 1 (or TRUE). Otherwise, it may error. Also, Excel detects seasonality automatically by default, but you can force it with a number (e.g., 12 for monthly data with yearly seasonality).
Common Problems and Fixes
Users often hit these issues:
- #VALUE! error: Occurs when dates are not recognized as real dates, or when the target date is outside the range. Ensure dates are in date format, not text.
- Forecast looks flat: If seasonality is set to 0 or auto-detection fails, the forecast may ignore patterns. Try setting seasonality manually.
- Too many data points:
FORECAST.ETSworks best with at least two full seasonal cycles. For monthly data with yearly seasonality, that means at least 24 months. - Confidence interval too wide: This indicates high variability. Consider using a lower confidence level (e.g., 0.80) or more historical data.
If you get a #NUM! error, it usually means the seasonality value is invalid or the data has too few points. Check the help for the exact constraints.
Comparing to Other Tools
Excel’s built-in forecasting is basic compared to dedicated tools like R, Python’s statsmodels, or specialized software like SAS Forecast Server. It does not support ARIMA or machine learning models. However, for quick business forecasts, it is often sufficient. If you need more advanced methods, you can use the Analysis ToolPak add-in for exponential smoothing, but it is less flexible than FORECAST.ETS. For large datasets, Excel may slow down, but for typical business data (up to a few thousand rows), it is fine.
Cost and Availability
Forecasting features are included in all modern Excel versions—no extra cost. You need Excel 2016 or later, or a Microsoft 365 subscription. The Forecast Sheet is available on Windows, Mac, and Excel for the web, though the web version may have fewer options. If you are using an older Excel version (2013 or earlier), you can still use FORECAST and TREND, but not FORECAST.ETS.
Frequently Asked Questions
Can I forecast with non-date data?
Yes, but FORECAST.ETS requires a timeline that is equally spaced. If you use numeric periods (like 1, 2, 3…), it works, but seasonality detection may be less accurate. Use FORECAST.LINEAR for simple numeric x-values.
How do I add seasonality manually?
In the Forecast Sheet dialog, change the seasonality from “Automatically detect” to “Set manually” and enter a number. For monthly data with yearly seasonality, enter 12. In the formula, add the seasonality argument: =FORECAST.ETS(D2, B2:B20, A2:A20, 12).
Why is my forecast line a straight line?
That happens when seasonality is set to 0 or the data has no detectable seasonal pattern. If your data clearly has peaks and valleys, try setting seasonality to a specific number or check that your dates are complete and regular.
Can I forecast multiple products at once?
Yes, but each product needs its own forecast. You can use a single formula per product, or create a dynamic array formula with BYROW or MAKEARRAY in Microsoft 365. For example, with product names in A2:A5 and values in B2:E20, you could use FORECAST.ETS inside a LAMBDA function, but that is advanced.
Is there a way to see the underlying statistics?
Excel does not expose the model coefficients. For a detailed breakdown, you would need to use the Analysis ToolPak’s Exponential Smoothing tool, which outputs a smoothed series but not full statistics. For academic or rigorous work, consider exporting to a statistical package.
Final Thoughts
Building a jet forecast in Excel is straightforward: use the Forecast Sheet for a quick visual, or FORECAST.ETS for a formula-based approach. Always validate your forecast against a holdout sample if possible, and remember that forecasts are estimates—they are not guarantees. For critical business decisions, combine Excel’s output with domain knowledge and, if needed, consult a statistician.
Related
- Excel Conditional Formatting Date Occurring: How To
- Excel Conditional Formatting Color Scales Explained
- Excel Center Louisville KY: What It Is & How It Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Hide Columns in Excel on Mac Without Losing DataTo hide columns in Excel on a Mac, select the column letter or letters, then choose Home >…
- Filter Unique Values in Google Sheets With a FormulaIf the values are in A2:A and their statuses are in B2:B, enter =UNIQUE(FILTER(A2:A7,B2:B7="Paid",A2:A7<>"")) to return each nonblank…
- Excel Conditional Formatting Between Two Dates: StepsTo highlight dates between two limits in Excel, select the date cells, choose Home > Conditional Formatting >…
- How to Schedule an Email in Outlook to Send at a Later TimeTo schedule an email in Outlook, write your message, open the menu beside Send, choose Schedule send, and…
- Aggregate Excel Rows by Category, Product, or DateTo aggregate Excel rows, select your source data and choose Insert > PivotTable; place the field you want…
- Excel Text on Multiple Lines in One Cell: How to Do ItTo put text on multiple lines in one Excel cell, select the cell, start editing it, and press…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.