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

磁力链接/BT种子名称

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

磁力链接/BT种子简介

种子哈希：4a18ffac8c8c5777672d93a02657b7c9e1c7602b
文件大小： 3.99G
已经下载：618次
下载速度：极快
收录时间：2023-04-26
最近下载：2025-10-07

地址随时变，回家记住路

小野猫.com黑猫警长.com哆啦a猫.com御猫.com科目三.com猫哭老鼠.com女猫.com☜☜☜找最新地址请保存左面网址

磁力链接

magnet:?xt=urn:btih:4A18FFAC8C8C5777672D93A02657B7C9E1C7602B
推荐使用PIKPAK网盘下载资源，PIKPAK是目前最好用网盘，10T超大空间，不和谐任何资源，支持无限次数离线下载，视频在线观看

下载BT种子文件

磁力链接 迅雷下载 在线观看 世界之窗 含羞草 极乐禁地 91视频 51品茶 逼哩逼哩 萝莉岛 欲漫涩 91短视频 成人快手 抖阴破解版 ai色色 pilipili 草榴社区 哆哔涩漫 好色先生 疯马秀 TikTok成人版 悠悠禁区 波多 听泉鉴鲍 xvideo 外网天堂 PornHub 抖音Max 呦乐园 拔萝卜 糖心视频 麻豆Vlog 暗网Xvideo

资源截图

API Integration

最近搜索

