Chris Dutton – DATA VISUALIZATION WITH EXCEL CHARTS & GRAPHS

WHAT WILL YOU LEARN?

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!

WHAT’S INCLUDED IN THE COURSE?

• LIFETIME access to all content
• Downloadable project files and resources
• Unique, hands-on demos and case studies
• Course quizzes & homework exercises
• Certificate of Completion
• 100% MONEY-BACK GUARANTEE

WHO IS THIS COURSE FOR?

• 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

COURSE CURRICULUM

Getting Started
PreviewCourse Structure & Outline (1:27)
StartDOWNLOAD: Course Resources
StartSetting Expectations (2:02)
Data Visualization Best Practices
PreviewKey Principles & The 10-Second Rule (2:45)
PreviewThe Good, The Bad & The Ugly (3:44)
StartThree Key Questions (1:49)
Chart Formatting & Customization
StartChart Elements, Layouts & Styles (6:20)
StartChart Formatting Options (5:26)
StartChanging Chart Types & Adding a Secondary Axis (3:03)
PreviewCreating, Modifying & Applying Custom Templates (4:06)
StartQUIZ: Chart Customization
Mastering Basic Charts & Graphs
StartBar & Column Charts (8:49)
StartHOMEWORK: Bar & Column Charts
StartHistogram & Pareto Charts (5:58)
StartHOMEWORK: Histogram & Pareto Charts
StartLine Charts & Trendlines (5:16)
StartHOMEWORK: Line Charts & Trendlines
StartArea Charts (4:41)
StartHOMEWORK: Area Charts
StartPies, Donuts & Race Tracks (12:04)
StartHOMEWORK: Pies, Donuts & Race Tracks
StartScatter Plots (7:30)
StartBubble Charts (6:36)
StartHOMEWORK: Scatter Plots & Bubble Charts
StartBox & Whisker Charts (6:05)
StartHOMEWORK: Box & Whisker Charts
PreviewTree Maps & Sunbursts (6:36)
StartHOMEWORK: Tree Maps & Sunbursts
StartWaterfall Charts (3:17)
StartFunnel Charts (3:42)
StartHOMEWORK: Waterfall & Funnel Charts
PreviewRadar Charts (7:56)
StartHOMEWORK: Radar Charts
StartStock Charts (7:18)
StartHOMEWORK: Stock Charts
StartHeat Maps (4:41)
StartHOMEWORK: Heat Maps
StartSurface & Contour Charts (7:35)
StartHOMEWORK: Surface & Contour Charts
StartGeospatial Maps with Power Map (5:28)
StartHOMEWORK: Power Map
StartBasic Combo Charts (7:57)
StartHOMEWORK: Combo Charts
StartSparklines (2:07)
StartHOMEWORK: Sparklines
StartQUIZ: Basic Charts & Graphs
Next-Level Data Viz Demos
StartSetting Expectations (1:40)
StartDEMO: Custom Image Overlay Charts (6:01)
StartDEMO: Adding Binary Values to Highlight Ranges (5:02)
PreviewDEMO: Automation with OFFSET & COUNTA (7:08)
StartDEMO: Adding Interactive Elements with Form Controls (12:30)
StartDEMO: Animating Changes Over Time (14:20)
StartDEMO: Building a Dynamic Dashboard (Part 1) (16:10)
PreviewDEMO: Building a Dynamic Dashboard (Part 2) (12:08)
StartDEMO: Dynamic Value-Based Formatting (10:09)
PreviewDEMO: Dynamically Highlighting a Data Series (10:26)
StartDEMO: Building a Custom Pacing Chart (10:22)
StartDEMO: Building a Custom Gauge Chart (9:58)
StartDEMO: Visualizing Percentages with Arrays (7:16)
StartQUIZ: Next-Level Data Viz
Wrapping Up
PreviewMore from Maven Analytics