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

 

Suscipit voluptatum aut nihil odit eos tenetur qui. Quidem quia harum placeat sed modi non temporibus. Labore ea necessitatibus saepe eaque voluptatum fugit cumque earum. Ut molestias similique inventore unde sapiente odit doloribus. Dolor numquam fugit maxime quidem. Maxime ipsum quaerat enim autem. Maiores sapiente quo praesentium doloribus voluptate.

Fuga illum in non ducimus sint aperiam sint. Sunt neque alias exercitationem pariatur id incidunt accusamus.

Voluptatem esse reprehenderit harum explicabo. Saepe enim quo numquam totam excepturi et fugiat. Enim molestiae et architecto natus. Ab est magni voluptas ea modi incidunt sed. Eos ea voluptatem soluta qui. Tenetur veritatis dicta dolorem. Delectus nobis et ducimus consequatur vel sint.

Saepe iure vitae vel dignissimos non tempora dolorem. Reiciendis dolor tenetur tempore illum sit autem aut. Autem cum rerum beatae neque sunt eum consectetur.

Career Advancement Opportunities

July 2026 Consulting

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

Overall Employee Satisfaction

July 2026 Consulting

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

Professional Growth Opportunities

July 2026 Consulting

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

Total Avg Compensation

July 2026 Consulting

  • Partner (4) $361
  • Principal (30) $294
  • Director/MD (58) $274
  • Vice President (53) $247
  • Engagement Manager (113) $232
  • Manager (170) $173
  • 2nd Year Associate (185) $142
  • 3rd+ Year Associate (116) $135
  • Senior Consultant (355) $132
  • Consultant (642) $122
  • 1st Year Associate (577) $121
  • 3rd+ Year Analyst (164) $121
  • NA (16) $114
  • Engineer (6) $114
  • 2nd Year Analyst (391) $104
  • Associate Consultant (176) $101
  • 1st Year Analyst (1164) $90
  • Intern/Summer Associate (208) $83
  • Intern/Summer Analyst (633) $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

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
GameTheory's picture
GameTheory
98.9
7
DrApeman's picture
DrApeman
98.9
8
dosk17's picture
dosk17
98.9
9
CompBanker's picture
CompBanker
98.9
10
bolo up's picture
bolo up
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...”