E-DAB 05: Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards

This video teaches about how to visualize in Excel with Tables, Conditional Formatting, Column and Bar Charts, Cross Tab Char (Clustered Column / Bar & Stacked Column / Bar), Line Chart, X Y Scatter Chart and Dashboards. Comprehensive Dashboard Example at end.
This class : Data Analysis & Business Intelligence Made Easy with Excel Power Tools - Excel Data Analysis Basics = E-DAB Class – Sponsored by YouTube and taught by Mike Girvin, Highline College Instructor, Microsoft Excel MVP and founder of the excelisfun channel at YouTube. This is a free educational resource for people how want to learn about the Basics of Data Analysis and Business Intelligence using Microsoft Power Tools such as, PivotTables, Power Query, Power Pivot, Power BI Desktop and more.

Topics:
1. (00:15) Introduction to topics, downloading files and visualizing examples in video.
2. (01:48) Why Visualize? Table or Visualization?
3. (03:47) Edward R. Tufte and High Data/Ink Ratio Rule and “No Chart Junk Rule”
4. (05:57) Tables Formatting Rules
5. (12:05) Conditional Formatting
6. (15:45) Column and Bar Charts
7. (24:04) Cross Tab Chart: Clustered Column / Bar & Stacked Column / Bar
8. (27:10) Line Chart: 1 Number
9. (29:47) Line Chart and IF Function for line chart that shows revenue and emphasizes promotions for company.
10. (35:40) X-Y Scatter Chart: 2 Numbers
11. (37:02) Comprehensive Dashboard example with PivotTables and Charts. Print Setup to allow printing.
12. (39:26) PivotTable Custom Style
13. (53:44) Summary

Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!

[excelisfun]

Topics:
1. (00:15) Introduction to topics, downloading files and visualizing examples in video.
2. (01:48) Why Visualize? Table or Visualization?
3. (03:47) Edward R. Tufte and High Data/Ink Ratio Rule and “No Chart Junk Rule”
4. (05:57) Tables Formatting Rules
5. (12:05) Conditional Formatting
6. (15:45) Column and Bar Charts
7. (24:04) Cross Tab Chart: Clustered Column / Bar & Stacked Column / Bar
8. (27:10) Line Chart: 1 Number
9. (29:47) Line Chart and IF Function for line chart that shows revenue and emphasizes promotions for company.
10. (35:40) X-Y Scatter Chart: 2 Numbers
11. (37:02) Comprehensive Dashboard example with PivotTables and Charts. Print Setup to allow printing.
12. (39:26) PivotTable Custom Style
13. (53:44) Summary

[rodrigocustodio]

The delivery, the energy in the voice, the strategy in teaching, the ability of breaking down complex subjects into easily understandable topics, makes Mike, the best Excel guru in the world.

[jishantpatel]

If there is any Nobel prize for Excel then Professor Mike deserves it.

[estherlamikanra]

You're so amazing. I can't believe I'm actually enjoying learning this

[anasksaiby]

The best Youtube video ever made .... thanks a lot Mike! 💝

[AlexDonnett]

That " alt" trick for moving stuff was gold

[accountantzone]

Honestly big fan of you because of your teaching methods. Great all courses. Great work 👍

[Ahdhsjsshhsj]

This guy is an excel gem that must be protected at all cost. thanks alot man

[dantemartinez]

Excellent job on this course and everything else. Thank you so much for putting this out for free!

[mnsoyan]

So much pleasure learning Excel with you. Thanks so much Mike! 👍👍

[shubhampawar]

love the topic of line charts with different colours ❤️😊

[msantosh]

Learning never END when Mike is around. Thanks for adding one more video to enthusiastic learners. 😊

[msantosh]

So much of information to grab in this 54:41 minutes of education video, Only an expert tutor like Mike can deliver such video so excited to know more on data visualization. Excel is fun with Mike Girvin❤❤❤👍

[MT]

Amazing video! Really like how neat the dashboard looks and the tricks to present the promotions is really effective! Thank you for another epic resource :)

[RobMichaels]

I don't think Edward Tufte himself could have showed how to avoid chart junk better than your excellent video! Thanks.

[camiloperon]

Professor Mike, you are amazing! I am so glad for this E-DAB series, because you make everything enjoyable and easy to understand!

[dexuus]

"Everything you need to know in Written form about visualising data" 🤔 I love it.

[excelisfun]

Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!

[ginger]

Unbelievable! After so long, I just notice that your video has subtitle!!! OMG, that really helps a lot, especially for people like me who are not native English speaker. thanks！！！

[knikl]

Appreciate the time you take to post these videos and especially the thorough PDF notes. Thank you!