Chapter 15: Using Formulas for Financial Analysis
15
Click Create and Excel inserts a new worksheet that contains a table and a chart. Figure
15.27 shows part of this table. The table displays the forecasted values, along with
the lower and upper confidence intervals. These values are generated using the new
FORECAST.ETS and FORECAST.ETS.CONFINT functions. These are fairly complex func-
tions, which explains why Excel does all the work.
FIGURE 15.27
The forecast worksheet contains a table and a chart.