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.

How does the Consulting Q&A work?

Anyone can ask a question
Anyone can write an answer
Upvotes let answers rise to the top
Most relevant
  • Last Activity
  • Newest question
  • Newest answer
  • Answer upvotes
  • Most views
  • Most relevant
1 - 20 of 1018 results

Required Excel Skills for a Consulting Internship

Excel Excel case study
Most recent answer on Jun 08, 2020
Anonymous gave the best answer on Jun 08, 2020
Dear A, Congratulations to your offer! It would be helpful for you to learn the business-focused Excel features. In business, about 80% of your work will come from 20% of the functionality of the Microsoft Excel. ... (read entire answer)
5
Answers
2.8 k
Views
6
Total Upvotes
on Jun 08, 2020 on Jun 08, 2020
Last Activity

Free online resources to learn Excel basics

Excel free resources
Question edited on Jun 08, 2020
Anonymous gave the best answer on Jun 08, 2020
Dear A, Congratulations to your offer! It would be helpful for you to learn the business-focused Excel features. In business, about 80% of your work will come from 20% of the functionality of the Microsoft Excel. ... (read entire answer)
5
Answers
2.1 k
Views
14
Total Upvotes
on Jun 08, 2020 on Jun 08, 2020
Last Activity

Excel Skills

Excel
Most recent answer on Jun 08, 2020
The best answer (on Feb 12, 2019) is from:
Norah
Expert
I am here to get you an offer! | Got 8 offers including the 3 MBBs and non MBB like Wyman, Roland Berger, Strategy&.
Norah
Expert
gave the best answer on Feb 12, 2019
I am here to get you an offer! | Got 8 offers including the 3 MBBs and non MBB like Wyman, Roland Berger, Strategy&.
Hello Bele, Thanks for the reach out on the platform! Not absolutely recommended to fresh up excel skills for strategy consulting interviews, as you won't be tested on those. However, if you do have strong excel ski ... (read entire answer)
6
Answers
2.0 k
Views
4
Total Upvotes
on Jun 08, 2020 on Jun 08, 2020
Last Activity

How do I master excel within a few weeks?

Excel
Most recent answer on Jun 08, 2020
The best answer (on May 01, 2019) is from:
Vlad
Expert
Content Creator
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School
Vlad
Expert
Content Creator
gave the best answer on May 01, 2019
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School
Hi, You need to learn the following: Basics Fast excel - throw away your mouse and put some tape on your touchpad. Do everything with your keyboard! The main formulas (especially vlookup, column, etc) Pivot ... (read entire answer)
4
Answers
1.6 k
Views
4
Total Upvotes
on Jun 08, 2020 on Jun 08, 2020
Last Activity

Resources to refresh Excel skills

Excel
Most recent answer on May 22, 2020
The best answer (on Apr 08, 2020) is from:
Clara
Expert
Content Creator
McKinsey | Awarded professor at Master in Management @ IE | MBA at MIT |+180 students coached | Integrated FIT Guide aut
Clara
Expert
Content Creator
gave the best answer on Apr 08, 2020
McKinsey | Awarded professor at Master in Management @ IE | MBA at MIT |+180 students coached | Integrated FIT Guide aut
Hello! Congrats of that offer! Excel skills are part of the core skill-set of consultants, and it´s great that you want to practice them. PFB a list of the most popular commands: Basic operations: SUM, SUMPR ... (read entire answer)
8
Answers
1.3 k
Views
37
Total Upvotes
on May 22, 2020 on May 22, 2020
Last Activity

What Excel Prep course do you recommend?

bestcourse courses Excel
Most recent answer on Apr 04, 2021
The best answer (on Mar 31, 2021) is from:
Adi
Expert
Content Creator
Accenture, Deloitte | Precision Case Prep | Experienced Interviewer & Career Coach | 15 years professional experience
Adi
Expert
Content Creator
gave the best answer on Mar 31, 2021
Accenture, Deloitte | Precision Case Prep | Experienced Interviewer & Career Coach | 15 years professional experience
Have a look at this thread: https://www.preplounge.com/en/consulting-forum/excel-skills-9465
5
Answers
799
Views
36
Total Upvotes
on Apr 04, 2021 on Apr 04, 2021
Last Activity

How can I improve my excel modeling skills as a consultant?

Excel
Most recent answer on Jan 28, 2022
The best answer (on Jan 27, 2022) is from:
Ian
Expert
Content Creator
MBB | 100% personal interview success rate (8/8) and 95% candidate success rate | Personalized interview prep
Ian
Expert
Content Creator
gave the best answer on Jan 27, 2022
MBB | 100% personal interview success rate (8/8) and 95% candidate success rate | Personalized interview prep
Hi there, You have a few options here: Learn on the job Ask your colleagues Do the online/internal trainings Find online tutorials/trainings (there are a million) “Create” you own training by playing around with a big d ... (read entire answer)
6
Answers
620
Views
49
Total Upvotes
on Jan 28, 2022 on Jan 28, 2022
Last Activity

