|
|
1. Average and Average If Function.mp4
|
MP4
|
61.9 MB
|
|
|
1. Average and Average If Function.srt
|
SRT
|
11.2 KB
|
|
|
1. Entering a Formula.mp4
|
MP4
|
49 MB
|
|
|
1. Entering a Formula.srt
|
SRT
|
8.4 KB
|
|
|
1. Introduction to Excel reports.mp4
|
MP4
|
90.8 MB
|
|
|
1. Introduction to Excel reports.srt
|
SRT
|
15 KB
|
|
|
1. PMT Financial Function.mp4
|
MP4
|
41.1 MB
|
|
|
1. PMT Financial Function.srt
|
SRT
|
6.5 KB
|
|
|
1. Shortcut Key Function - F6.mp4
|
MP4
|
85.4 MB
|
|
|
1. Shortcut Key Function - F6.srt
|
SRT
|
10.7 KB
|
|
|
1. Vertical Lookups (v LOOKUPS).mp4
|
MP4
|
46.3 MB
|
|
|
1. Vertical Lookups (v LOOKUPS).srt
|
SRT
|
7.6 KB
|
|
|
10. Average Counting Blank and Non Blank.mp4
|
MP4
|
67.5 MB
|
|
|
10. Average Counting Blank and Non Blank.srt
|
SRT
|
11.8 KB
|
|
|
10. INT and TRUNC Function.mp4
|
MP4
|
47.1 MB
|
|
|
10. INT and TRUNC Function.srt
|
SRT
|
8.9 KB
|
|
|
11. Offset and Concat Function in Excel.mp4
|
MP4
|
66.5 MB
|
|
|
11. Offset and Concat Function in Excel.srt
|
SRT
|
12.1 KB
|
|
|
12. Relative Reference in Excel.mp4
|
MP4
|
36.7 MB
|
|
|
12. Relative Reference in Excel.srt
|
SRT
|
6.7 KB
|
|
|
13. Absolute and Mixed Reference in Excel.mp4
|
MP4
|
63.4 MB
|
|
|
13. Absolute and Mixed Reference in Excel.srt
|
SRT
|
10 KB
|
|
|
14. Logically if Function in Excel.mp4
|
MP4
|
37.6 MB
|
|
|
14. Logically if Function in Excel.srt
|
SRT
|
7.9 KB
|
|
|
15. Logically AND & OR Function in Excel.mp4
|
MP4
|
54.8 MB
|
|
|
15. Logically AND & OR Function in Excel.srt
|
SRT
|
9.8 KB
|
|
|
16. Nested if and Switch Function.mp4
|
MP4
|
44.7 MB
|
|
|
16. Nested if and Switch Function.srt
|
SRT
|
10.2 KB
|
|
|
17. Example of Logical Function.mp4
|
MP4
|
76.1 MB
|
|
|
17. Example of Logical Function.srt
|
SRT
|
13.6 KB
|
|
|
18. Basic of Date and Time Format.mp4
|
MP4
|
76.4 MB
|
|
|
18. Basic of Date and Time Format.srt
|
SRT
|
14.3 KB
|
|
|
19. Dated if and Weekday Function.mp4
|
MP4
|
40.9 MB
|
|
|
19. Dated if and Weekday Function.srt
|
SRT
|
8.8 KB
|
|
|
2. Entering a Function.mp4
|
MP4
|
36.3 MB
|
|
|
2. Entering a Function.srt
|
SRT
|
6.6 KB
|
|
|
2. Horizontal Lookups (H Lookups).mp4
|
MP4
|
61 MB
|
|
|
2. Horizontal Lookups (H Lookups).srt
|
SRT
|
8.1 KB
|
|
|
2. Loan with Different Terms.mp4
|
MP4
|
38.3 MB
|
|
|
2. Loan with Different Terms.srt
|
SRT
|
7.1 KB
|
|
|
2. Random Number and rank Function.mp4
|
MP4
|
36.1 MB
|
|
|
2. Random Number and rank Function.srt
|
SRT
|
7.4 KB
|
|
|
2. Shortcut Key Function - F10.mp4
|
MP4
|
55.5 MB
|
|
|
2. Shortcut Key Function - F10.srt
|
SRT
|
8.3 KB
|
|
|
20. Network Day Function.mp4
|
MP4
|
50 MB
|
|
|
20. Network Day Function.srt
|
SRT
|
9.1 KB
|
|
|
21. Work Day Function.mp4
|
MP4
|
35.6 MB
|
|
|
21. Work Day Function.srt
|
SRT
|
7.5 KB
|
|
|
22. Example of Date and Time Function.mp4
|
MP4
|
50.6 MB
|
|
|
22. Example of Date and Time Function.srt
|
SRT
|
8.1 KB
|
|
|
23. String Concentration Function.mp4
|
MP4
|
75.4 MB
|
|
|
23. String Concentration Function.srt
|
SRT
|
16.1 KB
|
|
|
24. Upper and Lower Function.mp4
|
MP4
|
48.3 MB
|
|
|
24. Upper and Lower Function.srt
|
SRT
|
9.6 KB
|
|
|
25. Lenth of the Function.mp4
|
MP4
|
51.2 MB
|
|
|
25. Lenth of the Function.srt
|
SRT
|
8.4 KB
|
|
|
26. Trim and Clean Function.mp4
|
MP4
|
68.7 MB
|
|
|
26. Trim and Clean Function.srt
|
SRT
|
14.2 KB
|
|
|
27. Search and Concat Function.mp4
|
MP4
|
68.9 MB
|
|
|
27. Search and Concat Function.srt
|
SRT
|
11.5 KB
|
|
|
3. Formatting Text and Numbers.mp4
|
MP4
|
65.1 MB
|
|
|
3. Formatting Text and Numbers.srt
|
SRT
|
8.4 KB
|
|
|
3. Loan with Different Terms Continues.mp4
|
MP4
|
48.6 MB
|
|
|
3. Loan with Different Terms Continues.srt
|
SRT
|
7.2 KB
|
|
|
3. Match Function.mp4
|
MP4
|
80.3 MB
|
|
|
3. Match Function.srt
|
SRT
|
13.8 KB
|
|
|
3. Operator Precedence.mp4
|
MP4
|
75.7 MB
|
|
|
3. Operator Precedence.srt
|
SRT
|
13 KB
|
|
|
3. Random Number and rank Function.mp4
|
MP4
|
36.1 MB
|
|
|
3. Random Number and rank Function.srt
|
SRT
|
6.6 KB
|
|
|
4. F2 and Shit Plus F2.mp4
|
MP4
|
83.9 MB
|
|
|
4. F2 and Shit Plus F2.srt
|
SRT
|
11 KB
|
|
|
4. Left V Lookups.mp4
|
MP4
|
71.3 MB
|
|
|
4. Left V Lookups.srt
|
SRT
|
11.6 KB
|
|
|
4. Name and Formula in Excel.mp4
|
MP4
|
74 MB
|
|
|
4. Name and Formula in Excel.srt
|
SRT
|
14.2 KB
|
|
|
4. PPMT and IPMT.mp4
|
MP4
|
33.9 MB
|
|
|
4. PPMT and IPMT.srt
|
SRT
|
5.6 KB
|
|
|
4. Random Number and rank Function Continues.mp4
|
MP4
|
54 MB
|
|
|
4. Random Number and rank Function Continues.srt
|
SRT
|
8.6 KB
|
|
|
5. CTRL Plus Apostrophe.mp4
|
MP4
|
78 MB
|
|
|
5. CTRL Plus Apostrophe.srt
|
SRT
|
10.4 KB
|
|
|
5. Count functions in Excel.mp4
|
MP4
|
40.8 MB
|
|
|
5. Count functions in Excel.srt
|
SRT
|
6.7 KB
|
|
|
5. Example of PPMT and IPMT.mp4
|
MP4
|
63.6 MB
|
|
|
5. Example of PPMT and IPMT.srt
|
SRT
|
5.6 KB
|
|
|
5. Percentile and Quadrilles.mp4
|
MP4
|
83.3 MB
|
|
|
5. Percentile and Quadrilles.srt
|
SRT
|
14.4 KB
|
|
|
5. Tow Ways Lookup.mp4
|
MP4
|
62 MB
|
|
|
5. Tow Ways Lookup.srt
|
SRT
|
9 KB
|
|
|
6. CTRL Plus Shift Plus Tilde.mp4
|
MP4
|
84.1 MB
|
|
|
6. CTRL Plus Shift Plus Tilde.srt
|
SRT
|
10.9 KB
|
|
|
6. Round and Even Odd Function.mp4
|
MP4
|
47.5 MB
|
|
|
6. Round and Even Odd Function.srt
|
SRT
|
9.9 KB
|
|
|
6. Sum Functions in Excel.mp4
|
MP4
|
49.8 MB
|
|
|
6. Sum Functions in Excel.srt
|
SRT
|
6.8 KB
|
|
|
6. Tow Ways Lookup Continues.mp4
|
MP4
|
73.7 MB
|
|
|
6. Tow Ways Lookup Continues.srt
|
SRT
|
12.6 KB
|
|
|
7. Example of Lookups.mp4
|
MP4
|
62.2 MB
|
|
|
7. Example of Lookups.srt
|
SRT
|
10.5 KB
|
|
|
7. More in Count Functions in Excel.mp4
|
MP4
|
39.3 MB
|
|
|
7. More in Count Functions in Excel.srt
|
SRT
|
7.2 KB
|
|
|
7. Trendline and Trend Analysis.mp4
|
MP4
|
49.2 MB
|
|
|
7. Trendline and Trend Analysis.srt
|
SRT
|
8.9 KB
|
|
|
8. Counts of Logical Values in Excel.mp4
|
MP4
|
40.7 MB
|
|
|
8. Counts of Logical Values in Excel.srt
|
SRT
|
6.7 KB
|
|
|
8. Trendline and Trend Analysis Continues.mp4
|
MP4
|
59.2 MB
|
|
|
8. Trendline and Trend Analysis Continues.srt
|
SRT
|
8.1 KB
|
|
|
9. Round up and Round Down Function.mp4
|
MP4
|
31.5 MB
|
|
|
9. Round up and Round Down Function.srt
|
SRT
|
7.1 KB
|
|
|
9. Sum Product Function in Excel.mp4
|
MP4
|
49.8 MB
|
|
|
9. Sum Product Function in Excel.srt
|
SRT
|
6.8 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
