[FreeCourseLab.com] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation

磁力链接/BT种子名称

[FreeCourseLab.com] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation

磁力链接/BT种子简介

种子哈希：183b86239551157c5d4886c7b9d8e4282ff94d3d
文件大小： 3.02G
已经下载：235次
下载速度：极快
收录时间：2022-04-25
最近下载：2025-02-15

移花宫入口

移花宫.com邀月.com怜星.com花无缺.comyhgbt.icuyhgbt.top

磁力链接下载

magnet:?xt=urn:btih:183B86239551157C5D4886C7B9D8E4282FF94D3D
推荐使用PIKPAK网盘下载资源，10TB超大空间，不限制资源，无限次数离线下载，视频在线观看

下载BT种子文件

磁力链接 迅雷下载 PIKPAK在线播放 91视频 含羞草 欲漫涩 逼哩逼哩 成人快手 51品茶 抖阴破解版 暗网禁地 91短视频 TikTok成人版 PornHub 草榴社区 乱伦社区 少女初夜 萝莉岛

最近搜索

文件列表

  • 15. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.mp4 120.5 MB
  • 15. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp4 59.3 MB
  • 15. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered Free Cash Flow.mp4 58.7 MB
  • 15. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp4 56.8 MB
  • 15. Tesla valuation - Complete practical exercise/26. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 53.2 MB
  • 15. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.mp4 48.8 MB
  • 15. Tesla valuation - Complete practical exercise/21. Forecasting other assets.mp4 47.4 MB
  • 15. Tesla valuation - Complete practical exercise/31. Final comments.mp4 47.1 MB
  • 15. Tesla valuation - Complete practical exercise/28. Estimating Weighted Average Cost of Capital (WACC).mp4 46.4 MB
  • 15. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.mp4 44.4 MB
  • 15. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.mp4 44.0 MB
  • 15. Tesla valuation - Complete practical exercise/23. Completing Unlevered Free Cash Flow.mp4 42.9 MB
  • 15. Tesla valuation - Complete practical exercise/29. Performing Discounted Cash Flow valuation (DCF).mp4 36.6 MB
  • 15. Tesla valuation - Complete practical exercise/29. Performing Discounted Cash Flow valuation (DCF).vtt 36.6 MB
  • 15. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp4 36.1 MB
  • 17. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and completing the exercise.mp4 35.8 MB
  • 10. Case Study - Building an FMCG Model from Scratch/8. GetPivotData is great! Extracting data from the Master Pivot Table.mp4 32.6 MB
  • 15. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.mp4 32.5 MB
  • 4. Keyboard shortcuts in Excel/1. Keyboard shortcuts Save LOTS of time in Excel.mp4 31.9 MB
  • 15. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.mp4 29.1 MB
  • 15. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4 28.1 MB
  • 15. Tesla valuation - Complete practical exercise/10. Forecasting 'energy' and 'services' revenue.mp4 26.5 MB
  • 2. Introduction to Excel/8. Introduction to formatting.mp4 25.9 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4 24.1 MB
  • 10. Case Study - Building an FMCG Model from Scratch/10.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx 23.9 MB
  • 10. Case Study - Building an FMCG Model from Scratch/11.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx 23.9 MB
  • 10. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.mp4 23.7 MB
  • 17. Capital Budgeting - A Complete Case Study/11. Discounting the project's cash flows and residual value.mp4 23.6 MB
  • 15. Tesla valuation - Complete practical exercise/30. Calculating enterprise value, equity value, and price per share.mp4 23.6 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/6. An introduction to slicers - The modern-day Pivot Table filters.mp4 23.2 MB
  • 10. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp4 23.0 MB
  • 15. Tesla valuation - Complete practical exercise/22. Forecasting other liabilities.mp4 23.0 MB
  • 15. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.mp4 21.9 MB
  • 10. Case Study - Building an FMCG Model from Scratch/7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table.xlsx.xlsx 21.8 MB
  • 10. Case Study - Building an FMCG Model from Scratch/8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA.xlsx.xlsx 21.8 MB
  • 10. Case Study - Building an FMCG Model from Scratch/9.1 8. Exercise - Build an FMCG Model_Inserting Slicers.xlsx.xlsx 21.8 MB
  • 11. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.mp4 20.9 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 20.8 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/2. Creating Pivot Tables easily!.mp4 20.3 MB
  • 16. Capital budgeting - The theory/5. Calculating cost of equity.mp4 20.1 MB
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1.1 Course Notes - Beginner to Pro in Excel.pdf.pdf 20.0 MB
  • 15. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.mp4 20.0 MB
  • 16. Capital budgeting - The theory/9. Estimating the project's cash flows.mp4 19.7 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/21. Learn how to create Bridge charts.mp4 19.7 MB
  • 15. Tesla valuation - Complete practical exercise/18. Fill in the P&L output sheet.mp4 19.2 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GetPivotData - A very important Excel function.mp4 18.9 MB
  • 10. Case Study - Building an FMCG Model from Scratch/9. Combining Slicers and GetPivotData The key to our success.mp4 18.7 MB
  • 15. Tesla valuation - Complete practical exercise/16. Calculating DSO, DIO, DPO.mp4 18.4 MB
  • 15. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.mp4 18.4 MB
  • 11. Financial Modeling Fundamentals/5. Financial modeling - best practices.mp4 18.1 MB
  • 15. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.mp4 18.0 MB
  • 10. Case Study - Building an FMCG Model from Scratch/10. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 18.0 MB
  • 15. Tesla valuation - Complete practical exercise/2. The input data we will work with.mp4 16.6 MB
  • 3. Useful tips and tools for your work in Excel/25. Working with conditional formatting.mp4 15.8 MB
  • 7. Financial functions in Excel/1. Future and present values in Excel.mp4 15.7 MB
  • 10. Case Study - Building an FMCG Model from Scratch/6.1 4. Exercise - Build an FMCG Model_Adding Calculations.xlsx.xlsx 15.6 MB
  • 10. Case Study - Building an FMCG Model from Scratch/5.1 2. Exercise - Build an FMCG Model_Layout.xlsx.xlsx 15.6 MB
  • 10. Case Study - Building an FMCG Model from Scratch/4.1 2. Exercise - Build an FMCG Model_Structure.xlsx.xlsx 15.6 MB
  • 10. Case Study - Building an FMCG Model from Scratch/2.1 1. Exercise - Build an FMCG Model_Mapping.xlsx.xlsx 15.6 MB
  • 7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.mp4 15.5 MB
  • 15. Tesla valuation - Complete practical exercise/25. Calculating Net income.mp4 15.5 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/7. Use Vlookup to fill the Database sheet.mp4 15.4 MB
  • 2. Introduction to Excel/2. Overview of Excel.mp4 14.6 MB
  • 17. Capital Budgeting - A Complete Case Study/10. Finding cost of equity.mp4 14.6 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 14.5 MB
  • 15. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.mp4 14.3 MB
  • 10. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.mp4 14.2 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/9. Use SUMIF to complete the Database sheet.mp4 13.9 MB
  • 10. Case Study - Building an FMCG Model from Scratch/1.1 0. Exercise - Build an FMCG Model_before.xlsx.xlsx 13.9 MB
  • 15. Tesla valuation - Complete practical exercise/27. Balancing the Balance sheet.mp4 13.9 MB
  • 16. Capital budgeting - The theory/4. Calculating future and present Value.mp4 13.7 MB
  • 5. Excel's key functions and functionalities made easy/12. Index, Match and their combination - the perfect substitute for Vlookup.mp4 13.4 MB
  • 6. Update! 15 December - Exercise/2. Exercise - Excel's Sumifs function - solved & explained.mp4 13.3 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/10. Use Index & Match as a substitute for Vlookup.mp4 13.3 MB
  • 11. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.mp4 13.1 MB
  • 11. Financial Modeling Fundamentals/12. Modeling the Income statement.mp4 13.0 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/18.1 Case Study Building A P&L From Scratch Complete.xlsx 12.8 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/21.3 Case Study Building A P&L From Scratch Complete.xlsx 12.8 MB
  • 17. Capital Budgeting - A Complete Case Study/4. Fixed asset rollforward.mp4 12.7 MB
  • 5. Excel's key functions and functionalities made easy/11. Learn how to transfer data efficiently in Excel Vlookup and Hlookup.mp4 12.7 MB
  • 10. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.mp4 12.6 MB
  • 2. Introduction to Excel/11. Introduction to Excel functions.mp4 12.6 MB
  • 5. Excel's key functions and functionalities made easy/13. A great Excel technique Index, Match, Match.mp4 12.3 MB
  • 10. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.mp4 12.2 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/18.3 Column Stacked Chart - Solved.xlsm.xlsm 12.1 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/21.2 Bridge Chart - Solved.xlsm.xlsm 12.1 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/18.2 Column Stacked Chart - Unsolved.xlsm.xlsm 12.1 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/19.1 Doughnut Chart - Unsolved.xlsm.xlsm 12.1 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/19.2 Doughnut Chart - Solved.xlsm.xlsm 12.1 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/20.1 Area Chart - Solved.xlsm.xlsm 12.1 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/20.2 Area Chart - Unsolved.xlsm.xlsm 12.1 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/21.1 Bridge Chart – Unsolved.xlsm.xlsm 12.1 MB
  • 7. Financial functions in Excel/4. Date functions in Excel.mp4 11.9 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/18. Build a Column Stacked chart with a secondary line axis in Excel.mp4 11.9 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.mp4 11.8 MB
  • 17. Capital Budgeting - A Complete Case Study/2. Organizing an Inputs sheet.mp4 11.6 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/22. Calculating Unlevered Free Cash Flow.mp4 11.3 MB
  • 2. Introduction to Excel/7. Data entry in Excel.mp4 10.9 MB
  • 17. Capital Budgeting - A Complete Case Study/8. Calculating project cash flows.mp4 10.6 MB
  • 3. Useful tips and tools for your work in Excel/24. Filter by color - an excellent tool.mp4 10.4 MB
  • 5. Excel's key functions and functionalities made easy/3.5 Key Functions In Excel.pdf 10.3 MB
  • 5. Excel's key functions and functionalities made easy/4.2 Key Functions In Excel.pdf 10.3 MB
  • 5. Excel's key functions and functionalities made easy/10.4 Key Functions In Excel.pdf 10.3 MB
  • 5. Excel's key functions and functionalities made easy/11.4 Key Functions In Excel.pdf 10.3 MB
  • 5. Excel's key functions and functionalities made easy/12.2 Key Functions In Excel.pdf 10.3 MB
  • 5. Excel's key functions and functionalities made easy/15.2 Key Functions In Excel.pdf 10.3 MB
  • 5. Excel's key functions and functionalities made easy/16.5 Key Functions In Excel.pdf 10.3 MB
  • 5. Excel's key functions and functionalities made easy/17.1 Key Functions In Excel.pdf 10.3 MB
  • 5. Excel's key functions and functionalities made easy/19.2 Key Functions In Excel.pdf 10.3 MB
  • 5. Excel's key functions and functionalities made easy/21.4 Key Functions In Excel.pdf 10.3 MB
  • 5. Excel's key functions and functionalities made easy/7.5 Key Functions In Excel.pdf 10.3 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/24. Obtaining the rest of the cash flows through Find and Replace.mp4 10.2 MB
  • 3. Useful tips and tools for your work in Excel/14.1 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 3. Useful tips and tools for your work in Excel/16.2 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 3. Useful tips and tools for your work in Excel/17.2 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 3. Useful tips and tools for your work in Excel/18.4 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 3. Useful tips and tools for your work in Excel/20.1 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 3. Useful tips and tools for your work in Excel/5.1 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 3. Useful tips and tools for your work in Excel/7.1 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 3. Useful tips and tools for your work in Excel/10.5 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 3. Useful tips and tools for your work in Excel/11.3 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 3. Useful tips and tools for your work in Excel/12.3 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 3. Useful tips and tools for your work in Excel/2.2 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 3. Useful tips and tools for your work in Excel/21.5 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 3. Useful tips and tools for your work in Excel/22.4 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 3. Useful tips and tools for your work in Excel/23.3 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 3. Useful tips and tools for your work in Excel/3.5 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 3. Useful tips and tools for your work in Excel/8.4 Useful Tips & Tools PDF Version.pdf 9.9 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/11. Mapping the rows in the Database sheet.mp4 9.9 MB
  • 11. Financial Modeling Fundamentals/14. Modeling the Balance sheet - Part 2.mp4 9.8 MB
  • 16. Capital budgeting - The theory/8. The type of cash flows we will have in a project.mp4 9.8 MB
  • 17. Capital Budgeting - A Complete Case Study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4 9.7 MB
  • 16. Capital budgeting - The theory/6. Coming up with project-specific beta.mp4 9.4 MB
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp4 9.4 MB
  • 10. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.mp4 9.3 MB
  • 2. Introduction to Excel/6. The Excel ribbon.mp4 9.2 MB
  • 17. Capital Budgeting - A Complete Case Study/1. Introduction to the Capital Budgeting exercise.mp4 9.0 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/29. Sensitivity analysis for WACC and perpetuity growth.mp4 9.0 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/3. The various stages of a complete DCF Valuation.mp4 9.0 MB
  • 15. Tesla valuation - Complete practical exercise/17. Producing a clean P&L output sheet.mp4 8.8 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/31. Using charts to summarize the results of the DCF model.mp4 8.6 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/20. Learn how to build an Area chart in Excel.mp4 8.4 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/23. Course Challenge - Apply your skills in practice!.mp4 8.3 MB
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The approach to take this course.mp4 8.2 MB
  • 11. Financial Modeling Fundamentals/3. Why use financial models.mp4 8.1 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/32. You Made It!.mp4 8.0 MB
  • 7. Financial functions in Excel/2. Calculating the rate of return of an investment with the IRR function.mp4 7.9 MB
  • 2. Introduction to Excel/12. Cut, copy, & paste.mp4 7.9 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/19. Completing the output BS sheet for the historical period.mp4 7.9 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/19. Learn how to build effective Doughnut charts in Excel.mp4 7.8 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/15. Learn how to find mistakes with Countif.mp4 7.8 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/8. Modeling other items Other revenues and Cogs.mp4 7.8 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/23. Calculating Net Cash Flow.mp4 7.4 MB
  • 2. Introduction to Excel/4. Basic manipulations with rows and columns.mp4 7.2 MB
  • 16. Capital budgeting - The theory/2. Why we need Capital budgeting.mp4 7.2 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/16. Calculating year-on-year percentage variations the proper way.mp4 7.2 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/3. Understand your data source before you start working on it.mp4 7.1 MB
  • 5. Excel's key functions and functionalities made easy/3. Key Excel functions Sum, Sumif and Sumifs.mp4 7.0 MB
  • 2. Introduction to Excel/14. Paste special.mp4 7.0 MB
  • 16. Capital budgeting - The theory/3. The time value of money.mp4 7.0 MB
  • 11. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.mp4 6.7 MB
  • 11. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.mp4 6.7 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/14. Populate the P&L sheet with Sumif.mp4 6.7 MB
  • 5. Excel's key functions and functionalities made easy/7. Elaborate text efficiently Left, Right, Mid, Upper, Lower,Proper, Concatenate.mp4 6.6 MB
  • 3. Useful tips and tools for your work in Excel/3. Fast scrolling through Excel sheets.mp4 6.6 MB
  • 17. Capital Budgeting - A Complete Case Study/6. Modeling debt financing.mp4 6.5 MB
  • 3. Useful tips and tools for your work in Excel/5. Introduction to fixing of cell references.mp4 6.4 MB
  • 5. Excel's key functions and functionalities made easy/4. Key Excel functions Count, Counta, Countif, Countifs.mp4 6.3 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.mp4 6.3 MB
  • 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.mp4 6.3 MB
  • 2. Introduction to Excel/9. Introduction to Excel formulas.mp4 6.1 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/13. Formatting sets You apart from the competition in Excel - A Practical Example.mp4 6.0 MB
  • 11. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.mp4 6.0 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/4. Order the source worksheets.mp4 6.0 MB
  • 17. Capital Budgeting - A Complete Case Study/9. Estimating the weighted average cost of capital (WACC).mp4 5.9 MB
  • 16. Capital budgeting - The theory/7. Weighted Average Cost of Capital (WACC).mp4 5.8 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/6. Learn how to create a database.mp4 5.7 MB
  • 16. Capital budgeting - The theory/1. Introduction to Capital budgeting.mp4 5.7 MB
  • 5. Excel's key functions and functionalities made easy/19. Include sensitivity analysis in your models through Data Tables.mp4 5.7 MB
  • 17. Capital Budgeting - A Complete Case Study/5. The impact of working capital.mp4 5.6 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/17. Populating the output P&L sheet.mp4 5.6 MB
  • 5. Excel's key functions and functionalities made easy/21. Excel's dynamic and interactive tables Pivot tables.mp4 5.6 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/9. Modeling other items Operating expenses and D&A.mp4 5.5 MB
  • 11. Financial Modeling Fundamentals/13. Modeling the Balance sheet - Part 1.mp4 5.5 MB
  • 3. Useful tips and tools for your work in Excel/23. Fix the top row of your table with Freeze Panes.mp4 5.5 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/6. Modeling the top line.mp4 5.4 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4 5.4 MB
  • 17. Capital Budgeting - A Complete Case Study/7. Adding a P&L sheet.mp4 5.1 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4 5.0 MB
  • 11. Financial Modeling Fundamentals/2. What is a financial model.mp4 4.8 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/2. Introduction to the DCF exercise.mp4 4.7 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/4. Description of the structure of the DCF model.mp4 4.7 MB
  • 3. Useful tips and tools for your work in Excel/18. Macros are a great timesaver! Here's why!.mp4 4.5 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/8. 50% Completed!.mp4 4.5 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp4 4.3 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/26. Discounting Unlevered Free Cash Flows to obtain their Present Value.mp4 4.2 MB
  • 3. Useful tips and tools for your work in Excel/8. Learn how to organize your data with Text to Columns.mp4 4.1 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/14. Forecasting DSO, DPO and DOI.mp4 4.1 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/12. Building the structure of the P&L sheet.mp4 4.1 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/16. Creating an output P&L sheet.mp4 3.9 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/27. Calculating Continuing Value and Enterprise Value of the business.mp4 3.6 MB
  • 5. Excel's key functions and functionalities made easy/16. Learn how to render your models flexible with Choose.mp4 3.6 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/18. Populating the output BS sheet.mp4 3.6 MB
  • 3. Useful tips and tools for your work in Excel/2. Initial formatting of an Excel sheet to render it professional.mp4 3.5 MB
  • 3. Useful tips and tools for your work in Excel/20. Create a drop-down list by using Data Validation.mp4 3.5 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/7. Introducing scenarios to the model with Choose.mp4 3.4 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/30. A possible application of Goal Seek.mp4 3.4 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/1. Case study - Build a P&L from scratch - Welcome lecture.mp4 3.3 MB
  • 3. Useful tips and tools for your work in Excel/12. Find and select special types of cells with Select Special (F5).mp4 3.2 MB
  • 5. Excel's key functions and functionalities made easy/17. Use Goal Seek to find the result that you are looking for.mp4 3.2 MB
  • 3. Useful tips and tools for your work in Excel/21. Using Custom-sort in order to sort multiple columns within a table.mp4 2.9 MB
  • 5. Excel's key functions and functionalities made easy/5. Key Excel functions Average and Averageif.mp4 2.9 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/21. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 2.8 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/25. Introducing Weighted Average Cost of Capital and Perpetuity Growth.mp4 2.8 MB
  • 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.8 MB
  • 5. Excel's key functions and functionalities made easy/15. Using Excel's Iferror function to trap spreadsheet errors.mp4 2.8 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/28. Calculating Equity Value.mp4 2.6 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/2. Introduction to the case study.mp4 2.5 MB
  • 3. Useful tips and tools for your work in Excel/14. Learn how to assign dynamic names within a financial model.mp4 2.4 MB
  • 5. Excel's key functions and functionalities made easy/1. Excel's key functions - Welcome lecture.mp4 2.4 MB
  • 17. Capital Budgeting - A Complete Case Study/14. Congratulations!!.mp4 2.4 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/12. An introduction to the Days methodology.mp4 2.4 MB
  • 3. Useful tips and tools for your work in Excel/22.3 Useful Tips And Tools Excel File.xlsx 2.4 MB
  • 3. Useful tips and tools for your work in Excel/3.4 Useful tips and tools - Excel file.xlsx.xlsx 2.3 MB
  • 3. Useful tips and tools for your work in Excel/17. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4 2.3 MB
  • 3. Useful tips and tools for your work in Excel/1. Excel best practices - Welcome lecture.mp4 2.2 MB
  • 3. Useful tips and tools for your work in Excel/16. Define a named range in Excel.mp4 2.2 MB
  • 11. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.mp4 2.2 MB
  • 2. Introduction to Excel/1. Introduction to Excel - welcome lecture.mp4 2.1 MB
  • 5. Excel's key functions and functionalities made easy/9. Find the minimum or maximum value in a range of cells in Excel.mp4 2.0 MB
  • 3. Useful tips and tools for your work in Excel/22. Create a great Index page at the beginning of your models - Hyperlinks.mp4 2.0 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/4.1 4. Working with Pivot Tables.xlsx.xlsx 2.0 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/6.2 6. Slicers.xlsx.xlsx 2.0 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/5.1 5. GetPivotData.xlsx.xlsx 2.0 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/1. Valuation Case study - Welcome lecture.mp4 1.9 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/5. A glimpse at the company we are valuing - Cheeseco.mp4 1.8 MB
  • 3. Useful tips and tools for your work in Excel/11. Create easily printable documents in Excel by using Set Print Area.mp4 1.8 MB
  • 15. Tesla valuation - Complete practical exercise/29.1 22. DCF_before.xlsx.xlsx 1.6 MB
  • 15. Tesla valuation - Complete practical exercise/16.2 11. Working capital forecasting_after.xlsx.xlsx 1.6 MB
  • 15. Tesla valuation - Complete practical exercise/8.2 4a. Gross profit automotive - before.xlsx.xlsx 1.6 MB
  • 3. Useful tips and tools for your work in Excel/7. Using the 'Alt + Enter' combination.mp4 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/30.1 23. EV, Equity value, Price per share_after.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/29.2 22. DCF_after.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/30.2 23. EV, Equity value, Price per share_before.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/27.1 20. Complete the BS_after.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/26.1 19. Cash flow_complete_after.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/27.2 20. Complete the BS_before.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/28.1 21. WACC_after.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/26.2 19. Cash flow_complete_before.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/25.1 18. P&L complete_after.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/24.2 17. Financing_after.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/28.2 21. WACC_before.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/25.2 18. P&L complete_before.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/24.1 17. Financing_before.xlsx.xlsx 1.5 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/2.1 2. Creating a Pivot Table.xlsx.xlsx 1.5 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/3.1 3. Formatting a Pivot Table.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/23.2 16a. Complete UFCF_after.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/23.1 16a. Complete UFCF_before.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/22.2 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/21.2 15. Balance Sheet forecasting assets_after.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/22.1 16. Balance Sheet forecasting liabilities_before.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/20.2 14. Cash flow - UFCF_after.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/21.1 15. Balance Sheet forecasting assets_before.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/20.1 14. Cash flow - UFCF_before.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/19.2 13. Calculating working capital_after.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/19.1 13. Calculating working capital_before.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/18.1 12a. P&L fill in_after.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/18.2 12a. P&L fill in_before.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/17.1 12. P&L.xlsx.xlsx 1.5 MB
  • 15. Tesla valuation - Complete practical exercise/16.1 11. Working capital forecasting_before.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/15.1 10a. PP&E comparison.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/14.2 10. PP&E schedule_after.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/13.2 9. PP&E forecasting and comparables_after.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/14.1 10. PP&E schedule_before.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/13.1 9. PP&E forecasting and comparables_before.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/12.2 8. Opex - After.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/12.1 8. Opex - Before.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/11.2 7. Energy and Other - Gross profit, cost of sales - After.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/11.1 7. Energy and Other - Gross profit, cost of sales - Before.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/10.1 6. Energy and Other revenue - After.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/10.2 6. Energy and Other revenue - Before.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/9.1 5. Cost of sales and chart.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/8.1 4a. Gross profit automotive - after.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/7.1 4. Gross profit automotive.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/6.2 3. Revenue calculation and scenarios - after.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/5.1 2. Average price_after.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/6.1 3. Revenue calculation and scenarios - before.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/5.2 2. Average price_before.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/4.1 1a. Deliveries development.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/3.2 1. Deliveries_after.xlsx.xlsx 1.4 MB
  • 6. Update! 15 December - Exercise/2.1 Exercise Sumifs With Solutions.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/3.1 1. Deliveries_before.xlsx.xlsx 1.4 MB
  • 15. Tesla valuation - Complete practical exercise/2.2 0aa. Inputs_before.xlsx.xlsx 1.3 MB
  • 15. Tesla valuation - Complete practical exercise/2.1 0aa. Inputs_after.xlsx.xlsx 1.3 MB
  • 15. Tesla valuation - Complete practical exercise/1.1 0a. Drivers_after.xlsx.xlsx 1.3 MB
  • 15. Tesla valuation - Complete practical exercise/1.2 0a. Drivers_before.xlsx.xlsx 1.3 MB
  • 5. Excel's key functions and functionalities made easy/10. Include Round in your financial models.mp4 1.3 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/17. Create professional and good-looking charts - Introduction.mp4 1.3 MB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/11. Forecasting Balance Sheet items.mp4 1.0 MB
  • 5. Excel's key functions and functionalities made easy/10.2 Excel Functions.xlsx 994.3 kB
  • 5. Excel's key functions and functionalities made easy/21.5 Excel Functions.xlsx 994.3 kB
  • 3. Useful tips and tools for your work in Excel/10. Learn how to use the Wrap Text button.mp4 930.2 kB
  • 5. Excel's key functions and functionalities made easy/21.2 Excel functions.xlsx.xlsx 908.6 kB
  • 8. Microsoft Excel's Pivot Tables in Depth/6.1 Database - Pivot & Slicers.xlsm.xlsm 871.7 kB
  • 3. Useful tips and tools for your work in Excel/5.3 Fixing references - Solved.xlsx.xlsx 660.7 kB
  • 3. Useful tips and tools for your work in Excel/5.4 Fixing references – Unsolved.xlsx.xlsx 659.4 kB
  • 3. Useful tips and tools for your work in Excel/23.2 Freeze Panes - Solved.xlsx.xlsx 659.4 kB
  • 3. Useful tips and tools for your work in Excel/23.1 Freeze Panes – Unsolved.xlsx.xlsx 659.3 kB
  • 3. Useful tips and tools for your work in Excel/3.1 2. Fast Scrolling - Solved.xlsx.xlsx 657.9 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/23.2 1. SOULUTIONS - Course Challenge.xlsx.xlsx 557.0 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/23.1 1. Course Challenge.xlsx.xlsx 517.6 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/3.1 Valuation exercise.pdf.pdf 421.6 kB
  • 2. Introduction to Excel/6.2 02 8 The Ribbon Solved.xlsx.xlsx 412.9 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/4.1 DCF Model structure.pdf.pdf 246.6 kB
  • 5. Excel's key functions and functionalities made easy/21.1 05 49 Pivot Tables Intro Solved.xlsx.xlsx 194.6 kB
  • 3. Useful tips and tools for your work in Excel/24.1 Solution_Filter by Color.xlsx.xlsx 157.2 kB
  • 5. Excel's key functions and functionalities made easy/21.3 05 49 Pivot Tables Intro Exercise & Text.xlsx.xlsx 155.8 kB
  • 3. Useful tips and tools for your work in Excel/21.2 Sort data - Solved.xlsx.xlsx 149.1 kB
  • 3. Useful tips and tools for your work in Excel/21.1 Sort data – Unsolved.xlsx.xlsx 148.8 kB
  • 3. Useful tips and tools for your work in Excel/18.5 03 28 Macros Solved.xlsx.xlsx 148.5 kB
  • 3. Useful tips and tools for your work in Excel/22.2 03 31 Hyperlinks Solved.xlsx.xlsx 140.4 kB
  • 3. Useful tips and tools for your work in Excel/22.1 03 31 Hyperlinks Exercise & Text.xlsx.xlsx 140.2 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/12.1 Working Capital Days.pptx.pptx 124.5 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/31.2 30. Charts - Solved.xlsm.xlsm 99.4 kB
  • 2. Introduction to Excel/11.4 02 12 Functions Solved.xlsx.xlsx 83.0 kB
  • 2. Introduction to Excel/9.2 02 11 Formulas Solved.xlsx.xlsx 82.1 kB
  • 3. Useful tips and tools for your work in Excel/20.5 03 29 Drop-down List Solved.xlsx.xlsx 78.9 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/24.1 23. Use Find and Replace - Solved.xlsm.xlsm 66.0 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/31.1 30. Charts – Unsolved.xlsm.xlsm 65.4 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/30.1 29. Goal seek - Solved.xlsm.xlsm 65.4 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/29.1 28. Sensitivity analysis - Solved.xlsm.xlsm 65.4 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/30.2 29. Goal Seek - Unsolved.xlsm.xlsm 65.4 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/28.1 27. Calculating Equity Value - Solved.xlsm.xlsm 64.1 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/29.3 28. Sensitivity analysis - Unsolved.xlsm.xlsm 64.1 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/27.2 26. Calculating CV of the business - Solved.xlsm.xlsm 63.8 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/28.2 27. Calculating Equity Value - Unsolved.xlsm.xlsm 63.8 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/26.1 25. Calculating PV of Cash Flows - Solved.xlsm.xlsm 63.5 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/27.1 26. Calculating CV of the business - Unsolved.xlsm.xlsm 63.5 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/23.3 22. From UFCF to Net Cash Flow - Solved.xlsm.xlsm 62.8 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/24.2 23. Use Find and Replace - Unsolved.xlsm.xlsm 62.8 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/25.2 24. Introducing WACC and g - Solved.xlsm.xlsm 62.5 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/25.1 24. Introducing WACC and g - Unsolved.xlsm.xlsm 62.4 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/29.2 Sensitivity Analysis.xlsx 62.3 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/21.2 20. From UFCF to Net Cash Flow – Solved.xlsm.xlsm 61.8 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/19.1 18. Completing the BS items - Solved.xlsm.xlsm 61.5 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/22.1 21. Calculating UFCF - Unsolved.xlsm.xlsm 60.9 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/14.1 13. Populating the P&L sheet - Solved.xlsm.xlsm 60.4 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/18.2 17. Populating the BS sheet - Solved.xlsm.xlsm 60.2 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/26.2 25. Calculating PV of Cash Flows - Unsolved.xlsm.xlsm 59.6 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/22.2 21. Calculating UFCF - Solved.xlsm.xlsm 59.3 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/23.1 22. From UFCF to Net Cash Flow - Unsolved.xlsm.xlsm 59.3 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/15.1 14. Countif - Solved.xlsx.xlsx 58.7 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/20.2 19. Building a Cash Flow Format – Solved.xlsm.xlsm 58.6 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/17.1 16. Populating the P&L sheet - Solved.xlsm.xlsm 58.5 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/21.1 20. From UFCF to Net Cash Flow - Unsolved.xlsm.xlsm 58.2 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/16.1 15. Adding % variations - Solved.xlsx.xlsx 57.9 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/20.1 19. Building a Cash Flow Format – Unsolved.xlsm.xlsm 57.5 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/23.2 Cash Flow Classification By Activities.xlsx 57.3 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/19.2 18. Completing the BS items – Unsolved.xlsm.xlsm 57.0 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/16.2 15. P&L structure - Solved.xlsm.xlsm 56.7 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/18.1 17. Populating the Balance sheet – Unsolved.xlsm.xlsm 56.1 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/15.2 14. Countif - Unsolved.xlsm.xlsm 55.3 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/12.1 11 Building A P&L.xlsx 55.1 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/12.2 11. Building a P&L - Solved.xlsx.xlsx 55.1 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/14.1 13. Forecasting DSO, DPO and DIO - Solved.xlsm.xlsm 54.9 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/13.1 12. Formatting the P&L sheet - Solved.xlsx.xlsx 54.8 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/17.2 16. Populating the P&L sheet – Unsolved.xlsm.xlsm 54.0 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/11.1 10. Project BS items – Unsolved.xlsm.xlsm 54.0 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/11.2 10. Project BS items - Solved.xlsm.xlsm 54.0 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 54.0 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/13.1 12. Calculating DSO, DPO and DIO - Solved.xlsm.xlsm 53.6 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/9.1 8. Opex and D&A - Solved.xlsm.xlsm 53.6 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/8.1 7. Modeling Cogs - Solved.xlsm.xlsm 53.1 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 52.9 kB
  • 3. Useful tips and tools for your work in Excel/25.2 Solution_Conditional Formatting.xlsx.xlsx 52.8 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/16.2 15. Adding % variations - Unsolved.xlsx.xlsx 52.4 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 52.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 52.3 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/16.1 15. P&L structure – Unsolved.xlsm.xlsm 51.6 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/14.2 13. Forecasting DSO, DPO and DIO - Unsolved.xlsm.xlsm 51.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 51.0 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/7.1 6. Choose - Solved.xlsm.xlsm 50.7 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/13.2 12. Formatting the P&L - Unsolved.xlsx.xlsx 50.5 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/6.2 5. Modeling revenues - Solved.xlsm.xlsm 50.5 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/14.2 13. Populating the P&L sheet - Unsolved.xlsx.xlsx 50.4 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/9.2 8. Opex and D&A - Unsolved.xlsm.xlsm 50.1 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/4.2 3. Beginning of exercise.xlsm.xlsm 50.0 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/8.2 7. Modeling Cogs – Unsolved.xlsm.xlsm 49.9 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/6.1 5. Modeling revenues - Unsolved.xlsm.xlsm 49.8 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/11.1 10. Mapping - Solved.xlsx.xlsx 48.6 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/9.1 8. Sumif - Solved.xlsx.xlsx 48.4 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/7.2 6. Choose – Unsolved.xlsm.xlsm 47.6 kB
  • 3. Useful tips and tools for your work in Excel/3.3 03 18 Fast Scrolling Solved.xlsx.xlsx 45.4 kB
  • 3. Useful tips and tools for your work in Excel/3.2 03 18 Fast Scrolling Exercise & Text.xlsx.xlsx 45.0 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/10.2 9. Index & Match - Solved.xlsx.xlsx 43.9 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/5.1 Beginning Of Exercise.xlsx 43.4 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/7.3 7. Vlookup - Solved.xlsx.xlsx 42.3 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/7.1 7 Vlookup.xlsx 41.7 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/11.2 10. Mapping - Unsolved.xlsx.xlsx 40.0 kB
  • 17. Capital Budgeting - A Complete Case Study/12.2 10. Sensitivty analysis.xlsx.xlsx 39.7 kB
  • 17. Capital Budgeting - A Complete Case Study/12.1 10. Sensitivty analysis_unsolved.xlsx.xlsx 39.6 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/10.1 9. Index & Match - Unsolved.xlsx.xlsx 39.4 kB
  • 17. Capital Budgeting - A Complete Case Study/11.2 9. Discounted cash flow.xlsx.xlsx 39.0 kB
  • 17. Capital Budgeting - A Complete Case Study/10.1 8. WACC.xlsx.xlsx 38.9 kB
  • 17. Capital Budgeting - A Complete Case Study/9.1 8. WACC.xlsx.xlsx 38.9 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/9.2 8. Sumif - Unsolved.xlsx.xlsx 38.3 kB
  • 17. Capital Budgeting - A Complete Case Study/11.1 9. Discounted cash flow_unsolved.xlsx.xlsx 38.1 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/4.1 4. Order a worksheet - Solved.xlsm.xlsm 37.5 kB
  • 17. Capital Budgeting - A Complete Case Study/10.2 8. WACC_unsolved.xlsx.xlsx 36.8 kB
  • 17. Capital Budgeting - A Complete Case Study/9.2 8. WACC_unsolved.xlsx.xlsx 36.8 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/6.2 6. Creating a database - Solved.xlsx.xlsx 36.3 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/5.1 5. Creating a code - Solved.xlsx.xlsx 34.7 kB
  • 2. Introduction to Excel/4.2 02 7 Basic Manipulations Solved.xlsx.xlsx 33.7 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/5.2 5. Creating a code - Unsolved.xlsm.xlsm 33.5 kB
  • 2. Introduction to Excel/7.1 02 9 Data Entry Solved.xlsx.xlsx 33.5 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/7.2 7. Vlookup - Unsolved.xlsx.xlsx 33.3 kB
  • 17. Capital Budgeting - A Complete Case Study/8.2 7. Cash flow.xlsx.xlsx 32.1 kB
  • 17. Capital Budgeting - A Complete Case Study/7.1 6. P&L.xlsx.xlsx 31.8 kB
  • 17. Capital Budgeting - A Complete Case Study/6.2 5. Financing.xlsx.xlsx 31.7 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/6.1 6. Creating a database - Unsolved.xlsx.xlsx 31.4 kB
  • 17. Capital Budgeting - A Complete Case Study/6.1 5. Financing_unsolved.xlsx.xlsx 30.7 kB
  • 17. Capital Budgeting - A Complete Case Study/7.2 6. P&L_unsolved.xlsx.xlsx 30.4 kB
  • 17. Capital Budgeting - A Complete Case Study/8.1 7. Cash flow_unsolved.xlsx.xlsx 30.4 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/4.2 4. Order a worksheet - Unsolved.xlsx.xlsx 29.3 kB
  • 7. Financial functions in Excel/3.2 Solution-Loan-Schedule.xlsx.xlsx 23.2 kB
  • 3. Useful tips and tools for your work in Excel/12.1 03 24 Select Special (F5) Solved.xlsx.xlsx 22.8 kB
  • 3. Useful tips and tools for your work in Excel/12.4 03 24 Select Special (F5) Exercise & Text.xlsx.xlsx 22.1 kB
  • 17. Capital Budgeting - A Complete Case Study/5.1 4. Working Capital_unsolved.xlsx.xlsx 21.7 kB
  • 17. Capital Budgeting - A Complete Case Study/5.2 4. Working Capital_unsolved.xlsx.xlsx 21.7 kB
  • 3. Useful tips and tools for your work in Excel/24.2 Exercise_Filter by Color.xlsx.xlsx 21.0 kB
  • 7. Financial functions in Excel/3.3 05 15 PMT.xlsx.xlsx 20.7 kB
  • 17. Capital Budgeting - A Complete Case Study/4.2 3. Fixed Asset Rollforward.xlsx.xlsx 20.1 kB
  • 17. Capital Budgeting - A Complete Case Study/4.1 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx 19.0 kB
  • 5. Excel's key functions and functionalities made easy/12.7 Solution_Index; Match; Index and Match.xlsx.xlsx 17.4 kB
  • 17. Capital Budgeting - A Complete Case Study/3.1 2. Savings Forecast.xlsx.xlsx 17.0 kB
  • 5. Excel's key functions and functionalities made easy/17.5 05 47 Goal Seek Solved.xlsx.xlsx 16.6 kB
  • 5. Excel's key functions and functionalities made easy/4.1 05-38-Counts-Solved.xlsx.xlsx 16.5 kB
  • 5. Excel's key functions and functionalities made easy/17.2 05 47 Goal Seek Exercise & Text.xlsx.xlsx 16.5 kB
  • 7. Financial functions in Excel/3.1 Exercise-Loan-Schedule.xlsx.xlsx 16.2 kB
  • 5. Excel's key functions and functionalities made easy/12.6 Exercise-Index-Match-Index-and-Match (1).xlsx.xlsx 15.8 kB
  • 5. Excel's key functions and functionalities made easy/15.4 05 45 IFERROR Solved.xlsx.xlsx 15.7 kB
  • 5. Excel's key functions and functionalities made easy/4.5 05 38 Counts Exercise & Text.xlsx.xlsx 15.6 kB
  • 5. Excel's key functions and functionalities made easy/5.4 05 39 Average, AverageIF Solution.xlsx.xlsx 15.4 kB
  • 5. Excel's key functions and functionalities made easy/3.2 05 37 Sum, Sumif, Sumifs Solved.xlsx.xlsx 15.2 kB
  • 5. Excel's key functions and functionalities made easy/9.3 05 41 MIN MAX Solved.xlsx.xlsx 15.2 kB
  • 17. Capital Budgeting - A Complete Case Study/3.2 2. Savings Forecast_unsolved.xlsx.xlsx 15.1 kB
  • 5. Excel's key functions and functionalities made easy/5.3 05 39 Average, AverageIF Exercise & Text.xlsx.xlsx 14.9 kB
  • 15. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.vtt 14.9 kB
  • 5. Excel's key functions and functionalities made easy/3.1 05 37 Sum, Sumif, Sumifs Exercise & Text.xlsx.xlsx 14.8 kB
  • 5. Excel's key functions and functionalities made easy/9.4 05 41 MIN MAX Exercise & Text.xlsx.xlsx 14.7 kB
  • 5. Excel's key functions and functionalities made easy/15.1 05 45 IFERROR Exercise & Text.xlsx.xlsx 14.6 kB
  • 5. Excel's key functions and functionalities made easy/11.2 05 43 Vlookup, Hlookup Solved.xlsx.xlsx 14.5 kB
  • 3. Useful tips and tools for your work in Excel/14.4 Dynamic Naming - Solved.xlsx.xlsx 14.2 kB
  • 3. Useful tips and tools for your work in Excel/14.5 Dynamic Naming – Unsolved.xlsx.xlsx 13.9 kB
  • 2. Introduction to Excel/14.2 02 14 Paste Special Exercise & Text.xlsx.xlsx 13.8 kB
  • 2. Introduction to Excel/14.1 02 14 Paste Special Solved.xlsx.xlsx 13.8 kB
  • 2. Introduction to Excel/11.1 02 12 Functions Exercise & Text.xlsx.xlsx 13.6 kB
  • 5. Excel's key functions and functionalities made easy/19.3 05 48 Sensitivity Analysis Solved.xlsx.xlsx 13.4 kB
  • 5. Excel's key functions and functionalities made easy/3.3 Sum, Sumif, Sumifs – Solved.xlsx.xlsx 13.3 kB
  • 5. Excel's key functions and functionalities made easy/3.4 Sum, Sumif, Sumifs - Unsolved.xlsx.xlsx 13.2 kB
  • 3. Useful tips and tools for your work in Excel/25.1 Exercise_Conditional Formatting.xlsx.xlsx 13.2 kB
  • 5. Excel's key functions and functionalities made easy/19.4 05 48 Sensitivity Analysis Exercise & Text.xlsx.xlsx 12.9 kB
  • 2. Introduction to Excel/12.2 02 13 Copy Cut Paste Solved.xlsx.xlsx 12.9 kB
  • 7. Financial functions in Excel/4.2 Solution-Date-Functions (2).xlsx.xlsx 12.7 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/21. Learn how to create Bridge charts.vtt 12.7 kB
  • 7. Financial functions in Excel/2.2 Solution-IRR.xlsx.xlsx 12.6 kB
  • 7. Financial functions in Excel/4.3 05 16 Date Functions.xlsx.xlsx 12.5 kB
  • 5. Excel's key functions and functionalities made easy/7.2 05 40 2 Left, Right etc Solved.xlsx.xlsx 12.5 kB
  • 5. Excel's key functions and functionalities made easy/13.2 Solution_Index, Match, Match.xlsx.xlsx 12.5 kB
  • 2. Introduction to Excel/6.1 02 8 The Ribbon Exercise & Text.xlsx.xlsx 12.4 kB
  • 5. Excel's key functions and functionalities made easy/12.5 05 44 Index, Match Solved.xlsx.xlsx 12.4 kB
  • 5. Excel's key functions and functionalities made easy/11.3 05 43 Vlookup, Hlookup Exercise & Text.xlsx.xlsx 12.2 kB
  • 3. Useful tips and tools for your work in Excel/14.2 03 25 Assigning Dynamic Names Solved.xlsx.xlsx 12.0 kB
  • 5. Excel's key functions and functionalities made easy/16.2 05 46 Choose Solved.xlsx.xlsx 12.0 kB
  • 2. Introduction to Excel/9.4 02 11 Formulas Exercise Text.xlsx.xlsx 12.0 kB
  • 5. Excel's key functions and functionalities made easy/10.3 05 42 Round Solved.xlsx.xlsx 12.0 kB
  • 5. Excel's key functions and functionalities made easy/7.4 05 40 2 Left, Right etc Exercise & Text.xlsx.xlsx 12.0 kB
  • 5. Excel's key functions and functionalities made easy/12.3 Index & Match – Solved.xlsx.xlsx 12.0 kB
  • 5. Excel's key functions and functionalities made easy/4.4 Count, Countif, Countifs - Solved.xlsx.xlsx 12.0 kB
  • 3. Useful tips and tools for your work in Excel/16.1 03 26 Defining a Named Range Solved.xlsx.xlsx 11.9 kB
  • 2. Introduction to Excel/8.2 02 10 Formatting Exercise Text.xlsx.xlsx 11.9 kB
  • 2. Introduction to Excel/8.3 02 10 Formatting Solved.xlsx.xlsx 11.9 kB
  • 5. Excel's key functions and functionalities made easy/12.4 05 44 Index, Match Exercise & Text.xlsx.xlsx 11.9 kB
  • 5. Excel's key functions and functionalities made easy/13.1 Exercise_Index, Match, Match.xlsx.xlsx 11.9 kB
  • 7. Financial functions in Excel/2.1 Exercise-IRR.xlsx.xlsx 11.8 kB
  • 17. Capital Budgeting - A Complete Case Study/2.1 1. Drivers.xlsx.xlsx 11.8 kB
  • 3. Useful tips and tools for your work in Excel/21.4 03 30 Custom Sort Solved.xlsx.xlsx 11.7 kB
  • 3. Useful tips and tools for your work in Excel/11.1 Set Print Area – Unsolved.xlsx.xlsx 11.7 kB
  • 7. Financial functions in Excel/4.1 Exercise-Date-Functions.xlsx.xlsx 11.7 kB
  • 7. Financial functions in Excel/4.4 Exercise-Date-Functions.xlsx.xlsx 11.7 kB
  • 2. Introduction to Excel/4.1 02 7 Basic Manipulations Exercise Text.xlsx.xlsx 11.7 kB
  • 3. Useful tips and tools for your work in Excel/7.2 03 20 Alt+Enter Solved.xlsx.xlsx 11.7 kB
  • 3. Useful tips and tools for your work in Excel/21.3 03 30 Custom Sort Exercise & Text.xlsx.xlsx 11.6 kB
  • 3. Useful tips and tools for your work in Excel/17.3 03 27 Assigning Custom Formats Exercise & Text.xlsx.xlsx 11.6 kB
  • 2. Introduction to Excel/12.1 02 13 Copy Cut Paste Exercise Text.xlsx.xlsx 11.6 kB
  • 5. Excel's key functions and functionalities made easy/10.1 05 42 Round Exercise & Text.xlsx.xlsx 11.6 kB
  • 3. Useful tips and tools for your work in Excel/20.3 03 29 Drop-down List Exercise & Text.xlsx.xlsx 11.6 kB
  • 5. Excel's key functions and functionalities made easy/16.1 05 46 Choose Exercise & Text.xlsx.xlsx 11.6 kB
  • 3. Useful tips and tools for your work in Excel/8.5 03 21 Text to Columns Solved.xlsx.xlsx 11.6 kB
  • 5. Excel's key functions and functionalities made easy/12.1 Index & Match - Unsolved.xlsx.xlsx 11.6 kB
  • 5. Excel's key functions and functionalities made easy/4.3 Count, Countif, Countifs – Unsolved.xlsx.xlsx 11.6 kB
  • 3. Useful tips and tools for your work in Excel/14.3 03 25 Assigning Dynamic Names Exercise & Text.xlsx.xlsx 11.5 kB
  • 3. Useful tips and tools for your work in Excel/11.2 Set Print Area - Solved.xlsx.xlsx 11.5 kB
  • 7. Financial functions in Excel/2.3 05 14 IRR.xlsx.xlsx 11.5 kB
  • 3. Useful tips and tools for your work in Excel/18.1 Creating a Macro - Solved.xlsx.xlsx 11.4 kB
  • 5. Excel's key functions and functionalities made easy/11.1 Vlookup, Hlookup – Solved.xlsx.xlsx 11.4 kB
  • 3. Useful tips and tools for your work in Excel/7.4 03 20 Alt+Enter Exercise & Text.xlsx.xlsx 11.4 kB
  • 5. Excel's key functions and functionalities made easy/7.3 Text Functions - Solved.xlsx.xlsx 11.4 kB
  • 3. Useful tips and tools for your work in Excel/17.1 03 27 Assigning Custom Formats Solved.xlsx.xlsx 11.3 kB
  • 3. Useful tips and tools for your work in Excel/16.4 03 26 Defining a Named Range Exercise & Text.xlsx.xlsx 11.3 kB
  • 2. Introduction to Excel/7.2 02 9 Data Entry Exercise Text.xlsx.xlsx 11.2 kB
  • 2. Introduction to Excel/2.1 02 6 Overview of Excel Solved.xlsx.xlsx 11.1 kB
  • 3. Useful tips and tools for your work in Excel/20.2 Data Validation - Solved.xlsx.xlsx 11.1 kB
  • 3. Useful tips and tools for your work in Excel/20.4 Data Validation – Unsolved.xlsx.xlsx 11.1 kB
  • 3. Useful tips and tools for your work in Excel/5.5 03 19 Fixing Cells Solved.xlsx.xlsx 11.1 kB
  • 3. Useful tips and tools for your work in Excel/2.5 03 17 Formatting a Worksheet Solved.xlsx.xlsx 11.0 kB
  • 5. Excel's key functions and functionalities made easy/11.5 Vlookup, Hlookup - Unsolved.xlsx.xlsx 11.0 kB
  • 3. Useful tips and tools for your work in Excel/5.2 03 19 Fixing Cells Exercise & Text.xlsx.xlsx 10.9 kB
  • 3. Useful tips and tools for your work in Excel/2.4 03 17 Formatting a Worksheet Exercise & Text.xlsx.xlsx 10.9 kB
  • 5. Excel's key functions and functionalities made easy/7.1 Text Functions - Unsolved.xlsx.xlsx 10.9 kB
  • 3. Useful tips and tools for your work in Excel/8.2 03 21 Text to Columns Exercise & Text.xlsx.xlsx 10.8 kB
  • 3. Useful tips and tools for your work in Excel/12.2 Select Special.xlsx.xlsx 10.8 kB
  • 2. Introduction to Excel/2.2 02 6 Overview of Excel Exercise & Text.xlsx.xlsx 10.7 kB
  • 3. Useful tips and tools for your work in Excel/18.2 03 28 Macros Exercise & Text.xlsx.xlsx 10.6 kB
  • 3. Useful tips and tools for your work in Excel/16.5 Naming ranges - Solved.xlsx.xlsx 10.6 kB
  • 3. Useful tips and tools for your work in Excel/10.3 03 22 Wrap Text Solved.xlsx.xlsx 10.4 kB
  • 3. Useful tips and tools for your work in Excel/10.4 03 22 Wrap Text Exercise & Text.xlsx.xlsx 10.4 kB
  • 6. Update! 15 December - Exercise/2. Exercise - Excel's Sumifs function - solved & explained.vtt 10.3 kB
  • 3. Useful tips and tools for your work in Excel/8.1 Text to columns - Solved.xlsx.xlsx 10.1 kB
  • 2. Introduction to Excel/8.1 Formatting - Solved.xlsx.xlsx 10.1 kB
  • 3. Useful tips and tools for your work in Excel/8.3 Text to columns – Unsolved.xlsx.xlsx 10.0 kB
  • 5. Excel's key functions and functionalities made easy/16.3 Choose - Solved.xlsx.xlsx 9.9 kB
  • 3. Useful tips and tools for your work in Excel/18.3 Creating a Macro - Unsolved.xlsx.xlsx 9.9 kB
  • 3. Useful tips and tools for your work in Excel/7.3 Alt + Enter - Solved.xlsx.xlsx 9.9 kB
  • 3. Useful tips and tools for your work in Excel/7.5 Alt + Enter – Unsolved.xlsx.xlsx 9.9 kB
  • 3. Useful tips and tools for your work in Excel/10.1 Wrap text – Unsolved.xlsx.xlsx 9.8 kB
  • 3. Useful tips and tools for your work in Excel/10.2 Wrap text - Solved.xlsx.xlsx 9.8 kB
  • 5. Excel's key functions and functionalities made easy/15.3 Iferror.xlsx.xlsx 9.8 kB
  • 3. Useful tips and tools for your work in Excel/2.1 Formatting a worksheet - Solved.xlsx.xlsx 9.8 kB
  • 5. Excel's key functions and functionalities made easy/19.5 Data Tables - Solved.xlsx.xlsx 9.7 kB
  • 5. Excel's key functions and functionalities made easy/15.5 Iferror – Unsolved.xlsx.xlsx 9.6 kB
  • 5. Excel's key functions and functionalities made easy/5.2 Average, Averageif - Solved.xlsx.xlsx 9.6 kB
  • 2. Introduction to Excel/9.3 Formulas - Solved.xlsx.xlsx 9.6 kB
  • 2. Introduction to Excel/11.2 Functions - Solved.xlsx.xlsx 9.6 kB
  • 5. Excel's key functions and functionalities made easy/16.4 Choose – Unsolved.xlsx.xlsx 9.6 kB
  • 2. Introduction to Excel/9.1 Formulas – Unsolved.xlsx.xlsx 9.5 kB
  • 5. Excel's key functions and functionalities made easy/19.1 Data Tables – Unsolved.xlsx.xlsx 9.5 kB
  • 2. Introduction to Excel/11.3 Functions – Unsolved.xlsx.xlsx 9.5 kB
  • 5. Excel's key functions and functionalities made easy/9.2 Max, min – Solved.xlsx.xlsx 9.4 kB
  • 5. Excel's key functions and functionalities made easy/5.1 Average, Averageif – Unsolved.xlsx.xlsx 9.2 kB
  • 3. Useful tips and tools for your work in Excel/2.3 Formatting a worksheet – Unsolved.xlsx.xlsx 9.2 kB
  • 5. Excel's key functions and functionalities made easy/9.1 Max, min - Unsolved.xlsx.xlsx 9.2 kB
  • 2. Introduction to Excel/8.4 Formatting - Unsolved.xlsx.xlsx 9.1 kB
  • 5. Excel's key functions and functionalities made easy/17.3 Goal Seek - Solved.xlsx.xlsx 9.1 kB
  • 5. Excel's key functions and functionalities made easy/17.4 Goal Seek – Unsolved.xlsx.xlsx 9.1 kB
  • 3. Useful tips and tools for your work in Excel/16.3 Naming ranges – Unsolved.xlsx.xlsx 9.0 kB
  • 5. Excel's key functions and functionalities made easy/11. Learn how to transfer data efficiently in Excel Vlookup and Hlookup.vtt 8.7 kB
  • 5. Excel's key functions and functionalities made easy/12. Index, Match and their combination - the perfect substitute for Vlookup.vtt 8.4 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/3. The various stages of a complete DCF Valuation.vtt 7.8 kB
  • 16. Capital budgeting - The theory/5. Calculating cost of equity.vtt 7.7 kB
  • 17. Capital Budgeting - A Complete Case Study/10. Finding cost of equity.vtt 7.3 kB
  • 11. Financial Modeling Fundamentals/12. Modeling the Income statement.vtt 7.2 kB
  • 11. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.vtt 7.0 kB
  • 15. Tesla valuation - Complete practical exercise/28. Estimating Weighted Average Cost of Capital (WACC).vtt 7.0 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/22. Calculating Unlevered Free Cash Flow.vtt 6.9 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/18. Build a Column Stacked chart with a secondary line axis in Excel.vtt 6.9 kB
  • 10. Case Study - Building an FMCG Model from Scratch/8. GetPivotData is great! Extracting data from the Master Pivot Table.vtt 6.8 kB
  • 16. Capital budgeting - The theory/9. Estimating the project's cash flows.vtt 6.8 kB
  • 15. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.vtt 6.4 kB
  • 2. Introduction to Excel/8. Introduction to formatting.vtt 6.3 kB
  • 7. Financial functions in Excel/1. Future and present values in Excel.vtt 6.3 kB
  • 16. Capital budgeting - The theory/4. Calculating future and present Value.vtt 6.2 kB
  • 15. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered Free Cash Flow.vtt 6.2 kB
  • 17. Capital Budgeting - A Complete Case Study/2. Organizing an Inputs sheet.vtt 6.2 kB
  • 7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.vtt 6.0 kB
  • 11. Financial Modeling Fundamentals/14. Modeling the Balance sheet - Part 2.vtt 5.9 kB
  • 11. Financial Modeling Fundamentals/5. Financial modeling - best practices.vtt 5.8 kB
  • 3. Useful tips and tools for your work in Excel/25. Working with conditional formatting.vtt 5.7 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/31. Using charts to summarize the results of the DCF model.vtt 5.7 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/7. Use Vlookup to fill the Database sheet.vtt 5.7 kB
  • 11. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.vtt 5.6 kB
  • 15. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.vtt 5.6 kB
  • 5. Excel's key functions and functionalities made easy/7. Elaborate text efficiently Left, Right, Mid, Upper, Lower,Proper, Concatenate.vtt 5.4 kB
  • 7. Financial functions in Excel/4. Date functions in Excel.vtt 5.4 kB
  • 5. Excel's key functions and functionalities made easy/13. A great Excel technique Index, Match, Match.vtt 5.4 kB
  • 15. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.vtt 5.3 kB
  • 4. Keyboard shortcuts in Excel/1. Keyboard shortcuts Save LOTS of time in Excel.vtt 5.3 kB
  • 15. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.vtt 5.2 kB
  • 17. Capital Budgeting - A Complete Case Study/4. Fixed asset rollforward.vtt 5.2 kB
  • 5. Excel's key functions and functionalities made easy/3. Key Excel functions Sum, Sumif and Sumifs.vtt 5.0 kB
  • 17. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and completing the exercise.vtt 5.0 kB
  • 15. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.vtt 4.9 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/19. Learn how to build effective Doughnut charts in Excel.vtt 4.9 kB
  • 5. Excel's key functions and functionalities made easy/19. Include sensitivity analysis in your models through Data Tables.vtt 4.8 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/20. Learn how to build an Area chart in Excel.vtt 4.8 kB
  • 10. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.vtt 4.7 kB
  • 10. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.vtt 4.7 kB
  • 15. Tesla valuation - Complete practical exercise/21. Forecasting other assets.vtt 4.7 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/23. Calculating Net Cash Flow.vtt 4.6 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/29. Sensitivity analysis for WACC and perpetuity growth.vtt 4.6 kB
  • 5. Excel's key functions and functionalities made easy/4. Key Excel functions Count, Counta, Countif, Countifs.vtt 4.6 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/9. Use SUMIF to complete the Database sheet.vtt 4.6 kB
  • 8. Microsoft Excel's Pivot Tables in Depth/6. An introduction to slicers - The modern-day Pivot Table filters.vtt 4.5 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/19. Completing the output BS sheet for the historical period.vtt 4.5 kB
  • 8. Microsoft Excel's Pivot Tables in Depth/4. Modifying and pivoting fields to obtain the Pivot Table you need.vtt 4.5 kB
  • 15. Tesla valuation - Complete practical exercise/26. Bridging Unlevered Free Cash Flow to Net Cash Flow.vtt 4.5 kB
  • 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.5 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/8. Modeling other items Other revenues and Cogs.vtt 4.5 kB
  • 2. Introduction to Excel/11. Introduction to Excel functions.vtt 4.5 kB
  • 15. Tesla valuation - Complete practical exercise/31. Final comments.vtt 4.4 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/24. Obtaining the rest of the cash flows through Find and Replace.vtt 4.3 kB
  • 15. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.vtt 4.3 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/10. Use Index & Match as a substitute for Vlookup.vtt 4.3 kB
  • 15. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.vtt 4.2 kB
  • 2. Introduction to Excel/9. Introduction to Excel formulas.vtt 4.2 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/6. Modeling the top line.vtt 4.2 kB
  • 8. Microsoft Excel's Pivot Tables in Depth/2. Creating Pivot Tables easily!.vtt 4.1 kB
  • 17. Capital Budgeting - A Complete Case Study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.vtt 4.0 kB
  • 16. Capital budgeting - The theory/8. The type of cash flows we will have in a project.vtt 4.0 kB
  • 2. Introduction to Excel/2. Overview of Excel.vtt 4.0 kB
  • 10. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.vtt 3.9 kB
  • 8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GetPivotData - A very important Excel function.vtt 3.9 kB
  • 17. Capital Budgeting - A Complete Case Study/8. Calculating project cash flows.vtt 3.8 kB
  • 15. Tesla valuation - Complete practical exercise/23. Completing Unlevered Free Cash Flow.vtt 3.6 kB
  • 16. Capital budgeting - The theory/6. Coming up with project-specific beta.vtt 3.6 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/4. Description of the structure of the DCF model.vtt 3.5 kB
  • 10. Case Study - Building an FMCG Model from Scratch/10. Getting fancy with Excel slicers - Good-looking Excel slicers.vtt 3.5 kB
  • 10. Case Study - Building an FMCG Model from Scratch/9. Combining Slicers and GetPivotData The key to our success.vtt 3.5 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/20. Creating a structure for the calculation of Unlevered Free Cash Flows.vtt 3.4 kB
  • 11. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.vtt 3.4 kB
  • 3. Useful tips and tools for your work in Excel/18. Macros are a great timesaver! Here's why!.vtt 3.4 kB
  • 2. Introduction to Excel/7. Data entry in Excel.vtt 3.4 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/13. Formatting sets You apart from the competition in Excel - A Practical Example.vtt 3.4 kB
  • 17. Capital Budgeting - A Complete Case Study/9. Estimating the weighted average cost of capital (WACC).vtt 3.4 kB
  • 17. Capital Budgeting - A Complete Case Study/11. Discounting the project's cash flows and residual value.vtt 3.4 kB
  • 7. Financial functions in Excel/2. Calculating the rate of return of an investment with the IRR function.vtt 3.3 kB
  • 17. Capital Budgeting - A Complete Case Study/6. Modeling debt financing.vtt 3.3 kB
  • 17. Capital Budgeting - A Complete Case Study/1. Introduction to the Capital Budgeting exercise.vtt 3.3 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/16. Calculating year-on-year percentage variations the proper way.vtt 3.3 kB
  • 11. Financial Modeling Fundamentals/13. Modeling the Balance sheet - Part 1.vtt 3.3 kB
  • 15. Tesla valuation - Complete practical exercise/10. Forecasting 'energy' and 'services' revenue.vtt 3.2 kB
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.vtt 3.2 kB
  • 11. Financial Modeling Fundamentals/3. Why use financial models.vtt 3.2 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/26. Discounting Unlevered Free Cash Flows to obtain their Present Value.vtt 3.1 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/14. Populate the P&L sheet with Sumif.vtt 3.1 kB
  • 15. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.vtt 3.1 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.vtt 3.1 kB
  • 2. Introduction to Excel/6. The Excel ribbon.vtt 3.1 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/3. Understand your data source before you start working on it.vtt 3.0 kB
  • 17. Capital Budgeting - A Complete Case Study/5. The impact of working capital.vtt 3.0 kB
  • 11. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.vtt 3.0 kB
  • 15. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.vtt 2.9 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/9. Modeling other items Operating expenses and D&A.vtt 2.9 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/14. Forecasting DSO, DPO and DOI.vtt 2.9 kB
  • 10. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.vtt 2.9 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/10. Modeling other items Interest expenses, Extraordinary items and Taxes.vtt 2.9 kB
  • 15. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.vtt 2.8 kB
  • 11. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.vtt 2.8 kB
  • 16. Capital budgeting - The theory/2. Why we need Capital budgeting.vtt 2.8 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/11. Mapping the rows in the Database sheet.vtt 2.7 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/15. Learn how to find mistakes with Countif.vtt 2.7 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/7. Introducing scenarios to the model with Choose.vtt 2.7 kB
  • 5. Excel's key functions and functionalities made easy/16. Learn how to render your models flexible with Choose.vtt 2.7 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/17. Populating the output P&L sheet.vtt 2.7 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/32. You Made It!.vtt 2.7 kB
  • 16. Capital budgeting - The theory/3. The time value of money.vtt 2.7 kB
  • 5. Excel's key functions and functionalities made easy/21. Excel's dynamic and interactive tables Pivot tables.vtt 2.6 kB
  • 5. Excel's key functions and functionalities made easy/17. Use Goal Seek to find the result that you are looking for.vtt 2.6 kB
  • 3. Useful tips and tools for your work in Excel/5. Introduction to fixing of cell references.vtt 2.6 kB
  • 15. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.vtt 2.6 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/16. Creating an output P&L sheet.vtt 2.6 kB
  • 10. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.vtt 2.5 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/12. Building the structure of the P&L sheet.vtt 2.5 kB
  • 10. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.vtt 2.5 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/27. Calculating Continuing Value and Enterprise Value of the business.vtt 2.5 kB
  • 16. Capital budgeting - The theory/7. Weighted Average Cost of Capital (WACC).vtt 2.5 kB
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The approach to take this course.vtt 2.4 kB
  • 15. Tesla valuation - Complete practical exercise/22. Forecasting other liabilities.vtt 2.4 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/4. Order the source worksheets.vtt 2.4 kB
  • 11. Financial Modeling Fundamentals/2. What is a financial model.vtt 2.4 kB
  • 2. Introduction to Excel/12. Cut, copy, & paste.vtt 2.4 kB
  • 5. Excel's key functions and functionalities made easy/5. Key Excel functions Average and Averageif.vtt 2.3 kB
  • 8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.vtt 2.3 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/6. Learn how to create a database.vtt 2.3 kB
  • 15. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.vtt 2.3 kB
  • 3. Useful tips and tools for your work in Excel/8. Learn how to organize your data with Text to Columns.vtt 2.3 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/25. Introducing Weighted Average Cost of Capital and Perpetuity Growth.vtt 2.2 kB
  • 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.vtt 2.2 kB
  • 3. Useful tips and tools for your work in Excel/2. Initial formatting of an Excel sheet to render it professional.vtt 2.2 kB
  • 18. Bonus lecture/1. Bonus lecture Next steps.html 2.2 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/21. Bridging Unlevered Free Cash Flow to Net Cash Flow.vtt 2.2 kB
  • 15. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.vtt 2.2 kB
  • 15. Tesla valuation - Complete practical exercise/30. Calculating enterprise value, equity value, and price per share.vtt 2.2 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/18. Populating the output BS sheet.vtt 2.2 kB
  • 3. Useful tips and tools for your work in Excel/20. Create a drop-down list by using Data Validation.vtt 2.2 kB
  • 15. Tesla valuation - Complete practical exercise/16. Calculating DSO, DIO, DPO.vtt 2.2 kB
  • 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
  • 17. Capital Budgeting - A Complete Case Study/7. Adding a P&L sheet.vtt 2.1 kB
  • 5. Excel's key functions and functionalities made easy/15. Using Excel's Iferror function to trap spreadsheet errors.vtt 2.1 kB
  • 3. Useful tips and tools for your work in Excel/24. Filter by color - an excellent tool.vtt 2.1 kB
  • 8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.vtt 2.0 kB
  • 2. Introduction to Excel/4. Basic manipulations with rows and columns.vtt 2.0 kB
  • 3. Useful tips and tools for your work in Excel/17. Assign custom formats to specific cells within a financial model (e.g Multiples).vtt 1.9 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/30. A possible application of Goal Seek.vtt 1.9 kB
  • 3. Useful tips and tools for your work in Excel/12. Find and select special types of cells with Select Special (F5).vtt 1.9 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/12. An introduction to the Days methodology.vtt 1.9 kB
  • 16. Capital budgeting - The theory/1. Introduction to Capital budgeting.vtt 1.8 kB
  • 15. Tesla valuation - Complete practical exercise/18. Fill in the P&L output sheet.vtt 1.8 kB
  • 3. Useful tips and tools for your work in Excel/3. Fast scrolling through Excel sheets.vtt 1.8 kB
  • 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
  • 15. Tesla valuation - Complete practical exercise/2. The input data we will work with.vtt 1.7 kB
  • 15. Tesla valuation - Complete practical exercise/17. Producing a clean P&L output sheet.vtt 1.7 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/28. Calculating Equity Value.vtt 1.7 kB
  • 3. Useful tips and tools for your work in Excel/16. Define a named range in Excel.vtt 1.7 kB
  • 3. Useful tips and tools for your work in Excel/21. Using Custom-sort in order to sort multiple columns within a table.vtt 1.6 kB
  • 15. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.vtt 1.6 kB
  • 3. Useful tips and tools for your work in Excel/14. Learn how to assign dynamic names within a financial model.vtt 1.6 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/1. Case study - Build a P&L from scratch - Welcome lecture.vtt 1.6 kB
  • 3. Useful tips and tools for your work in Excel/22. Create a great Index page at the beginning of your models - Hyperlinks.vtt 1.5 kB
  • 17. Capital Budgeting - A Complete Case Study/14. Congratulations!!.vtt 1.5 kB
  • 3. Useful tips and tools for your work in Excel/11. Create easily printable documents in Excel by using Set Print Area.vtt 1.5 kB
  • 2. Introduction to Excel/14. Paste special.vtt 1.5 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/5. A glimpse at the company we are valuing - Cheeseco.vtt 1.5 kB
  • 3. Useful tips and tools for your work in Excel/23. Fix the top row of your table with Freeze Panes.vtt 1.4 kB
  • 15. Tesla valuation - Complete practical exercise/25. Calculating Net income.vtt 1.4 kB
  • 14. Learn how to build a Discounted Cash Flow model in Excel/2. Introduction to the DCF exercise.vtt 1.3 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/23. Course Challenge - Apply your skills in practice!.vtt 1.2 kB
  • 15. Tesla valuation - Complete practical exercise/27. Balancing the Balance sheet.vtt 1.2 kB
  • 5. Excel's key functions and functionalities made easy/10. Include Round in your financial models.vtt 1.2 kB
  • 5. Excel's key functions and functionalities made easy/9. Find the minimum or maximum value in a range of cells in Excel.vtt 1.1 kB
  • 5. Excel's key functions and functionalities made easy/1. Excel's key functions - Welcome lecture.vtt 1.1 kB
  • 11. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.vtt 1.1 kB
  • 3. Useful tips and tools for your work in Excel/1. Excel best practices - Welcome lecture.vtt 1.0 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/2. Introduction to the case study.vtt 1.0 kB
  • 3. Useful tips and tools for your work in Excel/7. Using the 'Alt + Enter' combination.vtt 1.0 kB
  • 2. Introduction to Excel/1. Introduction to Excel - welcome lecture.vtt 911 Bytes
  • 14. Learn how to build a Discounted Cash Flow model in Excel/11. Forecasting Balance Sheet items.vtt 893 Bytes
  • 14. Learn how to build a Discounted Cash Flow model in Excel/1. Valuation Case study - Welcome lecture.vtt 869 Bytes
  • 3. Useful tips and tools for your work in Excel/10. Learn how to use the Wrap Text button.vtt 869 Bytes
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/5. Download all course materials.html 758 Bytes
  • 9. Case study - Building a complete P&L from scratch in Excel/17. Create professional and good-looking charts - Introduction.vtt 461 Bytes
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/2. Bonus! Welcome gift.html 167 Bytes
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/3. Welcome gift number 2.html 167 Bytes
  • 12. Introduction to Company Valuation/1. The core theory behind Company Valuation.html 167 Bytes
  • 13. Introduction to Mergers & Acquisitions/1. Introduction to Mergers & Acquisitions.html 167 Bytes
  • 2. Introduction to Excel/15. Basic operations in Excel - 38 pages.html 167 Bytes
  • 4. Keyboard shortcuts in Excel/2. Keyboard shortcuts in Excel.html 167 Bytes
  • 5. Excel's key functions and functionalities made easy/2. Key functions in Excel If.html 167 Bytes
  • 6. Update! 15 December - Exercise/1. Exercise - Excel's Sumifs function - unsolved.html 167 Bytes
  • 10. Case Study - Building an FMCG Model from Scratch/12. Dynamic reporting with GETPIVOTDATA and slicers.html 166 Bytes
  • 17. Capital Budgeting - A Complete Case Study/13. Build a complete capital budgeting model from scratch.html 166 Bytes
  • 11. Financial Modeling Fundamentals/10. Forecasting financials - Quiz.html 163 Bytes
  • 11. Financial Modeling Fundamentals/15. Building a financial model - Quiz.html 163 Bytes
  • 11. Financial Modeling Fundamentals/7. Financial modeling - Quiz.html 163 Bytes
  • 2. Introduction to Excel/10. Introduction to Excel formulas.html 163 Bytes
  • 2. Introduction to Excel/13. Cut, copy, & paste.html 163 Bytes
  • 2. Introduction to Excel/3. Overview of Excel.html 163 Bytes
  • 2. Introduction to Excel/5. Rows and columns.html 163 Bytes
  • 3. Useful tips and tools for your work in Excel/13. Select Special.html 163 Bytes
  • 3. Useful tips and tools for your work in Excel/15. Assigning dynamic names.html 163 Bytes
  • 3. Useful tips and tools for your work in Excel/19. Excel Macros - quiz.html 163 Bytes
  • 3. Useful tips and tools for your work in Excel/4. Fast scrolling through Excel sheets.html 163 Bytes
  • 3. Useful tips and tools for your work in Excel/6. Introduction to fixing of cell references.html 163 Bytes
  • 3. Useful tips and tools for your work in Excel/9. Learn how to organize your data with Text to Columns.html 163 Bytes
  • 5. Excel's key functions and functionalities made easy/14. Index, Match and their combination - the perfect substitute for Vlookup.html 163 Bytes
  • 5. Excel's key functions and functionalities made easy/18. Use Goal Seek in order to find the result that you are looking for.html 163 Bytes
  • 5. Excel's key functions and functionalities made easy/20. Include sensitivity analysis in your models through Data Tables.html 163 Bytes
  • 5. Excel's key functions and functionalities made easy/6. Key Excel functions Average and Averageif.html 163 Bytes
  • 5. Excel's key functions and functionalities made easy/8. Elaborate text efficiently Left, Right, Mid, Upper, Lower,Proper, Concatenate.html 163 Bytes
  • 3. Useful tips and tools for your work in Excel/26. Useful tips and tools for your work in Excel - quiz.html 162 Bytes
  • 5. Excel's key functions and functionalities made easy/22. Excel's key functions and functionalities made easy.html 162 Bytes
  • 9. Case study - Building a complete P&L from scratch in Excel/22. Case Study - Building a Complete P&L from scratch in Excel.html 162 Bytes
  • [FreeCourseLab.com].url 126 Bytes
  • 9. Case study - Building a complete P&L from scratch in Excel/8. 50% Completed!.vtt 51 Bytes

随机展示

相关说明

本站不存储任何资源内容，只收集BT种子元数据(例如文件名和文件大小)和磁力链接(BT种子标识符)，并提供查询服务，是一个完全合法的搜索引擎系统。 网站不提供种子下载服务，用户可以通过第三方链接或磁力链接获取到相关的种子资源。本站也不对BT种子真实性及合法性负责，请用户注意甄别！
>