Learn to use Excel for data visualization. Explore the most useful chart and graph tools, including scatterplots, histograms, sparklines, 3D power maps, and geospatial heat maps.
Excel Data Visualization: Mastering 20+ Charts and Graphs
Overview
Syllabus
Introduction
- Part 1: Introduction
- Key principles and the 10-second rule
- The good, the bad, and the ugly
- The three key questions
- Setting expectations
- Chart elements, layouts, colors, and styles
- Chart formatting options
- Changing chart types and axis options
- Creating, modifying, and applying templates
- Bar and column charts
- Histograms and Pareto charts
- Line charts and trendlines
- Area charts
- Pies, donuts, and race tracks
- Scatter plots
- Bubble charts
- Box and whisker charts
- Tree maps and sunburst charts
- Waterfall charts
- Funnel charts
- Radar charts
- Stock charts
- Heat maps
- Surface and contour charts
- Geospatial maps (Power Map)
- Basic combo charts
- Sparklines
- Part 1: Conclusion
Taught by
Chris Dutton
Related Courses
-
Excel Data Visualization Part 1: Charts & Graphs
-
Excel Data Visualization - Guide to Charts and Dashboards
-
Microsoft Excel: Data Visualization w/ Excel Charts & Graphs
-
Data Visualization in Excel
5.0 -
Data Visualization and Dashboards with Excel and Cognos
-
Excel Data Visualization Part 2: Advanced Demos
