|
|
0
|
|
0 B
|
|
|
1 - A brief introduction to Excel English.vtt
|
VTT
|
5.9 KB
|
|
|
1 - A brief introduction to Excel.mp4
|
MP4
|
44.9 MB
|
|
|
1 - Test your knowledge on references.html
|
HTML
|
0 B
|
|
|
1
|
|
307.2 B
|
|
|
2
|
|
24.2 KB
|
|
|
10 - Main Workbook download.html
|
HTML
|
1.4 KB
|
|
|
10 - MainWorkbook-Section2.xlsx
|
XLSX
|
748 KB
|
|
|
11 - The three different types of references. Part 1 English.vtt
|
VTT
|
8.6 KB
|
|
|
11 - The three different types of references. Part 1.mp4
|
MP4
|
62.4 MB
|
|
|
12 - The three different types of references. Part 2 English.vtt
|
VTT
|
4.7 KB
|
|
|
12 - The three different types of references. Part 2.mp4
|
MP4
|
38.5 MB
|
|
|
13 - References exercise. A quick note.html
|
HTML
|
409.6 B
|
|
|
14 - References exercise English.vtt
|
VTT
|
5.4 KB
|
|
|
14 - References exercise.mp4
|
MP4
|
38.4 MB
|
|
|
15 - 2022 update to main workbook.html
|
HTML
|
716.8 B
|
|
|
15 - Formulas-and-Functions.xlsx
|
XLSX
|
627.4 KB
|
|
|
16 - Formulas and functions. What's the difference English.vtt
|
VTT
|
2.6 KB
|
|
|
16 - Formulas and functions. What's the difference.mp4
|
MP4
|
13 MB
|
|
|
17 - How to write formulas English.vtt
|
VTT
|
11.5 KB
|
|
|
17 - How to write formulas.mp4
|
MP4
|
72.1 MB
|
|
|
18 - Basic function variations you must know English.vtt
|
VTT
|
13.5 KB
|
|
|
18 - Basic function variations you must know.mp4
|
MP4
|
116.1 MB
|
|
|
19 - Basic function variations you must know. SumIF and AverageIF English.vtt
|
VTT
|
10.9 KB
|
|
|
19 - Basic function variations you must know. SumIF and AverageIF.mp4
|
MP4
|
106.9 MB
|
|
|
2 - Test your knowledge on the concatenate function.html
|
HTML
|
0 B
|
|
|
2 - The basic layout of spreadsheet English.vtt
|
VTT
|
12.8 KB
|
|
|
2 - The basic layout of spreadsheet.mp4
|
MP4
|
162.4 MB
|
|
|
3
|
|
56.7 KB
|
|
|
4
|
|
884.8 KB
|
|
|
20 - Functions exercise instructions English.vtt
|
VTT
|
1.8 KB
|
|
|
20 - Functions exercise instructions.mp4
|
MP4
|
14.7 MB
|
|
|
21 - Welcome to the Concatenate function English.vtt
|
VTT
|
3.3 KB
|
|
|
21 - Welcome to the Concatenate function.mp4
|
MP4
|
28.4 MB
|
|
|
22 - The IF Function English.vtt
|
VTT
|
14.9 KB
|
|
|
22 - The IF Function.mp4
|
MP4
|
100 MB
|
|
|
23 - 2022 update to main workbook.html
|
HTML
|
819.2 B
|
|
|
24 - Introduction to charts English.vtt
|
VTT
|
2.2 KB
|
|
|
24 - Introduction to charts.mp4
|
MP4
|
20.5 MB
|
|
|
25 - Inserting a chart English.vtt
|
VTT
|
8 KB
|
|
|
25 - Inserting a chart.mp4
|
MP4
|
65.1 MB
|
|
|
26 - Chart exercise instructions English.vtt
|
VTT
|
1.5 KB
|
|
|
26 - Chart exercise instructions.mp4
|
MP4
|
11.1 MB
|
|
|
27 - Charts (And more) Solution video English.vtt
|
VTT
|
6.8 KB
|
|
|
27 - Charts (And more) Solution video.mp4
|
MP4
|
46 MB
|
|
|
28 - Formatting data into a table English.vtt
|
VTT
|
9.4 KB
|
|
|
28 - Formatting data into a table.mp4
|
MP4
|
86.2 MB
|
|
|
29 - Formatting data into a table. Part 2 English.vtt
|
VTT
|
7 KB
|
|
|
29 - Formatting data into a table. Part 2.mp4
|
MP4
|
64.6 MB
|
|
|
3 - Auto English.vtt
|
VTT
|
10.8 KB
|
|
|
3 - Auto-fill, basic functions and more.mp4
|
MP4
|
67.7 MB
|
|
|
3 - Test your knowledge on the IfAndOr function.html
|
HTML
|
0 B
|
|
|
30 - Function error in next tutorial.html
|
HTML
|
614.4 B
|
|
|
31 - The If And Or functions. Part 1 English.vtt
|
VTT
|
9.5 KB
|
|
|
31 - The If And Or functions. Part 1.mp4
|
MP4
|
71.6 MB
|
|
|
32 - The If And Or functions. Part 2 English.vtt
|
VTT
|
4.4 KB
|
|
|
32 - The If And Or functions. Part 2.mp4
|
MP4
|
34.2 MB
|
|
|
33 - 2022 course update.html
|
HTML
|
1.1 KB
|
|
|
34 - Introduction to printing English.vtt
|
VTT
|
1.1 KB
|
|
|
34 - Introduction to printing.mp4
|
MP4
|
7.7 MB
|
|
|
35 - Printing your first spreadsheet English.vtt
|
VTT
|
13.1 KB
|
|
|
35 - Printing your first spreadsheet.mp4
|
MP4
|
92.4 MB
|
|
|
35 - Printing.xlsx
|
XLSX
|
23.4 KB
|
|
|
36 - Printer settings English.vtt
|
VTT
|
2.2 KB
|
|
|
36 - Printer settings.mp4
|
MP4
|
14.4 MB
|
|
|
37 - Printing the second spreadsheet. Solution exercise English.vtt
|
VTT
|
5.3 KB
|
|
|
37 - Printing the second spreadsheet. Solution exercise.mp4
|
MP4
|
49.8 MB
|
|
|
38 - Building a Navigation pane English.vtt
|
VTT
|
11.6 KB
|
|
|
38 - Building a Navigation pane.mp4
|
MP4
|
61.5 MB
|
|
|
39 - Vlookup English.vtt
|
VTT
|
10.9 KB
|
|
|
39 - Vlookup.mp4
|
MP4
|
74 MB
|
|
|
4 - Exercise and solution video English.vtt
|
VTT
|
7 KB
|
|
|
4 - Exercise and solution video.mp4
|
MP4
|
54.8 MB
|
|
|
4 - SolutionandExercise.xlsx
|
XLSX
|
16.1 KB
|
|
|
4 - Test your knowledge on the IfAndOr function.html
|
HTML
|
0 B
|
|
|
5
|
|
459.8 KB
|
|
|
40 - Subtotaling data. Part1 English.vtt
|
VTT
|
11.7 KB
|
|
|
40 - Subtotaling data. Part1.mp4
|
MP4
|
81.7 MB
|
|
|
41 - Subtotaling data. Part 2 English.vtt
|
VTT
|
8.3 KB
|
|
|
41 - Subtotaling data. Part 2.mp4
|
MP4
|
60.8 MB
|
|
|
42 - Goals Exercise instructions English.vtt
|
VTT
|
4 KB
|
|
|
42 - Goals Exercise instructions.mp4
|
MP4
|
32.5 MB
|
|
|
43 - Goals solution video English.vtt
|
VTT
|
14.2 KB
|
|
|
43 - Goals solution video.mp4
|
MP4
|
110.1 MB
|
|
|
44 - Advanced printing English.vtt
|
VTT
|
10.6 KB
|
|
|
44 - Advanced printing.mp4
|
MP4
|
54.6 MB
|
|
|
45 - Collation and more English.vtt
|
VTT
|
6.5 KB
|
|
|
45 - Collation and more.mp4
|
MP4
|
67.5 MB
|
|
|
46 - Advanced printing. Part 2 English.vtt
|
VTT
|
11.8 KB
|
|
|
46 - Advanced printing. Part 2.mp4
|
MP4
|
59 MB
|
|
|
47 - Advanced printing. Part 3 English.vtt
|
VTT
|
11.2 KB
|
|
|
47 - Advanced printing. Part 3.mp4
|
MP4
|
72.7 MB
|
|
|
48 - Introduction to macros English.vtt
|
VTT
|
1.9 KB
|
|
|
48 - Introduction to macros.mp4
|
MP4
|
8 MB
|
|
|
5 - Course notebook preview English.vtt
|
VTT
|
1.1 KB
|
|
|
5 - Course notebook preview.mp4
|
MP4
|
9 MB
|
|
|
5 - Test your knowledge on printing in Excel.html
|
HTML
|
0 B
|
|
|
6 - Downloading your notebook templates.html
|
HTML
|
1.3 KB
|
|
|
6 - Notebook-Template-Pictures.zip
|
ZIP
|
167.2 KB
|
|
|
6 - Notebook-Templates-Word.docx
|
DOCX
|
246.8 KB
|
|
|
6 - Test your knowledge of building a navigation pane.html
|
HTML
|
0 B
|
|
|
6
|
|
879.2 KB
|
|
|
7
|
|
746.1 KB
|
|
|
8
|
|
128.7 KB
|
|
|
9
|
|
13.9 KB
|
|
|
10
|
|
321.3 KB
|
|
|
11
|
|
428.9 KB
|
|
|
12
|
|
634 KB
|
|
|
13
|
|
865.1 KB
|
|
|
14
|
|
215 KB
|
|
|
15
|
|
841.6 KB
|
|
|
16
|
|
987.4 KB
|
|
|
17
|
|
356.8 KB
|
|
|
18
|
|
781 KB
|
|
|
20
|
|
645.6 KB
|
|
|
21
|
|
845.4 KB
|
|
|
22
|
|
619.7 KB
|
|
|
23
|
|
41.9 KB
|
|
|
24
|
|
252.2 KB
|
|
|
25
|
|
347.1 KB
|
|
|
26
|
|
971.3 KB
|
|
|
27
|
|
378.1 KB
|
|
|
28
|
|
797.2 KB
|
|
|
29
|
|
197.2 KB
|
|
|
30
|
|
923.9 KB
|
|
|
31
|
|
329.3 KB
|
|
|
32
|
|
546.2 KB
|
|
|
33
|
|
924.6 KB
|
|
|
34
|
|
332.4 KB
|
|
|
35
|
|
372.3 KB
|
|
|
36
|
|
610.8 KB
|
|
|
37
|
|
925.7 KB
|
|
|
38
|
|
477 KB
|
|
|
40
|
|
170.5 KB
|
|
|
41
|
|
9.1 KB
|
|
|
42
|
|
164.3 KB
|
|
|
43
|
|
206.9 KB
|
|
|
44
|
|
437.4 KB
|
|
|
45
|
|
722.9 KB
|
|
|
46
|
|
524.8 KB
|
|
|
47
|
|
546 KB
|
|
|
48
|
|
125.1 KB
|
|
|
49
|
|
220.7 KB
|
|
|
49 - Creating your first macro English.vtt
|
VTT
|
14.5 KB
|
|
|
49 - Creating your first macro.mp4
|
MP4
|
88.8 MB
|
|
|
49 - MacrosInExcel.xlsx
|
XLSX
|
17.9 KB
|
|
|
50
|
|
456.2 KB
|
|
|
50 - Create a macro with cell referencing English.vtt
|
VTT
|
7.1 KB
|
|
|
50 - Create a macro with cell referencing.mp4
|
MP4
|
53.3 MB
|
|
|
51
|
|
509.4 KB
|
|
|
51 - Creating macro shortcut icons on the ribbon English.vtt
|
VTT
|
5.2 KB
|
|
|
51 - Creating macro shortcut icons on the ribbon.mp4
|
MP4
|
33.8 MB
|
|
|
52 - How to save a macro enabled Workbook. Best practices English.vtt
|
VTT
|
2.5 KB
|
|
|
52
|
|
697.6 KB
|
|
|
52 - How to save a macro enabled Workbook. Best practices.mp4
|
MP4
|
18.2 MB
|
|
|
53
|
|
2.2 KB
|
|
|
53 - MorgagesPmtIpmt-Spreadsheet.xlsx
|
XLSX
|
14.7 KB
|
|
|
53 - Using the PMT function for a mortgage English.vtt
|
VTT
|
9.9 KB
|
|
|
53 - Using the PMT function for a mortgage.mp4
|
MP4
|
62.1 MB
|
|
|
54
|
|
91.5 KB
|
|
|
54 - Using the IPMT function for a mortgage English.vtt
|
VTT
|
9.6 KB
|
|
|
54 - Using the IPMT function for a mortgage.mp4
|
MP4
|
70.2 MB
|
|
|
55
|
|
80.1 KB
|
|
|
55 - What if analysis. Data table English.vtt
|
VTT
|
9.1 KB
|
|
|
55 - What if analysis. Data table.mp4
|
MP4
|
61 MB
|
|
|
55 - What-IF-with-Tables-Spreadsheet.xlsx
|
XLSX
|
17.6 KB
|
|
|
56
|
|
329.8 KB
|
|
|
56 - What if analysis. Goal seek English.vtt
|
VTT
|
7.7 KB
|
|
|
56 - What if analysis. Goal seek.mp4
|
MP4
|
47.3 MB
|
|
|
57 - What if analysis. Goal seek formulas English.vtt
|
VTT
|
5.1 KB
|
|
|
57 - What if analysis. Goal seek formulas.mp4
|
MP4
|
38.7 MB
|
|
|
57
|
|
486.8 KB
|
|
|
58 - Introduction to 3D maps English.vtt
|
VTT
|
5.4 KB
|
|
|
58 - Introduction to 3D maps.mp4
|
MP4
|
51.5 MB
|
|
|
58
|
|
579 KB
|
|
|
58 - Power-Station-Sample1.xlsx
|
XLSX
|
3.4 MB
|
|
|
59
|
|
126.9 KB
|
|
|
59 - 3D maps. How to use. Part 1 English.vtt
|
VTT
|
14.9 KB
|
|
|
59 - 3D maps. How to use. Part 1.mp4
|
MP4
|
122.9 MB
|
|
|
60
|
|
259.4 KB
|
|
|
60 - 3D maps. How to use. Part 2 English.vtt
|
VTT
|
14.1 KB
|
|
|
60 - 3D maps. How to use. Part 2.mp4
|
MP4
|
133.8 MB
|
|
|
61
|
|
300.4 KB
|
|
|
61 - Link to Microsoft web page with data.html
|
HTML
|
409.6 B
|
|
|
62 - Must know functions. Part 1 English.vtt
|
VTT
|
9.9 KB
|
|
|
62 - MustKnowFunctions.xlsx
|
XLSX
|
19.6 KB
|
|
|
62
|
|
486.8 KB
|
|
|
62 - Must know functions. Part 1.mp4
|
MP4
|
64.7 MB
|
|
|
63 - Must know functions. Part 2.mp4
|
MP4
|
68.8 MB
|
|
|
63
|
|
625 KB
|
|
|
63 - Must know functions. Part 2 English.vtt
|
VTT
|
10.3 KB
|
|
|
64 - Must know functions. Part 3 English.vtt
|
VTT
|
6.9 KB
|
|
|
64
|
|
13.5 KB
|
|
|
64 - Must know functions. Part 3.mp4
|
MP4
|
43.4 MB
|
|
|
65 - Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 1 English.vtt
|
VTT
|
8.6 KB
|
|
|
65 - Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 1.mp4
|
MP4
|
54.8 MB
|
|
|
65
|
|
755.1 KB
|
|
|
65 - Splitting-names.xlsx
|
XLSX
|
14.6 KB
|
|
|
66 - Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 2 English.vtt
|
VTT
|
6.5 KB
|
|
|
66 - Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 2.mp4
|
MP4
|
49.6 MB
|
|
|
66
|
|
801 KB
|
|
|
67 - Excels drawing tools and more English.vtt
|
VTT
|
7.5 KB
|
|
|
67
|
|
210.3 KB
|
|
|
67 - Excels drawing tools and more.mp4
|
MP4
|
38.7 MB
|
|
|
68 - Introduction to Charts in Excel English.vtt
|
VTT
|
1.6 KB
|
|
|
68 - Introduction to Charts in Excel.mp4
|
MP4
|
28.2 MB
|
|
|
68
|
|
473.2 KB
|
|
|
69
|
|
524.7 KB
|
|
|
69 - Charts in Excel. Part 1 English.vtt
|
VTT
|
6.6 KB
|
|
|
69 - Charts in Excel. Part 1.mp4
|
MP4
|
45.9 MB
|
|
|
69 - ChartsWorkbook.xlsx
|
XLSX
|
17.9 KB
|
|
|
7 - Must know keyboard shortcuts when doing an online course English.vtt
|
VTT
|
6.4 KB
|
|
|
7 - Must know keyboard shortcuts when doing an online course.mp4
|
MP4
|
44.5 MB
|
|
|
70
|
|
618.2 KB
|
|
|
70 - Charts in Excel. Part 2 English.vtt
|
VTT
|
7.2 KB
|
|
|
70 - Charts in Excel. Part 2.mp4
|
MP4
|
47.5 MB
|
|
|
71
|
|
841 KB
|
|
|
71 - Charts in Excel. Part 3 English.vtt
|
VTT
|
12.4 KB
|
|
|
71 - Charts in Excel. Part 3.mp4
|
MP4
|
80.2 MB
|
|
|
72
|
|
710.7 KB
|
|
|
72 - Inserting sparklines and more English.vtt
|
VTT
|
14.3 KB
|
|
|
72 - Inserting sparklines and more.mp4
|
MP4
|
119.3 MB
|
|
|
72 - PictureForChart1.jpg
|
JPG
|
6.3 MB
|
|
|
72 - PictureForChart2.jpg
|
JPG
|
869.3 KB
|
|
|
72 - SparkLinesAndMore.xlsx
|
XLSX
|
40.6 KB
|
|
|
73 - Charts solution video English.vtt
|
VTT
|
9.2 KB
|
|
|
73 - Charts solution video.mp4
|
MP4
|
79.4 MB
|
|
|
74 - Freezing the panes and more English.vtt
|
VTT
|
9.6 KB
|
|
|
74 - Freezing the panes and more.mp4
|
MP4
|
107.3 MB
|
|
|
74 - Sorting-data-spreadsheet-Stats1-1.xlsx
|
XLSX
|
108.7 KB
|
|
|
75 - Sorting the data (Exercise instructions) English.vtt
|
VTT
|
3.2 KB
|
|
|
75 - Sorting the data (Exercise instructions).mp4
|
MP4
|
31.5 MB
|
|
|
76 - Sorting the data (Solution video).mp4
|
MP4
|
76.2 MB
|
|
|
8 - List of keyboard shortcuts.html
|
HTML
|
716.8 B
|
|
|
8 - Shortcuts.png
|
PNG
|
1.2 MB
|
|
|
9 - A general overview and brief introduction (MUST WATCH) English.vtt
|
VTT
|
2.4 KB
|
|
|
9 - A general overview and brief introduction (MUST WATCH).mp4
|
MP4
|
37 MB
|
|
|
73
|
|
179.8 KB
|
|
|
74
|
|
507.2 KB
|
|
|
75
|
|
856.6 KB
|
|
|
76 - Sorting the data (Solution video) English.vtt
|
VTT
|
6.7 KB
|
|
|
76
|
|
304.2 KB
|
|
|
77 - Filtering and analyzing the data. Part 1 English.vtt
|
VTT
|
8.6 KB
|
|
|
77
|
|
591.2 KB
|
|
|
77 - Filtering and analyzing the data. Part 1.mp4
|
MP4
|
92.2 MB
|
|
|
78 - Filtering and analyzing the data. Part 2 English.vtt
|
VTT
|
7.2 KB
|
|
|
78 - Filtering and analyzing the data. Part 2.mp4
|
MP4
|
75.4 MB
|
|
|
79 - Duplicates-Spreadsheet1.xlsx
|
XLSX
|
12.8 KB
|
|
|
79 - Locating and deleting duplicate entries English.vtt
|
VTT
|
5.7 KB
|
|
|
79 - Locating and deleting duplicate entries.mp4
|
MP4
|
34.3 MB
|
|
|
79
|
|
938.2 KB
|
|
|
80 - Concatenate continuation training English.vtt
|
VTT
|
6.5 KB
|
|
|
80 - Concatenate continuation training.mp4
|
MP4
|
49.9 MB
|
|
|
80
|
|
982.3 KB
|
|
|
80 - Duplicates-Spreadsheet1.xlsx
|
XLSX
|
12.8 KB
|
|
|
81 - How to use the DateValue attribute within the IF function English.vtt
|
VTT
|
5.6 KB
|
|
|
81 - How to use the DateValue attribute within the IF function.mp4
|
MP4
|
44.7 MB
|
|
|
81
|
|
20.9 KB
|
|
|
82
|
|
337.5 KB
|
|
|
82 - Calculating the payment with the PMT Function English.vtt
|
VTT
|
6.1 KB
|
|
|
82 - Calculating the payment with the PMT Function.mp4
|
MP4
|
72.8 MB
|
|
|
82 - Car-loan-Spreadsheet.xlsx
|
XLSX
|
11.6 KB
|
|
|
83 - Exploring true cost English.vtt
|
VTT
|
5.1 KB
|
|
|
83 - Exploring true cost.mp4
|
MP4
|
51.5 MB
|
|
|
83
|
|
715.5 KB
|
|
|
84 - Calculating total cost English.vtt
|
VTT
|
6.6 KB
|
|
|
84
|
|
620.7 KB
|
|
|
84 - Calculating total cost.mp4
|
MP4
|
93.7 MB
|
|
|
85 - Using the 'IPMT' function to work out interest English.vtt
|
VTT
|
8.7 KB
|
|
|
85 - Using the 'IPMT' function to work out interest.mp4
|
MP4
|
113.6 MB
|
|
|
86 - Inserting a chart for reference (Car Finance) English.vtt
|
VTT
|
6.2 KB
|
|
|
86 - Inserting a chart for reference (Car Finance).mp4
|
MP4
|
68.1 MB
|
|
|
87 - Introduction to pivot tables and charts English.vtt
|
VTT
|
1.1 KB
|
|
|
87 - Introduction to pivot tables and charts.mp4
|
MP4
|
20.8 MB
|
|
|
88 - Pivot-charts-and-tables.xlsx
|
XLSX
|
18.2 KB
|
|
|
88 - Source data checklist and building your first pivot table English.vtt
|
VTT
|
8.8 KB
|
|
|
88 - Source data checklist and building your first pivot table.mp4
|
MP4
|
93.6 MB
|
|
|
89 - How the interface works (The field list) and more English.vtt
|
VTT
|
13.6 KB
|
|
|
89 - How the interface works (The field list) and more.mp4
|
MP4
|
80 MB
|
|
|
90 - Inserting our last Pivot table, charts, and beginning on our dashboard English.vtt
|
VTT
|
6.3 KB
|
|
|
90 - Inserting our last Pivot table, charts, and beginning on our dashboard.mp4
|
MP4
|
40.9 MB
|
|
|
91 - Building a dashboard and inserting slicers English.vtt
|
VTT
|
13.3 KB
|
|
|
91 - Building a dashboard and inserting slicers.mp4
|
MP4
|
84 MB
|
|
|
92 - Farewell message.html
|
HTML
|
1 KB
|
|
|
93 - Farewell English.vtt
|
VTT
|
1.4 KB
|
|
|
93 - Farewell.mp4
|
MP4
|
25.3 MB
|
|
|
TutsNode.com.txt
|
TXT
|
102.4 B
|
|
|
[TGx]Downloaded from torrentgalaxy.to .txt
|
TXT
|
614.4 B
|
