Module 1 Before We Dive In
Unit 1 Course Structure & Outline
Unit 2 Resource Files and Datasets
Module 2 Data Visualization Best Practices
Unit 1 Key Data Viz Principles & The 10-Second Rule
Unit 2 The Good, The Bad, and The Ugly
Unit 3 The 3 Key Questions
Module 3 Customizing Charts in Excel
Unit 1 Setting Expectations
Unit 2 Chart Elements, Layouts, Colors & Styles
Unit 3 Chart Formatting Options
Unit 4 Changing Chart Types & Adding a Secondary Axis
Unit 5 Creating, Modifying & Applying Custom Templates
Module 4 Mastering Basic Charts & Graphs
Unit 1 Bar & Columns Charts
Unit 2 Histograms & Pareto Charts
Unit 3 Line Charts & Trendlines
Unit 4 Area Charts
Unit 5 Pies, Donuts & Race Tracks
Unit 6 Scatter Plots
Unit 7 Bubble Charts
Unit 8 Box & Whisker Charts
Unit 9 Tree Maps & Sunburst Charts
Unit 10 Waterfall Charts
Unit 11 Funnel Charts
Unit 12 Radar Charts
Unit 13 Stock Charts
Unit 14 Heat Maps
Unit 15 Surface & Contour Charts
Unit 16 Geo-Spatial Maps with Power Map
Unit 17 Basic Combo Charts
Unit 18 Sparklines
Module 5 Next-Level Data Visualization Exercises
Unit 1 Setting Expectations
Unit 2 DEMO: Custom Image Overlay Charts
Unit 3 DEMO: Adding Binary Values to Highlight Date Ranges
Unit 4 DEMO: Automation with OFFSET, COUNTA & Named Ranges Preview
Unit 5 DEMO: Adding Scroll & Zoom Functionality with Form Controls
Unit 6 DEMO: Animating Changes Over Time
Unit 7 DEMO: Building a Dynamic Dashboard (Part 1)
Unit 8 DEMO: Building a Dynamic Dashboard (Part 2)
Unit 9 DEMO: Value-Based Dynamic Formatting
Unit 10 DEMO: Dynamically Highlighting a Data Series
Unit 11 DEMO: Building a Custom Pacing Chart
Unit 12 DEMO: Designing a Custom Gauge Chart
Unit 13 DEMO: Visualizing a Percentage Using Array Functions
Module 6 Wrapping Up
Unit 1 Additional Resources & Next Steps
Powered By WP Courseware

Data Visualization w/ Excel Charts & Graphs


Course Description

Ask people what comes to mind when they think of Excel, and odds are they'll say “spreadsheets”. The truth is, Excel is an incredibly powerful, robust, and dynamic data visualization platform for those willing to think beyond rows, columns, and primitive pie charts — and I'm here to prove it.

This course gives you a deep, 100% comprehensive understanding of Excel's latest data visualization tools and techniques. I'll show you when, why, and how to use each chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and exercises every step of the way.

We'll kick things off by exploring 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
And more…

From there we'll dive into a series of 12+ advanced Excel demos guaranteed to turn you into an absolute data viz rockstar. These aren't “textbook” demos that you can find on YouTube; these are projects adapted from actual, award-winning work featured by Microsoft, MIT, and the New York Times. I've built my analytics career around data visualization, and I can help you do the same.

Whether you're looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your data visualization game in a major way, this course is for you. In fact, if you don't learn something brand new in this course, I will make sure you get your money back AND give you a virtual high-five for checking it out. You literally can't lose.