| 1. Intro to Section 2.mp4 | 3.8 MB | ||
| 1. Intro to Section 3.mp4 | 2.4 MB | ||
| 1. Introduction - Course Overview.mp4 | 10.5 MB | ||
| 1. Section Overview.mp4 | 2.9 MB | ||
| 10. Q Paste Special.html | 204.8 B | ||
| 10. Ratio Analysis.mp4 | 53.3 MB | ||
| 10. Vlookup, Hlookup.mp4 | 48.2 MB | ||
| 10.1 3.6 Vlookup, HLookup.xlsx | 21.1 KB | ||
| 10.1 4.7 Ratio analysis.xlsx | 20.9 KB | ||
| 11. Keyboard shortcuts - moving faster in a spreadsheet.mp4 | 25.2 MB | ||
| 11. Q Lookup functions.html | 204.8 B | ||
| 11. Ratio Analysis part 2.mp4 | 18 MB | ||
| 11.1 2.7 Moving faster, shortcuts.xlsx | 14.2 KB | ||
| 11.1 4.8 ratio analysis part 2.xlsx | 13.3 KB | ||
| 11.2 Excel Shortcuts.pdf | 98.7 KB | ||
| 11.3 Find more shortcuts at Microsoft Support page.html | 204.8 B | ||
| 12. Index & Match.mp4 | 59.9 MB | ||
| 12. Macros.mp4 | 23.6 MB | ||
| 12. Regression Analysis.mp4 | 31.6 MB | ||
| 12.1 2.8 macros.xlsx | 11.5 KB | ||
| 12.1 3.7 index, match.xlsx | 29 KB | ||
| 12.1 4.9 Regression Analysis.xlsx | 13.4 KB | ||
| 13. Q IndexMatch.html | 204.8 B | ||
| 13. Q Macros.html | 204.8 B | ||
| 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. Goal Seek.mp4 | 15.6 MB | ||
| 14. Text to column, transpose function.mp4 | 14.8 MB | ||
| 14.1 2.9 text to column.xlsx | 10.8 KB | ||
| 14.1 3.8 goal seek.xlsx | 24.5 KB | ||
| 14.1 4.11 Correlation.xlsx | 18.2 KB | ||
| 15. Creating lists and dropdown menu.mp4 | 17.4 MB | ||
| 15. Pivot Table.mp4 | 47.2 MB | ||
| 15. Stock pick - Analysis.mp4 | 28.5 MB | ||
| 15.1 2.10 creating lists, dropdown menu.xlsx | 15.4 KB | ||
| 15.1 3.9 pivot table.xlsx | 24.7 KB | ||
| 15.1 4.13 Fundamental analysis - Stock picking.xlsx | 10.5 KB | ||
| 16. Q Pivot.html | 204.8 B | ||
| 16. Text wrap and Line break.mp4 | 15.7 MB | ||
| 16.1 2.11 wrap text.xlsx | 14.2 KB | ||
| 17. Choose Function helps you navigate between different scenarios.mp4 | 14.2 MB | ||
| 17. Q Line break.html | 204.8 B | ||
| 17.1 3.10 choose.xlsx | 12.5 KB | ||
| 18. Hyperlinks.mp4 | 11.4 MB | ||
| 18. Min, Max.mp4 | 5.8 MB | ||
| 18.1 2.12 hyperlinks.xlsx | 27.3 KB | ||
| 18.1 3.11 Min, Max.xlsx | 11.9 KB | ||
| 19. Conditional Formatting.mp4 | 59.5 MB | ||
| 19. Starting each formula with equal or plus sign.mp4 | 5.6 MB | ||
| 19.1 2.13 equals or plus.xlsx | 10.3 KB | ||
| 19.1 3.12 conditional formatting.xlsx | 47 KB | ||
| 2. Course Resources - How to Use it.mp4 | 7 MB | ||
| 2. Discounted Cash Flow - NPV.mp4 | 28.2 MB | ||
| 2. Inserting, deleting, modifying rows and columns.mp4 | 16.4 MB | ||
| 2. Sum, SumIF, SumIFS.mp4 | 39.1 MB | ||
| 2.1 2.2 inserting, deleting, modifying rows and columns.xlsx | 11.6 KB | ||
| 2.1 3.1. sum, sumif, sumifs.xlsx | 19.7 KB | ||
| 2.1 4.01 DCF analysis.xlsx | 12.3 KB | ||
| 20. Freeze panes.mp4 | 23.5 MB | ||
| 20. Q Cond. Formatting.html | 204.8 B | ||
| 20.1 2.14 freeze panes.xlsx | 23.4 KB | ||
| 21. Absolute & Relative References.mp4 | 17.6 MB | ||
| 21. Q Freeze panes.html | 204.8 B | ||
| 21.1 3.13 absolute and relative reference.xlsx | 14.9 KB | ||
| 22. How to print Set print area.mp4 | 14.4 MB | ||
| 22. Working with Charts.mp4 | 46.5 MB | ||
| 22.1 2.15 print area.xlsx | 33.6 KB | ||
| 22.1 3.14 working with charts.xlsx | 30.9 KB | ||
| 23. Finding templates in Excel.mp4 | 6.3 MB | ||
| 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. Excel Basics Quiz.html | 204.8 B | ||
| 24. Find and Replace.mp4 | 11.9 MB | ||
| 24.1 3.15 find and replace.xlsx | 12.7 KB | ||
| 25. Date Function.mp4 | 30 MB | ||
| 25.1 3.16 date function.xlsx | 24.1 KB | ||
| 26. Section Quiz.html | 204.8 B | ||
| 3. Formatting cells.mp4 | 19.1 MB | ||
| 3. MS Excel Basics.mp4 | 22 MB | ||
| 3. Q NPV.html | 204.8 B | ||
| 3. Q Sum.html | 204.8 B | ||
| 3.1 2.3 formatting cells.xlsx | 11.4 KB | ||
| 3.1 Spreasheet basics.pdf | 97 KB | ||
| 4. Basic Excel Formulas.mp4 | 20.2 MB | ||
| 4. Count, CountIF, CountIFS, CountA.mp4 | 36.4 MB | ||
| 4. Dividend Discount Model.mp4 | 44.2 MB | ||
| 4. Q formatting.html | 204.8 B | ||
| 4.1 1.5 Basic formulas in excel.xlsx | 12.1 KB | ||
| 4.1 3.2 count, count if, countifs.xlsx | 13.3 KB | ||
| 4.1 4.2 stock valuation - dividend discount model.xlsx | 11.3 KB | ||
| 5. Formatting Spreadsheets.mp4 | 49 MB | ||
| 5. Internal Rate of Return - IRR.mp4 | 16.4 MB | ||
| 5. Intro to Excel Functions.mp4 | 11.9 MB | ||
| 5. Q Count.html | 204.8 B | ||
| 5.1 1.6 intro to functions.xlsx | 11.3 KB | ||
| 5.1 2.4 formatting spreadsheet.xlsx | 20.9 KB | ||
| 5.1 4.4 IRR.xlsx | 12.8 KB | ||
| 6. Average, AverageIF, AverageIFS.mp4 | 25.3 MB | ||
| 6. Q IRR.html | 204.8 B | ||
| 6. Q2 formatting.html | 204.8 B | ||
| 6. Section 1 Quiz.html | 204.8 B | ||
| 6.1 3.3 average.xlsx | 20.4 KB | ||
| 7. Cut, copy, paste.mp4 | 12.2 MB | ||
| 7. Left, Right, Mid, Upper, Lower, Proper, Concatenate.mp4 | 31 MB | ||
| 7. PMT Function - Loan Schedule.mp4 | 30.8 MB | ||
| 7.1 2.5 cut, copy, paste.xlsx | 11.1 KB | ||
| 7.1 3.4 left, right, mid, upper, lower.xlsx | 19.1 KB | ||
| 7.1 4.5 PMT function, Loan Schedule.xlsx | 31.1 KB | ||
| 8. Q CopyPaste.html | 204.8 B | ||
| 8. Q LeftRightMidUpper.html | 204.8 B | ||
| 8. Q PMT.html | 204.8 B | ||
| 9. IF Function.mp4 | 59 MB | ||
| 9. Paste Special, copying formulas.mp4 | 26.4 MB | ||
| 9. Scenario and Sensitivity Analysis - Data Table.mp4 | 81.2 MB | ||
| 9.1 2.6 Paste special.xlsx | 14.7 KB | ||
| 9.1 3.5 IF Function.xlsx | 15.6 KB | ||
| 9.1 4.6 Data Table, Sensitivity, Scenario Analysis.xlsx | 23.7 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 120 total files | |||
Learn MS Excel and Data Analysis
https://DevCourseWeb.com
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.33 GB | Duration: 3h 1m
Master Essential Excel Formulas and Analyze Financials Like a Pro
What you'll learn
Use Excel for Personal Finances
Use Excel for Stock Analysis
Calculate and Use Basic Excel Functions
Calculate and Use Advanced Excel Functions
Analyze Data in Excel
Create Pivot Tables
Excel Features
Lifetime Access to Excel Course + Quizzes & Worksheets
Analyze Financial Statements
Perform Business Analysis
Description
This course is designed with the Excel power user in mind. No prior knowledge of VLOOKUP, IF statements, PivotTables, Sensitivity Analysis, or other such formulas is required -- my goal is to teach you how to solve business problems in Excel.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 14.63 GB | Metodone | 2 days | 12 | 5 | |
| 836.1 MB | freecoursewb | 1 week | 102 | 25 | |
| 1.3 GB | freecoursewb | 1 week | 28 | 9 | |
| 1.1 GB | freecoursewb | 1 week | 0 | 0 | |
| 1.9 GB | freecoursewb | 1 week | 1 | 30 |
All Comments