种子简介
种子名称:
Lynda - Excel Workshop - Building a Dynamic Heat Map
文件类型:
视频
文件数目:
30个文件
文件大小:
269.05 MB
收录时间:
2016-12-3 15:27
已经下载:
3次
资源热度:
104
最近下载:
2024-11-21 10:36
下载BT种子文件
下载Torrent文件(.torrent)
立即下载
磁力链接下载
magnet:?xt=urn:btih:5164ff0490c8b523624373b69b52a1f10683bf72&dn=Lynda - Excel Workshop - Building a Dynamic Heat Map
复制链接到迅雷、QQ旋风进行下载,或者使用百度云离线下载。
喜欢这个种子的人也喜欢
种子包含的文件
Lynda - Excel Workshop - Building a Dynamic Heat Map.torrent
01. Introduction/01_01-Welcome.mp45.53MB
01. Introduction/01_02-What you should know before watching this course.mp4891.41KB
01. Introduction/01_03-Using the exercise files.mp4677.23KB
02. Project Setup/02_01-Downloading the dataset.mp43.42MB
02. Project Setup/02_02-Getting familiar with the data.mp47.72MB
02. Project Setup/02_03-Project goal and creating a roadmap.mp43.8MB
03. Date and Time Functions/03_01-DATEVALUE.mp48.74MB
03. Date and Time Functions/03_02-Categorization.mp414.35MB
03. Date and Time Functions/03_03-WEEKDAY.mp49.17MB
03. Date and Time Functions/03_04-VLOOKUP.mp416.54MB
03. Date and Time Functions/03_05-EOMONTH.mp415.07MB
03. Date and Time Functions/03_06-YEARFRAC.mp413.8MB
04. Conditional Statements and Logical Operators/04_01-True Season.mp417.68MB
04. Conditional Statements and Logical Operators/04_02-Accident type.mp417.97MB
04. Conditional Statements and Logical Operators/04_03-Using ISBLANK.mp49.42MB
05. Building a Basic Heat Map/05_01-Heat map framework.mp415.05MB
05. Building a Basic Heat Map/05_02-COUNTIFS.mp419.14MB
05. Building a Basic Heat Map/05_03-Color scale formatting.mp46.73MB
05. Building a Basic Heat Map/05_04-Aggregate data SUM.mp44.92MB
05. Building a Basic Heat Map/05_05-Quick QA Identifying and eliminating inaccurate data.mp47.69MB
06. Adding Dynamic Filters to the Map/06_01-Data validation.mp46.78MB
06. Adding Dynamic Filters to the Map/06_02-Accident type COUNTIFS.mp410.59MB
06. Adding Dynamic Filters to the Map/06_03-SEASON filter.mp417.19MB
07. Creating FormulaBased Formatting Rules/07_01-Using the NOW and TODAY functions.mp47.46MB
07. Creating FormulaBased Formatting Rules/07_02-Formatting with ROW and COLUMN functions.mp49.43MB
07. Creating FormulaBased Formatting Rules/07_03-Highlighting a current moment in time.mp44.56MB
08. Wrapping Up/08_01-Adding the finishing touches.mp46.53MB
08. Wrapping Up/08_02-Accident analytics.mp44.83MB
08. Wrapping Up/08_03-Extension Power Map.mp41.96MB
09. Conclusion/09_01-Next steps.mp41.45MB