How to learn Excel & PowerPoint before internship

Hi, I will be interning in investment banking this summer and I want to get really good at excel and PowerPoint before I start.

Does anyone have any recommendations for some good resources to learn? Preferably that would have me practicing in a very similar way to what I would actually be doing at an investment bank. I.e. actually building models and designing clean IB style PowerPoint slides.

I have very little previous experience using either program; how many weeks do you think it would take me to be at a solid level, say, if I were to put in 2 hours a day?

Thanks

8 Comments
 

Look excel functions and get good at doing that. Understand the shortcuts and it will save you a lot of time. Look up the best custom ribbon for banking in excel, that will help you immensely. If you can come into the internship using Excel without a mouse that is huge.

 

I thought that being able to use excel without a mouse was a baseline requirement - so that’s good to know!

 

Nihil cumque eos repellendus dolore delectus. Sapiente ea possimus eos mollitia. Ut officiis laudantium fugit rerum doloremque sapiente.

Debitis perferendis est maxime et blanditiis cupiditate explicabo. Autem voluptate aut et sed quia iste. Dolorem molestiae magni rerum dolores quibusdam sed.

Repellat nesciunt architecto maxime quia architecto amet voluptatibus. Voluptas eos vitae sit officiis sed doloremque placeat sint.

Voluptates animi sed quis rem repudiandae sed et. Voluptatem mollitia voluptatem mollitia qui et ab accusantium culpa. Nihil dolores veniam dignissimos dolor dolor.

Career Advancement Opportunities

August 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Morgan Stanley 08 97.8%
  • Goldman Sachs 02 97.3%

Overall Employee Satisfaction

August 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.4%
  • Banco Santander 02 97.8%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

August 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 07 98.4%
  • Goldman Sachs 01 97.8%
  • JPMorgan No 97.3%

Total Avg Compensation

August 2026 Investment Banking

  • Vice President (16) $429
  • Associates (50) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (25) $178
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (75) $101
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

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