Do a quick forecast in Excel 2016

 Oct 18, 2016

Excel 2016 has a very handy new feature that enables you to create a quick forecast from a list of dates and their associated figures. It also automatically plots them on a column or line chart for you!

To create this forecast, the process is simple:

  1. Lay out the data in the appropriate format with dates in the first column and data in the second. For example, like this:
  2. Select the data.
  3. Go to the Data tab on the Ribbon and click the Forecast Sheet button. A preview of the chart is shown and can be changed to a column chart with the button at the top-right of the dialog box.
  4. Note: There are other options that can be customized; click the Options button at the lower-left to find these.
  5. Click OK and a new sheet is added to the workbook with the forecasted figures and chart.

For more information, take a look at our Excel training courses.

How do your Excel skills stack up?   

Test Now  

About the Author:

Ben Kirk  

With over 16 years of experience working as a Desktop Applications specialist for a number of large education services providers, Ben is one of New Horizons most skilled and dynamic instructors. With his Advanced Diploma of Business Skills alongside his practical experience and expertise, Ben is able to provide insight and guidance to students at all skill levels across the entire Microsoft Office suite.

Read full bio