When you create a forecast, Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. A forecast can help you …

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 …

In Excel 2016, the FORECAST function was replaced with FORECAST.LINEAR as part of the new Forecasting functions.

When you create a forecast, Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. A forecast can help you …

Click this link to download a workbook with Excel FORECAST.ETS function examples.

In Excel 2016, the FORECAST function was replaced with FORECAST.LINEAR as part of the new Forecasting functions.

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 …

Monte Carlo simulations model the probability of different outcomes. You can identify the impact of risk and uncertainty in forecasting models.

By using What-If Analysis tools in Excel, you can use several different sets of values in one or more formulas to explore all the various results. For example, you can do What-If Analysis to …

Use sparklines in Excel to show data trends and visually represent your data within a cell.

Important: The function FORECAST.ETS.CONFINT is not available in Excel for the Web, iOS, or Android. Returns a confidence interval for the forecast value at the specified target date.