Recorded Webinar: Designing a Better Forecasting Spreadsheet


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

    John Casey- Headshot
    John Casey
    The Forum
    Jo Sparkes- Headshot
    Jo Sparkes
    Spreadsheet Design Consultant
    Dave Appleby- Headshot
    Dave Appleby
    Resource Planning
    Jonty Pearce- Headshot
    Jonty Pearce
    Call Centre Helper

    company logo
    This webinar was brought to you by Call Centre Helper and is sponsored by Call Centre Helper


    Get the latest exciting call centre reports, specialist whitepapers, interesting case-studies and industry events straight to your inbox.