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

 

Et omnis omnis odit eaque. Vel minima excepturi temporibus neque nemo odio. Reiciendis quisquam harum repellendus est distinctio laborum ea blanditiis. Id minus sunt minima nostrum. Eum repellat autem voluptatibus ratione voluptates. Tempore voluptate provident expedita molestias. Ut dolor alias ut dolor consequatur sit quasi.

Odit et debitis vel occaecati et. Omnis et doloremque aliquid ut nihil facere sit error. Aspernatur nulla odio voluptatum ut illo.

Earum ex omnis ut. Est ut et vitae. Deleniti earum eos quia consequuntur expedita architecto alias incidunt.

Magnam omnis sit sint delectus eos quod. Optio accusamus omnis porro eaque fugiat ratione et et. Et voluptas vitae sed impedit. Modi beatae quo quasi molestiae ex aperiam. Autem unde fugiat in ea est.

Career Advancement Opportunities

June 2026 Consulting

  • Boston Consulting Group 99.5%
  • Bain & Company 99.0%
  • McKinsey and Co 98.5%
  • Oliver Wyman 98.0%
  • LEK Consulting 97.4%

Overall Employee Satisfaction

June 2026 Consulting

  • Cornerstone Research 99.5%
  • Bain & Company 99.0%
  • Boston Consulting Group 98.5%
  • McKinsey and Co 98.0%
  • Oliver Wyman 97.4%

Professional Growth Opportunities

June 2026 Consulting

  • Bain & Company 99.5%
  • Boston Consulting Group 99.0%
  • McKinsey and Co 98.5%
  • Oliver Wyman 98.0%
  • LEK Consulting 97.4%

Total Avg Compensation

June 2026 Consulting

  • Partner (4) $361
  • Principal (30) $294
  • Director/MD (58) $274
  • Vice President (53) $247
  • Engagement Manager (111) $232
  • Manager (167) $172
  • 2nd Year Associate (185) $142
  • 3rd+ Year Associate (115) $135
  • Senior Consultant (354) $132
  • Consultant (635) $122
  • 3rd+ Year Analyst (162) $121
  • 1st Year Associate (575) $121
  • NA (16) $114
  • Engineer (6) $114
  • 2nd Year Analyst (390) $104
  • Associate Consultant (175) $100
  • 1st Year Analyst (1152) $90
  • Intern/Summer Associate (205) $83
  • Intern/Summer Analyst (625) $67
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
kanon's picture
kanon
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
Betsy Massar's picture
Betsy Massar
98.9
8
DrApeman's picture
DrApeman
98.9
9
CompBanker's picture
CompBanker
98.9
10
Linda Abraham's picture
Linda Abraham
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...”