| 11. P&L Case Study continued - Let's create some great-looking professional charts/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4 | 136.11 MB |
| 17. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.mp4 | 114.9 MB |
| 9. Case study - Building a complete P&L from scratch in Excel/7. Use VLOOKUP to fill the Database sheet.mp4 | 61.57 MB |
| 16. Learn how to build a Discounted Cash Flow model in Excel/22. Calculating Unlevered free cash flow.mp4 | 59.72 MB |
| 17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp4 | 56.58 MB |
| 17. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered free cash flow.mp4 | 55.93 MB |
| 17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp4 | 54.2 MB |
| 11. P&L Case Study continued - Let's create some great-looking professional charts/5. Learn how to create bridge charts.mp4 | 52.07 MB |
| 4. Keyboard shortcuts in Excel/1. Keyboard shortcuts Save LOTS of time in Excel.mp4 | 51.16 MB |
| 17. Tesla valuation - Complete practical exercise/26. Bridging Unlevered free cash flow to Net cash flow.mp4 | 50.72 MB |
| 23. APPENDIX - Microsoft Excel 2010 - Keyboard shortcuts/1. Keyboard shortcuts Save LOTS of time in Excel 2010.mp4 | 49.64 MB |
| 9. Case study - Building a complete P&L from scratch in Excel/10. Use INDEX & MATCH as a substitute for VLOOKUP.mp4 | 49.58 MB |
| 16. Learn how to build a Discounted Cash Flow model in Excel/3. The stages of a complete DCF Valuation.mp4 | 49.24 MB |
| 9. Case study - Building a complete P&L from scratch in Excel/9. Use SUMIF to complete the Database sheet.mp4 | 47.94 MB |
| 16. Learn how to build a Discounted Cash Flow model in Excel/24. Obtaining the rest of the cash flows through Find and Replace.mp4 | 46.73 MB |
| 17. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.mp4 | 46.56 MB |
| 11. P&L Case Study continued - Let's create some great-looking professional charts/2. Build a column stacked chart with a secondary line axis in Excel.mp4 | 46.37 MB |
| 17. Tesla valuation - Complete practical exercise/21. Forecasting other assets.mp4 | 45.24 MB |
| 17. Tesla valuation - Complete practical exercise/31. Final comments.mp4 | 44.88 MB |
| 16. Learn how to build a Discounted Cash Flow model in Excel/8. Modeling other items Other revenues and Cogs.mp4 | 44.56 MB |
| 17. Tesla valuation - Complete practical exercise/28. Estimating Weighted average cost of capital (WACC).mp4 | 44.27 MB |
| 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/5. Introduction to formatting.mp4 | 44.18 MB |
| 19. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and completing the exercise.mp4 | 43.04 MB |
| 8. Microsoft Excel's Pivot Tables in Depth/6. An introduction to slicers - The modern-day Pivot Table filters.mp4 | 42.46 MB |
| 17. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.mp4 | 42.35 MB |
| 17. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.mp4 | 41.92 MB |
| 17. Tesla valuation - Complete practical exercise/23. Completing Unlevered free cash flow.mp4 | 40.88 MB |
| 16. Learn how to build a Discounted Cash Flow model in Excel/29. Sensitivity analysis for WACC and perpetuity growth.mp4 | 40.49 MB |
| 5. Excel's key functions and functionalities made easy/16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4 | 38.95 MB |
| 9. Case study - Building a complete P&L from scratch in Excel/12. In case you have any doubts about the Mapping exercise.mp4 | 38.56 MB |
| 2. Introduction to Excel/7. Introduction to formatting.mp4 | 38.21 MB |
| 16. Learn how to build a Discounted Cash Flow model in Excel/19. Completing the output BS sheet for the historical period.mp4 | 38.03 MB |
| 11. P&L Case Study continued - Let's create some great-looking professional charts/3. Learn how to build effective doughnut charts in Excel.mp4 | 38 MB |
| 16. Learn how to build a Discounted Cash Flow model in Excel/23. Calculating Net cash flow.mp4 | 37.9 MB |
| 12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp4 | 37.12 MB |
| 6. Update! SUMIFS - Exercise/2. Exercise - Excel's SUMIFS function - solved & explained.mp4 | 35.31 MB |
| 17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp4 | 34.91 MB |
| 17. Tesla valuation - Complete practical exercise/29. Performing discounted cash flow valuation (DCF).mp4 | 34.9 MB |
| 5. Excel's key functions and functionalities made easy/14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4 | 34.59 MB |
| 17. Tesla valuation - Complete practical exercise/23. Completing Unlevered free cash flow.srt | 33.78 MB |
| 16. Learn how to build a Discounted Cash Flow model in Excel/31. Using charts to summarize the results of the DCF model.mp4 | 32.88 MB |
| 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp4 | 32.77 MB |
| 10. Introduction to Excel charts/3. Excel chart formatting.mp4 | 32.74 MB |
| 8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GETPIVOTDATA - A very important Excel function.mp4 | 32.63 MB |
| 9. Case study - Building a complete P&L from scratch in Excel/11. Mapping the rows in the Database sheet.mp4 | 32.48 MB |
| 12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4 | 31.04 MB |
| 17. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.mp4 | 31 MB |
| 9. Case study - Building a complete P&L from scratch in Excel/15. Populate the P&L sheet with SUMIF.mp4 | 30.26 MB |
| 16. Learn how to build a Discounted Cash Flow model in Excel/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4 | 30.01 MB |
| 9. Case study - Building a complete P&L from scratch in Excel/17. Calculating year-on-year percentage variations the proper way.mp4 | 29.97 MB |