Get Active in Our Amazing Community of Over 448,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!

Has anyone taken the Management Consulted "Excel & PPT course"?

online courses
New answer on May 22, 2022
4 Answers
1.5 k Views
Anonymous A asked on May 18, 2022

Hi guys, I will be starting my new consultant role in 1.5 months. I'm wondering are there any specific course designed for consultants? Based on my desktop research, the only one I've found is the “Excel & PPT” course provided by Management Consulted (https://managementconsulted.com/product/excel-powerpoint-consulting/).

Just wondering has anyone taken the course and is $500 worthwile? Would you recommend other resources that is better? Thanks!

Overview of answers

Upvotes
  • Upvotes
  • Date ascending
  • Date descending
Best answer
Clara
Expert
Content Creator
replied on May 20, 2022
McKinsey | Awarded professor at Master in Management @ IE | MBA at MIT |+180 students coached | Integrated FIT Guide aut

Hello!

Congrats of that offer!

I think you can also get it for free in many many places. PFB a list of the most popular commands:

Basic operations: SUM, SUMPRODUCT

Text transformations: CONCATENATE, LEFT, RIGHT, & operator,

Connecting different datasets: VLOOKUP, HLOOKUP, INDEX(MATCH(),MATCH())

Conditional-based operations: SUMIF, COUNTIF, SUMIFS, COUNTIFS, COUNTA

Learn how to analyze data using Pivot Tables

There are plenty of online materials -unfortunately now we cannot post the adress but you can find them easily-

Microsoft Support: support .office

Kubicle: kubicle.com (go for the 7 days free trial - Excel for Business Analytics)

Hope it helps!

Cheers,

Clara

Was this answer helpful?
Mario
Expert
replied on May 22, 2022
Ex-Mckinsey (analyst->associate->manager) and now in tech (Bytedance) + Part time interview coach and mentor

I would recommend taking a break and recharging your battery. Consulting can be tough in terms of lifestyle (but the skills you acquire are essential). 

That said, I wouldn't take on any extensive and serious extra training at this stage.

However, one course I took which has been highly beneficial and that actually made me stand out is called “beyond formulas” on Udemy. It teaches you everything you need to know about basic modeling. In addition, you can watch some alteryx and Tableau trainings but these are easier to learn on the job.

 

Best of luck !

 

Mario

Was this answer helpful?
Ian
Expert
Content Creator
replied on May 19, 2022
#1 BCG coach | MBB | Tier 2 | Digital, Tech, Platinion | 100% personal success rate (8/8) | 95% candidate success rate

Hi there,

Personally, I probably wouldn't pay for that (there are many other things I would spend that $ on).

You can download free excel sheets and learn yourself. There are plenty of free courses as well. The company will train you in this material as well.

If you are worried about ramping up quickly, that investment could be worth it! But, there are alternatives. Here's some other advice for getting ready….

==================================

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: I have a consulting survival guide handbook with 25 key tips for surviving the consulting world. Feel free to message me for it!

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

Second: 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

5) Powerpoint

  • Best practices/standards
  • Different layouts
  • Quickly editing/updating slides
  • Thinking in PowerPoint

6) Presentation skills / sharp communication

  • There are some online/virtual classes for this

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

Third: 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 timeFind out which ones matter when. (i.e. be visibile and focus efforts on the things that people care about)

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

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

https://www.preplounge.com/en/consulting-forum/what-makes-a-good-consultant-how-to-get-a-good-review-6790

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

Was this answer helpful?
Lucie
Expert
Content Creator
replied on May 18, 2022
10+yrs recruiting & BCG Project leader

Hi there, 

I wouldn't spend any money now, MBB will give you all the training to acquire all skills needed to succeed in your new role. Hence I would recommend to enjoy your time in this 1.5 months and relax…. just recharge battery!

Good luck,

Lucie

Was this answer helpful?

Was this answer helpful?
How likely are you to recommend us to a friend or fellow student?
0
1
2
3
4
5
6
7
8
9
10
0 = Not likely
10 = Very likely