Completed
) Conditional Formatting
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
