Leila Gharani – Business Charts in Excel

CREATE EXCEL CHARTS THAT GET YOU NOTICED

Feel 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 lessons
• 60+ practice files & 50+ ready-to-use templates
• Quick Guide eBook on Excel Charts

What You’ll Learn In Business Charts in Excel

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

• 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

More courses from the same author: Leila Gharani