The Leading Contact Centre Magazine

Recorded Webinar: Designing a Better Forecasting Spreadsheet

5,794

5,794
Filed under - Recorded Call Centre and Customer Experience Webinars, ,
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


    Read more about - Recorded Call Centre and Customer Experience Webinars, ,

    Recommended Articles

    Monthly Forecasting Excel Spreadsheet Template
    The Latest Techniques for Call Centre Forecasting
    A Guide to Workforce Forecasting in the Contact Centre
    Contact Centre Reports, Surveys and White Papers
    Get the latest exciting call centre reports, specialist whitepapers, interesting case-studies and industry events straight to your inbox.