Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards

Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards

ExcelIsFun via YouTube Direct link

) Line Chart and IF Function for line chart that shows revenue and emphasizes promotions for company.

9 of 13

9 of 13

) Line Chart and IF Function for line chart that shows revenue and emphasizes promotions for company.

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. 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.