Recorded Webinar: Designing a Better Forecasting Spreadsheet

Related Articles
Free Download of the Excel Monthly Forecasting Template
Monthly Forecasting Excel Spreadsheet Template
The Top Call Centre Forecasting Models
A Guide to Call Centre Forecasting
11 Top Tips for Spreadsheet Forecasting in Excel
Assembled Forecasting Template V2 box
9,508
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

    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 Top Call Centre Forecasting Models
    A Guide to Call Centre Forecasting
    11 Top Tips for Spreadsheet Forecasting in Excel