zhongziso种子搜
首页
功能
磁力转BT
BT转磁力
使用教程
免责声明
关于
zhongziso
搜索
Lynda - Excel Workshop - Building a Dynamic Heat Map
magnet:?xt=urn:btih:5164ff0490c8b523624373b69b52a1f10683bf72&dn=Lynda - Excel Workshop - Building a Dynamic Heat Map
磁力链接详情
Hash值:
5164ff0490c8b523624373b69b52a1f10683bf72
点击数:
86
文件大小:
269.05 MB
文件数量:
30
创建日期:
2016-12-3 15:27
最后访问:
2024-7-28 00:18
访问标签:
Lynda
-
Excel
Workshop
-
Building
a
Dynamic
Heat
Map
文件列表详情
01. Introduction/01_01-Welcome.mp4 5.53 MB
01. Introduction/01_02-What you should know before watching this course.mp4 891.41 KB
01. Introduction/01_03-Using the exercise files.mp4 677.23 KB
02. Project Setup/02_01-Downloading the dataset.mp4 3.42 MB
02. Project Setup/02_02-Getting familiar with the data.mp4 7.72 MB
02. Project Setup/02_03-Project goal and creating a roadmap.mp4 3.8 MB
03. Date and Time Functions/03_01-DATEVALUE.mp4 8.74 MB
03. Date and Time Functions/03_02-Categorization.mp4 14.35 MB
03. Date and Time Functions/03_03-WEEKDAY.mp4 9.17 MB
03. Date and Time Functions/03_04-VLOOKUP.mp4 16.54 MB
03. Date and Time Functions/03_05-EOMONTH.mp4 15.07 MB
03. Date and Time Functions/03_06-YEARFRAC.mp4 13.8 MB
04. Conditional Statements and Logical Operators/04_01-True Season.mp4 17.68 MB
04. Conditional Statements and Logical Operators/04_02-Accident type.mp4 17.97 MB
04. Conditional Statements and Logical Operators/04_03-Using ISBLANK.mp4 9.42 MB
05. Building a Basic Heat Map/05_01-Heat map framework.mp4 15.05 MB
05. Building a Basic Heat Map/05_02-COUNTIFS.mp4 19.14 MB
05. Building a Basic Heat Map/05_03-Color scale formatting.mp4 6.73 MB
05. Building a Basic Heat Map/05_04-Aggregate data SUM.mp4 4.92 MB
05. Building a Basic Heat Map/05_05-Quick QA Identifying and eliminating inaccurate data.mp4 7.69 MB
06. Adding Dynamic Filters to the Map/06_01-Data validation.mp4 6.78 MB
06. Adding Dynamic Filters to the Map/06_02-Accident type COUNTIFS.mp4 10.59 MB
06. Adding Dynamic Filters to the Map/06_03-SEASON filter.mp4 17.19 MB
07. Creating FormulaBased Formatting Rules/07_01-Using the NOW and TODAY functions.mp4 7.46 MB
07. Creating FormulaBased Formatting Rules/07_02-Formatting with ROW and COLUMN functions.mp4 9.43 MB
07. Creating FormulaBased Formatting Rules/07_03-Highlighting a current moment in time.mp4 4.56 MB
08. Wrapping Up/08_01-Adding the finishing touches.mp4 6.53 MB
08. Wrapping Up/08_02-Accident analytics.mp4 4.83 MB
08. Wrapping Up/08_03-Extension Power Map.mp4 1.96 MB
09. Conclusion/09_01-Next steps.mp4 1.45 MB
其他位置