Overview
-
Learn how to design, create, and maintain robust business budgets using Microsoft Excel.
Syllabus
-
Introduction
- Building a business budget in Excel
- Case study for the course
- Budgeting foundations
- Understanding the business
- Why use Excel?
- Preparing the workbook
- Understanding cost drivers
- Understanding revenue drivers
- How sales impact variable costs
- Calculating variable costs
- Calculating staff costs
- Summarizing expenses
- Summarizing revenue
- Preparing reports
- Sharing the model
- Enhanced reporting
- Controlling inputs
- Efficient updates
- Undoing mistakes
- Next steps
