Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn how to effectively visualize data in Excel using tables, charts, conditional formatting, and dashboards in this comprehensive 55-minute tutorial. Explore the importance of data visualization, apply Edward R. Tufte's principles for high data-to-ink ratio, and master table formatting rules. Practice creating various chart types, including column, bar, cross tab, line, and X-Y scatter charts. Discover how to use conditional formatting to highlight important data points and create a comprehensive dashboard with PivotTables and charts. Gain practical skills in data analysis and business intelligence using Excel's powerful tools, with a focus on clear and impactful data presentation techniques.

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.