Recorded Call Centre and Customer Experience Webinars

Recorded Webinar: Designing a Better Forecasting Spreadsheet

Published On: 19th Apr 2016 10:16

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

The Forum

Jo Sparkes

Spreadsheet Design Consultant

Dave Appleby

Resource Planning

Jonty Pearce

Call Centre Helper

Author
Rachael Trickey

Rachael Trickey first joined Call Centre Helper in 2010. She has acquired extensive knowledge of call centre technology and the key players in the contact centre Industry.

Rachael is an Account Manager at Call Centre Helper, helping our current customers especially with Webinars and Social Media.

Connect with Rachael on LinkedIn

Recorded Webinar: Designing a Better Forecasting Spreadsheet

Topics Discussed

Panellists

Topic:

Your Next Read