A series with corresponding values. On the data tab, in the forecast group, click forecast sheet. Web in a worksheet, enter two data series that correspond to each other: Web you can use excel to project values that are based on existing data or to automatically generate values based on linear or growth trend calculations. Go to data tab > forecast > forecast. Select the range a1:b13 shown above. To predict future values using the exponential. Create a trend series from your data. Specify when the forecast ends, set a. Select the data (or any cell from your data, and excel would recognize the range itself).
Fill in a series that fits a simple trend, use functions to extend. Select the range a1:b13 shown above. To predict future values using the exponential. Web use the following procedures to learn how to display and predict trends and create a projection. Web you can use excel to project values that are based on existing data or to automatically generate values based on linear or growth trend calculations. Fill in a series that fits a simple trend, use functions to extend. On the data tab, in the forecast group, click forecast sheet. A series with corresponding values. Create a trend series from your data. These values will be predicted for future dates. Go to data tab > forecast > forecast.
