HELP: Prep for incoming analyst

Hey guys,

I am an incoming 1st year business analyst at MBB and would like to know how to prep for the job.

Basically, I have a non-business undergrad and very little knowledge about PPT or Excel (I was doing Python and other stuff lol). For example, I don't know any PPT shortcut and only the basic functions in Excel. 

I am worried I will lack behind my peers as most of the incoming analysts had previous internships at MBB + other F500 companies and will be proficient in PPT/Excel.

Moreover, speaking with people in the industry I was told the first project in consulting is really important as your review will impact the projects you can access next and this is a virtuous/vicious cycle. Hence, I want to perform well on this first project. 

Any good (and free) material online to get up to speed before I start my FT?

Thanks for all your suggestions! 

2 Comments
 

Quo explicabo non aut sint et. Quia voluptas aut officia voluptatem et consequuntur.

Career Advancement Opportunities

September 2026 Consulting

  • Boston Consulting Group 99.5%
  • Bain & Company 98.9%
  • McKinsey & Company 98.4%
  • Oliver Wyman 97.9%
  • LEK Consulting 97.4%

Overall Employee Satisfaction

September 2026 Consulting

  • Cornerstone Research 99.5%
  • Bain & Company 98.9%
  • Boston Consulting Group 98.4%
  • McKinsey & Company 97.9%
  • Oliver Wyman 97.4%

Professional Growth Opportunities

September 2026 Consulting

  • Bain & Company 99.5%
  • Boston Consulting Group 98.9%
  • McKinsey & Company 98.4%
  • Oliver Wyman 97.9%
  • LEK Consulting 97.4%

Total Avg Compensation

September 2026 Consulting

  • Partner (4) $361
  • Principal (30) $294
  • Director/MD (58) $274
  • Vice President (52) $246
  • Engagement Manager (114) $233
  • Manager (171) $173
  • 2nd Year Associate (185) $142
  • 3rd+ Year Associate (116) $137
  • Senior Consultant (355) $132
  • Consultant (642) $122
  • 3rd+ Year Analyst (164) $121
  • 1st Year Associate (577) $121
  • NA (16) $114
  • Engineer (6) $114
  • 2nd Year Analyst (393) $104
  • Associate Consultant (176) $101
  • 1st Year Analyst (1164) $90
  • Intern/Summer Associate (208) $83
  • Intern/Summer Analyst (640) $68
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
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
CompBanker's picture
CompBanker
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
98.9
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...”