|
|
0
|
|
0 B
|
|
|
1. Analytics in Excel.mp4
|
MP4
|
138.8 MB
|
|
|
1. Analytics in Excel.srt
|
SRT
|
21.2 KB
|
|
|
1. Charts-Part 1.mp4
|
MP4
|
92.3 MB
|
|
|
1. Charts-Part 1.srt
|
SRT
|
14.9 KB
|
|
|
1. Concept of Net Present Value and Customer Value.mp4
|
MP4
|
62.3 MB
|
|
|
1. Concept of Net Present Value and Customer Value.srt
|
SRT
|
9.7 KB
|
|
|
1. Data Tools.mp4
|
MP4
|
158.2 MB
|
|
|
1. Data Tools.srt
|
SRT
|
23.4 KB
|
|
|
1. Excel Practice test.html
|
HTML
|
204.8 B
|
|
|
1. Excel Shortcuts.mp4
|
MP4
|
134.6 MB
|
|
|
1. Formatting data and tables.mp4
|
MP4
|
201.8 MB
|
|
|
1
|
|
204.8 B
|
|
|
1. Excel Shortcuts.srt
|
SRT
|
17.3 KB
|
|
|
1. Formatting data and tables.srt
|
SRT
|
22.9 KB
|
|
|
1. Importing tables from PDF - Excel 2021 and office 365.mp4
|
MP4
|
106.6 MB
|
|
|
1. Importing tables from PDF - Excel 2021 and office 365.srt
|
SRT
|
17.9 KB
|
|
|
1. Income Tax calculation - Slabs based tax.html
|
HTML
|
512 B
|
|
|
1. Infographics 1 Cool charts.mp4
|
MP4
|
149 MB
|
|
|
1. Infographics 1 Cool charts.srt
|
SRT
|
14.2 KB
|
|
|
1. Introduction.mp4
|
MP4
|
18 MB
|
|
|
1. Introduction.srt
|
SRT
|
3.2 KB
|
|
|
1. Lookup Functions.mp4
|
MP4
|
79.3 MB
|
|
|
1. Lookup Functions.srt
|
SRT
|
10.7 KB
|
|
|
1. Macros.mp4
|
MP4
|
80.2 MB
|
|
|
1. Macros.srt
|
SRT
|
13.5 KB
|
|
|
1. Maps chart.mp4
|
MP4
|
65.8 MB
|
|
|
1. Maps chart.srt
|
SRT
|
11.9 KB
|
|
|
1. Mathematical Functions - Part 1.mp4
|
MP4
|
79.1 MB
|
|
|
1. Mathematical Functions - Part 1.srt
|
SRT
|
11.8 KB
|
|
|
1. Named Ranges.mp4
|
MP4
|
63.1 MB
|
|
|
1. Named Ranges.srt
|
SRT
|
9.8 KB
|
|
|
1. Pivot Tables.mp4
|
MP4
|
90.6 MB
|
|
|
1. Pivot Tables.srt
|
SRT
|
10.9 KB
|
|
|
1. The final milestone!.mp4
|
MP4
|
11.9 MB
|
|
|
1. The final milestone!.srt
|
SRT
|
1.7 KB
|
|
|
1. XLookup as a replacement of Vlookup.mp4
|
MP4
|
77.9 MB
|
|
|
1. XLookup as a replacement of Vlookup.srt
|
SRT
|
11.9 KB
|
|
|
1.1 Apple quarterly balance sheet 1.pdf
|
PDF
|
1.4 MB
|
|
|
1.1 Introduction_01.pdf
|
PDF
|
905.1 KB
|
|
|
1.1 Lecture_10_Shortcuts.xlsx
|
XLSX
|
21.4 KB
|
|
|
1.1 Lecture_11_Advance_Analytics.xlsx
|
XLSX
|
20.9 KB
|
|
|
1.1 Lecture_12_Macro.xlsx
|
XLSX
|
13.5 KB
|
|
|
1.1 Lecture_15_Infographics.xlsx
|
XLSX
|
335.8 KB
|
|
|
1.1 Lecture_5_Lookups.xlsx
|
XLSX
|
25.5 KB
|
|
|
1.1 Lecture_6_Data.xlsx
|
XLSX
|
23.1 KB
|
|
|
1.1 Lecture_6_Formatting.xlsx
|
XLSX
|
14.9 KB
|
|
|
1.1 Lecture_8_PivotTables.xlsx
|
XLSX
|
113.4 KB
|
|
|
1.1 Lecture_Maps_Solved.xlsx
|
XLSX
|
8 MB
|
|
|
1.1 Lecture_XLookup_Solved.xlsx
|
XLSX
|
183.8 KB
|
|
|
1.2 Apple quarterly balance sheet.pdf
|
PDF
|
1.4 MB
|
|
|
1.2 Lecture_Maps_Unsolved.xlsx
|
XLSX
|
11.6 KB
|
|
|
1.2 Lecture_XLookup_unsolved.xlsx
|
XLSX
|
169.8 KB
|
|
|
1.3 Apple_PDF_import_solved.xlsx
|
XLSX
|
17.2 KB
|
|
|
1.4 Employee data.pdf
|
PDF
|
198.8 KB
|
|
|
1.5 employee_ctc_pdf_load_solved.xlsx
|
XLSX
|
20.4 KB
|
|
|
10. Exercise 312 Logical Functions.html
|
HTML
|
307.2 B
|
|
|
10.1 Session3_Exercise.xlsx
|
XLSX
|
49.2 KB
|
|
|
10.2 Session3_Solution.xlsx
|
XLSX
|
73.5 KB
|
|
|
11. Date-time (Temporal) Functions.mp4
|
MP4
|
59.9 MB
|
|
|
11. Date-time (Temporal) Functions.srt
|
SRT
|
7.9 KB
|
|
|
11.1 Lecture_4_Dates.xlsx
|
XLSX
|
19.5 KB
|
|
|
12. Exercise 412 Date-Time Functions.html
|
HTML
|
307.2 B
|
|
|
12.1 Session4_Exercise.xlsx
|
XLSX
|
51.2 KB
|
|
|
12.2 Session4_Solution.xlsx
|
XLSX
|
59.4 KB
|
|
|
13. Quiz.html
|
HTML
|
204.8 B
|
|
|
2. Bonus Lecture.html
|
HTML
|
2.3 KB
|
|
|
2. Charts-Part 2.mp4
|
MP4
|
110.9 MB
|
|
|
2. Charts-Part 2.srt
|
SRT
|
16.4 KB
|
|
|
2. Course Resources.html
|
HTML
|
409.6 B
|
|
|
2. Exercise 1012 Shortcuts.html
|
HTML
|
307.2 B
|
|
|
2. Exercise 1112 Analytics.html
|
HTML
|
307.2 B
|
|
|
2. Exercise 1212 Macros.html
|
HTML
|
307.2 B
|
|
|
2. Exercise 512 Lookup Functions.html
|
HTML
|
307.2 B
|
|
|
2. Exercise 612 Data Tools.html
|
HTML
|
307.2 B
|
|
|
2. Exercise 712 Formatting.html
|
HTML
|
307.2 B
|
|
|
2. Exercise 812 Pivot tables.html
|
HTML
|
204.8 B
|
|
|
2. Finding Net Present Value in Excel.mp4
|
MP4
|
73.1 MB
|
|
|
2. Finding Net Present Value in Excel.srt
|
SRT
|
10.7 KB
|
|
|
2. Indirect Functions.mp4
|
MP4
|
35.5 MB
|
|
|
2. Indirect Functions.srt
|
SRT
|
5.1 KB
|
|
|
2
|
|
0 B
|
|
|
2. Handling #NA and Approximates match in Xlookup.mp4
|
MP4
|
122.9 MB
|
|
|
2. Handling #NA and Approximates match in Xlookup.srt
|
SRT
|
15.6 KB
|
|
|
2. Infographics 2 Cool charts.mp4
|
MP4
|
46.2 MB
|
|
|
2. Infographics 2 Cool charts.srt
|
SRT
|
7.9 KB
|
|
|
2. Mathematical Functions - Part 2.mp4
|
MP4
|
64.7 MB
|
|
|
2. Mathematical Functions - Part 2.srt
|
SRT
|
6.6 KB
|
|
|
2.1 Lecture_16_Infographics.xlsx
|
XLSX
|
295.5 KB
|
|
|
2.1 Lecture_9_Charts.xlsx
|
XLSX
|
162.2 KB
|
|
|
2.1 Session10_Exercise.xlsx
|
XLSX
|
8.5 MB
|
|
|
2.1 Session11_Exercise.xlsx
|
XLSX
|
16.8 KB
|
|
|
2.1 Session12_Exercise.xlsx
|
XLSX
|
13.6 KB
|
|
|
2.1 Session5_Exercise.xlsx
|
XLSX
|
272.3 KB
|
|
|
2.1 Session6_Exercise.xlsx
|
XLSX
|
849.4 KB
|
|
|
2.1 Session7_Exercise.xlsx
|
XLSX
|
13.5 KB
|
|
|
2.1 Session8_Exercise.xlsx
|
XLSX
|
173.7 KB
|
|
|
2.2 Session10_Solution.xlsx
|
XLSX
|
8.5 MB
|
|
|
2.2 Session11_Solution.xlsx
|
XLSX
|
23.5 KB
|
|
|
2.2 Session12_Solution.xlsm
|
XLSM
|
23.6 KB
|
|
|
2.2 Session5_Solution.xlsx
|
XLSX
|
421.6 KB
|
|
|
2.2 Session6_Solution.xlsx
|
XLSX
|
3.6 MB
|
|
|
2.2 Session7_Solution.xlsx
|
XLSX
|
14.1 KB
|
|
|
2.2 Session8_Solution.xlsx
|
XLSX
|
294.5 KB
|
|
|
3. Difference between RANK, RANK.AVG and RANK.EQ.html
|
HTML
|
819.2 B
|
|
|
3. Exercise 912 Charts.html
|
HTML
|
307.2 B
|
|
|
3. Quiz.html
|
HTML
|
204.8 B
|
|
|
3. Sensitivity Analysis in Excel.mp4
|
MP4
|
56.5 MB
|
|
|
3. Sensitivity Analysis in Excel.srt
|
SRT
|
7 KB
|
|
|
3. This is a milestone!.mp4
|
MP4
|
20.7 MB
|
|
|
3. This is a milestone!.srt
|
SRT
|
3.8 KB
|
|
|
3. Waterfall chart.mp4
|
MP4
|
95.6 MB
|
|
|
3. Waterfall chart.srt
|
SRT
|
14.2 KB
|
|
|
3. Wildcard matching in XLookup.mp4
|
MP4
|
35.6 MB
|
|
|
3. Wildcard matching in XLookup.srt
|
SRT
|
5.3 KB
|
|
|
3.1 Lecture_14_Ex_Waterfall.xlsx
|
XLSX
|
30.5 KB
|
|
|
3.1 Session9_Exercise.xlsx
|
XLSX
|
25.8 KB
|
|
|
3.2 Session9_Solution.xlsx
|
XLSX
|
67.7 KB
|
|
|
4. Exercise 112 Mathematical Funtions.html
|
HTML
|
307.2 B
|
|
|
4. Quiz.html
|
HTML
|
204.8 B
|
|
|
4. Search modes in XLookup.mp4
|
MP4
|
60 MB
|
|
|
4. Search modes in XLookup.srt
|
SRT
|
6.3 KB
|
|
|
4. Variations in finding customer value.mp4
|
MP4
|
39 MB
|
|
|
4. Variations in finding customer value.srt
|
SRT
|
7.9 KB
|
|
|
4.1 Session1_Exercise.xlsx
|
XLSX
|
64.3 KB
|
|
|
4.2 Session1_Solution.xlsx
|
XLSX
|
111.9 KB
|
|
|
5. Textual Functions - Part 1.mp4
|
MP4
|
66.5 MB
|
|
|
5. Textual Functions - Part 1.srt
|
SRT
|
7.9 KB
|
|
|
5.1 Textual Functions.xlsx
|
XLSX
|
27.9 KB
|
|
|
6. Textual Functions - Part 2.mp4
|
MP4
|
66 MB
|
|
|
6. Textual Functions - Part 2.srt
|
SRT
|
7.7 KB
|
|
|
7. Exercise 212 Textual Functions.html
|
HTML
|
204.8 B
|
|
|
7.1 Session2_Exercise.xlsx
|
XLSX
|
66.2 KB
|
|
|
7.2 Session2_Solution.xlsx
|
XLSX
|
122.8 KB
|
|
|
8. Quiz.html
|
HTML
|
204.8 B
|
|
|
9. Logical Functions.mp4
|
MP4
|
98.3 MB
|
|
|
9. Logical Functions.srt
|
SRT
|
10.8 KB
|
|
|
9.1 Lecture_3_logical.xlsx
|
XLSX
|
23.8 KB
|
|
|
TutsNode.net.txt
|
TXT
|
102.4 B
|
|
|
[TGx]Downloaded from torrentgalaxy.to .txt
|
TXT
|
614.4 B
|
|
|
3
|
|
0 B
|
|
|
4
|
|
0 B
|
|
|
5
|
|
102.4 B
|
|
|
6
|
|
102.4 B
|
|
|
7
|
|
102.4 B
|
|
|
8
|
|
102.4 B
|
|
|
9
|
|
240 KB
|
|
|
10
|
|
410.4 KB
|
|
|
11
|
|
851.4 KB
|
|
|
12
|
|
682 KB
|
|
|
13
|
|
953.9 KB
|
|
|
14
|
|
114.8 KB
|
|
|
15
|
|
907 KB
|
|
|
16
|
|
542.2 KB
|
|
|
17
|
|
996.9 KB
|
|
|
18
|
|
179.2 KB
|
|
|
19
|
|
351.7 KB
|
|
|
20
|
|
934.5 KB
|
|
|
21
|
|
705.6 KB
|
|
|
23
|
|
131.2 KB
|
|
|
24
|
|
538.6 KB
|
|
|
25
|
|
801.3 KB
|
|
|
26
|
|
1.3 KB
|
|
|
27
|
|
390.2 KB
|
|
|
28
|
|
501.8 KB
|
|
|
29
|
|
325.9 KB
|
|
|
30
|
|
990.8 KB
|
|
|
31
|
|
138.9 KB
|
|
|
32
|
|
509.6 KB
|
|
|
33
|
|
517.9 KB
|
|
|
35
|
|
437.8 KB
|
|
|
36
|
|
652.1 KB
|
