Excel: Creating Business Budgets

Excel: Creating Business Budgets

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 0h 55m | 141 MB

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.

Topics include:

  • Designing the optimal Excel workbook
  • Cost and revenue drivers and why they’re important
  • Linking revenue scenarios with input costs
  • Building the business budget model
  • Analyzing and interpreting results
  • Applying data validation to control inputs
  • Preparing concise reports
  • Using basic Excel formulas to streamline ongoing updates to the model
Table of Contents

1 Building a business budget in Excel
2 Case study for the course
3 Budgeting foundations
4 Understanding the business
5 Why use Excel
6 Preparing the workbook
7 Understanding cost drivers
8 Understanding revenue drivers
9 How sales impact variable costs
10 Calculating variable costs
11 Calculating staff costs
12 Summarizing expenses
13 Summarizing revenue
14 Preparing reports
15 Sharing the model
16 Enhanced reporting
17 Controlling inputs
18 Efficient updates
19 Undoing mistakes
20 Next steps