Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Excel: Creating Business Budgets

via LinkedIn Learning

Write review

Details

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Effort

1 hour 9 minutes
Sessions

Self-Paced
Level

Beginner

Found in

DataCamp

Power BI Fundamentals - Create visualizations and dashboards from scratch

Boot.dev

Learn Backend Development Part-Time, Online

Overview

Google, IBM & Meta Certificates – 40% Off

One Coursera Plus subscription covers most Professional Certificates on Coursera.

Unlock All Certificates

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

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

Taught by

Joshua Rischin

Reviews

4.7 rating at LinkedIn Learning based on 1186 ratings

Start your review of Excel: Creating Business Budgets