How to prepare for consulting career

Hi there,

Really great question!

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!

--------------------------------------------------------------------------------------

First: Read the 25 tips in my consulting handbook here: https://www.spencertom.com/2018/01/14/consulting-survival-guide/

--------------------------------------------------------------------------------------

Second: Attend an academy

There are so many great training programs that prepare new graduates for the consulting world! I'm part of a few myself. Feel free to shoot me a message and I can point you in the right direction!

--------------------------------------------------------------------------------------

Third: In terms of things you can learn/do to prepare beforehand:

1) Daily Reading

• The Economist, The Financial Times, BCG/Mskinsey Insights

2) Industry deep-dives

• Learn, in-depth, how the industries/companies your office advises, work. (PM me for an industry overview template)

3) Analytics tools

• Alteryx, Tableau, etc.

4) Excel

• https://www.preplounge.com/en/consulting-forum/free-online-resources-to-learn-excel-basics-6946
• Pivottables
• Working with data
• Key fuctions (vlookup, Index match, count and sum if/ifs, sumproduct, concat, etc.)
• Hotkeys (i.e. use keyboard more than your mouse)
• Financial modeling

5) Powerpoint

• https://www.preplounge.com/en/consulting-forum/powerpoint-skills-4072
• Wireframing
• Lead-in titles
• Best practices/standards
• Different layouts
• Quickly editing/updating slides
• Thinking in PowerPoint

6) Presentation skills / sharp communication

• There are some great online/virtual classes for this (including the academies meantioned above

--------------------------------------------------------------------------------------

Fourth: In terms of doing well in your role when you're there:

1) Understand the context/prompt (what role are you in, what company, who's watching, etc.)

2) Understand the objective (what, specifically, is expected from you...both day to day, and in your overall career progression)

3) Quickly process information, and focus on what's important - Take a lot of information and the unknown, find the most logical path, and focus on that.

4) Be comfortable with the unknown, and learn to brainstorm - think/speak like an expert without being one

In summary, there will always be a flood of information, expectations, competition etc. and not enough time. Find out which ones matter when. (i.e. be visibile and focus efforts on the things that people care about)

--------------------------------------------------------------------------------------

Fifth: Here are some great prior Q&As for you!

https://www.preplounge.com/en/consulting-forum/how-hard-is-it-to-excel-in-top-consulting-firms-6762

https://www.preplounge.com/en/consulting-forum/how-to-become-an-engagement-manager-and-partner-quickly-6722

https://www.preplounge.com/en/consulting-forum/need-to-learn-skills-in-the-ample-free-time-before-starting-at-an-mbb-what-should-i-do-6774

Hi there,

Congrats on the offer. If you want to take courses I would concentrate on the technical side on:

• Financial modelling
• Anything that could help to increase speed with Excel
• Anything that could help with advanced data analysis (eg SQL and VBA)

Below you can also find a list of things that could be useful to practice during your first weeks:

1. Take notes when your manager tells you something – this will help you to remember details and will show you care about them to the team.
2. Always double-check. The first impression is very important in consulting: if you show you are reliable from the beginning, you create a reputation of a reliable person. Double checks should be done on expectations for your job, your Excel analysis, your slides – basically everything.
3. Define priorities before starting any set of tasks. The majority of the results usually come from a subset of activities – this is true also for your tasks in consulting. You have to identify which they are and prioritize them – the application of the so-called 80-20 rule or Pareto Principle. Alignment on priorities and expectations is particularly important with your manager at the beginning of the project.
4. Socialize with your colleagues and start to build a network. Consulting is a people business and you should build a good network both within and outside the company. A good start is key to develop good relationships long-term
5. Organize your private life activities. You want to organize your calendar to leave some space for personal activities (sport/ friends/ family). This is not easy but can be managed if you organize well, and long-term will be critical to keep a balance between work and private life. Also, it is better to align with your manager/teammates from the beginning on your core needs, so that there are no surprises later on.
6. Ask for feedback every two-three weeks – this will show you are proactive and willing to learn.
7. Ask for help when you don't know what to do – better to let know you are in trouble with meeting a deadline then missing the deadline.
8. Be social and respectful with the support staff – these people are great and influential as well in the company.

Good luck!

Francesco

Hi Anonymous,

first of all, congratulations on your offer! If you want to prepare in advance before you start, I would recommend working on technical, communication and stress management skills.

