Microsoft Excel - Data Visualization, Excel Charts & Graphs
4.6 (12,285 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
63,138 students enrolled

Microsoft Excel - Data Visualization, Excel Charts & Graphs

Master 20+ Excel charts & graphs and build custom visuals with a best-selling Excel instructor (Excel 2016 - Excel 2019)
Bestseller
4.6 (12,285 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
63,138 students enrolled
Last updated 6/2020
English
English [Auto], French [Auto], 6 more
  • German [Auto]
  • Indonesian [Auto]
  • Italian [Auto]
  • Portuguese [Auto]
  • Spanish [Auto]
  • Thai [Auto]
Current price: $113.99 Original price: $174.99 Discount: 35% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 19 articles
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Understand WHEN, WHY, and HOW to use 20+ chart types in Excel 2016+
  • Learn advanced Excel tools like automated dashboards, scrolling charts, dynamic formats, and more
  • Master unique tips, tools and case studies that you won't find in ANY other Excel course, guaranteed
  • Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor
  • Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support
  • Build 10+ Excel projects designed to take your data visualization skills to the next level
Requirements
  • Microsoft Excel, ideally 2016+ or Office 365 for PC (some charts are not available in other versions of Excel)
  • Mac users are welcome, but note that the user experience will be significantly different across platforms
Description

Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Data Visualization course:

"Absolutely great stuff. I really enjoyed it! Chris is truly a Excel guru. I strongly recommend this course to all users looking to improve their skills with Excel charts & graphs."

-Nirav M.

"Excellent from start to finish! I picked up a bunch of Excel data visualization tips that will be useful in the workplace, including some very cool advanced Excel visuals and custom charts & graphs. Loved all of it, and hope I can learn more from this wonderful individual!"

-Robert C.

"At the first part I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then at the second part I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other Excel and data visualization courses!"

-Judit B.

__________

FULL COURSE DESCRIPTION:

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 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 Excel chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and Excel exercises every step of the way.

__________

We'll kick things off by exploring each of the 20+ charts & graphs introduced in Excel 2016, including: 

  • Bar & Column charts

  • Histograms & Pareto charts (Office 365, Excel 2016 or Excel 2019)

  • Line charts & trend lines 

  • Area charts

  • Pies & Donuts

  • Scatter plots & Bubble charts

  • Box & Whisker charts (Office 365, Excel 2016 or Excel 2019)

  • Tree Maps & Sunbursts (Office 365, Excel 2016 or Excel 2019)

  • Waterfall & Funnel charts (Office 365, Excel 2016 or Excel 2019)

  • 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 Excel YouTube channels; 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.

We'll cover advanced Excel data viz topics that you won't find anywhere else, including:

  • Custom image overlay charts

  • Automation with named ranges and OFFSET/COUNTA functions

  • Scroll & Zoom functionality with Excel form controls

  • Animated charts to visualize changes over time

  • Dynamic, custom Excel dashboards

  • Value-based chart formatting

  • Custom gauge charts & pacing charts

  • Grid visuals using Excel array formulas

Whether you're looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your Excel data visualization game in a major way, this course is for you.

See you there!

-Chris (Founder, Maven Analytics)

__________

Most students in this course enroll in our full EXCEL LEARNING PATH, designed to help you build a deep, expert-level Excel skill set:

  1. Advanced Excel Formulas & Functions

  2. Data Visualization with Excel Charts & Graphs (you are here)

  3. Data Analysis with Excel PivotTables

  4. Excel Power Query, Power Pivot & DAX

  5. Excel Pro Tips for Power Users

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

*NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2016, Excel 2019 or Office 365.

Who this course is for:
  • Anyone looking to create beautiful and effective 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
  • Anyone looking to pursue a career in data analysis or business intelligence
Course content
Expand all 59 lectures 04:37:12
+ Getting Started
4 lectures 06:18
READ ME: Important Notes for New Students
01:54
DOWNLOAD: Course Resources
00:19
+ Data Visualization Best Practices
3 lectures 08:18

Data visualization is about creating clear, powerful narratives and striking a balance between design and function. This lecture reviews several key data visualization principles and demonstrates the "10-Second Rule" to test the effectiveness of a given chart or graph.

Preview 02:45

This lecture covers several examples of strong, weak, and just plain ugly data visualizations. Learn about the importance of using chart elements effectively, minimizing noise, and choosing the correct chart types. 

Good, Bad & Ugly Data Viz
03:44

This lecture reviews the three key questions that you should ask yourself when designing data visualizations, including what type of data are you working with, what you're trying to communicate, and who will be the end user consuming the information.

3 Key Questions for Effective Visualization
01:49
+ Excel Chart Formatting & Customization
4 lectures 18:56

This lecture serves as a quick review of chart customization in Excel 2016, including chart elements, layout options, colors and styles. 

Customizing Chart Elements, Layouts & Styles
06:20

This lecture reviews basic chart formatting options, including applying options in both the format ribbon and formatting pane as well as customizing individual chart elements. 

Configuring Chart Formats
05:27

This lecture reviews when and how to change chart types in Excel, and demonstrates several methods of adding a secondary chart axis to visualize multiple data series.

Changing Chart Types & Adding a Secondary Axis
03:03

This lecture demonstrates how to create and save new chart templates in Excel 2016.

Preview 04:06
Excel Chart Customization
5 questions
+ Mastering Basic Excel Charts & Graphs
34 lectures 01:59:42

This lecture reviews when, why, and how to use bar and column charts in Excel (basic, stacked, and clustered), including pro tips, sample data sets, and hands-on exercises in Excel 2016.

DEMO: Excel Bar & Columns Charts
08:49
HOMEWORK: Bar & Column Charts
00:21

This lecture reviews when, why, and how to use histograms and pareto charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

DEMO: Excel Histograms & Pareto Charts (Office 365/Excel 2016+)
05:58
HOMEWORK: Histograms & Pareto Charts
00:16

This lecture reviews when, why, and how to use line charts and trendlines (linear, logarithmic, polynomial, etc) in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

DEMO: Excel Line Charts & Trendlines
05:16
HOMEWORK: Line Charts & Trendlines
00:24

This lecture reviews when, why, and how to use area charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

DEMO: Excel Area Charts
04:41
HOMEWORK: Area Charts
00:24

This lecture reviews when, why, and how to use pie, donut, and custom race track charts and visualizations in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

DEMO: Excel Pie Charts, Donuts & Race Tracks
12:04
HOMEWORK: Pies, Donuts & Race Tracks
00:26

This lecture reviews when, why, and how to use scatter plots in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

DEMO: Excel Scatter Plots
07:30

This lecture reviews when, why, and how to use bubble charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

DEMO: Excel Bubble Charts
06:36
HOMEWORK: Scatter Plots & Bubble Charts
00:35

This lecture reviews when, why, and how to use box & whisker charts and graphs in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

DEMO: Excel Box & Whisker Charts (Office 365/Excel 2016+)
06:05
HOMEWORK: Box & Whisker Charts
00:24

Excel's Tree Map and Sunburst charts are ideal for visualizing hierarchical data that falls into natural groups and subgroups. In this demo, we'll explore movie titles and employee records to practice building and customizing our own tree maps and sunbursts.

Preview 06:36
HOMEWORK: Tree Maps & Sunburst Charts
00:20

This lecture reviews when, why, and how to use waterfall charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

DEMO: Excel Waterfall Charts (Office 365/Excel 2016+)
03:17

This lecture reviews when, why, and how to use funnel charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

DEMO: Excel Funnel Charts (Office 365/Excel 2016+)
03:42
HOMEWORK: Waterfall & Funnel Charts
00:31

This lecture reviews when, why, and how to use radar charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016. This lecture also covers the importance of normalizing data sets to create consistent scales and more effective visualizations.

Preview 07:56
HOMEWORK: Radar Charts
00:22

This lecture reviews when, why, and how to use stock charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

DEMO: Excel Stock Charts
07:18
HOMEWORK: Stock Charts
00:16

This lecture reviews when, why, and how to use cell-formatted heat maps in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

DEMO: Excel Heat Maps with Conditional Formatting
04:41
HOMEWORK: Heat Maps
00:25

This lecture reviews when, why, and how to use surface and contour charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

DEMO: Excel Surface & 3D Contour Charts
07:35
HOMEWORK: Surface & Contour Charts
00:20

This lecture serves as a brief introduction to Excel's Power Map tool, and reviews a sample exercise showcasing state-level geo-spatial mapping in Excel 2016.

DEMO: Geo-Spatial Mapping with Excel Power Map
05:28
HOMEWORK: Power Map
00:15

This lecture reviews when, why, and how to use combo charts in Excel, and reviews sample exercises showcasing combinations of line, column, and stacked area charts in Excel 2016.

DEMO: Common Excel Combo Charts
07:57
HOMEWORK: Combo Charts
00:23

This lecture reviews when, why, and how to use cell sparklines in Excel, including a hands-on demo in Excel 2016.

DEMO: Excel Sparklines
02:07
HOMEWORK: Sparklines
00:18
Basic Excel Chart Types
10 questions
+ Next-Level Demos
13 lectures 02:03:10
Setting Expectations
01:40

This Excel demo showcases how you can combine basic stacked column charts with custom graphics to create image overlay charts.

DEMO: Creating Custom Image Overlay Charts
06:01

This Excel demo showcases how to use binary values and stacked column charts to highlight specific dates or date ranges within a chart.

DEMO: Using Binary Values to Highlight Time Periods
05:02

This Excel demo showcases how to use OFFSET and COUNTA functions within named ranges to dynamically update charts as new data points are added.

Preview 07:08

This Excel demo showcases how to use scrollbar form controls, OFFSET functions, and named arrays to create charts that users can dynamically scroll and zoom.

DEMO: Adding Scroll & Zoom Functionality Using Form Controls
12:30

This Excel demo shows you how to create a dynamic source array using basic SUMIFS functions, and combine form controls with data validation lists to create charts that show animation over time. 

DEMO: Creating Interactive Area Charts to Show Changes Over Time
14:20

In this Excel demo, users will populate a sample dashboard using SUMIFS functions, data validation lists, custom conditional formatting rules, and combo charts.

DEMO: Building a Dynamic Excel Dashboard (Part 1)
16:10

This Excel demo builds on the previous dashboard example, and showcases how to create dynamic charts and graphs that can display different metrics based on user-selected values.

Preview 12:08

This Excel demo showcases how to create formula-based chart formatting rules to highlight data points based on underlying values.

DEMO: Dynamic Chart Formatting Based on Values
10:09

In this Excel demo, users will learn how to create charts and graphs that dynamically highlight specific data series based on user-selected values.

DEMO: Dynamically Highlighting Segments of Data
10:26

This Excel demo is all about using combo charts and creative formatting to design a custom pacing chart.  

DEMO: Building a Custom Excel Pacing Chart
10:22

In this Excel demo, we'll combine a donut chart with a scatter plot and incorporate some trigonometry functions to build a custom gauge & needle effect.

Preview 09:58

This Excel demo showcases how array functions and scatter plots can be used to build a custom percentage visualization built from 100 individual data markers.

DEMO: Visualizing Percentages Using Array Functions
07:16
Advanced Excel Data Visualization Techniques
4 questions
+ Wrapping Up
1 lecture 00:47
More from Maven Analytics
00:47