Microsoft Excel: Data Visualization w/ Excel Charts & Graphs
4.8 (304 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,373 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel: Data Visualization w/ Excel Charts & Graphs to your Wishlist.

Add to Wishlist

Microsoft Excel: Data Visualization w/ Excel Charts & Graphs

Master 20+ Excel charts & graphs in Microsoft Excel 2016 with hands-on demos from a best-selling Excel instructor
Bestselling
4.8 (304 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,373 students enrolled
Created by Chris Dutton
Last updated 7/2017
English
English
Current price: $10 Original price: $175 Discount: 94% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 18 Articles
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 20+ downloadable PDF handouts, course quizzes, and 30+ hands-on Excel demos
  • A step-by-step, 100% comprehensive guide to visualizing data using charts & graphs in Excel
  • A deep understanding of WHEN, WHY, and HOW to use 20+ chart types in Excel 2016
  • Exclusive data visualization tips, tricks, and best practices from an award-winning analytics expert
  • Unique, custom content that you won't find in ANY other course
View Curriculum
Requirements
  • Microsoft Excel, ideally 2016 for PC (some charts are not available in earlier versions of Excel)
  • Mac users are welcome, but note that the user experience will be significantly different across platforms
Description

*** Course includes 20+ free PDF downloads and 30+ hands-on Excel projects and advanced data visualization demos ***

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
  • 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. You literally can't lose.

Who is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
59 Lectures
04:36:20
+
Before We Dive In
2 Lectures 02:25

Bonus Homework Exercises
00:22
+
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. 

Preview 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.

The 3 Key Questions
01:49
+
Customizing Charts in Excel
5 Lectures 19:58
Setting Expectations
01:02

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

Chart Elements, Layouts, Colors & 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. 

Chart Formatting Options
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

Chart Customization
5 questions
+
Mastering Basic Charts & Graphs
34 Lectures 01:59:53

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.

Bar & Columns Charts
08:49

HOMEWORK: Bar & Column Charts
00:19

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.

Histograms & Pareto Charts
05:58

HOMEWORK: Histograms & Pareto Charts
00:17

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.

Line Charts & Trendlines
05:16

HOMEWORK: Line Charts & Trendlines
00:25

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.

Area Charts
04:41

HOMEWORK: Area Charts
00:18

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.

Pies, Donuts & Race Tracks
12:04

HOMEWORK: Pies, Donuts & Race Tracks
00:29

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.

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.

Bubble Charts
06:36

HOMEWORK: Scatter Plots & Bubble Charts
00:32

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.

Box & Whisker Charts
06:05

HOMEWORK: Box & Whisker Charts
00:28

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

Preview 06:36

HOMEWORK: Tree Maps & Sunburst Charts
00:22

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.

Waterfall Charts
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.

Funnel Charts
03:42

HOMEWORK: Waterfall & Funnel Charts
00:32

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:26

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.

Stock Charts
07:18

HOMEWORK: Stock Charts
00:17

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.

Heat Maps
04:41

HOMEWORK: Heat Maps
00:26

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.

Surface & 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.

Geo-Spatial Maps with Power Map
05:28

HOMEWORK: Power Map
00:16

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.

Basic Combo Charts
07:57

HOMEWORK: Combo Charts
00:25

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

Sparklines
02:07

HOMEWORK: Sparklines
00:18

Basic Chart Types
10 questions
+
Next-Level Data Visualization Exercises
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: 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: Adding Binary Values to Highlight Date Ranges
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 with 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: Animating 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 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: Value-Based Dynamic Formatting
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.

Preview 10:26

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

DEMO: Building a Custom 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.

DEMO: Designing a Custom Gauge Chart
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 a Percentage Using Array Functions
07:16

Advanced Data Visualization Techniques
4 questions
+
Wrapping Up
2 Lectures 03:02
Additional Resources & Next Steps
02:38

Bonus Lecture: More from Excel Maven
00:24
About the Instructor
Chris Dutton
4.7 Average rating
2,080 Reviews
10,803 Students
3 Courses
Best-selling Udemy Instructor & Founder, Excel Maven

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling Udemy instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. 

He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 10,000+ students in more than 130 countries. He has developed award-winning data analytics and visualization tools, which have been featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Current Udemy courses include Advanced Excel Formulas & Functions, Data Visualization with Excel Charts & Graphs, and Data Analysis with Excel Pivot Tables.