• On the technical side, Excel will be the most important technical thing to master at the beginning, in particular for VLOOKUPs and Pivot tables; you could also review PowerPoint, which you will also use quite a lot.
  • At BCG we got learning courses we could use to improve on them, and I guess you will receive the same at McKinsey, but so far that you have already mastered the skills before joining (you can find several courses online for both), even better.
  • Tip for Excel: learn how to use as much as possible the keyword and relegate the touchpad to the minimum – this will skyrocket your productivity in the long term. Some computer programs such as KeyRocket provide tips to improve on this.
• For what concerns communication, I would recommend the classic book on the topic: “How to Win Friends and Influence People” by Dale Carnegie.
• For stress management, I would recommend two books:
  • “The Miracle Morning” by Hal Elrod – great tips to start in the right way your day
  • “The Magic of Thinking Big” by David Schwartz – a great sum up of some of the best tips be positive, productive and achieve more

Below you can also find a list of things that could be useful to practice during your first weeks:

1. Take notes when your manager tells you something – this will help you to remember details and will show you care about them to the team.
2. Always double check. The first impression is very important in consulting: if you show you are reliable from the beginning, you create a reputation of a reliable person. Double checks should be done on expectations for your job, your excel analysis, your slides – basically everything.
3. Define priorities before starting any set of tasks. The majority of the results usually come from a subset of activities – this is true also for your tasks in consulting. You have to identify which they are and prioritize them – the application of the so-called 80-20 rule or Pareto Principle.
4. Socialize with your colleagues and start to build a network. Consulting is a people business and you should build a good network both within and outside the company. A good start is key to develop good relationships long-term
5. Organize your private life activities. You want to organize your calendar to leave some space for personal activities (sport/ friends/ family). This is not easy but can be managed if you organize well, and long-term will be critical to keep a balance between work and private life. Also, it is better to align with your manager/teammates from the beginning on your core needs, so that there are no surprises later on.
6. Ask for feedback every two-three weeks – this will show you are proactive and willing to learn.
7. Ask for help when you don't know what to do – better to let know you are in trouble with meeting a deadline then missing the deadline.
8. Be social and respectful with the support staff – these people are great and influential as well in the company.

Hope this helps,

Francesco

Hi Anonymous,

first of all, congratulations on your offers - that's a really good outcome! Below you can find a couple of things that could be useful to practice during your first weeks:

1. Take notes when your manager tells you something – this will help you to remember details and will show you care about them to the team.
2. Always double check. The first impression is very important in consulting: if you show you are reliable from the beginning, you will create a reputation of a reliable person. Double checks should be done on expectations for your job, your excel analysis, your slides – basically everything.
3. Define priorities before starting any set of tasks. The majority of the results usually come from a subset of activities – this is true also for your tasks in consulting. You have to identify which they are and prioritize them – the application of the so-called 80-20 rule or Pareto Principle.
4. Socialize with your colleagues and start to build a network. Consulting is a people business and you should build a good network both within and outside the company. A good start is key to develop good relationships long-term
5. Organize your private life activities. You want to organize your calendar to leave some space for personal activities (sport/ friends/ family). This is not easy but can be managed if you organize well, and long-term will be critical to keep a balance between work and private life. Also, it is better to align with your manager/teammates from the beginning on your core needs, so that there are no surprises later on.
6. Ask for feedback every two-three weeks – this will show you are proactive and willing to learn.
7. Ask for help when you don't know what to do – better to let know you are in trouble with meeting a deadline then missing the deadline.
8. Be social and respectful with the support staff – these people are great and influential as well in the company.

If you want to prepare in advance before you start, you could work on both technical and communication skills.

• On the technical side, Excel will be the most important technical thing to master at the beginning, in particular for VLOOKUPs and Pivot tables; you could also review PowerPoint, which you will also use intensively.
  • At BCG you will be able to take part in learning courses to improve, but so far that you have already mastered the skills before joining (you can find several courses online for both), even better.
  • Tip for Excel: learn how to use as much as possible the keyword and relegate the touchpad to the minimum – this will skyrocket your productivity in the long term.
• For what concerns communication, a classic on the topic is the book “How to win friends and influence people” by Dale Carnegie.

Hope this helps,

Francesco

Hi Anonymous,

