Introduction to Data Visualization in Excel: Charts & Graphs (Part 1)

Chris Dutton, Founder, Excel Maven

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
27 Videos (2h 19m)
    • Course Structure and Outline

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

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

      3:44
    • The 3 Key Questions

      1:49
    • Customizing Charts in Excel: Setting Expectations

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

      6:20
    • Chart Formatting Options

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

      3:03
    • Creating, Modifying & Applying Custom Templates

      4:06
    • Bar & Column Charts

      8:49
    • Histograms & Pareto Charts

      5:58
    • Line Charts & Trendlines

      5:16
    • Area Charts

      4:41
    • Pies, Donuts, and Race Tracks

      12:04
    • Scatter Plots

      7:30
    • Bubble Charts

      6:36
    • Box & Whisker Charts

      6:05
    • Tree Maps & Sunburst Charts

      6:36
    • Waterfall Charts

      3:17
    • Funnel Charts

      3:42
    • Radar Charts

      7:56
    • Stock Charts

      7:18
    • Heat Maps

      4:41
    • Geo-Spatial Maps with Power Map

      5:28
    • Basic Combo Charts

      7:57
    • Sparklines

      2:07
    • Conclusion

      2:38

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

10 of 10 students recommendSee All

it worthes every minute!! Many thanks to the teacher!
Chris is an excellent instructor, calm, clear and well-paced. I'd estimate I've taken 15-20 courses on Skillshare so far. I found this to be 1 of the top courses (if not the top) based on its high volume of understandable, usable, and "impactful" content. Great work, Chris. If you're a self-described "data nerd", this is a must-take.
clearn in-depth and helpfu

111

Students

--

Projects

Chris Dutton

Founder, Excel Maven

Chris Dutton is a Certified Microsoft Expert and Analytics Consultant with more than a decade of experience in the B.I and data science fields. His work has been featured by Microsoft, the Society of American Baseball Research (SABR) and the New York Times.

Excel Maven provides high-quality online analytics training, hands-on workshops, and project-based consulting services to clients and students across 120+ countries.