|
|
1. Intro to Section 2.mp4
|
MP4
|
3.8 MB
|
|
|
1. Intro to Section 3.mp4
|
MP4
|
2.4 MB
|
|
|
1. Introduction - Course Overview.mp4
|
MP4
|
10.5 MB
|
|
|
1. Section Overview.mp4
|
MP4
|
2.9 MB
|
|
|
10. Q Paste Special.html
|
HTML
|
204.8 B
|
|
|
10. Ratio Analysis.mp4
|
MP4
|
53.3 MB
|
|
|
10. Vlookup, Hlookup.mp4
|
MP4
|
48.2 MB
|
|
|
10.1 3.6 Vlookup, HLookup.xlsx
|
XLSX
|
21.1 KB
|
|
|
10.1 4.7 Ratio analysis.xlsx
|
XLSX
|
20.9 KB
|
|
|
11. Keyboard shortcuts - moving faster in a spreadsheet.mp4
|
MP4
|
25.2 MB
|
|
|
11. Q Lookup functions.html
|
HTML
|
204.8 B
|
|
|
11. Ratio Analysis part 2.mp4
|
MP4
|
18 MB
|
|
|
11.1 2.7 Moving faster, shortcuts.xlsx
|
XLSX
|
14.2 KB
|
|
|
11.1 4.8 ratio analysis part 2.xlsx
|
XLSX
|
13.3 KB
|
|
|
11.2 Excel Shortcuts.pdf
|
PDF
|
98.7 KB
|
|
|
11.3 Find more shortcuts at Microsoft Support page.html
|
HTML
|
204.8 B
|
|
|
12. Index & Match.mp4
|
MP4
|
59.9 MB
|
|
|
12. Macros.mp4
|
MP4
|
23.6 MB
|
|
|
12. Regression Analysis.mp4
|
MP4
|
31.6 MB
|
|
|
12.1 2.8 macros.xlsx
|
XLSX
|
11.5 KB
|
|
|
12.1 3.7 index, match.xlsx
|
XLSX
|
29 KB
|
|
|
12.1 4.9 Regression Analysis.xlsx
|
XLSX
|
13.4 KB
|
|
|
13. Q IndexMatch.html
|
HTML
|
204.8 B
|
|
|
13. Q Macros.html
|
HTML
|
204.8 B
|
|
|
13. Regression Analysis Part 2.mp4
|
MP4
|
39.4 MB
|
|
|
13.1 4.10 Regression Analysis part 2.xlsx
|
XLSX
|
16.1 KB
|
|
|
14. Correlation.mp4
|
MP4
|
24.3 MB
|
|
|
14. Goal Seek.mp4
|
MP4
|
15.6 MB
|
|
|
14. Text to column, transpose function.mp4
|
MP4
|
14.8 MB
|
|
|
14.1 2.9 text to column.xlsx
|
XLSX
|
10.8 KB
|
|
|
14.1 3.8 goal seek.xlsx
|
XLSX
|
24.5 KB
|
|
|
14.1 4.11 Correlation.xlsx
|
XLSX
|
18.2 KB
|
|
|
15. Creating lists and dropdown menu.mp4
|
MP4
|
17.4 MB
|
|
|
15. Pivot Table.mp4
|
MP4
|
47.2 MB
|
|
|
15. Stock pick - Analysis.mp4
|
MP4
|
28.5 MB
|
|
|
15.1 2.10 creating lists, dropdown menu.xlsx
|
XLSX
|
15.4 KB
|
|
|
15.1 3.9 pivot table.xlsx
|
XLSX
|
24.7 KB
|
|
|
15.1 4.13 Fundamental analysis - Stock picking.xlsx
|
XLSX
|
10.5 KB
|
|
|
16. Q Pivot.html
|
HTML
|
204.8 B
|
|
|
16. Text wrap and Line break.mp4
|
MP4
|
15.7 MB
|
|
|
16.1 2.11 wrap text.xlsx
|
XLSX
|
14.2 KB
|
|
|
17. Choose Function helps you navigate between different scenarios.mp4
|
MP4
|
14.2 MB
|
|
|
17. Q Line break.html
|
HTML
|
204.8 B
|
|
|
17.1 3.10 choose.xlsx
|
XLSX
|
12.5 KB
|
|
|
18. Hyperlinks.mp4
|
MP4
|
11.4 MB
|
|
|
18. Min, Max.mp4
|
MP4
|
5.8 MB
|
|
|
18.1 2.12 hyperlinks.xlsx
|
XLSX
|
27.3 KB
|
|
|
18.1 3.11 Min, Max.xlsx
|
XLSX
|
11.9 KB
|
|
|
19. Conditional Formatting.mp4
|
MP4
|
59.5 MB
|
|
|
19. Starting each formula with equal or plus sign.mp4
|
MP4
|
5.6 MB
|
|
|
19.1 2.13 equals or plus.xlsx
|
XLSX
|
10.3 KB
|
|
|
19.1 3.12 conditional formatting.xlsx
|
XLSX
|
47 KB
|
|
|
2. Course Resources - How to Use it.mp4
|
MP4
|
7 MB
|
|
|
2. Discounted Cash Flow - NPV.mp4
|
MP4
|
28.2 MB
|
|
|
2. Inserting, deleting, modifying rows and columns.mp4
|
MP4
|
16.4 MB
|
|
|
2. Sum, SumIF, SumIFS.mp4
|
MP4
|
39.1 MB
|
|
|
2.1 2.2 inserting, deleting, modifying rows and columns.xlsx
|
XLSX
|
11.6 KB
|
|
|
2.1 3.1. sum, sumif, sumifs.xlsx
|
XLSX
|
19.7 KB
|
|
|
2.1 4.01 DCF analysis.xlsx
|
XLSX
|
12.3 KB
|
|
|
20. Freeze panes.mp4
|
MP4
|
23.5 MB
|
|
|
20. Q Cond. Formatting.html
|
HTML
|
204.8 B
|
|
|
20.1 2.14 freeze panes.xlsx
|
XLSX
|
23.4 KB
|
|
|
21. Absolute & Relative References.mp4
|
MP4
|
17.6 MB
|
|
|
21. Q Freeze panes.html
|
HTML
|
204.8 B
|
|
|
21.1 3.13 absolute and relative reference.xlsx
|
XLSX
|
14.9 KB
|
|
|
22. How to print Set print area.mp4
|
MP4
|
14.4 MB
|
|
|
22. Working with Charts.mp4
|
MP4
|
46.5 MB
|
|
|
22.1 2.15 print area.xlsx
|
XLSX
|
33.6 KB
|
|
|
22.1 3.14 working with charts.xlsx
|
XLSX
|
30.9 KB
|
|
|
23. Finding templates in Excel.mp4
|
MP4
|
6.3 MB
|
|
|
23. Working with Charts Secondary Axis, Sparklines, WaterfallBridge Charts.mp4
|
MP4
|
56.9 MB
|
|
|
23.1 3.14 working with charts part 2.xlsx
|
XLSX
|
43.7 KB
|
|
|
24. Excel Basics Quiz.html
|
HTML
|
204.8 B
|
|
|
24. Find and Replace.mp4
|
MP4
|
11.9 MB
|
|
|
24.1 3.15 find and replace.xlsx
|
XLSX
|
12.7 KB
|
|
|
25. Date Function.mp4
|
MP4
|
30 MB
|
|
|
25.1 3.16 date function.xlsx
|
XLSX
|
24.1 KB
|
|
|
26. Section Quiz.html
|
HTML
|
204.8 B
|
|
|
3. Formatting cells.mp4
|
MP4
|
19.1 MB
|
|
|
3. MS Excel Basics.mp4
|
MP4
|
22 MB
|
|
|
3. Q NPV.html
|
HTML
|
204.8 B
|
|
|
3. Q Sum.html
|
HTML
|
204.8 B
|
|
|
3.1 2.3 formatting cells.xlsx
|
XLSX
|
11.4 KB
|
|
|
3.1 Spreasheet basics.pdf
|
PDF
|
97 KB
|
|
|
4. Basic Excel Formulas.mp4
|
MP4
|
20.2 MB
|
|
|
4. Count, CountIF, CountIFS, CountA.mp4
|
MP4
|
36.4 MB
|
|
|
4. Dividend Discount Model.mp4
|
MP4
|
44.2 MB
|
|
|
4. Q formatting.html
|
HTML
|
204.8 B
|
|
|
4.1 1.5 Basic formulas in excel.xlsx
|
XLSX
|
12.1 KB
|
|
|
4.1 3.2 count, count if, countifs.xlsx
|
XLSX
|
13.3 KB
|
|
|
4.1 4.2 stock valuation - dividend discount model.xlsx
|
XLSX
|
11.3 KB
|
|
|
5. Formatting Spreadsheets.mp4
|
MP4
|
49 MB
|
|
|
5. Internal Rate of Return - IRR.mp4
|
MP4
|
16.4 MB
|
|
|
5. Intro to Excel Functions.mp4
|
MP4
|
11.9 MB
|
|
|
5. Q Count.html
|
HTML
|
204.8 B
|
|
|
5.1 1.6 intro to functions.xlsx
|
XLSX
|
11.3 KB
|
|
|
5.1 2.4 formatting spreadsheet.xlsx
|
XLSX
|
20.9 KB
|
|
|
5.1 4.4 IRR.xlsx
|
XLSX
|
12.8 KB
|
|
|
6. Average, AverageIF, AverageIFS.mp4
|
MP4
|
25.3 MB
|
|
|
6. Q IRR.html
|
HTML
|
204.8 B
|
|
|
6. Q2 formatting.html
|
HTML
|
204.8 B
|
|
|
6. Section 1 Quiz.html
|
HTML
|
204.8 B
|
|
|
6.1 3.3 average.xlsx
|
XLSX
|
20.4 KB
|
|
|
7. Cut, copy, paste.mp4
|
MP4
|
12.2 MB
|
|
|
7. Left, Right, Mid, Upper, Lower, Proper, Concatenate.mp4
|
MP4
|
31 MB
|
|
|
7. PMT Function - Loan Schedule.mp4
|
MP4
|
30.8 MB
|
|
|
7.1 2.5 cut, copy, paste.xlsx
|
XLSX
|
11.1 KB
|
|
|
7.1 3.4 left, right, mid, upper, lower.xlsx
|
XLSX
|
19.1 KB
|
|
|
7.1 4.5 PMT function, Loan Schedule.xlsx
|
XLSX
|
31.1 KB
|
|
|
8. Q CopyPaste.html
|
HTML
|
204.8 B
|
|
|
8. Q LeftRightMidUpper.html
|
HTML
|
204.8 B
|
|
|
8. Q PMT.html
|
HTML
|
204.8 B
|
|
|
9. IF Function.mp4
|
MP4
|
59 MB
|
|
|
9. Paste Special, copying formulas.mp4
|
MP4
|
26.4 MB
|
|
|
9. Scenario and Sensitivity Analysis - Data Table.mp4
|
MP4
|
81.2 MB
|
|
|
9.1 2.6 Paste special.xlsx
|
XLSX
|
14.7 KB
|
|
|
9.1 3.5 IF Function.xlsx
|
XLSX
|
15.6 KB
|
|
|
9.1 4.6 Data Table, Sensitivity, Scenario Analysis.xlsx
|
XLSX
|
23.7 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
