I made a McKinsey Chart in Excel FASTER than coffee! Watch this.

Рет қаралды 203,749

Күн бұрын

Join Business Charts in Excel course👉 link.xelplus.com/yt-d-pro-biz... 🥳 To celebrate the launch, enjoy a 20% discount until April 23, 2024. Use coupon code YT at checkout. Plus, sign up before April 23 to receive an exclusive Excel chart template package!
Learn to quickly make professional charts in Excel. These are simple, modern Excel charts that communicate your data clearly and in an engaging way.
This tutorial shows you how to design charts similar to those used in top industry reports. They fit in any corporate report or consulting presentation. The best part? We use a simple Excel function to create the chart. This is Excel's hidden Chart Function! The method is ideal for improving your business reports with effective visuals, without the need for complex software. Just with a few clicks you'll be able to create an impressive McKinsey chart in Excel. This McKinsey chart is often referred to as the lollipop bar chart or the pin horizontal chart.
You can also use this Excel function to create a super fast bar chart in Excel. Tweak it to create a star bar chart or use any symbol you like. It's so flexible and easy, you'll love this simple Excel hack.
Learn about:
◊ Using the REPT function to customize chart bars with emojis and symbols.
◊ Modifying charts dynamically to adapt to data changes instantly.
For more detailed insights and advanced techniques, check out our full course on Business Charts in Excel. This course is designed to help you create charts that stand out in any professional setting, mimicking the sophisticated styles seen in publications like The Economist and McKinsey reports.
00:00 Use THIS Excel function to Create a McKinsey chart
00:30 Create a Excel McKinsey Chart in 90 seconds
02:24 Customize the Chart
06:49 New Course: Business Charts in Excel
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
➡️ Join this channel to get access to perks:
/ @leilagharani
🎬 LINKS to related videos:
Make Beautiful Excel Charts Like The Economist: • Make Beautiful Excel C...
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
More resources on my Amazon page: www.amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel

Пікірлер: 290

@LeilaGharani Ай бұрын

Join over 2000 professionals in our Business Charts in Excel course 👉 link.xelplus.com/yt-c-pro-bizcharts-course

@dulceisha 28 күн бұрын

Hi. the coupon is not working well. I added the other course as well but the code only applied to one item.

@dulceisha 28 күн бұрын

Placed the order but could not complete the excel add-on course.

@LeilaGharani 26 күн бұрын

@@dulceisha hi, the launch coupon only applies to this course. If you run into any problems please write an email to info@xelplus.com

@dulceisha 26 күн бұрын

@@LeilaGharani ok. But on the page it was listed that I could get a discount without the code.

@notesfromleisa-land7893 Күн бұрын

I will attest to the quality of Leila’s courses. I’ve only taken the Power Query course which I needed for a data triage train wreck. I had muddled through it on my own initially. The course was a life and time saver. The cost and time of the course was a fraction of the time, effort and frustration I saved. I think that this course is next. I’m an old dog and need this new trick. Users are so lucky today to have access to high quality videos from trusted professionals to help us increase and refine our excel skills. It was dark days on the frontier back in the day.

@teemad Ай бұрын

Leila, great video as always. I have to say however, you may be one of the world's top Excel resources and no doubt you love what you do, but you are missing your true calling. Comedy! The timing first on the "woah, wait" bit and then the coffee sip was just comedic genius! 🤣

@LeilaGharani Ай бұрын

ahhh thank you! When I first read the "but," I thought you were going to say, "but why do you have to tease IT again?" 😉 It was nice surprise. I always liked acting, but I have no talent. But everything can be learnt.

@h.esther9400 Ай бұрын

I think you have acting talent - I’d watch a pro vs noob tv series!

@Meow2Kaco 23 күн бұрын

I agree! When she said “woah, wait!” I thought “oh, she’s gonna cheat the 90 second limit by explaining a bunch of stuff before the timer starts, and she didn’t. And when the timer actually started, while all viewers are watching like “how is she going to do this?!” with our eyes wide open, she used up more than 10 seconds for sipping coffee 😂 That was awesome!!! Love this excel trick too. I use Power BI for reporting a lot, but there are some users who prefer excel. I love both. And I cannot wait to use this technique to make my users go “Wow!”

@teemad 17 күн бұрын

@@LeilaGharani Sorry for the late reply, I don't have notifications on. I actually think you definitely have acting talent. If you have a passion for it then you should definitely explore that side of you. But please don't forget us lowly Excel and Power BI users pretty please, we still need your expertise! 😂

@BORISVLEONOV Ай бұрын

"Now I'm ready". It was perfect! 😊 Thank you for the video!

@Gabriela-hn2tx 9 күн бұрын

This was amazing, thank you! I've been loving these McKinsey and The Economist videos!

@andrew7586 Ай бұрын

