Techniques for Better Forecasting in Excel 

It’s never been more important for business professionals to have the skills to build robust, flexible and dynamic forecast models. Using in-built standard Excel tools, we explore how to predict business outcomes and handle the volatile economic inputs we see in these uncertain times. Understanding the inputs, assumptions and drivers and the best way to incorporate them into forecast models is critical for accurate forward planning. We also discuss the best ways to deal with the unknown and evaluate several different forecasting techniques to perform analysis in Excel models.
0:55 Budgeting vs. Forecasting
3:19 Excel Forecast Tools
4:43 Linear Regression
9:11 Calculating Seasonality
20:47 Rolling Forecasts
This session was recorded for Excel Weekend 7, hosted by ‪@ExcelTurbo‬
★Find out more about Excel weekend here ►excelweekend.com/
★Download the Excel file here ► plumsolutions.com.au/wp-conte...
★Connect with Danielle Stein Fairhurst on Linkedin ► / daniellesteinfairhurst