Excel Data Visualization Part 1: Charts & Graphs

Chris Dutton, Founder, Excel Maven

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
28 Lessons (2h 27m)
    • 1. Course Structure and Outline

      2:03
    • 2. Key Data Viz Principles & The 10-Second Rule

      2:45
    • 3. The Good, The Bad, and The Ugly

      3:44
    • 4. The 3 Key Questions

      1:49
    • 5. Customizing Charts in Excel: Setting Expectations

      1:02
    • 6. Chart Elements, Layouts, Colors, and Styles

      6:20
    • 7. Chart Formatting Options

      5:27
    • 8. Changing Chart Types & Adding a Secondary Axis

      3:03
    • 9. Creating, Modifying & Applying Custom Templates

      4:06
    • 10. Bar & Column Charts

      8:49
    • 11. Histograms & Pareto Charts

      5:58
    • 12. Line Charts & Trendlines

      5:16
    • 13. Area Charts

      4:41
    • 14. Pies, Donuts, and Race Tracks

      12:04
    • 15. Scatter Plots

      7:30
    • 16. Bubble Charts

      6:36
    • 17. Box & Whisker Charts

      6:05
    • 18. Tree Maps & Sunburst Charts

      6:36
    • 19. Waterfall Charts

      3:17
    • 20. Funnel Charts

      3:42
    • 21. Radar Charts

      7:56
    • 22. Stock Charts

      7:18
    • 23. Heat Maps

      4:41
    • 24. Surface & Contour Charts

      7:35
    • 25. Geo-Spatial Maps with Power Map

      5:28
    • 26. Basic Combo Charts

      7:57
    • 27. Sparklines

      2:07
    • 28. Conclusion

      2:38
37 students are watching this class

About This Class

This class is Part 1 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.

In this section of the course I'll introduce key data visualization tips and best practices, guide you through interactive, hands-on demos and exercises, and show you when, why, and how to use each of the 20+ chart types that Excel 2016 has to offer, including: 

  • Bar & Column charts
  • Histograms & Pareto charts
  • Line charts & trend lines 
  • Area charts
  • Pies & Donuts
  • Scatter plots & Bubble charts
  • Box & Whisker charts
  • Tree Maps & Sunbursts
  • Waterfall & Funnel charts
  • Radar & Stock charts
  • Heat maps, 3-D Surface & contour charts
  • Chloropleths & Geospatial maps
  • Custom combo charts & graphs
  • Sparklines

Once you've mastered the basics, Part 2 is all about putting your skills to the test, with advanced demos and case studies that you won't find in ANY other course, guaranteed.

Whether you're looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your data viz game in a major way, this series is for you.

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?

  • A step-by-step, 100% comprehensive guide to visualizing data using charts & graphs in Excel
  • A deep understanding of WHEN, WHY, and HOW to use 20+ chart types in Excel 2016
  • 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 have basic skills but want to master advanced charts, graphs & dashboards
  • Students looking for an engaging, hands-on, and highly interactive approach to training