Getting Started
  • Course Structure & Outline
  • READ ME: Important Notes for New Students
  • DOWNLOAD: Course Resources
  • Setting Expectations
Data Visualization Best Practices
  • Key Visualization Principles & The 10-Second Rule
  • Good, Bad & Ugly Data Viz
  • 3 Key Questions for Effective Visualization
Excel Chart Formatting & Customization
  • Customizing Chart Elements, Layouts & Styles
  • Configuring Chart Formats
  • Changing Chart Types & Adding a Secondary Axis
  • Creating & Applying Custom Chart Templates
  • Excel Chart Customization
Mastering Basic Excel Charts & Graphs
  • DEMO: Excel Bar & Columns Charts
  • HOMEWORK: Bar & Column Charts
  • DEMO: Excel Histograms & Pareto Charts (Office 365/Excel 2016+)
  • HOMEWORK: Histograms & Pareto Charts
  • DEMO: Excel Line Charts & Trendlines
  • HOMEWORK: Line Charts & Trendlines
  • DEMO: Excel Area Charts
  • HOMEWORK: Area Charts
  • DEMO: Excel Pie Charts, Donuts & Race Tracks
  • HOMEWORK: Pies, Donuts & Race Tracks
  • DEMO: Excel Scatter Plots
  • DEMO: Excel Bubble Charts
  • HOMEWORK: Scatter Plots & Bubble Charts
  • DEMO: Excel Box & Whisker Charts (Office 365/Excel 2016+)
  • HOMEWORK: Box & Whisker Charts
  • DEMO: Excel Tree Maps & Sunburst Charts (Office 365/Excel 2016+)
  • HOMEWORK: Tree Maps & Sunburst Charts
  • DEMO: Excel Waterfall Charts (Office 365/Excel 2016+)
  • DEMO: Excel Funnel Charts (Office 365/Excel 2016+)
  • HOMEWORK: Waterfall & Funnel Charts
  • DEMO: Excel Radar Charts
  • HOMEWORK: Radar Charts
  • DEMO: Excel Stock Charts
  • HOMEWORK: Stock Charts
  • DEMO: Excel Heat Maps with Conditional Formatting
  • HOMEWORK: Heat Maps
  • DEMO: Excel Surface & 3D Contour Charts
  • HOMEWORK: Surface & Contour Charts
  • DEMO: Geo-Spatial Mapping with Excel Power Map
  • HOMEWORK: Power Map
  • DEMO: Common Excel Combo Charts
  • HOMEWORK: Combo Charts
  • DEMO: Excel Sparklines
  • HOMEWORK: Sparklines
  • Basic Excel Chart Types
Next-Level Demos
  • Setting Expectations
  • DEMO: Creating Custom Image Overlay Charts
  • DEMO: Using Binary Values to Highlight Time Periods
  • DEMO: Automating Charts with Named Ranges (OFFSET & COUNTA)
  • DEMO: Adding Scroll & Zoom Functionality Using Form Controls
  • DEMO: Creating Interactive Area Charts to Show Changes Over Time
  • DEMO: Building a Dynamic Excel Dashboard (Part 1)
  • DEMO: Building a Dynamic Excel Dashboard (Part 2)
  • DEMO: Dynamic Chart Formatting Based on Values
  • DEMO: Dynamically Highlighting Segments of Data
  • DEMO: Building a Custom Excel Pacing Chart
  • DEMO: Designing a Custom Excel Gauge Chart
  • DEMO: Visualizing Percentages Using Array Functions
  • Advanced Excel Data Visualization Techniques
Wrapping Up
  • BONUS LECTURE: More from Maven Analytics