Filename Size 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp4 9 MB 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.vtt 3.1 KB 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1.1 Course Notes - Beginner to Pro in Excel.pdf.pdf 19 MB 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/2. Bonus! Welcome gift.html 167 B 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/3. Welcome gift number 2.html 167 B 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The approach to take this course.mp4 7.8 MB 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The approach to take this course.vtt 2.4 KB 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/5. Download all course materials.html 758 B 10. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.mp4 12.1 MB 10. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.vtt 2.4 KB 10. Case Study - Building an FMCG Model from Scratch/1.1 0. Exercise - Build an FMCG Model_before.xlsx.xlsx 13.3 MB 10. Case Study - Building an FMCG Model from Scratch/10. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 17.1 MB 10. Case Study - Building an FMCG Model from Scratch/10. Getting fancy with Excel slicers - Good-looking Excel slicers.vtt 3.4 KB 10. Case Study - Building an FMCG Model from Scratch/10.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx 22.8 MB 10. Case Study - Building an FMCG Model from Scratch/11. This is how the report can be used in practice by high-level executives.mp4 19.8 MB 10. Case Study - Building an FMCG Model from Scratch/11. This is how the report can be used in practice by high-level executives.vtt 4.4 KB 10. Case Study - Building an FMCG Model from Scratch/11.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx 22.8 MB 10. Case Study - Building an FMCG Model from Scratch/12. Dynamic reporting with GETPIVOTDATA and slicers.html 166 B 10. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.mp4 22.6 MB 10. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.vtt 2.4 KB 10. Case Study - Building an FMCG Model from Scratch/2.1 1. Exercise - Build an FMCG Model_Mapping.xlsx.xlsx 14.9 MB 10. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp4 22 MB 10. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.vtt 3.8 KB 10. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.mp4 11.7 MB 10. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.vtt 2.8 KB 10. Case Study - Building an FMCG Model from Scratch/4.1 2. Exercise - Build an FMCG Model_Structure.xlsx.xlsx 14.9 MB 10. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.mp4 13.5 MB 10. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.vtt 4.6 KB 10. Case Study - Building an FMCG Model from Scratch/5.1 2. Exercise - Build an FMCG Model_Layout.xlsx.xlsx 14.9 MB 10. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.mp4 8.8 MB 10. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.vtt 4.6 KB 10. Case Study - Building an FMCG Model from Scratch/6.1 4. Exercise - Build an FMCG Model_Adding Calculations.xlsx.xlsx 14.9 MB 10. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.mp4 13.8 MB 10. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.vtt 2.1 KB 10. Case Study - Building an FMCG Model from Scratch/7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table.xlsx.xlsx 20.8 MB 10. Case Study - Building an FMCG Model from Scratch/8. GetPivotData is great! Extracting data from the Master Pivot Table.mp4 31 MB 10. Case Study - Building an FMCG Model from Scratch/8. GetPivotData is great! Extracting data from the Master Pivot Table.vtt 6.7 KB 10. Case Study - Building an FMCG Model from Scratch/8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA.xlsx.xlsx 20.8 MB 10. Case Study - Building an FMCG Model from Scratch/9. Combining Slicers and GetPivotData The key to our success.mp4 17.8 MB 10. Case Study - Building an FMCG Model from Scratch/9. Combining Slicers and GetPivotData The key to our success.vtt 3.4 KB 10. Case Study - Building an FMCG Model from Scratch/9.1 8. Exercise - Build an FMCG Model_Inserting Slicers.xlsx.xlsx 20.8 MB 11. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.mp4 2.1 MB 11. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.vtt 1.1 KB 11. Financial Modeling Fundamentals/10. Forecasting financials - Quiz.html 163 B 11. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.mp4 6.4 MB 11. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.vtt 2.7 KB 11. Financial Modeling Fundamentals/12. Modeling the Income statement.mp4 12.4 MB 11. Financial Modeling Fundamentals/12. Modeling the Income statement.vtt 7 KB 11. Financial Modeling Fundamentals/13. Modeling the Balance sheet - Part 1.mp4 5.2 MB 11. Financial Modeling Fundamentals/13. Modeling the Balance sheet - Part 1.vtt 3.2 KB 11. Financial Modeling Fundamentals/14. Modeling the Balance sheet - Part 2.mp4 9.4 MB 11. Financial Modeling Fundamentals/14. Modeling the Balance sheet - Part 2.vtt 5.7 KB 11. Financial Modeling Fundamentals/15. Building a financial model - Quiz.html 163 B 11. Financial Modeling Fundamentals/2. What is a financial model.mp4 4.6 MB 11. Financial Modeling Fundamentals/2. What is a financial model.vtt 2.3 KB 11. Financial Modeling Fundamentals/3. Why use financial models.mp4 7.7 MB 11. Financial Modeling Fundamentals/3. Why use financial models.vtt 3.1 KB 11. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.mp4 19.9 MB 11. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.vtt 6.9 KB 11. Financial Modeling Fundamentals/5. Financial modeling - best practices.mp4 17.2 MB 11. Financial Modeling Fundamentals/5. Financial modeling - best practices.vtt 5.7 KB 11. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.mp4 12.5 MB 11. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.vtt 5.5 KB 11. Financial Modeling Fundamentals/7. Financial modeling - Quiz.html 163 B 11. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.mp4 5.7 MB 11. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.vtt 2.9 KB 11. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.mp4 6.4 MB 11. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.vtt 3.3 KB 12. Introduction to Company Valuation/1. The core theory behind Company Valuation.html 167 B 13. Introduction to Mergers & Acquisitions/1. Introduction to Mergers & Acquisitions.html 167 B 14. Learn how to build a Discounted Cash Flow model in Excel/1. Valuation Case study - Welcome lecture.mp4 1.8 MB 14. Learn how to build a Discounted Cash Flow model in Excel/1. Valuation Case study - Welcome lecture.vtt 869 B 14. Learn how to build a Discounted Cash Flow model in Excel/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4 5.1 MB 14. Learn how to build a Discounted Cash Flow model in Excel/10. Modeling other items Interest expenses, Extraordinary items and Taxes.vtt 2.8 KB 14. Learn how to build a Discounted Cash Flow model in Excel/10.1 9. Interest expenses, Extraordinary items and Taxes - Solved.xlsm.xlsm 52.7 KB 14. Learn how to build a Discounted Cash Flow model in Excel/10.2 9. Interest expenses, Extraordinary items and Taxes – Unsolved.xlsm.xlsm 51.6 KB 14. Learn how to build a Discounted Cash Flow model in Excel/11. Forecasting Balance Sheet items.mp4 1012.4 KB 14. Learn how to build a Discounted Cash Flow model in Excel/11. Forecasting Balance Sheet items.vtt 893 B 14. Learn how to build a Discounted Cash Flow model in Excel/11.1 10. Project BS items – Unsolved.xlsm.xlsm 52.7 KB 14. Learn how to build a Discounted Cash Flow model in Excel/11.2 10. Project BS items - Solved.xlsm.xlsm 52.7 KB 14. Learn how to build a Discounted Cash Flow model in Excel/12. An introduction to the Days methodology.mp4 2.3 MB 14. Learn how to build a Discounted Cash Flow model in Excel/12. An introduction to the Days methodology.vtt 1.8 KB 14. Learn how to build a Discounted Cash Flow model in Excel/12.1 Working Capital Days.pptx.pptx 121.5 KB 14. Learn how to build a Discounted Cash Flow model in Excel/13. Calculation of DSO, DPO and DOI for the historical period.mp4 2.7 MB 14. Learn how to build a Discounted Cash Flow model in Excel/13. Calculation of DSO, DPO and DOI for the historical period.vtt 1.7 KB 14. Learn how to build a Discounted Cash Flow model in Excel/13.1 12. Calculating DSO, DPO and DIO - Solved.xlsm.xlsm 52.3 KB 14. Learn how to build a Discounted Cash Flow model in Excel/13.2 12. Calculating DSO, DPO and DIO - Unsolved.xlsm.xlsm 49.9 KB 14. Learn how to build a Discounted Cash Flow model in Excel/14. Forecasting DSO, DPO and DOI.mp4 3.9 MB 14. Learn how to build a Discounted Cash Flow model in Excel/14. Forecasting DSO, DPO and DOI.vtt 2.9 KB 14. Learn how to build a Discounted Cash Flow model in Excel/14.1 13. Forecasting DSO, DPO and DIO - Solved.xlsm.xlsm 53.7 KB 14. Learn how to build a Discounted Cash Flow model in Excel/14.2 13. Forecasting DSO, DPO and DIO - Unsolved.xlsm.xlsm 50.1 KB 14. Learn how to build a Discounted Cash Flow model in Excel/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4 4.7 MB 14. Learn how to build a Discounted Cash Flow model in Excel/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.vtt 3 KB 14. Learn how to build a Discounted Cash Flow model in Excel/15.1 14. Forecasting PP&E, Other assets and Other liabilities - Solved.xlsm.xlsm 51 KB 14. Learn how to build a Discounted Cash Flow model in Excel/15.2 14. Forecasting PP&E, Other assets and Other liabilities - Unsolved.xlsm.xlsm 51 KB 14. Learn how to build a Discounted Cash Flow model in Excel/16. Creating an output P&L sheet.mp4 3.7 MB 14. Learn how to build a Discounted Cash Flow model in Excel/16. Creating an output P&L sheet.vtt 2.5 KB 14. Learn how to build a Discounted Cash Flow model in Excel/16.1 15. P&L structure – Unsolved.xlsm.xlsm 50.3 KB 14. Learn how to build a Discounted Cash Flow model in Excel/16.2 15. P&L structure - Solved.xlsm.xlsm 55.4 KB