Create a forecast in Excel for Windows - Microsoft Support
Use your existing data in Excel 2016 to predict and chart future values much faster and easier than using the various Forecast functions with one click. This article also contains information on the parameters used in the calculations and how to adjust them.
FORECAST and FORECAST.LINEAR functions - Microsoft Support
This article describes the formula syntax and usage of the FORECAST.LINEAR and FORECAST functions in Microsoft Excel. Note: In Excel 2016, the FORECAST function was replaced with FORECAST.LINEAR as part of the new Forecasting functions .
FORECAST.ETS function - Microsoft Support
Calculates or predicts a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm. The predicted value is a continuation of the historical values in the specified target date, which should be a continuation of the timeline.
FORECAST.ETS.SEASONALITY function - Microsoft Support
FORECAST.ETS.SEASONALITY(values, timeline, [data_completion], [aggregation]) The FORECAST.ETS.SEASONALITY function syntax has the following arguments: Values Required. Values are the historical values, for which you want to forecast the next points.
Forecasting functions (reference) - Microsoft Support
Forecasting functions can be used to predict future values based on historical data. These functions use advanced machine learning algorithms, such as Exponential Triple Smoothing (ETS).
Predict data trends - Microsoft Support
You can use trendline and moving average in two-dimensional charts to graphically display trends and analyze problems of prediction (also known as regression analysis). A moving average smooths out fluctuations in data and shows the pattern or trend more clearly.
FORECAST.ETS.CONFINT function - Microsoft Support
FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation]) The FORECAST.ETS.CONFINT function syntax has the following arguments: Target_date Required. The data point for which you want to predict a value. Target date can be date/time or numeric.
FORECAST.ETS.STAT function - Microsoft Support
FORECAST.ETS.STAT(values, timeline, statistic_type, [seasonality], [data_completion], [aggregation]) The FORECAST.ETS.STAT function syntax has the following arguments: Values Required. Values are the historical values, for which you want to forecast the next points.
TREND function - Microsoft Support
You can use TREND for polynomial curve fitting by regressing against the same variable raised to different powers. For example, suppose column A contains y-values and column B contains x-values. You can enter x^2 in column C, x^3 in column D, and so on, and then regress columns B through D against column A.
Introduction to What-If Analysis - Microsoft Support
If you want to prepare forecasts, you can use Excel to automatically generate future values that are based on existing data, or to automatically generate extrapolated values that are based on linear trend or growth trend calculations.