How do you calculate forecast in Excel?

Answer 1

Enter two data series that correspond and select them. On the Data tab, in the Forecast group, click Forecast Sheet. In the Create Forecast Worksheet box, pick either a line chart or a column chart for the visual representation of the forecast. Pick an end date, and then click Create. This will create a new worksheet with your forecast and a chart. You can also use the FORECAST function.