Projecting amounts with the Forecast Sheet feature
The Forecast Sheet feature is available in Excel 2016 or later for Windows. You can use it with data that comprises dates/times and values, as shown in Figure 6.20. Let’s assume that we want to protect this data through the end of 2024:
Figure 6.20 – The source data for a forecast
Nuance
The Forecast Feature adds a new worksheet to your workbook that uses the FORECAST.ETS and FORECAST.ETS.CONFINT worksheet functions to project your amounts. You can share a forecast with someone using Excel 2013 or earlier for viewing. The catch is that any edits to the workbook could cause the forecast functions to recalculate. In that event, the forecasted amounts will return #NAME? because older versions of Excel cannot recognize those worksheet functions.
Now, let’s give the Forecast Sheet feature a try:
- Select any cell within your date-based or time-based data, such as cell B4 on...
