Lynda Excel Workshop Building Dynamic Heat Map | 5164FF0490C8B523624373B69B52A1F10683BF72

Lynda Excel Workshop Building Dynamic Heat Map

Name	Lynda - Excel Workshop - Building a Dynamic Heat Map	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	309.0 MB
Total Files	31
Hash	5164FF0490C8B523624373B69B52A1F10683BF72

/01. Introduction/
01_01-Welcome.mp4	5.8 MB
01_02-What you should know before watching this course.mp4	912.8 KB
01_03-Using the exercise files.mp4	693.5 KB
/02. Project Setup/
02_01-Downloading the dataset.mp4	3.6 MB
02_02-Getting familiar with the data.mp4	8.1 MB
02_03-Project goal and creating a roadmap.mp4	4.0 MB
/03. Date and Time Functions/
03_01-DATEVALUE.mp4	9.2 MB
03_02-Categorization.mp4	15.0 MB
03_03-WEEKDAY.mp4	9.6 MB
03_04-VLOOKUP.mp4	17.3 MB
03_05-EOMONTH.mp4	15.8 MB
03_06-YEARFRAC.mp4	14.5 MB
/04. Conditional Statements and Logical Operators/
04_01-True Season.mp4	18.5 MB
04_02-Accident type.mp4	18.8 MB
04_03-Using ISBLANK.mp4	9.9 MB
/05. Building a Basic Heat Map/
05_01-Heat map framework.mp4	15.8 MB
05_02-COUNTIFS.mp4	20.1 MB
05_03-Color scale formatting.mp4	7.1 MB
05_04-Aggregate data SUM.mp4	5.2 MB
05_05-Quick QA Identifying and eliminating inaccurate data.mp4	8.1 MB
/06. Adding Dynamic Filters to the Map/
06_01-Data validation.mp4	7.1 MB
06_02-Accident type COUNTIFS.mp4	11.1 MB
06_03-SEASON filter.mp4	18.0 MB
/07. Creating FormulaBased Formatting Rules/
07_01-Using the NOW and TODAY functions.mp4	7.8 MB
07_02-Formatting with ROW and COLUMN functions.mp4	9.9 MB
07_03-Highlighting a current moment in time.mp4	4.8 MB
/08. Wrapping Up/
08_01-Adding the finishing touches.mp4	6.8 MB
08_02-Accident analytics.mp4	5.1 MB
08_03-Extension Power Map.mp4	2.1 MB
/09. Conclusion/
09_01-Next steps.mp4	1.5 MB
/Exercice Files/
Ex_Files_Excel_HeatMaps.zip	26.9 MB
Total files 31