Quant Fund Middle Office Excel Test

I have an excel test coming up for a fund I'm interviewing at. I have not taken one of these in a couple of years, so wondering if there is anything I should brush up on beforehand. 

I'm comfortable with all the generic items that tend to be on these, lookups, pivots, data formatting etc. 

1 Comments
 

Quidem numquam debitis earum voluptatem totam voluptate totam aut. Molestiae fuga temporibus et qui eum. Et accusamus numquam hic minus reprehenderit ut iusto.

Voluptatem facilis vel ducimus saepe qui. Recusandae quas tenetur facere fugit ad. Facilis repellat sit aut aut reiciendis porro. Id vero et itaque sed consequuntur amet odio.

Career Advancement Opportunities

September 2026 Hedge Fund

  • Point72 99.0%
  • D.E. Shaw 98.0%
  • Citadel Investment Group 97.0%
  • AQR Capital Management 96.0%
  • Magnetar Capital 95.0%

Overall Employee Satisfaction

September 2026 Hedge Fund

  • Magnetar Capital 99.0%
  • D.E. Shaw 98.0%
  • Blackstone Group 97.0%
  • Citadel Investment Group 96.0%
  • Two Sigma Investments 94.9%

Professional Growth Opportunities

September 2026 Hedge Fund

  • AQR Capital Management 99.0%
  • Point72 98.0%
  • D.E. Shaw 97.1%
  • Citadel Investment Group 96.1%
  • Magnetar Capital 95.1%

Total Avg Compensation

September 2026 Hedge Fund

  • Portfolio Manager (9) $1,648
  • Vice President (27) $464
  • Director/MD (11) $372
  • NA (9) $320
  • Engineer/Quant (83) $287
  • 3rd+ Year Associate (26) $284
  • Manager (4) $282
  • 2nd Year Associate (32) $253
  • 1st Year Associate (76) $193
  • Analysts (234) $178
  • Intern/Summer Associate (29) $145
  • Junior Trader (5) $102
  • Intern/Summer Analyst (276) $95
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
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
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...”