01 - Introduction
Ex_Files_Miss_Excel_Top_Productivity_Hacks
02 - 1. Cleaning Data
-
01 - Meet Flash Fill The superhero of Excel (2:52)
-
02 - Text to columns The CSV file connoisseur (2:59)
-
03 - Go To Special The blank-removing remedy (2:52)
-
04 - The Excel glue stick &, CONCATENATE, and TEXTJOIN (6:14)
-
05 - LEFT and FIND The Excel power couple (5:22)
-
06 - Ctrl + enter The missing heading magician (2:33)
03 - 2. Analyzing Data
-
01 - Meet XLOOKUP The new Microsoft lookup function (3:05)
-
02 - INDEX and MATCH The perfect pair (5:07)
-
03 - Meet the new FILTER function (3:45)
-
04 - The perfect pair PivotTables and PowerPoint (4:25)
-
05 - Meet SUM-s supervisor The SUMIF function (3:00)
-
06 - Why you need absolute referencing (4:46)
-
07 - PivotTable grouping tool The summarizing savant (2:32)
04 - 3. Formatting Data
-
01 - Drop it like it-s hot with dropdown menus (2:35)
-
02 - Input messages The art of leaving notes tastefully (2:44)
-
03 - PSA Cells can format themselves with conditional formatting (2:38)
-
04 - Rebranding secret weapon Find and Replace by color (2:54)
-
05 - Grab your jacket, we are freezing our panes (1:51)
-
06 - Copy and paste visible cells only (not ones you-ve hidden) (3:43)
05 - Conclusion
