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
- Sparklines
- 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.
Course Curriculum
| 1.1 Course Structure & Outline | |||
| 1.1 Course Structure & Outline | 00:00:00 | ||
| 1.2 Resource Files and Datasets | |||
| 1.2 Resource Files and Datasets | 00:00:00 | ||
| 2.2 The Good, The Bad, and The Ugly | |||
| 2.2 The Good, The Bad, and The Ugly | 00:00:00 | ||
| 2.3 The 3 Key Questions | |||
| 2.3 The 3 Key Questions | 00:00:00 | ||
| 3.1 Setting Expectations | |||
| 3.1 Setting Expectations | 00:00:00 | ||
| 3.2 Chart Elements, Layouts, Colors & Styles | |||
| 3.2 Chart Elements, Layouts, Colors & Styles | 00:00:00 | ||
| 3.3 Chart Formatting Options | |||
| 3.3 Chart Formatting Options | 00:00:00 | ||
| 3.4 Changing Chart Types & Adding a Secondary Axis | |||
| 3.4 Changing Chart Types & Adding a Secondary Axis | 00:00:00 | ||
| 3.5 Creating, Modifying & Applying Custom Templates | |||
| 3.5 Creating, Modifying & Applying Custom Templates | 00:00:00 | ||
| 4.1 Bar & Columns Charts | |||
| 4.1 Bar & Columns Charts | 00:00:00 | ||
| 4.2 Histograms & Pareto Charts | |||
| 4.2 Histograms & Pareto Charts | 00:00:00 | ||
| 4.3 Line Charts & Trendlines | |||
| 4.3 Line Charts & Trendlines | 00:00:00 | ||
| 4.4 Area Charts | |||
| 4.4 Area Charts | 00:00:00 | ||
| 4.5 Pies, Donuts & Race Tracks | |||
| 4.5 Pies, Donuts & Race Tracks | 00:00:00 | ||
| 4.6 Scatter Plots | |||
| 4.6 Scatter Plots | 00:00:00 | ||
| 4.7 Bubble Charts | |||
| 4.7 Bubble Charts | 00:00:00 | ||
| 4.8 Box & Whisker Charts | |||
| 4.8 Box & Whisker Charts | 00:00:00 | ||
| 4.9 Tree Maps & Sunburst Charts | |||
| 4.9 Tree Maps & Sunburst Charts | 00:00:00 | ||
| 4.10 Waterfall Charts | |||
| 4.10 Waterfall Charts | 00:00:00 | ||
| 4.11 Funnel Charts | |||
| 4.11 Funnel Charts | 00:00:00 | ||
| 4.12 Radar Charts | |||
| 4.12 Radar Charts | 00:00:00 | ||
| 4.13 Stock Charts | |||
| 4.13 Stock Charts | 00:00:00 | ||
| 4.14 Heat Maps | |||
| 4.14 Heat Maps | 00:00:00 | ||
| 4.15 Surface & Contour Charts | |||
| 4.15 Surface & Contour Charts | 00:00:00 | ||
| 4.16 Geo-Spatial Maps with Power Map | |||
| 4.16 Geo-Spatial Maps with Power Map | 00:00:00 | ||
| 4.17 Basic Combo Charts | |||
| 4.17 Basic Combo Charts | 00:00:00 | ||
| 4.18 Sparklines | |||
| 4.18 Sparklines | 00:00:00 | ||
| 5.1 Setting Expectations | |||
| 5.1 Setting Expectations | 00:00:00 | ||
| 5.2 Demo Custom Image Overlay Charts | |||
| 5.2 Demo Custom Image Overlay Charts | 00:00:00 | ||
| 5.3 Demo Adding Binary Values to Highlight Date Ranges | |||
| 5.3 Demo Adding Binary Values to Highlight Date Ranges | 00:00:00 | ||
| 5.4 Demo Automation with OFFSET, COUNTA & Named Ranges Preview | |||
| 5.4 Demo Automation with OFFSET, COUNTA & Named Ranges Preview | 00:00:00 | ||
| 5.5 Demo Adding Scroll & Zoom Functionality with Form Controls | |||
| 5.5 Demo Adding Scroll & Zoom Functionality with Form Controls | 00:00:00 | ||
| 5.6 Demo Animating Changes Over Time | |||
| 5.6 Demo Animating Changes Over Time | 00:00:00 | ||
| 5.7 Demo Building a Dynamic Dashboard (Part 1) | |||
| 5.7 Demo Building a Dynamic Dashboard (Part 1) | 00:00:00 | ||
| 5.8 Demo Building a Dynamic Dashboard (Part 2) | |||
| 5.8 Demo Building a Dynamic Dashboard (Part 2) | 00:00:00 | ||
| 5.9 Demo Value-Based Dynamic Formatting | |||
| 5.9 Demo Value-Based Dynamic Formatting | 00:00:00 | ||
| 5.10 Demo Dynamically Highlighting a Data Series | |||
| 5.10 Demo Dynamically Highlighting a Data Series | 00:00:00 | ||
| 5.11 Demo Building a Custom Pacing Chart | |||
| 5.11 Demo Building a Custom Pacing Chart | 00:00:00 | ||
| 5.12 Demo Designing a Custom Gauge Chart | |||
| 5.12 Demo Designing a Custom Gauge Chart | 00:00:00 | ||
| 5.13 Demo Visualizing a Percentage Using Array Functions | |||
| 5.13 Demo Visualizing a Percentage Using Array Functions | 00:00:00 | ||
| 6.1 Additional Resources & Next Steps | |||
| 6.1 Additional Resources & Next Steps | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
0 STUDENTS ENROLLED
