Download file from “Highline BI 348 Class” section: https://people.highline.edu/mgirvin/excelisfun.htm

Learn the basic Guidelines for Visualizing Tables & Charts:

1) (00:13) Topics for video

2) (00:41) When to visualize with a Chart or a Table

3) (02:35): Effective Data Visualization makes our analysis easier for others to “see” and understand

4) (04:05) Edward R. Tufte: Data Ink Ration Rule and “No Chart Junk” Rule

5) (04:49) Data Visualization Golden Rule: No Extraneous Elements in Table or Chart

6) (07:25) Tables Vs. Charts: Tables show Exact Values and allow Exact Comparisons, Charts show Relative Comparisons

7) (08:16) Tables are good when the units or magnitudes are different for the numbers

8) (08:47) Table Design Principles

9) (12:30) Example 1 for implementing Table Design Principles for small table with “less than minimal formatting”

10) (12:45) Remove all formatting with “Eraser” button: Home Ribbon Tab, Edit group, Clear Formats. Keyboard: Alt, H, E, F or Alt, E, A, F

11) (13:48) Borders and Fill and Font Color

12) (14:02) Number Formatting for currency when the unit is implied in Field Name (Header)

13) (14:30) How to present Percentages without Percent Number Format: Times 100 and then Paste Special Values.

14) (16:51) Example 2 for implementing Table Design Principles for small table with “minimal formatting”

15) (17:35) Example 2 for implementing Table Design Principles for big table, where we shade every other column

16) (18:09) Custom Number Formatting for showing numbers in millions

17) (21:27) Overview of Charts

18) (23:12) Terms that Excel Charts use for numbers and categories. Numbers = Series. Categories = labels or criteria.

19) (24:12) Knowing when to use and how to create Column and Bar Charts

20) (27:06) Knowing when to use and how to create “Stacked Column or Bar Chart” and “Clustered column or Bar Chart”

21) (29:55) Line Charts

22) (31:00) Custom Number Formatting for showing numbers in thousands

23) (32:53) Look at Select Dialog Box to change range of cells that Chart points to for numbers and category labels.

24) (33:21) X-Y Scatter Charts

25) (35:15) Bubble Charts

26) (37:39) Conditional Formatting to create heat Map

27) (38:42) 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) (41:00) Summary and Conclusion

Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.