Completed
16. Array Formula Dashboard Tips: Conditional Formatting and Dynamic Charts
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Visualizing Data and Building Dashboards in Excel & Power BI
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction
- 2 2. Topics
- 3 3. Why Visualize? Table or Visualization?
- 4 4. Edward R. Tufte and High Data/Ink Ratio Rule and “No Chart Junk Rule”
- 5 5. Tables Formatting Rules
- 6 6. Conditional Formatting
- 7 7. Column and Bar Charts to compare differences across categories
- 8 8. Cross Tab Chart: Clustered Column / Bar & Stacked Column / Bar
- 9 9. Line Chart: 3 examples
- 10 10. Line Chart and IF Function for line chart that shows revenue and emphasizes promotions for company.
- 11 11. X-Y Scatter Chart: Relationship Between Two Numbers
- 12 12. Excel Comprehensive Dashboard example with PivotTables and Charts. Print Setup to allow printing.
- 13 13. PivotTable Custom Style
- 14 14. Power BI Comprehensive Dashboard example with Power Query, Data Modeling, Time Dimension Table, DAX Formulas and Publishing and Sharing Online.
- 15 15. 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 price…
- 16 16. Array Formula Dashboard Tips: Conditional Formatting and Dynamic Charts
- 17 17. PivotTable Dashboard Tips: PivotTable to create Dynamic Dashboard Title
- 18 18. Import Excel Power Query query into Power BI Desktop
- 19 19. Power BI Desktop Dashboard Tips: Formatting Date Slicer, Invert Picture, Conditional Formatting
- 20 20. Add New File To Folder and Update Three Dashboards: Array Formula, PivotTable and Power BI
- 21 21. Summary and Conclusions
- 22 22. Closing and Video Links