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.

$175

Regular Price

$25

Special Offer

Full Course Access Includes

https://www.excelmaven.com/wp-content/themes/salient/css/fonts/svg/basic_clockwise.svg
Lifetime Access
https://www.excelmaven.com/wp-content/themes/salient/css/fonts/svg/basic_elaboration_browser_download.svg
Downloadable resources and practice files
https://www.excelmaven.com/wp-content/themes/salient/css/fonts/svg/basic_book_pencil.svg
Course quizzes and homework exercises
https://www.excelmaven.com/wp-content/themes/salient/css/fonts/svg/arrows_shrink_horizonal2.svg
1-on-1 instructor support
https://www.excelmaven.com/wp-content/themes/salient/css/fonts/svg/ecommerce_receipt_dollar.svg
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

Sparklines

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?

ACCESS FULL COURSE