Get Active in Our Amazing Community of Over 451,000 Peers!

Schedule mock interviews on the Meeting Board, join the latest community discussions in our Consulting Q&A and find like-minded Case Partners to connect and practice with!

How does the Consulting Q&A work?

Anyone can ask a question

Anyone can write an answer

Upvotes let answers rise to the top

solve – McKinney's assessment game excel templet

Analytiktest Excel free resources McKinsey McKinsey Imbellus Problem Solving Test

Most recent answer on Mar 05, 2024

Alberto

Expert

Ex-McKinsey Associate Partner | +15 years in consulting | +200 McKinsey 1st & 2nd round interviews

Alberto

Expert

gave the best answer on Jan 31, 2024

Ex-McKinsey Associate Partner | +15 years in consulting | +200 McKinsey 1st & 2nd round interviews

Hi Anat, You can check out the amazing product Francesco has created to prepare the McKinsey assessment game here: https://psgsecrets.com/ Best, Alberto — Check out my latest case based on a real MBB interview: Sierra S ... (read entire answer)

6
Answers

286
Views

51
Total Upvotes

on Mar 05, 2024 on Mar 05, 2024
Last Activity

Excel used in Consulting

Big 4 big four Big Four - Strategy Excel Excel for consultants MBB mbb big4

Most recent answer on Oct 18, 2023

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, Great that you are showing enthusiasm and initiative to try and prepare for the job. If you ask me - most of what you need to know, you'll pick up on the job. That being said, sharing for me what were the most comm ... (read entire answer)

8
Answers

666
Views

62
Total Upvotes

on Oct 18, 2023 on Oct 18, 2023
Last Activity

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

Excel

Most recent answer on Oct 15, 2023

gave the best answer on Jan 27, 2022

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)

7
Answers

1.2 k
Views

53
Total Upvotes

on Oct 15, 2023 on Oct 15, 2023
Last Activity

Looking for exciting discussions from the community?

Required Excel Skills for a Consulting Internship

Excel Excel case study

Most recent answer on Oct 15, 2023

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.4 k
Views

15
Total Upvotes

on Oct 15, 2023 on Oct 15, 2023
Last Activity

Mckinsey new hire - advice on development and should I work on weekends?

analysis entry level Excel McKinsey newbie PowerPoint Problem Solving

Most recent answer on Oct 15, 2023

Vlad

Expert

McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School

Vlad

Expert

gave the best answer on Jan 06, 2019

McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School

Hi, First of all - try to get on the project. There is nothing worse than sitting on the beach with no skills Secondly - please practice on your own I would concentrate on getting the right financial modeling skil ... (read entire answer)

3
Answers

4.3 k
Views

22
Total Upvotes

on Oct 15, 2023 on Oct 15, 2023
Last Activity

what excel skills do i need to start my consulting internship

Excel

Most recent answer on Oct 15, 2023

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 common functions that were the most useful 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 Condit ... (read entire answer)

4
Answers

4.4 k
Views

19
Total Upvotes

on Oct 15, 2023 on Oct 15, 2023
Last Activity

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

Excel

Most recent answer on Oct 15, 2023

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 my perspective having started consulting with zero excel skills, and having also done numerous models across my time in consulting. You'll pick up whatever you need to learn on the job Sure you can take basi ... (read entire answer)

3
Answers

949
Views

19
Total Upvotes

on Oct 15, 2023 on Oct 15, 2023
Last Activity

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

Excel financial modeling

Most recent answer on Oct 15, 2023

gave the best answer on Jun 12, 2021

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)

2
Answers

907
Views

23
Total Upvotes

on Oct 15, 2023 on Oct 15, 2023
Last Activity

In preparation to my job at Bain I would like to improve my analytical skills. Any advice on how to improve these?

analytics Excel MBB preparation

Most recent answer on Aug 31, 2023

Francesco

Expert

#1 Coach for Sessions (4.500+) | 1.500+ 5-Star Reviews | Proven Success (➡ interviewoffers.com) | Ex BCG | 10Y+ Coaching

Francesco

Expert

gave the best answer on Sep 06, 2017

#1 Coach for Sessions (4.500+) | 1.500+ 5-Star Reviews | Proven Success (➡ interviewoffers.com) | Ex BCG | 10Y+ Coaching

Hi Anonymous, I would assume you are referring to the actual job at Bain. In general there is no statistical analysis that should be performed in a strategy-consulting job (unless you have a background in statistics a ... (read entire answer)

4
Answers

3.7 k
Views

5
Total Upvotes

on Aug 31, 2023 on Aug 31, 2023
Last Activity

Best online courses

Excel financial analysis

Question edited on May 02, 2023

Cristian

Expert

#1 rated MBB & McKinsey Coach

Cristian

Expert

gave the best answer on May 01, 2023

#1 rated MBB & McKinsey Coach

Hi there, This sounds like an amazing question to ask ChatGPT. Let us know as well what answers you get ;) By the way, if you're looking to improve these to be prepared for when you go into consulting, I wouldn't stres ... (read entire answer)

5
Answers

476
Views

40
Total Upvotes

on May 02, 2023 on May 02, 2023
Last Activity

Expected skill level in Excel and Powerpoint at the start of internship

Excel PowerPoint

