Make Impressive McKinsey Visuals in Excel!

  Рет қаралды 344,133

Kenji Explains

Kenji Explains

Күн бұрын

Пікірлер: 133
@KenjiExplains
@KenjiExplains Жыл бұрын
🚀Take our PowerPoint Course: www.careerprinciples.com/courses/powerpoint-for-business-finance
@Influenceless-influencer
@Influenceless-influencer Жыл бұрын
These “recreating visuals” videos are super useful. Thanks. Part 2 and part 3 please
@KenjiExplains
@KenjiExplains Жыл бұрын
Noted thank you :)
@oscarjuarez3386
@oscarjuarez3386 Жыл бұрын
Keep them coming!
@HarryPotterFan1307
@HarryPotterFan1307 Жыл бұрын
Definitely a part two and three!!! These dashboard videos are the best on KZbin!
@KenjiExplains
@KenjiExplains Жыл бұрын
Glad you like them! More to come hopefully
@daviddigridi7949
@daviddigridi7949 9 ай бұрын
@@KenjiExplainsplease waiting for the part 2
@Thatrandomgirl7
@Thatrandomgirl7 Жыл бұрын
I have just started learning excel and your video are giving me confidence and ample knowledge to go in this path
@Jan-sd6nc
@Jan-sd6nc Жыл бұрын
Yes we want a part two. These videos are very helpful for me.
@KenjiExplains
@KenjiExplains Жыл бұрын
Noted thank you!
@vodkayan210
@vodkayan210 Жыл бұрын
Yes, looking forward to part2 and 3, thanks Kenji!@@KenjiExplains
@VINAY_DEVADIGA
@VINAY_DEVADIGA 10 ай бұрын
In the Unnamed chart, --> Alternatively you can also create a horizontal range of the values of Year and Quarter, create a linked image through the excel's built in Camera tool and then Format and Resize it as convenient and finally place it on top of the chart, saves a bit of time!!
@maniimanii1766
@maniimanii1766 Жыл бұрын
Downloaded Excel today, literally found your page yesterday and the quality of content you create is amazing, more visuals please!
@KenjiExplains
@KenjiExplains Жыл бұрын
Awesome, thank you! more soon hopefully :)
@happymystic9800
@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 …
@amospan14
@amospan14 Жыл бұрын
Really appreciate these recreating visuals walkthroughs. They come in handy, thank you! =)
@KenjiExplains
@KenjiExplains Жыл бұрын
You're very welcome!
@Sailingbill1
@Sailingbill1 5 ай бұрын
This is one of the only pragmatic video's I have seen. Thank you for taking the time to do this!
@VishnuVardhan-sj6nd
@VishnuVardhan-sj6nd Жыл бұрын
Did anyone recreate the Radial Chart on their MacOS ? I have the paid MS Excel version on my Macbook but I couldn't find the 'More Pie Chart' option.
@asadxo
@asadxo 9 ай бұрын
same
@luigibru8677
@luigibru8677 6 ай бұрын
Excel for MacOS sucks.
@healthsis1768
@healthsis1768 Жыл бұрын
This is incredible! Many thanks for sharing your expertise with us!
@gregharrison7654
@gregharrison7654 6 ай бұрын
Firstly, I like the tutorial and the tonality + pace, all good and an excellent learning opportunity. However, these examples are for static presentations. I am using dynamic graphs in Excel that include slicers to filter results. As you've built these to replicate existing material, I see how the need is flat or static. The challenge in making these dynamic is the labelling. Any suggestions? Especially the radial bar chart, the first one. It could be a big hit if the labelling issue can be resolved.
@Max-qy1dw
@Max-qy1dw Жыл бұрын
McKinsey uses as Ppt add in called Thinkcell. With such tool it takes you 30 seconds to build charts. Doing it in Excel is really inefficient.
@violentfox
@violentfox Жыл бұрын
Well, it costs starting €250/year. If one needs to just draw a couple charts, it’s Think-cell that’s not cost-efficient.
@winnershandbook1069
@winnershandbook1069 Жыл бұрын
250/yr for mckinsey is nothing lol@@violentfox
@yuvrajroy1257
@yuvrajroy1257 7 ай бұрын
What about π racy ​@@violentfox
@Daniel-tb6gn
@Daniel-tb6gn 5 ай бұрын
Exactly, with Think Cell it’s a piece of cake!
@jtb52
@jtb52 Жыл бұрын
What's very cool is that you go for these text labels..I can spend hours assuming they can be automatically done in the chart data..not any more
@m.w.6099
@m.w.6099 Жыл бұрын
Great vid again! Isn’t it so that when you want to change something you don’t have to do the right click on the bar and then go to change data series but instead you just use ctrl+1 that works almost anywhere?
@lr7949
@lr7949 Жыл бұрын
Can I also create all these designs on the Mac with Excel? - I can't find the pie chart (first draft) there. Many thanks in advance!
@iainsmith2278
@iainsmith2278 Жыл бұрын
I am assuming that the 'more charts' option is only available to windows and not mac?
@MarkJones-bc5vx
@MarkJones-bc5vx 7 ай бұрын
Fantastic examples. You explain making charts in an easy to understand way.
@PoonamShetty413
@PoonamShetty413 11 ай бұрын
Thank you soo much Kenji you have made this excel topic easy with your explanations. Yes we want part 2 and part 3 ❣
@giacomobr2777
@giacomobr2777 Жыл бұрын
One of the best videos ever! Please prepare part2
@RedBlur0817
@RedBlur0817 Жыл бұрын
Awesome! I’m going to copy for the dashboard I’m building at work.
@KenjiExplains
@KenjiExplains Жыл бұрын
Thank you!
@deruan7625
@deruan7625 10 ай бұрын
Super useful Kenki, thanks so much. FYI the second chart is a Stacked Bar Chart, to compare frequencies over a 2 parameters of a variables, let's say freqs of Yes and No over a variable like "Hold a bachelor degree" over a range of years or age population ranges. It would be nice a video like this but making some ppts in McKinsey style as they recently changed their branding a bit
@acp481
@acp481 Жыл бұрын
Que versión de excel usas?, es que no me aparecen algunas opciones, como el primer gráfico saludos
@xllearner
@xllearner Жыл бұрын
Another great video! The chart is called a Stacked Column or Stacked Bar Chart.
@KenjiExplains
@KenjiExplains Жыл бұрын
Thanks for the info!
@yoti.
@yoti. 27 күн бұрын
Asombrada de lo que logré desarrollar, gracias por data para practicar :)
@qasimbashir7033
@qasimbashir7033 4 ай бұрын
Hello there.. Chart used for radial bar chart is not showing in excel? Any help in this regard?
@AndreMahfouz
@AndreMahfouz Жыл бұрын
Concerning the eyedropper tool, there's a system-wide one in the Powertoys tool developed by Microsoft, it'll save you some time.
@cashtube777
@cashtube777 Жыл бұрын
You are literally the GOAT
@johndavies4758
@johndavies4758 Жыл бұрын
I don't know if I am doing something wrong but I only get a single option for doughnut chart in Excel (M365), which is has 2 rings. I don't get the one shown on the right, which is used, with a ring for each row in the data. Anyone know how to fix this?
@dominicgentolia9259
@dominicgentolia9259 10 ай бұрын
Can't help it admiring this guy!
@Danny-Do-It
@Danny-Do-It 4 ай бұрын
Lets say you had this radia bar chart - if you wanted to use it every month in powerpoint, is there a way to dynamically link the text box + chart to the data in excel? meaning when i add monthly data the tables on powerpoint update with it
@xllearner
@xllearner Жыл бұрын
I would also like to see a Part 2. Thank you!
@s_elgebali9660
@s_elgebali9660 3 ай бұрын
thanks very much , I benefit from your video so much😍😍😍😍
@laveshmalik9912
@laveshmalik9912 4 ай бұрын
For the second chart example, I also get Quarters in the bar form, how do I change that? I am doing something wrong?
@ultimatefreedom6934
@ultimatefreedom6934 6 ай бұрын
How do you add all 3 things together - the chart, numbers and text. When increasing size of chart, text and numbers remain there.
@nishanth4323
@nishanth4323 Жыл бұрын
Now that some interesting thing. .😮. can't wait for more this type of videos...🙏
@KenjiExplains
@KenjiExplains Жыл бұрын
Glad you liked it! More to come hopefully :)
@wilbalt8553
@wilbalt8553 Жыл бұрын
Hi, do you know how to change the Data sequence in a Sunburst Diagramm? Normally its sorted by size. I'd like to sort it my myself. For example, Sales in a year: Inner circle are the quarters, outer the months. Should be Q1 to Q4 und Jan to Dec and not most Sales sorted. Thanks
@bhaveshsavla7812
@bhaveshsavla7812 Жыл бұрын
Query abt radial bar chart - am unable to select the helper bars to delete. In my case both the helper and percentage are being selected together. Even data series is showing them together.😢
@UvanSankar
@UvanSankar 10 ай бұрын
More pie charts unavailable in Excel. Could you tell on how to enable this?
@kameshsubramanian2553
@kameshsubramanian2553 Жыл бұрын
@KenjiExplains. Great video. Are any of your courses available on Udemy?
@xuka2106
@xuka2106 Жыл бұрын
Thank you so much. It's very helpful ❤
@andresqueupumilrodriguez6722
@andresqueupumilrodriguez6722 8 ай бұрын
mi version of excel mac don`t have the option of more circle graphs, it's s no license version
@KManvik
@KManvik Жыл бұрын
Awesome...So well explained..thank you!!
@KenjiExplains
@KenjiExplains Жыл бұрын
Glad it was helpful!
@Horn_of_Afrika
@Horn_of_Afrika Жыл бұрын
More than 29k views but still 1k likes? Come on guys, let’s like & subscribe. He is teaching us freely.
@venusflytrap909
@venusflytrap909 Жыл бұрын
Great doughnut chart but if the value changes the text box will not be at the end of the doughnut curve (or am I wrong ?)
@KenjiExplains
@KenjiExplains Жыл бұрын
yes you're right, it would just be a bit manual there :/
@waadabdullah2191
@waadabdullah2191 9 ай бұрын
Please keep making these re-creating videos.
@franciscaamano3519
@franciscaamano3519 Жыл бұрын
Kenji this was excellent
@Alen_115
@Alen_115 Жыл бұрын
I like the video very much, it would help me in my scientific research papers
@kientr9999
@kientr9999 6 ай бұрын
How about the bump chart?
@gcorbalan
@gcorbalan 10 ай бұрын
Thank you for sharing!
@jbgood7694
@jbgood7694 11 ай бұрын
I'm using a MacBook Pro and I can't find the same doughnut chart that you are using in the video. I have the most current version of Microsoft 365 installed. I am not able to reduce the center of the doughnut either.
@yohannaagbanaji8012
@yohannaagbanaji8012 Жыл бұрын
Great vid as usual ❤❤❤.
@camlex6310
@camlex6310 Жыл бұрын
Great visuals!! Super helpful
@growth2509
@growth2509 Жыл бұрын
Very innovative, thanks for sharing.
@Danny-Do-It
@Danny-Do-It 3 ай бұрын
I dont have that pie chart on my list.. any idea?
@spikeydude114
@spikeydude114 Жыл бұрын
You make awesome content. Thank you so much !
@KenjiExplains
@KenjiExplains Жыл бұрын
Glad you enjoy it!
@mannyuruchurtu318
@mannyuruchurtu318 Жыл бұрын
Bar in bar chart for the second one 👍🏽
@yohannaagbanaji8012
@yohannaagbanaji8012 Жыл бұрын
Does this work on all the office versions?
@FungoTech
@FungoTech 10 ай бұрын
Great video!
@arindambhattacharya7848
@arindambhattacharya7848 9 ай бұрын
For the first chart - Am sure there may be a way to avoid manually adding the percentage numbers and names and save time
@isaiahmaragalla
@isaiahmaragalla 11 ай бұрын
amazing. thank you
@nicolasbeltranrubio6362
@nicolasbeltranrubio6362 Жыл бұрын
Is there any way we can export these visuals to Excel?
@nakkulmahajan1170
@nakkulmahajan1170 9 ай бұрын
I can't find more charts on excel, could someone help please..
@avinashsingh7930
@avinashsingh7930 Жыл бұрын
the Unnamed bar chart is called as thermo-meter chart
@KenjiExplains
@KenjiExplains Жыл бұрын
Awesome thank you for the information!
@ezequiasrocha3037
@ezequiasrocha3037 Ай бұрын
Good job.
@shankarathreya1899
@shankarathreya1899 Жыл бұрын
how can we do meeko bar charts in excel?
@aneeshssundaram1675
@aneeshssundaram1675 5 ай бұрын
The unnamed bar chart in the second part of this exercise should be a 2-d stacked column chart
@magedx7059
@magedx7059 8 ай бұрын
Awesome, thanks
@weppes8090
@weppes8090 Жыл бұрын
Guys, do you know why my Excel version doesn't have all the charts available ? BTW, Amazing content man ! 🙂
@KenjiExplains
@KenjiExplains Жыл бұрын
it's possible that you're on an older Excel version that doesn't have all the features. In my case, I'm in Microsoft 365.
@iqbalhossain5035
@iqbalhossain5035 Жыл бұрын
Thanks a lot.
@doritos7134
@doritos7134 Жыл бұрын
Thanks for the video but I feel these are time consuming and should only be used for external presentations.
@gauravmakhijani9079
@gauravmakhijani9079 8 ай бұрын
I’m need of this badly but need a 60% discount on the course
@thamimalope5221
@thamimalope5221 8 ай бұрын
powerful !
@rockyn3193
@rockyn3193 8 ай бұрын
Damn, thought you were going to show us the mekko chart in the stop left of the thumbnail
@VijaySrinivasVittalam
@VijaySrinivasVittalam 8 ай бұрын
2nd chart is "Manhattan Towers"
@GODFATHER4484
@GODFATHER4484 9 ай бұрын
Why do I not have All charts
@helloeveryone6909
@helloeveryone6909 Жыл бұрын
Can we have a a discount before the end of the year please
@SocialReader
@SocialReader Жыл бұрын
Part two please
@nidaparveen1557
@nidaparveen1557 Жыл бұрын
We want part 2
@md.naimulislam3913
@md.naimulislam3913 Жыл бұрын
I need part 2
@ummuhaidar
@ummuhaidar 11 ай бұрын
The secomd chart is called a bullet chart😊
@qristomaich1809
@qristomaich1809 Жыл бұрын
part 2?
@nguyenhuunhattan1206
@nguyenhuunhattan1206 Жыл бұрын
Nice
@KenjiExplains
@KenjiExplains Жыл бұрын
Thank you
@Niklas-og4zm
@Niklas-og4zm Жыл бұрын
I think the unnamed bar chart is called a bullet graph.
@fycrtr
@fycrtr Жыл бұрын
We use Think-cell to do our graphs, not Excel
@sawansamant1603
@sawansamant1603 8 ай бұрын
2nd chart is bar in bar chart
@faraazali9589
@faraazali9589 5 ай бұрын
The second chart is called a bullet chart.
@jhadinger
@jhadinger 8 ай бұрын
It could be so easy to misrepresent data with a radial bar chart. Anyone using this needs to be aware of the story you're telling to anyone who sees your visualization. The more columns (or "rings"?) you have, the more skewed the inner and outer rings can seem. Keep this in mind! You really shouldn't use a donut chart or something resembling one unless you're showing parts of a whole.
@samuelmehinsan_
@samuelmehinsan_ Жыл бұрын
It's called stacked bar chart I guess
@samuelmehinsan_
@samuelmehinsan_ Жыл бұрын
...or not
@kylebrazeal7739
@kylebrazeal7739 8 ай бұрын
There's no point in making the labels dynamic as the positioning won't shift automatically....
@kanazawasyosuke2262
@kanazawasyosuke2262 Жыл бұрын
👍
@KenjiExplains
@KenjiExplains Жыл бұрын
thanks for watching!
@mariusgearip
@mariusgearip 10 ай бұрын
So many manual adjustments with shapes and text boxes. If you these charts once per year, it may be bearable, but it's inefficient.
@ravbuddy
@ravbuddy 3 ай бұрын
What would you suggest?
@shivaraju8595
@shivaraju8595 Жыл бұрын
🎉🎉🎉🎉🎉🎉🎉
@eclipseslayer98
@eclipseslayer98 2 ай бұрын
I'm currently HATING Excel. I have two dats sets, one is supposed to be the Y axis, and the other is supposed to be the X axis. Excel in its infinite stupid however REFUSES to make a chart using the data set. It EXTREMELY SIMPLE, yet Excel is having such a hard time with it. In the X-Axis, I have date (month/day/year) and in the y-axis, I have time (hours:minutes:seconds). Yet Excel REFUSES to graph them. I've looked EVERYWHERE, and NOBODY has ANYTHING helpful. in ALL the videos I've seen, their Excel just MAGICALLY knows what dates are and correctly graphs them from the start.
@willzinner8813
@willzinner8813 Жыл бұрын
second
@KenjiExplains
@KenjiExplains Жыл бұрын
lets go
@camg7960
@camg7960 Жыл бұрын
1st
@KenjiExplains
@KenjiExplains Жыл бұрын
haha thanks for watching :)
@ericssontest2332
@ericssontest2332 5 ай бұрын
Ggf
@airforce1969
@airforce1969 Жыл бұрын
It would be great if you could do this in power bi too!!!
@Draykoh01
@Draykoh01 Жыл бұрын
This donut chart isn't even dynamic. Another example of McKinsey making something pretty without being practical.
Build Awesome Excel Visuals to Grab Anyone's Attention
18:11
Kenji Explains
Рет қаралды 430 М.
The 5 Most Popular Consulting Slides (and how to build them)
11:02
Analyst Academy
Рет қаралды 562 М.
Сестра обхитрила!
00:17
Victoria Portfolio
Рет қаралды 958 М.
Enceinte et en Bazard: Les Chroniques du Nettoyage ! 🚽✨
00:21
Two More French
Рет қаралды 42 МЛН
Гениальное изобретение из обычного стаканчика!
00:31
Лютая физика | Олимпиадная физика
Рет қаралды 4,8 МЛН
小丑女COCO的审判。#天使 #小丑 #超人不会飞
00:53
超人不会飞
Рет қаралды 16 МЛН
Make an Interactive Excel Dashboard in 4 Simple Steps!
19:41
Kenji Explains
Рет қаралды 342 М.
Make Beautiful Excel Charts Like The Economist (file included)
19:07
Leila Gharani
Рет қаралды 491 М.
Try This Function Instead of IF Statements
12:51
Kenji Explains
Рет қаралды 63 М.
Build your own “McKinsey Style” Presentation (Full Tutorial)
10:54
Analyst Academy
Рет қаралды 120 М.
Telling a Story with Data | Dashboard Build Demo
13:41
Maven Analytics
Рет қаралды 158 М.
Make Awesome Excel Visuals like The Economist Magazine
19:16
Kenji Explains
Рет қаралды 152 М.
Ex-McKinsey consultant creates a Slide Presentation with you
27:23
Firm Learning
Рет қаралды 477 М.
Storytelling in PowerPoint: Learn McKinsey’s 3-Step Framework
10:50
Сестра обхитрила!
00:17
Victoria Portfolio
Рет қаралды 958 М.