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!
Back to overview

Incoming McKinsey BA - What are courses to get up to speed in Excel AND PPT, specifically designed for consultants?

I am starting as a BA in 4 months and I am super nervous. 

I want to make my excel and ppt skills best I can before I start. 

I know there are many free materials everywhere but I am looking for a structured course or program to get up to speed in Excel and PPT, specifically for consulting. 

Any recommendations?

3 Answers
300+ Views
44
Be the first to answer!
Nobody has responded to this question yet.
Top answer
Hagen
Coach
on Oct 28, 2024
#1 recommended coach | >95% success rate | most experience in consulting, interviewing, and coaching

Hi there,

First of all, congratulations on the upcoming consulting career start with McKinsey!

I would be happy to share my thoughts on your question:

  • First of all, while it is great to see how eager you are to prepare for your consulting career start, I would highly advise you not to worry about it.
  • All major consulting firms provide you with excellent onboarding and training that will prepare you for everything you need to know.
  • Lastly, if you still want to improve your MS PowerPoint and Excel skills on your own, I would advise you to focus on learning common MS Excel functions as well as MS Excel and PowerPoint shortcuts.

If you would like a more detailed discussion on your specific situation, please don't hesitate to contact me directly.

Best,

Hagen

Florian
Coach
on Sep 30, 2024
1400 5-star reviews across platforms | 500+ offers | Highest-rated case book on Amazon | Uni lecturer in US, Asia, EU

Hey there,

Congrats on the achievement!

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 reached out to people I knew in McKinsey and people who interviewed me to ask: what can I do to make the start easier? how can I prepare?

The answer from everyone was: Relax! Enjoy your time before you start and don't think about it. You will figure it out on the job. I followed that advice and it made sense to me once I joined.

When you start at in top tier consulting there are 2 ways to learn:

  1. Formal training. The formal training sessions/ weeks/ days in the beginning, are nice, however, they are more for networking and meeting your peers. You learn some interesting concepts and get some useful tips from more experienced consultants BUT
  2. Constant and implicit learning on the job is where it's at. No matter if you are a newcomer or a veteran after 2 years, you will always find yourself on a steep learning curve. As soon as you barely mastered one skill or the skills needed for one level in the hierarchy, you will take care of things, which are expected from a more senior colleague. This cycle never ends. You are expected to learn on the job, learn from your colleagues, your mentors, sometimes even the client. So basically a newly promoted Engagement Manager has the same 'struggle' as a new-hire Business Analyst. They both need to work in a completely new environment and role.

Knowing that, if we now go back to square one in your MBB journey it makes perfect sense to enter the firm with a blank slate with a lot of curiosity and eagerness to soak it all up and quickly learn the ropes.

Nothing matches the experience and the learning and this is a good thing (also the reason why ex-MBBs are valued highly on the job market).

You will learn everything you need to master while doing it. You will be thrown in the cold water and need to swim. However, your colleagues will always be happy to help you and mentor you. And for the rest, you will figure everything out along the way. The key here is always to ask for tips, shortcuts, feedback, etc. Don't be quiet if you get stuck.

Lastly, if you have no domain knowledge about a certain industry or topic, read through the internal library of documentation (which is endless) and call some of the firm experts on the topic. Usually, they are happy to offer you a short call to get you up to speed.

But here’s something extra: Since the question came up ever so often with my clients, I've authored a book titled "Consulting Career Secrets," specifically to guide newcomers like you in navigating this journey. The goal of the book was to answer all typical questions of entry-level consultants and show them the way to make the entry and the transition as simple and painless as possible. 

While no book or training can entirely prep you for the unique experiences of your first day, week, or project, it offers comprehensive insights to mentally prepare you, suggests essential tools and skills to acquire, shows you the ways how to do that, and strategies to quickly adapt and excel in your new role. 

You can DM me if you want to know more.

In any case, don't sweat the small stuff and enjoy the ride!

Florian

Alberto
Coach
on Sep 30, 2024
Ex-McKinsey Partner | Most experienced coach (15 years exp, +2.000 real interviews) | 95% success rate

One week at McKinsey is worth 3 months of external courses

Don't stress out with being ready. Everything is designed so you can get up to speed very fast. Enjoy the upcoming days to do things that charge your physical, mental and emotional energy. You will need to be at your 200% when you start.

Similar Questions
Consulting
How Long Does It Take Bain To Respond to Application
on Nov 20, 2024
USA
5 Answers
100+ Views
Top answer by
Ex-BCG Project Leader - BOS, Exp. Hire, Energy/Climate & Sustainability | Trained Interviewer | Free 15min Consultation
25
5 Answers
100+ Views
+2
Consulting
Looking to transition from Data & Analytics to Strategy/Analytics Consulting
on Nov 13, 2024
USA
4 Answers
200+ Views
Top answer by
Daniel
Coach
FREE 15 MIN CALL | ex-Strategy& Manager & Interviewer | Non-Traditional Path | 50+ Coachings
49
4 Answers
200+ Views
+1
Consulting
What starting full-time position has better reputation and career growth opportunities?
on Nov 05, 2024
USA
3 Answers
100+ Views
Top answer by
Oumar
Coach
Ex-McKinsey Interviewer | Case Interview Expertise | Helping Aspiring Consultants Succeed on PrepLounge
23
3 Answers
100+ Views
How likely are you to recommend us to a friend or fellow student?
0 = Not likely
10 = Very likely
You are a true consultant! Thank you for consulting us on how to make PrepLounge even better!