Introduction to Data Visualization in Excel (Part 2): Advanced, Real-World Case Studies

Chris Dutton, Founder, Excel Maven

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

      1:40
    • Custom Image Overlay Charts

      6:01
    • Adding Binary Values to Highlight Date Ranges

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

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

      12:30
    • Animating Changes Over Time

      14:20
    • Building a Dynamic Dashboard Part 1

      16:10
    • Building a Dynamic Dashboard Part 2

      12:08
    • Value Based Dynamic Formatting

      10:09
    • Dynamically Highlighting a Data Series

      10:26
    • Building a Custom Pacing Chart

      10:22
    • Designing a Custom Gauge Chart

      9:58
    • Visualize a Percentage Using Array Functions

      7:16
    • Conclusion

      2:38