Werde aktiv in unserer Community aus über 451.000 Gleichgesinnten!

Verabrede dich zum Casen über das Meeting-Board, nimm an Diskussionen in unserem Consulting Q&A teil und finde gleichgesinnte Case-Partner, um dich auszutauschen und gemeinsam zu üben!

Wie funktioniert das Consulting Q&A?

Jeder kann eine Frage stellen

Jeder kann eine Antwort verfassen

Upvotes lassen Antworten nach oben steigen

solve – McKinney's assessment game excel templet

Analytiktest Excel free resources McKinsey McKinsey Imbellus Problem Solving Test

Neueste Antwort am 5. März 2024

Alberto

Experte

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

Alberto

Experte

gab die beste Antwort am 31. Jan. 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 ... (ganze Antwort lesen)

6
Antworten

287
Aufrufe

51
Upvotes insgesamt

am 5. März 2024 am 5. März 2024
Letzte Aktivität

Excel used in Consulting

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

Neueste Antwort am 18. Okt. 2023

Benjamin

Experte

Ex-BCG Principal | 8+ years consulting experience in SEA | BCG top interviewer & top performer

Benjamin

Experte

gab die beste Antwort am 15. Okt. 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 ... (ganze Antwort lesen)

8
Antworten

667
Aufrufe

62
Upvotes insgesamt

am 18. Okt. 2023 am 18. Okt. 2023
Letzte Aktivität

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

Excel

Neueste Antwort am 15. Okt. 2023

gab die beste Antwort am 27. Jan. 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 ... (ganze Antwort lesen)

7
Antworten

1,2 T.
Aufrufe

53
Upvotes insgesamt

am 15. Okt. 2023 am 15. Okt. 2023
Letzte Aktivität

Spannende Diskussionen aus der Community gesucht?

Melde dich jetzt an und finde weitere Fragen und Antworten zu aktuellen Themen aus der Branche in unserem Consulting Q&A.

Required Excel Skills for a Consulting Internship

Excel Excel case study

Neueste Antwort am 15. Okt. 2023

Benjamin

Experte

Ex-BCG Principal | 8+ years consulting experience in SEA | BCG top interviewer & top performer

Benjamin

Experte

gab die beste Antwort am 15. Okt. 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 ... (ganze Antwort lesen)

6
Antworten

4,4 T.
Aufrufe

15
Upvotes insgesamt

am 15. Okt. 2023 am 15. Okt. 2023
Letzte Aktivität

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

analysis entry level Excel McKinsey newbie PowerPoint Problem Solving

Neueste Antwort am 15. Okt. 2023

Vlad

Experte

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

Vlad

Experte

gab die beste Antwort am 6. Jan. 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 ... (ganze Antwort lesen)

3
Antworten

4,3 T.
Aufrufe

22
Upvotes insgesamt

am 15. Okt. 2023 am 15. Okt. 2023
Letzte Aktivität

what excel skills do i need to start my consulting internship

Excel

Neueste Antwort am 15. Okt. 2023

Benjamin

Experte

Ex-BCG Principal | 8+ years consulting experience in SEA | BCG top interviewer & top performer

Benjamin

Experte

gab die beste Antwort am 15. Okt. 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 ... (ganze Antwort lesen)

4
Antworten

4,4 T.
Aufrufe

19
Upvotes insgesamt

am 15. Okt. 2023 am 15. Okt. 2023
Letzte Aktivität

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

Excel

Neueste Antwort am 15. Okt. 2023

Benjamin

Experte

Ex-BCG Principal | 8+ years consulting experience in SEA | BCG top interviewer & top performer

Benjamin

Experte

gab die beste Antwort am 15. Okt. 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 ... (ganze Antwort lesen)

3
Antworten

949
Aufrufe

19
Upvotes insgesamt

am 15. Okt. 2023 am 15. Okt. 2023
Letzte Aktivität

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

Excel financial modeling

Neueste Antwort am 15. Okt. 2023

gab die beste Antwort am 12. Juni 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 ... (ganze Antwort lesen)

2
Antworten

907
Aufrufe

23
Upvotes insgesamt

am 15. Okt. 2023 am 15. Okt. 2023
Letzte Aktivität

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

Neueste Antwort am 31. Aug. 2023

Francesco

Experte

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

Francesco

Experte

gab die beste Antwort am 6. Sept. 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 ... (ganze Antwort lesen)

4
Antworten

3,7 T.
Aufrufe

5
Upvotes insgesamt

am 31. Aug. 2023 am 31. Aug. 2023
Letzte Aktivität

Best online courses

Excel financial analysis

Frage bearbeitet am 2. Mai 2023

Cristian

Experte

