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