Forecasting, Planning & Budgeting Techniques with Excel

Course level - Intermediate

This one day course offers hands-on training surrounding specific skills in Excel which help enhance forecasting and budgeting practices, as part of the management accounting function.

Learning outcomes include obtaining a greater understanding of:

• Forecasting, planning and budgeting as part of the management accounting function
• Modern quantitative methods used for forecasting
  • ◦ Regression analysis
  • ◦ Time series analysis
  • ◦ Expected value calculations
• Planning techniques
  • The deterministic approach
  • Optimisation using the Solver toolpak
  • The ‘What-if analysis’ and ‘Scenario Manager’
  • Working with ‘Data Tables’
  • ◦Introduction to stochastic planning
• Functions
  • Random number generator
  • Conditional/Error
  • Forecast/Slope/Intercept
  • Array
• Budgeting
  • Producing budgets
  • Consolidation options
• An introduction to Excel dashboards
  • Create a simple dashboard
  • Tips on how to present overview data on a front screen