Best Excel Resources For Getting Better With Large Amounts Of Data And Scalable Logic?

I need to practice and improve the logic around how I structure models with large amounts of disorganized data, particularly when drilling down into customer cohort data. Can I get some recommendations? 

I didn't come from an IB background, more the BD side of Corp Dev, so my modeling skills aren't where they should be. I'm able to find workarounds to get the right answer a decent amount of the time in the first attempt but my work tends to difficult to audit and adding new components to a model can cause breaks in other areas which I have to go back and patch. I've taken the basic modeling courses from WallStreetPrep and WSO so I can do any of the general DCF/LBO work easily, but none of those really did much to prepare me for a huge data dump of historical customer/product data going back 5-10 years. I need to get better with organizing it all so I'm not causing other members of my team to get hit with a time crunch because I'm having to go back and fix things. Got my first real taste of a DD process over the last week and my lack of excel fluidity caused several very late nights putting unneeded stress on my team which makes me feel horrible, don't want it to happen again. 

3 Comments
 

Ducimus eaque sint quis et quibusdam unde. Ipsa dolorem in nostrum consequuntur magnam minus. Qui neque ipsum mollitia est. Asperiores hic placeat eaque. Repellendus possimus in voluptate laborum est. Et fuga et consequatur quasi a. Ullam et officiis magnam animi.

Ex qui quis quasi beatae est aut. Quisquam neque nobis officia sunt qui ut consequatur.

Sed ipsa dolores rerum quia. Odio laborum est voluptas voluptatem. Et velit rem nam veniam et dolores.

Voluptate cum incidunt aut alias iure et non sunt. Dolorem quibusdam dignissimos et facilis. Ea iure dolorum provident qui unde. Dolor et aut doloremque nihil est molestiae. Aliquid quis ratione facere unde eum rem ut.

Career Advancement Opportunities

August 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Morgan Stanley 08 97.8%
  • Goldman Sachs 02 97.2%

Overall Employee Satisfaction

August 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.3%
  • Banco Santander 02 97.8%
  • BMO Capital Markets 12 97.2%

Professional Growth Opportunities

August 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.8%
  • JPMorgan 01 97.2%

Total Avg Compensation

August 2026 Investment Banking

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

1
redever's picture
redever
99.2
2
kanon's picture
kanon
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
CompBanker's picture
CompBanker
98.9
7
DrApeman's picture
DrApeman
98.9
8
dosk17's picture
dosk17
98.9
9
GameTheory's picture
GameTheory
98.9
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...”