first of all, congratulations for your offer! I agree with Vlad that, although being updated on the news can be helpful, there are some more important elements to secure a good performance from the beginning. I believe a good preparation would include technical, communication and goal setting/stress management skills.

• On the technical side, as also mentioned by Vlad, Excel will be the most important technical thing to master at the beginning, in particular for what concerns VLOOKUP and Pivot tables; an additional useful review may concern PowerPoint, which you will also use pretty intensively. At BCG we got learning courses we could use to improve on them, and I guess you will receive the same in every MBB, but so far that you have already mastered the skills before joining (you can find several courses online for both for free), even better.
• For what concerns communication, a classic on the topic is the book “How to win friends and influence people” by Dale Carnegie. In case you have time for an additional job before starting your consulting career, an experience in a sales role could also help a lot.
• Finally, for goal setting/stress management I would recommend “The Secret” by Rhonda Byrne - great book to cultivate a positive attitude in a stressful environment.

A couple of things that could help you during your first weeks are also the following:

1. Take notes when your manager tells you something – this will help you to remember details and will show you care about them to the team.
2. Ask for feedback every two-three weeks – this will show you are proactive and willing to learn.
3. Always double check. First impression is very important in consulting: if you show you are reliable from the beginning, you will create a reputation of a reliable person.
4. Ask for help when you don't know what to do – better to let know you are in trouble with meeting a deadline then missing the deadline.
5. Be social and respectful with the support staff – these people are great and influential as well in the company.

Hope this helps,

Francesco

Hi,

The things that you've mentioned will help you to have a good conversation with the client, but it's not the most important thing at the entry level.

I would concentrate on getting the right financial modeling skills and presenting your analysis in Power Point.

1) Financial modeling - the best course I know is Training The Street. Take Financial Modeling, Valuation, Maybe LBO. Also, learn pivot tables and the basic statistics tools

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 reproduce to be able to do that fast.

The key thing - throw away your mouse and put some tape on your touchpad. Do everything with your keyboard!

2) Power Point

• First, read "Say it with charts" and "Pyramid Principle".
• As a next step Google for MBB presentations on SlideShare and try to replicate them in PPT.
• Finally, take MBA some cases (HBS or any other) and try to derive the conclusions and put them on slides using MBB styles.

And finally - take a long vacation before starting your job;)

While in consulting focus on the following:

• Having a good DGL / career counselor, etc. (Each company has different names). This is a person who guides your development in the company, collects the feedbacks on you, and presents your case to a promotion committee. Make sure to have a person who is organized enough to collect the feedbacks in time, who is a nice person in general and who has enough authority in the company (i.e. Senior partner - the more power he has - the better)
• Choosing the project you work on smartly (i.e. collect the feedbacks on each and everyone prior to accepting the project)
• Perfect technical skills (Excel, PPT, Problem Solving)
• Good feedbacks on you from the client. Thus try to make friends with your clients (Both senior and non-senior role. Even a bad feedback from a blue collar can ruin your career)
• Ability to manage your own standalone workstream with minimum supervision. TOP performers bring the end products that impress others
• Being proactive - helping the team with daily routine, scheduling, etc. Participating in the office initiatives
• Establishing relationships with your managers and partners. Ideally, you should have multiple senior partners to be excited about you and to support you)
• Being lucky!

Good Luck!

Hi,

1. Financial modeling of all sorts since it's a must. Can recommend Training The Street courses
2. SQL and Tableau are used more and more in consulting, so I recommend you practice them. I recommend starting with DataCamp

Best

Hi,

I would concentrate on getting the right financial modeling skills and presenting your analysis in Power Point.

1) Financial modeling - the best course I know is Training The Street. Take Financial Modeling, Valuation, Maybe LBO. Also, learn pivot tables and the basic statistics tools

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 reproduce to be able to do that fast.

The key thing - throw away your mouse and put some tape on your touchpad. Do everything with your keyboard!

2) Power Point

• First, read "Say it with charts" and "Pyramid Principle".
• As a next step Google for MBB presentations on SlideShare and try to replicate them in PPT.
• Finally, take MBA some cases (HBS or any other) and try to derive the conclusions and put them on slides using MBB styles.

And finally - take a long vacation before starting your job;)

While in consulting focus on the following:

