|
|
001 1.1 Basic math formulas.mp4
|
MP4
|
72.4 MB
|
|
|
001 1.1 Basic math formulas_en.srt
|
SRT
|
8.9 KB
|
|
|
001 1.1-solution.xlsx
|
XLSX
|
19.4 KB
|
|
|
001 1.1.xlsx
|
XLSX
|
18.8 KB
|
|
|
001 2.1 Logical functions.mp4
|
MP4
|
38.5 MB
|
|
|
001 2.1 Logical functions_en.srt
|
SRT
|
6.6 KB
|
|
|
001 3.1 Your first VLOOKUP.mp4
|
MP4
|
64.6 MB
|
|
|
001 3.1 Your first VLOOKUP_en.srt
|
SRT
|
7.8 KB
|
|
|
001 4.1 COUNTIF and SUMIF.mp4
|
MP4
|
70.8 MB
|
|
|
001 4.1 COUNTIF and SUMIF_en.srt
|
SRT
|
9.1 KB
|
|
|
001 5.1 Basic filtering.mp4
|
MP4
|
207 MB
|
|
|
001 5.1 Basic filtering_en.srt
|
SRT
|
36 KB
|
|
|
001 5.1-solution.xlsx
|
XLSX
|
2.4 MB
|
|
|
001 5.1.xlsx
|
XLSX
|
2.3 MB
|
|
|
001 The New Excel Learning Curve.mp4
|
MP4
|
57.4 MB
|
|
|
001 The New Excel Learning Curve_en.srt
|
SRT
|
3.6 KB
|
|
|
002 1.2 Formulas in the entire column.mp4
|
MP4
|
65.3 MB
|
|
|
002 1.2 Formulas in the entire column_en.srt
|
SRT
|
6.7 KB
|
|
|
002 1.2-solution.xlsx
|
XLSX
|
40.6 KB
|
|
|
002 1.2.xlsx
|
XLSX
|
24.1 KB
|
|
|
002 2.1-2-solution.xlsx
|
XLSX
|
12.5 KB
|
|
|
002 2.1-2.xlsx
|
XLSX
|
11 KB
|
|
|
002 2.2 IF, IFS, SWITCH (Excel 365).mp4
|
MP4
|
65.9 MB
|
|
|
002 2.2 IF, IFS, SWITCH (Excel 365)_en.srt
|
SRT
|
9 KB
|
|
|
002 3.2 Common problems with VLOOKUP.mp4
|
MP4
|
57.2 MB
|
|
|
002 3.2 Common problems with VLOOKUP_en.srt
|
SRT
|
7.9 KB
|
|
|
002 4.2 COUNTIFS and SUMIFS.mp4
|
MP4
|
86 MB
|
|
|
002 4.2 COUNTIFS and SUMIFS_en.srt
|
SRT
|
9 KB
|
|
|
002 5.2 Advanced filtering.mp4
|
MP4
|
55.4 MB
|
|
|
002 5.2 Advanced filtering_en.srt
|
SRT
|
4.8 KB
|
|
|
002 5.2-solution.xlsx
|
XLSX
|
3.2 MB
|
|
|
002 5.2.xlsx
|
XLSX
|
3.1 MB
|
|
|
003 1.3 Blocking formula address.mp4
|
MP4
|
59.3 MB
|
|
|
003 1.3 Blocking formula address_en.srt
|
SRT
|
9.8 KB
|
|
|
003 1.3-solution.xlsx
|
XLSX
|
15.4 KB
|
|
|
003 1.3.xlsx
|
XLSX
|
13.3 KB
|
|
|
003 2.3 Date & time functions.mp4
|
MP4
|
91.8 MB
|
|
|
003 2.3 Date & time functions_en.srt
|
SRT
|
12.3 KB
|
|
|
003 2.3-solution.xlsx
|
XLSX
|
13.4 KB
|
|
|
003 2.3.xlsx
|
XLSX
|
12.8 KB
|
|
|
003 3.3 Dealing with VLOOKUP errors with IFERROR.mp4
|
MP4
|
16.5 MB
|
|
|
003 3.3 Dealing with VLOOKUP errors with IFERROR_en.srt
|
SRT
|
1.9 KB
|
|
|
003 4.3 AVERAGEIF and MINIFS.mp4
|
MP4
|
16.2 MB
|
|
|
003 4.3 AVERAGEIF and MINIFS_en.srt
|
SRT
|
1.9 KB
|
|
|
003 5.3 Sorting.mp4
|
MP4
|
78.2 MB
|
|
|
003 5.3 Sorting_en.srt
|
SRT
|
7.5 KB
|
|
|
003 5.3-solution.xlsx
|
XLSX
|
52.5 KB
|
|
|
003 5.3.xlsx
|
XLSX
|
51.9 KB
|
|
|
003 form11.mp4
|
MP4
|
45.4 MB
|
|
|
004 1.4 Formulas in tables.mp4
|
MP4
|
66.6 MB
|
|
|
004 1.4 Formulas in tables_en.srt
|
SRT
|
9.4 KB
|
|
|
004 1.4-solution.xlsx
|
XLSX
|
13.2 KB
|
|
|
004 1.4.xlsx
|
XLSX
|
10.6 KB
|
|
|
004 2.4 Text functions (Excel 365).mp4
|
MP4
|
127 MB
|
|
|
004 2.4 Text functions (Excel 365)_en.srt
|
SRT
|
16.1 KB
|
|
|
004 2.4-solution.xlsx
|
XLSX
|
13.3 KB
|
|
|
004 2.4.xlsx
|
XLSX
|
11.9 KB
|
|
|
004 3.4 VLOOKUP to the left.mp4
|
MP4
|
18 MB
|
|
|
004 3.4 VLOOKUP to the left_en.srt
|
SRT
|
2.3 KB
|
|
|
004 4.4 SUMPRODUCT.mp4
|
MP4
|
13.2 MB
|
|
|
004 4.4 SUMPRODUCT_en.srt
|
SRT
|
1.2 KB
|
|
|
004 5.4 Removing duplicates.mp4
|
MP4
|
22.9 MB
|
|
|
004 5.4 Removing duplicates_en.srt
|
SRT
|
3.2 KB
|
|
|
004 5.4-solution.xlsx
|
XLSX
|
787.1 KB
|
|
|
004 5.4.xlsx
|
XLSX
|
766.8 KB
|
|
|
005 1.5-solution.xlsx
|
XLSX
|
12.5 KB
|
|
|
005 1.5. Defined names.mp4
|
MP4
|
34.2 MB
|
|
|
005 1.5. Defined names_en.srt
|
SRT
|
4.9 KB
|
|
|
005 1.5.xlsx
|
XLSX
|
10.8 KB
|
|
|
005 2.5 DIY Excel functions overview.mp4
|
MP4
|
100.3 MB
|
|
|
005 2.5 DIY Excel functions overview_en.srt
|
SRT
|
19.7 KB
|
|
|
005 2.5-solution.xlsx
|
XLSX
|
21.3 KB
|
|
|
005 2.5.xlsx
|
XLSX
|
18 KB
|
|
|
005 3.5 VLOOKUP on more than 1 column.mp4
|
MP4
|
11.5 MB
|
|
|
005 3.5 VLOOKUP on more than 1 column_en.srt
|
SRT
|
1.6 KB
|
|
|
005 4.5 Pivot table.mp4
|
MP4
|
8 MB
|
|
|
005 4.5 Pivot table_en.srt
|
SRT
|
1.6 KB
|
|
|
005 5.5 Conditional formatting.mp4
|
MP4
|
25.7 MB
|
|
|
005 5.5 Conditional formatting_en.srt
|
SRT
|
2.7 KB
|
|
|
005 5.5-solution.xlsx
|
XLSX
|
22.2 KB
|
|
|
005 5.5.xlsx
|
XLSX
|
21.2 KB
|
|
|
006 1.6 Shortcuts useful in working with cells and formulas.mp4
|
MP4
|
103.8 MB
|
|
|
006 1.6 Shortcuts useful in working with cells and formulas_en.srt
|
SRT
|
12.3 KB
|
|
|
006 1.6.xlsx
|
XLSX
|
12 KB
|
|
|
006 3.6 VLOOKUP with TRUE.mp4
|
MP4
|
14.5 MB
|
|
|
006 3.6 VLOOKUP with TRUE_en.srt
|
SRT
|
2.7 KB
|
|
|
006 4.6 Array formulas (Excel 365).mp4
|
MP4
|
8.9 MB
|
|
|
006 4.6 Array formulas (Excel 365)_en.srt
|
SRT
|
1.3 KB
|
|
|
006 5.6 Finding and replacing.mp4
|
MP4
|
50.2 MB
|
|
|
006 5.6 Finding and replacing_en.srt
|
SRT
|
6 KB
|
|
|
006 5.6-solution.xlsx
|
XLSX
|
31.4 KB
|
|
|
006 5.6.xlsx
|
XLSX
|
29.7 KB
|
|
|
007 1.7 Errors and problems with formulas.mp4
|
MP4
|
41.8 MB
|
|
|
007 1.7 Errors and problems with formulas_en.srt
|
SRT
|
7.7 KB
|
|
|
007 1.7-solution.xlsx
|
XLSX
|
11.9 KB
|
|
|
007 1.7.xlsx
|
XLSX
|
11.7 KB
|
|
|
007 3.7 VLOOKUP and many columns.mp4
|
MP4
|
15.7 MB
|
|
|
007 3.7 VLOOKUP and many columns_en.srt
|
SRT
|
2.2 KB
|
|
|
007 4.1-7-solution.xlsx
|
XLSX
|
33 KB
|
|
|
007 4.1-7.xlsx
|
XLSX
|
24.2 KB
|
|
|
007 4.7 Reference formulas.mp4
|
MP4
|
32.1 MB
|
|
|
007 4.7 Reference formulas_en.srt
|
SRT
|
5.4 KB
|
|
|
007 5.7 Pasting.mp4
|
MP4
|
97.7 MB
|
|
|
007 5.7 Pasting_en.srt
|
SRT
|
11.1 KB
|
|
|
007 5.7-solution.xlsx
|
XLSX
|
21.2 KB
|
|
|
007 5.7.xlsx
|
XLSX
|
20.8 KB
|
|
|
008 1.8 DIY Introduction to Excel formulas.mp4
|
MP4
|
46 MB
|
|
|
008 1.8 DIY Introduction to Excel formulas_en.srt
|
SRT
|
9.4 KB
|
|
|
008 1.8-solution.xlsx
|
XLSX
|
15.8 KB
|
|
|
008 1.8.xlsx
|
XLSX
|
15 KB
|
|
|
008 3.1-8-solution.xlsx
|
XLSX
|
65.4 KB
|
|
|
008 3.1-8.xlsx
|
XLSX
|
62.5 KB
|
|
|
008 3.8 HLOOKUP.mp4
|
MP4
|
20.7 MB
|
|
|
008 3.8 HLOOKUP_en.srt
|
SRT
|
2.4 KB
|
|
|
008 4.8 DYI Key reporting formulas.mp4
|
MP4
|
8.8 MB
|
|
|
008 4.8 DYI Key reporting formulas_en.srt
|
SRT
|
1.9 KB
|
|
|
008 4.8-solution.xlsx
|
XLSX
|
40.2 KB
|
|
|
008 4.8.xlsx
|
XLSX
|
33.1 KB
|
|
|
008 5.8 FILTER, SORT, SORTBY, UNIQUE (Excel 365).mp4
|
MP4
|
39.6 MB
|
|
|
008 5.8 FILTER, SORT, SORTBY, UNIQUE (Excel 365)_en.srt
|
SRT
|
4 KB
|
|
|
008 5.8-solution.xlsx
|
XLSX
|
37.9 KB
|
|
|
008 5.8.xlsx
|
XLSX
|
31.5 KB
|
|
|
009 3.9 XLOOKUP and XMATCH (Excel 365).mp4
|
MP4
|
10.2 MB
|
|
|
009 3.9 XLOOKUP and XMATCH (Excel 365)_en.srt
|
SRT
|
1.8 KB
|
|
|
009 3.9-solution.xlsx
|
XLSX
|
60.3 KB
|
|
|
009 3.9.xlsx
|
XLSX
|
57.7 KB
|
|
|
009 5.9 DIY Data operations.mp4
|
MP4
|
102 MB
|
|
|
009 5.9 DIY Data operations_en.srt
|
SRT
|
13 KB
|
|
|
009 5.9-solution.xlsx
|
XLSX
|
81 KB
|
|
|
009 5.9.xlsx
|
XLSX
|
73.7 KB
|
|
|
010 3.10 DIY VLOOKUP.mp4
|
MP4
|
77.9 MB
|
|
|
010 3.10 DIY VLOOKUP_en.srt
|
SRT
|
12.7 KB
|
|
|
010 3.10-solution.xlsx
|
XLSX
|
80.8 KB
|
|
|
010 3.10.xlsx
|
XLSX
|
70.4 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
