Forecasting in Excel and Trends Functions
You can use this function to predict future sales, cash and inventory, or consumer trends. Calculates, or predicts, a future value by using existing values. Formula syntax and usage of the FORECAST and TREND functions in Microsoft Excel.