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. 

 

Voluptatum aut voluptatem commodi enim. Voluptas ut et ut possimus sapiente qui. Quibusdam dolorem reprehenderit aut. Vitae ad dolores ea et. Pariatur illo rerum aperiam quos itaque.

Quis harum id voluptates sed quis adipisci autem. Aliquid dolores mollitia quia voluptatum ad enim quos.

Autem soluta minus assumenda aut. Reiciendis quia quae sequi consequatur quia consequuntur. Aspernatur provident nobis delectus ea in inventore nihil. Aliquam est aut et. Sit consequatur aspernatur in quasi aut delectus rerum.

Natus maxime officiis rerum eum. Et aut et eaque quasi aut possimus ab. Enim enim ipsum et illo. Occaecati et sunt dicta suscipit sed modi dolorem ipsam.

Career Advancement Opportunities

April 2024 Hedge Fund

  • Point72 98.9%
  • D.E. Shaw 97.9%
  • Citadel Investment Group 96.8%
  • Magnetar Capital 95.8%
  • AQR Capital Management 94.7%

Overall Employee Satisfaction

April 2024 Hedge Fund

  • Magnetar Capital 98.9%
  • D.E. Shaw 97.8%
  • Blackstone Group 96.8%
  • Two Sigma Investments 95.7%
  • Citadel Investment Group 94.6%

Professional Growth Opportunities

April 2024 Hedge Fund

  • AQR Capital Management 99.0%
  • Point72 97.9%
  • D.E. Shaw 96.9%
  • Magnetar Capital 95.8%
  • Citadel Investment Group 94.8%

Total Avg Compensation

April 2024 Hedge Fund

  • Portfolio Manager (9) $1,648
  • Vice President (23) $474
  • Director/MD (12) $423
  • NA (6) $322
  • 3rd+ Year Associate (24) $287
  • Manager (4) $282
  • Engineer/Quant (71) $274
  • 2nd Year Associate (30) $251
  • 1st Year Associate (73) $190
  • Analysts (225) $179
  • Intern/Summer Associate (22) $131
  • Junior Trader (5) $102
  • Intern/Summer Analyst (250) $85
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...”