Resources on training/ coaching for Excel Financial modelling

Hi Grace,

It's great that you are showing initiative and enthusiasm to improve your capabilities!

First off, a couple of contextual questions for you that will help me and other coaches to give you a better response:

1. What is your current situation and motivation - i.e. are you already in MBB and looking to learn how to model for an ongoing case; are you still interviewing and picking up this skill in anticipation of the future need for it etc?
2. What is your current level of familiarity with excel?

Now a couple of general points on modelling on the job in consulting:

1. You are right that most modelling courses are IB focused
2. There are very few (if any at all) consulting focused model courses, because the needs of a consulting ‘business model’ can really vary very widely 
3. While a good model is of course important and will help the case and your workstream, the reality is that consultants are not the best modellers per se, and we are often hired more for other core skills
   • There is a running joke with some of my banking/investment clients that they always pull their hair out after looking at our consultant's models (because they are not as good as those the bankers make)
   • The best modellers are often those with previous banking/transaction experience prior to consulting, but these profiles are the minority not the majority
   • Sometimes a scrappy model still gets the job done (though not elegantly) and for practicality, it works

In terms of improving modelling skills, I would break down modelling into 2 components:

1. Formatting, Layout, & Structure (Technical)
   • This is everything to do with how the model should be formatted in order to make information clear; best practices on how the model is structured (in terms of sheets) in order to let readers easily understand the model
   • You could also include learning the best/optimal formulas here (e.g. index match match or xlookup vs trying a vlookup)
2. Logic and Quantitative/Qualitative Reasoning (Thinking)
   • This is the crucial and critical part that drives the answer, and is the real value add that a MBB consultant brings to a model
   • Here, you are expected to structure the calculations logically, think critically about drivers and assumptions

So what are your options and the implications?

1. If you do an online course focused on IB financial modelling
   • I would suggest focusing only on “Financial Statement” modelling. DCF is extremely rare, and i have not seen LBO models during my 8 years of consulting
   • Even then, on the multiple cases I worked, we/client often outsourced a full 3-statement model to Big4 or a transaction company
   • Getting trained in IB financial statement modelling will teach you to the ‘gold’ standard of modelling, and prepare you in the rare event you need to do a full 3 statement model
   • However, you may not get fully drilled in the ‘thinking’ portion of modelling
2. If you hire a coach, as you suggested
   • I or other coaches could help you, but whoever you choose to work should be someone who has done a lot of modelling and/or supervised multiple models
   • Strategy cases do have models, and definitely people in the PE practices would have done tons of models and projections
   • One thing that consulting coaches here can definitely help you with is to train and develop the ‘thinking’ portion of modelling, which IMO is the most value add a consultant can bring to a model

Happy to chat if you have more questions. Hope this helps!

(edited)