Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel: Data Visualization with Charts & Graphs
Getting Started
Course Structure & Outline (1:27)
Bonus Homework Exercises
Setting Expectations (2:02)
Important Note for StackSkills Students
Data Visualization Best Practices
Key Principles & The 10-Second Rule (2:45)
The Good, The Bad & The Ugly (3:44)
Three Key Questions (1:49)
Chart Formatting & Customization
Chart Elements, Layouts & Styles (6:20)
Chart Formatting Options (5:26)
Changing Chart Types & Adding a Secondary Axis (3:03)
Creating, Modifying & Applying Custom Templates (4:06)
QUIZ: Chart Customization
Mastering Basic Charts & Graphs
Bar & Column Charts (8:49)
HOMEWORK: Bar & Column Charts
Histogram & Pareto Charts (5:58)
HOMEWORK: Histogram & Pareto Charts
Line Charts & Trendlines (5:16)
HOMEWORK: Line Charts & Trendlines
Area Charts (4:41)
HOMEWORK: Area Charts
Pies, Donuts & Race Tracks (12:04)
HOMEWORK: Pies, Donuts & Race Tracks
Scatter Plots (7:30)
Bubble Charts (6:36)
HOMEWORK: Scatter Plots & Bubble Charts
Box & Whisker Charts (6:05)
HOMEWORK: Box & Whisker Charts
Tree Maps & Sunbursts (6:36)
HOMEWORK: Tree Maps & Sunbursts
Waterfall Charts (3:17)
Funnel Charts (3:42)
HOMEWORK: Waterfall & Funnel Charts
Radar Charts (7:56)
HOMEWORK: Radar Charts
Stock Charts (7:18)
HOMEWORK: Stock Charts
Heat Maps (4:41)
HOMEWORK: Heat Maps
Surface & Contour Charts (7:35)
HOMEWORK: Surface & Contour Charts
Geospatial Maps with Power Map (5:28)
HOMEWORK: Power Map
Basic Combo Charts (7:57)
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 (5:02)
DEMO: Automation with OFFSET & COUNTA (7:08)
DEMO: Adding Interactive Elements with Form Controls (12:30)
DEMO: Animating Changes Over Time (14:20)
DEMO: Building a Dynamic Dashboard (Part 1) (16:10)
DEMO: Building a Dynamic Dashboard (Part 2) (12:08)
DEMO: Dynamic Value-Based Formatting (10:09)
DEMO: Dynamically Highlighting a Data Series (10:26)
DEMO: Building a Custom Pacing Chart (10:22)
DEMO: Building a Custom Gauge Chart (9:58)
DEMO: Visualizing Percentages with Arrays (7:16)
QUIZ: Next-Level Data Viz
Wrapping Up
More from Maven Analytics
HOMEWORK: Scatter Plots & Bubble Charts
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock