Главная
Study mode:
on
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
Description:
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.

Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Business Intelligence #Data Science #Data Analysis #Data Visualization #Spreadsheets #PivotTables
0:00 / 0:00
1 of 13

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