Great video/tutorial. It shows that Excel can be for much more than complex spreadsheet applications.

@mike42441 Ай бұрын

Excellent tutorial !! Love the sipping & savoring of good coffee, always part of the full Excel experience : )

@winteriscoming4407 Ай бұрын

thank you Leila! nice sharing 👍

@ManafKAMIL Ай бұрын

Brilliant... and I totally agree with you, the coffee sip at the start is very important 😁

@LeilaGharani Ай бұрын

😊

@enlighten92 Ай бұрын

I have enrolled in the course. Loving it. Taking it all in slowly. There is so much content..

@luayabdelbaqi7566 Ай бұрын

Thank you for your wonderful effort 🤩🤩 you are always the best

@user-kp7cw5hl3f Ай бұрын

Simply as usual. Thank you Leila!!

@LeilaGharani Ай бұрын

Glad you like it!

@Wio_La Ай бұрын

Dear Leila, thank you for your great work! You are the best teacher I have ever met!

@LeilaGharani Ай бұрын

Wow, thank you!

@mrknighttheitguy8434 Ай бұрын

Always enjoy these videos. Thanks.

@quiqueenrikx3992 Ай бұрын

You're simply the best. Thanks!!!!

@mafp22w Ай бұрын

What an amazing example for a young woman today.

@DeniseVajdak Ай бұрын

You always have the coolest uses of Excel functions!! ❤

@GailBolden-iq3rq Ай бұрын

Course is amazing!

@Tkourtog Ай бұрын

Once more another great video Leila! I can use this technique in one of my projects. Great 90" idea (with a coffee).. Thanks for sharing!

@walking_on_by Ай бұрын

I still have a few courses to complete, but the business charts course will be the next one. I love your teaching style, makes the courses enjoyable. I've learnt so much from them.

@LeilaGharani Ай бұрын

Awesome, thank you!

@kdub607 Ай бұрын

Your presentations and demos are always flawless! I love that you can take a seemingly complex Excel format and not only make it look easy to follow and learn, but do it quickly and almost effortlessly. Thank you for sharing your knowledge set and making more of us look like spreadsheet savants! 🥰

@LeilaGharani Ай бұрын

Thank you so much for the kind feedback! 🙏

@StepByStepExcelTutorials 27 күн бұрын

Love this, so important for those in the finance field!

@mr.gk5 Ай бұрын

Hey I love your videos on Mckinsey and The Economist styles, please do more videos on this topic. Keep up the good work!

@LeilaGharani Ай бұрын

Thank you! Will do!

@mr.gk5 29 күн бұрын

@@LeilaGharani thank YOU! Your videos have helped me a lot at work. I just wanna let you know you’re making a difference by helping so guys on the internet to improve his work and gain recognition

@vernacularbarnarchitecture Ай бұрын

Your videos are as lovely as your solutions.

@gabrielenicolini5988 Ай бұрын

Brava Leila - this is an excellent clip and I look forward to the end on the month report to try to include that chart. Grazie mille!

@LeilaGharani Ай бұрын

Glad you enjoyed it!

@sao_rav Ай бұрын

You have been a true mentor for all of us. And truly thank you for your contribution to the world. Much love and respect from India 🇮🇳. I sometime wonder how fo you even figure out how these works and get us so clear easy solutions?

@CatharinaDavies Ай бұрын

Thank you Leila, I have already purchased this course and can’t wait to delve in !

@LeilaGharani Ай бұрын

Wonderful! Thanks a lot for choosing the course! I'm sure you'll find it super useful. If you run into in any questions, let us know. Enjoy!

@Michael_Alaska 11 күн бұрын

Very nice, took me a little while to find the correct middle dot to use in Geometric Shapes.

@carlos2408 Ай бұрын

Well I am so glad to have a long format video back.

@LeilaGharani Ай бұрын

So am I. I tried the shorts, but I'm a fan of long form.

@chh8860 Ай бұрын

A unexpected Tuesday surprise!!! ... good thing I was ready with a cup of hot coffee ... flawless presentation once again ... 😍😍😍

@LeilaGharani Ай бұрын

Guess what? I thought about you when we decided to publish today instead of Thursday. I'm glad you and your coffee were both ready and we got you in time ☺

@chh8860 Ай бұрын

@@LeilaGharani 😂🤣😂🤣😂🤣 ...😍😍

@YacineHichri 25 күн бұрын

This is impressive. Thanks for sharing.

@TakYuMichaelKan 8 күн бұрын

love it. every time, I can learn something from Leila. Hi! I have been away for a long time. You video still helpful and profession.

@timwood101 Ай бұрын

You’re a very clever trainer.

@BillyG175 Ай бұрын

Loved this ❤ thank you

@VancouverVortex 19 күн бұрын

