Excel Data Visualization Part 2: Advanced Demos

Chris Dutton, Founder, Excel Maven

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
14 Lessons (2h 6m)
    • 1. Intro: Setting Expectations

      1:40
    • 2. Custom Image Overlay Charts

      6:01
    • 3. Adding Binary Values to Highlight Date Ranges

      5:02
    • 4. Automation with OFFSET, COUNTA & Named Ranges

      7:08
    • 5. Adding Scroll & Zoom Functionality with Form Control

      12:30
    • 6. Animating Changes Over Time

      14:20
    • 7. Building a Dynamic Dashboard Part 1

      16:10
    • 8. Building a Dynamic Dashboard Part 2

      12:08
    • 9. Value Based Dynamic Formatting

      10:09
    • 10. Dynamically Highlighting a Data Series

      10:26
    • 11. Building a Custom Pacing Chart

      10:22
    • 12. Designing a Custom Gauge Chart

      9:58
    • 13. Visualize a Percentage Using Array Functions

      7:16
    • 14. Conclusion

      2:38

About This Class

This class is Part 2 of a two part Excel data visualization series, designed to give you a deep, 100% comprehensive understanding of Excel's latest data visualization tools and techniques.

This segment builds on the skills developed in Microsoft Excel: Data Visualization With Charts & Graphs (Part 1) by introducing a series of advanced demos and case studies that you won't find in ANY other Excel course, including:

  • Custom image-overlay charts
  • Automation with dynamic ranges
  • Scroll & zoom functionality with form controls
  • Dynamic dashboards
  • Advanced formatting techniques
  • Custom-built gauge charts
  • And more!

What are the requirements?

  • Microsoft Excel, ideally 2016 for PC (some charts are not available in earlier versions of Excel)
  • Mac users are welcome, but note that the user experience will be significantly different across platforms

What am I going to get from this course?

  • Exclusive data visualization tips, tricks, and best practices from an award-winning analytics expert
  • Unique, custom content that you won't find in ANY other course

Who is the target audience?

  • Anyone looking to create beautiful, custom data visualizations in Excel
  • Excel users who want to master advanced charts, graphs & dashboards
  • Students looking for an engaging, hands-on, and highly interactive approach to training