Excel skills

Excel
New answer on Apr 22, 2022
5 Answers
1.3 k Views
Anonymous A asked on Apr 21, 2022

Hi all! Kicking off at one of the MBBs soon. Understand there will be powerpoint and excel training. Can anyone please advise what home prep is best to do beforehand? How strong excel modelling skills are required e.g. making balance sheet balance, DCF, LBO models or just knowledge of the basic formulas (vlookup, choose, indexmatch etc.)

Thanks!

Overview of answers

Upvotes
  • Upvotes
  • Date ascending
  • Date descending
Best answer
Florian
Expert
Content Creator
replied on Apr 21, 2022
Highest-rated McKinsey coach (ratings, offers, sessions) | 500+ offers | Author of The 1% & Consulting Career Secrets

Hey there,

If you are interested in preparing for your new role, I'd suggest the following:

95% of your work in Excel will be covered by

  • vlookups
  • index match
  • pivot tables

Unless you are specifically hired as a financial analyst or a consultant in the corporate finance or PE practice, you are not expected to create any more advanced financial models. Usually, for each, the firm has its own training materials and preferred way of structuring those anyway.
 

When I got the offer some years ago I did the same. I reached out to people I knew in McKinsey and people who interviewed me to ask: what can I do to make the start easier? how can I prepare?

The answer from everyone was: Relax! Enjoy your time before you start and don't think about it. You will figure it out on the job. I followed that advice and it made sense to me once I joined.

When you start at MBB there are 2 ways to learn:

  1. Formal training. The formal training sessions/ weeks/ days in the beginning, are nice, however, they are more for networking and meeting your peers. You learn some interesting concepts and get some useful tips from more experienced consultants BUT
  2. Constant and implicit learning on the job is where it's at. No matter if you are a newcomer or a veteran after 2 years, you will always find yourself on a steep learning curve. As soon as you barely mastered one skill or the skills needed for one level in the hierarchy, you will take care of things, which are expected from a more senior colleague. This cycle never ends. You are expected to learn on the job, learn from your colleagues, your mentors, sometimes even the client. So basically a newly promoted Engagement Manager has the same 'struggle' as a new-hire Business Analyst. They both need to work in a completely new environment and role.

Knowing that, if we now go back to square one in your consulting journey it makes perfect sense to enter the firm with a blank slate with a lot of curiosity and eagerness to soak it all up and quickly learn the ropes.

No book, no training, no coach can prepare you for your first day, your first week, your first engagement. Nothing matches the experience and the learning and this is a good thing (also the reason why ex-consultants are valued highly on the job market).

You will learn everything you need to master while doing it. You will be thrown in the cold water and need to swim. However, your colleagues will always be happy to help you and mentor you. And for the rest, you will figure everything out along the way. The key here is always to ask for tips, shortcuts, feedback, etc. Don't be quiet if you get stuck.

Also, for every technical problem (IT, Excel question, etc) McKinsey has a Global Helpdesk and the rule is to call them for every problem you can't solve within 5 minutes. They will fix your computer, guide you through Excel formulas, etc. I am sure other MBB have a similar format.

Lastly, if you have no domain knowledge about a certain industry or topic, read through the internal library of documentation (which is endless) and call some of the firm experts on the topic. Usually, they are happy to offer you a short call to get you up to speed.

Don't sweat the small stuff and enjoy the ride!

Florian

Was this answer helpful?
Ian
Expert
Content Creator
replied on Apr 22, 2022
#1 BCG coach | MBB | Tier 2 | Digital, Tech, Platinion | 100% personal success rate (8/8) | 95% candidate success rate

Hi there,

MOST IMPORTANTLY: Know that no-one can perfectly prepare for the job and that's the point: You will mess up, you will learn, you will be trained and supported. That's OK!

--------------------------------------------------------------------------------------

First: I have a consulting survival guide handbook with 25 key tips for surviving the consulting world. Feel free to message me for it!

--------------------------------------------------------------------------------------

Second: In terms of things you can learn/do to prepare beforehand:

1) Daily Reading

  • The Economist, The Financial Times, BCG/Mskinsey Insights