Nice to see this on your. I hate to say it but this is how I used to set up automated Gantt charts using an invisible character and conditional format colours and I did that in the 1990s!

@FutureCommentary1 Ай бұрын

Mind blown. That's it. Just mind blown.

@chrism9037 Ай бұрын

Awesome Leila!!!

@BlessedKomal Ай бұрын

Superb job😊 Thank you 😊

@jusepiyohannes528 Ай бұрын

You are super genius

@IOSALive Ай бұрын

Leila Gharani, This is fantastic! I subscribed right away!

@djtomasuk 16 күн бұрын

gotta love the creativity of how to make even a tutorial fun to watch and learn!

@LeilaGharani 14 күн бұрын

Thank you! Cheers!

@AjayKumarYadav-dv1xs 29 күн бұрын

Leila, your all video are awesome, short crisp and to the point, please also include MySQL

@mandeep3429 Ай бұрын

You are genius.

@christophermcguire7480 Ай бұрын

Thank you!

@barbarawenger2956 Ай бұрын

Started with the course begiining last week. I'm really addicted to it! Very worth to spend the money! It makes sooooo fun!

@LeilaGharani 29 күн бұрын

So happy to hear it!

@amarnathv118 Ай бұрын

Great Presentation

@andrearadaelli703 Ай бұрын

Great video and explanation!

@Vipvideo401 Ай бұрын

You are great teaching ❤😊

@AJ-nm9gb 25 күн бұрын

beautiful function....!

@orthopaedicmd Ай бұрын

Super pro tip!! I love this hack! Will be using for sure!

@LeilaGharani Ай бұрын

Wonderful!

@chrisogonas Ай бұрын

Simple and cool! 👍🏾

@PSModelling Ай бұрын

Clever solution, nice job.

@weircottage Ай бұрын

Genius!

@arindambhattacharya7848 27 күн бұрын

Excellent Leila 👏

@grtraders Ай бұрын

I am falling in ❤ with this lady every single day. She is simply brilliant with what she has to present. Jokes apart, I think no one on this planet can teach excel better. Thank you for teaching us and making the internet worth its existence. Please keep up the good work.

@vikastiwari7134 Ай бұрын

hope you got permission from your wife before post this msg😂😂

@grtraders 29 күн бұрын

She is always by my side. 😊😊😂😂

@MrSupernova111 Ай бұрын

Very cool! Thanks!!

@ronaldoliver1700 Ай бұрын

Thank you

@unnikrishnansanthosh Ай бұрын

as always, majestic

@brazilbeyondtheheadlines Ай бұрын

You are great! Thanks for this

@LeilaGharani Ай бұрын

You're very welcome!

@RayPayette Ай бұрын

Excellent!

@emredunder9108 28 күн бұрын

This is really excellent

@barneshudson Ай бұрын

this was a great start

@Lanykos Ай бұрын

Hi Leila, you are a great Excel expert, thank you for this videos. McK is working with add-ins to create charts, 90 seconds is to slow in this business, time is money 😂

@LeilaGharani Ай бұрын

I know, they're selling it too and it's great. But it's expensive 💸

@TheMhujako 29 күн бұрын

Great video content as always 😊

@asiminatsamou 28 күн бұрын

very informative! please though note that even I have used the fonts for monospace when I am adding comments in the example, it does not work properly. thank you in advance for the tip!

@mikecrosbie2419 Ай бұрын

Wish you could do more about excel but on macs, and some hints and tips for work arounds on certain areas where the mac version of excel is lacking

@LeilaGharani Ай бұрын

hi - I don't have a mac. If I did, I would probably return it. I'm just so used to PC and the mac Excel version is missing many features.

@jtt2668 8 күн бұрын

Thank you for your amazing videos. Do you have something along the line for (commercial) banking ? Thanks very much!

@ExcelTemplatesSolutions Ай бұрын

very useful thank you

@diytwoincollege7079 Ай бұрын

Cool charts

@smguy2945 Ай бұрын

Great video! But unless I missed it, there was no explanation of what you did in the part about scaling numbers back when you are presenting large numbers? Was it just to divide the larger number by a large number to get the rept function to show less? And how did the bars accommodate the text added like "VIP campaign" and "announcement"?

@IsMirDochLattens Ай бұрын

I didn't buy the course but i'd imagine that she used a monotype font (all characters have the same width) and then she just subtracted the length of the text from the repetition multiplicator. For the scaling you would divide the value of the row by the max of the data column and multiply it by the chosen length. So the largest number is divided by itself (=1) which results in 1* chosen length. So a bar that has half of the max value would result in 0.5 * chosen length. Edit: Font it probably "Hack" Edit2: No it's not, the dot at the end doesn't align. But it is close.

@vinimaysingh7713 28 күн бұрын

