Recorded Webinar – Excel Masterclass – Designing a Better Forecasting Spreadsheet


  • 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


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

Get the latest exciting news and articles straight to your inbox