Advanced Budgeting and Forecasting In Excel Course

This practical course will cover issues such as using budgets to measure staff performance, linking budgets to the strategic planning process and a comparison of budgeting techniques. We will explore the difference between budgets and forecasts, rolling forecast, report and budget scenarios in Excel.

Course Agenda Highlights

• Budgeting and Forecasting Theory
• Cost management concepts
• Budgets and strategic planning
• Using budgets as performance management
• Financial ratio analysis
• Reporting
• Budgeting techniques
• Limitations of budgets
• Budgeting “soft’’ skills
• Budgeting and Forecast Modeling
• Budget modeling
• Historical data analysis in excel
• Determination of business trends, cycles and seasonality
• Scenarios, sensitivities and stress-testing

Who Should Attend?

• Directors
• Deputy Directors
• General Managers
• Accountants
• Finance Staff
• Department heads.