-
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
Overview
Syllabus
-
- Course Structure and Outline
- Key Data Viz Principles & The 10-Second Rule
- The Good, The Bad, and The Ugly
- The 3 Key Questions
- Customizing Charts in Excel: Setting Expectations
- Chart Elements, Layouts, Colors, and Styles
- Chart Formatting Options
- Changing Chart Types & Adding a Secondary Axis
- Creating, Modifying & Applying Custom Templates
- Bar & Column Charts
- Histograms & Pareto Charts
- Line Charts & Trendlines
- Area Charts
- Pies, Donuts, and Race Tracks
- Scatter Plots
- Bubble Charts
- Box & Whisker Charts
- Tree Maps & Sunburst Charts
- Waterfall Charts
- Funnel Charts
- Radar Charts
- Stock Charts
- Heat Maps
- Surface & Contour Charts
- Geo-Spatial Maps with Power Map
- Basic Combo Charts
- Sparklines
- Conclusion
