Modelling Courses Available

IndexMatch offers the best Excel modelling courses and training available online. Learn at your own pace from the comfort of your own home. See the options below.



Basic

The basic course covers key concepts, best practice rules, modelling templates, excel shortcuts, cashflow modelling, debt modelling, calculating NPVs and IRR, sensitivities, scenarios and basic model management. This course progresses step by step so that each new skill is practiced and consolidated before moving on.

Having mastered this content you would be able to pass most modelling tests.



Advanced

The Advanced course builds on the tools learnt in the basic course to create more complex and more flexible models. It also covers more complex model layouts and how to model across multiple sheets. You will build (7) new models and by the end of the course feel confident in your new skill. Additionally there are a number of lessons on efficient and robust data management.
In the Advanced course we also offer invaluable interview advice. This covers (1) how to pass modelling test , (2) case studies and (3) what are the critical skills that employers are looking for from modellers. These lessons will enable you to be confident for interviews and make a positive impression.



Property

The property course sets a number of property specific modelling challenges using many of the techniques and approaches covered in the basic, intermediate and advanced course. As always our courses come with a lot of opportunity to practice modelling.

It also covers useful property specific definitions and approaches to valuation. By the end of this course you will be completely clear on the difference between implicit and explicit valuation methodologies as defined by RICS, market values, investment values, estimated rental values (ERVs), all risk yields, reversionary and equivalent yields, reversionary investments, rent reviews and gearing. Additionally, it covers waterfall deal structure, cash sweep and modelling of the multiple debt repayment methods. The course will also show you how to scale your model in three different ways: multi-sheet, using VBA and across sheet.

If you work in property and want to improve your analysis skills then this course is for you.



Securitisation

The securitisation course is a 2 day face-to-face course covering the business and modelling principles of securitisation modelling. The first day covers the asset side and the second day covers the liability side of securitizations.

This course is perfect for organizations wishing to develop a house style and approach to securitisation modelling. Through the course the participants will build all the elements of a secuirtisation model and then use it to provide commercial advice.

Get in touch with us for more details.

Online access to the course is also available at a reduced price via the sign up page.

Interview

If you are applying for a new job and part of the interview process is a modelling test then this package is for you.

This package includes access to the basic and intermediate modelling course, 2 modelling tests and 2 hours of personal coaching. Together these will give you the skills and experience you need to ace a modelling test and land your dream job.