Time series forecasting in excel

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'

  3. Adjust any parameters in the window

  4. This will output a chart and data table on a new sheet.

Time series forecasting in Tableau