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
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'.
Select Data Tab -> Forecast Section -> Click ‘Forecast Sheet'
Adjust any parameters in the window
This will output a chart and data table on a new sheet.