The Complete Financial Modeling and Valuation Course

37s 1. Introduction to Excel - Welcome Lecture 3m 39s 2. Overview of Excel 1m 48s 3. Basic Manipulations with Rows & Columns 2m 42s 4. The Excel Ribbon 3m 3s 5. Data Entry in Excel 5m 38s 6. Introduction to Formatting 2m 58s 7. Introduction to Excel Formulas 3m 47s 8. Introduction to Excel Functions 2m 8s 9. Cut, Copy & Paste 1m 28s 10. Paste Special

41s 1. Excel Best Practices - Welcome Lecture 1m 53s 2. Initial formatting of an Excel sheet in order to render it professional 1m 29s 3. Fast scrolling through Excel sheets 2m 8s 4. Introduction to fixing of cell references 38s 5. Using the Alt plus Enter combination 1m 53s 6. Learn how to organize your data with Text to Columns 44s 7. Learn how to Use the Wrap Text Button 1m 11s 8. Create easily printable documents in Excel by using Set Print Area 1m 31s 9. Find and select special types of cells with Select Special (F5) 1m 21s 10. Learn how to assign dynamic names within a Financial Model 1m 34s 11. Define a named range in Excel 1m 33s 12. Assign custom formats to specific cells within a Financial Model (ex 2m 51s 13. Macros are a great timesaver! Here's why! 1m 44s 14. Create a drop-down list by using Data Validation 1m 23s 15. Using Custom-sort in order to sort multiple columns within a table 1m 12s 16. Create a great Index page at the beginning of your models - Hyperlinks 1m 11s 17. Fix the top row of your table with Freeze Panes 1m 44s 18. Filter by color - an excellent tool 5m 40s 19. Working with conditional formatting

4m 32s 1. Keyboard Shortcuts Save LOTS of time in Excel

45s 1. Excel's Key Functions - Welcome Lecture 4m 20s 2. Key Excel Functions: Sum, Sumif and Sumifs 4m 3. Key Excel Functions: Count, Counta, Countif, Countifs 1m 53s 4. Key Excel Functions: Average and Averageif 4m 24s 5. Elaborate text efficiently: Left, Right, Mid, Upper, Lower,Proper, Concatenate 51s 6. Find the minimum or maximum value in a range of cells in Excel 1m 1s 7. Include Round in your Financial Models 7m 31s 8. Learn how to transfer data efficiently in Excel: Vlookup and Hlookup 7m 18s 9. Index, Match and their combination - the perfect substitute of Vlookup 4m 59s 10. A great Excel technique: Index, Match, Match 1m 42s 11. Using Excel's Iferror function to trap spreadsheet errors 2m 18s 12. Learn how to render your models flexible with Choose 2m 13s 13. Use Goal Seek in order to find the result that you are looking for 4m 6s 14. Include sensitivity analysis in your models through Data Tables 2m 12s 15. Excel's dynamic and interactive tables: Pivot tables

8m 1. Exercise - Excel's "Sumifs" function - explained & solved

7m 2s 1. Future and present values in Excel 3m 30s 2. Calculating the rate of return of an investment with the IRR function 6m 16s 3. Calculating a complete loan schedule in Excel 5m 38s 4. Date functions in Excel

1m 30s 1. Introduction to Pivot Tables & Their Application 3m 42s 2. Creating Pivot Tables is easy! 2m 9s 3. Give Your Excel Pivot Tables a Makeover 4m 28s 4. Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need 3m 40s 5. Learn More About GetPivotData - A Very Important Excel Function 4m 20s 6. An Introduction to Slicers - The Moden Day Pivot Table Filters

1m 2s 1. Case Study - Build a P&L From Scratch - Welcome Lecture 37s 2. Introduction to the Case Study 2m 22s 3. Understand your data source before you start working on It 1m 57s 4. Order the source worksheets 1m 48s 5. Create a code: the best way to organize your data and work efficiently with It 1m 50s 6. Learn how to create a Database 5m 17s 7. Use Vlookup in order to fill the Database sheet 4m 7s 8. Use Sumif in order to complete the Database sheet 3m 59s 9. Use Index & Match as a substitute of Vlookup 2m 7s 10. Mapping of the rows in the Database sheet 1m 59s 11. Building the structure of the P&L sheet 3m 15s 12. Formatting sets You apart from the competition in Excel - A Practical Example 2m 39s 13. Populate the P&L sheet with Sumif 2m 17s 14. Learn how to find mistakes with Countif 2m 59s 15. Calculating year-on-year percentage variations the proper way 20s 16. Create professional and good-looking charts - Introduction 5m 52s 17. Build a Column Stacked Chart with a secondary line axis in Excel 4m 6s 18. Learn how to build effective Doughnut Charts in Excel 4m 1s 19. Learn how to build an Area Chart in Excel 10m 41s 20. Learn how to create Bridge Charts

1m 55s 1. Introduction to the Case Study 2m 5s 2. Preliminary mapping of the data extraction 3m 17s 3. Working with an SAP data extraction 2m 24s 4. Creating an output structure of the FMCG model 4m 13s 5. Improving the layout and appearance of the FMCG report 2m 25s 6. Inserting formulas and automating calculations 1m 50s 7. Creating a Master Pivot Table: The main data source for the FMCG report 5m 40s 8. GetPivotData is great! Extracting data from the Master Pivot Table 3m 14s 9. Combining Slicers and GetPivotData: The key to our success 3m 7s 10. Getting fancy with Excel slicers - Good-looking Excel slicers 3m 54s 11. This is how the report can be used in practice by high-level executives

42s 1. Financial Modeling Basics - Welcome Lecture 2m 2s 2. What is a Financial model? 2m 35s 3. Why use Financial models? 5m 49s 4. Financial modeling: Worst Practices - Things you should avoid 4m 58s 5. Financial modeling: Best practices 4m 42s 6. Financial modeling: The types of models that are built in practice 2m 35s 7. Financial modeling: The right level of detail in a model 2m 51s 8. Financial modeling: Forecasting guidelines 2m 15s 9. Building a complete model - Important considerations 5m 58s 10. Modeling the Income statement 2m 35s 11. Modeling the Balance sheet - Part 1 5m 8s 12. Modeling the Balance sheet - Part 2

33s 1. Valuation Case Study - Welcome Lecture 1m 7s 2. Introduction to the DCF exercise 6m 30s 3. The various stages of a complete DCF Valuation 2m 53s 4. Description of the structure of the DCF model 1m 9s 5. A glimpse at the company we are valuing - Cheeseco 3m 39s 6. Modeling the top line 2m 12s 7. Introducing scenarios to the model with Choose 3m 46s 8. Modeling other items: Other revenues and Cogs 2m 33s 9. Modeling other items: Operating expenses and D&A 2m 28s 10. Modeling other items: Interest expenses, Extraordinary items and Taxes 43s 11. Forecasting Balance Sheet items 1m 35s 12. An introduction to the "Days" methodology 1m 30s 13. Calculation of DSO, DPO and DOI for the historical period 2m 23s 14. Forecasting DSO, DPO and DOI 2m 27s 15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities 2m 36s 16. Creating an output P&L sheet 2m 14s 17. Populating the output P&L sheet 1m 49s 18. Populating the output BS sheet 3m 41s 19. Completing the output BS sheet for the historical period 3m 5s 20. Creating a structure for the calculation of Unlevered Free Cash Flows 1m 55s 21. Bridging Unlevered Free Cash Flow to Net Cash Flow 6m 1s 22. Calculating Unlevered Free Cash Flow 3m 56s 23. Calculating Net Cash Flow 3m 52s 24. Obtaining the rest of the Cash Flows through Find and Replace 1m 56s 25. Introducing Weighted Average Cost of Capital and Perpetuity Growth 2m 50s 26. Discounting Unlevered Free Cash Flows in order to obtain their Present Value 2m 17s 27. Calculating Continuing Value and Enterprise Value of the business 1m 21s 28. Calculating Equity Value 4m 17s 29. Sensitivity analysis for WACC and perpetuity growth 1m 40s 30. A possible application of Goal Seek 4m 38s 31. Using charts in order to summarize the results of the DCF Model 2m 16s 32. You Made It! 1m 2s 33. Congratulations!!