Join SuperDataScience
Start Your Free Trial Today >>Ask people what comes to mind when they think of Excel, and odds are they'll say āspreadsheetsā.
The truth is, that 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 20+ chart types that Excel 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
Choropleths & 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.
The course is structured the following six modules:
Module 1 - Before We Dive In
Module 2 - Data Visualization Best Practices
Module 3 - Customizing Charts in Excel
Module 4 - Mastering Basic Charts & Graphs
Module 5 - Next-Level Data Visualization Exercises
Module 6 - Wrapping Up
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.
$35
/ MonthAccelerate your Career and boost your Earning Potential with our Expert Instructors & Community! What Youāll Unlock: - š 40+ Courses (over 200 hours!) - š 17 Specialized Career Paths - š Quizzes and Practice Activities - š Certificates for Courses & Career Paths - š Prizes for Learning - š§Ŗ Weekly Live Labs (plus recordings!) - šÆ Monthly Missions to practice even more - š¼ Monthly Career Booster Events - š¬ Full access to the SDS Community - ā” Monthly Speed Networking - š„ Monthly Resume Clinics - š„ Group Mentorship Program "In just a few months of learning at SDS, I landed a Data Analyst job!" ā Sanaz Afshar, California
$157
/ MonthAccelerate your Career and boost your Earning Potential with our Expert Instructors & Community! What Youāll Unlock: - š 40+ Courses (over 200 hours!) - š 17 Specialized Career Paths - š Quizzes and Practice Activities - š Certificates for Courses & Career Paths - š Prizes for Learning - š§Ŗ Weekly Live Labs (plus recordings!) - šÆ Monthly Missions to practice even more - š¼ Monthly Career Booster Events - š¬ Full access to the SDS Community - ā” Monthly Speed Networking - š„ Monthly Resume Clinics - š„ Group Mentorship Program Plus, Pro Plan perks just for you: - š A Personalized Career Path built around your goals - š§āš« 1-on-1 Mentoring Sessions every month - āļø Personalized Resume Reviews "In just a few months of learning at SDS, I landed a Data Analyst job!" ā Sanaz Afshar, California
Course content
Bar & Columns Charts
08:50
Histograms & Pareto Charts
05:59
Line Charts & Trendlines
05:17
Area Charts
04:42
Pies, Donuts & Race Tracks
12:04
Scatter Plots
07:30
Bubble Charts
06:36
Box & Whisker Charts
06:06
Tree Maps & Sunburst Charts
06:36
Waterfall Charts
03:17
Funnel Charts
03:42
Radar Charts
07:57
Stock Charts
07:18
Heat Maps
04:42
Surface & Contour Charts
07:35
Geo-Spatial Maps with Power Map
05:29
Basic Combo Charts
07:57
Sparklines
02:08
Setting Expectations
01:40
Demo: Custom Image Overlay Charts
06:01
Demo: Adding Binary Values to Highlight Date Ranges
05:02
Demo: Automation with OFFSET, COUNTA & Named Ranges Preview
07:08
Demo: Adding Scroll & Zoom Functionality with Form Controls
12:31
Demo: Animating Changes Over Time
14:20
Demo: Building a Dynamic Dashboard (Part 1)
16:10
Demo: Building a Dynamic Dashboard (Part 2)
12:09
Demo: Value-Based Dynamic Formatting
10:10
Demo: Dynamically Highlighting a Data Series
10:27
Demo: Building a Custom Pacing Chart
10:23
Demo: Designing a Custom Gauge Chart
09:58
Demo: Visualizing a Percentage Using Array Functions
07:16