# Time series forecasting in excel

I have done some time series forecasting using python in the past. Recently explored the Prophet library.

I like exploring doing similar things using different tools, so I wanted to step through doing time series forecasting in excel. Which is surprisingly pretty simple.

### Steps

1. Highlight your data in excel. (Both x and y variables). In my example I had a 'Date' and 'Value' column. I created some fake data with 'seasonality'.
    
2. Select Data Tab -> Forecast Section -> Click ‘Forecast Sheet'
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1704468383765/d73962c9-ff37-4771-ac8b-21786a6c2af2.png align="center")
    
3. Adjust any parameters in the window
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1704468457175/1c42a43b-61be-4c0f-8e96-82365714be0a.png align="center")
    
4. This will output a chart and data table on a new sheet.
    

[Time series forecasting in Tableau](https://blog.dtucker.xyz/time-series-forecasting-with-tableau)