Business Charts In Excel – Xelplus By Leila Gharani – Free Download Course
With this full course, you’ll learn the best formulas to make your reports dynamic so you can free up your valuable time for what matters.
✅ About This Course:
✅ Course Author: Leila Gharani
✅ Official Course Price: $57
✅ Free For Our VIP Members? : Yes
✅ Download Links : Mega & Google Drive
✅ Course Size : 7.41 GB
✅ Updatable? : Yes, all future updates included.
✅ Sales Page : You can check at the bottom of this page.
🏆 Here’s What You Get & Learn With This Course:
8.5 hours of video lessons
60+ practice files & 50+ ready-to-use templates
Quick Guide eBook on Excel Charts
BONUS Cheat Sheets for fast learning
LIFETIME Access so you never feel rushed
English Closed Captions (created by a professional typist)
Direct Support from our teaching assistants
Digital Badge & Certificate of completion
Introduction
How to Succeed with This Course
Download Files & Templates
Looking for a Specific Topic? Use the Transporter!
Section 1: Excel Chart Basics
How to Pick the Right Chart (Answer these questions)
Creating Excel Charts: Data Structure, Multiple Series
Improving Charts: Adding Elements & Formatting
Essential Practices for Creating Standout Visuals
Quiz – Chart Basics
Key Takeaways Chart Basics
Section 2: Mastering Dynamic Charts in Excel
Creating Charts that Update Themselves
Excel Tables & Slicers for Dynamic Charts
Last 12 Months Dynamic Charts (No more Manual Updates!)
Connecting Charts to a Drop-down
Exercise: Switching Units in Charts with a Drop-Down
Dynamic Chart Titles: Add Clarity with Real-time Updates
Adding Context with Text Boxes and Labels like The Economist
Challenge: Interactive Chart with Slicer and Dynamic Text
Automatic Sorting in Charts for Better Reporting
Positioning Axis Labels to Avoid Overlap with Negative Values
PivotCharts with Slicers and Timelines
PivotTable Data to Power Standard Charts with Slicers
Key Takeaways Dynamic Charts
Section 3: Comparing Values
Creating Excel Charts for Impactful Data Comparisons
Column Chart Essentials: Simplifying for Impact
Conditionally Highlight Columns (Top & Bottom Values)
Advanced Column Charts: Auto-Updates & Dynamic Titles
Creative Column Chart Formatting: Beyond the Basics
🔥 Challenge: Dropdown-Driven Conditional Highlights
McKinsey-Style Column Charts
DYNAMIC McKinsey-Style Column Charts
Compact Bar Chart with a Simple Function
McKinsey’s Lollipop Chart for Easy Comparison
Enhance Bar Charts with a Vertical Comparison Line
Dumbbell Charts: The Economist and BBC Style
💪 Exercise Pack to Sharpen Your Skills ✨
📝 Key Takeaways Comparing Values
Section 4: Showing Composition
Charts to Show Composition
Adding Totals to a Stacked Chart
Aligning Series Labels in Stacked Charts
Pie Chart & Doughnut Charts
Upgrading from Pie Charts: Sorted Bars with Extras
Treemaps to Explore Hierarchies
McKinsey’s Waffle Chart
🔥 Challenge: Stacked BAR Chart with Totals
🤔 Quiz – Showing Composition
📝 Key Takeaways Showing Composition
Section 5: Understanding Trends and Patterns
Captivating Line Charts with Simple Tweaks
Avoid Drop to Zero in Line Charts
Dynamic Series Label Integration for Multiple Line Series
Dynamic Data Labels: Frequency Selected from Drop-down
Forward-Looking Charts: Unifying Multiple Series into One
Economist-Style Multi-Line Slope Chart
Small Multiples Chart (Panel Chart) for Side-by-side Comparison
Excel Sparklines: Quick Visual Trends
💪 Exercise Pack to Sharpen Your Skills ✨
🤔 Quiz – Understanding Trends
📝 Key Takeaways Understanding Trends
Section 6: Displaying Change (Variance, Growth, Before/After)
Designing Impactful Variance Charts in Excel
Building Connected Color-Coded Bar Variance Charts
McKinsey-Style Lollipop Variance Charts
🔥 Challenge: Create a Column Lollipop Variance Chart
💪 Exercise: Column Variance Chart
Using Color-Coded Arrows in Charts
Waterfall Chart to Visualize Cumulative Impact
📝 Key Takeaways Displaying Change
Section 7: Presenting Tables in Excel
How to Best Present Data in a Table
Conditionally Change Row & Font Color
Subtle Color Coding for Key Changes
Use Bars and Arrows in Tables for Easier Readability
💪 Exercise: Table Formatting with Data Bars
🤔 Quiz – Presenting Tables
📝 Key Takeaways Presenting Tables
Bonus: More Elite Chart Design inspired by McKinsey & The Economist
Heat Map: McKinsey-Style
Category Chart: The Economist-Style
In-Cell Bar Chart with Comments
Q&A Resource Hub
🔐 Answer Vault
Wrapping Up
🙌 YOU DID IT!
Included: Quick Guide eBook
Use our Quick Guide eBook to master all aspects of Excel charts.
You’ll get step-by-step instructions for over 20 essential charting skills.
It’s packed with expert tips. It covers changing settings, adjusting series, adding conditional formatting and so much more.
Every page brings you closer to becoming an Excel charting pro.
🎁 Bonus Cheat Sheets
Instantly recall what you’ve learned in the course.
Receiving cheat sheets with your course is great because they’re like quick guides.
These short references make using what you learn simple and fast.
And who doesn’t like cheat sheets 😊
✅ Great X Courses Guarantee : At Great X Courses, we insist in providing high quality courses, with direct download links (no paid links or torrents). What you see is exactly what you get, no bad surprises or traps. We update our content as much as possible, to stay up to date with the latest courses updates.
You can find more info on the sales page here.