Excel skills

Excel
Most recent answer on Apr 22, 2022
The best answer (on Apr 21, 2022) is from:
Florian
Expert
Content Creator
#1 rated McKinsey Case and PEI Coach | 5 years at McKinsey | Mentorship Approach | 120+ McK offers in 18 months
Florian
Expert
Content Creator
gave the best answer on Apr 21, 2022
#1 rated McKinsey Case and PEI Coach | 5 years at McKinsey | Mentorship Approach | 120+ McK offers in 18 months
Hey there,If you are interested in preparing for your new role, I'd suggest the following: 95% of your work in Excel will be covered by vlookups index match pivot tables Unless you are specifically hired as a financial ... (read entire answer)
5
Answers
485
Views
27
Total Upvotes
on Apr 22, 2022 on Apr 22, 2022
Last Activity

Excel / financial modeling skills required (experienced hire) and how to develop?

Excel financial modeling
Most recent answer on Jun 12, 2021
The best answer (on Jun 12, 2021) is from:
Ian
Expert
Content Creator
MBB | 100% personal interview success rate (8/8) and 95% candidate success rate | Personalized interview prep
Ian
Expert
Content Creator
gave the best answer on Jun 12, 2021
MBB | 100% personal interview success rate (8/8) and 95% candidate success rate | Personalized interview prep
Hi there, I wouldn't worry too much about this until you join -you should get trained extensively at the company through orientation, intranet portal resources, and on-the-job learning. Of course, it shouldn't be a ... (read entire answer)
1
Answer
453
Views
15
Total Upvotes
on Jun 12, 2021 on Jun 12, 2021
Last Activity

How to enhance excel & modeling skills (for consultants)?

Excel
Most recent answer on Apr 13, 2022
The best answer (on Apr 13, 2022) is from:
Ian
Expert
Content Creator
MBB | 100% personal interview success rate (8/8) and 95% candidate success rate | Personalized interview prep
Ian
Expert
Content Creator
gave the best answer on Apr 13, 2022
MBB | 100% personal interview success rate (8/8) and 95% candidate success rate | Personalized interview prep
Hi there, You have a few options here: Learn on the job Ask your colleagues Do the online/internal trainings Find online tutorials/trainings (there are a million) “Create” you own training by playing around with a big d ... (read entire answer)
2
Answers
296
Views
10
Total Upvotes
on Apr 13, 2022 on Apr 13, 2022
Last Activity

Best training datasets for learning Excel

Excel
Most recent answer on Oct 28, 2022
Anonymous gave the best answer on Oct 27, 2022
Hi there,  Congrats on the offer and starting soon! You might find the lessons here useful: https://www.guru99.com/excel-tutorials.html They're structured along the main sort of operations you'd need to use in consultin ... (read entire answer)
4
Answers
110
Views
26
Total Upvotes
on Oct 28, 2022 on Oct 28, 2022
Last Activity

How to get quicker at Excel and PowerPoint for Consulting

Analytical Skills Data Analysis Excel McKinsey PowerPoint
Most recent answer on Jun 08, 2020
The best answer (on Feb 07, 2018) is from:
Vlad
Expert
Content Creator
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School
Vlad
Expert
Content Creator
gave the best answer on Feb 07, 2018
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School
Hi, 1) Excel and Financial modeling - the best course I know is Training The Street. Take Financial Modeling, Valuation, Maybe LBO. They have the amazing templates that you have to repsoduce to be able to do that fast ... (read entire answer)
9
Answers
13.1 k
Views
30
Total Upvotes
on Jun 08, 2020 on Jun 08, 2020
Last Activity

Specialist - Oil & Gas - Petroleum Asset eXcellence (PAX) Interview

Case interview process McKinsey oil & gas oil and gas PAX
Recent activity on Feb 11, 2018
The best answer (on Feb 11, 2018) is from:
Andrea
Expert
Former BCG Principal and decision round interviewer
Andrea
Expert
gave the best answer on Feb 11, 2018
Former BCG Principal and decision round interviewer
Since I've never heard of this, I reached out to a friend of mine who works in Houston for McKinsey, which I believe is your target consulting company. Contrary to what indicated in other answers here, he said that th ... (read entire answer)
5
Answers
7.1 k
Views
17
Total Upvotes
on Feb 11, 2018 on Feb 11, 2018
Last Activity

Best Excel Preparation Courses for Consulting

