Главная
Study mode:
on
1
) Topics for video
2
) When to visualize with a Chart or a Table
3
): Effective Data Visualization makes our analysis easier for others to “see” and understand
4
) Edward R. Tufte: Data Ink Ration Rule and “No Chart Junk” Rule
5
) Data Visualization Golden Rule: No Extraneous Elements in Table or Chart
6
) Tables Vs. Charts: Tables show Exact Values and allow Exact Comparisons, Charts show Relative Comparisons
7
) Tables are good when the units or magnitudes are different for the numbers
8
) Table Design Principles
9
) Example 1 for implementing Table Design Principles for small table with “less than minimal formatting”
10
) Remove all formatting with “Eraser” button: Home Ribbon Tab, Edit group, Clear Formats. Keyboard: Alt, H, E, F or Alt, E, A, F
11
) Borders and Fill and Font Color
12
) Number Formatting for currency when the unit is implied in Field Name (Header)
13
) How to present Percentages without Percent Number Format: Times 100 and then Paste Special Values.
14
) Example 2 for implementing Table Design Principles for small table with “minimal formatting”
15
) Example 2 for implementing Table Design Principles for big table, where we shade every other column
16
) Custom Number Formatting for showing numbers in millions
17
) Overview of Charts
18
) Terms that Excel Charts use for numbers and categories. Numbers = Series. Categories = labels or criteria.
19
) Knowing when to use and how to create Column and Bar Charts
20
) Knowing when to use and how to create “Stacked Column or Bar Chart” and “Clustered column or Bar Chart”
21
) Line Charts
22
) Custom Number Formatting for showing numbers in thousands
23
) Look at Select Dialog Box to change range of cells that Chart points to for numbers and category labels.
24
) X-Y Scatter Charts
25
) Bubble Charts
26
) Conditional Formatting to create heat Map
27
) Using Excel 2016, see a basic Geographical Information System example that involves taking zip code and population data and plotting it on a map using the 3-D Mapping tool
28
) Summary and Conclusion
Description:
Explore essential guidelines for visualizing data through tables and charts in Excel in this comprehensive 42-minute tutorial. Learn when to use tables versus charts, understand effective data visualization principles, and master table design techniques. Discover how to create and customize various chart types, including column, bar, line, scatter, and bubble charts. Practice implementing table design principles with examples of minimal and advanced formatting. Gain insights into custom number formatting, conditional formatting for heat maps, and using Excel's 3-D Mapping tool for geographical data visualization. Download accompanying files to follow along and enhance your Excel skills for business analytics and data presentation.

Basic Excel Business Analytics - Visualizing Data: Table & Chart Guidelines

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Visualization
0:00 / 0:00
1 of 28

) Topics for video