Excel: Creating Business Budgets
Offered By: LinkedIn Learning
Course Description
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
- 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
- Next steps
Taught by
Joshua Rischin
Related Courses
Intro to StatisticsStanford University via Udacity Introduction to Data Science
University of Washington via Coursera Passion Driven Statistics
Wesleyan University via Coursera Information Visualization
Indiana University via Independent DCO042 - Python For Informatics
University of Michigan via Independent