Duration : 1 day
Cost: $990.00 inc. GST.
""I really enjoyed the course. It gave me a much needed confidence boost to see that my skills were still fine! It was good to hear about putting a model together in a good way and has really motivated me to work with the ones I have inherited to improve them going forward.""
Interested in taking this course online? Register your interest now!
This practical course covers issues such as using budgets to measure staff performance, linking budgets to the strategic planning process and a comparison of budgeting techniques. We explore the difference between budgets and forecasts, and learn how to create your own budget, rolling forecast, variance report and budget scenarios in Excel.
Each participant on this course receives a hard copy of the book Using Excel for Business Analysis. Re-using your copy, got several participants or want to book on multiple courses? Consider making a bulk booking and save.
The course material includes extensive use of Excel and participants will gain the maximum benefit from this course if they are already competent spreadsheet users. It is designed for users who do use Excel on a regular basis, and are comfortable with using its tools and functions.
At minimum, it is assumed that participants will know how to:
If you are unsure about your level of Excel, you might also consider joining the online Excel School prior to coming on the course.
Public courses are run in a computer laboratory with workstations provided. Participants may bring their own laptops if they prefer. The course is demonstrated using Microsoft Excel 2013, but participants can use Excel 2007 or 2010 if they prefer. Course materials contain instructions for different versions, and Excel 2011 for Mac users are also catered for. Those who would like to use a Mac are most welcome to bring their own laptops.
This one-day course is delivered in two parts; the first part of the day covers the theory of budgeting and forecasting within organisations. Issues such as budgeting to organisational objectives, level of granularity and selecting the correct budgeting tool will be discussed. Students are encouraged to share their own experiences with the class.
In the second part of the day, participants will build their own budget and forecasting models to bring a practical application to the skills they have learned. The model will include a budget, rolling forecast, variance report as well as scenarios and sensitivity testing. During the course, participants will create their own Excel budgets & reporting analysis to take away with them. Each participant is provided with a USB memory stick on which they will be able to take their files away for future reference.
“An excellent combination of technical and practical applications to financial forecasting, control and budgeting.”
"The instructor has years of experience and was able to solve any problems or questions we had in the course."
"I was highly impressed with facilities, equipment and material provided. This course should be a core requirement for anyone considering undertaking an analytical role. I feel the course has provided me with the confidence to address stakeholders in discussing forecasting and budgeting - especially the procedure and method of approach. I'll be back for another course!"