#1 rated MBB & McKinsey Coach

Cristian

Experte

gab die beste Antwort am 1. Mai 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 ... (ganze Antwort lesen)

5
Antworten

477
Aufrufe

40
Upvotes insgesamt

am 2. Mai 2023 am 2. Mai 2023
Letzte Aktivität

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

Excel PowerPoint

Neueste Antwort am 13. Nov. 2022

Francesco

Experte

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

Francesco

Experte

gab die beste Antwort am 11. Nov. 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 ... (ganze Antwort lesen)

9
Antworten

691
Aufrufe

44
Upvotes insgesamt

am 13. Nov. 2022 am 13. Nov. 2022
Letzte Aktivität

Best training datasets for learning Excel

Excel

Neueste Antwort am 28. Okt. 2022

Cristian

Experte

#1 rated MBB & McKinsey Coach

Cristian

Experte

gab die beste Antwort am 27. Okt. 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 ... (ganze Antwort lesen)

4
Antworten

770
Aufrufe

26
Upvotes insgesamt

am 28. Okt. 2022 am 28. Okt. 2022
Letzte Aktivität

Hast du auch eine Frage an unsere Consulting-Experten?

Dann melde dich jetzt kostenlos an und erhalte innerhalb kürzester Zeit wertvolle Insights unserer Coaches.

Excel and PowerPoint

consulting Excel PowerPoint

Neueste Antwort am 5. Aug. 2022

gab die beste Antwort am 4. Aug. 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 ... (ganze Antwort lesen)

4
Antworten

687
Aufrufe

40
Upvotes insgesamt

am 5. Aug. 2022 am 5. Aug. 2022
Letzte Aktivität

Excel skills

Excel

Neueste Antwort am 22. Apr. 2022

Florian

Experte

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

Florian

Experte

gab die beste Antwort am 21. Apr. 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 ... (ganze Antwort lesen)

5
Antworten

1,4 T.
Aufrufe

27
Upvotes insgesamt

am 22. Apr. 2022 am 22. Apr. 2022
Letzte Aktivität

EXCEL Material

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

Neueste Antwort am 7. Okt. 2021

Florian

Experte

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

Florian

Experte

gab die beste Antwort am 7. Okt. 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 ... (ganze Antwort lesen)

7
Antworten

1,0 T.
Aufrufe

95
Upvotes insgesamt

am 7. Okt. 2021 am 7. Okt. 2021
Letzte Aktivität

Excel modelling practice

Excel MBB

Neueste Antwort am 4. Juni 2021

gab die beste Antwort am 4. Juni 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 ... (ganze Antwort lesen)

3
Antworten

1,4 T.
Aufrufe

43
Upvotes insgesamt

am 4. Juni 2021 am 4. Juni 2021
Letzte Aktivität

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

Excel MBB New Joiner

Neueste Antwort am 2. Juni 2021

Ken

Experte

Ex-McKinsey final round interviewer | Executive Coach

Ken

Experte

gab die beste Antwort am 2. Juni 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
Antworten

3,5 T.
Aufrufe

39
Upvotes insgesamt

am 2. Juni 2021 am 2. Juni 2021
Letzte Aktivität

What Excel Prep course do you recommend?

bestcourse courses Excel

Neueste Antwort am 4. Apr. 2021

Adi

Experte

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

Adi

Experte

gab die beste Antwort am 31. März 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
Antworten

1,5 T.
Aufrufe

36
Upvotes insgesamt

am 4. Apr. 2021 am 4. Apr. 2021
Letzte Aktivität

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

Neueste Antwort am 31. Okt. 2020

Anonym A gab die beste Antwort am 23. Jan. 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
Antworten

5,4 T.
Aufrufe

8
Upvotes insgesamt

am 31. Okt. 2020 am 31. Okt. 2020
Letzte Aktivität

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

Neueste Antwort am 26. Sept. 2020

Anonym gab die beste Antwort am 29. Juni 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 ... (ganze Antwort lesen)

4
Antworten

9,2 T.
Aufrufe

8
Upvotes insgesamt

am 26. Sept. 2020 am 26. Sept. 2020
Letzte Aktivität

1 - 20 von 30 Ergebnissen

Consulting Q&A - Stelle Fragen rund um Deine Karriere

In dieser Übersicht findest Du alle bisher gestellten Fragen der PrepLounge-Community. Jeder kann Fragen stellen und Antworten verfassen. Unsere Coaches stellen auch gerne ihre Expertise bereit. Wenn Dir eine Antwort gefällt, gib ihr ein Upvote, sodass sie nach oben steigt. Hier findest Du außerdem unsere Richtlinien und FAQs zum Consulting Q&A.