589689.xyz

Lynda - Excel Workshop - Building a Dynamic Heat Map

  • 收录时间:2018-04-12 20:31:58
  • 文件大小:295MB
  • 下载次数:105
  • 最近下载:2020-07-30 23:57:56
  • 磁力链接:
立即下载 复制链接

文件列表

  1. Exercice Files/Ex_Files_Excel_HeatMaps.zip 26MB
  2. 05. Building a Basic Heat Map/05_02-COUNTIFS.mp4 19MB
  3. 04. Conditional Statements and Logical Operators/04_02-Accident type.mp4 18MB
  4. 04. Conditional Statements and Logical Operators/04_01-True Season.mp4 18MB
  5. 06. Adding Dynamic Filters to the Map/06_03-SEASON filter.mp4 17MB
  6. 03. Date and Time Functions/03_04-VLOOKUP.mp4 17MB
  7. 03. Date and Time Functions/03_05-EOMONTH.mp4 15MB
  8. 05. Building a Basic Heat Map/05_01-Heat map framework.mp4 15MB
  9. 03. Date and Time Functions/03_02-Categorization.mp4 14MB
  10. 03. Date and Time Functions/03_06-YEARFRAC.mp4 14MB
  11. 06. Adding Dynamic Filters to the Map/06_02-Accident type COUNTIFS.mp4 11MB
  12. 07. Creating FormulaBased Formatting Rules/07_02-Formatting with ROW and COLUMN functions.mp4 9MB
  13. 04. Conditional Statements and Logical Operators/04_03-Using ISBLANK.mp4 9MB
  14. 03. Date and Time Functions/03_03-WEEKDAY.mp4 9MB
  15. 03. Date and Time Functions/03_01-DATEVALUE.mp4 9MB
  16. 02. Project Setup/02_02-Getting familiar with the data.mp4 8MB
  17. 05. Building a Basic Heat Map/05_05-Quick QA Identifying and eliminating inaccurate data.mp4 8MB
  18. 07. Creating FormulaBased Formatting Rules/07_01-Using the NOW and TODAY functions.mp4 7MB
  19. 06. Adding Dynamic Filters to the Map/06_01-Data validation.mp4 7MB
  20. 05. Building a Basic Heat Map/05_03-Color scale formatting.mp4 7MB
  21. 08. Wrapping Up/08_01-Adding the finishing touches.mp4 7MB
  22. 01. Introduction/01_01-Welcome.mp4 6MB
  23. 05. Building a Basic Heat Map/05_04-Aggregate data SUM.mp4 5MB
  24. 08. Wrapping Up/08_02-Accident analytics.mp4 5MB
  25. 07. Creating FormulaBased Formatting Rules/07_03-Highlighting a current moment in time.mp4 5MB
  26. 02. Project Setup/02_03-Project goal and creating a roadmap.mp4 4MB
  27. 02. Project Setup/02_01-Downloading the dataset.mp4 3MB
  28. 08. Wrapping Up/08_03-Extension Power Map.mp4 2MB
  29. 09. Conclusion/09_01-Next steps.mp4 1MB
  30. 01. Introduction/01_02-What you should know before watching this course.mp4 891KB
  31. 01. Introduction/01_03-Using the exercise files.mp4 677KB