Excel / financial modeling skills required (experienced hire) and how to develop?

Excel financial modeling
New answer on Jun 12, 2021
1 Answer
491 Views
Anonymous A asked on Jun 12, 2021

Once in a while, I see consultants mention that they do "complexed modeling" in projects. For post MBA roles, what would be a consultant's required excel skill and financial modeling skill in these 2 different circumstances: (1) generalist role (2) Corporate Finance / M&A practice?

I'm curious how complexed the model would be in consulting, as I would imagine many projects (such as quantifying synergy, assessing an acquisition's impact, etc) wuold also be quite quantitative and the impact needs to be quantified.

Also, as consultants join from different background, how do they develop excel / financial modeling skill on the job? 

Overview of answers

Upvotes
  • Upvotes
  • Date ascending
  • Date descending
Best answer
Ian
Expert
Content Creator
replied on Jun 12, 2021
MBB | 100% personal interview success rate (8/8) and 95% candidate success rate | Personalized interview prep

Hi there,

I wouldn't worry too much about this until you join -you should get trained extensively at the company through orientation, intranet portal resources, and on-the-job learning.

Of course, it shouldn't be a surprise that a Corporate Finance/M&A practice role requires more excel/financial modeling skills than a generalist role!

In terms of skills, you will need to be quite proficient at Excel, depending on the client/project. This does not mean knowing VBA! Just as an example, you'll need to know functions like indexmatch, pivot tables, data cleaning/manipulation, modeling, etc.

Was this answer helpful?
Ian gave the best answer

Ian

Content Creator
MBB | 100% personal interview success rate (8/8) and 95% candidate success rate | Personalized interview prep
820
Meetings
54,537
Q&A Upvotes
163
Awards
5.0
99 Reviews