An estimation of future values is often needed in Excel. For many versions, Excel has already included various functions and diagrams for this purpose. Since version 2016, the 1-click forecast is an additional tool that provides the required information quickly and clearly and is very convenient to use. In this special topic we will familiarize you with the application.

Published on: 11.01.2022

Excel 2016

Create forecasts  
Based on given data, Excel can calculate trends and developments and create a forecast sheet including a visualisation as a column chart or a line chart, an adjustable confidence interval and further options. This is done with just a few clicks. (6 Min.)