Lynda - Excel Workshop - Building a Dynamic Heat Map
File List
- Exercice Files/Ex_Files_Excel_HeatMaps.zip 25.6 MB
- 05. Building a Basic Heat Map/05_02-COUNTIFS.mp4 19.1 MB
- 04. Conditional Statements and Logical Operators/04_02-Accident type.mp4 18.0 MB
- 04. Conditional Statements and Logical Operators/04_01-True Season.mp4 17.7 MB
- 06. Adding Dynamic Filters to the Map/06_03-SEASON filter.mp4 17.2 MB
- 03. Date and Time Functions/03_04-VLOOKUP.mp4 16.5 MB
- 03. Date and Time Functions/03_05-EOMONTH.mp4 15.1 MB
- 05. Building a Basic Heat Map/05_01-Heat map framework.mp4 15.0 MB
- 03. Date and Time Functions/03_02-Categorization.mp4 14.4 MB
- 03. Date and Time Functions/03_06-YEARFRAC.mp4 13.8 MB
- 06. Adding Dynamic Filters to the Map/06_02-Accident type COUNTIFS.mp4 10.6 MB
- 07. Creating FormulaBased Formatting Rules/07_02-Formatting with ROW and COLUMN functions.mp4 9.4 MB
- 04. Conditional Statements and Logical Operators/04_03-Using ISBLANK.mp4 9.4 MB
- 03. Date and Time Functions/03_03-WEEKDAY.mp4 9.2 MB
- 03. Date and Time Functions/03_01-DATEVALUE.mp4 8.7 MB
- 02. Project Setup/02_02-Getting familiar with the data.mp4 7.7 MB
- 05. Building a Basic Heat Map/05_05-Quick QA Identifying and eliminating inaccurate data.mp4 7.7 MB
- 07. Creating FormulaBased Formatting Rules/07_01-Using the NOW and TODAY functions.mp4 7.5 MB
- 06. Adding Dynamic Filters to the Map/06_01-Data validation.mp4 6.8 MB
- 05. Building a Basic Heat Map/05_03-Color scale formatting.mp4 6.7 MB
- 08. Wrapping Up/08_01-Adding the finishing touches.mp4 6.5 MB
- 01. Introduction/01_01-Welcome.mp4 5.5 MB
- 05. Building a Basic Heat Map/05_04-Aggregate data SUM.mp4 4.9 MB
- 08. Wrapping Up/08_02-Accident analytics.mp4 4.8 MB
- 07. Creating FormulaBased Formatting Rules/07_03-Highlighting a current moment in time.mp4 4.6 MB
- 02. Project Setup/02_03-Project goal and creating a roadmap.mp4 3.8 MB
- 02. Project Setup/02_01-Downloading the dataset.mp4 3.4 MB
- 08. Wrapping Up/08_03-Extension Power Map.mp4 2.0 MB
- 09. Conclusion/09_01-Next steps.mp4 1.4 MB
- 01. Introduction/01_02-What you should know before watching this course.mp4 891.4 KB
- 01. Introduction/01_03-Using the exercise files.mp4 677.2 KB
Download Torrent
Related Resources
Copyright Infringement
If the content above is not authorized, please contact us via activebusinesscommunication[AT]gmail.com. Remember to include the full url in your complaint.