Designing a Better Forecasting Spreadsheet

I was very pleased to take part in a webinar masterclass with Call Centre Helper, all about how to design a forecasting spreadsheet. We discussed:

• Latest Forecasting Methods
• Regression based forecasting techniques – Holt Winters and ARIMA
• Building External Factors into the Forecast – Weather, Marketing, Mailings
• Removing outliers
• Useful Excel functions
• Correlation of data
• Using Pivot tables
• Using the Excel solver
• Seasonality and Trends
• Linking spreadsheets to WFM software
• Top tips from the audienceIf you’d like to have a listen you can pop on over to the replay here