Completed
): Effective Data Visualization makes our analysis easier for others to “see” and understand
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Basic Excel Business Analytics - Visualizing Data: Table & Chart Guidelines
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Topics for video
- 2 ) When to visualize with a Chart or a Table
- 3 ): Effective Data Visualization makes our analysis easier for others to “see” and understand
- 4 ) Edward R. Tufte: Data Ink Ration Rule and “No Chart Junk” Rule
- 5 ) Data Visualization Golden Rule: No Extraneous Elements in Table or Chart
- 6 ) Tables Vs. Charts: Tables show Exact Values and allow Exact Comparisons, Charts show Relative Comparisons
- 7 ) Tables are good when the units or magnitudes are different for the numbers
- 8 ) Table Design Principles
- 9 ) Example 1 for implementing Table Design Principles for small table with “less than minimal formatting”
- 10 ) Remove all formatting with “Eraser” button: Home Ribbon Tab, Edit group, Clear Formats. Keyboard: Alt, H, E, F or Alt, E, A, F
- 11 ) Borders and Fill and Font Color
- 12 ) Number Formatting for currency when the unit is implied in Field Name (Header)
- 13 ) How to present Percentages without Percent Number Format: Times 100 and then Paste Special Values.
- 14 ) Example 2 for implementing Table Design Principles for small table with “minimal formatting”
- 15 ) Example 2 for implementing Table Design Principles for big table, where we shade every other column
- 16 ) Custom Number Formatting for showing numbers in millions
- 17 ) Overview of Charts
- 18 ) Terms that Excel Charts use for numbers and categories. Numbers = Series. Categories = labels or criteria.
- 19 ) Knowing when to use and how to create Column and Bar Charts
- 20 ) Knowing when to use and how to create “Stacked Column or Bar Chart” and “Clustered column or Bar Chart”
- 21 ) Line Charts
- 22 ) Custom Number Formatting for showing numbers in thousands
- 23 ) Look at Select Dialog Box to change range of cells that Chart points to for numbers and category labels.
- 24 ) X-Y Scatter Charts
- 25 ) Bubble Charts
- 26 ) Conditional Formatting to create heat Map
- 27 ) Using Excel 2016, see a basic Geographical Information System example that involves taking zip code and population data and plotting it on a map using the 3-D Mapping tool
- 28 ) Summary and Conclusion
