Excel: Creating Business Budgets

Offered By: LinkedIn Learning

Tags

Microsoft Excel Courses Data Visualization Courses Financial Planning Courses Cost Analysis Courses Financial Reporting Courses

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

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

Related Courses

Introduction to Financial Accounting: The Accounting Cycle
University of California, Irvine via Coursera Microsoft Excel: Advanced Data Analysis and Visualisation
Cloudswyft via FutureLearn Data Visualization with Advanced Excel
PwC via Coursera الترجيح الإحصائي أو Statistical Weighting فى Microsoft Excel
Coursera Project Network via Coursera Business Metrics for Data-Driven Companies
Duke University via Coursera