Excel Data Visualization Part 1: Charts & Graphs | Chris Dutton | Skillshare

# 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
27 students are watching 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