Excel MBB preparation software
Most recent answer on Jun 08, 2020
The best answer (on Sep 29, 2019) is from:
Nirmit
Expert
I will get you an offer|McKinsey Senior EM|Offers from MBB|100+ interviews at McKinsey|Recruiting Lead|Experienced hire
Nirmit
Expert
gave the best answer on Sep 29, 2019
I will get you an offer|McKinsey Senior EM|Offers from MBB|100+ interviews at McKinsey|Recruiting Lead|Experienced hire
See if you can get your hands on matrial for Train the Street. Pretty impactful Cheers, Nirmit
4
Answers
4.4 k
Views
4
Total Upvotes
on Jun 08, 2020 on Jun 08, 2020
Last Activity

I am sitting the McKinsey SHL test in a few days - can we have Excel open for the test?

McKinsey shl numerical reasoning
Recent activity on Sep 03, 2018
The best answer (on Sep 02, 2018) is from:
Sarah
Sarah gave the best answer on Sep 02, 2018
I just took it. You can use whatever you have around (calculator is fine, for instance). I don't recommend using Excel, as the biggest pressure here was time.
3
Answers
4.3 k
Views
8
Total Upvotes
on Sep 03, 2018 on Sep 03, 2018
Last Activity

what excel skills do i need to start my consulting internship

Excel
Most recent answer on Jun 08, 2020
The best answer (on Feb 13, 2018) is from:
Andrea
Expert
Former BCG Principal and decision round interviewer
Andrea
Expert
gave the best answer on Feb 13, 2018
Former BCG Principal and decision round interviewer
To add to the above: -Sensitivity tables (1 input, 2 input) -Text manipulation functions (len,left,right, etc) -Conditional functions (if, sumif, etc) -Search functions (please use index/match instead of vlookup ... (read entire answer)
3
Answers
3.9 k
Views
12
Total Upvotes
on Jun 08, 2020 on Jun 08, 2020
Last Activity

Can I use excel in McKinsey Imbellus game or only scratch paper is allowed?

Digital McKinsey McKinsey PST
Most recent answer on Aug 18, 2021
The best answer (on Aug 18, 2021) is from:
Agrim
CoachingPlus Expert
Content Creator
BCG Dubai Project Leader | I will transform your thinking about Consulting Interviews
Agrim
CoachingPlus Expert
Content Creator
gave the best answer on Aug 18, 2021
BCG Dubai Project Leader | I will transform your thinking about Consulting Interviews
Although Francesco is the best authority on this - what I have seen in the game is that Excel will hold you back. There is a large amount of data entry in order to set-it-up. It would be better to make calculated 80:20 ... (read entire answer)
4
Answers
3.1 k
Views
17
Total Upvotes
on Aug 18, 2021 on Aug 18, 2021
Last Activity

Starting at an MBB. Training the Street or Management Consulted's Excel & PPT course?

Excel MBB New Joiner
Most recent answer on Jun 02, 2021
The best answer (on Jun 02, 2021) is from:
Ken
Expert
Content Creator
Ex-McKinsey final round interviewer | Executive Coach
Ken
Expert
Content Creator
gave the best answer on Jun 02, 2021
Ex-McKinsey final round interviewer | Executive Coach
I really would just wait until you get access to the internal training. I know McKinsey does this before you join as part of pre-work for the induction week. I'm sure the others do as well.
8
Answers
2.1 k
Views
38
Total Upvotes
on Jun 02, 2021 on Jun 02, 2021
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
Content Creator
MBB | 100% personal interview success rate (8/8) and 95% candidate success rate | Personalized interview prep
Ian
Expert
Content Creator
gave the best answer on Nov 22, 2021
MBB | 100% personal interview success rate (8/8) and 95% candidate success rate | Personalized interview prep
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
1.8 k
Views
16
Total Upvotes
on Aug 02, 2022 on Aug 02, 2022
Last Activity

Excel Skills

Actively preparing for interviews at McKinsey and BCG Actively preparing for interviews with Bain and BCG Actively preparing for Mckinsey & AT Kearney and Bain ATKearney MBB
Most recent answer on Mar 14, 2021
The best answer (on Mar 04, 2021) is from:
Ian
Expert
Content Creator
MBB | 100% personal interview success rate (8/8) and 95% candidate success rate | Personalized interview prep
Ian
Expert
Content Creator
gave the best answer on Mar 04, 2021
MBB | 100% personal interview success rate (8/8) and 95% candidate success rate | Personalized interview prep
Hi there, Teach yourself: https://blog.hubspot.com/marketing/learn-excel-resources Q&A: https://www.preplounge.com/en/consulting-forum/free-online-resources-to-learn-excel-basics-6946 Pay for a Course: ... (read entire answer)
9
Answers
1.6 k
Views
99
Total Upvotes
on Mar 14, 2021 on Mar 14, 2021
Last Activity
1 - 20 of 1018 results