[FreeAllCourse.Com] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation

File Information:
  1. Magnet Link:Magnet LinkMagnet Link
  2. File Size:6.18 GB
  3. Creat Time:2024-08-24
  4. Active Degree:18
  5. Last Active:2024-11-17
  6. File Tags:FreeAllCourse  Com  Udemy  Beginner  to  Pro  in  Excel  Financial  Modeling  and  Valuation  
  7. Statement:This site does not provide download links, only text displays, and does not contain any infringement.
File List:

    [FreeAllCourse.Com] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation

  1. 2. Introduction to Excel/9.5 12. Formulas- Lecture_after.xlsx 284.13 MB
  2. 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 139.38 MB
  3. 17. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.mp4 117.67 MB
  4. 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/5. Introduction to formatting.mp4 77.20 MB
  5. 9. Case study - Building a complete P&L from scratch in Excel/7. Use VLOOKUP to fill the database sheet.mp4 63.06 MB
  6. 16. Learn how to build a Discounted Cash Flow model in Excel/22. Calculating Unlevered free cash flow.mp4 61.17 MB
  7. 17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp4 57.93 MB
  8. 17. Tesla valuation - Complete practical exercise/21. Forecasting Unlevered free cash flow.mp4 57.28 MB
  9. 17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp4 55.51 MB
  10. 11. P&L Case Study continued - Let's create some great-looking professional charts/5. Learn how to create bridge charts.mp4 53.32 MB
  11. 4. Keyboard shortcuts in Excel/1. Keyboard shortcuts save LOTS of time in Excel.mp4 52.40 MB
  12. 17. Tesla valuation - Complete practical exercise/27. Bridging Unlevered free cash flow to Net cash flow.mp4 51.95 MB
  13. 12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4 51.18 MB
  14. 9. Case study - Building a complete P&L from scratch in Excel/11. Use INDEX & MATCH as a substitute for VLOOKUP.mp4 50.78 MB
  15. 16. Learn how to build a Discounted Cash Flow model in Excel/3. The stages of a complete DCF Valuation.mp4 50.43 MB
  16. 9. Case study - Building a complete P&L from scratch in Excel/9. Use SUMIF to complete the database sheet.mp4 49.10 MB
  17. 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 47.86 MB
  18. 17. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.mp4 47.68 MB
  19. 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 47.49 MB
  20. 17. Tesla valuation - Complete practical exercise/22. Forecasting other assets.mp4 46.33 MB
  21. 17. Tesla valuation - Complete practical exercise/32. Final comments.mp4 45.96 MB
  22. 16. Learn how to build a Discounted Cash Flow model in Excel/8. Modeling other items Other revenues and Cogs.mp4 45.62 MB
  23. 17. Tesla valuation - Complete practical exercise/29. Estimating Weighted average cost of capital (WACC).mp4 45.33 MB
  24. 19. Capital Budgeting - A complete Case study/12. Performing sensitivity analysis and completing the exercise.mp4 44.08 MB
  25. 17. Tesla valuation - Complete practical exercise/25. Modeling Tesla's financing needs in the forecast period.mp4 43.38 MB
  26. 17. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.mp4 42.92 MB
  27. 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/1. Overview of Excel.mp4 42.16 MB
  28. 17. Tesla valuation - Complete practical exercise/24. Completing Unlevered free cash flow.mp4 41.87 MB
  29. 16. Learn how to build a Discounted Cash Flow model in Excel/29. Sensitivity analysis for WACC and perpetuity growth.mp4 41.46 MB
  30. 5. Excel's key functions and functionalities made easy/16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4 39.89 MB
  31. 9. Case study - Building a complete P&L from scratch in Excel/13. In case you have any doubts about the Mapping exercise.mp4 39.49 MB
  32. 2. Introduction to Excel/7. Introduction to formatting.mp4 39.14 MB
  33. 16. Learn how to build a Discounted Cash Flow model in Excel/19. Completing the output BS sheet for the historical period.mp4 38.95 MB
  34. 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 38.91 MB
  35. 3. Useful tips and tools for your work in Excel/21. Introduction to custom formatting in Excel.mp4 38.87 MB
  36. 16. Learn how to build a Discounted Cash Flow model in Excel/23. Calculating Net cash flow.mp4 38.82 MB
  37. 12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp4 38.02 MB
  38. 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/7. Introduction to Excel functions.mp4 38.02 MB
  39. 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.02 MB
  40. 6. Update! SUMIFS - Exercise/2. Exercise - Excel's SUMIFS function - solved & explained.mp4 36.17 MB
  41. 17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp4 35.75 MB
  42. 17. Tesla valuation - Complete practical exercise/30. Performing discounted cash flow valuation (DCF).mp4 35.74 MB
  43. 5. Excel's key functions and functionalities made easy/14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4 35.43 MB
  44. 12. Case Study - Building an FMCG Model from Scratch/11. Combining Slicers and GETPIVOTDATA The key to our success.mp4 34.42 MB
  45. 16. Learn how to build a Discounted Cash Flow model in Excel/31. Using charts to summarize the results of the DCF model.mp4 33.68 MB
  46. 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp4 33.56 MB
  47. 10. Introduction to Excel charts/3. Excel chart formatting.mp4 33.54 MB
  48. 9. Case study - Building a complete P&L from scratch in Excel/12. Mapping the rows in the database sheet.mp4 33.25 MB
  49. 12. Case Study - Building an FMCG Model from Scratch/12. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 33.20 MB
  50. 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/4. Data entry in Excel.mp4 32.26 MB