Excel 2016: Advanced Charts & Graphs

$42.00 USD

Premium members get this course for $37.50 USD.

Learn More
or preview the first video
42 Lessons
4:30:03 Total Length
  • About
  • Curriculum

Create stunning charts, graphs & visualizations in Excel 2016 with hands-on demos from an award-winning Excel expert.

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 viz game in a major way, this course is for you.

About the Author

Chris is a Certified Excel Expert and Analytics Consultant with nearly a decade of experience in the field. Specializing in B.I. and data visualization, Chris founded Excel Maven in 2014 to deliver high quality training to students around the globe.
Posted: 31 August, 2016
Section 1: Before We Dive In
Section 2: Data Visualization Best Practices+
Section 3: Customizing Charts in Excel+
Section 4: Mastering Basic Charts & Graphs+
Section 6: Wrapping Up
This is a certification course.
By completing this course, you are eligible for certification opportunities. This course provides the instruction and educational material needed to prepare for a third-party certification exam.
This is a course package.
Course packages provide a comprehensive learning plan at a discounted price, and may lead to certification opportunities.