Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Business Charts in Excel
Introduction
How to Succeed with This Course (6:02)
⚙️ How to Use the Platform for Best Learning Experience
⬇️ 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) (8:36)
Creating Excel Charts: Data Structure, Multiple Series (12:32)
Improving Charts: Adding Elements & Formatting (14:01)
Essential Practices for Creating Standout Visuals (8:36)
🤔 Quiz - Chart Basics
📝 Key Takeaways Chart Basics
🔃 Section 2: Mastering Dynamic Charts in Excel
Creating Charts that Update Themselves (3:03)
Excel Tables & Slicers for Dynamic Charts (8:22)
Last 12 Months Dynamic Charts (No more Manual Updates!) (7:20)
Connecting Charts to a Drop-down (6:42)
💪 Exercise: Switching Units in Charts with a Drop-Down
Dynamic Chart Titles: Add Clarity with Real-time Updates (10:53)
Adding Context with Text Boxes and Labels like The Economist (9:26)
🔥 Challenge: Interactive Chart with Slicer and Dynamic Text (10:05)
Automatic Sorting in Charts for Better Reporting (5:09)
Positioning Axis Labels to Avoid Overlap with Negative Values (10:14)
PivotCharts with Slicers and Timelines (11:16)
PivotTable Data to Power Standard Charts with Slicers (10:00)
Bonus: More Interactive Charts with New Excel Features
📝 Key Takeaways Dynamic Charts
🔍 Section 3: Comparing Values
Creating Excel Charts for Impactful Data Comparisons (3:00)
Column Chart Essentials: Simplifying for Impact (5:27)
Conditionally Highlight Columns (Top & Bottom Values) (11:04)
Advanced Column Charts: Auto-Updates & Dynamic Titles (11:45)
Creative Column Chart Formatting: Beyond the Basics (12:17)
🔥 Challenge: Dropdown-Driven Conditional Highlights (7:11)
McKinsey-Style Column Charts (16:25)
DYNAMIC McKinsey-Style Column Charts (13:01)
Compact Bar Chart with a Simple Function (6:14)
McKinsey's Lollipop Chart for Clear Comparison (7:42)
Add a Vertical Comparison Line to Enhance Bar Charts (8:25)
Dumbbell Charts: The Economist and BBC Style (13:14)
💪 Exercise Pack to Sharpen Your Skills ✨
📝 Key Takeaways Comparing Values
🧩 Section 4: Showing Composition
Charts to Show Composition (1:51)
Adding Totals to a Stacked Chart (4:43)
Aligning Series Labels in Stacked Charts (7:16)
Pie Charts & Doughnut Charts (8:55)
Upgrading from Pie Charts: Sorted Bars with Extras (7:50)
Treemaps to Explore Hierarchies (4:54)
McKinsey's Waffle Chart (7:34)
🔥 Challenge: Stacked BAR Chart with Totals (5:10)
🤔 Quiz - Showing Composition
📝 Key Takeaways Showing Composition
📈 Section 5: Understanding Trends and Patterns
Captivating Line Charts with Simple Tweaks (9:50)
Avoid Drop to Zero in Line Charts (5:39)
Dynamic Series Label Integration for Multiple Line Series (9:28)
Dynamic Data Labels: Frequency Selected from Drop-down (11:19)
Forward-Looking Charts: Unifying Multiple Series into One (11:10)
Slope Chart (Economist-Style Multi-Line Chart) (8:16)
Small Multiples Chart (Panel Chart) for Side-by-side Comparison (11:10)
Excel Sparklines: Quick Visual Trends (8:42)
💪 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 (2:05)
Building Connected Color-Coded Bar Variance Charts (9:56)
McKinsey-Style Lollipop Variance Charts (11:10)
🔥 Challenge: Create a Column Lollipop Variance Chart (7:54)
💪 Exercise: Column Variance Chart
Using Color-Coded Arrows in Charts (7:00)
Waterfall Chart to Visualize Cumulative Impact (9:54)
📝 Key Takeaways Displaying Change
📄 Section 7: Presenting Tables in Excel
How to Best Present Data in a Table (6:52)
Conditionally Change Row & Font Color (6:42)
Subtle Color Coding for Key Changes (5:10)
Use Bars and Arrows in Tables for Easier Readability (10:25)
💪 Exercise: Table Formatting with Data Bars
🤔 Quiz - Presenting Tables
📝 Key Takeaways Presenting Tables
💡 Bonus - More Elite Chart Design
Heat Map: McKinsey-Style (9:58)
Category Chart: The Economist-Style (8:58)
In-Cell Bar Chart with Annotations (11:54)
⏰ Bonus - Cheat Sheets for ALL Chart Designs
Cheat Sheets for Easy Chart Creation
❓🗝️ Q&A Resource Hub
🔐 Answer Vault
🎓 Wrapping Up
🙌 YOU DID IT! (1:59)
✍️Leave a Review
My Favorite Resources
🏅 Share Your Digital Certificate (0:40)
McKinsey's Lollipop Chart for Clear Comparison
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock