We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)
Excel tutorial on how to use the Forecast Sheet in Excel. The Forecast Sheet button quickly analyzes the data on your spreadsheet and then creates a chart of its forecast.
You can then use this chart as a visual to help you understand the forecasted results better or as a visual for a presentation.
Watch as we create a forecast using the Forecast Sheet feature in this tutorial.
The Forecast Sheet button became available with Excel 2016 and is also available in Office 365 Excel version.
To use the Forecast Sheet tool, you will need 2 pieces of information:
- a range of dates and
- the data results for those dates.
The dates used should be consistent and in chronological order.
This data will be used to project results and will be output in both a detailed spreadsheet and a chart. The default chart is a line chart, you can also switch to a column chart.
After creating the final, you can format the chart just like any other chart in Excel, including switching to a different chart type, if you prefer.