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
University of Pennsylvania via Coursera Einführung in das Rechnungswesen
RWTH Aachen University via iversity Fundamentos e Linguagem de Negócios: Contabilidade (The Blue Side Up)
Universidade de São Paulo via Coursera 财务会计概论（中文版）
University of Pennsylvania via Coursera Introduction to Accounting - Part 1: Basics of Financial Statements
Indian Institute of Management Bangalore via edX