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!
Frage gesperrt
Diese Frage ist schreibgeschützt, da sie mit folgender Frage zusammengefügt wurde: How to prepare for consulting career.

Recommended readings / resources to prepare for consulting job at MBB?

MBB
Neue Antwort am 29. Sept. 2020
4 Antworten
2,1 T. Views
Anonym B fragte am 20. Dez. 2018

Starting soon as a consultant at one of the MBB firms, and I was wondering if there are any recommended readings, articles, or skills I should brush up on (excel?) to look at before my start-date?

Thanks!

Übersicht der Antworten

Upvotes
  • Upvotes
  • Datum aufsteigend
  • Datum absteigend
Beste Antwort
Guennael
Experte
antwortete am 20. Dez. 2018
Ex-MBB, Experienced Hire; I will teach you not only the how, but also the why of case interviews

Congratulations!

- Excel definitely a must. There are various (cheap) excel training modules around, I highly suggest you get familiar w/ excel quickly if you aren't yet. Pivot tables, vlookups, even index match...

- Keyboard shortcuts. My first manager told me to get rid of my mouse (which is also standard procedure in banking btw)

- PowerPoint, sure why not

- Web scrapping, sure why not

- Above all, I'd relax and enjoy the down time right now; go out, sleep, exercise... Pretty soon, you'll have more work and stress than you'd want

Anonym antwortete am 29. Sept. 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.

The core skills of a competent business Excel user are something like:

  • Formatting & basic formulas
  • Mouse-free Excel navigation
  • Vlookups & conditional statements
  • Data analysis - filtering, sorting, and analyzing data
  • Data visualization - tables, charts, and dual axis charts
  • What-if-analysis
  • Pivot tables

If you can do these things, you’ll outperform 95% of people in the workplace.

To learn these concepts, you could:

  • Learn the concepts online for free
  • Take an online course

If you’re looking for something free, I’d recommend Googling & Youtube-ing those topics on my list. Tons of free material online. On Udemy you can also find some courses.

If you’re short on time, take a short business-focused online course.

I’d recommend the following business-focused course focused on mastering the 20% of functions that make up 80% of Excel work.

Best,

André

Upvotes
1
Egor
Experte
antwortete am 26. Dez. 2018
Collected McKinsey & BCG offers/ Ex-McKinsey consultant/Harvard/WBS/MSU

Hi A,

I agree with Guennael. If I were, I would prioritize excel and communication skills at an associate/BA-levels.

It is important to mention that you will have an induction week, during which you will practice all required skills.

What’s more, you will learn a lot on the job. Don’t afraid to ask questions, colleagues will be always happy to help you and suggest a more effective way of doing things. Once you know it, you can google it and that’s it.

All the best,

Egor

Anonym antwortete am 21. Dez. 2018

And if you're not already a member: Get those frequent flyer programs :-D

Upvotes
0
Guennael gab die beste Antwort

Guennael

Ex-MBB, Experienced Hire; I will teach you not only the how, but also the why of case interviews
284
Meetings
1.459
Q&A Upvotes
64
Awards
5,0
171 Bewertungen