WSO Elite Modeling Package

  • 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
  • Elite instructors from top BB investment banks and private equity megafunds
  • Includes Company DB + Video Library Access (1 year)

Comments (9)

Oct 21, 2011 - 2:16pm

Yeah you'll definitely be asked about sorting, like the algorithmic nuances between tree sort, merge sort, and bubble sort, and how they're applied when you click the "sort" button in Excel.

You should also be strong to quite-strong with objects (Meet the Parents, anyone?), because you'll use those a lot too.

Oct 21, 2011 - 2:17pm

Excel Assessment (Originally Posted: 11/21/2013)

Next week I have an interview at McLagan consulting. They said they are going to give me a excel assessment.
What should I expect on this test?

V-look up, H-look up, Pivot table?
anything else?


It's all about bucks, kid. The rest is conversation. -Gordon Gekko
Learn More

300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.

Learn more
Oct 21, 2011 - 2:20pm

Excel Assessment Test (Originally Posted: 02/01/2012)

I have an interview coming up soon and in the e-mail I received I was told that I may be given an excel assessment test....In the job listing "intermediate to advanced" excel skills are expected.

My first question is: How common are excel assessments for analyst hires?

2nd: If I am somewhat proficient in lookups, if statements, and pivot tables, but have no experience in macros...should I be nervous about this test in the chance that I do end up being asked to take one?

Start Discussion

Total Avg Compensation

April 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (34) $348
  • Associates (185) $233
  • 2nd Year Analyst (106) $150
  • Intern/Summer Associate (96) $145
  • 3rd+ Year Analyst (26) $145
  • 1st Year Analyst (391) $132
  • Intern/Summer Analyst (318) $82