Formulas & Functions

Charts & Graphs

Data Analysis 
with PivotTables

Power Query, Power Pivot & DAX

Charts & Graphs

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 provides a comprehensive deep dive into 20+ chart types available in Excel 2016. I’ll show you when, why, and how to use each chart, introduce key data visualization best practices, and guide you through interactive, hands-on demos and exercises every step of the way.


Regular Price


Special Offer

Full Course Access Includes
Lifetime Access
Downloadable resources and practice files
Course quizzes and homework exercises
1-on-1 instructor support
30-day money-back guarantee

Choose A Section

Data Visualization Best Practices

Key Data Visualization Principles

Good, Bad & Ugly Data Visualization

The 3 Key Questions

Customizing Charts in Excel

Chart Elements, Layouts, Colors & Styles

Chart Formatting Options

Changing Chart Types & Secondary Axis

Applying Custom Templates

Mastering Basic Charts & Graphs

Bar & Column Charts

Histogram & Pareto Charts

Line Charts & Trendlines

Area Charts

Pies, Donuts & 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


Next-Level Data Visualization Exercises

DEMO: Custom Image Overlay Charts

DEMO: Charting Binary Values

DEMO: Automation with OFFSET & COUNTA

DEMO: Scroll & Zoom with Form Controls

DEMO: Animating Changes Over Time

DEMO: Dynamic Dashboards (Part 1)

DEMO: Dynamic Dashboards (Part 2)

DEMO: Value-Based Dynamic Formatting

DEMO: Dynamically Chart Highlighting

DEMO: Building a Custom Pacing Chart

DEMO: Custom Gauge Charts

DEMO: Visualizing Percentages with Arrays

Ready to Gain Full Access and Become an Excel Maven?