文件列表

  • 11/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4 134.6 MB
  • 17. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.mp4 104.6 MB
  • 9/7. Use VLOOKUP to fill the Database sheet.mp4 64.6 MB
  • 16/22. Calculating Unlevered free cash flow.mp4 62.6 MB
  • 17. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered free cash flow.mp4 58.6 MB
  • 17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp4 56.8 MB
  • 11/5. Learn how to create bridge charts.mp4 54.6 MB
  • 17. Tesla valuation - Complete practical exercise/26. Bridging Unlevered free cash flow to Net cash flow.mp4 53.2 MB
  • 9/10. Use INDEX & MATCH as a substitute for VLOOKUP.mp4 52.0 MB
  • 16/3. The stages of a complete DCF Valuation.mp4 51.6 MB
  • 9/9. Use SUMIF to complete the Database sheet.mp4 50.3 MB
  • 17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp4 49.8 MB
  • 16/24. Obtaining the rest of the cash flows through Find and Replace.mp4 49.0 MB
  • 11/2. Build a column stacked chart with a secondary line axis in Excel.mp4 48.6 MB
  • 17. Tesla valuation - Complete practical exercise/21. Forecasting other assets.mp4 47.4 MB
  • 17. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.mp4 47.3 MB
  • 17. Tesla valuation - Complete practical exercise/31. Final comments.mp4 47.1 MB
  • 16/8. Modeling other items Other revenues and Cogs.mp4 45.1 MB
  • 17. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.mp4 44.4 MB
  • 19. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and completing the exercise.mp4 43.4 MB
  • 16/29. Sensitivity analysis for WACC and perpetuity growth.mp4 42.4 MB
  • 5/15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4 40.8 MB
  • 9/12. In case you have any doubts about the Mapping exercise.mp4 40.4 MB
  • 17. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.mp4 39.5 MB
  • 16/19. Completing the output BS sheet for the historical period.mp4 38.2 MB
  • 16/23. Calculating Net cash flow.mp4 37.3 MB
  • 17. Tesla valuation - Complete practical exercise/29. Performing discounted cash flow valuation (DCF).mp4 36.6 MB
  • 5/13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4 36.3 MB
  • 17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp4 34.7 MB
  • 17. Tesla valuation - Complete practical exercise/23. Completing Unlevered free cash flow.mp4 34.7 MB
  • 16/31. Using charts to summarize the results of the DCF model.mp4 34.5 MB
  • 17. Tesla valuation - Complete practical exercise/28. Estimating Weighted average cost of capital (WACC).mp4 34.3 MB
  • 11/3. Learn how to build effective doughnut charts in Excel.mp4 33.7 MB
  • 6. Update! SUMIFS - Exercise/2. Exercise - Excel's SUMIFS function - solved & explained.mp4 33.3 MB
  • 12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4 32.5 MB
  • 16/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4 31.5 MB
  • 9/17. Calculating year-on-year percentage variations the proper way.mp4 31.4 MB
  • 10. Introduction to Excel charts/3. Excel chart formatting.mp4 30.0 MB
  • 11/4. Learn how to build an area chart in Excel.mp4 30.0 MB
  • 9/16. Learn how to find mistakes with COUNTIF.mp4 29.2 MB
  • 10. Introduction to Excel charts/6. Sparklines.mp4 28.9 MB
  • 4. Keyboard shortcuts in Excel/1. Keyboard shortcuts Save LOTS of time in Excel.mp4 28.9 MB
  • 9/11. Mapping the rows in the Database sheet.mp4 28.7 MB
  • 9/4. Order the source worksheets.mp4 27.8 MB
  • 10. Introduction to Excel charts/2. Editing Excel charts.mp4 27.3 MB
  • 16/17. Populating the output P&L sheet.mp4 26.8 MB
  • 17. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.mp4 26.7 MB
  • 9/14. Formatting sets You apart from the competition in Excel - A Practical Example.mp4 26.7 MB
  • 2. Introduction to Excel/8. Introduction to formatting.mp4 25.9 MB
  • 9/3. Understand your data source before you start working on it.mp4 25.8 MB
  • 3/30. Find and replace - references.mp4 25.2 MB
  • 9/15. Populate the P&L sheet with SUMIF.mp4 24.6 MB
  • 19. Capital Budgeting - A Complete Case Study/11. Discounting the project's cash flows and residual value.mp4 24.5 MB
  • 5/19. RANK is a valuable tool when using Excel for Financial and Business analysis.mp4 24.4 MB
  • 12. Case Study - Building an FMCG Model from Scratch/11.1 118. Exercise-Build-an-FMCG-Model-Complete-Lecture.xlsx.xlsx 23.9 MB
  • 16/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4 23.7 MB
  • 12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.mp4 23.7 MB
  • 17. Tesla valuation - Complete practical exercise/30. Calculating enterprise value, equity value, and price per share.mp4 23.6 MB
  • 16/20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp4 23.5 MB
  • 3/3. Fast scrolling through Excel sheets.mp4 23.2 MB
  • 12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp4 23.0 MB
  • 17. Tesla valuation - Complete practical exercise/22. Forecasting other liabilities.mp4 22.9 MB
  • 16/14. Forecasting DSO, DPO and DOI.mp4 21.9 MB
  • 12. Case Study - Building an FMCG Model from Scratch/7.1 114. Exercise-Build-an-FMCG-Model-Creating-a-Pivot-Table-Lecture.xlsx.xlsx 21.8 MB
  • 9/6. Learn how to create a database.mp4 21.7 MB
  • 3/6. Introduction to fixing of cell references.mp4 21.4 MB
  • 16/26. Discounting Unlevered free cash flows to obtain their Present value.mp4 21.2 MB
  • 2. Introduction to Excel/9. Introduction to Excel formulas.mp4 21.0 MB
  • 17. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.mp4 20.9 MB
  • 13. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.mp4 20.9 MB
  • 10. Introduction to Excel charts/1. How to insert a chart in Excel.mp4 20.8 MB
  • 12. Case Study - Building an FMCG Model from Scratch/12. This is how the report can be used in practice by high-level executives.mp4 20.8 MB
  • 3/4. Be even quicker F5 + Enter.mp4 20.7 MB
  • 12. Case Study - Building an FMCG Model from Scratch/12.1 119. Exercise-Build-an-FMCG-Model-Complete.xlsx.xlsx 20.5 MB
  • 5/3. Key Excel functions SUM, SUMIF and SUMIFS.mp4 20.3 MB
  • 18. Capital budgeting - The theory/5. Calculating cost of equity.mp4 20.1 MB
  • 17. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.mp4 20.0 MB
  • 16/16. Creating an output P&L sheet.mp4 19.7 MB
  • 18. Capital budgeting - The theory/9. Estimating the project's cash flows.mp4 19.7 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GETPIVOTDATA - A very important Excel function.mp4 18.9 MB
  • 17. Tesla valuation - Complete practical exercise/18. Fill in the P&L output sheet.mp4 18.9 MB
  • 12. Case Study - Building an FMCG Model from Scratch/10. Combining Slicers and GETPIVOTDATA The key to our success.mp4 18.7 MB
  • 3/34. Formula auditing with F2.mp4 18.6 MB
  • 16/27. Calculating Continuing value and Enterprise value of the business.mp4 18.6 MB
  • 3/25. Fix the top row of your table with Freeze Panes.mp4 18.5 MB
  • 13. Financial Modeling Fundamentals/5. Financial modeling - best practices.mp4 18.1 MB
  • 16/18. Populating the output BS sheet.mp4 17.8 MB
  • 12. Case Study - Building an FMCG Model from Scratch/8.1 115. Exercise-Build-an-FMCG-Model-GETPIVOTDATA-Lecture.xlsx.xlsx 17.7 MB
  • 5/25. Excel's dynamic and interactive tables Pivot tables.mp4 17.4 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/2. Creating Pivot Tables easily!.mp4 17.1 MB
  • 5/2. Key functions in Excel IF.mp4 17.0 MB
  • 17. Tesla valuation - Complete practical exercise/16. Calculating DSO, DIO, DPO.mp4 17.0 MB
  • 12. Case Study - Building an FMCG Model from Scratch/10.1 117. Exercise-Build-an-FMCG-Model-Inserting-Slicers-Lecture.xlsx.xlsx 16.9 MB
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The best way to take this course.mp4 16.8 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/6. An introduction to slicers - The modern-day Pivot Table filters.mp4 16.7 MB
  • 17. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.mp4 16.7 MB
  • 5/5. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 16.7 MB
  • 16/5. A glimpse at the company we are valuing - Cheeseco.mp4 16.4 MB
  • 16/30. A possible application of Goal seek.mp4 16.4 MB
  • 17. Tesla valuation - Complete practical exercise/2. The input data we will work with.mp4 15.8 MB
  • 12. Case Study - Building an FMCG Model from Scratch/4.1 111. Exercise-Build-an-FMCG-Model-Structure-Lecture.xlsx.xlsx 15.6 MB
  • 3/28. A neat trick - Multiply by 1.mp4 15.6 MB
  • 7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.mp4 15.5 MB
  • 17. Tesla valuation - Complete practical exercise/25. Calculating Net income.mp4 15.5 MB
  • 17. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4 15.4 MB
  • 16/21. Bridging Unlevered free cash flow to Net cash flow.mp4 15.3 MB
  • 3/27. Working with conditional formatting.mp4 14.9 MB
  • 12. Case Study - Building an FMCG Model from Scratch/2.1 109. Exercise-Build-an-FMCG-Model-Mapping-Lecture.xlsx.xlsx 14.8 MB
  • 3/33. Beauty saving - The professional way of saving files.mp4 14.7 MB
  • 19. Capital Budgeting - A Complete Case Study/10. Finding cost of equity.mp4 14.6 MB
  • 16/4. Description of the structure of the DCF model.mp4 14.6 MB
  • 9/10.2 87. Index Match-Lecture-after.xlsm.xlsm 14.5 MB
  • 12. 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
  • 3/31. Find and replace - formatting.mp4 14.4 MB
  • 12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4 14.4 MB
  • 17. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.mp4 14.3 MB
  • 9/14. Formatting sets You apart from the competition in Excel - A Practical Example.vtt 14.2 MB
  • 17. Tesla valuation - Complete practical exercise/27. Balancing the Balance sheet.mp4 13.9 MB
  • 18. Capital budgeting - The theory/4. Calculating future and present Value.mp4 13.7 MB
  • 3/20. How to save macros and use them across several workbooks.mp4 13.4 MB
  • 5/8. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4 13.2 MB
  • 3/32. Removing (automatic) green arrows.mp4 13.2 MB
  • 3/9. Learn how to organize your data with Text to Columns.mp4 13.2 MB
  • 13. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.mp4 13.1 MB
  • 10. Introduction to Excel charts/4. How to create a bridge chart in Excel.mp4 13.1 MB
  • 19. Capital Budgeting - A Complete Case Study/4. Fixed asset rollforward.mp4 12.7 MB
  • 12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.mp4 12.6 MB
  • 9/13. Building the structure of the P&L sheet.mp4 12.5 MB
  • 5/16. A great Excel technique INDEX, MATCH, MATCH.mp4 12.3 MB
  • 12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.mp4 12.2 MB
  • 11/5.1 105. Bridge chart-Lecture-after.xlsm.xlsm 12.1 MB
  • 11/2.1 102. Column stacked chart-Lecture-before.xlsm.xlsm 12.1 MB
  • 10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.mp4 12.0 MB
  • 10. Introduction to Excel charts/2.1 96. Formatting-a-Chart-Lecture.xlsm.xlsm 12.0 MB
  • 10. Introduction to Excel charts/1.1 95. Inserting-Charts-Lecture.xlsm.xlsm 12.0 MB
  • 7. Financial functions in Excel/4. Date functions in Excel.mp4 11.9 MB
  • 16/6. Modeling the top line.mp4 11.9 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.mp4 11.8 MB
  • 16/32. You made it!.mp4 11.8 MB
  • 12. Case Study - Building an FMCG Model from Scratch/1.1 108. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx.xlsx 11.7 MB
  • 19. Capital Budgeting - A Complete Case Study/2. Organizing an Inputs sheet.mp4 11.6 MB
  • 5/23. Include sensitivity analysis in your models through Data Tables.mp4 11.5 MB
  • 11/3.2 103. Doughnut chart-Lecture-before.xlsm.xlsm 11.1 MB
  • 11/4.1 104. Area chart-Lecture-after.xlsm.xlsm 11.0 MB
  • 2. Introduction to Excel/7. Data entry in Excel.mp4 10.9 MB
  • 3/22. Create a drop-down list by using Data Validation.mp4 10.7 MB
  • 11/3.1 103. Doughnut chart-Lecture-after.xlsm.xlsm 10.6 MB
  • 3/26. Filter by color - an excellent tool.mp4 10.4 MB
  • 9/5. Create a code the best way to organize your data and work efficiently with it.mp4 10.3 MB
  • 18. Capital budgeting - The theory/8. The type of cash flows we will have in a project.mp4 9.8 MB
  • 12. Case Study - Building an FMCG Model from Scratch/5.1 112. Exercise-Build-an-FMCG-Model-Formatting-Lecture.xlsx.xlsx 9.7 MB
  • 19. Capital Budgeting - A Complete Case Study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4 9.7 MB
  • 2. Introduction to Excel/11. Introduction to Excel functions.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
  • 12. 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
  • 19. Capital Budgeting - A Complete Case Study/1. Introduction to the Capital budgeting exercise.mp4 9.1 MB
  • 3/23. Using Custom-sort in order to sort multiple columns within a table.mp4 8.6 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4 8.5 MB
  • 3/2. Initial formatting of an Excel sheet to render it professional.mp4 8.4 MB
  • 11/8. Course Challenge - Apply your skills in practice!.mp4 8.3 MB
  • 11/5.2 105. Bridge chart-Lecture-before.xlsm.xlsm 8.2 MB
  • 2. Introduction to Excel/2. Overview of Excel.mp4 8.1 MB
  • 13. Financial Modeling Fundamentals/3. Why use financial models.mp4 8.1 MB
  • 11/2.2 102. Column stacked chart-Lecture-after.xlsm.xlsm 8.0 MB
  • 3/15. Learn how to assign dynamic names within a financial model.mp4 7.7 MB
  • 7. Financial functions in Excel/1. Future and present values in Excel.mp4 7.5 MB
  • 9/2. Introduction to the case study.mp4 7.2 MB
  • 17. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.mp4 7.2 MB
  • 12. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.mp4 7.1 MB
  • 2. Introduction to Excel/12. Cut, copy, & paste.mp4 6.9 MB
  • 18. Capital budgeting - The theory/2. Why we need Capital budgeting.mp4 6.9 MB
  • 13. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.mp4 6.7 MB
  • 13. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.mp4 6.7 MB
  • 3/13. Find and select special types of cells with Select Special (F5).mp4 6.6 MB
  • 5/14. How to enlarge the formula bar.mp4 6.6 MB
  • 11/1. Create professional and good-looking charts - Introduction.mp4 6.5 MB
  • 19. Capital Budgeting - A Complete Case Study/6. Modeling debt financing.mp4 6.5 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.mp4 6.3 MB
  • 5/11. Find the minimum or maximum value in a range of cells in Excel.mp4 6.2 MB
  • 5/4. = and + are interchangeable when you start typing a formula.mp4 6.1 MB
  • 13. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.mp4 6.0 MB
  • 12. Case Study - Building an FMCG Model from Scratch/6.1 113. Exercise-Build-an-FMCG-Model-Adding-Calculations-Lecture.xlsx.xlsx 5.8 MB
  • 18. Capital budgeting - The theory/1. Introduction to Capital budgeting.mp4 5.7 MB
  • 19. Capital Budgeting - A Complete Case Study/5. The impact of working capital.mp4 5.6 MB
  • 3/24. Create a great Index page at the beginning of your models - Hyperlinks.mp4 5.6 MB
  • 3/19. Macros are a great timesaver! Here's why!.mp4 5.2 MB
  • 19. Capital Budgeting - A Complete Case Study/7. Adding a P&L sheet.mp4 5.1 MB
  • 3/12. Create easily printable documents in Excel by using Set Print Area.mp4 5.0 MB
  • 16/11. Forecasting Balance sheet items.mp4 4.9 MB
  • 9/8. 50% Completed!.mp4 4.5 MB
  • 16/25. Introducing Weighted average cost of capital and Perpetuity growth.mp4 4.2 MB
  • 17. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.mp4 4.1 MB
  • 5/18. Using Excel's IFERROR function to trap spreadsheet errors.mp4 3.7 MB
  • 2. Introduction to Excel/4. Basic manipulations with rows and columns.mp4 3.7 MB
  • 3/8. Using the 'Alt + Enter' combination.mp4 3.5 MB
  • 3/11.5 Useful-Tips-Tools.pdf.pdf 3.5 MB
  • 3/12.3 Useful-Tips-Tools.pdf.pdf 3.5 MB
  • 3/13.4 Useful-Tips-Tools.pdf.pdf 3.5 MB
  • 3/23.4 Useful-Tips-Tools.pdf.pdf 3.5 MB
  • 3/25.3 Useful-Tips-Tools.pdf.pdf 3.5 MB
  • 3/3.1 Useful-Tips-Tools.pdf.pdf 3.5 MB
  • 3/6.1 Useful-Tips-Tools.pdf.pdf 3.5 MB
  • 3/9.4 Useful-Tips-Tools.pdf.pdf 3.5 MB
  • 3/18.2 Useful-Tips-Tools.pdf.pdf 3.5 MB
  • 3/19.1 Useful-Tips-Tools.pdf.pdf 3.5 MB
  • 3/2.3 Useful-Tips-Tools.pdf.pdf 3.5 MB
  • 5/13.3 Excel-Functions.pdf.pdf 3.3 MB
  • 5/18.4 Excel-Functions.pdf.pdf 3.3 MB
  • 5/20.4 Excel-Functions.pdf.pdf 3.3 MB
  • 5/21.2 Excel-Functions.pdf.pdf 3.3 MB
  • 5/15.2 Excel-Functions.pdf.pdf 3.3 MB
  • 5/3.4 Excel-Functions.pdf.pdf 3.3 MB
  • 9/1. Case study - Build a P&L from scratch - Welcome lecture.mp4 3.3 MB
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1.1 Course Notes - Beginner to Pro in Excel.pdf.pdf 3.2 MB
  • 19. Capital Budgeting - A Complete Case Study/8. Calculating project cash flows.mp4 3.0 MB
  • 17. Tesla valuation - Complete practical exercise/1.1 Tesla 2017.pdf.pdf 2.6 MB
  • 19. Capital Budgeting - A Complete Case Study/14. Congratulations!!.mp4 2.4 MB
  • 17. Tesla valuation - Complete practical exercise/1.5 Tesla Company Valuation - Detailed walkthrough.pdf.pdf 2.4 MB
  • 2. Introduction to Excel/11.3 Introduction-to-Excels-basic-features.pdf.pdf 2.4 MB
  • 2. Introduction to Excel/14.3 Introduction-to-Excels-basic-features.pdf.pdf 2.4 MB
  • 2. Introduction to Excel/2.1 7. Introduction to Excel.pdf.pdf 2.4 MB
  • 17. Tesla valuation - Complete practical exercise/1.2 Tesla 2016.pdf.pdf 2.3 MB
  • 13. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.mp4 2.2 MB
  • 5/21. Use Goal Seek to find the result that you are looking for.mp4 2.2 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/6.1 77. Slicers - Lecture - after.xlsx.xlsx 2.0 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/5.1 76. GetPivotData - Lecture - before.xlsx.xlsx 2.0 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/5.2 76. GetPivotData - Lecture – after.xlsx.xlsx 2.0 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/6.2 77. Slicers - Lecture - before.xlsx.xlsx 2.0 MB
  • 3/15.2 Useful-Tips-Tools.pdf.pdf 1.9 MB
  • 3/24.3 Useful-Tips-Tools.pdf.pdf 1.9 MB
  • 13. Financial Modeling Fundamentals/12. Modeling the Income statement.mp4 1.9 MB
  • 16/1. Valuation Case study - Welcome lecture.mp4 1.9 MB
  • 17. Tesla valuation - Complete practical exercise/30.2 23. EV, Equity value, Price per share_after.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/29.1 22. DCF_after.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/30.1 23. EV, Equity value, Price per share_before.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/27.2 20. Complete the BS_after.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/26.1 19. Cash flow_complete_after.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/27.1 20. Complete the BS_before.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/28.2 21. WACC_after.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/26.2 19. Cash flow_complete_before.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/25.2 18. P&L complete_after.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/24.2 17. Financing_after.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/28.1 21. WACC_before.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/25.1 18. P&L complete_before.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/24.1 17. Financing_before.xlsx.xlsx 1.5 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/3.1 74. Formatting-a-Pivot-Table - Lecture - after.xlsx.xlsx 1.5 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/2.1 73. Creating-a-Pivot-Table - Lecture - after.xlsx.xlsx 1.5 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/3.2 74. Formatting-a-Pivot-Table - Lecture - before.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/20.1 14. Cash flow - UFCF_after.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/20.2 14. Cash flow - UFCF_before.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/19.1 13. Calculating working capital_after.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/19.2 13. Calculating working capital_before.xlsx.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/15.1 10a. PP&E comparison.xlsx.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/14.1 10. PP&E schedule_after.xlsx.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/14.2 10. PP&E schedule_before.xlsx.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/12.2 8. Opex - After.xlsx.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/8.2 4a. Gross profit automotive - after.xlsx.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/3.2 1. Deliveries_after.xlsx.xlsx 1.4 MB
  • 6. Update! SUMIFS - Exercise/2.1 67. Exercise-Sumifs-With-Solutions.xlsx.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/3.1 1. Deliveries_before.xlsx.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/1.3 0a. Drivers_before.xlsx.xlsx 1.3 MB
  • 8. Microsoft Excel's Pivot Tables in Depth/2.2 73. Creating-a-Pivot-Table - Lecture – before.xlsx.xlsx 1.3 MB
  • 17. Tesla valuation - Complete practical exercise/29.2 22. DCF_before.xlsx.xlsx 1.3 MB
  • 5/23.1 64. Sensitivity analysis - Lecture - Solved.xlsm.xlsm 918.8 kB
  • 5/25.3 65. Pivot tables - Lecture - Solved.xlsm.xlsm 918.8 kB
  • 5/23.4 64. Sensitivity analysis - Lecture - Unsolved.xlsm.xlsm 918.6 kB
  • 5/18.5 60. Iferror - Lecture - Solved.xlsm.xlsm 917.9 kB
  • 5/12. Include ROUND in your financial models.mp4 859.9 kB
  • 5/25.1 65. Pivot tables - Lecture - Unsolved.xlsm.xlsm 704.3 kB
  • 18. Capital budgeting - The theory/6. Coming up with project-specific beta.mp4 701.0 kB
  • 3/6.5 21. Fixing-references-Lecture - Solved.xlsx.xlsx 660.7 kB
  • 3/6.3 21. Fixing-references-Lecture - Unsolved.xlsx.xlsx 659.4 kB
  • 3/25.2 35. Freeze-Panes-Lecture - Solved.xlsx.xlsx 659.4 kB
  • 3/25.1 35. Freeze-Panes-Lecture - Unsolved.xlsx.xlsx 659.3 kB
  • 3/3.4 19. Fast-Scrolling - Lecture.xlsx.xlsx 658.2 kB
  • 17. Tesla valuation - Complete practical exercise/1.4 Tesla 2018 Q2.pdf.pdf 650.3 kB
  • 11/8.1 107. Course-Challenge - Solved.xlsx.xlsx 557.0 kB
  • 16/28. Calculating Equity value.mp4 535.2 kB
  • 11/8.2 107. Course-Challenge - Unsolved.xlsx.xlsx 517.6 kB
  • 16/3.1 Valuation exercise.pdf.pdf 421.6 kB
  • 2. Introduction to Excel/6.1 9. The-Ribbon-Exercise-Solved.xlsx.xlsx 412.9 kB
  • 9/12.2 89. Mapping-exercise-explained.pdf.pdf 248.9 kB
  • 5/25.4 65. Pivot Tables - Exercise - Solved.xlsx.xlsx 195.0 kB
  • 9/17.3 Y-o-Y Function explanation.pdf.pdf 168.9 kB
  • 3/26.2 36. Exercise-Filter-by-Color-Solved.xlsx.xlsx 157.2 kB
  • 5/25.2 65. Pivot Tables - Exercise - Unsolved.xlsx.xlsx 155.8 kB
  • 3/19.3 30. Macros-Exercise - Solved.xlsx.xlsx 148.5 kB
  • 3/24.2 34. Hyperlinks-Exercise - Solved.xlsx.xlsx 140.4 kB
  • 3/24.1 34. Hyperlinks-Exercise - Unsolved.xlsx.xlsx 140.2 kB
  • 16/31.1 30. Charts.xlsm.xlsm 103.6 kB
  • 16/5.1 Cheeseco.pptx.pptx 82.0 kB
  • 16/12. An introduction to the Days methodology.mp4 75.6 kB
  • 5/23.2 64. Sensitivity-analysis-Exercise-Unsolved.xlsm.xlsm 68.4 kB
  • 16/30.2 29. Goal seek_ater.xlsm.xlsm 66.4 kB
  • 16/29.2 28. Sensitivity analysis_after.xlsm.xlsm 66.4 kB
  • 16/30.1 29. Goal seek_before.xlsm.xlsm 66.4 kB
  • 5/23.3 64. Sensitivity-analysis-Exercise-Solved.xlsm.xlsm 65.4 kB
  • 16/29.1 28. Sensitivity analysis_before.xlsm.xlsm 64.8 kB
  • 16/27.1 26. Calculating CV and EV_after.xlsm.xlsm 64.6 kB
  • 16/26.1 25. Calculating PV of Cash Flows_after.xlsm.xlsm 64.2 kB
  • 16/27.2 26. Calculating CV and EV_before.xlsm.xlsm 64.2 kB
  • 16/26.2 25. Calculating PV of Cash Flows_before.xlsm.xlsm 64.1 kB
  • 16/24.1 23. Find and replace_after.xlsm.xlsm 64.0 kB
  • 16/29.3 Sensitivity Analysis.xlsx 62.3 kB
  • 16/24.2 23. Find and replace_before.xlsm.xlsm 61.0 kB
  • 16/22.1 21. Calculating UFCF_after.xlsm.xlsm 60.6 kB
  • 16/21.2 20. Bridge UFCF to Net cash flow_after.xlsm.xlsm 60.1 kB
  • 16/22.2 21. Calculating UFCF_before.xlsm.xlsm 60.1 kB
  • 16/21.1 20. Bridge UFCF to Net cash flow_before.xlsm.xlsm 60.0 kB
  • 16/18.2 17. Populating BS sheet_after.xlsm.xlsm 58.6 kB
  • 9/17.1 94. Adding % variations-Lecture-after.xlsm.xlsm 57.9 kB
  • 16/17.1 16. Populating the P&L sheet_after.xlsm.xlsm 56.6 kB
  • 16/18.1 17. Populating BS sheet_before.xlsm.xlsm 56.6 kB
  • 9/16.1 93. Countif-Lecture-after.xlsm.xlsm 56.1 kB
  • 9/17.2 94. Adding % variations-Lecture-before.xlsm.xlsm 56.1 kB
  • 16/16.1 15. P&L structure_after.xlsm.xlsm 55.0 kB
  • 16/17.2 16. Populating the P&L sheet_before.xlsm.xlsm 55.0 kB
  • 16/16.2 15. P&L structure_before.xlsm.xlsm 54.9 kB
  • 9/16.2 93. Countif-Lecture-before.xlsm.xlsm 54.8 kB
  • 16/15.1 14. Forecasting PP&E, Other assets, and Other liabilities_after.xlsm.xlsm 54.2 kB
  • 16/14.2 13. Forecasting DSO, DPO, DIO_after.xlsm.xlsm 53.2 kB
  • 16/15.2 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm.xlsm 53.2 kB
  • 16/14.1 13. Forecasting DSO, DPO, DIO_before.xlsm.xlsm 52.7 kB
  • 16/11.1 10. Introduction to Balance sheet items.xlsm.xlsm 52.2 kB
  • 16/10.2 9. Interest expenses, taxes_after.xlsm.xlsm 52.1 kB
  • 3/34.1 43. F2-Lecture.xlsm.xlsm 52.0 kB
  • 3/4.1 20. F5-go-to - Lecture.xlsm.xlsm 52.0 kB
  • 16/10.1 9. Interest expenses, taxes_before.xlsm.xlsm 51.8 kB
  • 16/9.2 8. Opex and D&A_after.xlsm.xlsm 51.8 kB
  • 9/12.1 89. Mapping-Lecture-Unsolved.xlsm.xlsm 51.8 kB
  • 16/9.1 8. Opex and D&A_before.xlsm.xlsm 51.3 kB
  • 9/9.1 86. Sumif_after.xlsm.xlsm 50.7 kB
  • 9/12.3 89. Mapping-Lecture-Solved.xlsx.xlsx 48.6 kB
  • 5/14.1 57. Enlarge-the-formula-bar-Lecture.xlsm.xlsm 48.0 kB
  • 9/7.2 84. Vlookup_after.xlsm.xlsm 45.5 kB
  • 9/9.2 86. Sumif_before.xlsm.xlsm 45.5 kB
  • 3/3.3 19. Fast-Scrolling-Exercise - Solved.xlsx.xlsx 45.4 kB
  • 3/3.2 19. Fast-Scrolling-Exercise - Unsolved.xlsx.xlsx 45.0 kB
  • 9/4.1 81. Order a worksheet_before.xlsm.xlsm 44.1 kB
  • 9/6.2 83. Creating a database_before.xlsm.xlsm 42.7 kB
  • 9/10.1 87. Index Match-Lecture-before.xlsm.xlsm 42.0 kB
  • 9/4.2 81. Order a worksheet_after.xlsm.xlsm 42.0 kB
  • 9/7.1 84. Vlookup_before.xlsm.xlsm 40.5 kB
  • 9/6.1 83. Creating a database_after.xlsm.xlsm 40.3 kB
  • 3/30.2 39. Find-and-Replace-references-Lecture-before.xlsx.xlsx 39.7 kB
  • 19. Capital Budgeting - A Complete Case Study/10.2 8. WACC.xlsx.xlsx 38.9 kB
  • 3/30.1 39. Find-and-Replace-references-Lecture-after.xlsx.xlsx 38.8 kB
  • 19. Capital Budgeting - A Complete Case Study/10.1 8. WACC_unsolved.xlsx.xlsx 36.8 kB
  • 2. Introduction to Excel/7.3 10. Data-Entry- Exercise -Solved.xlsx.xlsx 33.5 kB
  • 19. Capital Budgeting - A Complete Case Study/7.1 6. P&L.xlsx.xlsx 31.8 kB
  • 19. Capital Budgeting - A Complete Case Study/6.2 5. Financing.xlsx.xlsx 31.7 kB
  • 19. Capital Budgeting - A Complete Case Study/6.1 5. Financing_unsolved.xlsx.xlsx 30.7 kB
  • 19. Capital Budgeting - A Complete Case Study/7.2 6. P&L_unsolved.xlsx.xlsx 30.4 kB
  • 7. Financial functions in Excel/3.2 70. Exercise-Loan-Schedule-Solved.xlsx.xlsx 23.2 kB
  • 19. Capital Budgeting - A Complete Case Study/5.1 4. Working Capital.xlsx.xlsx 22.5 kB
  • 19. Capital Budgeting - A Complete Case Study/5.2 4. Working Capital_unsolved.xlsx.xlsx 21.7 kB
  • 3/26.1 36. Exercise-Filter-by-Color-Unsolved.xlsx.xlsx 21.0 kB
  • 7. Financial functions in Excel/3.1 70. Loan Schedule-Lecture.xlsx.xlsx 20.7 kB
  • 19. Capital Budgeting - A Complete Case Study/4.2 3. Fixed Asset Rollforward.xlsx.xlsx 20.1 kB
  • 19. Capital Budgeting - A Complete Case Study/4.1 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx 19.0 kB
  • 3/28.2 38. Multiply-by-1-Lecture-after.xlsx.xlsx 17.6 kB
  • 3/31.2 40. Find-replace-Lecture-after.xlsx.xlsx 17.6 kB
  • 3/31.1 40. Find-replace-Lecture-before.xlsx.xlsx 17.6 kB
  • 3/33.1 42. Beauty-saving-Lecture-before.xlsx.xlsx 17.6 kB
  • 3/33.2 42. Beauty-saving-Lecture-after.xlsx.xlsx 17.5 kB
  • 5/4.1 49. = and + are interchangeable -after.xlsm.xlsm 17.4 kB
  • 5/4.2 49. = and + are interchangeable - before.xlsm.xlsm 17.4 kB
  • 19. Capital Budgeting - A Complete Case Study/3.1 2. Savings Forecast.xlsx.xlsx 17.0 kB
  • 3/28.1 38. Multiply-by-1-Lecture-before.xlsx.xlsx 16.9 kB
  • 5/21.3 63. Goal-Seek-Exercise-Solved.xlsx.xlsx 16.6 kB
  • 7. Financial functions in Excel/3.3 70. Exercise-Loan-Schedule-Unsolved.xlsx.xlsx 16.2 kB
  • 5/3.5 48. Sum-Sumif-Sumifs-Exercise - Solved.xlsx.xlsx 15.2 kB
  • 5/11.4 54. MIN-MAX-Exercise - Solved.xlsx.xlsx 15.2 kB
  • 19. Capital Budgeting - A Complete Case Study/3.2 2. Savings Forecast_unsolved.xlsx.xlsx 15.1 kB
  • 5/3.3 48. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx.xlsx 14.8 kB
  • 5/11.2 54. MIN-MAX-Exercise - Unsolved.xlsx.xlsx 14.7 kB
  • 5/13.4 56. Vlookup-Hlookup-Exercise - Solved.xlsx.xlsx 14.0 kB
  • 3/15.1 27. Dynamic-Naming-Lecture - Unsolved.xlsx.xlsx 13.9 kB
  • 2. Introduction to Excel/11.5 13. Functions-Exercise - Unsolved.xlsx.xlsx 13.6 kB
  • 5/3.2 48. Sum-Sumif-Sumifs-Lecture - Solved.xlsx.xlsx 13.3 kB
  • 5/3.1 48. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx.xlsx 13.2 kB
  • 10. Introduction to Excel charts/5.1 99. Treemap-Charts-Lecture.xlsx.xlsx 12.9 kB
  • 5/19.1 61. Rank-function-Lecture-after.xlsx.xlsx 12.9 kB
  • 3/20.3 31. How-to-save-macros-Lecture-after.xlsm.xlsm 12.9 kB
  • 7. Financial functions in Excel/4.1 71. Date Functions-Exercise-Solved.xlsx.xlsx 12.7 kB
  • 5/19.2 61. Rank-function-Lecture-before.xlsx.xlsx 12.6 kB
  • 7. Financial functions in Excel/4.2 71. Date Functions-Lecture.xlsx.xlsx 12.5 kB
  • 5/16.1 59. Exercise-Index-Match-Match-Solved.xlsx.xlsx 12.5 kB
  • 2. Introduction to Excel/6.2 9. The-Ribbon-Exercise-Exercise - Unsolved.xlsx.xlsx 12.4 kB
  • 5/15.3 58. Index-Match-Exercise - Solved.xlsx.xlsx 12.4 kB
  • 3/32.1 41. Green-references-Lecture.xlsx.xlsx 12.3 kB
  • 5/13.5 56. Vlookup-Hlookup-Exercise - Unsolved.xlsx.xlsx 12.2 kB
  • 5/15.1 58. Index-Match-Lecture - Solved.xlsx.xlsx 12.0 kB
  • 2. Introduction to Excel/8.2 11. Formatting-Exercise - Unsolved.xlsx.xlsx 11.9 kB
  • 2. Introduction to Excel/8.3 11. Formatting- Exercise - Solved.xlsx.xlsx 11.9 kB
  • 5/15.5 58. Index-Match-Exercise - Unsolved.xlsx.xlsx 11.9 kB
  • 5/16.2 59. Exercise-Index-Match-Match-Unsolved.xlsx.xlsx 11.9 kB
  • 19. Capital Budgeting - A Complete Case Study/2.1 1. Drivers.xlsx.xlsx 11.8 kB
  • 3/23.5 33. Custom-Sort-Exercise - Solved.xlsx.xlsx 11.7 kB
  • 3/12.1 25. Set-Print-Area-Lecture - Unsolved.xlsx.xlsx 11.7 kB
  • 7. Financial functions in Excel/4.3 71. Date Functions-Exercise-Unsolved.xlsx.xlsx 11.7 kB
  • 3/8.4 22. Alt-Enter-Exercise - Solved.xlsx.xlsx 11.7 kB
  • 5/20.5 62. Choose-Exercise - Unsolved.xlsx.xlsx 11.6 kB
  • 3/9.1 23. Text-to-Columns-Exercise - Solved.xlsx.xlsx 11.6 kB
  • 5/15.4 58. Index-Match-Lecture - Unsolved.xlsx.xlsx 11.6 kB
  • 3/12.2 25. Set-Print-Area-Lecture - Solved.xlsx.xlsx 11.5 kB
  • 3/19.2 30. Creating-a-Macro-Lecture - Solved.xlsx.xlsx 11.4 kB
  • 5/13.2 56. Vlookup-Hlookup- Lecture - Solved.xlsx.xlsx 11.4 kB
  • 3/8.1 22. Alt-Enter-Exercise - Unsolved.xlsx.xlsx 11.4 kB
  • 3/18.3 29. Assigning Custom Formats - Exercise - Solved.xlsx.xlsx 11.3 kB
  • 2. Introduction to Excel/7.2 10. Data-Entry-Exercise - Unsolved.xlsx.xlsx 11.2 kB
  • 2. Introduction to Excel/2.2 7. Overview-of-Excel-Exercise-Solved.xlsx.xlsx 11.1 kB
  • 3/6.4 21. Fixing-Cells-Exercise - Solved.xlsx.xlsx 11.1 kB
  • 3/2.2 18. Formatting-a-Worksheet-Exercise - Solved.xlsx.xlsx 11.0 kB
  • 5/13.1 56. Vlookup-Hlookup- Lecture - Unsolved.xlsx.xlsx 11.0 kB
  • 3/6.2 21. Fixing-Cells-Exercise - Unsolved.xlsx.xlsx 10.9 kB
  • 3/2.1 18. Formatting-a-Worksheet-Exercise - Unsolved.xlsx.xlsx 10.9 kB
  • 3/9.2 23. Text-to-Columns-Exercise - Unsolved.xlsx.xlsx 10.8 kB
  • 2. Introduction to Excel/2.3 7. Overview-of-Excel-Exercise-Unsolved.xlsx.xlsx 10.7 kB
  • 3/19.5 30. Macros-Exercise - Unsolved.xlsx.xlsx 10.6 kB
  • 3/9.5 23.Text-to-columns-Lecture - Solved.xlsx.xlsx 10.1 kB
  • 2. Introduction to Excel/8.1 11. Formatting - Lecture - Solved.xlsx.xlsx 10.1 kB
  • 3/9.3 23. Text-to-columns-Lecture - Unsolved.xlsx.xlsx 10.0 kB
  • 3/19.4 30. Creating-a-Macro-Lecture - Unsolved.xlsx.xlsx 9.9 kB
  • 3/8.3 22. Alt-Enter- Lecture - Solved.xlsx.xlsx 9.9 kB
  • 3/8.2 22. Alt-Enter- Lecture - Unsolved.xlsx.xlsx 9.9 kB
  • 10. Introduction to Excel charts/6.1 100. Sparklines-Lecture.xlsx.xlsx 9.8 kB
  • 3/2.4 18. Formatting-a-worksheet-Lecture - Solved.xlsx.xlsx 9.8 kB
  • 2. Introduction to Excel/11.4 13. Functions- Lecture - Unsolved.xlsx.xlsx 9.5 kB
  • 5/11.3 54. Max-min-Lecture - Solved.xlsx.xlsx 9.4 kB
  • 5/21.4 63. Goal-Seek-Lecture - Solved.xlsx.xlsx 9.4 kB
  • 5/21.5 63. Goal-Seek-Lecture - Unsolved.xlsx.xlsx 9.4 kB
  • 3/2.5 18. Formatting-a-worksheet-Lecture - Unsolved.xlsx.xlsx 9.2 kB
  • 5/11.1 54. Max-min-Lecture - Unsolved.xlsx.xlsx 9.2 kB
  • 2. Introduction to Excel/8.4 11. Formatting- Lecture - Unsolved.xlsx.xlsx 9.1 kB
  • 3/20.1 31. Another-file.xlsx.xlsx 9.0 kB
  • 5/13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.vtt 8.7 kB
  • 5/15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.vtt 8.4 kB
  • 2. Introduction to Excel/7.1 10. Data-Entry - Lecture.xlsx.xlsx 8.3 kB
  • 11/5. Learn how to create bridge charts.vtt 7.6 kB
  • 18. Capital budgeting - The theory/5. Calculating cost of equity.vtt 7.6 kB
  • 19. Capital Budgeting - A Complete Case Study/10. Finding cost of equity.vtt 7.3 kB
  • 13. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.vtt 7.0 kB
  • 12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.vtt 6.8 kB
  • 18. Capital budgeting - The theory/9. Estimating the project's cash flows.vtt 6.8 kB
  • 16/22. Calculating Unlevered free cash flow.vtt 6.8 kB
  • 16/3. The stages of a complete DCF Valuation.vtt 6.8 kB
  • 9/12. In case you have any doubts about the Mapping exercise.vtt 6.5 kB
  • 18. Capital budgeting - The theory/4. Calculating future and present Value.vtt 6.4 kB
  • 19. Capital Budgeting - A Complete Case Study/2. Organizing an Inputs sheet.vtt 6.4 kB
  • 2. Introduction to Excel/8. Introduction to formatting.vtt 6.3 kB
  • 3/20.2 31. How-to-save-macros-Lecture-before.xlsx.xlsx 6.2 kB
  • 7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.vtt 6.0 kB
  • 17. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered free cash flow.vtt 5.9 kB
  • 13. Financial Modeling Fundamentals/5. Financial modeling - best practices.vtt 5.8 kB
  • 11/2. Build a column stacked chart with a secondary line axis in Excel.vtt 5.8 kB
  • 7. Financial functions in Excel/4. Date functions in Excel.vtt 5.6 kB
  • 13. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.vtt 5.6 kB
  • 9/7. Use VLOOKUP to fill the Database sheet.vtt 5.5 kB
  • 19. Capital Budgeting - A Complete Case Study/4. Fixed asset rollforward.vtt 5.4 kB
  • 5/16. A great Excel technique INDEX, MATCH, MATCH.vtt 5.4 kB
  • 17. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.vtt 5.2 kB
  • 5/3. Key Excel functions SUM, SUMIF and SUMIFS.vtt 5.0 kB
  • 12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.vtt 4.7 kB
  • 16/29. Sensitivity analysis for WACC and perpetuity growth.vtt 4.7 kB
  • 12. Case Study - Building an FMCG Model from Scratch/12. This is how the report can be used in practice by high-level executives.vtt 4.5 kB
  • 17. Tesla valuation - Complete practical exercise/21. Forecasting other assets.vtt 4.4 kB
  • 9/10. Use INDEX & MATCH as a substitute for VLOOKUP.vtt 4.3 kB
  • 16/24. Obtaining the rest of the cash flows through Find and Replace.vtt 4.3 kB
  • 17. Tesla valuation - Complete practical exercise/31. Final comments.vtt 4.3 kB
  • 10. Introduction to Excel charts/6. Sparklines.vtt 4.3 kB
  • 17. Tesla valuation - Complete practical exercise/26. Bridging Unlevered free cash flow to Net cash flow.vtt 4.3 kB
  • 9/9. Use SUMIF to complete the Database sheet.vtt 4.3 kB
  • 17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.vtt 4.2 kB
  • 19. Capital Budgeting - A Complete Case Study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.vtt 4.2 kB
  • 18. Capital budgeting - The theory/8. The type of cash flows we will have in a project.vtt 4.0 kB
  • 12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.vtt 3.9 kB
  • 17. Tesla valuation - Complete practical exercise/29. Performing discounted cash flow valuation (DCF).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
  • 11/4. Learn how to build an area chart in Excel.vtt 3.6 kB
  • 12. Case Study - Building an FMCG Model from Scratch/10. Combining Slicers and GETPIVOTDATA The key to our success.vtt 3.5 kB
  • 13. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.vtt 3.4 kB
  • 2. Introduction to Excel/7. Data entry in Excel.vtt 3.4 kB
  • 3/30. Find and replace - references.vtt 3.4 kB
  • 19. Capital Budgeting - A Complete Case Study/6. Modeling debt financing.vtt 3.4 kB
  • 9/17. Calculating year-on-year percentage variations the proper way.vtt 3.3 kB
  • 19. Capital Budgeting - A Complete Case Study/1. Introduction to the Capital budgeting exercise.vtt 3.3 kB
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.vtt 3.2 kB
  • 13. Financial Modeling Fundamentals/3. Why use financial models.vtt 3.2 kB
  • 16/26. Discounting Unlevered free cash flows to obtain their Present value.vtt 3.1 kB
  • 2. Introduction to Excel/6. The Excel ribbon.vtt 3.1 kB
  • 13. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.vtt 3.0 kB
  • 16/10. Modeling other items Interest expenses, Extraordinary items and Taxes.vtt 3.0 kB
  • 10. Introduction to Excel charts/2. Editing Excel charts.vtt 3.0 kB
  • 16/32. You made it!.vtt 3.0 kB
  • 19. Capital Budgeting - A Complete Case Study/5. The impact of working capital.vtt 2.9 kB
  • 5/19. RANK is a valuable tool when using Excel for Financial and Business analysis.vtt 2.9 kB
  • 12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.vtt 2.9 kB
  • 9/16. Learn how to find mistakes with COUNTIF.vtt 2.9 kB
  • 16/14. Forecasting DSO, DPO and DOI.vtt 2.8 kB
  • 13. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.vtt 2.8 kB
  • 16/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.vtt 2.7 kB
  • 3/33. Beauty saving - The professional way of saving files.vtt 2.7 kB
  • 5/25. Excel's dynamic and interactive tables Pivot tables.vtt 2.6 kB
  • 3/6. Introduction to fixing of cell references.vtt 2.6 kB
  • 12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.vtt 2.5 kB
  • 16/17. Populating the output P&L sheet.vtt 2.5 kB
  • 12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.vtt 2.5 kB
  • 9/4. Order the source worksheets.vtt 2.5 kB
  • 16/27. Calculating Continuing value and Enterprise value of the business.vtt 2.4 kB
  • 16/16. Creating an output P&L sheet.vtt 2.4 kB
  • 8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.vtt 2.3 kB
  • 3/9. Learn how to organize your data with Text to Columns.vtt 2.3 kB
  • 3/2. Initial formatting of an Excel sheet to render it professional.vtt 2.2 kB
  • 9/6. Learn how to create a database.vtt 2.2 kB
  • 3/34. Formula auditing with F2.vtt 2.2 kB
  • 19. Capital Budgeting - A Complete Case Study/7. Adding a P&L sheet.vtt 2.2 kB
  • 16/21. Bridging Unlevered free cash flow to Net cash flow.vtt 2.2 kB
  • 3/4. Be even quicker F5 + Enter.vtt 2.2 kB
  • 12. 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. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.vtt 2.1 kB
  • 17. Tesla valuation - Complete practical exercise/30. Calculating enterprise value, equity value, and price per share.vtt 2.1 kB
  • 3/26. Filter by color - an excellent tool.vtt 2.0 kB
  • 8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.vtt 2.0 kB
  • 16/30. A possible application of Goal seek.vtt 2.0 kB
  • 3/31. Find and replace - formatting.vtt 1.9 kB
  • 18. Capital budgeting - The theory/1. Introduction to Capital budgeting.vtt 1.8 kB
  • 16/18. Populating the output BS sheet.vtt 1.8 kB
  • 3/3. Fast scrolling through Excel sheets.vtt 1.8 kB
  • 3/20. How to save macros and use them across several workbooks.vtt 1.8 kB
  • 10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.vtt 1.7 kB
  • 3/28. A neat trick - Multiply by 1.vtt 1.7 kB
  • 3/32. Removing (automatic) green arrows.vtt 1.7 kB
  • 17. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.vtt 1.7 kB
  • 3/15. Learn how to assign dynamic names within a financial model.vtt 1.6 kB
  • 9/1. Case study - Build a P&L from scratch - Welcome lecture.vtt 1.6 kB
  • 3/24. Create a great Index page at the beginning of your models - Hyperlinks.vtt 1.5 kB
  • 19. Capital Budgeting - A Complete Case Study/14. Congratulations!!.vtt 1.5 kB
  • 3/12. Create easily printable documents in Excel by using Set Print Area.vtt 1.5 kB
  • 12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.vtt 1.5 kB
  • 3/25. Fix the top row of your table with Freeze Panes.vtt 1.4 kB
  • 5/14. How to enlarge the formula bar.vtt 1.4 kB
  • 16/5. A glimpse at the company we are valuing - Cheeseco.vtt 1.4 kB
  • 17. Tesla valuation - Complete practical exercise/25. Calculating Net income.vtt 1.3 kB
  • 11/8. Course Challenge - Apply your skills in practice!.vtt 1.2 kB
  • 17. Tesla valuation - Complete practical exercise/27. Balancing the Balance sheet.vtt 1.1 kB
  • 5/11. Find the minimum or maximum value in a range of cells in Excel.vtt 1.1 kB
  • 13. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.vtt 1.1 kB
  • 3/8. Using the 'Alt + Enter' combination.vtt 1.0 kB
  • 5/4. = and + are interchangeable when you start typing a formula.vtt 975 Bytes
  • 16/11. Forecasting Balance sheet items.vtt 914 Bytes
  • 16/1. Valuation Case study - Welcome lecture.vtt 869 Bytes
  • 11/1. Create professional and good-looking charts - Introduction.vtt 727 Bytes
  • 14. Introduction to Company Valuation/1. The core theory behind Company Valuation.html 164 Bytes
  • 15. Introduction to Mergers & Acquisitions/1. Introduction to Mergers & Acquisitions.html 164 Bytes
  • 2. Introduction to Excel/15. Basic operations in Excel - 38 pages.html 164 Bytes
  • 13. Financial Modeling Fundamentals/10. Forecasting financials - Quiz.html 160 Bytes
  • 13. Financial Modeling Fundamentals/7. Financial modeling - Quiz.html 160 Bytes
  • 2. Introduction to Excel/3. Overview of Excel.html 160 Bytes
  • 3/14. Select Special.html 160 Bytes
  • 3/21. Excel Macros - quiz.html 160 Bytes
  • 3/5. Fast scrolling through Excel sheets.html 160 Bytes
  • 3/7. Introduction to fixing of cell references.html 160 Bytes
  • 5/17. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.html 160 Bytes
  • 5/22. Use Goal Seek in order to find the result that you are looking for.html 160 Bytes
  • 5/24. Include sensitivity analysis in your models through Data Tables.html 160 Bytes
  • 3/29. Useful tips and tools for your work in Excel - quiz.html 159 Bytes
  • 5/26. Excel's key functions and functionalities made easy.html 159 Bytes
  • [Tutorialsplanet.NET].url 128 Bytes
  • 9/8. 50% Completed!.vtt 51 Bytes
  • 10. Introduction to Excel charts/3. Excel chart formatting.vtt 0 Bytes

温馨提示

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