1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp48.94MB
1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The best way to take this course.mp417.62MB
10. Introduction to Excel charts/1. How to insert a chart in Excel.mp422.27MB
10. Introduction to Excel charts/2. Editing Excel charts.mp426.05MB
10. Introduction to Excel charts/3. Excel chart formatting.mp432.74MB
10. Introduction to Excel charts/4. How to create a bridge chart in Excel.mp413.66MB
10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.mp411.49MB
10. Introduction to Excel charts/6. Sparklines.mp427.56MB
11. P&L Case Study continued - Let's create some great-looking professional charts/1. Create professional and good-looking charts - Introduction.mp46.2MB
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.mp446.37MB
11. P&L Case Study continued - Let's create some great-looking professional charts/3. Learn how to build effective doughnut charts in Excel.mp438MB
11. P&L Case Study continued - Let's create some great-looking professional charts/4. Learn how to build an area chart in Excel.mp428.58MB
11. P&L Case Study continued - Let's create some great-looking professional charts/5. Learn how to create bridge charts.mp452.07MB
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.mp4136.11MB
11. P&L Case Study continued - Let's create some great-looking professional charts/8. Course Challenge - Apply your skills in practice!.mp47.92MB
12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.mp412.05MB
12. Case Study - Building an FMCG Model from Scratch/10. Combining Slicers and GETPIVOTDATA The key to our success.mp417.83MB
12. Case Study - Building an FMCG Model from Scratch/11. Getting fancy with Excel slicers - Good-looking Excel slicers.mp417.11MB
12. Case Study - Building an FMCG Model from Scratch/12. This is how the report can be used in practice by high-level executives.mp419.8MB
12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.mp422.6MB
12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp421.95MB
12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.mp411.65MB
12. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.mp413.5MB
12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.mp48.83MB
12. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.mp413.82MB
12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp431.04MB
12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.mp413.76MB
16. Learn how to build a Discounted Cash Flow model in Excel/1. Valuation Case study - Welcome lecture.mp41.78MB
16. Learn how to build a Discounted Cash Flow model in Excel/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp430.01MB
16. Learn how to build a Discounted Cash Flow model in Excel/11. Forecasting Balance sheet items.mp44.66MB
16. Learn how to build a Discounted Cash Flow model in Excel/12. An introduction to the Days methodology.mp410.08MB
16. Learn how to build a Discounted Cash Flow model in Excel/13. Calculation of DSO, DPO and DOI for the historical period.mp412.11MB
16. Learn how to build a Discounted Cash Flow model in Excel/14. Forecasting DSO, DPO and DOI.mp420.86MB
16. Learn how to build a Discounted Cash Flow model in Excel/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp422.62MB
16. Learn how to build a Discounted Cash Flow model in Excel/16. Creating an output P&L sheet.mp418.8MB
16. Learn how to build a Discounted Cash Flow model in Excel/17. Populating the output P&L sheet.mp425.53MB
16. Learn how to build a Discounted Cash Flow model in Excel/18. Populating the output BS sheet.mp416.93MB
16. Learn how to build a Discounted Cash Flow model in Excel/19. Completing the output BS sheet for the historical period.mp438.03MB
16. Learn how to build a Discounted Cash Flow model in Excel/2. Introduction to the DCF exercise.mp47.87MB
16. Learn how to build a Discounted Cash Flow model in Excel/20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp422.76MB
16. Learn how to build a Discounted Cash Flow model in Excel/21. Bridging Unlevered free cash flow to Net cash flow.mp414.58MB
16. Learn how to build a Discounted Cash Flow model in Excel/22. Calculating Unlevered free cash flow.mp459.72MB
16. Learn how to build a Discounted Cash Flow model in Excel/23. Calculating Net cash flow.mp437.9MB
16. Learn how to build a Discounted Cash Flow model in Excel/24. Obtaining the rest of the cash flows through Find and Replace.mp446.73MB
16. Learn how to build a Discounted Cash Flow model in Excel/25. Introducing Weighted average cost of capital and Perpetuity growth.mp413.2MB
16. Learn how to build a Discounted Cash Flow model in Excel/26. Discounting Unlevered free cash flows to obtain their Present value.mp420.22MB
16. Learn how to build a Discounted Cash Flow model in Excel/27. Calculating Continuing value and Enterprise value of the business.mp417.72MB
16. Learn how to build a Discounted Cash Flow model in Excel/28. Calculating Equity value.mp412.2MB
16. Learn how to build a Discounted Cash Flow model in Excel/29. Sensitivity analysis for WACC and perpetuity growth.mp440.48MB
16. Learn how to build a Discounted Cash Flow model in Excel/3. The stages of a complete DCF Valuation.mp449.24MB
16. Learn how to build a Discounted Cash Flow model in Excel/30. A possible application of Goal seek.mp415.62MB
16. Learn how to build a Discounted Cash Flow model in Excel/31. Using charts to summarize the results of the DCF model.mp432.88MB
16. Learn how to build a Discounted Cash Flow model in Excel/32. You made it!.mp411.26MB
16. Learn how to build a Discounted Cash Flow model in Excel/4. Description of the structure of the DCF model.mp418.53MB
16. Learn how to build a Discounted Cash Flow model in Excel/5. A glimpse at the company we are valuing - Cheeseco.mp415.67MB
16. Learn how to build a Discounted Cash Flow model in Excel/6. Modeling the top line.mp426.3MB
16. Learn how to build a Discounted Cash Flow model in Excel/7. Introducing scenarios to the model with Choose.mp417.83MB
16. Learn how to build a Discounted Cash Flow model in Excel/8. Modeling other items Other revenues and Cogs.mp444.56MB
16. Learn how to build a Discounted Cash Flow model in Excel/9. Modeling other items Operating expenses and D&A.mp426.33MB
17. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.mp431MB
17. Tesla valuation - Complete practical exercise/10. Forecasting 'energy' and 'services' revenue.mp425.3MB
17. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp426.81MB
17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp434.91MB
17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp456.58MB
17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp454.2MB
17. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.mp413.61MB
17. Tesla valuation - Complete practical exercise/16. Calculating DSO, DIO, DPO.mp417.51MB
17. Tesla valuation - Complete practical exercise/17. Producing a clean P&L output sheet.mp48.43MB
17. Tesla valuation - Complete practical exercise/18. Fill in the P&L output sheet.mp418.34MB
17. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.mp419.04MB
17. Tesla valuation - Complete practical exercise/2. The input data we will work with.mp415.8MB
7. Financial functions in Excel/1. Future and present values in Excel.mp414.96MB
7. Financial functions in Excel/2. Calculating the rate of return of an investment with the IRR function.mp47.57MB
7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.mp414.81MB
7. Financial functions in Excel/4. Date functions in Excel.mp411.35MB
8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.mp46MB
8. Microsoft Excel's Pivot Tables in Depth/2. Creating Pivot Tables easily!.mp419.37MB
8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.mp411.27MB
8. Microsoft Excel's Pivot Tables in Depth/4. Modifying and pivoting fields to obtain the Pivot Table you need.mp423MB
8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GETPIVOTDATA - A very important Excel function.mp418.06MB
8. Microsoft Excel's Pivot Tables in Depth/6. An introduction to slicers - The modern-day Pivot Table filters.mp422.16MB
9. Case study - Building a complete P&L from scratch in Excel/1. Case study - Build a P&L from scratch - Welcome lecture.mp43.14MB
9. Case study - Building a complete P&L from scratch in Excel/10. Use INDEX & MATCH as a substitute for VLOOKUP.mp449.58MB
9. Case study - Building a complete P&L from scratch in Excel/11. Mapping the rows in the Database sheet.mp432.48MB
9. Case study - Building a complete P&L from scratch in Excel/12. In case you have any doubts about the Mapping exercise.mp438.56MB
9. Case study - Building a complete P&L from scratch in Excel/13. Building the structure of the P&L sheet.mp420.85MB
9. Case study - Building a complete P&L from scratch in Excel/14. Formatting sets You apart from the competition in Excel - A Practical Example.mp425.42MB
9. Case study - Building a complete P&L from scratch in Excel/15. Populate the P&L sheet with SUMIF.mp430.26MB
9. Case study - Building a complete P&L from scratch in Excel/16. Learn how to find mistakes with COUNTIF.mp427.87MB
9. Case study - Building a complete P&L from scratch in Excel/17. Calculating year-on-year percentage variations the proper way.mp429.97MB
9. Case study - Building a complete P&L from scratch in Excel/2. Introduction to the case study.mp410.2MB
9. Case study - Building a complete P&L from scratch in Excel/3. Understand your data source before you start working on it.mp428.16MB
9. Case study - Building a complete P&L from scratch in Excel/4. Order the source worksheets.mp426.54MB
9. Case study - Building a complete P&L from scratch in Excel/5. Create a code the best way to organize your data and work efficiently with it.mp424.48MB
9. Case study - Building a complete P&L from scratch in Excel/6. Learn how to create a database.mp420.69MB
9. Case study - Building a complete P&L from scratch in Excel/7. Use VLOOKUP to fill the Database sheet.mp461.57MB
9. Case study - Building a complete P&L from scratch in Excel/8. 50% Completed!.mp44.3MB
9. Case study - Building a complete P&L from scratch in Excel/9. Use SUMIF to complete the Database sheet.mp447.94MB