Included Exercise Files
Skill Level : Intermediate
Duration : 55m
Language : English
Released : 11/19/2018
Size : 122,44 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
