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

[kajet]

Routine for dealing with Danielle's videos: 1) thumbs up 2) watch video.