Excel: Creating Business Budgets
1h 9mIntermediate2023-10-19
Authors

Joshua Rischin
Company Director of Axium Solutions
Course details
A sound business budget can help you effectively manage resources as your organization changes and grows. Microsoft Excel is uniquely suited to the task of business budgeting, as it boasts a slew of features that make it easy to create budget models, as well as apply ongoing updates as your business evolves. In this course, Joshua Rischin shows business owners, managers, and their staff how to use Excel to design, create, and maintain robust business budgets. Joshua demonstrates how to use an Excel model to build business budgets in a logical and structured manner, as well as how to forecast income and expenses based on various scenarios. He also shows how to collate inputs from various sources to create structured Excel input sheets, visualize your projected results, prepare summary reports, and more.
Learning objectives
Identify why it is a good idea to use Excel when creating a business budget.
Examine the importance of revenue drivers when putting together a business budget.
Recognize how to calculate staff costs when creating a business budget.
Explore the elements of preparing a concise report.
Break down the fundamentals of enhanced reporting.
Determine the best ways to utilize efficient updates.
Learning objectives
Identify why it is a good idea to use Excel when creating a business budget.
Examine the importance of revenue drivers when putting together a business budget.
Recognize how to calculate staff costs when creating a business budget.
Explore the elements of preparing a concise report.
Break down the fundamentals of enhanced reporting.
Determine the best ways to utilize efficient updates.
Skills covered
Project Management SoftwareSpreadsheetsMicrosoft ExcelProject ManagementBusiness Software and ToolsMicrosoftDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Building a business budget in Excel
- 02 - Case study for the course
1. Understanding Budgeting
- 03 - Budgeting foundations
- 04 - Understanding the business
- 05 - Why use Excel
2. Preparing the Business Budget Model
- 06 - Preparing the workbook
- 07 - Understanding cost drivers
- 08 - Understanding revenue drivers
- 09 - How sales impact variable costs
3. Building the Budget Model
- 10 - Calculating variable costs
- 11 - Calculating staff costs
- 12 - Summarizing expenses
- 13 - Summarizing revenue
- 14 - Preparing reports
4. Making the Most of Your Budget Model
- 15 - Sharing the model
- 16 - Enhanced reporting
- 17 - Controlling inputs
- 18 - Efficient updates
- 19 - Undoing mistakes
5. Collaborating with Your Budget Model
- 20 - Migrating to Excel Online
- 21 - Using Excel Desktop for enhancements
- 22 - Share thoughts with Comments and Notes
- 23 - Build trust with Show Changes
- 24 - Customize your layout with Sheet View
Conclusion
- 25 - Next steps
Related courses
- Agile Project Management with Microsoft Project
- Learning Asana
- Managing Projects with Smartsheet
- Learning Microsoft Project
- Microsoft Planner Essential Training
- Copilot in Microsoft Planner: Set Goals and Track Projects
- Smartsheet Essential Training
- Microsoft Project 2021 and Project Online Desktop Essential Training