1.Understand why data is created into charts
2.Know when and where to use the charts and
graphs
3.Be aware of areas of misrepresentation
4.Create powerful, useful, and summarized
visual information from large amount of data
5.Understand the needs of dashboards for
management reporting
6.Present data into effective communications for
Management
Course content
Sections:3
•
Activities:0
•
Resources:31
Storytelling Through Visualization
1.1. Excel Storytelling Through Visualization
1.2. ESSV Data Visualization
1.3. Preparing Effective Spreadsheet and Table Visuals
1.4. Visualization Dos and Don'ts Part-1
1.5. Visualization Dos and Don'ts Part 2
1.6. Visualization Dos and Don'ts Part 3
1.7. Visualization Dos and Don'ts Part - 4
1.8. Visualization Dos and Don'ts Summary
1.9. Understanding Chart Types
1.10. Chart Ribbon and Chart Components
1.11. Summary: Storytelling Through Visualization
* Exercise Workbook Building Basic Chart *
2.1. Building Line Chart
2.2. Building Bar Charts
2.3. Building Pie Chart & Stacked Bar Chart
2.4. Building a Scatter Plot Part-1
2.5. Building a Scatter Plot Part-2
* Exercise Workbook Complete Building Basic Chart *
* Exercise Workbook Other Chart *
3.1. Building a Box & Whisker Chart
3.2. Building a Tree Map
3.3. Building a Sunburst Chart
3.4. Building a Waterfall Chart
3.5. Building a Funnel Chart
3.6. Building a Stock Chart
3.7. Building a Radar Chart
3.8. Building a Heat Map
3.9. Building Area Charts and Compare Line Chart
3.10. Creating Save as Template for Chart Uses
* Exercise Workbook Complete Building Other Chart *
