Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
Excel: Creating Business Budgets

Excel: Creating Business Budgets

1h 9mIntermediate2023-10-19

Authors

Joshua Rischin

Joshua Rischin

Company Director of Axium Solutions

Course details

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.

Learning objectives
Identify why it is a good idea to use Excel when creating a business budget.
Examine the importance of revenue drivers when putting together a business budget.
Recognize how to calculate staff costs when creating a business budget.
Explore the elements of preparing a concise report.
Break down the fundamentals of enhanced reporting.
Determine the best ways to utilize efficient updates.

Skills covered

Project Management SoftwareSpreadsheetsMicrosoft ExcelProject ManagementBusiness Software and ToolsMicrosoftDeep Dive (X:Y)

Concepts

0. Introduction

  • 01 - Building a business budget in Excel
  • 02 - Case study for the course

1. Understanding Budgeting

  • 03 - Budgeting foundations
  • 04 - Understanding the business
  • 05 - Why use Excel

2. Preparing the Business Budget Model

  • 06 - Preparing the workbook
  • 07 - Understanding cost drivers
  • 08 - Understanding revenue drivers
  • 09 - How sales impact variable costs

3. Building the Budget Model

  • 10 - Calculating variable costs
  • 11 - Calculating staff costs
  • 12 - Summarizing expenses
  • 13 - Summarizing revenue
  • 14 - Preparing reports

4. Making the Most of Your Budget Model

  • 15 - Sharing the model
  • 16 - Enhanced reporting
  • 17 - Controlling inputs
  • 18 - Efficient updates
  • 19 - Undoing mistakes

5. Collaborating with Your Budget Model

  • 20 - Migrating to Excel Online
  • 21 - Using Excel Desktop for enhancements
  • 22 - Share thoughts with Comments and Notes
  • 23 - Build trust with Show Changes
  • 24 - Customize your layout with Sheet View

Conclusion

  • 25 - Next steps

Related courses

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
zarinpal
zibal