Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards

Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards

ExcelIsFun via YouTube Direct link

) Introduction to topics, downloading files and visualizing examples in video.

1 of 13

1 of 13

) Introduction to topics, downloading files and visualizing examples in video.

Class Central Classrooms beta

YouTube playlists 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. 1 ) Introduction to topics, downloading files and visualizing examples in video.
  2. 2 ) Why Visualize? Table or Visualization?
  3. 3 ) Edward R. Tufte and High Data/Ink Ratio Rule and “No Chart Junk Rule”
  4. 4 ) Tables Formatting Rules
  5. 5 ) Conditional Formatting
  6. 6 ) Column and Bar Charts
  7. 7 ) Cross Tab Chart: Clustered Column / Bar & Stacked Column / Bar
  8. 8 ) Line Chart: 1 Number
  9. 9 ) Line Chart and IF Function for line chart that shows revenue and emphasizes promotions for company.
  10. 10 ) X-Y Scatter Chart: 2 Numbers
  11. 11 ) Comprehensive Dashboard example with PivotTables and Charts. Print Setup to allow printing.
  12. 12 ) PivotTable Custom Style
  13. 13 ) Summary

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.