Completed
) Comprehensive Dashboard example with PivotTables and Charts. Print Setup to allow printing.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction to topics, downloading files and visualizing examples in video.
- 2 ) Why Visualize? Table or Visualization?
- 3 ) Edward R. Tufte and High Data/Ink Ratio Rule and “No Chart Junk Rule”
- 4 ) Tables Formatting Rules
- 5 ) Conditional Formatting
- 6 ) Column and Bar Charts
- 7 ) Cross Tab Chart: Clustered Column / Bar & Stacked Column / Bar
- 8 ) Line Chart: 1 Number
- 9 ) Line Chart and IF Function for line chart that shows revenue and emphasizes promotions for company.
- 10 ) X-Y Scatter Chart: 2 Numbers
- 11 ) Comprehensive Dashboard example with PivotTables and Charts. Print Setup to allow printing.
- 12 ) PivotTable Custom Style
- 13 ) Summary
