|Zwiń wszystko
Functions03:45:13
- Text functions 1 (MID, FIND, TRIM, CHAR) 00:23:15
- Text functions 2 - example 00:22:33
- Text functions 3 (SUBSTITIUTE, TEXT, Join Text)) 00:11:41
- VLOOKUP function (part 1) 00:14:30
- VLOOKUP function (part 2) 00:17:39
- Search function 1 (OFFSET, MATCH, VLOOKUP) 00:14:48
- Search function 2 (INDEX + MATCH vs PowerQuery) 00:22:02
- Search function 3 (INDEX + MATCH) 00:24:06
- Search function 4 (INDIRECT) 00:14:19
- Search function 5 (HLOOKUP) 00:12:56
- INDIRECT function 00:13:50
- Array formulas - introduction 00:07:34
- Array formulas - example 1 00:04:43
- Array formulas - example 2 00:10:32
- Array formulas - example 3 00:10:41
Formatting01:53:04
- Custom number format: ex1 (numbers, text) 00:30:37
- Custom number format: ex2 (date and time) 00:16:05
- Conditional formatting: ex1 (format row) 00:09:52
- Conditional formatting: ex2 (use a fromula) 00:10:15
- Conditional formatting: ex3 (date) 00:10:24
- Conditional formatting: ex4 (use a formula and form controls) 00:28:14
- Conditional formatting: ex5 00:07:34
Pivot tables02:03:37
- Introduction to Pivot Tables 00:26:08
- Pivot Tables: ex2 (Group Data, Show Data As, Calculated Fields) 00:29:20
- Pivot Tables: ex3 (Append Data in Power Query, Table Tools, Pivot Charts and Slicer) 00:34:54
- Pivot Tables: ex4 (Calculated Items) 00:19:10
- Pivot Tables: ex5 (Data model, Relationships and Slicer) 00:14:02
Tools00:45:09
- Consolidate 00:09:54
- Goal Seek ex1 00:04:44
- Goal Seek ex2 00:07:25
- Solver 00:23:04
Macros01:12:21
- Function email 00:17:28
- Macro recording example 1 00:18:40
- Macro recording example 2 00:08:56
- Macro import - errors 00:06:02
- Macro import 00:21:13
