Recorded Webinar: Designing a Better Forecasting Spreadsheet

5,284

5,284
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
    11 Top Tips for Spreadsheet Forecasting in Excel
    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.