Recorded Webinar – Excel Masterclass – Designing a Better Forecasting Spreadsheet

Speakers

• Jonty Pearce – Call Centre Helper

Click here to view the slides

• Jo Sparkes, Spreadsheet Design Consultant

Click here to view the slides

• Dave Appleby, Resource Planning

Click here to view the slides

• John Casey, The Forum

Click here to view the slides

Resources

https://www.callcentrehelper.com/erlang-c-calculator-2473.htm
https://www.callcentrehelper.com/forum/topic/forecasting-abandoned-calls
http://www.dashboarddiva.co.uk/free-help-with-spreadsheets/
https://www.facebook.com/groups/spreadsheetsupport

Click here to download our Monthly Forecasting Excel Spreadsheet Template

Topics to be 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
• Winning tip – “I use WEEKNUM excel function to incorporate previous years data with recent data to determine Week / Day of Week distribution”. Thanks to Michael

Original Webinar date: Thursday 28th April 2016