Basic Excel Business Analytics #43: Visualizing Data: Table & Chart Guidelines

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.

[ashishtiwari]

You are the best in excel.There is so much to learn from you.
Thanx for making these wonderful videos.

[mahamohan]

You are an excellent teacher. Many will love to be your students

[qianwu]

the 3D map graph is just amazing. First time learn this in Excel, thank you!!

[excelisfun]

@rob.j.maessen, Thanks for the correction: GEO-graphical Information System. I added annotations to each time I mentioned it in the videos. I depend on awesome Online Excel teammates like you to help me out with my mistakes. Thanks!

[Sonia-npte]

you make learning Fun! I really enjoyed watching this video and will most probably watch it again. Thank you for providing such valuable content in a clear, concise, and fun way. Looking forward to the rest of your videos.

[pankajarbia]

Really appreciate your effort for us very useful. please post more videos. Thank you so much.

[amyz.]

Michael, Your videos are amazing!Sincerely, Tingting

[r.j.maessen]

Michael,
Your video's are great, really great!
One small remark: GIS stands for GEO-graphical Information System
Regards,
Rob.

[HiseiTensi]

Amazing channel! U got 1 more sub from now on :-) Thanks for the great work u've done

[kaaa]

Thank you so much for your tutorial. I have a question on Combo chart:
We have dates, duration and charge. Date: horizontal axis, Duration: First data series (column) and Charge: second data series (line). In this data, sometimes the charges is null
How to create the chart but don’t show duration if the charges is null
Thank you so much.

[BeyonLimits]

The link to get the file does not seem to work. I wonder if you can help please.

[aamerakhan]

hey sir link for downloading the file has expired! can you please help

[bradleyroy]

you've had no issues with lost data in Excel 2016?