Excel Skills

Excel
New answer on Jun 08, 2020
6 Answers
2.5 k Views
B
Skilled
asked on Feb 12, 2019

Is it recommended to fresh up Excel skills before a job interview and to include Excel skills in the application?

Overview of answers

Upvotes
  • Upvotes
  • Date ascending
  • Date descending
Best answer
Norah
Expert
replied on Feb 12, 2019
I am here to get you an offer! | Ex MBB interviewer Expert in MBB and Tier 2, Deep knowledge of EU & Middle East regions

Hello Bele,

Thanks for the reach out on the platform!

Not absolutely recommended to fresh up excel skills for strategy consulting interviews, as you won't be tested on those.
However, if you do have strong excel skills (modeling, VBA, Business Plans, valuation), you can highlight those in your CV.
Best of luck in your interviews,
N

Was this answer helpful?
Guennael
Expert
replied on Feb 12, 2019
Ex-MBB, Experienced Hire; I will teach you not only the how, but also the why of case interviews

Excel skills are table stakes:

1. Do not bother mentioning on the application

2. Do not bother freshing up on them for the interview specifically (at least at MBB; I guess some boutiques might ask you about a formula but even that would be a bit surprising)

3. Absolutely do "freshen up" on them before you join however

Note: In my experience in industry, everyone will tell me they are a 9 on a 1-10 scale; heck, I used to think I was an 8 when I first learned to do color coding. As a result, I have taken to asking for the formula of a vlookup in every interview I run for analysts - but again, this is for industry interviews. I have never seen this asked in consulting

Was this answer helpful?
Anonymous replied on Jun 08, 2020

Dear A,

Congratulations to your offer!

It would be helpful for you to learn the business-focused Excel features.

In business, about 80% of your work will come from 20% of the functionality of the Microsoft Excel.

The core skills of a competent business Excel user are something like:

  • Formatting & basic formulas
  • Mouse-free Excel navigation
  • Vlookups & conditional statements
  • Data analysis - filtering, sorting, and analyzing data
  • Data visualization - tables, charts, and dual axis charts
  • What-if-analysis
  • Pivot tables

If you can do these things, you’ll outperform 95% of people in the workplace.

To learn these concepts, you could:

  • Learn the concepts online for free
  • Take an online course

If you’re looking for something free, I’d recommend Googling & Youtube-ing those topics on my list. Tons of free material online. On Udemy you can also find some courses.

If you’re short on time, take a short business-focused online course.

I’d recommend the following business-focused course focused on mastering the 20% of functions that make up 80% of Excel work.

Best,

André

Was this answer helpful?
0
Clara
Expert
Content Creator
replied on Dec 26, 2019
McKinsey | Awarded professor at Master in Management @ IE | MBA at MIT |+180 students coached | Integrated FIT Guide aut

Hello!

Excel won´t be tested in any MBB interviews.

Cheers!

Was this answer helpful?
Sidi
Expert
replied on Feb 13, 2019
McKinsey Senior EM & BCG Consultant | Interviewer at McK & BCG for 7 years | Coached 350+ candidates secure MBB offers

Excel skills are assumed for each applicant and there is no value in practicing this before the interview (it is not tested). It is a different story though in case you receive an offer - then it might be worth to brush up your Excel skills before your start date.

Cheers, Sidi

Was this answer helpful?
Vlad
Expert
replied on Feb 12, 2019
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School

Hi,

Since it's a must and everyone assumes you have it, you may not put them into your resume. Noone will also be testing them at the interview.

Best

Was this answer helpful?
Norah gave the best answer

Norah

I am here to get you an offer! | Ex MBB interviewer Expert in MBB and Tier 2, Deep knowledge of EU & Middle East regions
61
Meetings
241
Q&A Upvotes
5
Awards
5.0
10 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