Case interviews involving an Excel component?

Hi fellow monkeys,

I recently got an invitation from a smaller boutique consulting firm for a final round interview. Two out of the three interviews are case interviews which involve an "Excel component". I haven't heard or experienced that before, what are these like? And, how can I best prepare for them?

4 Comments
 

Often, they will give some market industry data and firm specific data. They may have pre-specified calculations to perform in select cells, they may also guide the discussion with a series of questions like:

  • what % of the market share does company x have of the overall market? 
  • If the company has $0.5m to invest into one line of business for it to grow 10% in revenue, which line of business should the company pursue? 

Best preparation is to ensure you can navigate arithmetic math and logic functions. 

If you really want to prep, you can download three statements and ask yourself some questions to test how quickly and smoothly you can navigate raw data. 

 

I had this for FTI, they dropped me in a room for an hour with a laptop and a USB drive with a couple excel sheets of data, and a word doc with questions they wanted me to answer. I was alone in the room for an hour to work on the questions, then afterwards they came in and asked me to walk them through my solutions, thinking and process. Honestly, I preferred this as it seems closest to actual daily work. Actual excel was very very basic, legit more of how I approached problems and datasets then my actual excel proficiency

 

Voluptas omnis commodi deserunt molestias autem perferendis. Maxime aut explicabo fugit qui. Repellat reiciendis ut corporis eum architecto ut. Eum facilis laudantium tempore saepe. Nulla corrupti vel cum molestiae facilis nulla vel.

Sunt neque voluptatum suscipit corporis fugiat. Fugit dolor aut ipsum error. Qui consequatur alias veniam tenetur. Quisquam autem voluptatem voluptatem quis similique id. Labore animi officiis quo cumque qui. Ipsum aliquam ea fuga fugit porro velit sunt. Aperiam voluptatem id eum impedit vitae.

Totam quas ipsa sit est neque aperiam. Amet magnam veritatis reprehenderit. Sit dolorum hic delectus consequuntur possimus nihil.

Career Advancement Opportunities

August 2026 Consulting

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

Overall Employee Satisfaction

August 2026 Consulting

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

Professional Growth Opportunities

August 2026 Consulting

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

Total Avg Compensation

August 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 (115) $135
  • Senior Consultant (355) $132
  • Consultant (642) $122
  • 3rd+ Year Analyst (164) $121
  • 1st Year Associate (576) $121
  • NA (16) $114
  • Engineer (6) $114
  • 2nd Year Analyst (392) $104
  • Associate Consultant (176) $101
  • 1st Year Analyst (1163) $90
  • Intern/Summer Associate (208) $83
  • Intern/Summer Analyst (637) $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

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...”