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

    Published On: 19th Apr 2016 - Last modified: 28th Feb 2023
    Read more about - Recorded Call Centre and Customer Experience Webinars, ,

    Recommended Articles

    Monthly Forecasting Excel Spreadsheet Template
    The Latest Techniques for Call Centre Forecasting
    Stressed Young Businesswoman Sitting At Desk In Office
    Why You Shouldn't Look For Contact Centre Spreadsheet Templates
    Get the latest exciting call centre reports, specialist whitepapers and interesting case-studies.

    Choose the content that you want to receive.