| Lynda - Excel Workshop - Building a Dynamic Heat Map/01. Introduction/01_01-Welcome.mp4 |
5.5 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/01. Introduction/01_02-What you should know before watching this course.mp4 |
891 KB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/01. Introduction/01_03-Using the exercise files.mp4 |
677 KB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/02. Project Setup/02_01-Downloading the dataset.mp4 |
3.4 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/02. Project Setup/02_02-Getting familiar with the data.mp4 |
7.7 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/02. Project Setup/02_03-Project goal and creating a roadmap.mp4 |
3.8 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/03. Date and Time Functions/03_01-DATEVALUE.mp4 |
8.7 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/03. Date and Time Functions/03_02-Categorization.mp4 |
14.4 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/03. Date and Time Functions/03_03-WEEKDAY.mp4 |
9.2 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/03. Date and Time Functions/03_04-VLOOKUP.mp4 |
16.5 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/03. Date and Time Functions/03_05-EOMONTH.mp4 |
15.1 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/03. Date and Time Functions/03_06-YEARFRAC.mp4 |
13.8 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/04. Conditional Statements and Logical Operators/04_01-True Season.mp4 |
17.7 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/04. Conditional Statements and Logical Operators/04_02-Accident type.mp4 |
18 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/04. Conditional Statements and Logical Operators/04_03-Using ISBLANK.mp4 |
9.4 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/05. Building a Basic Heat Map/05_01-Heat map framework.mp4 |
15 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/05. Building a Basic Heat Map/05_02-COUNTIFS.mp4 |
19.1 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/05. Building a Basic Heat Map/05_03-Color scale formatting.mp4 |
6.7 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/05. Building a Basic Heat Map/05_04-Aggregate data SUM.mp4 |
4.9 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/05. Building a Basic Heat Map/05_05-Quick QA Identifying and eliminating inaccurate data.mp4 |
7.7 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/06. Adding Dynamic Filters to the Map/06_01-Data validation.mp4 |
6.8 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/06. Adding Dynamic Filters to the Map/06_02-Accident type COUNTIFS.mp4 |
10.6 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/06. Adding Dynamic Filters to the Map/06_03-SEASON filter.mp4 |
17.2 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/07. Creating FormulaBased Formatting Rules/07_01-Using the NOW and TODAY functions.mp4 |
7.5 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/07. Creating FormulaBased Formatting Rules/07_02-Formatting with ROW and COLUMN functions.mp4 |
9.4 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/07. Creating FormulaBased Formatting Rules/07_03-Highlighting a current moment in time.mp4 |
4.6 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/08. Wrapping Up/08_01-Adding the finishing touches.mp4 |
6.5 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/08. Wrapping Up/08_02-Accident analytics.mp4 |
4.8 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/08. Wrapping Up/08_03-Extension Power Map.mp4 |
2 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/09. Conclusion/09_01-Next steps.mp4 |
1.4 MB |
| Lynda - Excel Workshop - Building a Dynamic Heat Map/Exercice Files/Ex_Files_Excel_HeatMaps.zip |
25.6 MB |
Magnet link
