Make Impressive McKinsey Visuals in Excel!

  Рет қаралды 280,054

Kenji Explains

Kenji Explains

Күн бұрын

Make McKinsey Charts and Visuals in Excel from scratch.
🚀 Take our PowerPoint Course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
In this video, I make 3 McKinsey visuals in Excel. McKinsey & Company is the most prestigious consulting firm in the world, so they're known to make some of the best visuals in the industry. That’s why I want to show you how to replicate three of their most popular visuals, in Excel. First, we create a radial bar chart, which is like a mix of a pie chart and a bar chart. You can find this inside of the pie charts section in Excel. Specifically, next to a doughnut chart. Second, we make a bar chart to compare one column of numbers inside of the other. This is similar to a budget vs actuals chart. Lastly, we make a stacked bar chart to showcase the demographics in each step of the corporate ladder.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Radial Bar Chart Part 1
3:05​ - Eyedropper Trick
4:07​ - Radia Bar Chart Part 2
6:33​ - Unnamed Bar Chart?
12:02 - Stacked Bar Chart
This video is for educational purposes only. Find out more about the charts used here: www.mckinsey.com/featured-ins...

Пікірлер: 127
Build Awesome Excel Visuals to Grab Anyone's Attention
18:11
Kenji Explains
Рет қаралды 396 М.
The 5 Most Popular Consulting Slides (and how to build them)
11:02
Analyst Academy
Рет қаралды 459 М.
Smart Sigma Kid #funny #sigma #comedy
00:26
CRAZY GREAPA
Рет қаралды 14 МЛН
DEFINITELY NOT HAPPENING ON MY WATCH! 😒
00:12
Laro Benz
Рет қаралды 59 МЛН
Make Beautiful Excel Charts Like The Economist (file included)
19:07
Leila Gharani
Рет қаралды 388 М.
Storytelling in PowerPoint: Learn McKinsey’s 3-Step Framework
10:50
This is how I ACTUALLY analyze data using Excel
24:05
Mo Chen
Рет қаралды 79 М.
Make an Interactive Excel Dashboard in 4 Simple Steps!
19:41
Kenji Explains
Рет қаралды 204 М.
Ex-McKinsey consultant creates a Slide Presentation with you
27:23
Firm Learning
Рет қаралды 454 М.
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 28 М.
Fast & Easy! McKinsey Chart in Excel. Watch this...
10:38
Leila Gharani
Рет қаралды 227 М.
6 Excel Tools Most Users Never Think to Use (Files Included)
12:34
MyOnlineTrainingHub
Рет қаралды 136 М.
Make an Awesome Excel Dashboard in Just 15 Minutes
15:27
Kenji Explains
Рет қаралды 1,1 МЛН