Most recent answer on Nov 13, 2022

Francesco

Expert

#1 Coach for Sessions (4.500+) | 1.500+ 5-Star Reviews | Proven Success (➡ interviewoffers.com) | Ex BCG | 10Y+ Coaching

Francesco

Expert

gave the best answer on Nov 11, 2022

#1 Coach for Sessions (4.500+) | 1.500+ 5-Star Reviews | Proven Success (➡ interviewoffers.com) | Ex BCG | 10Y+ Coaching

Hi Knut, Congratulations on the offer! In terms of your question: Q: Excel and PowerPoint. How high of a standard does MBB expect you to have when starting your internship? Is lacking skills a common reason for not rece ... (read entire answer)

9
Answers

691
Views

44
Total Upvotes

on Nov 13, 2022 on Nov 13, 2022
Last Activity

Best training datasets for learning Excel

Excel

Most recent answer on Oct 28, 2022

Cristian

Expert

#1 rated MBB & McKinsey Coach

Cristian

Expert

gave the best answer on Oct 27, 2022

#1 rated MBB & McKinsey Coach

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

769
Views

26
Total Upvotes

on Oct 28, 2022 on Oct 28, 2022
Last Activity

Do you have a question for our consulting experts, too?

Excel and PowerPoint

consulting Excel PowerPoint

Most recent answer on Aug 05, 2022

gave the best answer on Aug 04, 2022

Hi there, MOST IMPORTANTLY: Know that no-one can perfectly prepare for the job and that's the point: You will mess up, you will learn, you will be trained and supported. That's OK! For Excel + Powerpoint: You have a few ... (read entire answer)

4
Answers

687
Views

40
Total Upvotes

on Aug 05, 2022 on Aug 05, 2022
Last Activity

Excel skills

Excel

Most recent answer on Apr 22, 2022

Florian

Expert

Highest-rated McKinsey coach (ratings, offers, sessions) | 500+ offers | Author of The 1% & Consulting Career Secrets

Florian

Expert

gave the best answer on Apr 21, 2022

Highest-rated McKinsey coach (ratings, offers, sessions) | 500+ offers | Author of The 1% & Consulting Career Secrets

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

1.4 k
Views

27
Total Upvotes

on Apr 22, 2022 on Apr 22, 2022
Last Activity

EXCEL Material

background information BCG BCG Case Interview Client and MBB Excel I'm preparing to McK coming next week

Most recent answer on Oct 07, 2021

Florian

Expert

Highest-rated McKinsey coach (ratings, offers, sessions) | 500+ offers | Author of The 1% & Consulting Career Secrets

Florian

Expert

gave the best answer on Oct 07, 2021

Highest-rated McKinsey coach (ratings, offers, sessions) | 500+ offers | Author of The 1% & Consulting Career Secrets

Hey there,I don't believe that is necessary as others have pointed out already. If you are interested in preparing for your new role, I'd suggest the following: When I got the offer some years ago I did the same. I reac ... (read entire answer)

7
Answers

1.0 k
Views

95
Total Upvotes

on Oct 07, 2021 on Oct 07, 2021
Last Activity

Excel modelling practice

Excel MBB

Most recent answer on Jun 04, 2021

gave the best answer on Jun 04, 2021

Hi there, Hope you're doing well as well! There are a fair few online resources that you can google. In addition to that, Udemy, 2U, and HubSpot are pretty good! I also recommend downloading free datasets (Such as ... (read entire answer)

3
Answers

1.4 k
Views

43
Total Upvotes

on Jun 04, 2021 on Jun 04, 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

Ken

Expert

Ex-McKinsey final round interviewer | Executive Coach

Ken

Expert

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

3.5 k
Views

39
Total Upvotes

on Jun 02, 2021 on Jun 02, 2021
Last Activity

What Excel Prep course do you recommend?

bestcourse courses Excel

Most recent answer on Apr 04, 2021

Adi

Expert

Accenture, Deloitte | Precision Case Prep | Experienced Interviewer & Career Coach | 15 years professional experience

Adi

Expert

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

1.5 k
Views

36
Total Upvotes

on Apr 04, 2021 on Apr 04, 2021
Last Activity

I hear that A.T Kearney has an excel based assessment test in the Final round.Could some one throw more light on this part of the interview?

A.T. Kearney business analyst consulting Excel

Most recent answer on Oct 31, 2020

Anonymous A gave the best answer on Jan 23, 2018

ATK Milan and Dubai do not have an excel base test, or at least they didn't since few years ago (2016). Though ATK south america had a test before the first round.

4
Answers

5.4 k
Views

8
Total Upvotes

on Oct 31, 2020 on Oct 31, 2020
Last Activity

How can I ensure a full time offer after a summer internship at top management consulting firms?

consulting Excel full-time internship Intership get the offer MBB offer Top tier

Most recent answer on Sep 26, 2020

Anonymous gave the best answer on Jun 29, 2017

Hi Ibrahim, First of all, congrats on the offers! Definitely a good problem to have in terms of deciding where to go. As far as securing an offer goes, there's three things that I think you should account for duri ... (read entire answer)

4
Answers

9.2 k
Views

8
Total Upvotes

on Sep 26, 2020 on Sep 26, 2020
Last Activity

1 - 20 of 30 results

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.