Budgeting and Forecasting in Excel

If you are new to the budgeting and forecasting process, 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, and you will learn how to create your own budget, rolling forecast, variance report and budget scenarios in Excel.

This course is delivered in two parts; the first part of the day covers the theory of budgeting and forecasting within organisations. Issues such as budgeting to organisational objectives, level of granularity and selecting the correct budgeting tool will be discussed. Students are encouraged to share their own experiences with the class. In the second part of the day, students will build their own budget and forecasting model to bring a practical application to the skills they have learned. The model will include a budget, rolling forecast, variance report as well as scenarios and sensitivity testing.

Prerequisites:

This course is designed for users who use Excel fairly regularly, and are comfortable with using simple functions. It is assumed that the user will know how to create simple formulas, and link between workbooks. If you are unsure about your level of Excel, you might also consider joining the online Excel School prior to coming on the course.

If you are new to the budgeting and forecasting process, 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, and you will learn how to create your own budget, rolling forecast, variance report and budget scenarios in Excel.

This course is delivered in two parts; the first part of the day covers the theory of budgeting and forecasting within organisations. Issues such as budgeting to organisational objectives, level of granularity and selecting the correct budgeting tool will be discussed. Students are encouraged to share their own experiences with the class. In the second part of the day, students will build their own budget and forecasting model to bring a practical application to the skills they have learned. The model will include a budget, rolling forecast, variance report as well as scenarios and sensitivity testing.

Prequisites:

This course is designed for users who use Excel fairly regularly, and are comfortable with using simple functions. It is assumed that the user will know how to create simple formulas, and link between workbooks. If you are unsure about your level of Excel, you might also consider joining the online Excel School prior to coming on the course.