Instructor for this course
more

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.

Learning Objectives

  • 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.
Last updated/reviewed: September 18, 2018

27 Reviews (64 ratings)Reviews

4
Member's Profile
Great class with great tips and ideas to smooth processes, wish he would have touched on service based organizations more and would love to see a case on budgeting scenarios for different types of businesses.
5
Anonymous Author
I love the simplicity and inter-connectivity of the Excel files he created. It really shows the dependencies and narrows the user inputs to what they will know the most about.
4
Anonymous Author
Would have been helpful to have gone into more detail in the excel worksheets with formula used - advise brushing up on this before taking course but otherwise very good
5
Anonymous Author
Another great course I will refer back to when setting up our company's budget. This plus other "how to best utilize Excel" courses will make me dangerous!
Member's Profile
I found it difficult to stay engaged with this presentation and believe there are better Excel focused presentations available from Proformative.
4
Member's Profile
Mr. Turner demonstrated a comprehensive budgeting solution in Excel which could work well if it is monitored and managed carefully.
5
Member's Profile
Practical, good overview. Nothing. Operations people or people who have never had exposure to budgeting
3
Anonymous Author
Interesting to see how Mr. Turner creates a budget. There are a few tips that I maybe able to implement.
5
Anonymous Author
Very easy to follow and provided thoughts to incorporate into my modeling
5
Anonymous Author
would like this course to be even longer. Question 2 is a bit misleading.
Anonymous Author
good to remind me of the basics of excel financial simulation
5
Member's Profile
Good tips on working with other groups and leveraging Excel
4
Anonymous Author
Good basic course, would love to see more depth...
5
Member's Profile
Great course! learn the full budgeting process.
4
Anonymous Author
I like the detailed templates in Excel.
4
Anonymous Author
The excel templates are very helpful.
5
Member's Profile
greater details of linking B/S and C/f
4
Member's Profile
Good review of budgeting with Excel
5
Anonymous Author
very organized; valuable tips
4
Member's Profile
Excellent presentation!
4
Member's Profile
Good basic course
5
Member's Profile
clear and concise
5
Anonymous Author
Enjoyed the demos
3
Anonymous Author
Good overview.
5
Member's Profile
Great course!
4
Anonymous Author
Good overview
5
Member's Profile
Great course!

Prerequisites

Course Complexity: Intermediate

Prerequisite: Basic proficiency with financial modeling and Excel

 

Advanced Preparation: None

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
Budgeting in Excel
  5:04Working with Operations
  13:45Demo 1
  3:39Budget Timing
  6:03Excel Structure
  9:16Demo 2
  7:57Beyond Excel
Continuous Play
  49:37Budgeting in Excel
SUPPORTING MATERIALS
  PDFSlides: Budgeting in Excel
  PDFBudgeting in Excel Glossary/Index
BUDGET GUIDES
  XLSXManufacturing Budget
  XLSXCentral Budget
  XLSXMarketing Budget
  XLSXMaster Budget File
  XLSXSales Budget
REVIEW & TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM