Recorded Webinar: Designing a Better Forecasting Spreadsheet
Published On: 5th Aug 2026 10:16
In this masterclass webinar our panel look at how to design a forecasting spreadsheet.
Topics 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 audience
Panellists
Jo Sparkes
Spreadsheet Design Consultant
Dave Appleby
Resource Planning
Jonty Pearce
Call Centre Helper