Predicting future values using FORECAST and FORECAST.LINEAR functions in Excel - Office 365

In Excel 2016 the FORECAST function was replaced with FORECAST.LINEAR as part of the new forecasting functions. The syntax and usage of the two functions is the same but the older FORECAST function will be eventually deprecated. It's still available for backward compatibility but consider using the FORECAST.LINEAR function instead. These functions predicts a value based on existing values using linear regression. Can be used to predict numeric values like inventory, expenses, measurements etc.

To download the practice Excel file please click on the link below

To learn more about different Forecast functions in Excel please click on the link below