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

What analysis should I be able to perform in Excel and SPSS (when working as a consultant in a big firm)?

Hi there,

I was able to find a lot of prep material for quant skills for a management consulting interview. However, I was unable to find any content related the various quant skills needed when you do actual consulting work. I know that a conjoint analysis is quite common, for example. Do you happen to know any resources that list all the analysis that I should be able to perform/ will need to be able to perform at some point in Excel and SPSS when I do actual consulting work (in a big firm)? 

Thank you for your time!

3
1.7k
12
Be the first to answer!
Nobody has responded to this question yet.
Top answer
on Sep 01, 2020
McKinsey | NASA | top 10 FT MBA professor for consulting interviews | 6+ years of coaching

Hi, only basic tools in Excel will be needed. My recommendation is not overpreparing excel skills, you are quickly acquiring it on the job

Best,
Antonello

Ian
Coach
edited on Aug 21, 2020
#1 BCG coach | MBB | Tier 2 | Digital, Tech, Platinion | 100% personal success rate (8/8) | 95% candidate success rate

First, you definitely don't need SPSS! The thought of any form of robust statistical analysis occuring at strategy consultancies makes me laugh!

Remember: "Source: Mckinsey/BCG Analysis" often means "numbers are mostly made up"!

The only analytical tools you will need are Excel and Alteryx. Excel is more common and practice beforehand helps. Alteryx you may never use, and, if you do, it's pretty quick/easy to learn. Tableau is useful, but not required (and also dangerous in the hands of someone who doens't understand statistics/economics)

How to Skill Up in Excel

A few good resources:

https://blog.hubspot.com/marketing/learn-excel-resources

https://www.udemy.com/share/101Wde/ (Udemy is excellent. $15...basically free)

 Q&A: https://www.preplounge.com/en/consulting-forum/free-online-resources-to-learn-excel-basics-6946

Important Tip: Don't just learn formulas etc. Test yourself! Download a free data set, ask yourself a question, and try to solve for it. Play with actual data solving real questions and building a real dashboard etc. Don't just passively take lessons :)

Deleted user
on Aug 21, 2020

Dear A,

SPSS is not actually widely used in consulting, but it's rather Excel and other machine automated tools for big data analysis. 

Usually, knowing the Macros would be very helpful to start with, but all further learnings in Excel you could acquire during soecific seminars and trainings on the job, since, for example, my employer has provided multiple specific courses in Excel to advance the skills. 
 

So you would also be able to profit from this knowledge after you join the company. 

Best,
André

0
Similar Questions
Consulting
JOB APPLICATION
on Mar 27, 2025
Global
5
700+
Top answer by
#1 Coach for Sessions (4.500+) | 1.500+ 5-Star Reviews | Proven Success: ➡ interviewoffers.com | Ex BCG | 10Y+ Coaching
73
5 Answers
700+ Views
+2
Consulting
Do consultants use AI for PowerPoint or excel or anywhere in the Process??
on Aug 24, 2024
Global
7
1.8k
Top answer by
Nilay
Coach
Former McKinsey Sr Engagement Manager | Trained McKinsey interviewer (100+ interviews, 500+ coaching sessions)
50
7 Answers
1.8k Views
+4
Consulting
Consulting career
on Mar 28, 2025
Global
9
200+
Top answer by
Evelina
Coach
EY-Parthenon (6 years) l Ex BCG l 97% success rate l 30% off first session l free 15' intro call l LBS
14
9 Answers
200+ Views
+6
How likely are you to recommend us to a friend or fellow student?
0 = Not likely
10 = Very likely
Thanks for your feedback! Your opinion helps us make PrepLounge even better.