Leila Gharani – Business Charts in Excel

Leila Gharani – Business Charts in ExcelCREATE EXCEL CHARTS THAT GET YOU NOTICEDFeel like your Excel skills are falling behind?Tired of making Excel reports that no one notices?Imagine making Excel charts as powerful as those in The Economist and McKinsey, without getting stuck in slow, manual routines.We get it – creating professional charts in Excel can eat up your time.That’s exactly why our course focuses on MORE than creating charts that get noticed.It teaches you formulas to make your reports dynamic so you can free up your valuable time for what matters.Course Highlights:8.5 hours of video lessons60+ practice files & 50+ ready-to-use templatesQuick Guide eBook on Excel ChartsBONUS Cheat Sheets for fast learningLIFETIME Access so you never feel rushedEnglish Closed Captions (created by a professional typist)Direct Support from our teaching assistantsDigital Badge & Certificate of completionCreating Engaging Charts in Excel Is Time-ConsumingIf you lack the right techniques…You’ll struggle to make charts that explain your data clearly.Waste precious time on manual updates.Professional reports seem out of reach in a fast-paced business world.Plus Excel keeps adding new features making it hard to keep up. There seem to be many powerful tools. But you’re stuck in the basics.We don’t want that for you.Creating professional Excel charts should be easy.We designed this course so you can:Create Excel charts that exceed your manager’s expectations.Upgrade your skills with the latest Excel charting techniques.Master Excel formulas for dynamic, auto-updating charts.Select the right chart type, ensuring your data stands out.Present complex data simply, just like the experts at McKinsey and The Economist.These charts don’t only look great but also save you time. You get to focus on what really matters.Turn Data into Reports That Capture Every Colleague’s AttentionJoin 400,000+ learners who’ve upgraded their Excel skills with us.We know how challenging it can be to turn complex data into impactful charts in Excel.Especially when your hard work goes unnoticed.That’s why we designed our course to teach you quick methods for creating standout charts.Visuals that are engaging, informative and at the same time minimalistic.They’re rewarding to make. Rewarding to present. You’ll learn formulas to automate the making of your charts. So you don’t have to worry about adjusting your source data layout to fit your chart.You’ll save a ton of time AND stand out for your skills.Your 8-Step Roadmap to Chart MasteryIf Excel has ever made you doubt your abilities, you’re not alone. Go through the steps in the course and soon you’ll find yourself mastering more than just charts.XelPlus Roadmap for “Business Charts” course.Turn Your Data into Engaging StoriesStop wasting time with ineffective charts. Instead start making impactful visuals that get noticed.But let’s face it, Excel can be tough and take up too much of your time.We believe it should be easy to make charts that look good and tell a story. That’s why our course gives you all the shortcuts and support you need.Sample charts you’ll learn to createAnd there’s more to it than just looks.Once you create an engaging chart, you want it to be responsive and automatically update. Because if not, your whole day gets swallowed up by trying to keep your charts and reports current.Creating engaging AND self-updating charts is a skill few possess.The best part?In this course you’ll learn BOTH skills.You’ll learn to make charts that update automatically with new data. No more wasting hours manually updating graphs for your monthly reports or presentations. Think of the extra time you’ll have for other work or to simply enjoy a well-deserved break! I’m Leila.Your Instructor.Each month, I hop on a special video call with the Microsoft team. This is one of the perks of being a Microsoft MVP. They fill us in on all the latest features coming down the pipeline. Excel has been changing a lot. I understand the frustration of keeping up with new Excel features.Recognized by Forbes and others, my courses aim to boost your data analysis and visualization skills, focusing on automation to save time.I relied heavily on Excel in my corporate days in finance, IT and project management. I’ve mastered creating powerful automations and turned challenges into strengths.Join me to improve your Excel skills to the top level, without the manual hassle. It’ll be fun! “But Leila, Why Learn Business Charts from You?”You have plenty of options for learning about Excel Charts, so why enroll in our new course?For starters, as with all our courses, you’ll benefit from our XelPlus 3-pillars of teaching.Pillar 1– We Speak Plain EnglishWe don’t use jargon or “smart sounding” words when simple words will do. We start with the easy stuff to get you hooked. Then, you can go deeper.We don’t scare you away by showing you the nerdy details right out of the gate.Pillar 2 – We Give You Real World ExamplesBusiness Charts are meant to help decision making and solve real world problems.“What is this data trying to tell us?”“What are we missing?”“What should we do after this meeting?”Some teachers are afraid to go there. They feel safe with theory.Not us. We come from the trenches of industry.We don’t shy away from real world examples. We lean into them.Pillar 3 – We Show You the Big PictureI’m the type who needs to see how everything fits together.After all, nothing exists in a silo.Some courses only show you how to create various chart types in Excel. Some only teach you how to transform raw data for visualization. Others show you how to create beautiful reports.In our course we teach you both preparing the data and how to avoid manual updates. And yes, we show you how to create stunning visuals in Excel.Our course teaches you not just to make great-looking charts and graphs but also to master Excel’s shortcuts and functions that speed up your work. Our course will take you through a step-by-step learning plan. From Excel chart basics to advanced dynamic charts and automation.Wow your coworkers and managers with smart time-saving techniques.Here’s Your Learning PathCheck out the detailed curriculum below. Notice any topics that catch your eye?Where would you like to start your learning journey?IntroductionHow to Succeed with This CourseDownload Files & TemplatesLooking for a Specific Topic? Use the Transporter!Section 1: Excel Chart BasicsHow to Pick the Right Chart (Answer these questions)Creating Excel Charts: Data Structure, Multiple SeriesImproving Charts: Adding Elements & FormattingEssential Practices for Creating Standout VisualsQuiz – Chart BasicsKey Takeaways Chart BasicsSection 2: Mastering Dynamic Charts in ExcelCreating Charts that Update ThemselvesExcel Tables & Slicers for Dynamic ChartsLast 12 Months Dynamic Charts (No more Manual Updates!)Connecting Charts to a Drop-downExercise: Switching Units in Charts with a Drop-DownDynamic Chart Titles: Add Clarity with Real-time UpdatesAdding Context with Text Boxes and Labels like The EconomistChallenge: Interactive Chart with Slicer and Dynamic TextAutomatic Sorting in Charts for Better ReportingPositioning Axis Labels to Avoid Overlap with Negative ValuesPivotCharts with Slicers and TimelinesPivotTable Data to Power Standard Charts with SlicersKey Takeaways Dynamic ChartsSection 3: Comparing ValuesCreating Excel Charts for Impactful Data ComparisonsColumn Chart Essentials: Simplifying for ImpactConditionally Highlight Columns (Top & Bottom Values)Advanced Column Charts: Auto-Updates & Dynamic TitlesCreative Column Chart Formatting: Beyond the Basics🔥 Challenge: Dropdown-Driven Conditional HighlightsMcKinsey-Style Column ChartsDYNAMIC McKinsey-Style Column ChartsCompact Bar Chart with a Simple FunctionMcKinsey’s Lollipop Chart for Easy ComparisonEnhance Bar Charts with a Vertical Comparison LineDumbbell Charts: The Economist and BBC Style💪 Exercise Pack to Sharpen Your Skills ✨📝 Key Takeaways Comparing ValuesSection 4: Showing CompositionCharts to Show CompositionAdding Totals to a Stacked ChartAligning Series Labels in Stacked ChartsPie Chart & Doughnut ChartsUpgrading from Pie Charts: Sorted Bars with ExtrasTreemaps to Explore HierarchiesMcKinsey’s Waffle Chart🔥 Challenge: Stacked BAR Chart with Totals🤔 Quiz – Showing Composition📝 Key Takeaways Showing CompositionSection 5: Understanding Trends and PatternsCaptivating Line Charts with Simple TweaksAvoid Drop to Zero in Line ChartsDynamic Series Label Integration for Multiple Line SeriesDynamic Data Labels: Frequency Selected from Drop-downForward-Looking Charts: Unifying Multiple Series into OneEconomist-Style Multi-Line Slope ChartSmall Multiples Chart (Panel Chart) for Side-by-side ComparisonExcel Sparklines: Quick Visual Trends💪 Exercise Pack to Sharpen Your Skills ✨🤔 Quiz – Understanding Trends📝 Key Takeaways Understanding TrendsSection 6: Displaying Change (Variance, Growth, Before/After)Designing Impactful Variance Charts in ExcelBuilding Connected Color-Coded Bar Variance ChartsMcKinsey-Style Lollipop Variance Charts🔥 Challenge: Create a Column Lollipop Variance Chart💪 Exercise: Column Variance ChartUsing Color-Coded Arrows in ChartsWaterfall Chart to Visualize Cumulative Impact📝 Key Takeaways Displaying ChangeSection 7: Presenting Tables in ExcelHow to Best Present Data in a TableConditionally Change Row & Font ColorSubtle Color Coding for Key ChangesUse Bars and Arrows in Tables for Easier Readability💪 Exercise: Table Formatting with Data Bars🤔 Quiz – Presenting Tables📝 Key Takeaways Presenting TablesBonus: More Elite Chart Design inspired by McKinsey & The EconomistHeat Map: McKinsey-StyleCategory Chart: The Economist-StyleIn-Cell Bar Chart with CommentsQ&A Resource Hub🔐 Answer VaultWrapping Up🙌 YOU DID IT! Everything Included in Your EnrollmentIt’s time to say goodbye to the stress of making Excel charts.With our course, you can elevate your skills from the comfort of your home.You’ll get:The confidence and rewards that come from having cutting-edge Excel skillsIn-depth knowledge with over 8 hours of video lessonsFiles to follow along with each video lesson50+ ready-to-use business chart templates you can use right awayLifetime access: Learn on your schedule & without deadlinesOur topic transporter to quickly navigate to the topic you needQuick Guide eBook to master all aspects of Excel chartsA comment section to get your questions answered by our staff (how awesome is that?)Credits for CPD to enhance your resumeEnglish Captions by a professional typistQuizzes to track how well you understand the conceptsChallenges to test your knowledgeBonus: Our collection of Cheat Sheets to keep at your desk.There are no reviews yet.Add a Review Cancel replyYou must be logged in to post a review.