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

File Type Create Time File Size Seeders Leechers Updated
Movie 2023-03-20 3.99GB 0 1 1 week ago
Download
Magnet link   or   Save Instantly without Torrenting   or   Torrent download

To download this file, you need a free bitTorrent client such as qBittorrent.

Report Abuse
Tags
Tutorialsplanet  NET  Udemy  Beginner  Pro  Excel  Financial  Modeling  and  Valuation  
Related Torrents
  1. [FreeTutorials.Us] beginner-to-pro-in-excel-financial-modeling-and-valuation 2.36GB
  2. [Tutorialsplanet.NET] Udemy - Financial Engineering and Artificial Intelligence in Python 6.15GB
  3. [Tutorialsplanet.NET] Udemy - PyTorch Deep Learning and Artificial Intelligence 1.35GB
  4. [Tutorialsplanet.NET] Udemy - Deep Learning with TensorFlow 2.0 [2020] 194.00MB
  5. [Tutorialsplanet.NET] Udemy - Machine Learning with Python COMPLETE COURSE FOR BEGINNERS 8.05GB
  6. [Tutorialsplanet.NET] Udemy - Machine Learning - A-Z™ Full Course 3.55GB
  7. [Tutorialsplanet.NET] Udemy - Google Bard Generative Ai Masterclass Certification Course 421.98MB
  8. [Tutorialsplanet.NET] Udemy - Simulate, understand, & visualize data like a data scientist 340.13MB
  9. [Tutorialsplanet.NET] Udemy - Algorithmic Trading A-Z with Python, Machine Learning & AWS 2.97MB
  10. [Tutorialsplanet.NET] Udemy - REST API Design, Development & Management 739.19MB