2) Industry deep-dives

  • Learn, in-depth, how the industries/companies your office advises, work. (PM me for an industry overview template)

3) Analytics tools

  • Alteryx, Tableau, etc.

4) Excel

5) Powerpoint

  • Best practices/standards
  • Different layouts
  • Quickly editing/updating slides
  • Thinking in PowerPoint

6) Presentation skills / sharp communication

  • There are some online/virtual classes for this

--------------------------------------------------------------------------------------

Third: In terms of doing well in your role when you're there:

1) Understand the context/prompt (what role are you in, what company, who's watching, etc.)

2) Understand the objective (what, specifically, is expected from you...both day to day, and in your overall career progression)

3) Quickly process information, and focus on what's important - Take a lot of information and the unknown, find the most logical path, and focus on that.

4) Be comfortable with the unknown, and learn to brainstorm - think/speak like an expert without being one

In summary, there will always be a flood of information, expectations, competition etc. and not enough timeFind out which ones matter when. (i.e. be visibile and focus efforts on the things that people care about)

--------------------------------------------------------------------------------------

Fourth: Here are some great prior Q&As for you!

https://www.preplounge.com/en/consulting-forum/what-makes-a-good-consultant-how-to-get-a-good-review-6790

https://www.preplounge.com/en/consulting-forum/how-hard-is-it-to-excel-in-top-consulting-firms-6762

https://www.preplounge.com/en/consulting-forum/how-to-become-an-engagement-manager-and-partner-quickly-6722

https://www.preplounge.com/en/consulting-forum/need-to-learn-skills-in-the-ample-free-time-before-starting-at-an-mbb-what-should-i-do-6774

Was this answer helpful?
Anonymous replied on Apr 22, 2022

Hi there,

I actually have a 4 minute video about the only 5 formulas used in consulting over on my nascent Youtube channel - Angelina's Business World. (the video is called “The only 5 Excel formulas you need in consulting REVEALED”) 

I've made that video because when *I* was preparing to start at BCG, I went over a lot of formulas and modelling practice materials that turned out to be useless in practice. So I hope my formula suggestions could save you some time.

Good luck!

Was this answer helpful?
4
Clara
Expert
Content Creator
replied on Apr 22, 2022
McKinsey | Awarded professor at Master in Management @ IE | MBA at MIT |+180 students coached | Integrated FIT Guide aut

Hello!

Congrats of that offer!

If there is one thing I wish I had done before joining McKinsey, that would have been Excel. It can really be a game changer, so I would really focus on that (more than pptx, industry knowledge, etc., that are nice-to-have, but not deal breakers).

Excel skills are part of the core skill-set of consultants, and it´s great that you want to practice them. PFB a list of the most popular commands:

Basic operations: SUM, SUMPRODUCT

Text transformations: CONCATENATE, LEFT, RIGHT, & operator,

Connecting different datasets: VLOOKUP, HLOOKUP, INDEX(MATCH(),MATCH())

Conditional-based operations: SUMIF, COUNTIF, SUMIFS, COUNTIFS, COUNTA

Learn how to analyze data using Pivot Tables

There are plenty of online materials -unfortunately now we cannot post the adress but you can find them easily-

Microsoft Support: support .office

Kubicle: kubicle.com (go for the 7 days free trial - Excel for Business Analytics)

Hope it helps!

Cheers,

Clara

Was this answer helpful?
Ken
Expert
replied on Apr 21, 2022
Ex-McKinsey final round interviewer | Executive Coach

Basic Excel functions such as the one you've listed are always helpful but you will not build any of the complex models that you've listed at an MBB.  At McKinsey, there's no expectations around your Excel modelling where you can learn it on the job (with lot's of support) and there are a wealth of training material that you will have access once/just before you join.

Was this answer helpful?
Florian gave the best answer

Florian

Content Creator
Highest-rated McKinsey coach (ratings, offers, sessions) | 500+ offers | Author of The 1% & Consulting Career Secrets
1,125
Meetings
19,787
Q&A Upvotes
124
Awards
5.0
499 Reviews
How likely are you to recommend us to a friend or fellow student?
0
1
2
3
4
5
6
7
8
9
10
0 = Not likely
10 = Very likely