Data Visualization in Excel
Estimated Time Commitment: 4 Hours
You will learn fundamental principles that underlie data visualizations. Using those principles, you will identify use cases for different charts and learn how to build those charts in Excel. You will then use your knowledge of different charts to identify alternative charts that are better suited for directing attention.
Upon successful completion, you will be able to:
Examine fundamental principles that underly data visualizations
Identify use cases for different charts, and then build those charts
Critique commonly used charts and identify better alternatives
Introduction Video
Introduction to the Skill
Glossary
Why Visualize Data
Visual Perception Principles
Data Visualization Building Blocks
Knowledge Check 1
Basic Chart Data
Scatter Plots
Bar Charts
Box and Whisker Plots
Line Charts
Maps
Knowledge Check 2
Financial Chart Data
Waterfall Charts
Candlestick Charts
Treemaps and Sunburst Charts
Sparklines and Facets
Charts to Use Sparingly
Knowledge Check 3
Instructions and Materials
Exercise Part 1
Exercise Part 2
Debriefing
Concluding Video
Final Quiz
Survey Instructions
Feedback Survey
Survey Verification
Next Steps