Recorded Webinar – Excel Masterclass – Designing a Better Forecasting Spreadsheet


In this masterclass webinar our panel looked at how to design a forecasting spreadsheet.

Click here to view the replay

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

company logo
This webinar was brought to you by Call Centre Helper.

Click here to view the replay.



Read more about - Recorded Webinars , ,


 
css.php