The basic Excel modelling course covers key concepts, best practice rules, modeling templates, excel shortcuts, cashflow modeling, debt modeling, 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. Many clients on the Gold package choose to have a one and a half hour intensive session over Skype to cover the whole of the basic course.
The intermediate modelling 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 10 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 intermediate course we also offer invaluable interview advice. This covers (1) how to pass modelling test, (2) how to pass case studies and (3) what are the critical skills that employers are looking for from modelers. These lessons will enable you to be confident for interviews and make a positive impression.
The advanced course builds on the previous two courses. Here you will take your modelling to the next level and put it together with commercial thinking. The first two lessons cover model design from a supply and demand side.
On the technical side we cover, balance sheet, CGT, dividends and how to use decision trees for those really complex tax calculations as well as how to handle circular references.
Finally we look at some simple VBA to enable more scalability. This is particularly helpful for those modelling portfolios.
