[FreeAllCourse.Com] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation

•  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