• Course Structure & Outline Free
  • Setting Expectations Free
  • The Course Projects Free

  • Introduction Free
  • Data Viz 101 Free
  • The 10-Second Rule Free
  • The 3 Key Questions Free
  • Essential Visuals Free
  • Chart Formatting Tips Free
  • Storytelling with Data Pro
  • Common Visualization Mistakes Pro
  • BEST PRACTICES: Data Visualization Pro
  • QUIZ: Data Visualization Pro

  • Project Brief Pro
  • Creating the Chart in Excel Pro
  • Applying Chart Formatting Pro
  • Telling the Story Pro
  • ASSIGNMENT: Upload the Project to Showcase Pro
  • Selecting an Effective Chart Type Pro

  • Introduction Pro
  • Dashboards 101 Pro
  • Types of Dashboards Pro
  • Defining a Purpose Pro
  • Visual Elements Pro
  • Adding Context Pro
  • Dashboard Layouts Pro
  • BEST PRACTICES: Dashboard Design Pro
  • QUIZ: Dashboard Design Pro

  • Project Brief Pro
  • Defining the Purpose & Visuals Pro
  • Preparing the Filters & Interactivity Pro
  • Using AVERAGEIFS for Conditional Calculations Pro
  • Creating a Bar Chart Pro
  • PRO TIP: Sorting Based on Formulas Pro
  • Creating a Donut Chart Pro
  • PRO TIP: Grouping Donut Slices Pro
  • Creating a Combo Chart Pro
  • PRO TIP: Splitting Combo Chart Elements Pro
  • Creating a Filled Map Pro
  • PRO TIP: Adding New Data with Data Types Pro
  • PRO TIP: Switching Between Series in a Map Pro
  • Setting Up the Dashboard Layout Pro
  • Using Color Strategically Pro
  • PRO TIP: Dynamically Highlighting Series Pro
  • PRO TIP: Inserting Form Controls Pro
  • Creating Custom Color Themes Pro
  • Protecting the Dashboard Pro
  • ASSIGNMENT: Upload the Project to Showcase Pro

  • Project Brief Pro
  • Defining the Purpose & Visuals Pro
  • Preparing for Scale Pro
  • PRO TIP: Using Name Manager for Filter Values Pro
  • Calculating KPIs Pro
  • Applying Conditional Formatting Rules Pro
  • PRO TIP: Inserting Linked Pictures Pro
  • PRO TIP: Using Absolute Structured References Pro
  • Creating a Line Chart Pro
  • PRO TIP: Hiding Zero Values in a Line Chart Pro
  • Creating Complementary Bar Charts Pro
  • PRO TIP: Dynamically Sorting Data Pro
  • Creating Top/Bottom Tables Pro
  • Setting Up the Dashboard Layout Pro
  • Using Color Strategically Pro
  • Using Titles to Tell a Story Pro
  • Sharing the Dashboard Online Pro
  • PRO TIP: Formula Based Formatting Pro
  • ASSIGNMENT: Upload the Project to Showcase Pro

  • Project Brief Pro
  • Understanding the Story Pro
  • Defining the Purpose & Visuals Pro
  • Visualizing Seasonality with a Combo Chart Pro
  • Contrasting Gains & Losses with a Column Chart Pro
  • PRO TIP: Conditional Custom Number Formats Pro
  • PRO TIP: Using Stacked Bars Instead of Pies Pro
  • PRO TIP: Visualizing Part of a PivotTable Pro
  • Setting Up the Dashboard Layout Pro
  • Using Text to Tell a Story Pro
  • PRO TIP: Saving the Dashboard as an Image Pro
  • ASSIGNMENT: Upload the Project to Showcase Pro

  • Tips for Success Pro
  • Helpful Resources Pro

  • Course Feedback Survey Pro
  • Share the Love! Pro
  • Next Steps Pro