Look up

on the Youtubes and start learning and practicing. PPTX is pretty easy to learn, and is really just formatting and is really just more time consuming than anything. So I'd recommend an easy 80-85% lean towards Excel vs PPTX study.

Key words? VLIOOKUP, INDEX MATCH and Pivot Tables. Most of those tutorials online also have sample workbooks to work on along with the videos for some actual hands-on.

The poster formerly known as theAudiophile. Just turned up to 11, like the stereo.
 

Thank you! OP here. How much should I prepare before I start? Is this 5-hour course enough? Should I start building models online? Are there any textbooks I should read/work through? I am scared I will be behind my peers who did the internship before or were business majors. 

 

Is this 5-hour course enough? Should I start building models online? Are there any textbooks I should read/work through? I am scared I will be behind my peers who did the internship before or were business majors. 

Lord no that five hours is nowhere near enough practice. I'd steer away from textbooks and stick to the video tutorials and their follow-along workbooks because they'll be a lot more helpful. Plow through every tutorial you can find, look up any and all questions that come up because there'll be plenty of others asking on places like Quora too.

The poster formerly known as theAudiophile. Just turned up to 11, like the stereo.
 

Thank you! How many months or so of prep do you think I should do before I start, right now I'm thinking of doing ~20 hours a week for two months? I will focus on Excel. Is there any McK specific Excel advice you have or is it the same pretty much across most firms?

Can't speak to McK specifics and their targets for Excel. For practice, just keep at it. Don't let yourself think there is some hard number of hours per month you need. Find all the training exercises you can and work through them and if you get stumped, look it up online and push on. It's honestly not like memorizing a map of all 50 states and making it rote. Excel is very much taught through learning from doing.

The poster formerly known as theAudiophile. Just turned up to 11, like the stereo.
 
Most Helpful

Unde amet quam laborum velit voluptatem iusto. Laudantium mollitia error recusandae aut est. Et voluptatem ab consectetur ab.

Sapiente non nihil deleniti nobis omnis aut autem. Ut veritatis facilis in eos architecto voluptatem accusamus consequatur.

Eum sit recusandae dolores totam ab hic vero. Non non ea aliquid harum rerum illo quisquam voluptates. Qui impedit ut asperiores rerum vel ab.

Ut minima ipsa assumenda temporibus modi ut quia. Dolorum harum omnis molestias assumenda tempore natus placeat nam. Eum vel qui id distinctio. Nemo ea accusantium accusamus. Et ratione repellendus aut ab odit id et blanditiis.

Career Advancement Opportunities

April 2024 Consulting

  • Bain & Company 99.4%
  • McKinsey and Co 98.9%
  • Boston Consulting Group (BCG) 98.3%
  • Oliver Wyman 97.7%
  • LEK Consulting 97.2%

Overall Employee Satisfaction

April 2024 Consulting

  • Bain & Company 99.4%
  • Cornerstone Research 98.9%
  • Boston Consulting Group (BCG) 98.3%
  • McKinsey and Co 97.7%
  • Oliver Wyman 97.2%

Professional Growth Opportunities

April 2024 Consulting

  • Bain & Company 99.4%
  • McKinsey and Co 98.9%
  • Boston Consulting Group (BCG) 98.3%
  • Oliver Wyman 97.7%
  • LEK Consulting 97.2%

Total Avg Compensation

April 2024 Consulting

  • Partner (4) $368
  • Principal (25) $277
  • Director/MD (55) $270
  • Vice President (47) $246
  • Engagement Manager (100) $226
  • Manager (152) $170
  • 2nd Year Associate (158) $140
  • Senior Consultant (331) $130
  • 3rd+ Year Associate (108) $130
  • Consultant (587) $119
  • 1st Year Associate (538) $119
  • NA (15) $119
  • 3rd+ Year Analyst (146) $115
  • Engineer (6) $114
  • 2nd Year Analyst (344) $103
  • Associate Consultant (166) $98
  • 1st Year Analyst (1048) $87
  • Intern/Summer Associate (188) $84
  • Intern/Summer Analyst (552) $67
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
CompBanker's picture
CompBanker
98.9
6
kanon's picture
kanon
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
numi's picture
numi
98.8
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”