Consulting Case Interview Course

  • 2,037 questions across 209 consulting firms. Crowdsourced from over 600,000 members.
  • 11 Detailed Exclusive Cases developed by a McKinsey Associate and 10+ hours of video.
  • Trusted by over 1,000 aspiring consultants just like you.

Comments (15)

  • Associate 2 in Consulting
Jun 4, 2021 - 1:29pm

Yes, financial and other modeling is part of strategy consulting

In terms of the most technical stuff you'll have to do there's a high variance. I know people who are consistently using fairly advanced analytics platforms, and I also know people who have never opened Excel except to write down lists of names. I'd say the average is a mix of Excel, Tableau, and occasion Alteryx

Is there a particular reason you're asking?

  • Associate 2 in Consulting
Jun 4, 2021 - 1:41pm

Knowing how to use Excel and do some modeling is never a bad idea, but you aren't expected to have any particular technical skills before you join

Some companies will use Excel type tests in interviews, but I have not heard of MBB using them

Jun 4, 2021 - 2:03pm

Do learn excel / take an excel course if you can. I did this before starting and it has been immensely helpful. 
 

Don't take a financial modeling course. I've taken one of these as well as preparation for a previous finance internship. They focus on the kind of modeling you would do in banking. You would use these kinds of models very rarely if at all in consulting so the ROI would be low if not zero. 

In general, I found the excel course helped me much more than the financial modeling course, even for financial modeling. 

Learn More

300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.

Learn more
Jun 4, 2021 - 2:06pm

To answer your question about the 'most technical' thing in consulting, we have people who do work in /with Python / machine learning / data science. The ceiling on how 'technical' you can get in consulting is actually much higher than it is in banking, which I feel like is rarely acknowledged in these types of forums. 
 

If you want to do that kind of work I would learn some of it before starting so it's easier to get staffed in roles where you would be using those skills

Jun 4, 2021 - 2:15pm

I'd challenge the idea that these are separate paths. They are to an extent, but our more technical teams are being brought on to projects with increasing frequency. Which makes intuitive sense-if you have methods of more rigorous / advanced analysis, you would want to break those out wherever possible. 
 

Personally, I am working to develop a more technical toolkit so my staffing can be more flexible, not less. Someone who knows Python or SQL or any other technical skill can still be staffed on a more qualitative / slide heavy project where they don't use those skills, whereas someone without those skills is more limited

Start Discussion

Total Avg Compensation

June 2021 Consulting

  • Principal (20) $274
  • Director/MD (43) $260
  • Vice President (34) $249
  • Engagement Manager (75) $216
  • Manager (127) $165
  • 2nd Year Associate (122) $138
  • 3rd+ Year Associate (92) $128
  • Senior Consultant (270) $128
  • NA (10) $116
  • Consultant (482) $114
  • 1st Year Associate (428) $113
  • Engineer (4) $110
  • 3rd+ Year Analyst (111) $107
  • 2nd Year Analyst (243) $96
  • Associate Consultant (133) $92
  • 1st Year Analyst (840) $84
  • Intern/Summer Associate (131) $82
  • Intern/Summer Analyst (374) $67