Not sure which course is right for you? Fill in our needs analysis form, and we’ll get back to you with our recommendations.
Public courses are held in the CBDs of Sydney, Melbourne and Brisbane. Please bring a jacket as seminar rooms can be cool at times. It is usual for each student to be asked to briefly introduce themselves at the beginning of the day. Please advise if you would prefer not to do this.
As part of the course you will receive:
- A copy of the book Using Excel for Business Analysis, and/or a course exercise manual. (Please check the course outline to see which courses include a copy of the book.)
- USB memory stick on which to save your models
- Lunch, tea and coffee
Public courses are run in a computer laboratory and workstations are provided so that participants can work in Excel on practical applications of content covered in the course. The course is normally demonstrated using Excel 2016 and participants can choose to use a previous version of Excel if they prefer. If participants are more comfortable using their own laptops, they are most welcome to bring their own equipment. PCs are used during this course, so Apple Macintosh users may prefer to bring their own laptops.
Each version of Excel differs somewhat but it does not really matter which version you are using, as the machines used during class have several different versions installed so students may use whichever version they prefer. If you’re not sure which version you are using, and for an overview of the major differences between versions, please see the blog article Which version of Excel am I using?
A reasonable level of Excel is required for these courses. They are designed for users who use Excel fairly regularly, and are comfortable with using formulas and know their way around the basic functions of Excel. It is assumed that students will know how to link between worksheets, and create some formulas. These courses are not designed to teach Excel, rather the use of Excel in a modelling situation. Formulas such as VLOOKUP, SUMIF and IF and AND are used, and if they are not already known by the students they will be covered briefly. Complex formulas are documented in the course manual or book received by each student.
If you would like to brush up on your Excel skills prior to coming on a course, Plum Solutions has compiled a list of free Microsoft Excel tutorials which are most relevant to Financial Analysis. You might also consider Chandoo’s online Excel School prior to coming on the course.
Each student will build their own model/s during the day/s and can bring them home with them. Students will be supplied with a 1GB USB memory stick on which to save their work and take it away. If your company does not allow use of external drives it can be emailed to you.
A pre-course survey will be distributed to assess your skill level prior to coming on the course. If you are unsure about your suitability for this course or have any other questions, please phone our office on 0298187250.
Post Course Support
Arrange an in-house training session for your organisation.
Enrol in an online course and get started straight away
Book a Course in Your Area
|Financial Modelling in Excel (Melb)||Melbourne - 500 Collins Street||
|Melbourne Meetup: The Power and the Pitfalls of Discounted Cashflow (DCF) Modelling||Meetup||
|Dashboard Reporting in Modern Excel (Melb)||Melbourne - 500 Collins Street||
|Power BI and Power Pivot for Excel (Syd)||External Workshop||
|Sydney Meetup: Stochastic vs Deterministic Approaches to Financial Modelling||
|Professional Certificate in Financial Modelling (Dubai)||External Workshop||
|Financial Modelling in Excel (Syd)||Sydney - 10 Barrack Street||
|Advanced Financial Modelling in Excel (Syd)||Sydney - 10 Barrack Street||
|Dashboard Reporting in Modern Excel (Syd)||Sydney - 10 Barrack Street||
|Power BI and Power Pivot for Excel (Bris)||External Workshop||
|Power BI and Power Pivot for Excel (Melb)||External Workshop||
|Advanced Financial Modelling in Excel (Melb)||Melbourne - 500 Collins Street||
|Financial Modelling in Excel (Bris)||Brisbane - 300 Adelaide Street||
|Advanced Financial Modelling in Excel (Bris)||Brisbane - 300 Adelaide Street||
|Dashboard Reporting in Modern Excel (Bris)||Brisbane - 300 Adelaide Street||