Budgeting in Excel

This course examines how to create and manage a real corporate budget in Excel.

3.70 (20 reviews)
Udemy
platform
English
language
Microsoft
category
Budgeting in Excel
85
students
1 hour
content
Aug 2017
last update
$44.99
regular price

What you will learn

Explore approaches to take with operational groups to increase accuracy and reduce the burden of budgeting.

Identify how Finance can make the operational groups better at what they do and raise their performance profile.

Discover how to structure the Excel files to provide maximum benefit.

Discover Excel functionality to smooth the way through the process.

Explore how to scale budgeting and planning beyond Excel using more scalable technology, without entirely abandoning the Excel that we know so well.

Description

No-one likes budgeting! However, there are keys to making it work across the organization regardless of technology. This course examines how to create and manage a real corporate budget in Excel, including Excel features that can be utilized to improve the process’ accuracy and scalability.

The course includes many examples and sample files for ease of adoption.

If you would like Continuing Education Credit (e.g. CPE, CE, CPD, etc.) for this course, it is available if you take this course on the Illumeo dot com platform under course title: Budgeting in Excel. Illumeo is certified to provide CPE in over two dozen different professional certifications covering finance, accounting, treasury, internal audit, HR, and more. However, in order to receive CPE credit the courses must be taken on an ‘approved-by-the-governing-body’ CPE platform, and for over two dozen corporate professional certifications, that is the Illumeo platform. Go to Illumeo dot com to learn more.

Content

Introduction

Introduction to Budgeting in Excel
Working with Operations
Demo 1
Budget Timing
Excel Structure
Demo 2
Beyond Excel

Supporting Materials

Slides: Budgeting in Excel
Budgeting in Excel Glossary/Index
Manufacturing Budget
Central Budget
Marketing Budget
Master Budget File
Sales Budget

Review and Test

Review Questions
FINAL EXAM

Charts

Price

Budgeting in Excel - Price chart

Rating

Budgeting in Excel - Ratings chart

Enrollment distribution

Budgeting in Excel - Distribution chart
1324856
udemy ID
8/18/2017
course created date
2/8/2020
course indexed date
Bot
course submited by