Macros and VBA

Actively preparing for interviews with AT Kearney Mckinsey & Bains basic membership BCG gamma Interview McKinsey MBB
New answer on Sep 26, 2021
5 Answers
1.5 k Views
Anonymous A asked on Sep 24, 2021

are macros and vba used in consulting ?

 

as a junior consultant, should we have those skills ?

 

thanks

Overview of answers

Upvotes
  • Upvotes
  • Date ascending
  • Date descending
Best answer
Sofia
Expert
replied on Sep 25, 2021
Top-Ranked Coach on PrepLounge for 3 years| McKinsey San Francisco | Harvard graduate | 6+ years of coaching

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.

Was this answer helpful?
Pedro
Expert
replied on Sep 26, 2021
30% off in March 2024 | Bain | EY-Parthenon | Roland Berger | Market Sizing | DARDEN MBA

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.

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

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.)

Was this answer helpful?
Slawomir
Expert
replied on Sep 25, 2021
Former McK interviewer, PhD who successfully transitioned from Academia, received offers from McK/BCG/Bain/LEK

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

Was this answer helpful?
Antonello
Expert
Content Creator
replied on Sep 26, 2021
McKinsey | NASA | top 10 FT MBA professor for consulting interviews | 6+ years of coaching

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

Was this answer helpful?
Sofia gave the best answer

Sofia

Premium + Coaching Expert
Top-Ranked Coach on PrepLounge for 3 years| McKinsey San Francisco | Harvard graduate | 6+ years of coaching
67
Meetings
8,353
Q&A Upvotes
25
Awards
5.0
29 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