Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel: Data Visualization with Excel Charts & Graphs
Getting Started
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 (1:49)
Chart Customization
Setting Expectations (1:02)
Chart Elements, Layouts & Styles (6:20)
Chart Formatting Options (5:27)
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:59)
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:31)
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:10)
DEMO: Dynamically Highlighting a Data Series (10:26)
DEMO: Building a Custom Pacing Chart (10:23)
DEMO: Building a Custom Gauge Chart (9:58)
DEMO: Visualizing Percentages with Arrays (7:16)
QUIZ: Next-Level Data Viz
Wrapping Up
Resources & Next Steps (2:38)
DEMO: Building a Dynamic Dashboard (Part 2)
Complete and Continue
Discussion
0
comments
Load more
0 comments