• Having a good DGL / career counselor, etc. (Each company has different names). This is a person who guides your development in the company, collects the feedbacks on you, and presents your case to a promotion committee. Make sure to have a person who is organized enough to collect the feedbacks in time, who is a nice person in general and who has enough authority in the company (i.e. Senior partner - the more power he has - the better)
• Choosing the project you work on smartly (i.e. collect the feedbacks on each and everyone prior to accepting the project)
• Perfect technical skills (Excel, PPT, Problem Solving)
• Good feedbacks on you from the client. Thus try to make friends with your clients (Both senior and non-senior role. Even a bad feedback from a blue collar can ruin your career)
• Ability to manage your own standalone workstream with minimum supervision. TOP performers bring the end products that impress others
• Being proactive - helping the team with daily routine, scheduling, etc. Participating in the office initiatives
• Establishing relationships with your managers and partners. Ideally, you should have multiple senior partners to be excited about you and to support you)
• Being lucky!

Good Luck!

Hi,

I would concentrate on getting the right financial modeling skills and presenting your analysis in Power Point.

1) Financial modeling - the best course I know is Training The Street. Take Financial Modeling, Valuation, Maybe LBO. Also, learn pivot tables and the basic statistics tools

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 reproduce to be able to do that fast.

The key thing - throw away your mouse and put some tape on your touchpad. Do everything with your keyboard!

2) Power Point

• First, read "Say it with charts" and "Pyramid Principle".
• As a next step Google for MBB presentations on SlideShare and try to replicate them in PPT.
• Finally, take MBA some cases (HBS or any other) and try to derive the conclusions and put them on slides using MBB styles.

And finally - take a long vacation before starting your job;)

While in consulting focus on the following:

• Having a good DGL / career counselor, etc. (Each company has different names). This is a person who guides your development in the company, collects the feedbacks on you, and presents your case to a promotion committee. Make sure to have a person who is organized enough to collect the feedbacks in time, who is a nice person in general and who has enough authority in the company (i.e. Senior partner - the more power he has - the better)
• Choosing the project you work on smartly (i.e. collect the feedbacks on each and everyone prior to accepting the project)
• Perfect technical skills (Excel, PPT, Problem Solving)
• Good feedbacks on you from the client. Thus try to make friends with your clients (Both senior and non-senior role. Even a bad feedback from a blue collar can ruin your career)
• Ability to manage your own standalone workstream with minimum supervision. TOP performers bring the end products that impress others
• Being proactive - helping the team with daily routine, scheduling, etc. Participating in the office initiatives
• Establishing relationships with your managers and partners. Ideally, you should have multiple senior partners to be excited about you and to support you)
• Being lucky!

Good Luck!

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é

Dear A,

First of all, my congratulations to your offers, I wish you best of luck in your career.

For candidates like you, who have already secured the offer with a leading consulting firm, I have designed my program "Get ready for the first 100 days " as well as long-term career planning. This program touches all the important aspects: the mindset, the skills, knowledge, networking and ,managing yourself as well, your bosses and clients - everything that is important in your successful career.

In fact, I'm sharing my knowledge of 6 years career experience in consulting, where I was able to land on the fast track promotion and to be promoted from consultant to a project manager just within 3 years, which is extremely fast.

Happy to share these insights with you, feel free to reach out directly to me.

Good luck,

André

Dear A,

First thing I would recommend you is to take rest and spend your time with family and friends.

As mentioned other coaches, you can do some excel basic course, storry-telling etc.

What I can add from my side is that I have a program "First 100 days in your career and long term career success", where you can get all skills you need to start you career successfully, tips on communications with different ranges of your co-workers, client, managers, and also trocks on how to get your promotion faster.

If you have any further questions, feel free to contact.

Best,
André

Dear A,

First of all, my congratulations to your MBB offer, I wish you best of luck in your career.

For candidates like you, who have already secured the offer with a leading consulting firm, I have designed my program "Get ready for the first 100 days " as well as long-term career planning. This program touches all the important aspects: the mindset, the skills, knowledge, networking and ,managing yourself as well, your bosses and clients - everything that is important in your successful career.

In fact, I'm sharing my knowledge of 6 years career experience in consulting, where I was able to land on the fast track promotion and to be promoted from consultant to a project manager just within 3 years, which is extremely fast.

Happy to share these insights with you, feel free to reach out directly to me.

Good luck,

André

https://www.preplounge.com/en/consulting-forum/recommended-readings-resources-to-prepare-for-consulting-job-at-mbb-3155#a7114