Summary
Keywords
Full Transcript
🔥 Create charts that wow your audience. Learn the secrets now—start today! 👉 https://link.xelplus.com/yt-g-mckinsey-charts-course Learn how to create a professional McKinsey-style chart in Excel in under 90 seconds! 🚀 Stop using boring default charts and start building dynamic, high-impact visuals that grab attention. In this tutorial, I’ll show you the "magic" of the Excel REPT function to build custom bar charts that look like they came straight from The Economist or a top consulting firm. 🎓 400,000+ professionals trust our courses—start your journey here 👉 https://link.xelplus.com/yt-d-all-courses 🔍 What You’ll Learn in This Video: If you work in Finance, IT, or Project Management, your reports need to stand out. Most people spend hours tweaking chart borders and colors. Instead, use this 90-second formula hack to create a Dynamic Bar Chart inside your cells. Key Topics Covered: - The 90-Second Challenge: Setting up a McKinsey-style visual from scratch. - Excel REPT Function: How to use the "Repeat" formula for data visualization. - Custom Styling: Using the Windows Emoji picker (Win + .) to add unique symbols and bars. - Dynamic Highlighting: Using Conditional Formatting and font colors to make key data pop. - Scaling Large Numbers: How to handle thousands or millions in a formula-based chart. - Adding Dynamic Comments: Automate "VIP" or "Announcement" labels inside your bars. 🎓 Take Your Skills Further: If you’re tired of "messy data" and want to build economist-level reports that update like magic, join over 400,000 students in our Business Charts Mastery program. We cover everything from highlight strategies to professional finance reporting. 👉 Join the Course here: https://link.xelplus.com/yt-bizcharts-course 00:00 The McKinsey Chart Challenge 00:30 Create a Excel McKinsey Chart in 90 seconds 01:10 Using the Excel REPT Function 02:24 Styling Hacks: Colors, Fonts, and Sizes 05:10 Scaling Large Data Sets 06:04 Adding Dynamic Comments to Bars 06:49 Join the Business Charts in Excel Course Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses 📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 🎬 LINKS to related videos: Make Beautiful Excel Charts Like The Economist: https://youtu.be/wP8NWRR0Fdg 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ More resources on my Amazon page: https://www.amazon.com/shop/leilagharani 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/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
