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.

But TREND is only the beginning—Excel offers a wealth of statistical tools, such as FORECAST, LINEST, and LOGEST, that you can use to dig deeper into your data and make more informed decisions.