excelisfun | Visualizing Data and Building Dashboards in Excel & Power BI - 365 MECS 11 @excelisfun | Uploaded 1 year ago | Updated 1 day ago
Download Zipped Folder with All Files: https://excelisfun.net/files/11-M365ExcelClassVideoFiles.zip
This video covers the basics of visualizing data, then shows how to create five different types of Dashboards in Excel and Power BI.
This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
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.Workbook function, The Merge feature to lookup prices, and the Add Column / From Number / Standard feature to automatically generate Calculated Custom Columns.
16. Power Query to create custom columns (calculated columns) for revenue, COGS and Gross Profit and avoid having to do it in the worksheet.
17. (01:32:22) Array Formula Dashboard Tips: Conditional Formatting and Dynamic Charts
18. (01:35:45) PivotTable Dashboard Tips: PivotTable to create Dynamic Dashboard Title
19. (01:36:49) Import Excel Power Query query into Power BI Desktop
20. (01:38:40) Power BI Desktop Dashboard Tips: Formatting Date Slicer, Invert Picture, Conditional Formatting
21. (01:40:25) Add New File To Folder and Update Three Dashboards: Array Formula, PivotTable and Power BI
22. (01:41:24) Summary and Conclusions
23. (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/
#MikeGirvin
#excelisfun
#MikeexcelisfunGirvin
#Microsoft365Excel
#MECS11
#Microsoft365ExcelCompleteStory
#Dashboards
#HowtobuilddashboardsinExcel
#HowtobuilddashboardsinPowerBI
#ExcelDashboards
#PowerBIDashboards
#VisualizingData
#Thevisualdisplayofquantitativeinformation
#BeautifulEvidence
#PowerQueryDashboards
#PowerPivotDashboards
#ImportMultipleExcelFiles
#ImportmultipleWorksheetsofData
#ConditionalFormatting
#FreeClass
#FreePowerBIClass
Download Zipped Folder with All Files: https://excelisfun.net/files/11-M365ExcelClassVideoFiles.zip
This video covers the basics of visualizing data, then shows how to create five different types of Dashboards in Excel and Power BI.
This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
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.Workbook function, The Merge feature to lookup prices, and the Add Column / From Number / Standard feature to automatically generate Calculated Custom Columns.
16. Power Query to create custom columns (calculated columns) for revenue, COGS and Gross Profit and avoid having to do it in the worksheet.
17. (01:32:22) Array Formula Dashboard Tips: Conditional Formatting and Dynamic Charts
18. (01:35:45) PivotTable Dashboard Tips: PivotTable to create Dynamic Dashboard Title
19. (01:36:49) Import Excel Power Query query into Power BI Desktop
20. (01:38:40) Power BI Desktop Dashboard Tips: Formatting Date Slicer, Invert Picture, Conditional Formatting
21. (01:40:25) Add New File To Folder and Update Three Dashboards: Array Formula, PivotTable and Power BI
22. (01:41:24) Summary and Conclusions
23. (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/
#MikeGirvin
#excelisfun
#MikeexcelisfunGirvin
#Microsoft365Excel
#MECS11
#Microsoft365ExcelCompleteStory
#Dashboards
#HowtobuilddashboardsinExcel
#HowtobuilddashboardsinPowerBI
#ExcelDashboards
#PowerBIDashboards
#VisualizingData
#Thevisualdisplayofquantitativeinformation
#BeautifulEvidence
#PowerQueryDashboards
#PowerPivotDashboards
#ImportMultipleExcelFiles
#ImportmultipleWorksheetsofData
#ConditionalFormatting
#FreeClass
#FreePowerBIClass