Files
  1. 10. Introduction to Excel charts/3. Excel chart formatting.vtt 0B
  2. 11/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4 128.34MB
  3. 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1.1 Course Notes - Beginner to Pro in Excel.pdf.pdf 3.05MB
  4. 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The best way to take this course.mp4 16.02MB
  5. 10. Introduction to Excel charts/1. How to insert a chart in Excel.mp4 19.86MB
  6. 10. Introduction to Excel charts/1.1 95. Inserting-Charts-Lecture.xlsm.xlsm 11.45MB
  7. 10. Introduction to Excel charts/2. Editing Excel charts.mp4 26.05MB
  8. 10. Introduction to Excel charts/2. Editing Excel charts.vtt 2.90KB
  9. 10. Introduction to Excel charts/2.1 96. Formatting-a-Chart-Lecture.xlsm.xlsm 11.45MB
  10. 10. Introduction to Excel charts/3. Excel chart formatting.mp4 28.63MB
  11. 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp4 8.94MB
  12. 10. Introduction to Excel charts/4. How to create a bridge chart in Excel.mp4 12.48MB
  13. 10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.mp4 11.49MB
  14. 10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.vtt 1.67KB
  15. 10. Introduction to Excel charts/5.1 99. Treemap-Charts-Lecture.xlsx.xlsx 12.62KB
  16. 10. Introduction to Excel charts/6. Sparklines.mp4 27.56MB
  17. 10. Introduction to Excel charts/6. Sparklines.vtt 4.17KB
  18. 10. Introduction to Excel charts/6.1 100. Sparklines-Lecture.xlsx.xlsx 9.59KB
  19. 11/1. Create professional and good-looking charts - Introduction.mp4 6.21MB
  20. 11/1. Create professional and good-looking charts - Introduction.vtt 727B
  21. 11/2. Build a column stacked chart with a secondary line axis in Excel.mp4 46.37MB
  22. 11/2. Build a column stacked chart with a secondary line axis in Excel.vtt 5.63KB
  23. 11/2.1 102. Column stacked chart-Lecture-before.xlsm.xlsm 11.50MB
  24. 11/2.2 102. Column stacked chart-Lecture-after.xlsm.xlsm 7.65MB
  25. 11/3. Learn how to build effective doughnut charts in Excel.mp4 32.14MB
  26. 11/3.1 103. Doughnut chart-Lecture-after.xlsm.xlsm 10.13MB
  27. 11/3.2 103. Doughnut chart-Lecture-before.xlsm.xlsm 10.62MB
  28. 11/4. Learn how to build an area chart in Excel.mp4 28.58MB
  29. 11/4. Learn how to build an area chart in Excel.vtt 3.48KB
  30. 11/4.1 104. Area chart-Lecture-after.xlsm.xlsm 10.52MB
  31. 11/5. Learn how to create bridge charts.mp4 52.07MB
  32. 11/5. Learn how to create bridge charts.vtt 7.45KB
  33. 11/5.1 105. Bridge chart-Lecture-after.xlsm.xlsm 11.54MB
  34. 11/5.2 105. Bridge chart-Lecture-before.xlsm.xlsm 7.87MB
  35. 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.vtt 3.11KB
  36. 11/8. Course Challenge - Apply your skills in practice!.mp4 7.92MB
  37. 11/8. Course Challenge - Apply your skills in practice!.vtt 1.17KB
  38. 11/8.1 107. Course-Challenge - Solved.xlsx.xlsx 543.93KB
  39. 11/8.2 107. Course-Challenge - Unsolved.xlsx.xlsx 505.49KB
  40. 12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.mp4 12.06MB
  41. 12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.vtt 2.45KB
  42. 12. Case Study - Building an FMCG Model from Scratch/1.1 108. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx.xlsx 11.20MB
  43. 12. Case Study - Building an FMCG Model from Scratch/10. Combining Slicers and GETPIVOTDATA The key to our success.mp4 17.84MB
  44. 12. Case Study - Building an FMCG Model from Scratch/10. Combining Slicers and GETPIVOTDATA The key to our success.vtt 3.40KB
  45. 12. Case Study - Building an FMCG Model from Scratch/10.1 117. Exercise-Build-an-FMCG-Model-Inserting-Slicers-Lecture.xlsx.xlsx 16.10MB
  46. 12. Case Study - Building an FMCG Model from Scratch/11.1 118. Exercise-Build-an-FMCG-Model-Complete-Lecture.xlsx.xlsx 22.81MB
  47. 12. Case Study - Building an FMCG Model from Scratch/12. This is how the report can be used in practice by high-level executives.mp4 19.81MB
  48. 12. Case Study - Building an FMCG Model from Scratch/12. This is how the report can be used in practice by high-level executives.vtt 4.38KB
  49. 12. Case Study - Building an FMCG Model from Scratch/12.1 119. Exercise-Build-an-FMCG-Model-Complete.xlsx.xlsx 19.57MB
  50. 12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.mp4 22.60MB
  51. 12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.vtt 2.43KB
  52. 12. Case Study - Building an FMCG Model from Scratch/2.1 109. Exercise-Build-an-FMCG-Model-Mapping-Lecture.xlsx.xlsx 14.16MB
  53. 12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp4 21.95MB
  54. 12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.vtt 3.84KB
  55. 12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.mp4 11.65MB
  56. 12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.vtt 2.80KB
  57. 12. Case Study - Building an FMCG Model from Scratch/4.1 111. Exercise-Build-an-FMCG-Model-Structure-Lecture.xlsx.xlsx 14.91MB
  58. 12. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.mp4 6.75MB
  59. 12. Case Study - Building an FMCG Model from Scratch/5.1 112. Exercise-Build-an-FMCG-Model-Formatting-Lecture.xlsx.xlsx 9.24MB
  60. 12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.mp4 8.84MB
  61. 12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.vtt 4.63KB
  62. 12. Case Study - Building an FMCG Model from Scratch/6.1 113. Exercise-Build-an-FMCG-Model-Adding-Calculations-Lecture.xlsx.xlsx 5.49MB
  63. 12. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.mp4 13.83MB
  64. 12. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.vtt 2.10KB
  65. 12. Case Study - Building an FMCG Model from Scratch/7.1 114. Exercise-Build-an-FMCG-Model-Creating-a-Pivot-Table-Lecture.xlsx.xlsx 20.81MB
  66. 12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4 31.04MB
  67. 12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.vtt 6.68KB
  68. 12. Case Study - Building an FMCG Model from Scratch/8.1 115. Exercise-Build-an-FMCG-Model-GETPIVOTDATA-Lecture.xlsx.xlsx 16.89MB
  69. 12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4 13.76MB
  70. 12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.vtt 1.48KB
  71. 13. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.mp4 2.10MB
  72. 13. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.vtt 1.07KB
  73. 13. Financial Modeling Fundamentals/10. Forecasting financials - Quiz.html 160B
  74. 13. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.mp4 6.44MB
  75. 13. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.vtt 2.72KB
  76. 13. Financial Modeling Fundamentals/12. Modeling the Income statement.mp4 1.79MB
  77. 13. Financial Modeling Fundamentals/3. Why use financial models.mp4 7.69MB
  78. 13. Financial Modeling Fundamentals/3. Why use financial models.vtt 3.11KB
  79. 13. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.mp4 19.91MB
  80. 13. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.vtt 6.86KB
  81. 13. Financial Modeling Fundamentals/5. Financial modeling - best practices.mp4 17.22MB
  82. 13. Financial Modeling Fundamentals/5. Financial modeling - best practices.vtt 5.69KB
  83. 13. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.mp4 12.51MB
  84. 13. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.vtt 5.49KB
  85. 13. Financial Modeling Fundamentals/7. Financial modeling - Quiz.html 160B
  86. 13. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.mp4 5.68MB
  87. 13. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.vtt 2.93KB
  88. 13. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.mp4 6.44MB
  89. 13. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.vtt 3.34KB
  90. 14. Introduction to Company Valuation/1. The core theory behind Company Valuation.html 164B
  91. 15. Introduction to Mergers & Acquisitions/1. Introduction to Mergers & Acquisitions.html 164B
  92. 16/1. Valuation Case study - Welcome lecture.mp4 1.78MB
  93. 16/1. Valuation Case study - Welcome lecture.vtt 869B
  94. 16/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4 30.01MB
  95. 16/10. Modeling other items Interest expenses, Extraordinary items and Taxes.vtt 2.92KB
  96. 16/10.1 9. Interest expenses, taxes_before.xlsm.xlsm 50.57KB
  97. 16/10.2 9. Interest expenses, taxes_after.xlsm.xlsm 50.89KB
  98. 16/11. Forecasting Balance sheet items.mp4 4.66MB
  99. 16/11. Forecasting Balance sheet items.vtt 914B
  100. 16/11.1 10. Introduction to Balance sheet items.xlsm.xlsm 51.02KB
  101. 16/12. An introduction to the Days methodology.mp4 73.78KB
  102. 16/14. Forecasting DSO, DPO and DOI.mp4 20.86MB
  103. 16/14. Forecasting DSO, DPO and DOI.vtt 2.73KB
  104. 16/14.1 13. Forecasting DSO, DPO, DIO_before.xlsm.xlsm 51.47KB
  105. 16/14.2 13. Forecasting DSO, DPO, DIO_after.xlsm.xlsm 51.98KB
  106. 16/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4 22.63MB
  107. 16/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.vtt 2.60KB
  108. 16/15.1 14. Forecasting PP&E, Other assets, and Other liabilities_after.xlsm.xlsm 52.88KB
  109. 16/15.2 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm.xlsm 51.98KB
  110. 16/16. Creating an output P&L sheet.mp4 18.80MB
  111. 16/16. Creating an output P&L sheet.vtt 2.32KB
  112. 16/16.1 15. P&L structure_after.xlsm.xlsm 53.67KB
  113. 16/16.2 15. P&L structure_before.xlsm.xlsm 53.60KB
  114. 16/17. Populating the output P&L sheet.mp4 25.53MB
  115. 16/17. Populating the output P&L sheet.vtt 2.44KB
  116. 16/17.1 16. Populating the P&L sheet_after.xlsm.xlsm 55.32KB
  117. 16/17.2 16. Populating the P&L sheet_before.xlsm.xlsm 53.67KB
  118. 16/18. Populating the output BS sheet.mp4 16.93MB
  119. 16/18. Populating the output BS sheet.vtt 1.75KB
  120. 16/18.1 17. Populating BS sheet_before.xlsm.xlsm 55.32KB
  121. 16/18.2 17. Populating BS sheet_after.xlsm.xlsm 57.18KB
  122. 16/19. Completing the output BS sheet for the historical period.mp4 36.40MB
  123. 16/20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp4 22.38MB
  124. 16/21. Bridging Unlevered free cash flow to Net cash flow.mp4 14.58MB
  125. 16/21. Bridging Unlevered free cash flow to Net cash flow.vtt 2.11KB
  126. 16/21.1 20. Bridge UFCF to Net cash flow_before.xlsm.xlsm 58.58KB
  127. 16/21.2 20. Bridge UFCF to Net cash flow_after.xlsm.xlsm 58.70KB
  128. 16/22. Calculating Unlevered free cash flow.mp4 59.72MB
  129. 16/22. Calculating Unlevered free cash flow.vtt 6.63KB
  130. 16/22.1 21. Calculating UFCF_after.xlsm.xlsm 59.18KB
  131. 16/22.2 21. Calculating UFCF_before.xlsm.xlsm 58.66KB
  132. 16/23. Calculating Net cash flow.mp4 35.62MB
  133. 16/24. Obtaining the rest of the cash flows through Find and Replace.mp4 46.73MB
  134. 16/24. Obtaining the rest of the cash flows through Find and Replace.vtt 4.18KB
  135. 16/24.1 23. Find and replace_after.xlsm.xlsm 62.50KB
  136. 16/24.2 23. Find and replace_before.xlsm.xlsm 59.55KB
  137. 16/25. Introducing Weighted average cost of capital and Perpetuity growth.mp4 4.03MB
  138. 16/26. Discounting Unlevered free cash flows to obtain their Present value.mp4 20.22MB
  139. 16/26. Discounting Unlevered free cash flows to obtain their Present value.vtt 2.99KB
  140. 16/26.1 25. Calculating PV of Cash Flows_after.xlsm.xlsm 62.71KB
  141. 16/26.2 25. Calculating PV of Cash Flows_before.xlsm.xlsm 62.58KB
  142. 16/27. Calculating Continuing value and Enterprise value of the business.mp4 17.72MB
  143. 16/27. Calculating Continuing value and Enterprise value of the business.vtt 2.33KB
  144. 16/27.1 26. Calculating CV and EV_after.xlsm.xlsm 63.10KB
  145. 16/27.2 26. Calculating CV and EV_before.xlsm.xlsm 62.71KB
  146. 16/28. Calculating Equity value.mp4 522.65KB
  147. 16/29. Sensitivity analysis for WACC and perpetuity growth.mp4 40.48MB
  148. 16/29. Sensitivity analysis for WACC and perpetuity growth.vtt 4.56KB
  149. 16/29.1 28. Sensitivity analysis_before.xlsm.xlsm 63.27KB
  150. 16/29.2 28. Sensitivity analysis_after.xlsm.xlsm 64.83KB
  151. 16/29.3 Sensitivity Analysis.xlsx 60.81KB
  152. 16/3. The stages of a complete DCF Valuation.mp4 49.24MB
  153. 16/3. The stages of a complete DCF Valuation.vtt 6.61KB
  154. 16/3.1 Valuation exercise.pdf.pdf 411.76KB
  155. 16/30. A possible application of Goal seek.mp4 15.62MB
  156. 16/30. A possible application of Goal seek.vtt 1.94KB
  157. 16/30.1 29. Goal seek_before.xlsm.xlsm 64.83KB
  158. 16/30.2 29. Goal seek_ater.xlsm.xlsm 64.84KB
  159. 16/31. Using charts to summarize the results of the DCF model.mp4 32.88MB
  160. 16/31.1 30. Charts.xlsm.xlsm 101.22KB
  161. 16/32. You made it!.mp4 11.27MB
  162. 16/32. You made it!.vtt 2.90KB
  163. 16/4. Description of the structure of the DCF model.mp4 13.88MB
  164. 16/5. A glimpse at the company we are valuing - Cheeseco.mp4 15.67MB
  165. 16/5. A glimpse at the company we are valuing - Cheeseco.vtt 1.35KB
  166. 16/5.1 Cheeseco.pptx.pptx 80.09KB
  167. 16/6. Modeling the top line.mp4 11.32MB
  168. 16/8. Modeling other items Other revenues and Cogs.mp4 42.99MB
  169. 16/9.1 8. Opex and D&A_before.xlsm.xlsm 50.08KB
  170. 16/9.2 8. Opex and D&A_after.xlsm.xlsm 50.57KB
  171. 17. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.mp4 3.90MB
  172. 17. Tesla valuation - Complete practical exercise/1.1 Tesla 2017.pdf.pdf 2.51MB
  173. 17. Tesla valuation - Complete practical exercise/1.2 Tesla 2016.pdf.pdf 2.21MB
  174. 17. Tesla valuation - Complete practical exercise/1.3 0a. Drivers_before.xlsx.xlsx 1.27MB
  175. 17. Tesla valuation - Complete practical exercise/1.4 Tesla 2018 Q2.pdf.pdf 635.07KB
  176. 17. Tesla valuation - Complete practical exercise/1.5 Tesla Company Valuation - Detailed walkthrough.pdf.pdf 2.27MB
  177. 17. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4 14.64MB
  178. 17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp4 33.13MB
  179. 17. Tesla valuation - Complete practical exercise/12.2 8. Opex - After.xlsx.xlsx 1.36MB
  180. 17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp4 47.50MB
  181. 17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp4 54.20MB
  182. 17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.vtt 4.13KB
  183. 17. Tesla valuation - Complete practical exercise/14.1 10. PP&E schedule_after.xlsx.xlsx 1.37MB
  184. 17. Tesla valuation - Complete practical exercise/14.2 10. PP&E schedule_before.xlsx.xlsx 1.37MB
  185. 17. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.mp4 13.61MB
  186. 17. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.vtt 1.62KB
  187. 17. Tesla valuation - Complete practical exercise/15.1 10a. PP&E comparison.xlsx.xlsx 1.37MB
  188. 17. Tesla valuation - Complete practical exercise/16. Calculating DSO, DIO, DPO.mp4 16.24MB
  189. 17. Tesla valuation - Complete practical exercise/18. Fill in the P&L output sheet.mp4 17.99MB
  190. 17. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.mp4 19.03MB
  191. 17. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.vtt 2.09KB
  192. 17. Tesla valuation - Complete practical exercise/19.1 13. Calculating working capital_after.xlsx.xlsx 1.40MB
  193. 17. Tesla valuation - Complete practical exercise/19.2 13. Calculating working capital_before.xlsx.xlsx 1.40MB
  194. 17. Tesla valuation - Complete practical exercise/2. The input data we will work with.mp4 15.05MB
  195. 17. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered free cash flow.mp4 55.93MB
  196. 17. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered free cash flow.vtt 5.79KB
  197. 17. Tesla valuation - Complete practical exercise/20.1 14. Cash flow - UFCF_after.xlsx.xlsx 1.41MB
  198. 17. Tesla valuation - Complete practical exercise/20.2 14. Cash flow - UFCF_before.xlsx.xlsx 1.41MB
  199. 17. Tesla valuation - Complete practical exercise/21. Forecasting other assets.mp4 45.24MB
  200. 17. Tesla valuation - Complete practical exercise/21. Forecasting other assets.vtt 4.33KB
  201. 17. Tesla valuation - Complete practical exercise/21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx 1.41MB
  202. 17. Tesla valuation - Complete practical exercise/21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx 1.41MB
  203. 17. Tesla valuation - Complete practical exercise/22. Forecasting other liabilities.mp4 21.84MB
  204. 17. Tesla valuation - Complete practical exercise/23. Completing Unlevered free cash flow.mp4 33.05MB
  205. 17. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.mp4 42.35MB
  206. 17. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.vtt 5.04KB
  207. 17. Tesla valuation - Complete practical exercise/24.1 17. Financing_before.xlsx.xlsx 1.43MB
  208. 17. Tesla valuation - Complete practical exercise/24.2 17. Financing_after.xlsx.xlsx 1.43MB
  209. 17. Tesla valuation - Complete practical exercise/25. Calculating Net income.mp4 14.80MB
  210. 17. Tesla valuation - Complete practical exercise/25. Calculating Net income.vtt 1.29KB
  211. 17. Tesla valuation - Complete practical exercise/25.1 18. P&L complete_before.xlsx.xlsx 1.43MB
  212. 17. Tesla valuation - Complete practical exercise/25.2 18. P&L complete_after.xlsx.xlsx 1.43MB
  213. 17. Tesla valuation - Complete practical exercise/26. Bridging Unlevered free cash flow to Net cash flow.mp4 50.72MB
  214. 17. Tesla valuation - Complete practical exercise/26. Bridging Unlevered free cash flow to Net cash flow.vtt 4.17KB
  215. 17. Tesla valuation - Complete practical exercise/26.1 19. Cash flow_complete_after.xlsx.xlsx 1.43MB
  216. 17. Tesla valuation - Complete practical exercise/26.2 19. Cash flow_complete_before.xlsx.xlsx 1.43MB
  217. 17. Tesla valuation - Complete practical exercise/27. Balancing the Balance sheet.mp4 13.27MB
  218. 17. Tesla valuation - Complete practical exercise/27. Balancing the Balance sheet.vtt 1.12KB
  219. 17. Tesla valuation - Complete practical exercise/27.1 20. Complete the BS_before.xlsx.xlsx 1.43MB
  220. 17. Tesla valuation - Complete practical exercise/27.2 20. Complete the BS_after.xlsx.xlsx 1.43MB
  221. 17. Tesla valuation - Complete practical exercise/28. Estimating Weighted average cost of capital (WACC).mp4 32.71MB
  222. 17. Tesla valuation - Complete practical exercise/28.1 21. WACC_before.xlsx.xlsx 1.43MB
  223. 17. Tesla valuation - Complete practical exercise/28.2 21. WACC_after.xlsx.xlsx 1.43MB
  224. 17. Tesla valuation - Complete practical exercise/29. Performing discounted cash flow valuation (DCF).mp4 34.90MB
  225. 17. Tesla valuation - Complete practical exercise/29. Performing discounted cash flow valuation (DCF).vtt 3.83KB
  226. 17. Tesla valuation - Complete practical exercise/29.1 22. DCF_after.xlsx.xlsx 1.44MB
  227. 17. Tesla valuation - Complete practical exercise/29.2 22. DCF_before.xlsx.xlsx 1.23MB
  228. 17. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.mp4 99.71MB
  229. 17. Tesla valuation - Complete practical exercise/3.1 1. Deliveries_before.xlsx.xlsx 1.29MB
  230. 17. Tesla valuation - Complete practical exercise/3.2 1. Deliveries_after.xlsx.xlsx 1.29MB
  231. 17. Tesla valuation - Complete practical exercise/30. Calculating enterprise value, equity value, and price per share.mp4 22.55MB
  232. 17. Tesla valuation - Complete practical exercise/30. Calculating enterprise value, equity value, and price per share.vtt 2.01KB
  233. 17. Tesla valuation - Complete practical exercise/30.1 23. EV, Equity value, Price per share_before.xlsx.xlsx 1.44MB
  234. 17. Tesla valuation - Complete practical exercise/30.2 23. EV, Equity value, Price per share_after.xlsx.xlsx 1.44MB
  235. 17. Tesla valuation - Complete practical exercise/31. Final comments.mp4 44.88MB
  236. 17. Tesla valuation - Complete practical exercise/31. Final comments.vtt 4.18KB
  237. 17. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.mp4 19.91MB
  238. 17. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.mp4 37.66MB
  239. 17. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.mp4 45.13MB
  240. 17. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.mp4 15.95MB
  241. 17. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.mp4 25.45MB
  242. 17. Tesla valuation - Complete practical exercise/8.2 4a. Gross profit automotive - after.xlsx.xlsx 1.32MB
  243. 17. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.mp4 6.84MB
  244. 18. Capital budgeting - The theory/1. Introduction to Capital budgeting.mp4 5.43MB
  245. 18. Capital budgeting - The theory/1. Introduction to Capital budgeting.vtt 1.79KB
  246. 18. Capital budgeting - The theory/2. Why we need Capital budgeting.mp4 6.57MB
  247. 18. Capital budgeting - The theory/4. Calculating future and present Value.mp4 13.08MB
  248. 18. Capital budgeting - The theory/4. Calculating future and present Value.vtt 6.27KB
  249. 18. Capital budgeting - The theory/5. Calculating cost of equity.mp4 19.21MB
  250. 18. Capital budgeting - The theory/5. Calculating cost of equity.vtt 7.44KB
  251. 18. Capital budgeting - The theory/6. Coming up with project-specific beta.mp4 684.53KB
  252. 18. Capital budgeting - The theory/8. The type of cash flows we will have in a project.mp4 9.34MB
  253. 18. Capital budgeting - The theory/8. The type of cash flows we will have in a project.vtt 3.88KB
  254. 18. Capital budgeting - The theory/9. Estimating the project's cash flows.mp4 18.79MB
  255. 18. Capital budgeting - The theory/9. Estimating the project's cash flows.vtt 6.68KB
  256. 19. Capital Budgeting - A Complete Case Study/1. Introduction to the Capital budgeting exercise.mp4 8.63MB
  257. 19. Capital Budgeting - A Complete Case Study/1. Introduction to the Capital budgeting exercise.vtt 3.23KB
  258. 19. Capital Budgeting - A Complete Case Study/10. Finding cost of equity.mp4 13.92MB
  259. 19. Capital Budgeting - A Complete Case Study/10. Finding cost of equity.vtt 7.16KB
  260. 19. Capital Budgeting - A Complete Case Study/10.1 8. WACC_unsolved.xlsx.xlsx 35.93KB
  261. 19. Capital Budgeting - A Complete Case Study/10.2 8. WACC.xlsx.xlsx 38.03KB
  262. 19. Capital Budgeting - A Complete Case Study/11. Discounting the project's cash flows and residual value.mp4 23.37MB
  263. 19. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and completing the exercise.mp4 41.39MB
  264. 19. Capital Budgeting - A Complete Case Study/14. Congratulations!!.mp4 2.30MB
  265. 19. Capital Budgeting - A Complete Case Study/14. Congratulations!!.vtt 1.50KB
  266. 19. Capital Budgeting - A Complete Case Study/2. Organizing an Inputs sheet.mp4 11.05MB
  267. 19. Capital Budgeting - A Complete Case Study/2. Organizing an Inputs sheet.vtt 6.22KB
  268. 19. Capital Budgeting - A Complete Case Study/2.1 1. Drivers.xlsx.xlsx 11.50KB
  269. 19. Capital Budgeting - A Complete Case Study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4 9.21MB
  270. 19. Capital Budgeting - A Complete Case Study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.vtt 4.12KB
  271. 19. Capital Budgeting - A Complete Case Study/3.1 2. Savings Forecast.xlsx.xlsx 16.58KB
  272. 19. Capital Budgeting - A Complete Case Study/3.2 2. Savings Forecast_unsolved.xlsx.xlsx 14.74KB
  273. 19. Capital Budgeting - A Complete Case Study/4. Fixed asset rollforward.mp4 12.15MB
  274. 19. Capital Budgeting - A Complete Case Study/4. Fixed asset rollforward.vtt 5.28KB
  275. 19. Capital Budgeting - A Complete Case Study/4.1 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx 18.54KB
  276. 19. Capital Budgeting - A Complete Case Study/4.2 3. Fixed Asset Rollforward.xlsx.xlsx 19.66KB
  277. 19. Capital Budgeting - A Complete Case Study/5. The impact of working capital.mp4 5.37MB
  278. 19. Capital Budgeting - A Complete Case Study/5. The impact of working capital.vtt 2.85KB
  279. 19. Capital Budgeting - A Complete Case Study/5.1 4. Working Capital.xlsx.xlsx 21.93KB
  280. 19. Capital Budgeting - A Complete Case Study/5.2 4. Working Capital_unsolved.xlsx.xlsx 21.19KB
  281. 19. Capital Budgeting - A Complete Case Study/6. Modeling debt financing.mp4 6.18MB
  282. 19. Capital Budgeting - A Complete Case Study/6. Modeling debt financing.vtt 3.30KB
  283. 19. Capital Budgeting - A Complete Case Study/6.1 5. Financing_unsolved.xlsx.xlsx 29.99KB
  284. 19. Capital Budgeting - A Complete Case Study/6.2 5. Financing.xlsx.xlsx 30.97KB
  285. 19. Capital Budgeting - A Complete Case Study/7. Adding a P&L sheet.mp4 4.88MB
  286. 19. Capital Budgeting - A Complete Case Study/7. Adding a P&L sheet.vtt 2.12KB
  287. 19. Capital Budgeting - A Complete Case Study/7.1 6. P&L.xlsx.xlsx 31.03KB
  288. 19. Capital Budgeting - A Complete Case Study/7.2 6. P&L_unsolved.xlsx.xlsx 29.70KB
  289. 19. Capital Budgeting - A Complete Case Study/8. Calculating project cash flows.mp4 2.87MB
  290. 2. Introduction to Excel/11. Introduction to Excel functions.mp4 9.00MB
  291. 2. Introduction to Excel/11.3 Introduction-to-Excels-basic-features.pdf.pdf 2.27MB
  292. 2. Introduction to Excel/11.4 13. Functions- Lecture - Unsolved.xlsx.xlsx 9.24KB
  293. 2. Introduction to Excel/11.5 13. Functions-Exercise - Unsolved.xlsx.xlsx 13.26KB
  294. 2. Introduction to Excel/12. Cut, copy, & paste.mp4 6.57MB
  295. 2. Introduction to Excel/14.3 Introduction-to-Excels-basic-features.pdf.pdf 2.27MB
  296. 2. Introduction to Excel/15. Basic operations in Excel - 38 pages.html 164B
  297. 2. Introduction to Excel/2. Overview of Excel.mp4 7.72MB
  298. 2. Introduction to Excel/2.1 7. Introduction to Excel.pdf.pdf 2.26MB
  299. 2. Introduction to Excel/2.2 7. Overview-of-Excel-Exercise-Solved.xlsx.xlsx 10.88KB
  300. 2. Introduction to Excel/2.3 7. Overview-of-Excel-Exercise-Unsolved.xlsx.xlsx 10.47KB
  301. 2. Introduction to Excel/3. Overview of Excel.html 160B
  302. 2. Introduction to Excel/4. Basic manipulations with rows and columns.mp4 3.49MB
  303. 2. Introduction to Excel/6. The Excel ribbon.mp4 8.81MB
  304. 2. Introduction to Excel/6. The Excel ribbon.vtt 2.99KB
  305. 2. Introduction to Excel/6.1 9. The-Ribbon-Exercise-Solved.xlsx.xlsx 403.25KB
  306. 2. Introduction to Excel/6.2 9. The-Ribbon-Exercise-Exercise - Unsolved.xlsx.xlsx 12.09KB
  307. 2. Introduction to Excel/7. Data entry in Excel.mp4 10.39MB
  308. 2. Introduction to Excel/7. Data entry in Excel.vtt 3.32KB
  309. 2. Introduction to Excel/7.1 10. Data-Entry - Lecture.xlsx.xlsx 8.07KB
  310. 2. Introduction to Excel/7.2 10. Data-Entry-Exercise - Unsolved.xlsx.xlsx 10.97KB
  311. 2. Introduction to Excel/7.3 10. Data-Entry- Exercise -Solved.xlsx.xlsx 32.76KB
  312. 2. Introduction to Excel/8. Introduction to formatting.mp4 24.75MB
  313. 2. Introduction to Excel/8. Introduction to formatting.vtt 6.14KB
  314. 2. Introduction to Excel/8.1 11. Formatting - Lecture - Solved.xlsx.xlsx 9.85KB
  315. 2. Introduction to Excel/8.2 11. Formatting-Exercise - Unsolved.xlsx.xlsx 11.61KB
  316. 2. Introduction to Excel/8.3 11. Formatting- Exercise - Solved.xlsx.xlsx 11.59KB
  317. 2. Introduction to Excel/8.4 11. Formatting- Lecture - Unsolved.xlsx.xlsx 8.91KB
  318. 2. Introduction to Excel/9. Introduction to Excel formulas.mp4 20.07MB
  319. 3/11.5 Useful-Tips-Tools.pdf.pdf 3.31MB
  320. 3/12. Create easily printable documents in Excel by using Set Print Area.mp4 4.74MB
  321. 3/12. Create easily printable documents in Excel by using Set Print Area.vtt 1.50KB
  322. 3/12.1 25. Set-Print-Area-Lecture - Unsolved.xlsx.xlsx 11.42KB
  323. 3/12.2 25. Set-Print-Area-Lecture - Solved.xlsx.xlsx 11.22KB
  324. 3/12.3 Useful-Tips-Tools.pdf.pdf 3.31MB
  325. 3/13. Find and select special types of cells with Select Special (F5).mp4 6.31MB
  326. 3/13.4 Useful-Tips-Tools.pdf.pdf 3.31MB
  327. 3/14. Select Special.html 160B
  328. 3/15. Learn how to assign dynamic names within a financial model.mp4 7.32MB
  329. 3/15. Learn how to assign dynamic names within a financial model.vtt 1.56KB
  330. 3/15.1 27. Dynamic-Naming-Lecture - Unsolved.xlsx.xlsx 13.54KB
  331. 3/15.2 Useful-Tips-Tools.pdf.pdf 1.83MB
  332. 3/18.2 Useful-Tips-Tools.pdf.pdf 3.30MB
  333. 3/18.3 29. Assigning Custom Formats - Exercise - Solved.xlsx.xlsx 11.08KB
  334. 3/19. Macros are a great timesaver! Here's why!.mp4 4.95MB
  335. 3/19.1 Useful-Tips-Tools.pdf.pdf 3.30MB
  336. 3/19.2 30. Creating-a-Macro-Lecture - Solved.xlsx.xlsx 11.17KB
  337. 3/19.3 30. Macros-Exercise - Solved.xlsx.xlsx 145.02KB
  338. 3/19.4 30. Creating-a-Macro-Lecture - Unsolved.xlsx.xlsx 9.66KB
  339. 3/19.5 30. Macros-Exercise - Unsolved.xlsx.xlsx 10.34KB
  340. 3/2. Initial formatting of an Excel sheet to render it professional.mp4 7.99MB
  341. 3/2. Initial formatting of an Excel sheet to render it professional.vtt 2.16KB
  342. 3/2.1 18. Formatting-a-Worksheet-Exercise - Unsolved.xlsx.xlsx 10.63KB
  343. 3/2.2 18. Formatting-a-Worksheet-Exercise - Solved.xlsx.xlsx 10.76KB
  344. 3/2.3 Useful-Tips-Tools.pdf.pdf 3.30MB
  345. 3/2.4 18. Formatting-a-worksheet-Lecture - Solved.xlsx.xlsx 9.56KB
  346. 3/2.5 18. Formatting-a-worksheet-Lecture - Unsolved.xlsx.xlsx 8.98KB
  347. 3/20. How to save macros and use them across several workbooks.mp4 12.78MB
  348. 3/20. How to save macros and use them across several workbooks.vtt 1.72KB
  349. 3/20.1 31. Another-file.xlsx.xlsx 8.81KB
  350. 3/20.2 31. How-to-save-macros-Lecture-before.xlsx.xlsx 6.02KB
  351. 3/20.3 31. How-to-save-macros-Lecture-after.xlsm.xlsm 12.59KB
  352. 3/21. Excel Macros - quiz.html 160B
  353. 3/22. Create a drop-down list by using Data Validation.mp4 10.23MB
  354. 3/23. Using Custom-sort in order to sort multiple columns within a table.mp4 8.22MB
  355. 3/23.4 Useful-Tips-Tools.pdf.pdf 3.31MB
  356. 3/23.5 33. Custom-Sort-Exercise - Solved.xlsx.xlsx 11.46KB
  357. 3/24. Create a great Index page at the beginning of your models - Hyperlinks.mp4 5.35MB
  358. 3/24. Create a great Index page at the beginning of your models - Hyperlinks.vtt 1.51KB
  359. 3/24.1 34. Hyperlinks-Exercise - Unsolved.xlsx.xlsx 136.89KB
  360. 3/24.2 34. Hyperlinks-Exercise - Solved.xlsx.xlsx 137.06KB
  361. 3/24.3 Useful-Tips-Tools.pdf.pdf 1.83MB
  362. 3/25. Fix the top row of your table with Freeze Panes.mp4 17.67MB
  363. 3/25. Fix the top row of your table with Freeze Panes.vtt 1.42KB
  364. 3/25.1 35. Freeze-Panes-Lecture - Unsolved.xlsx.xlsx 643.87KB
  365. 3/25.2 35. Freeze-Panes-Lecture - Solved.xlsx.xlsx 643.94KB
  366. 3/25.3 Useful-Tips-Tools.pdf.pdf 3.31MB
  367. 3/26. Filter by color - an excellent tool.mp4 9.88MB
  368. 3/26. Filter by color - an excellent tool.vtt 1.99KB
  369. 3/26.1 36. Exercise-Filter-by-Color-Unsolved.xlsx.xlsx 20.47KB
  370. 3/26.2 36. Exercise-Filter-by-Color-Solved.xlsx.xlsx 153.48KB
  371. 3/27. Working with conditional formatting.mp4 14.23MB
  372. 3/28. A neat trick - Multiply by 1.mp4 14.84MB
  373. 3/28. A neat trick - Multiply by 1.vtt 1.64KB
  374. 3/28.1 38. Multiply-by-1-Lecture-before.xlsx.xlsx 16.47KB
  375. 3/28.2 38. Multiply-by-1-Lecture-after.xlsx.xlsx 17.21KB
  376. 3/29. Useful tips and tools for your work in Excel - quiz.html 159B
  377. 3/3. Fast scrolling through Excel sheets.mp4 22.16MB
  378. 3/3. Fast scrolling through Excel sheets.vtt 1.73KB
  379. 3/3.1 Useful-Tips-Tools.pdf.pdf 3.31MB
  380. 3/3.2 19. Fast-Scrolling-Exercise - Unsolved.xlsx.xlsx 43.90KB
  381. 3/3.3 19. Fast-Scrolling-Exercise - Solved.xlsx.xlsx 44.35KB
  382. 3/3.4 19. Fast-Scrolling - Lecture.xlsx.xlsx 642.82KB
  383. 3/30. Find and replace - references.mp4 24.04MB
  384. 3/30. Find and replace - references.vtt 3.32KB
  385. 3/30.1 39. Find-and-Replace-references-Lecture-after.xlsx.xlsx 37.91KB
  386. 3/30.2 39. Find-and-Replace-references-Lecture-before.xlsx.xlsx 38.79KB
  387. 3/31. Find and replace - formatting.mp4 13.78MB
  388. 3/31. Find and replace - formatting.vtt 1.88KB
  389. 3/31.1 40. Find-replace-Lecture-before.xlsx.xlsx 17.19KB
  390. 3/31.2 40. Find-replace-Lecture-after.xlsx.xlsx 17.19KB
  391. 3/32. Removing (automatic) green arrows.mp4 12.60MB
  392. 3/32. Removing (automatic) green arrows.vtt 1.63KB
  393. 3/32.1 41. Green-references-Lecture.xlsx.xlsx 12.00KB
  394. 3/33. Beauty saving - The professional way of saving files.mp4 14.02MB
  395. 3/33. Beauty saving - The professional way of saving files.vtt 2.59KB
  396. 3/33.1 42. Beauty-saving-Lecture-before.xlsx.xlsx 17.17KB
  397. 3/33.2 42. Beauty-saving-Lecture-after.xlsx.xlsx 17.05KB
  398. 3/34. Formula auditing with F2.mp4 17.74MB
  399. 3/34. Formula auditing with F2.vtt 2.14KB
  400. 3/34.1 43. F2-Lecture.xlsm.xlsm 50.76KB
  401. 3/4. Be even quicker F5 + Enter.mp4 19.78MB
  402. 3/4. Be even quicker F5 + Enter.vtt 2.11KB
  403. 3/4.1 20. F5-go-to - Lecture.xlsm.xlsm 50.76KB
  404. 3/5. Fast scrolling through Excel sheets.html 160B
  405. 3/6. Introduction to fixing of cell references.mp4 20.37MB
  406. 3/6. Introduction to fixing of cell references.vtt 2.53KB
  407. 3/6.1 Useful-Tips-Tools.pdf.pdf 3.31MB
  408. 3/6.2 21. Fixing-Cells-Exercise - Unsolved.xlsx.xlsx 10.67KB
  409. 3/6.3 21. Fixing-references-Lecture - Unsolved.xlsx.xlsx 643.98KB
  410. 3/6.4 21. Fixing-Cells-Exercise - Solved.xlsx.xlsx 10.82KB
  411. 3/6.5 21. Fixing-references-Lecture - Solved.xlsx.xlsx 645.17KB
  412. 3/7. Introduction to fixing of cell references.html 160B
  413. 3/8. Using the 'Alt + Enter' combination.mp4 3.33MB
  414. 3/8. Using the 'Alt + Enter' combination.vtt 1008B
  415. 3/8.1 22. Alt-Enter-Exercise - Unsolved.xlsx.xlsx 11.12KB
  416. 3/8.2 22. Alt-Enter- Lecture - Unsolved.xlsx.xlsx 9.64KB
  417. 3/8.3 22. Alt-Enter- Lecture - Solved.xlsx.xlsx 9.65KB
  418. 3/8.4 22. Alt-Enter-Exercise - Solved.xlsx.xlsx 11.40KB
  419. 3/9. Learn how to organize your data with Text to Columns.mp4 12.54MB
  420. 3/9. Learn how to organize your data with Text to Columns.vtt 2.21KB
  421. 3/9.1 23. Text-to-Columns-Exercise - Solved.xlsx.xlsx 11.30KB
  422. 3/9.2 23. Text-to-Columns-Exercise - Unsolved.xlsx.xlsx 10.57KB
  423. 3/9.3 23. Text-to-columns-Lecture - Unsolved.xlsx.xlsx 9.76KB
  424. 3/9.4 Useful-Tips-Tools.pdf.pdf 3.31MB
  425. 3/9.5 23.Text-to-columns-Lecture - Solved.xlsx.xlsx 9.90KB
  426. 4. Keyboard shortcuts in Excel/1. Keyboard shortcuts Save LOTS of time in Excel.mp4 27.55MB
  427. 5/11. Find the minimum or maximum value in a range of cells in Excel.mp4 5.91MB
  428. 5/11. Find the minimum or maximum value in a range of cells in Excel.vtt 1.09KB
  429. 5/11.1 54. Max-min-Lecture - Unsolved.xlsx.xlsx 8.95KB
  430. 5/11.2 54. MIN-MAX-Exercise - Unsolved.xlsx.xlsx 14.39KB
  431. 5/11.3 54. Max-min-Lecture - Solved.xlsx.xlsx 9.23KB
  432. 5/11.4 54. MIN-MAX-Exercise - Solved.xlsx.xlsx 14.80KB
  433. 5/12. Include ROUND in your financial models.mp4 839.76KB
  434. 5/13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4 34.59MB
  435. 5/13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.vtt 8.45KB
  436. 5/13.1 56. Vlookup-Hlookup- Lecture - Unsolved.xlsx.xlsx 10.74KB
  437. 5/13.2 56. Vlookup-Hlookup- Lecture - Solved.xlsx.xlsx 11.13KB
  438. 5/13.3 Excel-Functions.pdf.pdf 3.19MB
  439. 5/13.4 56. Vlookup-Hlookup-Exercise - Solved.xlsx.xlsx 13.68KB
  440. 5/13.5 56. Vlookup-Hlookup-Exercise - Unsolved.xlsx.xlsx 11.95KB
  441. 5/14. How to enlarge the formula bar.mp4 6.26MB
  442. 5/14. How to enlarge the formula bar.vtt 1.37KB
  443. 5/14.1 57. Enlarge-the-formula-bar-Lecture.xlsm.xlsm 46.89KB
  444. 5/15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4 38.95MB
  445. 5/15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.vtt 8.22KB
  446. 5/15.1 58. Index-Match-Lecture - Solved.xlsx.xlsx 11.70KB
  447. 5/15.2 Excel-Functions.pdf.pdf 3.18MB
  448. 5/15.3 58. Index-Match-Exercise - Solved.xlsx.xlsx 12.08KB
  449. 5/15.4 58. Index-Match-Lecture - Unsolved.xlsx.xlsx 11.29KB
  450. 5/15.5 58. Index-Match-Exercise - Unsolved.xlsx.xlsx 11.59KB
  451. 5/16. A great Excel technique INDEX, MATCH, MATCH.mp4 11.76MB
  452. 5/16. A great Excel technique INDEX, MATCH, MATCH.vtt 5.27KB
  453. 5/16.1 59. Exercise-Index-Match-Match-Solved.xlsx.xlsx 12.21KB
  454. 5/16.2 59. Exercise-Index-Match-Match-Unsolved.xlsx.xlsx 11.58KB
  455. 5/17. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.html 160B
  456. 5/18. Using Excel's IFERROR function to trap spreadsheet errors.mp4 3.51MB
  457. 5/18.4 Excel-Functions.pdf.pdf 3.19MB
  458. 5/18.5 60. Iferror - Lecture - Solved.xlsm.xlsm 896.43KB
  459. 5/19. RANK is a valuable tool when using Excel for Financial and Business analysis.mp4 23.24MB
  460. 5/19. RANK is a valuable tool when using Excel for Financial and Business analysis.vtt 2.82KB
  461. 5/19.1 61. Rank-function-Lecture-after.xlsx.xlsx 12.61KB
  462. 5/19.2 61. Rank-function-Lecture-before.xlsx.xlsx 12.27KB
  463. 5/2. Key functions in Excel IF.mp4 16.25MB
  464. 5/20.4 Excel-Functions.pdf.pdf 3.19MB
  465. 5/20.5 62. Choose-Exercise - Unsolved.xlsx.xlsx 11.32KB
  466. 5/21. Use Goal Seek to find the result that you are looking for.mp4 2.06MB
  467. 5/21.2 Excel-Functions.pdf.pdf 3.19MB
  468. 5/21.3 63. Goal-Seek-Exercise-Solved.xlsx.xlsx 16.21KB
  469. 5/21.4 63. Goal-Seek-Lecture - Solved.xlsx.xlsx 9.17KB
  470. 5/21.5 63. Goal-Seek-Lecture - Unsolved.xlsx.xlsx 9.15KB
  471. 5/22. Use Goal Seek in order to find the result that you are looking for.html 160B
  472. 5/23. Include sensitivity analysis in your models through Data Tables.mp4 10.96MB
  473. 5/23.1 64. Sensitivity analysis - Lecture - Solved.xlsm.xlsm 897.30KB
  474. 5/23.2 64. Sensitivity-analysis-Exercise-Unsolved.xlsm.xlsm 66.82KB
  475. 5/23.3 64. Sensitivity-analysis-Exercise-Solved.xlsm.xlsm 63.87KB
  476. 5/23.4 64. Sensitivity analysis - Lecture - Unsolved.xlsm.xlsm 897.09KB
  477. 5/24. Include sensitivity analysis in your models through Data Tables.html 160B
  478. 5/25. Excel's dynamic and interactive tables Pivot tables.mp4 16.59MB
  479. 5/25. Excel's dynamic and interactive tables Pivot tables.vtt 2.58KB
  480. 5/25.1 65. Pivot tables - Lecture - Unsolved.xlsm.xlsm 687.83KB
  481. 5/25.2 65. Pivot Tables - Exercise - Unsolved.xlsx.xlsx 152.17KB
  482. 5/25.3 65. Pivot tables - Lecture - Solved.xlsm.xlsm 897.26KB
  483. 5/25.4 65. Pivot Tables - Exercise - Solved.xlsx.xlsx 190.47KB
  484. 5/26. Excel's key functions and functionalities made easy.html 159B
  485. 5/3. Key Excel functions SUM, SUMIF and SUMIFS.mp4 19.32MB
  486. 5/3. Key Excel functions SUM, SUMIF and SUMIFS.vtt 4.92KB
  487. 5/3.1 48. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx.xlsx 12.93KB
  488. 5/3.2 48. Sum-Sumif-Sumifs-Lecture - Solved.xlsx.xlsx 13.01KB
  489. 5/3.3 48. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx.xlsx 14.46KB
  490. 5/3.4 Excel-Functions.pdf.pdf 3.18MB
  491. 5/3.5 48. Sum-Sumif-Sumifs-Exercise - Solved.xlsx.xlsx 14.84KB
  492. 5/4. = and + are interchangeable when you start typing a formula.mp4 5.79MB
  493. 5/4. = and + are interchangeable when you start typing a formula.vtt 975B
  494. 5/4.1 49. = and + are interchangeable -after.xlsm.xlsm 17.04KB
  495. 5/4.2 49. = and + are interchangeable - before.xlsm.xlsm 17.01KB
  496. 5/5. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 15.93MB
  497. 5/8. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4 12.61MB
  498. 6. Update! SUMIFS - Exercise/2. Exercise - Excel's SUMIFS function - solved & explained.mp4 31.76MB
  499. 6. Update! SUMIFS - Exercise/2.1 67. Exercise-Sumifs-With-Solutions.xlsx.xlsx 1.29MB
  500. 7. Financial functions in Excel/1. Future and present values in Excel.mp4 7.15MB
  501. 7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.mp4 14.82MB
  502. 7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.vtt 5.90KB
  503. 7. Financial functions in Excel/3.1 70. Loan Schedule-Lecture.xlsx.xlsx 20.17KB
  504. 7. Financial functions in Excel/3.2 70. Exercise-Loan-Schedule-Solved.xlsx.xlsx 22.68KB
  505. 7. Financial functions in Excel/3.3 70. Exercise-Loan-Schedule-Unsolved.xlsx.xlsx 15.81KB
  506. 7. Financial functions in Excel/4. Date functions in Excel.mp4 11.35MB
  507. 7. Financial functions in Excel/4. Date functions in Excel.vtt 5.51KB
  508. 7. Financial functions in Excel/4.1 71. Date Functions-Exercise-Solved.xlsx.xlsx 12.43KB
  509. 7. Financial functions in Excel/4.2 71. Date Functions-Lecture.xlsx.xlsx 12.25KB
  510. 7. Financial functions in Excel/4.3 71. Date Functions-Exercise-Unsolved.xlsx.xlsx 11.41KB
  511. 8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.mp4 6.00MB
  512. 8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.vtt 1.99KB
  513. 8. Microsoft Excel's Pivot Tables in Depth/2. Creating Pivot Tables easily!.mp4 16.29MB
  514. 8. Microsoft Excel's Pivot Tables in Depth/2.1 73. Creating-a-Pivot-Table - Lecture - after.xlsx.xlsx 1.43MB
  515. 8. Microsoft Excel's Pivot Tables in Depth/2.2 73. Creating-a-Pivot-Table - Lecture – before.xlsx.xlsx 1.23MB
  516. 8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.mp4 11.28MB
  517. 8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.vtt 2.22KB
  518. 8. Microsoft Excel's Pivot Tables in Depth/3.1 74. Formatting-a-Pivot-Table - Lecture - after.xlsx.xlsx 1.43MB
  519. 8. Microsoft Excel's Pivot Tables in Depth/3.2 74. Formatting-a-Pivot-Table - Lecture - before.xlsx.xlsx 1.43MB
  520. 8. Microsoft Excel's Pivot Tables in Depth/4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4 8.10MB
  521. 8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GETPIVOTDATA - A very important Excel function.mp4 18.06MB
  522. 8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GETPIVOTDATA - A very important Excel function.vtt 3.77KB
  523. 8. Microsoft Excel's Pivot Tables in Depth/5.1 76. GetPivotData - Lecture - before.xlsx.xlsx 1.88MB
  524. 8. Microsoft Excel's Pivot Tables in Depth/5.2 76. GetPivotData - Lecture – after.xlsx.xlsx 1.88MB
  525. 8. Microsoft Excel's Pivot Tables in Depth/6. An introduction to slicers - The modern-day Pivot Table filters.mp4 15.97MB
  526. 8. Microsoft Excel's Pivot Tables in Depth/6.1 77. Slicers - Lecture - after.xlsx.xlsx 1.88MB
  527. 8. Microsoft Excel's Pivot Tables in Depth/6.2 77. Slicers - Lecture - before.xlsx.xlsx 1.88MB
  528. 9/1. Case study - Build a P&L from scratch - Welcome lecture.mp4 3.14MB
  529. 9/1. Case study - Build a P&L from scratch - Welcome lecture.vtt 1.53KB
  530. 9/10. Use INDEX & MATCH as a substitute for VLOOKUP.mp4 49.58MB
  531. 9/10. Use INDEX & MATCH as a substitute for VLOOKUP.vtt 4.24KB
  532. 9/10.1 87. Index Match-Lecture-before.xlsm.xlsm 41.04KB
  533. 9/10.2 87. Index Match-Lecture-after.xlsm.xlsm 13.86MB
  534. 9/11. Mapping the rows in the Database sheet.mp4 27.41MB
  535. 9/12. In case you have any doubts about the Mapping exercise.mp4 38.56MB
  536. 9/12. In case you have any doubts about the Mapping exercise.vtt 6.34KB
  537. 9/12.1 89. Mapping-Lecture-Unsolved.xlsm.xlsm 50.55KB
  538. 9/12.2 89. Mapping-exercise-explained.pdf.pdf 243.03KB
  539. 9/12.3 89. Mapping-Lecture-Solved.xlsx.xlsx 47.50KB
  540. 9/13. Building the structure of the P&L sheet.mp4 11.94MB
  541. 9/14. Formatting sets You apart from the competition in Excel - A Practical Example.mp4 25.42MB
  542. 9/14. Formatting sets You apart from the competition in Excel - A Practical Example.vtt 13.56MB
  543. 9/15. Populate the P&L sheet with SUMIF.mp4 23.44MB
  544. 9/16. Learn how to find mistakes with COUNTIF.mp4 27.87MB
  545. 9/16. Learn how to find mistakes with COUNTIF.vtt 2.80KB
  546. 9/16.1 93. Countif-Lecture-after.xlsm.xlsm 54.78KB
  547. 9/16.2 93. Countif-Lecture-before.xlsm.xlsm 53.51KB
  548. 9/17. Calculating year-on-year percentage variations the proper way.mp4 29.98MB
  549. 9/17. Calculating year-on-year percentage variations the proper way.vtt 3.24KB
  550. 9/17.1 94. Adding % variations-Lecture-after.xlsm.xlsm 56.51KB
  551. 9/17.2 94. Adding % variations-Lecture-before.xlsm.xlsm 54.78KB
  552. 9/17.3 Y-o-Y Function explanation.pdf.pdf 164.92KB
  553. 9/2. Introduction to the case study.mp4 6.84MB
  554. 9/3. Understand your data source before you start working on it.mp4 24.63MB
  555. 9/4. Order the source worksheets.mp4 26.54MB
  556. 9/4. Order the source worksheets.vtt 2.41KB
  557. 9/4.1 81. Order a worksheet_before.xlsm.xlsm 43.08KB
  558. 9/4.2 81. Order a worksheet_after.xlsm.xlsm 41.01KB
  559. 9/5. Create a code the best way to organize your data and work efficiently with it.mp4 9.80MB
  560. 9/6. Learn how to create a database.mp4 20.70MB
  561. 9/6. Learn how to create a database.vtt 2.15KB
  562. 9/6.1 83. Creating a database_after.xlsm.xlsm 39.39KB
  563. 9/6.2 83. Creating a database_before.xlsm.xlsm 41.73KB
  564. 9/7. Use VLOOKUP to fill the Database sheet.mp4 61.57MB
  565. 9/7. Use VLOOKUP to fill the Database sheet.vtt 5.40KB
  566. 9/7.1 84. Vlookup_before.xlsm.xlsm 39.50KB
  567. 9/7.2 84. Vlookup_after.xlsm.xlsm 44.45KB
  568. 9/8. 50% Completed!.mp4 4.31MB
  569. 9/8. 50% Completed!.vtt 51B
  570. 9/9. Use SUMIF to complete the Database sheet.mp4 47.94MB
  571. 9/9. Use SUMIF to complete the Database sheet.vtt 4.17KB
  572. 9/9.1 86. Sumif_after.xlsm.xlsm 49.53KB
  573. 9/9.2 86. Sumif_before.xlsm.xlsm 44.45KB
  574. [Tutorialsplanet.NET].url 128B