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

    Author: Rachael Trickey

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

    Follow Us on LinkedIn

    Recommended Articles

    Free Download of the Excel Monthly Forecasting Template
    Monthly Forecasting Excel Spreadsheet Template
    The Latest Techniques for Call Centre Forecasting
    A Guide to Call Centre Forecasting
    11 Top Tips for Spreadsheet Forecasting in Excel