Schedule mock interviews on the Meeting Board, join the latest community discussions in our Consulting Q&A and find like-minded Interview Partners to connect and practice with!
Back to overview

Macros and VBA

are macros and vba used in consulting ?

 

as a junior consultant, should we have those skills ?

 

thanks

5
2.3k
18
Be the first to answer!
Nobody has responded to this question yet.
Top answer
Deleted user
on Sep 25, 2021

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.

18
Pedro
Coach
on Sep 26, 2021
Bain | EY-Parthenon | Former Principal | 1.5h session | 30% discount 1st session

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.

Ian
Coach
on Sep 26, 2021
Top US BCG / MBB Coach - 5,000 sessions |Tech, Platinion, Big 4 | 9/9 personal interviews passed | 95% candidate success

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

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

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

Similar Questions
Consulting
Best Time to Apply to MBB as an Experienced Hire
on Oct 04, 2024
Global
4
2.0k
Top answer by
Hagen
Coach
#1 recommended coach | >95% success rate | 8+ years consulting, 8+ years coaching and 7+ years interviewing experience
70
4 Answers
2.0k Views
+1
Consulting
Trading public stocks prohibited in McKinsey?
on Feb 12, 2025
Global
5
1.8k
Top answer by
Hagen
Coach
#1 recommended coach | >95% success rate | 8+ years consulting, 8+ years coaching and 7+ years interviewing experience
50
5 Answers
1.8k Views
+2
Consulting
Which questions to ask over a coffee chat with an MBB consultant?
on Oct 11, 2024
Global
2
2.6k
Top answer by
Alessa
Coach
xMcKinsey & Company | xBCG | +200 individual & group coachings | feel free to schedule a 15 min intro call for free
47
2 Answers
2.6k Views