Consulting Tools and Tips
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Consulting Tools and Tips
This course is part of Management Consulting Specialization
Instructor: John Kim
Top Instructor
14,834 already enrolled
Included with
Ask Coursera
416 reviews
416 reviews
What you'll learn
How to get smart quickly on a new topic? What is industry analysis? How to benchmark companies? How to make great excel models?
Skills you'll gain
Tools you'll learn
Details to know
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
There are 5 modules in this course
This is the #4 course in the specialization on management consulting.
Management consultants are quick learners. When you first join a generalist consulting firm, you are expected to learn core consulting skills and will likely be staffed on projects across industry and functions. You might be on a chemicals pricing project, then a retail cost-reduction project. It’s critical that you learn “how to get smart quickly” and ask smart questions. At the same time, you should develop an armory of tools to create data through client interviews, surveys, benchmarking, and observations.
What's the first thing you do when learning something new? Internet, of course. So, if you have a new client, in a new industry that you don't know a lot about, where should you start? Learn the first 10 steps you should take to learn the company's business, financials, and industry trends. Work smart.
What's included
5 videos4 readings1 assignment3 discussion prompts
5 videos•Total 36 minutes
- What will we learn from this course?•7 minutes
- 4.1 Top 5 ways to get smart on a client’s business•6 minutes
- 4.2 Top 5 ways to get smart on industry trends•7 minutes
- 4.3 Finviz.com: A free way to analyze stocks•7 minutes
- 4.4 Paid research is expensive, and may be useful•9 minutes
4 readings•Total 27 minutes
- Course outline for note taking•10 minutes
- Consulting Fundamentals: skills, tools, tips (2023)•5 minutes
- Example of investor relations presentations: Lowe's•6 minutes
- Watch CEO interviews •6 minutes
1 assignment•Total 20 minutes
- Research on client, industry, and competitors•20 minutes
3 discussion prompts•Total 20 minutes
- Optional: meet and greet•4 minutes
- Optional: What did you research recently?•6 minutes
- Optional: Let's practice using Finviz.com•10 minutes
All companies and organizations sit within an industry landscape; they have suppliers, customers, rivals, and even new entrants (new competitors). What's the power dynamics among those players and who has the leverage? Professor Michael Porter famously said that "strategy is how you cope with competition." How can your client create barriers to entry and dig an "economic moat" around their business profits?
What's included
3 videos1 reading1 assignment1 peer review
3 videos•Total 19 minutes
- 4.5 Michael Porter's five forces framework•6 minutes
- 4.6 Application of the five forces framework•7 minutes
- 4.7 Creating barriers to entry•6 minutes
1 reading•Total 13 minutes
- Interview with Michael Porter (13min)•13 minutes
1 assignment•Total 20 minutes
- Strategy and industry dynamics•20 minutes
1 peer review•Total 30 minutes
- Your turn to do a company / industry analysis•30 minutes
Consultants require useful data to make persuasive recommendations. Some of that data is available in ERP (enterprise resource planning) systems and IT databases. However, some other data doesn't exist; you need to create it through client interviews, surveys, observations, benchmarking, or other methods. It's a beautiful thing when consultants are able to drive correlation between the disparate pieces of "data" and tell a coherent story.
What's included
3 videos1 reading1 assignment
3 videos•Total 25 minutes
- 4.8 Sometimes you need to create new data•8 minutes
- 4.9 Surveys are useful, and take a lot of time•9 minutes
- 4.10 Observations give a glimpse of reality•8 minutes
1 reading•Total 15 minutes
- More survey tips? Ask Survey Money•15 minutes
1 assignment•Total 20 minutes
- Creating new data•20 minutes
Benchmarking is the simple idea of comparing performance against others. When you go to the doctor and they measure your vital signs (e.g., blood pressure, heart rate) against your peer group (e.g., women in their 50s), this is benchmarking. It's also a commonly used consulting tool because a) clients often want to know how they are performing relative to their peers, and 2) it's a convenient way for consultants to identify gaps in performance. While the concept is simple, it's incredibly difficult to do well. It's vulnerable to bias and manipulation. As a consultant, it can get you in trouble, and you should use it wisely.
What's included
3 videos1 reading1 assignment1 discussion prompt
3 videos•Total 47 minutes
- 4.11 What is benchmarking?•8 minutes
- 4.12 How to stay out of (benchmarking) trouble•21 minutes
- 4.13 10 tips for competitive intelligence•19 minutes
1 reading•Total 10 minutes
- How many jobs require "benchmarking?"•10 minutes
1 assignment•Total 20 minutes
- Benchmarking, competitive intelligence, Excel models•20 minutes
1 discussion prompt•Total 8 minutes
- Optional: Have you benchmarked?•8 minutes
Management consultants use Excel daily. They need to organize, analyze, and uncover correlations between data. So, consultants practice Excel hygiene to keep their file useful: a) don't hard code values, b) keep a copy of your source data, c) document assumptions, d) don't merge cells. However, once you get past these beginner tips, you should consider who the audience is for the file before you spend too much time "making it pretty." For example, your manager wants to quickly understand and audit your work. Your client wants you to use the Excel model to show them your thinking and make a recommendation.
What's included
3 videos1 reading
3 videos•Total 27 minutes
- 4.14 Use Exceljet.net to learn the Excel basics•11 minutes
- 4.15 Excel models vary from simple to fancy•14 minutes
- Congratulations on finishing course #4•2 minutes
1 reading•Total 2 minutes
- Please take 2 minutes and leave a review•2 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Offered by
Explore more from Business Strategy
- E
Emory University
Course
- E
Emory University
Course
- E
Emory University
Course
- E
Emory University
Course
Why people choose Coursera for their career
Learner reviews
- 5 stars
89.18%
- 4 stars
8.65%
- 3 stars
1.68%
- 2 stars
0.24%
- 1 star
0.24%
Showing 3 of 416
Reviewed on Jul 6, 2025
Very helpful for me entering into the new consulting world. The tools and tricks taught here is very helpful in my early journey in the field.
Reviewed on Nov 7, 2022
I truly enjoyed the course. Mr Kim is simply the best instructor I have met. His method of teaching leaves one with imprint memory never to forget.Thanks so much
Reviewed on Nov 27, 2024
Such an amazing course that ive gained alot and enless of knowlage out of it , thanks John for the great matrials , examples and resourses in the course
Frequently asked questions
Yes, we will review industry analysis, benchmarking, competitive intelligence, and consulting research methods.
Absolutely. Your ability to "get smart quickly", analyze industries, and benchmark competitors will help you in most careers.
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
More questions
Financial aid available,
¹ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.
