[Tutorialsplanet.NET] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation

11/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4

17. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.mp4

9/7. Use VLOOKUP to fill the Database sheet.mp4

16/22. Calculating Unlevered free cash flow.mp4

17. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered free cash flow.mp4

17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp4

11/5. Learn how to create bridge charts.mp4

17. Tesla valuation - Complete practical exercise/26. Bridging Unlevered free cash flow to Net cash flow.mp4

9/10. Use INDEX & MATCH as a substitute for VLOOKUP.mp4

16/3. The stages of a complete DCF Valuation.mp4

9/9. Use SUMIF to complete the Database sheet.mp4

17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp4

16/24. Obtaining the rest of the cash flows through Find and Replace.mp4

11/2. Build a column stacked chart with a secondary line axis in Excel.mp4

17. Tesla valuation - Complete practical exercise/21. Forecasting other assets.mp4

17. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.mp4

17. Tesla valuation - Complete practical exercise/31. Final comments.mp4

16/8. Modeling other items Other revenues and Cogs.mp4

17. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.mp4

19. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and completing the exercise.mp4

16/29. Sensitivity analysis for WACC and perpetuity growth.mp4

5/15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4

9/12. In case you have any doubts about the Mapping exercise.mp4

17. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.mp4

16/19. Completing the output BS sheet for the historical period.mp4

16/23. Calculating Net cash flow.mp4

17. Tesla valuation - Complete practical exercise/29. Performing discounted cash flow valuation (DCF).mp4

5/13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4

17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp4

17. Tesla valuation - Complete practical exercise/23. Completing Unlevered free cash flow.mp4

16/31. Using charts to summarize the results of the DCF model.mp4

17. Tesla valuation - Complete practical exercise/28. Estimating Weighted average cost of capital (WACC).mp4

11/3. Learn how to build effective doughnut charts in Excel.mp4

6. Update! SUMIFS - Exercise/2. Exercise - Excel's SUMIFS function - solved & explained.mp4

12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4

16/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4

9/17. Calculating year-on-year percentage variations the proper way.mp4

10. Introduction to Excel charts/3. Excel chart formatting.mp4

11/4. Learn how to build an area chart in Excel.mp4

9/16. Learn how to find mistakes with COUNTIF.mp4

10. Introduction to Excel charts/6. Sparklines.mp4

4. Keyboard shortcuts in Excel/1. Keyboard shortcuts Save LOTS of time in Excel.mp4

9/11. Mapping the rows in the Database sheet.mp4

9/4. Order the source worksheets.mp4

10. Introduction to Excel charts/2. Editing Excel charts.mp4

16/17. Populating the output P&L sheet.mp4

17. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.mp4

9/14. Formatting sets You apart from the competition in Excel - A Practical Example.mp4

2. Introduction to Excel/8. Introduction to formatting.mp4

9/3. Understand your data source before you start working on it.mp4