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