What Computer skills do you need in MBB to succeed as a consultant? List some tools or programming languages.
Übersicht der Antworten
Upvotes
Beste Antwort
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
War diese Antwort hilfreich?
It depends on the role. But, the most important tools you will need are Excel and PowerPoint.
GB
War diese Antwort hilfreich?
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
War diese Antwort hilfreich?
In order of descending importance:
MS Powerpoint
MS Excel
(Internal expense system)
Alteryx
Tableau (nice-to-have)
(editiert)
War diese Antwort hilfreich?
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.
War diese Antwort hilfreich?
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:
- PowerPoint
- Excel
- Alteryx
- Tableau
- 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.
War diese Antwort hilfreich?
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
(editiert)
War diese Antwort hilfreich?
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
War diese Antwort hilfreich?
Verwandte Cases
Themen:
Der in seiner Heimatregion äußerst erfolgreiche asiatische Premiumhersteller von Schmierstoffen, LubricantsCo, möchte seinen Umsatz und Gewinn weiter steigern. Die Produktpalette erstreckt sich von Schmierstoffen im automobilen Umfeld (z. B. Motor- und Getriebeöl) bis zu Industrieanwendungen (z. B.
... (Ganzen Case öffnen)
197,1 Tsd.
mal gelöst
Anfänger
Schwierigkeitsgrad
Themen:
Sie erben von Ihrem Großvater ein Weingut, die Old Winery, welche sich seit fünf Generationen in Familienbesitz befindet und bis ins 16. Jahrhundert datiert werden kann.Auf den elf Hektar der Old Winery werden konventionell, d.h. nicht biologisch betrieben und zertifiziert, je zur Hälfte weiße und r
... (Ganzen Case öffnen)
101,4 Tsd.
mal gelöst
Fortgeschritten
Schwierigkeitsgrad
Expertencase von Francesco
Themen:
Our client is SmartBridge, a nonprofit educational institution offering face-to-face tutoring services. The client operates in the US.The mission of SmartBridge is to help as many students as possible to complete studies and prevent that they drop from the school system, in particular in disadv
... (Ganzen Case öffnen)
28,2 Tsd.
mal gelöst
Schwierig
Schwierigkeitsgrad
Expertencase von Luca
Themen:
Espresso Whatelse is an Italian company that produces coffee and espresso machines since 1908. It is the Italian market leader and has a strong presence overall in Europe. In 2019, Espresso Whatelse has increased its revenues but it has seen declining profit margin.Your client wants to understa
... (Ganzen Case öffnen)
15,9 Tsd.
mal gelöst
Schwierig
Schwierigkeitsgrad
Expertencase von Francesco
Themen:
Our client is a BlissOttica, an Eyewear Manufacturer that is looking to reach a 10% increase in profits. How would you help our client?
... (Ganzen Case öffnen)
11,3 Tsd.
mal gelöst
Fortgeschritten
Schwierigkeitsgrad
Content Creator
McKinsey | Awarded professor at Master in Management @ IE | MBA at MIT |+180 students coached | Integrated FIT Guide aut
68
Meetings
22.754
Q&A Upvotes
121
Awards
57 Bewertungen
Verwandte Produkte
Break Into Consulting - Strategy Consulting Firm's All-In-One von Alexandre
Break Into Consulting - Industry Overviews von Alexandre
Break Into Consulting - Frameworks I wish I knew von Alexandre
BCG Online Case Combo: Software Simulation von Francesco
BCG Online Case Secrets von Francesco
BCG Potential Test #2 von Gaurav
BCG Potential Test #1 von Francesco
Prep Guide for McKinsey PST von PrepLounge
McKinsey PST #2 von Gaurav
