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

    Recommended Articles

    Monthly Forecasting Excel Spreadsheet Template
    The Latest Techniques for Call Centre Forecasting
    A photo of someone working with spreadsheets
    9 Excel Hacks for Spreadsheet-Based Workforce Planning
    Get the latest exciting call centre reports, specialist whitepapers and interesting case-studies.

    Choose the content that you want to receive.