Consulting Q&A – Ask Questions about Your Career

In this overview, you will find all the questions asked so far by the PrepLounge community. Anyone can ask questions and write answers. Our coaches are also happy to share their expertise. If you like an answer, give it an upvote so that it rises to the top. Here you can also find our guidelines and FAQs for the Consulting Q&A.

How does the Consulting Q&A work?

Anyone can ask a question
Anyone can write an answer
Upvotes let answers rise to the top
Sort by
Last Activity
Newest question
Newest answer
Answer upvotes
Most views
Most relevant
Limit Selection
Answered
Your Tag Subscriptions

Required Excel Skills for a Consulting Internship

Excel Excel case study
Most recent answer on Oct 15, 2023
The best answer (on Oct 15, 2023) is from:
Benjamin
Expert
Ex-BCG Principal | 8+ years consulting experience in SEA | BCG top interviewer & top performer
Benjamin
Expert
gave the best answer on Oct 15, 2023
Ex-BCG Principal | 8+ years consulting experience in SEA | BCG top interviewer & top performer
Hi Sharing a few functions that were really helpful for me: Pivot tables Lookups: Index Match, Index Match Match, V/H Lookup, or X lookup (in the newer versions of excel) Sums: Sumproduct, Sumif Goalseek Conditional for ... (read entire answer)
6
Answers
4.3 k
Views
15
Total Upvotes
on Oct 15, 2023 on Oct 15, 2023
Last Activity

Deloitte Value Creation Services Interview

Deloitte Excel case study Value Creation
Most recent answer on Oct 09, 2023
The best answer (on Jul 24, 2018) is from:
Vlad
Expert
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School
Vlad
Expert
gave the best answer on Jul 24, 2018
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School
Hi, Based on the description, it may be closer to the PE / IB M&A interview that is much more technical and detailed in the financial part. Usually, they give you much more time to prepare and do the valuation on ... (read entire answer)
2
Answers
6.5 k
Views
21
Total Upvotes
on Oct 09, 2023 on Oct 09, 2023
Last Activity

Efficio - Excel Exercise

Excel case study
Most recent answer on Feb 07, 2023
The best answer (on Feb 07, 2023) is from:
Ian
Expert
#1 BCG coach | MBB | Tier 2 | Digital, Tech, Platinion | 100% personal success rate (8/8) | 95% candidate success rate
Ian
Expert
gave the best answer on Feb 07, 2023
#1 BCG coach | MBB | Tier 2 | Digital, Tech, Platinion | 100% personal success rate (8/8) | 95% candidate success rate
Hi there, Unfortunately I don't know much about Efficio (imagine that, a coach confessing ignorance!), but a quick google led me to understand the following from their interviews: An online numeracy and problem-solving ... (read entire answer)
2
Answers
1.2 k
Views
19
Total Upvotes
on Feb 07, 2023 on Feb 07, 2023
Last Activity

Efficio - excel-based case study

Excel case study Procurement supply chain
Most recent answer on Aug 02, 2022
The best answer (on Nov 22, 2021) is from:
Ian
Expert
#1 BCG coach | MBB | Tier 2 | Digital, Tech, Platinion | 100% personal success rate (8/8) | 95% candidate success rate
Ian
Expert
gave the best answer on Nov 22, 2021
#1 BCG coach | MBB | Tier 2 | Digital, Tech, Platinion | 100% personal success rate (8/8) | 95% candidate success rate
Hi there, The answer for any interview in regards to “should I prepare” is yes :) Unfortunately I don't know much about Efficio (imagine that, a coach confessing ignorance!), but a quick google led me to understand the ... (read entire answer)
7
Answers
4.8 k
Views
17
Total Upvotes
on Aug 02, 2022 on Aug 02, 2022
Last Activity

Second Round Written Big 4 Case Interview

big four business technology Excel case study powerpoint presenation written case
Most recent answer on Oct 12, 2021
The best answer (on Oct 12, 2021) is from:
Ian
Expert
#1 BCG coach | MBB | Tier 2 | Digital, Tech, Platinion | 100% personal success rate (8/8) | 95% candidate success rate
Ian
Expert
gave the best answer on Oct 12, 2021
#1 BCG coach | MBB | Tier 2 | Digital, Tech, Platinion | 100% personal success rate (8/8) | 95% candidate success rate
Hi James, First, good luck! I recommend the following: Remember that most casing tips apply here (i.e. be very clear+focused on the objective, ruthlessly cut out information that doesn't help you meet this objective/que ... (read entire answer)
5
Answers
1.9 k
Views
44
Total Upvotes
on Oct 12, 2021 on Oct 12, 2021
Last Activity

What's the most effective way to prep for consultancy?

BCG BCG McKinsey and Bain case studies Consultancy Excel case study HelpASisterOut
Most recent answer on Apr 30, 2020
The best answer (on Apr 05, 2020) is from:
Luca
Expert
BCG |NASA | SDA Bocconi & Cattolica partner | GMAT expert 780/800 score | 200+ students coached
Luca
Expert
gave the best answer on Apr 05, 2020
BCG |NASA | SDA Bocconi & Cattolica partner | GMAT expert 780/800 score | 200+ students coached
Dear anonymous, Your feeling is really common and you shouldn't worry too much about this. The most effective way to prepare is to practice both with other candidates and coaches that can give you a reliable feedabck. ... (read entire answer)
12
Answers
1.7 k
Views
29
Total Upvotes
on Apr 30, 2020 on Apr 30, 2020
Last Activity
6 results
How likely are you to recommend us to a friend or fellow student?
0
1
2
3
4
5
6
7
8
9
10
0 = Not likely
10 = Very likely