Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Free Preview: Excel Charts & Graphs
Getting Started
About this Preview Course
Full Course Structure & Outline (2:03)
Bonus Homework Exercises
Data Visualization Best Practices
Key Principles & The 10-Second Rule (2:45)
The Good, The Bad & The Ugly (3:44)
Three Key Questions
Chart Formatting & Customization
Setting Expectations (1:02)
Chart Elements, Layouts & Styles (6:20)
Chart Formatting Options
Changing Chart Types & Adding a Secondary Axis (3:03)
Creating, Modifying & Applying Custom Templates
QUIZ: Chart Customization
Mastering Basic Charts & Graphs
Bar & Column Charts
HOMEWORK: Bar & Column Charts
Histogram & Pareto Charts (5:58)
HOMEWORK: Histogram & Pareto Charts
Line Charts & Trendlines
HOMEWORK: Line Charts & Trendlines
Area Charts (4:41)
HOMEWORK: Area Charts
Pies, Donuts & Race Tracks
HOMEWORK: Pies, Donuts & Race Tracks
Scatter Plots
Bubble Charts (6:36)
HOMEWORK: Scatter Plots & Bubble Charts
Box & Whisker Charts
HOMEWORK: Box & Whisker Charts
Tree Maps & Sunbursts (6:36)
HOMEWORK: Tree Maps & Sunbursts
Waterfall Charts
Funnel Charts
HOMEWORK: Waterfall & Funnel Charts
Radar Charts (7:56)
HOMEWORK: Radar Charts
Stock Charts
HOMEWORK: Stock Charts
Heat Maps
HOMEWORK: Heat Maps
Surface & Contour Charts
HOMEWORK: Surface & Contour Charts
Geospatial Maps with Power Map
HOMEWORK: Power Map
Basic Combo Charts
HOMEWORK: Combo Charts
Sparklines (2:07)
HOMEWORK: Sparklines
QUIZ: Basic Charts & Graphs
Next-Level Data Viz Demos
Setting Expectations (1:40)
DEMO: Custom Image Overlay Charts (6:01)
DEMO: Adding Binary Values to Highlight Ranges
DEMO: Automation with OFFSET & COUNTA
DEMO: Adding Interactive Elements with Form Controls
DEMO: Animating Changes Over Time (14:20)
DEMO: Building a Dynamic Dashboard (Part 1)
DEMO: Building a Dynamic Dashboard (Part 2) (12:08)
DEMO: Dynamic Value-Based Formatting
DEMO: Dynamically Highlighting a Data Series
DEMO: Building a Custom Pacing Chart
DEMO: Building a Custom Gauge Chart (9:58)
DEMO: Visualizing Percentages with Arrays
QUIZ: Next-Level Data Viz
Wrapping Up
Resources & Next Steps
Special Offer
HOMEWORK: Sparklines
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock