Share on facebook
Share on Facebook
Share on twitter
Share on Twitter
Share on linkedin
Share on LinkedIn
Share on pinterest
Share on Pinterest

Designing a Better Forecasting Spreadsheet

I was very pleased to take part in a webinar masterclass with Call Centre Helper, all about how to design a forecasting spreadsheet. We 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
 

If you’d like to have a listen you can pop on over to the replay here

Leave a Reply

Your email address will not be published. Required fields are marked *