Use the FORECAST Function: Apply FORECAST to predict a future value based on existing values and the linear trend. Specify the X Value: Enter the x-value for which you want to forecast the y-value.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Use Tab to toggle from the function arguments fields. Select the range of 12 data points for the X Function Argument field. Select the range of 12 revenue goals for the Y Function Argument field.