are macros and vba used in consulting ?
as a junior consultant, should we have those skills ?
thanks
Macros and VBA
Übersicht der Antworten
Upvotes
Beste Antwort
Hello,
In my experience at McKinsey, macros were used infrequently and VBA was not used at all. The McKinsey work laptops came pre-programmed with a set of excel macros that we were all given instructions on using during onboarding. Occasionally consultants working on finance or tech projects coded or used macros beyond that suite. But we did not need to use them often, and there was certainly no expectation for incoming junior consultants to have those skills already - you will be taught anything you need to know on the job. I wouldn't worry about macros and VBA.
War diese Antwort hilfreich?
You shouldn't worry about this. You are taught what you need to know.
Answering the questions: Macros yes. VBA no.
Having said this, notice two things:
- There are other analytical tools that right now are seen as much more relevant (e.g. alteryx, tableau, …)
- I still don't know how to build a macro and nevertheless was super-successful as an analyst.
Learnt it if you want to learn it.
War diese Antwort hilfreich?
Hi there,
Yes they're used but they're absolutely nice-to-haves.
Your focus should be a LOT more on “standard" excel work and being efficient/smart with that (indexmatch, pivot-tables, etc.)
War diese Antwort hilfreich?
These are nice to have skills and they might save you some time during an engagement or help to impress a colleague/client (or not at all - depending on the situation) but based on my personal experience at McK they were not required from a new joiner consultant.
Typically you will have a higher ROI from investing time in other skills initially.
Best,
Slawomir
War diese Antwort hilfreich?
Hi!
Yes, they're used (especially macros).
However, you shouldn't worry about having those skills before joining. You'll learn by doing while at the firm.
Best,
Anto
War diese Antwort hilfreich?
Verwandte Cases
Unternehmenscase von Bain & Company
Du erbst von deinem 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
...
Du erbst von deinem 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 de
...
(Ganzen Case öffnen)
118,1 T.
mal gelöst
Fortgeschritten
Schwierigkeitsgrad
Expertencase von Francesco
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
...
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 stude
...
(Ganzen Case öffnen)
31,6 T.
mal gelöst
Schwierig
Schwierigkeitsgrad
Expertencase von Bernard
The COVID-19 pandemic has killed millions of people worldwide and led to devastating economic impact. A vaccine is one of the biggest hopes for stopping the pandemic. The World Health Organization (WHO) is working with multiple stakeholders to ensure groups at higher risk of becoming infec
...
The COVID-19 pandemic has killed millions of people worldwide and led to devastating economic impact. A vaccine is one of the biggest hopes for stopping the pandemic. The World Hea
...
(Ganzen Case öffnen)
18,3 T.
mal gelöst
Schwierig
Schwierigkeitsgrad
Expertencase von Luca
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
...
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, Espr
...
(Ganzen Case öffnen)
17,4 T.
mal gelöst
Schwierig
Schwierigkeitsgrad
Expertencase von Francesco
Our client is a BlissOttica, an Eyewear Manufacturer that is looking to reach a 10% increase in profits. How would you help our client?
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)
13,6 T.
mal gelöst
Fortgeschritten
Schwierigkeitsgrad
Verwandte Unternehmen
Premium + Coaching-Experten
Top-Ranked Coach on PrepLounge for 3 years| McKinsey San Francisco | Harvard graduate | 6+ years of coaching
67
Meetings
8.477
Q&A Upvotes
25
Awards
29 Bewertungen
Verwandte Produkte
McKinsey Solve Game Simulation Package von Francesco
Einstieg ins Consulting - All-in-One für Strategieberatungen von Alexandre
Einstieg in die Consultingbranche - Branchenübersichten von Alexandre
Einstieg ins Consulting - Frameworks, die ich gerne gewusst hätte von Alexandre
Imbellus Test von McKinsey – Guide von Luca
McKinsey Imbellus Solve Game Secrets von Francesco
