Download Zipped Folder with All Files: https://excelisfun.net/files/11-M365ExcelClassVideoFiles.zip
Course taught by Excel MVP and Highline College Professor, Mike Girvin. Course is Microsoft 365 Excel Complete Story.
This video covers the basics of visualizing data, then shows how to create five different types of Dashboards.
Topics in video:
1. (00:00) Introduction
2. (00:21) Topics
3. (01:06) Why Visualize? Table or Visualization?
4. (03:44) Edward R. Tufte and High Data/Ink Ratio Rule and “No Chart Junk Rule”
5. (05:56) Tables Formatting Rules
6. (12:03) Conditional Formatting
7. (15:41) Column and Bar Charts to compare differences across categories
8. (24:00) Cross Tab Chart: Clustered Column / Bar & Stacked Column / Bar
9. (27:07) Line Chart: 3 examples
10. (29:41) Line Chart and IF Function for line chart that shows revenue and emphasizes promotions for company.
11. (35:34) X-Y Scatter Chart: Relationship Between Two Numbers
12. (37:00) Excel Comprehensive Dashboard example with PivotTables and Charts. Print Setup to allow printing.
13. (39:24) PivotTable Custom Style
14. (53:41) Power BI Comprehensive Dashboard example with Power Query, Data Modeling, Time Dimension Table, DAX Formulas and Publishing and Sharing Online.
15. (01:17:33) Power Query to take data from multiple worksheets in multiple Excel files and transform it into a single table. Learn how to use Excel.CurrentWorkbook function, The Merge feature to lookup prices, and the Add Column / From Number / Standard feature to automatically generate Calculated Custom Columns.
16. (01:32:22) Array Formula Dashboard Tips: Conditional Formatting and Dynamic Charts
17. (01:35:45) PivotTable Dashboard Tips: PivotTable to create Dynamic Dashboard Title
18. (01:36:49) Import Excel Power Query query into Power BI Desktop
19. (01:38:40) Power BI Desktop Dashboard Tips: Formatting Date Slicer, Invert Picture, Conditional Formatting
20. (01:40:25) Add New File To Folder and Update Three Dashboards: Array Formula, PivotTable and Power BI
21. (01:41:24) Summary and Conclusions
22. (01:41:53) Closing and Video Links
Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/ . Artist: http://audionautix.com/