| 1. Course Promo Video.mp4 | 40.7 MB | ||
| 1. Course Promo Video.srt | 3.1 KB | ||
| 1. Introduction.mp4 | 3.7 MB | ||
| 1. Introduction.srt | 819.2 B | ||
| 1. Loan Amortization Schedule.mp4 | 101.8 MB | ||
| 1. Loan Amortization Schedule.srt | 18 KB | ||
| 1. Macros for Task Automation.mp4 | 52 MB | ||
| 1. Macros for Task Automation.srt | 9.9 KB | ||
| 1.1 Financial Export.xlsx | 9.4 KB | ||
| 1.1 Section 10 Workbook.xlsx | 50.4 KB | ||
| 1.2 Section 9 Workbook.xlsm | 12 KB | ||
| 10. INDEXMATCH Financial Statement Example.mp4 | 29.5 MB | ||
| 10. INDEXMATCH Financial Statement Example.srt | 5.4 KB | ||
| 11. OFFSET Basics.mp4 | 14.5 MB | ||
| 11. OFFSET Basics.srt | 4.2 KB | ||
| 11.1 OFFSET Exercise.xlsx | 17.7 KB | ||
| 12. OFFSET Dynamic Example.mp4 | 24.9 MB | ||
| 12. OFFSET Dynamic Example.srt | 4.8 KB | ||
| 2. Conditional Formatting Basics.mp4 | 29.6 MB | ||
| 2. Conditional Formatting Basics.srt | 7.3 KB | ||
| 2. Efficient Movement.mp4 | 41.7 MB | ||
| 2. Efficient Movement.srt | 7.2 KB | ||
| 2. Financial Calculator Functions.mp4 | 23.4 MB | ||
| 2. Financial Calculator Functions.srt | 7.3 KB | ||
| 2. IF.mp4 | 18.9 MB | ||
| 2. IF.srt | 4.6 KB | ||
| 2. Keyboard Shortcuts Basics.mp4 | 52.9 MB | ||
| 2. Keyboard Shortcuts Basics.srt | 10.2 KB | ||
| 2. MATCH.mp4 | 19.8 MB | ||
| 2. MATCH.srt | 3.3 KB | ||
| 2. Pivot Tables.mp4 | 38.9 MB | ||
| 2. Pivot Tables.srt | 7.9 KB | ||
| 2. SUMIF.mp4 | 51.5 MB | ||
| 2. SUMIF.srt | 9.1 KB | ||
| 2. Thank You.mp4 | 2.9 MB | ||
| 2. Thank You.srt | 1.2 KB | ||
| 2. What You'll Learn.mp4 | 18.7 MB | ||
| 2. What You'll Learn.srt | 4.2 KB | ||
| 2.1 Keyboard Shortcuts.pdf | 88.9 KB | ||
| 2.1 Section 1 Workbook.xlsx | 56.4 KB | ||
| 2.1 Section 3 Workbook.xlsx | 25.6 KB | ||
| 2.1 Section 4 Workbook.xlsx | 17.4 KB | ||
| 2.1 Section 5 Workbook.xlsx | 20.1 KB | ||
| 2.1 Section 6 Workbook.xlsx | 23.8 KB | ||
| 2.1 Section 7 Workbook.xlsx | 15.6 KB | ||
| 2.1 Section 8 Workbook.xlsx | 24 KB | ||
| 2.2 Section 2 Workbook.xlsx | 17.4 KB | ||
| 3. CF Balance Sheet Exercise.mp4 | 12.8 MB | ||
| 3. CF Balance Sheet Exercise.srt | 2.4 KB | ||
| 3. Efficient Screen Setup.mp4 | 50.3 MB | ||
| 3. Efficient Screen Setup.srt | 6.4 KB | ||
| 3. Formatting Rows & Columns.mp4 | 34.8 MB | ||
| 3. Formatting Rows & Columns.srt | 6.2 KB | ||
| 3. Instructor Bio.mp4 | 14 MB | ||
| 3. Instructor Bio.srt | 4.4 KB | ||
| 3. Nested IF Statements.mp4 | 42.4 MB | ||
| 3. Nested IF Statements.srt | 9.1 KB | ||
| 3. Net Present Value (NPV).mp4 | 18.7 MB | ||
| 3. Net Present Value (NPV).srt | 4.4 KB | ||
| 3. SUMIFS.mp4 | 29.6 MB | ||
| 3. SUMIFS.srt | 4.6 KB | ||
| 3. VLOOKUP.mp4 | 40.7 MB | ||
| 3. VLOOKUP.srt | 6 KB | ||
| 3. What If Sensitivity Anaysis.mp4 | 45.7 MB | ||
| 3. What If Sensitivity Anaysis.srt | 8.7 KB | ||
| 4. Anchoring (F4).mp4 | 35.9 MB | ||
| 4. Anchoring (F4).srt | 6.8 KB | ||
| 4. CF Dynamic Receivables Exercise.mp4 | 46.8 MB | ||
| 4. CF Dynamic Receivables Exercise.srt | 6.5 KB | ||
| 4. IFS.mp4 | 28.1 MB | ||
| 4. IFS.srt | 5.3 KB | ||
| 4. Internal Rate of Return (IRR).mp4 | 17 MB | ||
| 4. Internal Rate of Return (IRR).srt | 4.2 KB | ||
| 4. Legal Disclaimer.mp4 | 15.9 MB | ||
| 4. SUMIF in Financial Statements.mp4 | 30.2 MB | ||
| 4. SUMIF in Financial Statements.srt | 4.2 KB | ||
| 4. Solver.mp4 | 25.2 MB | ||
| 4. Solver.srt | 4.8 KB | ||
| 4. Sort & Filter.mp4 | 23.3 MB | ||
| 4. Sort & Filter.srt | 4 KB | ||
| 4. VLOOKUP MATCH.mp4 | 34.3 MB | ||
| 4. VLOOKUP MATCH.srt | 4.4 KB | ||
| 5. COUNTIF and COUNTA.mp4 | 31.2 MB | ||
| 5. COUNTIF and COUNTA.srt | 4.8 KB | ||
| 5. Capital Budgeting Exercise.mp4 | 91.2 MB | ||
| 5. Capital Budgeting Exercise.srt | 15.5 KB | ||
| 5. Cell Formatting.mp4 | 19.4 MB | ||
| 5. Cell Formatting.srt | 3.3 KB | ||
| 5. OR AND.mp4 | 36.3 MB | ||
| 5. OR AND.srt | 7.4 KB | ||
| 5. VLOOKUP Range Lookup.mp4 | 44 MB | ||
| 5. VLOOKUP Range Lookup.srt | 5.1 KB | ||
| 6. Custom Formatting.mp4 | 23.7 MB | ||
| 6. Custom Formatting.srt | 3.6 KB | ||
| 6. HLOOKUP.mp4 | 24.2 MB | ||
| 6. HLOOKUP.srt | 4 KB | ||
| 6. IFERROR.mp4 | 33.6 MB | ||
| 6. IFERROR.srt | 6.8 KB | ||
| 6. Rounding Functions.mp4 | 17.6 MB | ||
| 6. Rounding Functions.srt | 4.7 KB | ||
| 6.1 OFFSET Example.xlsx | 20.8 KB | ||
| 7. XLOOKUP.mp4 | 40.3 MB | ||
| 7. XLOOKUP.srt | 5.4 KB | ||
| 8. INDEXMATCH Basics.mp4 | 37.8 MB | ||
| 8. INDEXMATCH Basics.srt | 7.1 KB | ||
| 9. INDEXMATCH Auto Inventory Example.mp4 | 23.4 MB | ||
| 9. INDEXMATCH Auto Inventory Example.srt | 3.3 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Crypto Downloads Here.url | 204.8 B | ||
| ▲ 123 total files | |||
The Financial Analyst's Complete Guide to Excel [2022]
https://FreeCryptoLearn.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 54 lectures (3h 45m) | Size: 1.56 GB
Learn how to use Excel for financial analysis and financial modeling! Real world exercises from a CFA charterholder
What you'll learn
Excel techniques and functions used in banking, private equity, real estate & more
Gain EXTREME confidence in your abilities to use Excel to solve financial problems
Create your own custom financial models from scratch
Build a loan amortization table from scratch. Take this one to the bank!
Advanced search & lookup functions including VLOOKUP, INDEX/MATCH & more
Creating macros to automate everyday, mundane tasks
Pivot tables and other data analysis tools
Keyboard shortcuts and keyboard movement
Conditional formatting
Logical operator functions
and more!
Requirements
Excel 2010 or newer
A basic working knowledge of Excel is required.
Basic knowledge of finance is a plus but is not necessary. You will learn a lot about finance in this course.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 784.3 MB | freecoursewb | 2 weeks | 18 | 6 | |
| 3.7 GB | freecoursewb | 2 weeks | 0 | 0 | |
| 3.5 GB | freecoursewb | 2 weeks | 0 | 0 | |
| 3 GB | freecoursewb | 2 weeks | 8 | 46 | |
|
Udemy - Enterprise Architecture Practitioner with the TOGAF Standard Posted by
freecoursewb in Other
|
2.9 GB | freecoursewb | 2 weeks | 5 | 47 |
All Comments