I used “Consolas” font and the same approach and it worked. Dumb question though, how I go about the conditional formatting to highlight the row with highest value. Thanks. Figured the conditional formatting part too.

@Hamromerochannel 28 күн бұрын

I see it differently. I figure out we always limited only by imagination. Now she gave me an idea, I will go figure it myself. Excellent idea about scaling. In fact excellent way of visualisation I had never thought of.

@RogerStocker Ай бұрын

Fully agreed, the course is a gold mine even for advanced users. all these nice things behind the scenes, are captivating. I can't get away from the screen. "Only the next one..." is my repetitive statement to myself once I start taking a look to the videos in the course.

@LeilaGharani Ай бұрын

That's awesome to hear Roger! I love that you're finding so much value in the course and can't peel yourself away from the screen ❤🙂

@ben.holmes 16 күн бұрын

Love this! thanks Struggling to get the Bar chart part working. I've tried every combo of emoji boxes. Is it a spacing thing?

@ereinaud Ай бұрын

Thank you. You're awesome Leila!

@zarnigarmacnunova8533 Ай бұрын

In one words: WONDERFUL TEACHING and SUPER RESULTS❤

@ricardowong1813 26 күн бұрын

You are my hero 🎉❤😊

@TheDigitalOne Ай бұрын

👏👏👏 Pretty fast, good timing, ehehehe. I guess is all the function formulas knowledge, I know a little bit more complicated that, excellent informative video, tho! 😺⭐️💎

@rthsw 28 күн бұрын

How smart... Cool!

@muhammadshalah8724 29 күн бұрын

I always Follow ur video. Great ❣️

@LeilaGharani 29 күн бұрын

Thank you so much 😀

@user-yo7fx2xn8m 29 күн бұрын

Thank u

@theoblanca1062 Ай бұрын

Godspeed✅

@SyedMuzammilMahasanShahi Ай бұрын

Thanks for the share.

@LeilaGharani Ай бұрын

Thanks for watching!

@emmaeIIe Ай бұрын

Oddly I am also interested in how you bring up the emoji picker. This chart is amazing too lol

@howardhautville4208 Ай бұрын

Hold windows key and tap .

@fabianerouille9839 23 күн бұрын

Didn’t work for me

@JustinWeis 19 күн бұрын

didn't work for me either. what did work was inserting a symbol in another cell and copy/pasting it where she inserted the emoji.

@spongebobby188 15 күн бұрын

"First I'm taking a sip of coffee" ...dayam the arrogance....I love it!

@LeilaGharani 14 күн бұрын

😁

@Zoddex 17 күн бұрын

This was awesome! And no need for think-cell lol

@chakralamurali Ай бұрын

Excellent madam

@aloxingh 29 күн бұрын

A great video as usual. I have a question. How can you make the chart on the right side dynamic in reducing order ?

@noellongwe7574 Ай бұрын

Cool stuff

@user-ee8bc4mp1u 27 күн бұрын

Great🎉

@cadelly Ай бұрын

I am soooooooo amazed!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

@murrayh-c7937 Ай бұрын

Would love to see an option to access all your courses for a lower monthly subscription fee as opposed to the singlular large investment for single learning areas. Do existing. courses with lifetime access get updated alongside new Excel function releases and updates?

@flipinfin Ай бұрын

Great video. How would you change a color of series when you clicked on it?

@VaiosK Ай бұрын

UR Rock....

@Hsalz 29 күн бұрын

Cool!

@ohtheresheis8542 Ай бұрын

The coffee at the beginning was such a power move, I am still recovering! ❤

@LeilaGharani Ай бұрын

😊

@user-ct3ws1dk8d 11 күн бұрын

Hello Leila, do you have a plan on launching new course particularly on power bi advanced visualization techniques with modern design? I am sure you'd agree that design is also as important as Power Query, Data Modelling or DAX when it comes to reporting especially for end users.

@FreakAzoiyd Ай бұрын

Nice. But still waiting for a render svg and html function 😭 That would be really epic 😅

@nazarkamal8831 28 күн бұрын

Nice

@hansangb Ай бұрын

Thanks!

@LeilaGharani Ай бұрын

Thank you!

@ganpatkumhar1634 18 күн бұрын

Hey Leila, make a video on how to Vstack Spilled Ranges in Excel. For example, I have spilled ranges in cells A1,A2,A3 all the way to cell A50 having 5 columns, however i want all the ranges to be stacked one below the another. How to go about it ?

@rkalle66 Ай бұрын

Now you can just add 99-x% repeats after the dot to the right side. Deduct additional 4 when placing the percentage number. ───●─── ─────●─ And you may even format the right bar part in grey or not in bold. It's all included in the extended ascii (IBM) character set to draw frames only with characters. But ... Don't forget to check it on printed paper.

@LeilaGharani Ай бұрын

Thanks for sharing your tips!