Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. - Basic Excel Business Analytics #43: Visualizing Data: Table & Chart Guidelines

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.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.