Excel 2016 provides a new tool called Forecast Sheet that automatically calculates and plots your upper and lower forecast boundaries based on your desired level of confidence.

Forecast in Excel is a useful feature that helps you create a forecast based on historical time-based series data analysis. It has some newly built capabilities.

Use Excel's Data Forecast Tool Excel's data forecasting tool lets you predict future trends based on historical data in just a few clicks, saving you from having to make those forecasts manually.

Use Excel’s Forecast Sheet tool Get a quick view of what to expect in the coming year using Excel's Forecast Sheet tool. It creates a chart based on any data sets in your spreadsheet.

Excel: This forecast was bound to happen Excel 2016 provides a new tool called Forecast Sheet that automatically calculates and plots your upper and lower forecast boundaries based on your desired ...