Make Impressive McKinsey Visuals in Excel!

Kenji Explains
Kenji Explains
258,374
0
Published 2023-10-29
Make McKinsey Charts and Visuals in Excel from scratch.
🚀 Take our PowerPoint Course: www.careerprinciples.com/courses/powerpoint-for-bu…

🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.com/mssfixa655

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/courses/power-bi-for-busi…
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation…
👉 Excel for Business & Finance Course: www.careerprinciples.com/courses/excel-for-busines…
🚀 All our courses: www.careerprinciples.com/courses

SOCIALS:
📸 Instagram - www.instagram.com/careerprinciples/?hl=en
🤳 TikTok - www.tiktok.com/@career_principles
🧑‍💻 LinkedIn - www.linkedin.com/company/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-insights/diversity-and-i…
All Comments (21)
  • @farhan-app
    Please keep the "re-create" series going! I re-made the financial times charts in Excel for fun...such a great learning experience
  • @HarryPotterFan1307
    Definitely a part two and three!!! These dashboard videos are the best on YouTube!
  • @Thatrandomgirl7
    I have just started learning excel and your video are giving me confidence and ample knowledge to go in this path
  • @healthsis1768
    This is incredible! Many thanks for sharing your expertise with us!
  • @happymystic9800
    Nice work packed inside an instructive video. A part 2:and 3 would be a perfect roundup of more charts in the McKinsey arsenal. Cheers …
  • @PoonamShetty413
    Thank you soo much Kenji you have made this excel topic easy with your explanations. Yes we want part 2 and part 3 ❣
  • @MarkJones-bc5vx
    Fantastic examples. You explain making charts in an easy to understand way.
  • @maniimanii1766
    Downloaded Excel today, literally found your page yesterday and the quality of content you create is amazing, more visuals please!
  • @amospan14
    Really appreciate these recreating visuals walkthroughs. They come in handy, thank you! =)
  • @Jan-sd6nc
    Yes we want a part two. These videos are very helpful for me.
  • @xuka2106
    Thank you so much. It's very helpful ❤
  • @xllearner
    I would also like to see a Part 2. Thank you!