incoming summer analyst without any excel/ppt knowledge :(

Hey guys,

I am currently a third year student at a top european university, and a few months ago I got an offer for a summer intern role at a big 4 M&A (which is my first interniship ever).

However, I am scared I will fuck up everything, since, even tought I may be a little knowledgable about M&A, I am a terrible user of microsoft office. I have taken an excel course at my uni, but I am very rusty, in addition, my power point abilities are close to zero, since I have never used it in my entire life...

Is this gonna be a huge problem? Since I am starting in 2 weeks, should I watch some youtube tutorials, or check online material? And how much should I be good at using these tools before the internship starts?

Every suggestion/advise would be very much appreciated

Thank youuu

 

Yeah watch YouTube. Everything you need you can learn from there. The basics, anyway. Some nice tiktok accounts too.

 
Most Helpful

I think there are plenty of (free) online tutorials nowadays. You should probably focus on Excel as you cannot invent a formula so you have to know which exist to be able to use them, graphs are also quite important and most students suck at formatting before starting tbh.

PPT is more intuitive in a way and is more about knowing shortcuts to align/group and respect company graphic chart sometime using Microsoft plugin (which you cannot learn how to use before you know which one they have).

Practice a lot, this is the only way to really improve.

My advice are for general use, have done off-cycle internships so might differ for summer on (i) the formation you get prior getting started (ii) the tasks you'll have to do.

Take note of everything you'll be taught during you first weeks and force yourself to use shortcut as much as possible, you are going to do great!

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $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

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
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
kanon's picture
kanon
98.9
9
bolo up's picture
bolo up
98.8
10
numi's picture
numi
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...”