Excel: Creating Business Budgets

Introduction

• Building a business budget in Excel
• Case study for the course

1. Understanding Budgeting

• Budgeting foundations
• Understanding the business
• Why use Excel?

2. Preparing the Business Budget Model

• Preparing the workbook
• Understanding cost drivers
• Understanding revenue drivers
• How sales impact variable costs

3. Building the Budget Model

• Calculating variable costs
• Calculating staff costs
• Summarizing expenses
• Summarizing revenue
• Preparing reports

4. Making the Most of Your Budget Model

• Sharing the model
• Enhanced reporting
• Controlling inputs
• Efficient updates
• Undoing mistakes

5. Collaborating with Your Budget Model

• Migrating to Excel Online
• Using Excel Desktop for enhancements
• Share thoughts with Comments and Notes
• Build trust with Show Changes
• Customize your layout with Sheet View

Conclusion

• Next steps