Verabrede dich zum Casen über das Meeting-Board, nimm an Diskussionen in unserem Consulting Q&A teil und finde gleichgesinnte Interview-Partner:innen, um dich auszutauschen und gemeinsam zu üben!
Zurück zur Übersicht

What Computer skills do you need in MBB to succeed as a consultant? List some tools or programming languages.

8
3,3k
26
Schreibe die erste Antwort!
Bisher hat niemand auf diese Frage reagiert.
Beste Antwort
Clara
Coach
am 31. Okt. 2020
McKinsey | Awarded professor at Master in Management @ IE | MBA at MIT |+180 students coached | Integrated FIT Guide aut

Hello!

Although some people get to see some Tableau and R, 99% of people deal only with Excel. 

Indeed, iff 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:

  • Microsoft Support: https://support.office.com/en-us/excel
  • Kubicle: https://kubicle.com/personal (go for the 7 days free trial - Excel for Business Analytics)

Hope it helps!

Cheers,

Clara

am 31. Okt. 2020
#1 Coach for Sessions (4.500+) | 1.500+ 5-Star Reviews | Proven Success: ➡ interviewoffers.com | Ex BCG | 10Y+ Coaching

Hi there,

Mostly Excel and PowerPoint. Mastering Excel is particularly important to increase productivity and speed. Knowing how to work with macros is a nice-to-have but not strictly required skill.

Best,
Francesco

Gaurav
Coach
am 31. Okt. 2020
#1 MBB Coach(Placed 750+ in MBBs & 1250+ in Tier2)| The Only 360° coach(Ex-McKinsey+Certified Coach+Active recruiter)

It depends on the role. But, the most important tools you will need are Excel and PowerPoint.

GB

Ken
Coach
bearbeitet am 31. Okt. 2020
Ex-McKinsey final round interviewer | Executive Coach

In order of descending importance:

MS Powerpoint
MS Excel
(Internal expense system)
Alteryx
Tableau (nice-to-have)

Gelöscht
Coach
bearbeitet am 30. Okt. 2020
15 years in Strategy & Transformation. Was Practice Lead in Accenture Strategy leading team of 45 consultants.

Hi,

I believe  in management consulting, the all weather handy tools are MS Excel, MS Powerpoint and MS Word ( rarely used now). But global institutions or Govt agencies mostly want the output/report in MS Word. 

If you are doing lot of PMO roles, good to know MS Project. If you are working in capital projects, need to know Primavera. 

If you are doing lot of process related work, knowing ARIS, Visio helps.

If there is a need to learn anything beyond this depending on the project, believe you will get the requisite training from the firm itself. 

Thanks

Ian
Coach
am 30. Okt. 2020
Top US BCG / MBB Coach - 5,000 sessions |Tech, Platinion, Big 4 | 9/9 personal interviews passed | 95% candidate success

Hi there,

At MBB, you will be able to learn them on the job (ample training, mentoring etc.). That being said, the tools you need you learn, in order of importance are:

  1. PowerPoint
  2. Excel
  3. Alteryx
  4. Tableau
  5. Nothing else

You won't be able to get away with not knowing PowerPoint/Excel. You may never have a project that requires Alteryx/Tableau. You will never, ever, need to learn a programming language.

Gelöschter Nutzer
am 31. Okt. 2020

It's mainly four tools that you'll need:

  • Powerpoint
  • Excel
  • Tableau
  • Alteryx

I don't think it makes a ton of sense to practice powerpoint, as all firms have their internal plugins that provide additional and simplified functionality to the regular version. Practicing without that doesn't make a lot of sense.

For all the others you'll find tons of materials out there to preparte. 

9
Mehdi
Coach
am 31. Okt. 2020
BCG | Received offers from all MBB & Tier 1Firms | Supporting you secure your top tier consulting offer

Hi there,

I would advise you to master Analytical tools (Alteryx, Tableau, Qlickview, etc.). Excel would help you meet the basic expectations for Analysts, while Tableau/Alteryx would definitely make you standout!

All the best, 

Mehdi

Ähnliche Fragen
Consulting
BCG Knowledge DIRECTOR SALARY
am 31. Mai 2024
Global
6
3,5k
Beste Antwort von
Florian
Coach
1400 5-star reviews across platforms | 600+ offers | Highest-rated case book on Amazon | Uni lecturer in US, Asia, EU
80
6 Antworten
3,5k Aufrufe
+3
Consulting
When can I expect to hear back from BCG Final/Decision Round for North America Intern
am 27. Juni 2024
Global
6
5,7k
Beste Antwort von
Hagen
Coach
#1 recommended coach | >95% success rate | 8+ years consulting, 8+ years coaching and 7+ years interviewing experience
250
6 Antworten
5,7k Aufrufe
+3
Consulting
BCG First Round Behavioral
am 24. März 2025
Global
6
3,3k
Beste Antwort von
Lorenzo
Coach
IESE MBA | Bain&Co | OC&C | Private Equity | Consumer Goods
70
6 Antworten
3,3k Aufrufe
+3
Wie wahrscheinlich ist es, dass du uns einem Freund oder Kommilitonen empfiehlst?
0 = Nicht wahrscheinlich
10 = Sehr wahrscheinlich
Vielen Dank für dein Feedback! Deine Meinung hilft uns, PrepLounge noch besser zu machen.