Excel Essential: Storytelling through Visualization and Analytic

Storytelling with Data Design Principles Data Visualization Tips Advanced Conditional Formatting
Adding interactivity to your Dashboard

Responsible	Administrator
Last Update	10/31/2022
Completion Time	7 hours 19 minutes
Members	15

Basic, Intermediate Beginner Newest

Introduction
- Introduction
  
  Preview
- Class Instructions
Data Visualization and Charts Best Practices
- Download Workbook Files
- Data Visualization
- Dos and Don't of Charts
- Excel Formatting Ribbons
- Topic End Quizzes
  
  10 xp
Chart Types
- Chart Types Part 1
- Chart Types Part 2
- Chart Types Part 3
Basic Chart Making
- Line Charts
- Bar Chart
- Pie Chart & Stacked Bar
- Scatter Part-1
- Scatter Part-2
- Pareto Part 1
- Pareto Part 2
- Topic End Quizzes
  
  10 xp
Advanced Charts
- Download Workbook Files
- Box & Whisker
- Tree Maps
- Sunburst
- Waterfall
- Funnel Chart
- Stock Chart
- Radar Chart
- Heat Map
Case Study 1: Finance Charts and Graphs
- Charts and Graphs Part-1
- Charts and Graphs Part-2
- Charts and Graphs Part 3
Case Study 2: Stacked Columns Targets
- Download Workbook Files
- Target Vs Actual Part 1
- Target Vs Actual Part 2
- 4 Week 4 FFNP Valuation 4
- Finance for Non Finance non finance valution 5
- Finance for Non Finance valution 6
- Finance for Non Finance valution 7
- Finance for Non Finance valution 8
- Finance for Non Finance valution 9
Case Study 3: Breakeven (Line & Scatter)
- Breakeven Part 1
- Breakeven Part 2
Case Study 4: Dropdown Boxes and Charts
- Dropdown Part 1
- Dropdown Part 2
Case Study 5: Gauge Charts
- Download Workbook Files
- Gauge Chart Part 1
- Gauge Chart Part 2
- Gauge Chart Part 3
- Gauge Chart Part 4
- Gauge Chart Part 5
- Topic End Quizzes
  
  10 xp
Bullet Charts
- Bullet Chart
- Highlight Ranges
Final Assessment and Feedback Form
- Qualified Assessments Type I
- Qualified Assessments Type II
- Course Completion
- Share your Feedback