SPECIALISTS IN FINANCIAL MODELLING

Advanced Financial Modelling in Excel

Jan 8, 2018

Can’t make it to a workshop?  Enrol in the online version of the Financial Modelling course, and start straight away!  Complete the course at your own pace. This course is part of the Financial Modelling Online Series:
  1. Financial Modelling for Non Financial Modellers
  2. Financial Modelling in Excel (Intermediate)
  3. Advanced Financial Modelling in Excel
Buy all three courses at once and save, PLUS you’ll get a copy of Using Excel for Business and Financial Modelling included as well as Financial Modeling in Excel for Dummies! Or, get the online Intro course included if you sign up for the Financial Modelling Workshop bundle. In the ever-changing business environment, being able to accurately model and forecast the volatile economic inputs is a critical skill for business professionals. Build on your existing modelling skills and apply new techniques to better analyse financial data, predict revenues and cost and assess risks to justify business decisions in the most time-efficient and effective way. More detail about how the online courses work

Who should complete this course?

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 those who have already undertaken the Introduction and/or Intermediate Financial Modelling in Excel courses or users who do use Excel on a regular basis, and are comfortable with using its tools and functions. Download the course outline here

What are the prerequisites for taking this course?

At minimum, it is assumed that participants will know how to: •    Navigate confidently in Excel •    Use absolute cell references (e.g. =$A$1) •    Create and use advanced Excel tools and functions on a regular basis This course builds on students’ advanced knowledge of Excel tools and functions and incorporates these into complex and dynamic financial models. More detail about how the online courses work

How do I purchase?

Scroll to the bottom of this page, tick the box and add it to your cart.  Once you’ve gone through the shopping cart, you will gain access to the course.  You’ll need to be logged in in order to view the content.

Testimonials

Hear what past students have to say about the online Advanced Financial Modelling course:

Modules in this Course

3.1 Theory and Best Practice
•    Choosing between Excel versions •    Overview of best practice financial modelling techniques •    Common Excel error values in financial modelling •    Correcting  and suppressing errors •    Locating and fixing circular references •    Allowing iterative calculations when circular references are maintained
3.2 Advanced Tools and Functions
•    Selecting the formula or tool which is most appropriate for each modelling situation •    Nesting formulas •    Useful functions in financial modelling such as COLUMN, CHOOSE, OFFSET, LOOKUP and TRANSPOSE •    Using LOOKUP functions in tiered pricing models (volume break discounting) •    Pros and cons of using array functions and their use in financial modelling •    Use of form controls such as spin buttons and combo boxes
3.3 Advanced Techniques
•    Rebuilding an inherited model •    How long should a formula be?  Deciding when to break a complex formula in several steps to maintain transparency and allowing ease of model auditing •    Comparison of different methods of modelling escalation and growth calculations •    Presenting model output using a chart on two different axes  and chart types •    Creating a Waterfall Chart in Excel •    Pivot tables – summarise, dissect and analyse large amounts of data •    Why pivot tables are not commonly uses in financial modelling, and other alternative tools •    Automate your financial model for the user with Macros.  Recording and modifying VBA code and creating macro buttons
3.4 Scenarios & Sensitivity Analysis
Learn different methods of what-if, scenario and sensitivity analysis in Excel using: •    Show multiple scenario outcomes simultaneously with one and two-dimensional  Data Tables •    Learn how to automatically highlight selected scenarios using complex conditional formatting •    Using the Scenario Manager •    Manual scenario building – In-cell drop-down boxes – Combo-box drop down boxes At each step during the course, participants build and practice each formula, tool and technique.  Record your own macro with buttons, build a pivot table, and create drop-down boxes.
3.5 Practical Financial Modelling Building on the tools and techniques covered, we will learn to apply advanced modelling skills to build complex, yet robust and user-friendly financial models. Factory Rollout Model Working on a startup funding model from start to finish we will evaluate input assumptions, calculate revenue and costs of production to calculate cash requirements.  From this, we build a full set of financial statement with particular emphasis on linking the profit & loss statement, cash flow statement and balance sheet together. Utilising the tools and techniques covered in the first part of the course, participants will build their own financial model case study, performing stress testing, scenario and sensitivity analysis on their model.
Price: $240.00 ex GST
Take this Course

Course Content

Expand All | Collapse All
468