[DesireCourse.Net] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation

磁力链接/BT种子名称

[DesireCourse.Net] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation

磁力链接/BT种子简介

种子哈希：6efa437e6486bf66436578d3083e9748dfaa1a40
文件大小： 5.71G
已经下载：4214次
下载速度：极快
收录时间：2021-04-28
最近下载：2025-06-11

移花宫入口

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

磁力链接下载

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

下载BT种子文件

磁力链接 迅雷下载 PIKPAK在线播放 世界之窗 91视频 含羞草 欲漫涩 逼哩逼哩 成人快手 51品茶 抖阴破解版 极乐禁地 91短视频 TikTok成人版 PornHub 草榴社区 91未成年 乱伦巴士 呦乐园 萝莉岛

最近搜索

文件列表

  • 11. P&L Case Study continued - Let's create some great-looking professional charts/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4 142.7 MB
  • 17. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.mp4 105.2 MB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/5. Introduction to formatting.mp4 79.1 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/7. Use VLOOKUP to fill the database sheet.mp4 64.6 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/22. Calculating Unlevered free cash flow.mp4 62.6 MB
  • 17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp4 59.3 MB
  • 17. Tesla valuation - Complete practical exercise/21. Forecasting Unlevered free cash flow.mp4 58.7 MB
  • 17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp4 56.8 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/5. Learn how to create bridge charts.mp4 54.6 MB
  • 4. Keyboard shortcuts in Excel/1. Keyboard shortcuts save LOTS of time in Excel.mp4 53.7 MB
  • 17. Tesla valuation - Complete practical exercise/27. Bridging Unlevered free cash flow to Net cash flow.mp4 53.2 MB
  • 12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4 52.4 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/11. Use INDEX & MATCH as a substitute for VLOOKUP.mp4 52.0 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/3. The stages of a complete DCF Valuation.mp4 51.6 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/9. Use SUMIF to complete the database sheet.mp4 50.3 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/24. Obtaining the rest of the cash flows through Find and Replace.mp4 49.0 MB
  • 17. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.mp4 48.8 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/2. Build a column stacked chart with a secondary line axis in Excel.mp4 48.6 MB
  • 17. Tesla valuation - Complete practical exercise/22. Forecasting other assets.mp4 47.4 MB
  • 17. Tesla valuation - Complete practical exercise/32. Final comments.mp4 47.1 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/8. Modeling other items Other revenues and Cogs.mp4 46.7 MB
  • 17. Tesla valuation - Complete practical exercise/29. Estimating Weighted average cost of capital (WACC).mp4 46.4 MB
  • 19. Capital Budgeting - A complete Case study/12. Performing sensitivity analysis and completing the exercise.mp4 45.1 MB
  • 17. Tesla valuation - Complete practical exercise/25. Modeling Tesla's financing needs in the forecast period.mp4 44.4 MB
  • 2. Introduction to Excel/9. Introduction to Excel formulas.srt 44.2 MB
  • 17. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.mp4 44.0 MB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/1. Overview of Excel.mp4 43.2 MB
  • 17. Tesla valuation - Complete practical exercise/24. Completing Unlevered free cash flow.mp4 42.9 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/29. Sensitivity analysis for WACC and perpetuity growth.mp4 42.5 MB
  • 5. Excel's key functions and functionalities made easy/16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4 40.9 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/13. In case you have any doubts about the Mapping exercise.mp4 40.4 MB
  • 2. Introduction to Excel/7. Introduction to formatting.mp4 40.1 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/19. Completing the output BS sheet for the historical period.mp4 39.9 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/3. Learn how to build effective doughnut charts in Excel.mp4 39.9 MB
  • 3. Useful tips and tools for your work in Excel/21. Introduction to custom formatting in Excel.mp4 39.8 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/23. Calculating Net cash flow.mp4 39.8 MB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/7. Introduction to Excel functions.mp4 38.9 MB
  • 12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp4 38.9 MB
  • 12. Case Study - Building an FMCG Model from Scratch/13. This is how the report can be used in practice by high-level executives.mp4 37.9 MB
  • 6. Update! SUMIFS - Exercise/2. Exercise - Excel's SUMIFS function - solved & explained.mp4 37.0 MB
  • 17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp4 36.6 MB
  • 17. Tesla valuation - Complete practical exercise/30. Performing discounted cash flow valuation (DCF).mp4 36.6 MB
  • 5. Excel's key functions and functionalities made easy/14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4 36.3 MB
  • 12. Case Study - Building an FMCG Model from Scratch/11. Combining Slicers and GETPIVOTDATA The key to our success.mp4 35.3 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/31. Using charts to summarize the results of the DCF model.mp4 34.5 MB
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp4 34.4 MB
  • 10. Introduction to Excel charts/3. Excel chart formatting.mp4 34.3 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/12. Mapping the rows in the database sheet.mp4 34.1 MB
  • 12. Case Study - Building an FMCG Model from Scratch/12. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 34.0 MB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/4. Data entry in Excel.mp4 33.0 MB
  • 17. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.mp4 32.5 MB
  • 12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.mp4 31.9 MB
  • 23. APPENDIX - Microsoft Excel 2010 - Keyboard shortcuts/1. Keyboard shortcuts Save LOTS of time in Excel 2010.mp4 31.9 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/16. Populate the P&L sheet with SUMIF.mp4 31.7 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4 31.5 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/19. Calculating year-on-year percentage variations the proper way.mp4 31.4 MB
  • 2. Introduction to Excel/15. Format cells.mp4 30.5 MB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/3. The Excel ribbon.mp4 30.3 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/4. Learn how to build an area chart in Excel.mp4 30.0 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 29.5 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/18. Learn how to find mistakes with COUNTIF.mp4 29.2 MB
  • 17. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.mp4 29.1 MB
  • 10. Introduction to Excel charts/6. Sparklines.mp4 28.9 MB
  • 17. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4 28.1 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/4. Order the source worksheets.mp4 27.8 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/9. Modeling other items Operating expenses and D&A.mp4 27.6 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/6. Modeling the top line.mp4 27.6 MB
  • 10. Introduction to Excel charts/2. Editing Excel charts.mp4 27.3 MB
  • 19. Capital Budgeting - A complete Case study/11. Discounting the project's cash flows and residual value.mp4 27.2 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/17. Populating the output P&L sheet.mp4 26.8 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/15. Formatting sets You apart from the competition in Excel - A Practical Example.mp4 26.7 MB
  • 12. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.mp4 26.6 MB
  • 17. Tesla valuation - Complete practical exercise/10. Forecasting 'energy' and 'services' revenue.mp4 26.5 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 25.7 MB
  • 3. Useful tips and tools for your work in Excel/6. Fixing cell references.mp4 25.3 MB
  • 12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.mp4 25.2 MB
  • 3. Useful tips and tools for your work in Excel/32. Find and replace - references.mp4 25.2 MB
  • 5. Excel's key functions and functionalities made easy/20. RANK is a valuable tool when using Excel for financial and business analysis.mp4 24.4 MB
  • 5. Excel's key functions and functionalities made easy/26. Excel's dynamic and interactive tables Pivot tables.mp4 24.3 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
  • 12. Case Study - Building an FMCG Model from Scratch/13.1 9. Exercise - Build an FMCG Model_Complete_after.xlsx 23.9 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/20. Creating a structure for the calculation of Unlevered free cash flows.mp4 23.9 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4 23.7 MB
  • 17. Tesla valuation - Complete practical exercise/31. Calculating enterprise value, equity value, and price per share.mp4 23.7 MB
  • 10. Introduction to Excel charts/1. How to insert a chart in Excel.mp4 23.4 MB
  • 8. Microsoft Excel's Pivot Tables in depth/6. An introduction to slicers - The modern-day Pivot Table filters.mp4 23.2 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/2. Fast scrolling through Excel sheets.mp4 23.2 MB
  • 17. Tesla valuation - Complete practical exercise/23. Forecasting other liabilities.mp4 23.0 MB
  • 17. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.mp4 21.9 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/14. Forecasting DSO, DPO and DOI.mp4 21.9 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/14. Building the structure of the P&L sheet.mp4 21.9 MB
  • 12. Case Study - Building an FMCG Model from Scratch/11.1 7. Exercise - Build an FMCG Model_Inserting Slicers_before.xlsx 21.8 MB
  • 12. Case Study - Building an FMCG Model from Scratch/8.2 6a. Exercise - Build an FMCG Model_Copying Get Pivot_after.xlsx 21.8 MB
  • 12. Case Study - Building an FMCG Model from Scratch/7.2 5. Exercise - Build an FMCG Model_Creating a Pivot Table_after.xlsx 21.8 MB
  • 12. Case Study - Building an FMCG Model from Scratch/8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA_before.xlsx 21.8 MB
  • 12. Case Study - Building an FMCG Model from Scratch/11.2 7. Exercise - Build an FMCG Model_Inserting Slicers_after.xlsx 21.8 MB
  • 12. Case Study - Building an FMCG Model from Scratch/12.1 8. Exercise - Build an FMCG Model_Formatting Slicers_before.xlsx 21.8 MB
  • 2. Introduction to Excel/2. Overview of Excel.mp4 21.7 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/6. Learn how to create a database.mp4 21.7 MB
  • 2. Introduction to Excel/9. Introduction to Excel formulas.mp4 21.7 MB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/2. Basic manipulations with rows and columns.mp4 21.4 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/3. Introduction to fixing of cell references.mp4 21.4 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/26. Discounting Unlevered free cash flows to obtain their Present value.mp4 21.2 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 21.1 MB
  • 13. Financial modeling fundamentals/4. Financial modeling - worst practices - things you should avoid.mp4 20.9 MB
  • 3. Useful tips and tools for your work in Excel/5. Be even quicker F5 + Enter.mp4 20.7 MB
  • 12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.mp4 20.7 MB
  • 8. Microsoft Excel's Pivot Tables in depth/2. Creating Pivot Tables easily!.mp4 20.3 MB
  • 5. Excel's key functions and functionalities made easy/4. 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/20. Calculating investments in working capital.mp4 20.0 MB
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1.1 Course Notes - Beginner to Pro in Excel.pdf 20.0 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/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
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/6. Introduction to Excel formulas.mp4 19.7 MB
  • 2. Introduction to Excel/11. Introduction to Excel functions.mp4 19.6 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/4. Description of the structure of the DCF model.mp4 19.4 MB
  • 17. Tesla valuation - Complete practical exercise/19. Fill in the P&L output sheet.mp4 19.2 MB
  • 12. Case Study - Building an FMCG Model from Scratch/12.2 8. Exercise - Build an FMCG Model_Formatting Slicers_after.xlsx 19.1 MB
  • 12. Case Study - Building an FMCG Model from Scratch/13.2 9. Exercise - Build an FMCG Model_Complete_before.xlsx 19.1 MB
  • 8. Microsoft Excel's Pivot Tables in depth/5. Learn more about GETPIVOTDATA - A very important Excel function.mp4 18.9 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/7. Introducing scenarios to the model with Choose.mp4 18.7 MB
  • 3. Useful tips and tools for your work in Excel/37. Formula auditing with F2.mp4 18.6 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/27. Calculating Continuing value and Enterprise value of the business.mp4 18.6 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/8. Fix the top row of your table with Freeze Panes.mp4 18.5 MB
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The best way to take this course.mp4 18.5 MB
  • 3. Useful tips and tools for your work in Excel/3. Fast scrolling through Excel sheets.mp4 18.4 MB
  • 17. Tesla valuation - Complete practical exercise/17. Calculating DSO, DIO, DPO.mp4 18.4 MB
  • 17. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.mp4 18.4 MB
  • 13. Financial modeling fundamentals/5. Financial modeling - best practices.mp4 18.1 MB
  • 17. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.mp4 18.0 MB
  • 3. Useful tips and tools for your work in Excel/23. Macros are a great timesaver! Here's why!.mp4 18.0 MB
  • 5. Excel's key functions and functionalities made easy/6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 17.8 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/18. Populating the output BS sheet.mp4 17.8 MB
  • 5. Excel's key functions and functionalities made easy/9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4 17.6 MB
  • 5. Excel's key functions and functionalities made easy/3. Key functions in Excel IF.mp4 17.5 MB
  • 12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.mp4 16.9 MB
  • 5. Excel's key functions and functionalities made easy/11. Working with text in Excel.mp4 16.8 MB
  • 2. Introduction to Excel/6. Data entry in Excel.mp4 16.8 MB
  • 17. Tesla valuation - Complete practical exercise/2. The input data we will work with.mp4 16.6 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/5. A glimpse at the company we are valuing - Cheeseco.mp4 16.4 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/30. A possible application of Goal seek.mp4 16.4 MB
  • 3. Useful tips and tools for your work in Excel/29. Working with conditional formatting.mp4 15.8 MB
  • 7. Financial functions in Excel/1. Future and present values in Excel.mp4 15.7 MB
  • 12. Case Study - Building an FMCG Model from Scratch/4.2 2. Exercise - Build an FMCG Model_Layout_after.xlsx 15.6 MB
  • 12. Case Study - Building an FMCG Model from Scratch/5.2 3. Exercise - Build an FMCG Model_Formatting_before.xlsx 15.6 MB
  • 12. Case Study - Building an FMCG Model from Scratch/5.1 3. Exercise - Build an FMCG Model_Formatting_after.xlsx 15.6 MB
  • 12. Case Study - Building an FMCG Model from Scratch/6.2 4. Exercise - Build an FMCG Model_Adding Calculations_before.xlsx 15.6 MB
  • 12. Case Study - Building an FMCG Model from Scratch/6.1 4. Exercise - Build an FMCG Model_Adding Calculations_after.xlsx 15.6 MB
  • 12. Case Study - Building an FMCG Model from Scratch/7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table_before.xlsx 15.6 MB
  • 12. Case Study - Building an FMCG Model from Scratch/4.1 2. Exercise - Build an FMCG Model_Layout_before.xlsx 15.6 MB
  • 12. Case Study - Building an FMCG Model from Scratch/2.2 1. Exercise - Build an FMCG Model_Mapping_after.xlsx 15.6 MB
  • 3. Useful tips and tools for your work in Excel/31. 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/26. Calculating Net income.mp4 15.5 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/21. Bridging Unlevered free cash flow to Net cash flow.mp4 15.3 MB
  • 3. Useful tips and tools for your work in Excel/26. Fix the top row of your table with freeze panes.mp4 15.2 MB
  • 5. Excel's key functions and functionalities made easy/24. Include sensitivity analysis in your models through Data Tables.mp4 15.0 MB
  • 13. Financial modeling fundamentals/6. Financial modeling - The types of models that are built in practice.mp4 15.0 MB
  • 3. Useful tips and tools for your work in Excel/14. Create drop-down lists with data validation.mp4 14.8 MB
  • 3. Useful tips and tools for your work in Excel/36. Beauty saving - The professional way of saving files.mp4 14.7 MB
  • 3. Useful tips and tools for your work in Excel/9. Organize your data with text to columns.mp4 14.6 MB
  • 19. Capital Budgeting - A complete Case study/10. Finding cost of equity.mp4 14.6 MB
  • 3. Useful tips and tools for your work in Excel/15. Find and select special types of cells with Select special (F5).mp4 14.6 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/11.2 87. Index Match-Lecture-after.xlsm 14.5 MB
  • 3. Useful tips and tools for your work in Excel/34. Find and replace - formatting.mp4 14.5 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
  • 10. Introduction to Excel charts/4. How to create a bridge chart in Excel.mp4 14.3 MB
  • 17. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.mp4 14.3 MB
  • 2. Introduction to Excel/4. The Excel ribbon.mp4 14.2 MB
  • 13. Financial modeling fundamentals/12. Modeling the Income statement.mp4 14.0 MB
  • 12. Case Study - Building an FMCG Model from Scratch/2.1 1. Exercise - Build an FMCG Model_Mapping_before.xlsx 13.9 MB
  • 12. Case Study - Building an FMCG Model from Scratch/1.1 108. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx 13.9 MB
  • 17. Tesla valuation - Complete practical exercise/28. Balancing the Balance sheet.mp4 13.9 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/25. Introducing Weighted average cost of capital and Perpetuity growth.mp4 13.9 MB
  • 18. Capital budgeting - The theory/4. Calculating future and present value.mp4 13.7 MB
  • 2. Introduction to Excel/12. Cut, copy, & paste.mp4 13.6 MB
  • 3. Useful tips and tools for your work in Excel/24. How to save macros and use them across several workbooks.mp4 13.4 MB
  • 3. Useful tips and tools for your work in Excel/35. Removing (automatic) green arrows.mp4 13.2 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/13. Learn how to organize your data with Text to Columns.mp4 13.2 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/28. Calculating Equity value.mp4 12.8 MB
  • 19. Capital Budgeting - A complete Case study/4. Fixed asset rollforward.mp4 12.8 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/13. Calculation of DSO, DPO and DOI for the historical period.mp4 12.7 MB
  • 5. Excel's key functions and functionalities made easy/17. A great Excel technique INDEX, MATCH, MATCH.mp4 12.3 MB
  • 3. Useful tips and tools for your work in Excel/2. Initial formatting of Excel sheets for a professional layout.mp4 12.2 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/5.2 105. Bridge chart-Lecture-after.xlsm 12.1 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/6.1 20. Bridge chart_after.xlsm 12.1 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/4.2 104. Area chart-Lecture-after.xlsm 12.1 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/5.1 105. Bridge chart-Lecture-before.xlsm 12.1 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/6.2 20. Bridge chart_before.xlsm 12.1 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/3.1 103. Doughnut chart-Lecture-after.xlsm 12.1 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/4.1 104. Area chart-Lecture-before.xlsm 12.1 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/3.2 103. Doughnut chart-Lecture-before.xlsm 12.1 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/2.2 102. Column stacked chart-Lecture-after.xlsm 12.1 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/2.1 102. Column stacked chart-Lecture-before.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 12.0 MB
  • 10. Introduction to Excel charts/1.1 95. Inserting-Charts-Lecture.xlsm 12.0 MB
  • 10. Introduction to Excel charts/3.1 97. Modifying-a-Chart-Lecture.xlsm 12.0 MB
  • 7. Financial functions in Excel/4. Date functions 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
  • 16. Learn how to build a Discounted Cash Flow model in Excel/32. You made it!.mp4 11.8 MB
  • 2. Introduction to Excel/5. Basic operations with rows and columns.mp4 11.7 MB
  • 3. Useful tips and tools for your work in Excel/13. Custom sort helps you sort multiple columns in Excel tables.mp4 11.7 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/9. Macros are a great timesaver! Here's why!.mp4 11.6 MB
  • 19. Capital Budgeting - A complete Case study/2. Organizing an Inputs sheet.mp4 11.6 MB
  • 2. Introduction to Excel/14. Paste special.mp4 11.4 MB
  • 13. Financial modeling fundamentals/14. Modeling the Balance sheet - Part 2.mp4 11.1 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/5. Create a drop-down list by using Data Validation.mp4 11.1 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/2. Introduction to the case study.mp4 10.7 MB
  • 19. Capital Budgeting - A complete Case study/8. Calculating project cash flows.mp4 10.6 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/12. An introduction to the Days methodology.mp4 10.6 MB
  • 13. Financial modeling fundamentals/3. Why use financial models.mp4 10.5 MB
  • 3. Useful tips and tools for your work in Excel/28. Filter by color - an excellent tool.mp4 10.4 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/10. Find and select special types of cells with Select Special (F5).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
  • 19. Capital Budgeting - A complete Case study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4 9.7 MB
  • 3. Useful tips and tools for your work in Excel/22. Apply custom formatting in a financial model.mp4 9.6 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/6. Using Custom-sort in order to sort multiple columns within a table.mp4 9.6 MB
  • 18. Capital budgeting - The theory/6. Coming up with project-specific beta.mp4 9.4 MB
  • 5. Excel's key functions and functionalities made easy/21. Learn how to render your models flexible with CHOOSE.mp4 9.4 MB
  • 19. Capital Budgeting - A complete Case study/1. Introduction to the Capital budgeting exercise.mp4 9.1 MB
  • 3. Useful tips and tools for your work in Excel/20. Create a great Index page at the beginning of your models - Hyperlinks.mp4 9.0 MB
  • 5. Excel's key functions and functionalities made easy/3.6 Key functions - Excel.pdf 8.9 MB
  • 13. Financial modeling fundamentals/11. Building a complete model - Important considerations.mp4 8.9 MB
  • 17. Tesla valuation - Complete practical exercise/18. Producing a clean P&L output sheet.mp4 8.9 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/1. Initial formatting of an Excel sheet to render it professional.mp4 8.4 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/8. Course Challenge - Apply your skills in practice!.mp4 8.3 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/2. Introduction to the DCF exercise.mp4 8.3 MB
  • 5. Excel's key functions and functionalities made easy/7. Key Excel functions AVERAGE and AVERAGEIF.mp4 8.2 MB
  • 5. Excel's key functions and functionalities made easy/22. Use Goal Seek to find the result that you are looking for.mp4 8.2 MB
  • 3. Useful tips and tools for your work in Excel/17. Assign dynamic names in a financial model.mp4 8.1 MB
  • 3. Useful tips and tools for your work in Excel/19. Define a named range in Excel.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
  • 3. Useful tips and tools for your work in Excel/12. Set print area.mp4 7.9 MB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/8. Cut, copy, & paste.mp4 7.9 MB
  • 3. Useful tips and tools for your work in Excel/27. How to search functionalities in Excel.mp4 7.9 MB
  • 5. Excel's key functions and functionalities made easy/19. Using Excel's IFERROR function to trap spreadsheet errors.mp4 7.9 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/14. Learn how to assign dynamic names within a financial model.mp4 7.7 MB
  • 13. Financial modeling fundamentals/8. Financial modeling The right level of detail in a model.mp4 7.6 MB
  • 13. Financial modeling fundamentals/9. Financial modeling Forecasting guidelines.mp4 7.5 MB
  • 18. Capital budgeting - The theory/2. Why we need Capital budgeting.mp4 7.2 MB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/9. Paste special.mp4 7.0 MB
  • 18. Capital budgeting - The theory/3. The time value of money.mp4 7.0 MB
  • 5. Excel's key functions and functionalities made easy/15. How to enlarge the formula bar.mp4 6.6 MB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/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
  • 13. Financial modeling fundamentals/13. Modeling the Balance sheet - Part 1.mp4 6.4 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. Excel's key functions and functionalities made easy/12. Find the minimum or maximum value in a range of cells in Excel.mp4 6.2 MB
  • 5. Excel's key functions and functionalities made easy/5. = and + are interchangeable when you start typing a formula.mp4 6.1 MB
  • 19. Capital Budgeting - A complete Case study/9. Estimating the weighted average cost of capital (WACC).mp4 5.9 MB
  • 18. Capital budgeting - The theory/7. Weighted average cost of capital (WACC).mp4 5.8 MB
  • 13. Financial modeling fundamentals/2. What is a financial model.mp4 5.7 MB
  • 18. Capital budgeting - The theory/1. Introduction to Capital budgeting.mp4 5.7 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/12. Define a named range in Excel.mp4 5.7 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/11. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4 5.7 MB
  • 19. Capital Budgeting - A complete Case study/5. The impact of working capital.mp4 5.6 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/7. Create a great Index page at the beginning of your models - Hyperlinks.mp4 5.6 MB
  • 17. Tesla valuation - Complete practical exercise/1.1 Tesla Company Valuation - Detailed walkthrough.pdf 5.3 MB
  • 19. Capital Budgeting - A complete Case study/7. Adding a P&L sheet.mp4 5.1 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/15. Create easily printable documents in Excel by using Set Print Area.mp4 5.0 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/11. Forecasting Balance sheet items.mp4 4.9 MB
  • 9. Case study - Building a complete P&L from scratch in Excel/8. 50% completed!.mp4 4.5 MB
  • 3. Useful tips and tools for your work in Excel/8. Alt + Enter.mp4 4.4 MB
  • 3. Useful tips and tools for your work in Excel/11. The wrap text button.mp4 3.8 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/16. Using the 'Alt + Enter' combination.mp4 3.5 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/10.2 Useful-Tips-Tools.pdf 3.5 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/11.1 Useful-Tips-Tools.pdf 3.5 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/12.2 Useful-Tips-Tools.pdf 3.5 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/13.1 Useful-Tips-Tools.pdf 3.5 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/15.2 Useful-Tips-Tools.pdf 3.5 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/2.3 Useful-Tips-Tools.pdf 3.5 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/3.4 Useful-Tips-Tools.pdf 3.5 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/4.2 Useful-Tips-Tools.pdf 3.5 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/5.1 Useful-Tips-Tools.pdf 3.5 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/6.5 Useful-Tips-Tools.pdf 3.5 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/9.1 Useful-Tips-Tools.pdf 3.5 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/1.5 Useful-Tips-Tools.pdf 3.5 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/14.2 Useful-Tips-Tools.pdf 3.5 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/7.2 Useful-Tips-Tools.pdf 3.5 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/8.1 Useful-Tips-Tools.pdf 3.5 MB
  • 5. Excel's key functions and functionalities made easy/13.2 Excel-Functions.pdf 3.3 MB
  • 5. Excel's key functions and functionalities made easy/16.1 Excel-Functions.pdf 3.3 MB
  • 5. Excel's key functions and functionalities made easy/22.4 Excel-Functions.pdf 3.3 MB
  • 5. Excel's key functions and functionalities made easy/4.2 Excel-Functions.pdf 3.3 MB
  • 5. Excel's key functions and functionalities made easy/7.4 Excel-Functions.pdf 3.3 MB
  • 5. Excel's key functions and functionalities made easy/14.3 Excel-Functions.pdf 3.3 MB
  • 5. Excel's key functions and functionalities made easy/19.5 Excel-Functions.pdf 3.3 MB
  • 5. Excel's key functions and functionalities made easy/21.1 Excel-Functions.pdf 3.3 MB
  • 5. Excel's key functions and functionalities made easy/21.2 62. Choose-Lecture - Unsolved.xlsx 3.3 MB
  • 5. Excel's key functions and functionalities made easy/6.4 Excel-Functions.pdf 3.3 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
  • 5. Excel's key functions and functionalities made easy/13. Include ROUND in your financial models.mp4 3.3 MB
  • 3. Useful tips and tools for your work in Excel/1.1 Useful Tips & Tools.pdf 3.2 MB
  • 3. Useful tips and tools for your work in Excel/2.1 Useful Tips & Tools.pdf 3.2 MB
  • 17. Tesla valuation - Complete practical exercise/1.6 Tesla 2017.pdf 2.6 MB
  • 5. Excel's key functions and functionalities made easy/1. Excel's key functions - Welcome lecture.mp4 2.4 MB
  • 19. Capital Budgeting - A complete Case study/15. Congratulations!!.mp4 2.4 MB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/6.3 Introduction-to-Excels-basic-features.pdf 2.4 MB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/7.5 Introduction-to-Excels-basic-features.pdf 2.4 MB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/8.1 Introduction-to-Excels-basic-features.pdf 2.4 MB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/9.1 Introduction-to-Excels-basic-features.pdf 2.4 MB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/1.2 7. Introduction to Excel.pdf 2.4 MB
  • 17. Tesla valuation - Complete practical exercise/1.4 Tesla 2016.pdf 2.3 MB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/4. Learn how to use the Wrap Text button.mp4 2.3 MB
  • 3. Useful tips and tools for your work in Excel/1. Excel best practices - Welcome lecture.mp4 2.2 MB
  • 13. Financial modeling fundamentals/1. Financial modeling basics - Welcome lecture.mp4 2.2 MB
  • 2. Introduction to Excel/12.2 Introduction to Excel.pdf 2.1 MB
  • 2. Introduction to Excel/14.3 Introduction to Excel.pdf 2.1 MB
  • 2. Introduction to Excel/2.3 Introduction to Excel.pdf 2.1 MB
  • 2. Introduction to Excel/5.4 Introduction to Excel.pdf 2.1 MB
  • 2. Introduction to Excel/6.3 Introduction to Excel.pdf 2.1 MB
  • 2. Introduction to Excel/9.5 Introduction to Excel.pdf 2.1 MB
  • 2. Introduction to Excel/11.5 Introduction to Excel.pdf 2.1 MB
  • 2. Introduction to Excel/4.1 Introduction to Excel.pdf 2.1 MB
  • 2. Introduction to Excel/7.3 Introduction to Excel.pdf 2.1 MB
  • 2. Introduction to Excel/1. Introduction to Excel.mp4 2.1 MB
  • 8. Microsoft Excel's Pivot Tables in depth/4.1 75. Working-with-Pivot-Tables - Lecture - after.xlsx 2.0 MB
  • 8. Microsoft Excel's Pivot Tables in depth/6.1 77. Slicers - Lecture - after.xlsx 2.0 MB
  • 8. Microsoft Excel's Pivot Tables in depth/5.1 76. GetPivotData - Lecture - before.xlsx 2.0 MB
  • 8. Microsoft Excel's Pivot Tables in depth/5.2 76. GetPivotData - Lecture – after.xlsx 2.0 MB
  • 8. Microsoft Excel's Pivot Tables in depth/6.2 77. Slicers - Lecture - before.xlsx 2.0 MB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/1. Valuation Case study - Welcome lecture.mp4 1.9 MB
  • 17. Tesla valuation - Complete practical exercise/30.1 22. DCF_before.xlsx 1.6 MB
  • 17. Tesla valuation - Complete practical exercise/17.2 11. Working capital forecasting_after.xlsx 1.6 MB
  • 17. Tesla valuation - Complete practical exercise/8.2 4a. Gross profit automotive - before.xlsx 1.6 MB
  • 17. Tesla valuation - Complete practical exercise/31.1 23. EV, Equity value, Price per share_after.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/30.2 22. DCF_after.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/31.2 23. EV, Equity value, Price per share_before.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/28.1 20. Complete the BS_after.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/27.1 19. Cash flow_complete_after.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/28.2 20. Complete the BS_before.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/29.2 21. WACC_after.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/27.2 19. Cash flow_complete_before.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/26.1 18. P&L complete_after.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/25.2 17. Financing_after.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/29.1 21. WACC_before.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/26.2 18. P&L complete_before.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/25.1 17. Financing_before.xlsx 1.5 MB
  • 8. Microsoft Excel's Pivot Tables in depth/3.2 74. Formatting-a-Pivot-Table - Lecture - after.xlsx 1.5 MB
  • 8. Microsoft Excel's Pivot Tables in depth/2.2 73. Creating-a-Pivot-Table - Lecture - after.xlsx 1.5 MB
  • 8. Microsoft Excel's Pivot Tables in depth/3.1 74. Formatting-a-Pivot-Table - Lecture - before.xlsx 1.5 MB
  • 8. Microsoft Excel's Pivot Tables in depth/4.2 75. Working-with-Pivot-Tables - Lecture - before.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/24.2 16a. Complete UFCF_after.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/24.1 16a. Complete UFCF_before.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/23.2 16. Balance Sheet forecasting liabilities_after.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/22.2 15. Balance Sheet forecasting assets_after.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/23.1 16. Balance Sheet forecasting liabilities_before.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/21.1 14. Cash flow - UFCF_after.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/22.1 15. Balance Sheet forecasting assets_before.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/21.2 14. Cash flow - UFCF_before.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/20.2 13. Calculating working capital_after.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/20.1 13. Calculating working capital_before.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/19.2 12a. P&L fill in_after.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/19.1 12a. P&L fill in_before.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/18.1 12. P&L.xlsx 1.5 MB
  • 17. Tesla valuation - Complete practical exercise/17.1 11. Working capital forecasting_before.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/15.1 10a. PP&E comparison.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/14.2 10. PP&E schedule_after.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/13.2 9. PP&E forecasting and comparables_after.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/14.1 10. PP&E schedule_before.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/13.1 9. PP&E forecasting and comparables_before.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/12.1 8. Opex - After.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/12.2 8. Opex - Before.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/11.1 7. Energy and Other - Gross profit, cost of sales - After.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/11.2 7. Energy and Other - Gross profit, cost of sales - Before.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/10.1 6. Energy and Other revenue - After.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/10.2 6. Energy and Other revenue - Before.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/9.1 5. Cost of sales and chart.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/8.1 4a. Gross profit automotive - after.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/7.1 4. Gross profit automotive.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/6.1 3. Revenue calculation and scenarios - after.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/5.1 2. Average price_after.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/6.2 3. Revenue calculation and scenarios - before.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/5.2 2. Average price_before.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/4.1 1a. Deliveries development.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/1.2 Tesla 2015.pdf 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/3.2 1. Deliveries_after.xlsx 1.4 MB
  • 6. Update! SUMIFS - Exercise/2.1 67. Exercise-Sumifs-With-Solutions.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/3.1 1. Deliveries_before.xlsx 1.4 MB
  • 17. Tesla valuation - Complete practical exercise/2.2 0aa. Inputs_before.xlsx 1.3 MB
  • 17. Tesla valuation - Complete practical exercise/2.1 0aa. Inputs_after.xlsx 1.3 MB
  • 17. Tesla valuation - Complete practical exercise/1.5 0a. Drivers_after.xlsx 1.3 MB
  • 17. Tesla valuation - Complete practical exercise/1.3 0a. Drivers_before.xlsx 1.3 MB
  • 8. Microsoft Excel's Pivot Tables in depth/2.1 73. Creating-a-Pivot-Table - Lecture – before.xlsx 1.3 MB
  • 4. Keyboard shortcuts in Excel/1.1 Beginner to Pro in Excel - Shortcuts for PC.pdf 1.1 MB
  • 5. Excel's key functions and functionalities made easy/24.2 64. Sensitivity analysis - Lecture - Solved.xlsm 918.8 kB
  • 5. Excel's key functions and functionalities made easy/19.2 60. Iferror - Lecture - Unsolved.xlsm 918.8 kB
  • 5. Excel's key functions and functionalities made easy/26.3 65. Pivot tables - Lecture - Solved.xlsm 918.8 kB
  • 5. Excel's key functions and functionalities made easy/24.3 64. Sensitivity analysis - Lecture - Unsolved.xlsm 918.6 kB
  • 5. Excel's key functions and functionalities made easy/19.4 60. Iferror - Lecture - Solved.xlsm 917.9 kB
  • 5. Excel's key functions and functionalities made easy/13.1 55. Excel-functions-Lecture.xlsx 911.3 kB
  • 5. Excel's key functions and functionalities made easy/26.1 65. Pivot tables - Lecture - Unsolved.xlsm 704.3 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/3.3 21. Fixing-references-Lecture - Solved.xlsx 660.7 kB
  • 3. Useful tips and tools for your work in Excel/6.1 Fixing-references-Lecture - Solved.xlsx 660.0 kB
  • 3. Useful tips and tools for your work in Excel/26.1 Freeze-Panes-Lecture - Solved.xlsx 659.6 kB
  • 3. Useful tips and tools for your work in Excel/26.2 Freeze-Panes-Lecture - Unsolved.xlsx 659.6 kB
  • 3. Useful tips and tools for your work in Excel/27.1 Search.xlsx 659.6 kB
  • 3. Useful tips and tools for your work in Excel/6.2 Fixing-references-Lecture - Unsolved.xlsx 659.6 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/3.1 21. Fixing-references-Lecture - Unsolved.xlsx 659.4 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/8.3 35. Freeze-Panes-Lecture - Solved.xlsx 659.4 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/8.2 35. Freeze-Panes-Lecture - Unsolved.xlsx 659.3 kB
  • 3. Useful tips and tools for your work in Excel/3.1 Fast-Scrolling - Lecture.xlsx 659.1 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/2.2 19. Fast-Scrolling - Lecture.xlsx 658.2 kB
  • 17. Tesla valuation - Complete practical exercise/1.7 Tesla 2018 Q2.pdf 650.3 kB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/8.2 107. Course-Challenge - Solved.xlsx 557.0 kB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/8.1 107. Course-Challenge - Unsolved.xlsx 517.6 kB
  • 4. Keyboard shortcuts in Excel/1.2 Beginner to Pro in Excel - Shortcuts for MAC.pdf 458.3 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/3.1 Valuation exercise.pdf 421.6 kB
  • 2. Introduction to Excel/4.3 8. The-Ribbon-Exercise_after.xlsx 412.9 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/3.1 9. The-Ribbon-Exercise-Solved.xlsx 412.9 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/13.2 89. Mapping-exercise-explained.pdf 248.9 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/4.2 DCF Model structure.pdf 246.6 kB
  • 5. Excel's key functions and functionalities made easy/26.2 65. Pivot Tables - Exercise - Solved.xlsx 195.0 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/19.2 Y-o-Y Function explanation.pdf 168.9 kB
  • 3. Useful tips and tools for your work in Excel/28.1 36. Exercise-Filter-by-Color-Solved.xlsx 157.2 kB
  • 5. Excel's key functions and functionalities made easy/26.4 65. Pivot Tables - Exercise - Unsolved.xlsx 155.8 kB
  • 5. Excel's key functions and functionalities made easy/3.3 Functions - English to Portuguese.pdf 149.6 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/6.3 33. Sort-data-Lecture - Solved.xlsx 149.1 kB
  • 3. Useful tips and tools for your work in Excel/13.4 Sort-data-Lecture - Solved.xlsx 149.1 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/6.2 33. Sort-data-Lecture - Unsolved.xlsx 148.8 kB
  • 3. Useful tips and tools for your work in Excel/13.3 Sort-data-Lecture - Unsolved.xlsx 148.8 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/9.2 30. Macros-Exercise - Solved.xlsx 148.5 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/7.1 34. Hyperlinks-Exercise - Solved.xlsx 140.4 kB
  • 3. Useful tips and tools for your work in Excel/20.3 Hyperlinks-Exercise - Solved.xlsx 140.4 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/7.3 34. Hyperlinks-Exercise - Unsolved.xlsx 140.2 kB
  • 3. Useful tips and tools for your work in Excel/20.4 Hyperlinks-Exercise - Unsolved.xlsx 140.2 kB
  • 5. Excel's key functions and functionalities made easy/3.2 Functions - English to Spanish.pdf 104.8 kB
  • 5. Excel's key functions and functionalities made easy/3.1 Functions - English to German.pdf 104.8 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/31.1 30. Charts.xlsm 103.6 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/12.1 Working Capital Days.pptx 97.0 kB
  • 2. Introduction to Excel/11.1 13. Functions- Exercise_after.xlsx 83.0 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/7.3 13. Functions- Exercise - Solved.xlsx 83.0 kB
  • 2. Introduction to Excel/9.1 12. Formulas- Exercise_after.xlsx 82.1 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/6.4 12. Formulas- Exercise - Solved.xlsx 82.1 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/5.1 Cheeseco.pptx 82.0 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/5.4 32. Drop-down-List-Exercise - Solved.xlsx 78.9 kB
  • 3. Useful tips and tools for your work in Excel/14.2 Drop-down-List-Exercise - Solved.xlsx 78.9 kB
  • 5. Excel's key functions and functionalities made easy/24.4 64. Sensitivity-analysis-Exercise-Unsolved.xlsm 68.4 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/30.2 29. Goal seek_ater.xlsm 66.4 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/29.2 28. Sensitivity analysis_after.xlsm 66.4 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/30.1 29. Goal seek_before.xlsm 66.4 kB
  • 5. Excel's key functions and functionalities made easy/24.1 64. Sensitivity-analysis-Exercise-Solved.xlsm 65.4 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/28.2 27. Calculating equity value_after.xlsm 64.8 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/29.1 28. Sensitivity analysis_before.xlsm 64.8 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/27.2 26. Calculating CV and EV_after.xlsm 64.6 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/28.1 27. Calculating equity value_before.xlsm 64.6 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/26.2 25. Calculating PV of Cash Flows_after.xlsm 64.2 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/27.1 26. Calculating CV and EV_before.xlsm 64.2 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/25.2 24. Introducing WACC and g_after.xlsm 64.1 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/26.1 25. Calculating PV of Cash Flows_before.xlsm 64.1 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/24.2 23. Find and replace_after.xlsm 64.0 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/25.1 24. Introducing WACC and g_before.xlsm 64.0 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/29.3 Sensitivity Analysis.xlsx 62.3 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/24.1 23. Find and replace_before.xlsm 61.0 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/23.2 22. Calculating Net Cash Flow_after.xlsm 60.8 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/22.2 21. Calculating UFCF_after.xlsm 60.6 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/23.1 22. Calculating Net Cash Flow_before.xlsm 60.6 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/21.1 20. Bridge UFCF to Net cash flow_after.xlsm 60.1 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/22.1 21. Calculating UFCF_before.xlsm 60.1 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/20.2 19. Cash flow structure_after.xlsm 60.0 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/21.2 20. Bridge UFCF to Net cash flow_before.xlsm 60.0 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/20.1 19. Cash flow structure_before.xlsm 59.9 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/19.2 18. Completing the Balance Sheet_after.xlsm 59.5 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/18.1 17. Populating BS sheet_after.xlsm 58.6 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/19.1 18. Completing the Balance Sheet_before.xlsm 58.6 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/19.1 94. Adding % variations-Lecture-after.xlsm 57.9 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/23.3 Cash Flow Classification By Activities.xlsx 57.3 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/17.1 16. Populating the P&L sheet_after.xlsm 56.6 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/18.2 17. Populating BS sheet_before.xlsm 56.6 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/18.2 93. Countif-Lecture-after.xlsm 56.1 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/19.3 94. Adding % variations-Lecture-before.xlsm 56.1 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/16.2 15. P&L structure_after.xlsm 55.0 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/17.2 16. Populating the P&L sheet_before.xlsm 55.0 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/16.1 15. P&L structure_before.xlsm 54.9 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/16.1 92. Formatting the P&L-Lecture-after.xlsm 54.8 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/18.1 93. Countif-Lecture-before.xlsm 54.8 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/15.2 14. Forecasting PP&E, Other assets, and Other liabilities_after.xlsm 54.2 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/16.2 92. Formatting the P&L-Lecture-before.xlsm 53.2 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/14.2 13. Forecasting DSO, DPO, DIO_after.xlsm 53.2 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/15.1 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm 53.2 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/15.1 91. Formatting the P&L-Lecture-after.xlsm 53.2 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/15.2 91. Formatting a P&L-Lecture-before.xlsm 53.1 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/14.2 90. Building a P&L-Lecture-after.xlsm 53.1 kB
  • 3. Useful tips and tools for your work in Excel/29.3 Solution_Conditional Formatting.xlsx 52.8 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/13.2 12. Days calculation_after.xlsm 52.7 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/14.1 13. Forecasting DSO, DPO, DIO_before.xlsm 52.7 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/13.1 12. Days calculation_before.xlsm 52.4 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/11.1 10. Introduction to Balance sheet items.xlsm 52.2 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/10.1 9. Interest expenses, taxes_after.xlsm 52.1 kB
  • 3. Useful tips and tools for your work in Excel/37.1 43. F2-Lecture.xlsm 52.0 kB
  • 3. Useful tips and tools for your work in Excel/5.1 20. F5-go-to - Lecture.xlsm 52.0 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/10.2 9. Interest expenses, taxes_before.xlsm 51.8 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/9.2 8. Opex and D&A_after.xlsm 51.8 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/12.2 88. Mapping_before.xlsm 51.8 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/13.3 89. Mapping-Lecture-Unsolved.xlsm 51.8 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/12.1 88. Mapping-Lecture-after.xlsm 51.4 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/14.1 90. Building a P&L-Lecture-before.xlsm 51.4 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/8.1 7. Other revenues and Cogs_after.xlsm 51.3 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/9.1 8. Opex and D&A_before.xlsm 51.3 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/9.2 86. Sumif_after.xlsm 50.7 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/7.2 6. Choose_after.xlsm 49.5 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/8.2 7. Other revenues and Cogs_before.xlsm 49.5 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/6.1 5. Modeling revenues_after.xlsm 49.3 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/7.1 6. Choose_before.xlsm 49.3 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/4.1 3. Structure of the DCF model.xlsm 49.0 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/6.2 5. Modeling revenues_before.xlsm 49.0 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/13.1 89. Mapping-Lecture-Solved.xlsx 48.6 kB
  • 5. Excel's key functions and functionalities made easy/15.1 57. Enlarge-the-formula-bar-Lecture.xlsm 48.0 kB
  • 3. Useful tips and tools for your work in Excel/9.5 Invoice example.pdf 45.5 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/7.2 84. Vlookup_after.xlsm 45.5 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/9.1 86. Sumif_before.xlsm 45.5 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/2.4 19. Fast-Scrolling-Exercise - Solved.xlsx 45.4 kB
  • 3. Useful tips and tools for your work in Excel/3.2 Fast-Scrolling-Exercise - Solved.xlsx 45.4 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/2.1 19. Fast-Scrolling-Exercise - Unsolved.xlsx 45.0 kB
  • 3. Useful tips and tools for your work in Excel/3.3 Fast-Scrolling-Exercise - Unsolved.xlsx 45.0 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/4.2 81. Order a worksheet_before.xlsm 44.1 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/3.1 80. Get to know the data source.xlsm 44.1 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/5.2 82. Creating a code_after.xlsm 42.7 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/6.1 83. Creating a database_before.xlsm 42.7 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/11.1 87. Index Match-Lecture-before.xlsm 42.0 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/4.1 81. Order a worksheet_after.xlsm 42.0 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/5.1 82. Creating a code_before.xlsm 42.0 kB
  • 19. Capital Budgeting - A complete Case study/12.2 10. Sensitivity analysis.xlsx 41.6 kB
  • 19. Capital Budgeting - A complete Case study/11.2 9. Discounted cash flow.xlsx 40.7 kB
  • 19. Capital Budgeting - A complete Case study/12.1 10. Sensitivity analysis_unsolved.xlsx 40.6 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/7.1 84. Vlookup_before.xlsm 40.5 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/6.2 83. Creating a database_after.xlsm 40.3 kB
  • 3. Useful tips and tools for your work in Excel/32.1 39. Find-and-Replace-references-Lecture-before.xlsx 39.7 kB
  • 19. Capital Budgeting - A complete Case study/11.1 9. Discounted cash flow_unsolved.xlsx 39.6 kB
  • 19. Capital Budgeting - A complete Case study/10.1 8. WACC.xlsx 38.9 kB
  • 19. Capital Budgeting - A complete Case study/9.2 8. WACC.xlsx 38.9 kB
  • 3. Useful tips and tools for your work in Excel/32.2 39. Find-and-Replace-references-Lecture-after.xlsx 38.8 kB
  • 19. Capital Budgeting - A complete Case study/10.2 8. WACC_unsolved.xlsx 36.8 kB
  • 19. Capital Budgeting - A complete Case study/9.1 8. WACC_unsolved.xlsx 36.8 kB
  • 2. Introduction to Excel/6.4 10. Data-Entry- Exercise_after.xlsx 33.5 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/4.3 10. Data-Entry- Exercise -Solved.xlsx 33.5 kB
  • 2. Introduction to Excel/5.3 9. Basic-Manipulations - Exercise_after.xlsx 33.2 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/2.2 8. Basic-Manipulations - Exercise - Solved.xlsx 33.2 kB
  • 19. Capital Budgeting - A complete Case study/8.2 7. Cash flow.xlsx 32.1 kB
  • 19. Capital Budgeting - A complete Case study/7.1 6. P&L.xlsx 31.8 kB
  • 19. Capital Budgeting - A complete Case study/6.1 5. Financing.xlsx 31.7 kB
  • 19. Capital Budgeting - A complete Case study/6.2 5. Financing_unsolved.xlsx 30.7 kB
  • 19. Capital Budgeting - A complete Case study/7.2 6. P&L_unsolved.xlsx 30.4 kB
  • 19. Capital Budgeting - A complete Case study/8.1 7. Cash flow_unsolved.xlsx 30.4 kB
  • 7. Financial functions in Excel/3.2 70. Exercise-Loan-Schedule-Solved.xlsx 23.2 kB
  • 5. Excel's key functions and functionalities made easy/17.3 Index, Match, Match - Lecture.xlsx 22.9 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/10.1 26. Select-Special-F5-Exercise - Solved.xlsx 22.8 kB
  • 3. Useful tips and tools for your work in Excel/15.3 Select-Special-F5-Exercise - Solved.xlsx 22.8 kB
  • 3. Useful tips and tools for your work in Excel/35.1 41. Green-references-Lecture.xlsx 22.5 kB
  • 19. Capital Budgeting - A complete Case study/5.1 4. Working Capital.xlsx 22.5 kB
  • 2. Introduction to Excel/7.4 11. Formatting-Exercise_before.xlsx 22.1 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/10.4 26. Select-Special-F5-Exercise - Unsolved.xlsx 22.1 kB
  • 3. Useful tips and tools for your work in Excel/15.2 Select-Special-F5-Exercise - Unsolved.xlsx 22.1 kB
  • 19. Capital Budgeting - A complete Case study/5.2 4. Working Capital_unsolved.xlsx 21.7 kB
  • 3. Useful tips and tools for your work in Excel/28.2 36. Exercise-Filter-by-Color-Unsolved.xlsx 21.0 kB
  • 7. Financial functions in Excel/3.3 70. Loan Schedule-Lecture.xlsx 20.7 kB
  • 19. Capital Budgeting - A complete Case study/4.2 3. Fixed Asset Rollforward.xlsx 20.1 kB
  • 19. Capital Budgeting - A complete Case study/4.1 3. Fixed Asset Rollforward_unsolved.xlsx 19.0 kB
  • 5. Excel's key functions and functionalities made easy/3.5 47. IF-function-Lecture-after.xlsm 18.4 kB
  • 3. Useful tips and tools for your work in Excel/31.2 38. Multiply-by-1-Lecture-after.xlsx 17.6 kB
  • 3. Useful tips and tools for your work in Excel/34.1 40. Find-replace-Lecture-after.xlsx 17.6 kB
  • 3. Useful tips and tools for your work in Excel/34.2 40. Find-replace-Lecture-before.xlsx 17.6 kB
  • 3. Useful tips and tools for your work in Excel/36.2 42. Beauty-saving-Lecture-before.xlsx 17.6 kB
  • 3. Useful tips and tools for your work in Excel/36.1 42. Beauty-saving-Lecture-after.xlsx 17.5 kB
  • 5. Excel's key functions and functionalities made easy/5.2 49. = and + are interchangeable -after.xlsm 17.4 kB
  • 5. Excel's key functions and functionalities made easy/5.1 49. = and + are interchangeable - before.xlsm 17.4 kB
  • 5. Excel's key functions and functionalities made easy/3.4 47. IF-function--Lecture-before.xlsm 17.4 kB
  • 19. Capital Budgeting - A complete Case study/3.2 2. Savings Forecast.xlsx 17.0 kB
  • 3. Useful tips and tools for your work in Excel/31.1 38. Multiply-by-1-Lecture-before.xlsx 16.9 kB
  • 5. Excel's key functions and functionalities made easy/22.1 63. Goal-Seek-Exercise-Solved.xlsx 16.6 kB
  • 5. Excel's key functions and functionalities made easy/22.5 63. Goal-Seek-Exercise - Unsolved.xlsx 16.5 kB
  • 5. Excel's key functions and functionalities made easy/6.1 05 38 Counts Solved.xlsx 16.4 kB
  • 17. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.srt 16.4 kB
  • 7. Financial functions in Excel/3.1 70. Exercise-Loan-Schedule-Unsolved.xlsx 16.2 kB
  • 5. Excel's key functions and functionalities made easy/6.2 05 38 Counts Exercise & Text.xlsx 16.0 kB
  • 5. Excel's key functions and functionalities made easy/19.1 60. Iferror-Exercise - Solved.xlsx 15.7 kB
  • 5. Excel's key functions and functionalities made easy/7.3 51. Average-AverageIF-Exercise - Solved.xlsx 15.4 kB
  • 5. Excel's key functions and functionalities made easy/4.5 48. Sum-Sumif-Sumifs-Exercise - Solved.xlsx 15.2 kB
  • 5. Excel's key functions and functionalities made easy/12.3 54. MIN-MAX-Exercise - Solved.xlsx 15.2 kB
  • 19. Capital Budgeting - A complete Case study/3.1 2. Savings Forecast_unsolved.xlsx 15.1 kB
  • 5. Excel's key functions and functionalities made easy/7.1 51. Average-AverageIF-Exercise - Unsolved.xlsx 14.9 kB
  • 5. Excel's key functions and functionalities made easy/4.1 48. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx 14.8 kB
  • 5. Excel's key functions and functionalities made easy/12.2 54. MIN-MAX-Exercise - Unsolved.xlsx 14.7 kB
  • 3. Useful tips and tools for your work in Excel/20.1 Hyperlinks - Lecture - Solved.xlsx 14.7 kB
  • 5. Excel's key functions and functionalities made easy/19.3 60. Iferror-Exercise - Unsolved.xlsx 14.6 kB
  • 3. Useful tips and tools for your work in Excel/20.2 Hyperlinks - Lecture - Unsolved.xlsx 14.5 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/14.4 27. Dynamic-Naming-Lecture - Solved.xlsx 14.2 kB
  • 3. Useful tips and tools for your work in Excel/17.1 Dynamic-Naming-Lecture - Unsolved.xlsx 14.0 kB
  • 5. Excel's key functions and functionalities made easy/14.4 56. Vlookup-Hlookup-Exercise - Solved.xlsx 14.0 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/14.5 27. Dynamic-Naming-Lecture - Unsolved.xlsx 13.9 kB
  • 2. Introduction to Excel/14.2 15. Paste-Special-Exercise_before.xlsx 13.8 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/9.3 15. Paste-Special-Exercise - Unsolved.xlsx 13.8 kB
  • 2. Introduction to Excel/14.1 15. Paste-Special-Exercise_after.xlsx 13.8 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/9.2 15. Paste-Special-Exercise - Solved.xlsx 13.8 kB
  • 2. Introduction to Excel/11.4 13. Functions-Exercise_before.xlsx 13.6 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/7.2 13. Functions-Exercise - Unsolved.xlsx 13.6 kB
  • 10. Introduction to Excel charts/4.1 98. Bridge-Charts-Lecture.xlsx 13.4 kB
  • 5. Excel's key functions and functionalities made easy/4.4 48. Sum-Sumif-Sumifs-Lecture - Solved.xlsx 13.3 kB
  • 5. Excel's key functions and functionalities made easy/4.3 48. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx 13.2 kB
  • 3. Useful tips and tools for your work in Excel/29.1 Exercise_Conditional Formatting.xlsx 13.2 kB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.srt 13.0 kB
  • 10. Introduction to Excel charts/5.1 99. Treemap-Charts-Lecture.xlsx 12.9 kB
  • 5. Excel's key functions and functionalities made easy/20.2 61. Rank-function-Lecture-after.xlsx 12.9 kB
  • 3. Useful tips and tools for your work in Excel/24.2 31. How-to-save-macros-Lecture-after.xlsm 12.9 kB
  • 2. Introduction to Excel/12.1 14. Copy-Cut-Paste-Exercise_after.xlsx 12.9 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/8.3 14. Copy-Cut-Paste-Exercise - Solved.xlsx 12.9 kB
  • 3. Useful tips and tools for your work in Excel/29.2 Conditional Formatting - Lecture.xlsx 12.8 kB
  • 7. Financial functions in Excel/4.2 71. Date Functions-Exercise-Solved.xlsx 12.7 kB
  • 3. Useful tips and tools for your work in Excel/17.2 Dynamic-Naming-Lecture - Solved.xlsx 12.7 kB
  • 7. Financial functions in Excel/2.1 69. Exercise-IRR-Solved.xlsx 12.6 kB
  • 5. Excel's key functions and functionalities made easy/20.1 61. Rank-function-Lecture-before.xlsx 12.6 kB
  • 7. Financial functions in Excel/4.3 71. Date Functions-Lecture.xlsx 12.5 kB
  • 5. Excel's key functions and functionalities made easy/9.1 52. Text functions - Exercise - Solved.xlsx 12.5 kB
  • 5. Excel's key functions and functionalities made easy/17.1 59. Exercise-Index-Match-Match-Solved.xlsx 12.5 kB
  • 2. Introduction to Excel/4.2 8. The-Ribbon-Exercise_before.xlsx 12.4 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/3.2 9. The-Ribbon-Exercise-Exercise - Unsolved.xlsx 12.4 kB
  • 5. Excel's key functions and functionalities made easy/16.4 58. Index-Match-Exercise - Solved.xlsx 12.4 kB
  • 5. Excel's key functions and functionalities made easy/14.5 56. Vlookup-Hlookup-Exercise - Unsolved.xlsx 12.2 kB
  • 3. Useful tips and tools for your work in Excel/12.2 Set-Print-Area-Lecture - Unsolved.xlsx 12.1 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/14.1 27. Assigning-Dynamic-Names-Exercise - Solved.xlsx 12.0 kB
  • 3. Useful tips and tools for your work in Excel/17.4 Assigning-Dynamic-Names-Exercise - Solved.xlsx 12.0 kB
  • 5. Excel's key functions and functionalities made easy/21.3 62. Choose-Exercise-Solved.xlsx 12.0 kB
  • 2. Introduction to Excel/9.3 12. Formulas - Exercise_before.xlsx 12.0 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/6.1 12. Formulas - Exercise - Unsolved.xlsx 12.0 kB
  • 5. Excel's key functions and functionalities made easy/13.4 55. Round-Exercise - Solved.xlsx 12.0 kB
  • 5. Excel's key functions and functionalities made easy/9.2 52. Text functions - Exercise - Unsolved.xlsx 12.0 kB
  • 5. Excel's key functions and functionalities made easy/16.3 58. Index-Match-Lecture - Solved.xlsx 12.0 kB
  • 5. Excel's key functions and functionalities made easy/6.5 Lecture-Count-Countif-Countifs-Solved.xlsx 12.0 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/12.3 28. Defining-a-Named-Range-Exercise - Solved.xlsx 11.9 kB
  • 3. Useful tips and tools for your work in Excel/19.1 28. Defining-a-Named-Range-Exercise - Solved.xlsx 11.9 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/5.2 11. Formatting-Exercise - Unsolved.xlsx 11.9 kB
  • 2. Introduction to Excel/7.5 11. Formatting- Exercise_after.xlsx 11.9 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/5.3 11. Formatting- Exercise - Solved.xlsx 11.9 kB
  • 5. Excel's key functions and functionalities made easy/16.5 58. Index-Match-Exercise - Unsolved.xlsx 11.9 kB
  • 5. Excel's key functions and functionalities made easy/17.2 59. Exercise-Index-Match-Match-Unsolved.xlsx 11.9 kB
  • 7. Financial functions in Excel/2.2 69. Exercise-IRR-Unsolved.xlsx 11.8 kB
  • 19. Capital Budgeting - A complete Case study/2.1 1. Drivers.xlsx 11.8 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/6.4 33. Custom-Sort-Exercise - Solved.xlsx 11.7 kB
  • 3. Useful tips and tools for your work in Excel/13.1 Custom-Sort-Exercise - Solved.xlsx 11.7 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/15.3 25. Set-Print-Area-Lecture - Unsolved.xlsx 11.7 kB
  • 7. Financial functions in Excel/4.1 71. Date Functions-Exercise-Unsolved.xlsx 11.7 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/16.2 22. Alt-Enter-Exercise - Solved.xlsx 11.7 kB
  • 3. Useful tips and tools for your work in Excel/8.4 Alt-Enter-Exercise - Solved.xlsx 11.7 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/6.1 33. Custom-Sort-Exercise - Unsolved.xlsx 11.6 kB
  • 3. Useful tips and tools for your work in Excel/13.2 Custom-Sort-Exercise - Unsolved.xlsx 11.6 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/11.3 29. Assigning Custom Formats - Exercise - Unsolved.xlsx 11.6 kB
  • 3. Useful tips and tools for your work in Excel/22.1 Assigning Custom Formats - Exercise - Unsolved.xlsx 11.6 kB
  • 2. Introduction to Excel/12.3 14. Copy-Cut-Paste-Exercise_before.xlsx 11.6 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/8.2 14. Copy-Cut-Paste-Exercise - Unsolved.xlsx 11.6 kB
  • 5. Excel's key functions and functionalities made easy/13.3 55. Round-Exercise - Unsolved.xlsx 11.6 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/5.2 32. Drop-down-List-Exercise - Unsolved.xlsx 11.6 kB
  • 3. Useful tips and tools for your work in Excel/14.4 Drop-down-List-Exercise - Unsolved.xlsx 11.6 kB
  • 5. Excel's key functions and functionalities made easy/21.5 62. Choose-Exercise - Unsolved.xlsx 11.6 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/13.3 23. Text-to-Columns-Exercise - Solved.xlsx 11.6 kB
  • 3. Useful tips and tools for your work in Excel/9.4 Text-to-Columns-Exercise - Solved.xlsx 11.6 kB
  • 5. Excel's key functions and functionalities made easy/16.2 58. Index-Match-Lecture - Unsolved.xlsx 11.6 kB
  • 5. Excel's key functions and functionalities made easy/6.3 Lecture-Count-Countif-Countifs-Unsolved.xlsx 11.6 kB
  • 3. Useful tips and tools for your work in Excel/14.1 Data-Validation-Lecture - Solved.xlsx 11.5 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/14.3 27. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx 11.5 kB
  • 3. Useful tips and tools for your work in Excel/17.3 Assigning-Dynamic-Names-Exercise - Unsolved.xlsx 11.5 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/15.1 25. Set-Print-Area-Lecture - Solved.xlsx 11.5 kB
  • 3. Useful tips and tools for your work in Excel/12.1 Set-Print-Area-Lecture - Solved.xlsx 11.5 kB
  • 7. Financial functions in Excel/2.3 69. IRR-Lecture.xlsx 11.5 kB
  • 3. Useful tips and tools for your work in Excel/14.3 Data-Validation-Lecture - Unsolved.xlsx 11.5 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/9.5 30. Creating-a-Macro-Lecture - Solved.xlsx 11.4 kB
  • 5. Excel's key functions and functionalities made easy/14.2 56. Vlookup-Hlookup- Lecture - Solved.xlsx 11.4 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/16.1 22. Alt-Enter-Exercise - Unsolved.xlsx 11.4 kB
  • 3. Useful tips and tools for your work in Excel/8.1 Alt-Enter-Exercise - Unsolved.xlsx 11.4 kB
  • 5. Excel's key functions and functionalities made easy/9.3 52. Text-Functions- Lecture - Solved.xlsx 11.4 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/11.2 29. Assigning Custom Formats - Exercise - Solved.xlsx 11.3 kB
  • 3. Useful tips and tools for your work in Excel/22.3 Assigning Custom Formats - Exercise - Solved.xlsx 11.3 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/12.5 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx 11.3 kB
  • 3. Useful tips and tools for your work in Excel/19.2 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx 11.3 kB
  • 2. Introduction to Excel/5.2 9. Basic-Manipulations - Exercise_before.xlsx 11.3 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/2.3 8. Basic-Manipulations - Exercise - Unsolved.xlsx 11.3 kB
  • 2. Introduction to Excel/6.1 10. Data-Entry-Exercise_before.xlsx 11.2 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/4.1 10. Data-Entry-Exercise - Unsolved.xlsx 11.2 kB
  • 3. Useful tips and tools for your work in Excel/15.1 Select-Special-Lecture-Solved.xlsx 11.2 kB
  • 5. Excel's key functions and functionalities made easy/11.2 53. Work-with-text-Lecture-after.xlsx 11.2 kB
  • 2. Introduction to Excel/2.2 7. Overview-of-Excel-Exercise_after.xlsx 11.1 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/1.1 7. Overview-of-Excel-Exercise-Solved.xlsx 11.1 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/5.5 32. Data-Validation-Lecture - Solved.xlsx 11.1 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/5.3 32. Data-Validation-Lecture - Unsolved.xlsx 11.1 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/3.2 21. Fixing-Cells-Exercise - Solved.xlsx 11.1 kB
  • 3. Useful tips and tools for your work in Excel/6.4 Fixing-Cells-Exercise - Solved.xlsx 11.1 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/1.2 18. Formatting-a-Worksheet-Exercise - Solved.xlsx 11.0 kB
  • 3. Useful tips and tools for your work in Excel/2.2 Formatting-a-Worksheet-Exercise - Solved.xlsx 11.0 kB
  • 3. Useful tips and tools for your work in Excel/21.2 19. Custom formatting_after.xlsx 11.0 kB
  • 5. Excel's key functions and functionalities made easy/14.1 56. Vlookup-Hlookup- Lecture - Unsolved.xlsx 11.0 kB
  • 3. Useful tips and tools for your work in Excel/21.1 19. Custom formatting_before.xlsx 10.9 kB
  • 6. Update! SUMIFS - Exercise/2. Exercise - Excel's SUMIFS function - solved & explained.srt 10.9 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/3.5 21. Fixing-Cells-Exercise - Unsolved.xlsx 10.9 kB
  • 3. Useful tips and tools for your work in Excel/6.3 Fixing-Cells-Exercise - Unsolved.xlsx 10.9 kB
  • 7. Financial functions in Excel/1.1 68. FV and PV-Lecture.xlsx 10.9 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/1.1 18. Formatting-a-Worksheet-Exercise - Unsolved.xlsx 10.9 kB
  • 3. Useful tips and tools for your work in Excel/2.4 Formatting-a-Worksheet-Exercise - Unsolved.xlsx 10.9 kB
  • 5. Excel's key functions and functionalities made easy/9.4 52. Text-Functions- Lecture - Unsolved.xlsx 10.9 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/13.2 23. Text-to-Columns-Exercise - Unsolved.xlsx 10.8 kB
  • 3. Useful tips and tools for your work in Excel/9.1 Text-to-Columns-Exercise - Unsolved.xlsx 10.8 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/10.3 26. Select-Special-Lecture.xlsx 10.8 kB
  • 3. Useful tips and tools for your work in Excel/15.4 Select-Special-Lecture.xlsx 10.8 kB
  • 2. Introduction to Excel/2.1 7. Overview-of-Excel-Exercise_before.xlsx 10.7 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/1.3 7. Overview-of-Excel-Exercise-Unsolved.xlsx 10.7 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/9.3 30. Macros-Exercise - Unsolved.xlsx 10.6 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/12.4 28. Naming-ranges-Lecture - Solved.xlsx 10.6 kB
  • 3. Useful tips and tools for your work in Excel/19.4 28. Naming-ranges-Lecture - Solved.xlsx 10.6 kB
  • 5. Excel's key functions and functionalities made easy/11.1 53. Work-with-text-Lecture-before.xlsx 10.6 kB
  • 3. Useful tips and tools for your work in Excel/9.3 Text-to-columns-Lecture - Solved.xlsx 10.4 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/4.1 24. Wrap-Text-Exercise - Solved.xlsx 10.4 kB
  • 3. Useful tips and tools for your work in Excel/11.2 Wrap-Text-Exercise - Solved.xlsx 10.4 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/4.3 24. Wrap-Text-Exercise - Unsolved.xlsx 10.4 kB
  • 3. Useful tips and tools for your work in Excel/11.4 Wrap-Text-Exercise - Unsolved.xlsx 10.4 kB
  • 3. Useful tips and tools for your work in Excel/8.2 Alt-Enter- Lecture - Solved.xlsx 10.2 kB
  • 3. Useful tips and tools for your work in Excel/8.3 Alt-Enter- Lecture - Unsolved.xlsx 10.2 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/13.4 23.Text-to-columns-Lecture - Solved.xlsx 10.1 kB
  • 2. Introduction to Excel/7.1 11. Formatting - Lecture_after.xlsx 10.1 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/5.1 11. Formatting - Lecture - Solved.xlsx 10.1 kB
  • 2. Introduction to Excel/15.1 10. Format cells_before.xlsx 10.0 kB
  • 2. Introduction to Excel/15.2 10. Format cells_after.xlsx 10.0 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/13.5 23. Text-to-columns-Lecture - Unsolved.xlsx 10.0 kB
  • 3. Useful tips and tools for your work in Excel/9.2 Text-to-columns-Lecture - Unsolved.xlsx 10.0 kB
  • 5. Excel's key functions and functionalities made easy/21.4 62. Choose-Lecture - Solved.xlsx 9.9 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/9.4 30. Creating-a-Macro-Lecture - Unsolved.xlsx 9.9 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/16.3 22. Alt-Enter- Lecture - Solved.xlsx 9.9 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/16.4 22. Alt-Enter- Lecture - Unsolved.xlsx 9.9 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/4.5 24. Wrap-text-Lecture - Unsolved.xlsx 9.8 kB
  • 3. Useful tips and tools for your work in Excel/11.3 Wrap-text-Lecture - Unsolved.xlsx 9.8 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/4.4 24. Wrap-text-Lecture - Solved.xlsx 9.8 kB
  • 3. Useful tips and tools for your work in Excel/11.1 Wrap-text-Lecture - Solved.xlsx 9.8 kB
  • 10. Introduction to Excel charts/6.1 100. Sparklines-Lecture.xlsx 9.8 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/1.3 18. Formatting-a-worksheet-Lecture - Solved.xlsx 9.8 kB
  • 3. Useful tips and tools for your work in Excel/2.3 Formatting-a-worksheet-Lecture - Solved.xlsx 9.8 kB
  • 5. Excel's key functions and functionalities made easy/7.2 51. Average-Averageif- Lecture - Solved.xlsx 9.6 kB
  • 2. Introduction to Excel/9.2 12. Formulas- Lecture_after.xlsx 9.6 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/6.5 12. Formulas- Lecture - Solved.xlsx 9.6 kB
  • 2. Introduction to Excel/11.2 13. Functions - Lecture_after.xlsx 9.6 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/7.4 13. Functions - Lecture -Solved.xlsx 9.6 kB
  • 2. Introduction to Excel/9.4 12. Formulas- Lecture_before.xlsx 9.5 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/6.2 12. Formulas- Lecture - Unsolved.xlsx 9.5 kB
  • 2. Introduction to Excel/11.3 13. Functions- Lecture_before.xlsx 9.5 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/7.1 13. Functions- Lecture - Unsolved.xlsx 9.5 kB
  • 5. Excel's key functions and functionalities made easy/12.4 54. Max-min-Lecture - Solved.xlsx 9.4 kB
  • 5. Excel's key functions and functionalities made easy/22.2 63. Goal-Seek-Lecture - Solved.xlsx 9.4 kB
  • 5. Excel's key functions and functionalities made easy/22.3 63. Goal-Seek-Lecture - Unsolved.xlsx 9.4 kB
  • 5. Excel's key functions and functionalities made easy/7.5 51. Average-Averageif- Lecture - Unsolved.xlsx 9.2 kB
  • 5. Excel's key functions and functionalities made easy/14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.srt 9.2 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/1.4 18. Formatting-a-worksheet-Lecture - Unsolved.xlsx 9.2 kB
  • 3. Useful tips and tools for your work in Excel/2.5 Formatting-a-worksheet-Lecture - Unsolved.xlsx 9.2 kB
  • 5. Excel's key functions and functionalities made easy/12.1 54. Max-min-Lecture - Unsolved.xlsx 9.2 kB
  • 2. Introduction to Excel/7.2 11. Formatting- Lecture_before.xlsx 9.1 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/5.4 11. Formatting- Lecture - Unsolved.xlsx 9.1 kB
  • 5. Excel's key functions and functionalities made easy/16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.srt 9.0 kB
  • 3. Useful tips and tools for your work in Excel/24.1 31. Another-file.xlsx 9.0 kB
  • 3. Useful tips and tools for your work in Excel/22.2 Custom formats - Lecture - Solved.xlsx 9.0 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/12.1 28. Naming-ranges-Lecture - Unsolved.xlsx 9.0 kB
  • 3. Useful tips and tools for your work in Excel/19.3 28. Naming-ranges-Lecture - Unsolved.xlsx 9.0 kB
  • 3. Useful tips and tools for your work in Excel/22.4 Custom formats - Lecture - Unsolved.xlsx 8.5 kB
  • 2. Introduction to Excel/5.1 9. Basic Manipulations - Lecture.xlsx 8.3 kB
  • 2. Introduction to Excel/6.2 10. Data-Entry - Lecture.xlsx 8.3 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/2.1 8. Basic manipulations - Lecture.xlsx 8.3 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/4.2 10. Data-Entry - Lecture.xlsx 8.3 kB
  • 3. Useful tips and tools for your work in Excel/21. Introduction to custom formatting in Excel.srt 8.3 kB
  • 18. Capital budgeting - The theory/5. Calculating cost of equity.srt 8.2 kB
  • 19. Capital Budgeting - A complete Case study/10. Finding cost of equity.srt 7.8 kB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/5. Learn how to create bridge charts.srt 7.8 kB
  • 13. Financial modeling fundamentals/12. Modeling the Income statement.srt 7.6 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/3. The stages of a complete DCF Valuation.srt 7.5 kB
  • 13. Financial modeling fundamentals/4. Financial modeling - worst practices - things you should avoid.srt 7.5 kB
  • 18. Capital budgeting - The theory/9. Estimating the project's cash flows.srt 7.3 kB
  • 12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.srt 7.3 kB
  • 7. Financial functions in Excel/1. Future and present values in Excel.srt 7.1 kB
  • 17. Tesla valuation - Complete practical exercise/29. Estimating Weighted average cost of capital (WACC).srt 6.9 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/13. In case you have any doubts about the Mapping exercise.srt 6.9 kB
  • 18. Capital budgeting - The theory/4. Calculating future and present value.srt 6.8 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/5. Introduction to formatting.srt 6.8 kB
  • 19. Capital Budgeting - A complete Case study/2. Organizing an Inputs sheet.srt 6.7 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/22. Calculating Unlevered free cash flow.srt 6.7 kB
  • 7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.srt 6.7 kB
  • 2. Introduction to Excel/15. Format cells.srt 6.7 kB
  • 17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.srt 6.6 kB
  • 13. Financial modeling fundamentals/14. Modeling the Balance sheet - Part 2.srt 6.2 kB
  • 17. Tesla valuation - Complete practical exercise/21. Forecasting Unlevered free cash flow.srt 6.2 kB
  • 3. Useful tips and tools for your work in Excel/29. Working with conditional formatting.srt 6.2 kB
  • 13. Financial modeling fundamentals/5. Financial modeling - best practices.srt 6.2 kB
  • 3. Useful tips and tools for your work in Excel/24.3 31. How-to-save-macros-Lecture-before.xlsx 6.2 kB
  • 4. Keyboard shortcuts in Excel/1. Keyboard shortcuts save LOTS of time in Excel.srt 6.0 kB
  • 2. Introduction to Excel/7. Introduction to formatting.srt 6.0 kB
  • 13. Financial modeling fundamentals/6. Financial modeling - The types of models that are built in practice.srt 6.0 kB
  • 7. Financial functions in Excel/4. Date functions in Excel.srt 5.9 kB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/2. Build a column stacked chart with a secondary line axis in Excel.srt 5.8 kB
  • 5. Excel's key functions and functionalities made easy/9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.srt 5.8 kB
  • 5. Excel's key functions and functionalities made easy/17. A great Excel technique INDEX, MATCH, MATCH.srt 5.8 kB
  • 17. Tesla valuation - Complete practical exercise/25. Modeling Tesla's financing needs in the forecast period.srt 5.8 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/7. Use VLOOKUP to fill the database sheet.srt 5.7 kB
  • 19. Capital Budgeting - A complete Case study/12. Performing sensitivity analysis and completing the exercise.srt 5.7 kB
  • 19. Capital Budgeting - A complete Case study/4. Fixed asset rollforward.srt 5.7 kB
  • 23. APPENDIX - Microsoft Excel 2010 - Keyboard shortcuts/1. Keyboard shortcuts Save LOTS of time in Excel 2010.srt 5.7 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/31. Using charts to summarize the results of the DCF model.srt 5.6 kB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/3. Learn how to build effective doughnut charts in Excel.srt 5.6 kB
  • 17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.srt 5.5 kB
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/5. Download all course materials and frequently asked questions (FAQ).html 5.5 kB
  • 5. Excel's key functions and functionalities made easy/4. Key Excel functions SUM, SUMIF and SUMIFS.srt 5.4 kB
  • 17. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.srt 5.3 kB
  • 5. Excel's key functions and functionalities made easy/24. Include sensitivity analysis in your models through Data Tables.srt 5.1 kB
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.srt 5.1 kB
  • 12. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.srt 5.1 kB
  • 12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.srt 5.1 kB
  • 17. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.srt 5.1 kB
  • 5. Excel's key functions and functionalities made easy/6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.srt 4.9 kB
  • 8. Microsoft Excel's Pivot Tables in depth/4. Modifying and pivoting fields to obtain the Pivot Table you need.srt 4.9 kB
  • 8. Microsoft Excel's Pivot Tables in depth/6. An introduction to slicers - The modern-day Pivot Table filters.srt 4.9 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/7. Introduction to Excel functions.srt 4.8 kB
  • 12. Case Study - Building an FMCG Model from Scratch/13. This is how the report can be used in practice by high-level executives.srt 4.8 kB
  • 17. Tesla valuation - Complete practical exercise/22. Forecasting other assets.srt 4.7 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/29. Sensitivity analysis for WACC and perpetuity growth.srt 4.7 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/8. Modeling other items Other revenues and Cogs.srt 4.7 kB
  • 17. Tesla valuation - Complete practical exercise/27. Bridging Unlevered free cash flow to Net cash flow.srt 4.6 kB
  • 17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.srt 4.6 kB
  • 17. Tesla valuation - Complete practical exercise/32. Final comments.srt 4.5 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/9. Use SUMIF to complete the database sheet.srt 4.5 kB
  • 17. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.srt 4.5 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/24. Obtaining the rest of the cash flows through Find and Replace.srt 4.5 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/23. Calculating Net cash flow.srt 4.4 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/6. Introduction to Excel formulas.srt 4.4 kB
  • 19. Capital Budgeting - A complete Case study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.srt 4.4 kB
  • 10. Introduction to Excel charts/6. Sparklines.srt 4.4 kB
  • 8. Microsoft Excel's Pivot Tables in depth/2. Creating Pivot Tables easily!.srt 4.4 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/11. Use INDEX & MATCH as a substitute for VLOOKUP.srt 4.4 kB
  • 18. Capital budgeting - The theory/8. The type of cash flows we will have in a project.srt 4.3 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/1. Overview of Excel.srt 4.2 kB
  • 12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.srt 4.2 kB
  • 17. Tesla valuation - Complete practical exercise/30. Performing discounted cash flow valuation (DCF).srt 4.2 kB
  • 2. Introduction to Excel/2. Overview of Excel.srt 4.1 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/19. Completing the output BS sheet for the historical period.srt 4.1 kB
  • 8. Microsoft Excel's Pivot Tables in depth/5. Learn more about GETPIVOTDATA - A very important Excel function.srt 4.1 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/6. Modeling the top line.srt 4.1 kB
  • 19. Capital Budgeting - A complete Case study/8. Calculating project cash flows.srt 4.1 kB
  • 2. Introduction to Excel/11. Introduction to Excel functions.srt 4.1 kB
  • 18. Capital budgeting - The theory/6. Coming up with project-specific beta.srt 3.9 kB
  • 19. Capital Budgeting - A complete Case study/11. Discounting the project's cash flows and residual value.srt 3.8 kB
  • 17. Tesla valuation - Complete practical exercise/24. Completing Unlevered free cash flow.srt 3.8 kB
  • 7. Financial functions in Excel/2. Calculating the rate of return of an investment with the IRR function.srt 3.7 kB
  • 12. Case Study - Building an FMCG Model from Scratch/11. Combining Slicers and GETPIVOTDATA The key to our success.srt 3.7 kB
  • 12. Case Study - Building an FMCG Model from Scratch/12. Getting fancy with Excel slicers - Good-looking Excel slicers.srt 3.7 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/9. Macros are a great timesaver! Here's why!.srt 3.7 kB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/4. Learn how to build an area chart in Excel.srt 3.6 kB
  • 13. Financial modeling fundamentals/9. Financial modeling Forecasting guidelines.srt 3.6 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/4. Data entry in Excel.srt 3.6 kB
  • 19. Capital Budgeting - A complete Case study/9. Estimating the weighted average cost of capital (WACC).srt 3.6 kB
  • 10. Introduction to Excel charts/3. Excel chart formatting.srt 3.6 kB
  • 3. Useful tips and tools for your work in Excel/32. Find and replace - references.srt 3.5 kB
  • 19. Capital Budgeting - A complete Case study/6. Modeling debt financing.srt 3.5 kB
  • 2. Introduction to Excel/6. Data entry in Excel.srt 3.5 kB
  • 19. Capital Budgeting - A complete Case study/1. Introduction to the Capital budgeting exercise.srt 3.5 kB
  • 13. Financial modeling fundamentals/13. Modeling the Balance sheet - Part 1.srt 3.5 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/15. Formatting sets You apart from the competition in Excel - A Practical Example.srt 3.5 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/4. Description of the structure of the DCF model.srt 3.4 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/19. Calculating year-on-year percentage variations the proper way.srt 3.4 kB
  • 13. Financial modeling fundamentals/3. Why use financial models.srt 3.4 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/20. Creating a structure for the calculation of Unlevered free cash flows.srt 3.3 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/3. The Excel ribbon.srt 3.3 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/26. Discounting Unlevered free cash flows to obtain their Present value.srt 3.2 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/3. Understand your data source before you start working on it.srt 3.2 kB
  • 17. Tesla valuation - Complete practical exercise/10. Forecasting 'energy' and 'services' revenue.srt 3.2 kB
  • 3. Useful tips and tools for your work in Excel/23. Macros are a great timesaver! Here's why!.srt 3.2 kB
  • 17. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.srt 3.2 kB
  • 13. Financial modeling fundamentals/8. Financial modeling The right level of detail in a model.srt 3.2 kB
  • 5. Excel's key functions and functionalities made easy/11. Working with text in Excel.srt 3.2 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/10. Modeling other items Interest expenses, Extraordinary items and Taxes.srt 3.1 kB
  • 19. Capital Budgeting - A complete Case study/5. The impact of working capital.srt 3.1 kB
  • 3. Useful tips and tools for your work in Excel/23.1 Recording a Macro - Lecture - Solved.ods 3.1 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/16. Populate the P&L sheet with SUMIF.srt 3.1 kB
  • 12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.srt 3.1 kB
  • 5. Excel's key functions and functionalities made easy/3. Key functions in Excel IF.srt 3.0 kB
  • 13. Financial modeling fundamentals/11. Building a complete model - Important considerations.srt 3.0 kB
  • 10. Introduction to Excel charts/2. Editing Excel charts.srt 3.0 kB
  • 17. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.srt 2.9 kB
  • 5. Excel's key functions and functionalities made easy/20. RANK is a valuable tool when using Excel for financial and business analysis.srt 2.9 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/32. You made it!.srt 2.9 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.srt 2.9 kB
  • 5. Excel's key functions and functionalities made easy/21. Learn how to render your models flexible with CHOOSE.srt 2.9 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/18. Learn how to find mistakes with COUNTIF.srt 2.9 kB
  • 18. Capital budgeting - The theory/3. The time value of money.srt 2.8 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/9. Modeling other items Operating expenses and D&A.srt 2.8 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/12. Mapping the rows in the database sheet.srt 2.8 kB
  • 5. Excel's key functions and functionalities made easy/22. Use Goal Seek to find the result that you are looking for.srt 2.8 kB
  • 17. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.srt 2.8 kB
  • 18. Capital budgeting - The theory/2. Why we need Capital budgeting.srt 2.8 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/3. Introduction to fixing of cell references.srt 2.8 kB
  • 2. Introduction to Excel/4. The Excel ribbon.srt 2.7 kB
  • 10. Introduction to Excel charts/1. How to insert a chart in Excel.srt 2.7 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/7. Introducing scenarios to the model with Choose.srt 2.7 kB
  • 5. Excel's key functions and functionalities made easy/26. Excel's dynamic and interactive tables Pivot tables.srt 2.7 kB
  • 12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.srt 2.6 kB
  • 3. Useful tips and tools for your work in Excel/23.2 Recording a Macro - Lecture - Unsolved.ods 2.6 kB
  • 12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.srt 2.6 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/27. Calculating Continuing value and Enterprise value of the business.srt 2.6 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/14. Forecasting DSO, DPO and DOI.srt 2.6 kB
  • 3. Useful tips and tools for your work in Excel/36. Beauty saving - The professional way of saving files.srt 2.6 kB
  • 17. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.srt 2.6 kB
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The best way to take this course.srt 2.6 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/4. Order the source worksheets.srt 2.6 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/17. Populating the output P&L sheet.srt 2.6 kB
  • 3. Useful tips and tools for your work in Excel/6. Fixing cell references.srt 2.6 kB
  • 18. Capital budgeting - The theory/7. Weighted average cost of capital (WACC).srt 2.5 kB
  • 3. Useful tips and tools for your work in Excel/9. Organize your data with text to columns.srt 2.5 kB
  • 13. Financial modeling fundamentals/2. What is a financial model.srt 2.5 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/8. Cut, copy, & paste.srt 2.5 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/16. Creating an output P&L sheet.srt 2.4 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/25. Introducing Weighted average cost of capital and Perpetuity growth.srt 2.4 kB
  • 5. Excel's key functions and functionalities made easy/7. Key Excel functions AVERAGE and AVERAGEIF.srt 2.4 kB
  • 8. Microsoft Excel's Pivot Tables in depth/3. Give your Excel Pivot Tables a makeover.srt 2.4 kB
  • 17. Tesla valuation - Complete practical exercise/23. Forecasting other liabilities.srt 2.4 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/14. Building the structure of the P&L sheet.srt 2.4 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/13. Learn how to organize your data with Text to Columns.srt 2.4 kB
  • 3. Useful tips and tools for your work in Excel/2. Initial formatting of Excel sheets for a professional layout.srt 2.4 kB
  • 2. Introduction to Excel/12. Cut, copy, & paste.srt 2.4 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/1. Initial formatting of an Excel sheet to render it professional.srt 2.4 kB
  • 20. Next steps/1. Next steps.html 2.3 kB
  • 17. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.srt 2.3 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.srt 2.3 kB
  • 19. Capital Budgeting - A complete Case study/7. Adding a P&L sheet.srt 2.3 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/5. Create a drop-down list by using Data Validation.srt 2.3 kB
  • 12. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.srt 2.3 kB
  • 3. Useful tips and tools for your work in Excel/28. Filter by color - an excellent tool.srt 2.3 kB
  • 3. Useful tips and tools for your work in Excel/37. Formula auditing with F2.srt 2.2 kB
  • 5. Excel's key functions and functionalities made easy/19. Using Excel's IFERROR function to trap spreadsheet errors.srt 2.2 kB
  • 17. Tesla valuation - Complete practical exercise/20. Calculating investments in working capital.srt 2.2 kB
  • 3. Useful tips and tools for your work in Excel/5. Be even quicker F5 + Enter.srt 2.2 kB
  • 17. Tesla valuation - Complete practical exercise/31. Calculating enterprise value, equity value, and price per share.srt 2.2 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/6. Learn how to create a database.srt 2.2 kB
  • 17. Tesla valuation - Complete practical exercise/17. Calculating DSO, DIO, DPO.srt 2.2 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/2. Basic manipulations with rows and columns.srt 2.2 kB
  • 8. Microsoft Excel's Pivot Tables in depth/1. Introduction to Pivot Tables and the way they are applied.srt 2.1 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/21. Bridging Unlevered free cash flow to Net cash flow.srt 2.1 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/30. A possible application of Goal seek.srt 2.0 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/11. Assign custom formats to specific cells within a financial model (e.g Multiples).srt 2.0 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/10. Find and select special types of cells with Select Special (F5).srt 2.0 kB
  • 3. Useful tips and tools for your work in Excel/14. Create drop-down lists with data validation.srt 2.0 kB
  • 3. Useful tips and tools for your work in Excel/34. Find and replace - formatting.srt 2.0 kB
  • 3. Useful tips and tools for your work in Excel/3. Fast scrolling through Excel sheets.srt 1.9 kB
  • 2. Introduction to Excel/5. Basic operations with rows and columns.srt 1.9 kB
  • 10. Introduction to Excel charts/4. How to create a bridge chart in Excel.srt 1.9 kB
  • 18. Capital budgeting - The theory/1. Introduction to Capital budgeting.srt 1.9 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/12. An introduction to the Days methodology.srt 1.9 kB
  • 17. Tesla valuation - Complete practical exercise/19. Fill in the P&L output sheet.srt 1.9 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/2. Fast scrolling through Excel sheets.srt 1.9 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/18. Populating the output BS sheet.srt 1.8 kB
  • 3. Useful tips and tools for your work in Excel/19. Define a named range in Excel.srt 1.8 kB
  • 3. Useful tips and tools for your work in Excel/31. A neat trick - Multiply by 1.srt 1.8 kB
  • 10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.srt 1.8 kB
  • 17. Tesla valuation - Complete practical exercise/2. The input data we will work with.srt 1.8 kB
  • 3. Useful tips and tools for your work in Excel/15. Find and select special types of cells with Select special (F5).srt 1.8 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/28. Calculating Equity value.srt 1.7 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/12. Define a named range in Excel.srt 1.7 kB
  • 3. Useful tips and tools for your work in Excel/35. Removing (automatic) green arrows.srt 1.7 kB
  • 3. Useful tips and tools for your work in Excel/24. How to save macros and use them across several workbooks.srt 1.7 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/6. Using Custom-sort in order to sort multiple columns within a table.srt 1.7 kB
  • 3. Useful tips and tools for your work in Excel/13. Custom sort helps you sort multiple columns in Excel tables.srt 1.7 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/14. Learn how to assign dynamic names within a financial model.srt 1.7 kB
  • 17. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.srt 1.7 kB
  • 17. Tesla valuation - Complete practical exercise/18. Producing a clean P&L output sheet.srt 1.7 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/7. Create a great Index page at the beginning of your models - Hyperlinks.srt 1.6 kB
  • 3. Useful tips and tools for your work in Excel/22. Apply custom formatting in a financial model.srt 1.6 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/15. Create easily printable documents in Excel by using Set Print Area.srt 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.srt 1.6 kB
  • 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/9. Paste special.srt 1.6 kB
  • 19. Capital Budgeting - A complete Case study/15. Congratulations!!.srt 1.6 kB
  • 3. Useful tips and tools for your work in Excel/17. Assign dynamic names in a financial model.srt 1.6 kB
  • 3. Useful tips and tools for your work in Excel/12. Set print area.srt 1.5 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/8. Fix the top row of your table with Freeze Panes.srt 1.5 kB
  • 12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.srt 1.5 kB
  • 3. Useful tips and tools for your work in Excel/20. Create a great Index page at the beginning of your models - Hyperlinks.srt 1.5 kB
  • 2. Introduction to Excel/14. Paste special.srt 1.5 kB
  • 5. Excel's key functions and functionalities made easy/2. A helpful consideration.html 1.5 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/5. A glimpse at the company we are valuing - Cheeseco.srt 1.4 kB
  • 5. Excel's key functions and functionalities made easy/15. How to enlarge the formula bar.srt 1.4 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/13. Calculation of DSO, DPO and DOI for the historical period.srt 1.4 kB
  • 17. Tesla valuation - Complete practical exercise/26. Calculating Net income.srt 1.4 kB
  • 3. Useful tips and tools for your work in Excel/26. Fix the top row of your table with freeze panes.srt 1.4 kB
  • 16. Learn how to build a Discounted Cash Flow model in Excel/2. Introduction to the DCF exercise.srt 1.3 kB
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/8. Course Challenge - Apply your skills in practice!.srt 1.3 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/10. FAQ Sum of FY2018 doens't go down to zero.html 1.3 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/20. FAQ Why do we subtract -1 when calculating year-on-year growth.html 1.3 kB
  • 5. Excel's key functions and functionalities made easy/13. Include ROUND in your financial models.srt 1.2 kB
  • 17. Tesla valuation - Complete practical exercise/28. Balancing the Balance sheet.srt 1.2 kB
  • 5. Excel's key functions and functionalities made easy/12. Find the minimum or maximum value in a range of cells in Excel.srt 1.2 kB
  • 5. Excel's key functions and functionalities made easy/1. Excel's key functions - Welcome lecture.srt 1.1 kB
  • 9. Case study - Building a complete P&L from scratch in Excel/2. Introduction to the case study.srt 1.1 kB
  • 13. Financial modeling fundamentals/1. Financial modeling basics - Welcome lecture.srt 1.1 kB
  • 3. Useful tips and tools for your work in Excel/1. Excel best practices - Welcome lecture.srt 1.1 kB
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/16. Using the 'Alt + Enter' combination.srt 1.1 kB
  • 5. Excel's key functions and functionalities made easy/5. = and + are interchangeable when you start typing a formula.srt 974 Bytes
  • 3. Useful tips and tools for your work in Excel/8. Alt + Enter.srt 961 Bytes
  • 2. Introduction to Excel/1. Introduction to Excel.srt 925 Bytes
  • 3. Useful tips and tools for your work in Excel/11. The wrap text button.srt 914 Bytes
  • 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/4. Learn how to use the Wrap Text button.srt 903 Bytes
  • 16. Learn how to build a Discounted Cash Flow model in Excel/1. Valuation Case study - Welcome lecture.srt 883 Bytes
  • 16. Learn how to build a Discounted Cash Flow model in Excel/11. Forecasting Balance sheet items.srt 870 Bytes
  • 3. Useful tips and tools for your work in Excel/27. How to search functionalities in Excel.srt 853 Bytes
  • 17. Tesla valuation - Complete practical exercise/16. FAQ Why model D&A as a % of revenues or as a % of beginning PP&E.html 818 Bytes
  • 3. Useful tips and tools for your work in Excel/33. FAQ Why do we replace external references and how does this help us.html 702 Bytes
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/1. Create professional and good-looking charts - Introduction.srt 662 Bytes
  • 12. Case Study - Building an FMCG Model from Scratch/10. FAQ My GETPIVOTDATA function doesn't work.html 651 Bytes
  • 9. Case study - Building a complete P&L from scratch in Excel/17. FAQ Why the sum of the check should be 0.html 542 Bytes
  • 19. Capital Budgeting - A complete Case study/13. FAQ Data does not change in the DCF sheet, it changes from the Drivers sheet.html 378 Bytes
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/2. Bonus! Welcome gift.html 171 Bytes
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/3. Welcome gift number 2.html 171 Bytes
  • 14. Introduction to Company Valuation/1. The core theory behind Company Valuation.html 171 Bytes
  • 15. Introduction to Mergers & Acquisitions/1. Introduction to Mergers & Acquisitions.html 171 Bytes
  • 2. Introduction to Excel/16. Basic operations in Excel - 38 pages.html 171 Bytes
  • 4. Keyboard shortcuts in Excel/2. Keyboard shortcuts in Excel.html 171 Bytes
  • 6. Update! SUMIFS - Exercise/1. Exercise - Excel's SUMIFS function - unsolved.html 171 Bytes
  • 12. Case Study - Building an FMCG Model from Scratch/14. Dynamic reporting with GETPIVOTDATA and slicers.html 170 Bytes
  • 19. Capital Budgeting - A complete Case study/14. Build a complete capital budgeting model from scratch.html 170 Bytes
  • 13. Financial modeling fundamentals/10. Forecasting financials - Quiz.html 167 Bytes
  • 13. Financial modeling fundamentals/15. Building a financial model - Quiz.html 167 Bytes
  • 13. Financial modeling fundamentals/7. Financial modeling - Quiz.html 167 Bytes
  • 2. Introduction to Excel/10. Introduction to Excel formulas.html 167 Bytes
  • 2. Introduction to Excel/13. Cut, copy, & paste.html 167 Bytes
  • 2. Introduction to Excel/3. Overview of Excel.html 167 Bytes
  • 2. Introduction to Excel/8. Rows and columns.html 167 Bytes
  • 3. Useful tips and tools for your work in Excel/10. Learn how to organize your data with text to columns.html 167 Bytes
  • 3. Useful tips and tools for your work in Excel/16. Select Special.html 167 Bytes
  • 3. Useful tips and tools for your work in Excel/18. Assigning dynamic names.html 167 Bytes
  • 3. Useful tips and tools for your work in Excel/25. Excel macros - quiz.html 167 Bytes
  • 3. Useful tips and tools for your work in Excel/4. Fast scrolling through Excel sheets.html 167 Bytes
  • 3. Useful tips and tools for your work in Excel/7. Introduction to fixing of cell references.html 167 Bytes
  • 5. Excel's key functions and functionalities made easy/10. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.html 167 Bytes
  • 5. Excel's key functions and functionalities made easy/18. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.html 167 Bytes
  • 5. Excel's key functions and functionalities made easy/23. Use Goal Seek in order to find the result that you are looking for.html 167 Bytes
  • 5. Excel's key functions and functionalities made easy/25. Include sensitivity analysis in your models through Data Tables.html 167 Bytes
  • 5. Excel's key functions and functionalities made easy/8. Key Excel functions AVERAGE and AVERAGEIF.html 167 Bytes
  • 11. P&L Case Study continued - Let's create some great-looking professional charts/7. Case Study - Building a Complete P&L from scratch in Excel.html 166 Bytes
  • 3. Useful tips and tools for your work in Excel/30. Useful tips and tools for your work in Excel - quiz.html 166 Bytes
  • 5. Excel's key functions and functionalities made easy/27. Excel's key functions and functionalities made easy.html 166 Bytes
  • 0. Websites you may like/[DesireCourse.Net].url 51 Bytes
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/[DesireCourse.Net].url 51 Bytes
  • 15. Introduction to Mergers & Acquisitions/[DesireCourse.Net].url 51 Bytes
  • 20. Next steps/[DesireCourse.Net].url 51 Bytes
  • 5. Excel's key functions and functionalities made easy/[DesireCourse.Net].url 51 Bytes
  • 9. Case study - Building a complete P&L from scratch in Excel/[DesireCourse.Net].url 51 Bytes
  • [DesireCourse.Net].url 51 Bytes
  • 0. Websites you may like/[CourseClub.Me].url 48 Bytes
  • 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/[CourseClub.Me].url 48 Bytes
  • 15. Introduction to Mergers & Acquisitions/[CourseClub.Me].url 48 Bytes
  • 20. Next steps/[CourseClub.Me].url 48 Bytes
  • 5. Excel's key functions and functionalities made easy/[CourseClub.Me].url 48 Bytes
  • 9. Case study - Building a complete P&L from scratch in Excel/[CourseClub.Me].url 48 Bytes
  • [CourseClub.Me].url 48 Bytes
  • 9. Case study - Building a complete P&L from scratch in Excel/8. 50% completed!.srt 41 Bytes

随机展示

相关说明

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