Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards

This beginner course teaches data visualization in Microsoft Excel through tables, conditional formatting, column and bar charts, line charts, XY scatterplots, and a comprehensive PivotTable dashboard example.

Syllabus

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