Instructor Led Efficient Training Classes in Australia

VBA for Financiers ...ature in today s Financial Models and provides us with an efficient way to solve advanced numerical problems and create user friendly and transparent analysis. However if it is not used appropriately it can cause more problems than it solves. This course gives you the skills and confidence to write your own code and expand your analytical skill set beyond the standard Excel functionality. It  more...

Debt Modelling Masterclass ...o control sculpted principal repayment * Establishing efficient mechanics for debt focused cash sweep payback calculations without complicating Debt Accounts mechanics * Discussion on commonly documented Pre-Payment methods using Inverse Order of Maturity and Pro Rata repayment mechanics Debt Service Reserve Account * An overview of the elements of the Cashflow Waterfall  more...

Project Finance Modelling ... * the proven infrastructure of a Navigator model * efficient coding of operational cashflows * the theoretical mechanics of debt repayment * how to use 1D data tables for instant scenario analysis * the basics of presenting and reviewing a model * and many other useful tools and functions Throughout the course we will demonstrate smart ways to use the Excel environment,  more...

Financial Modelling Fundamentals ...anding and use of Excel as an important tool to work more efficiently then this is the course for you! This two-day interactive workshop will give your Excel knowledge a kick-start, as we work through the key functions and applications for the financial sector. The focus during the course will range from file management and presentational features to more advanced functions, including named  more...