:Search:

Udemy Beginner to Pro in Excel Financial Modeling and Valuation Desire Course

Torrent:
Magnet Download .torrent File
Info Hash: 6EFA437E6486BF66436578D3083E9748DFAA1A40
Similar Posts:
Name Uploaded Size Se Le Upl. by
Udemy Beginner Friendly Waltz Wedding First Dance Choreography Udemy Beginner Friendly Waltz Wedding First Dance Choreography
2025-04-03 1.6 GB 18 7 freecoursewb
Udemy Beginner to Advance QuickBooks Accounting Software Training Fre… Udemy Beginner to Advance QuickBooks Accounting Software Training FreeCourseWeb
2025-01-13 3.4 GB 24 17 FreeCourseWeb
Udemy Beginner S Guide To Deepfakes Gen Ai Influencers and Av Udemy Beginner S Guide To Deepfakes Gen Ai Influencers and Av
2024-04-26 873.1 MB 8 9 freecoursewb
Udemy Beginner Machine Learning in Python ChatGPT Prize 2024 Udemy Beginner Machine Learning in Python ChatGPT Prize 2024
2024-03-13 694.6 MB 2 1 CourseClub
Udemy Beginner to Pro in Excel Financial Modeling and Valuation Updat… Udemy Beginner to Pro in Excel Financial Modeling and Valuation Updated 2 2020 FreeAllCourse
2023-10-28 5.4 GB 0 2 LMorningStar
Udemy Beginner to Pro in PowerPoint Complete PowerPoint Training Free… Udemy Beginner to Pro in PowerPoint Complete PowerPoint Training FreeAllCourse
2023-10-28 1.2 GB 3 5 LMorningStar
Udemy Beginner to Pro in Excel Financial Modeling and Valuation Desir… Udemy Beginner to Pro in Excel Financial Modeling and Valuation Desire Course
2023-10-27 5.7 GB 3 5 CourseClub
Udemy Beginner s Guide to Multiplayer Game Development in Unity Udemy Beginner s Guide to Multiplayer Game Development in Unity
2023-10-26 761.8 MB 2 1 tutsnode
Udemy Beginner Coding 3D Game World Development with Kodu Game Lab Udemy Beginner Coding 3D Game World Development with Kodu Game Lab
2023-10-25 388.6 MB 0 1 freecoursewb
Udemy Beginner RStudio Course For Excel Users Udemy Beginner RStudio Course For Excel Users
2023-10-25 1.1 GB 0 4 freecoursewb
Uploader: CourseClub
Source: 1 Logo 1337x
Downloads: 68
Type: Tutorials
Language: English
Category: Other
Size: 5.7 GB
Added: Oct. 27, 2023, 10:37 p.m.
Peers: Seeders: 3, Leechers: 5 (Last updated: 11 months ago)
Tracker Data:
Tracker Seeders Leechers Completed
udp://open.stealth.si:80/announce 2 2 63
udp://exodus.desync.com:6969/announce (Failed to scrape UDP tracker) 0 0 0
udp://tracker.cyberia.is:6969/announce (Failed to scrape UDP tracker) 0 0 0
udp://tracker.opentrackr.org:1337/announce 1 0 4
udp://tracker.torrent.eu.org:451/announce 0 0 0
udp://explodie.org:6969/announce (Failed to scrape UDP tracker) 0 0 0
udp://tracker.birkenwald.de:6969/announce 0 2 0
udp://tracker.moeking.me:6969/announce (Failed to scrape UDP tracker) 0 0 0
udp://ipv4.tracker.harry.lu:80/announce (Failed to scrape UDP tracker) 0 0 0
udp://tracker.tiny-vps.com:6969/announce 0 0 1
udp://tracker.therarbg.to:6969/announce 0 1 0
Files:
  1. [CourseClub.Me].url 48 bytes
  2. [DesireCourse.Net].url 51 bytes
  3. 1. What does the course cover.mp4 32.8 MB
  4. 1. What does the course cover.srt 4.9 KB
  5. 1.1 Course Notes - Beginner to Pro in Excel.pdf 19.0 MB
  6. 2. Bonus! Welcome gift.html 171 bytes
  7. 3. Welcome gift number 2.html 171 bytes
  8. 4. The best way to take this course.mp4 17.6 MB
  9. 4. The best way to take this course.srt 2.5 KB
  10. 5. Download all course materials and frequently asked questions (FAQ).html 5.4 KB
  11. [CourseClub.Me].url 48 bytes
  12. [DesireCourse.Net].url 51 bytes
  13. 1. How to insert a chart in Excel.mp4 22.3 MB
  14. 1. How to insert a chart in Excel.srt 2.7 KB
  15. 1.1 95. Inserting-Charts-Lecture.xlsm 11.5 MB
  16. 2. Editing Excel charts.mp4 26.1 MB
  17. 2. Editing Excel charts.srt 2.9 KB
  18. 2.1 96. Formatting-a-Chart-Lecture.xlsm 11.5 MB
  19. 3. Excel chart formatting.mp4 32.7 MB
  20. 3. Excel chart formatting.srt 3.5 KB
  21. 3.1 97. Modifying-a-Chart-Lecture.xlsm 11.4 MB
  22. 4. How to create a bridge chart in Excel.mp4 13.7 MB
  23. 4. How to create a bridge chart in Excel.srt 1.9 KB
  24. 4.1 98. Bridge-Charts-Lecture.xlsx 13.1 KB
  25. 5. New ways to visualize your data - Treemap charts.mp4 11.5 MB
  26. 5. New ways to visualize your data - Treemap charts.srt 1.7 KB
  27. 5.1 99. Treemap-Charts-Lecture.xlsx 12.6 KB
  28. 6. Sparklines.mp4 27.6 MB
  29. 6. Sparklines.srt 4.3 KB
  30. 6.1 100. Sparklines-Lecture.xlsx 9.6 KB
  31. 1. Create professional and good-looking charts - Introduction.mp4 6.2 MB
  32. 1. Create professional and good-looking charts - Introduction.srt 662 bytes
  33. 2. Build a column stacked chart with a secondary line axis in Excel.mp4 46.4 MB
  34. 2. Build a column stacked chart with a secondary line axis in Excel.srt 5.7 KB
  35. 2.1 102. Column stacked chart-Lecture-before.xlsm 11.5 MB
  36. 2.2 102. Column stacked chart-Lecture-after.xlsm 11.5 MB
  37. 3. Learn how to build effective doughnut charts in Excel.mp4 38.0 MB
  38. 3. Learn how to build effective doughnut charts in Excel.srt 5.4 KB
  39. 3.1 103. Doughnut chart-Lecture-after.xlsm 11.5 MB
  40. 3.2 103. Doughnut chart-Lecture-before.xlsm 11.5 MB
  41. 4. Learn how to build an area chart in Excel.mp4 28.6 MB
  42. 4. Learn how to build an area chart in Excel.srt 3.6 KB
  43. 4.1 104. Area chart-Lecture-before.xlsm 11.5 MB
  44. 4.2 104. Area chart-Lecture-after.xlsm 11.5 MB
  45. 5. Learn how to create bridge charts.mp4 52.1 MB
  46. 5. Learn how to create bridge charts.srt 7.6 KB
  47. 5.1 105. Bridge chart-Lecture-before.xlsm 11.5 MB
  48. 5.2 105. Bridge chart-Lecture-after.xlsm 11.5 MB
  49. 6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4 136.1 MB
  50. 6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.srt 12.7 KB
  51. 6.1 20. Bridge chart_after.xlsm 11.5 MB
  52. 6.2 20. Bridge chart_before.xlsm 11.5 MB
  53. 7. Case Study - Building a Complete P&L from scratch in Excel.html 166 bytes
  54. 8. Course Challenge - Apply your skills in practice!.mp4 7.9 MB
  55. 8. Course Challenge - Apply your skills in practice!.srt 1.3 KB
  56. 8.1 107. Course-Challenge - Unsolved.xlsx 505.5 KB
  57. 8.2 107. Course-Challenge - Solved.xlsx 543.9 KB
  58. 1. Introduction to the Case Study.mp4 24.1 MB
  59. 1. Introduction to the Case Study.srt 2.6 KB
  60. 1.1 108. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx 13.3 MB
  61. 10. FAQ My GETPIVOTDATA function doesn't work.html 651 bytes
  62. 11. Combining Slicers and GETPIVOTDATA The key to our success.mp4 33.6 MB
  63. 11. Combining Slicers and GETPIVOTDATA The key to our success.srt 3.6 KB
  64. 11.1 7. Exercise - Build an FMCG Model_Inserting Slicers_before.xlsx 20.8 MB
  65. 11.2 7. Exercise - Build an FMCG Model_Inserting Slicers_after.xlsx 20.8 MB
  66. 12. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 32.4 MB
  67. 12. Getting fancy with Excel slicers - Good-looking Excel slicers.srt 3.6 KB
  68. 12.1 8. Exercise - Build an FMCG Model_Formatting Slicers_before.xlsx 20.8 MB
  69. 12.2 8. Exercise - Build an FMCG Model_Formatting Slicers_after.xlsx 18.3 MB
  70. 13. This is how the report can be used in practice by high-level executives.mp4 36.2 MB
  71. 13. This is how the report can be used in practice by high-level executives.srt 4.7 KB
  72. 13.1 9. Exercise - Build an FMCG Model_Complete_after.xlsx 22.8 MB
  73. 13.2 9. Exercise - Build an FMCG Model_Complete_before.xlsx 18.3 MB
  74. 14. Dynamic reporting with GETPIVOTDATA and slicers.html 170 bytes
  75. 2. Preliminary mapping of the data extraction.mp4 30.5 MB
  76. 2. Preliminary mapping of the data extraction.srt 2.6 KB
  77. 2.1 1. Exercise - Build an FMCG Model_Mapping_before.xlsx 13.3 MB
  78. 2.2 1. Exercise - Build an FMCG Model_Mapping_after.xlsx 14.9 MB
  79. 3. Working with an SAP data extraction.mp4 37.1 MB
  80. 3. Working with an SAP data extraction.srt 4.1 KB
  81. 4. Creating an output structure of the FMCG model.mp4 19.7 MB
  82. 4. Creating an output structure of the FMCG model.srt 3.0 KB
  83. 4.1 2. Exercise - Build an FMCG Model_Layout_before.xlsx 14.9 MB
  84. 4.2 2. Exercise - Build an FMCG Model_Layout_after.xlsx 14.9 MB
  85. 5. Improving the layout and appearance of the FMCG report.mp4 25.4 MB
  86. 5. Improving the layout and appearance of the FMCG report.srt 4.9 KB
  87. 5.1 3. Exercise - Build an FMCG Model_Formatting_after.xlsx 14.9 MB
  88. 5.2 3. Exercise - Build an FMCG Model_Formatting_before.xlsx 14.9 MB
  89. 6. Inserting formulas and automating calculations.mp4 16.2 MB
  90. 6. Inserting formulas and automating calculations.srt 4.9 KB
  91. 6.1 4. Exercise - Build an FMCG Model_Adding Calculations_after.xlsx 14.9 MB
  92. 6.2 4. Exercise - Build an FMCG Model_Adding Calculations_before.xlsx 14.9 MB
  93. 7. Creating a Master Pivot Table The main data source for the FMCG report.mp4 20.1 MB
  94. 7. Creating a Master Pivot Table The main data source for the FMCG report.srt 2.2 KB
  95. 7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table_before.xlsx 14.9 MB
  96. 7.2 5. Exercise - Build an FMCG Model_Creating a Pivot Table_after.xlsx 20.8 MB
  97. 8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4 50.0 MB
  98. 8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.srt 7.1 KB
  99. 8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA_before.xlsx 20.8 MB
  100. 8.2 6a. Exercise - Build an FMCG Model_Copying Get Pivot_after.xlsx 20.8 MB
  101. 9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4 13.8 MB
  102. 9. A potential error with GETPIVOTDATA you might encounter and its fix.srt 1.5 KB
  103. 1. Financial modeling basics - Welcome lecture.mp4 2.1 MB
  104. 1. Financial modeling basics - Welcome lecture.srt 1.1 KB
  105. 10. Forecasting financials - Quiz.html 167 bytes
  106. 11. Building a complete model - Important considerations.mp4 8.4 MB
  107. 11. Building a complete model - Important considerations.srt 2.9 KB
  108. 12. Modeling the Income statement.mp4 13.3 MB
  109. 12. Modeling the Income statement.srt 7.5 KB
  110. 13. Modeling the Balance sheet - Part 1.mp4 6.1 MB
  111. 13. Modeling the Balance sheet - Part 1.srt 3.4 KB
  112. 14. Modeling the Balance sheet - Part 2.mp4 10.6 MB
  113. 14. Modeling the Balance sheet - Part 2.srt 6.1 KB
  114. 15. Building a financial model - Quiz.html 167 bytes
  115. 2. What is a financial model.mp4 5.5 MB
  116. 2. What is a financial model.srt 2.5 KB
  117. 3. Why use financial models.mp4 10.0 MB
  118. 3. Why use financial models.srt 3.3 KB
  119. 4. Financial modeling - worst practices - things you should avoid.mp4 19.9 MB
  120. 4. Financial modeling - worst practices - things you should avoid.srt 7.3 KB
  121. 5. Financial modeling - best practices.mp4 17.2 MB
  122. 5. Financial modeling - best practices.srt 6.0 KB
  123. 6. Financial modeling - The types of models that are built in practice.mp4 14.3 MB
  124. 6. Financial modeling - The types of models that are built in practice.srt 5.8 KB
  125. 7. Financial modeling - Quiz.html 167 bytes
  126. 8. Financial modeling The right level of detail in a model.mp4 7.3 MB
  127. 8. Financial modeling The right level of detail in a model.srt 3.1 KB
  128. 9. Financial modeling Forecasting guidelines.mp4 7.1 MB
  129. 9. Financial modeling Forecasting guidelines.srt 3.5 KB
  130. 1. The core theory behind Company Valuation.html 171 bytes
  131. 1. Introduction to Mergers & Acquisitions.html 171 bytes
  132. [CourseClub.Me].url 48 bytes
  133. [DesireCourse.Net].url 51 bytes
  134. 1. Valuation Case study - Welcome lecture.mp4 1.8 MB
  135. 1. Valuation Case study - Welcome lecture.srt 883 bytes
  136. 10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4 30.0 MB
  137. 10. Modeling other items Interest expenses, Extraordinary items and Taxes.srt 3.1 KB
  138. 10.1 9. Interest expenses, taxes_after.xlsm 50.9 KB
  139. 10.2 9. Interest expenses, taxes_before.xlsm 50.6 KB
  140. 11. Forecasting Balance sheet items.mp4 4.7 MB
  141. 11. Forecasting Balance sheet items.srt 870 bytes
  142. 11.1 10. Introduction to Balance sheet items.xlsm 51.0 KB
  143. 12. An introduction to the Days methodology.mp4 10.1 MB
  144. 12. An introduction to the Days methodology.srt 1.8 KB
  145. 12.1 Working Capital Days.pptx 94.8 KB
  146. 13. Calculation of DSO, DPO and DOI for the historical period.mp4 12.1 MB
  147. 13. Calculation of DSO, DPO and DOI for the historical period.srt 1.4 KB
  148. 13.1 12. Days calculation_before.xlsm 51.2 KB
  149. 13.2 12. Days calculation_after.xlsm 51.5 KB
  150. 14. Forecasting DSO, DPO and DOI.mp4 20.9 MB
  151. 14. Forecasting DSO, DPO and DOI.srt 2.5 KB
  152. 14.1 13. Forecasting DSO, DPO, DIO_before.xlsm 51.5 KB
  153. 14.2 13. Forecasting DSO, DPO, DIO_after.xlsm 52.0 KB
  154. 15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4 22.6 MB
  155. 15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.srt 2.8 KB
  156. 15.1 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm 52.0 KB
  157. 15.2 14. Forecasting PP&E, Other assets, and Other liabilities_after.xlsm 52.9 KB
  158. 16. Creating an output P&L sheet.mp4 18.8 MB
  159. 16. Creating an output P&L sheet.srt 2.4 KB
  160. 16.1 15. P&L structure_before.xlsm 53.6 KB
  161. 16.2 15. P&L structure_after.xlsm 53.7 KB
  162. 17. Populating the output P&L sheet.mp4 25.5 MB
  163. 17. Populating the output P&L sheet.srt 2.5 KB
  164. 17.1 16. Populating the P&L sheet_after.xlsm 55.3 KB
  165. 17.2 16. Populating the P&L sheet_before.xlsm 53.7 KB
  166. 18. Populating the output BS sheet.mp4 16.9 MB
  167. 18. Populating the output BS sheet.srt 1.8 KB
  168. 18.1 17. Populating BS sheet_after.xlsm 57.2 KB
  169. 18.2 17. Populating BS sheet_before.xlsm 55.3 KB
  170. 19. Completing the output BS sheet for the historical period.mp4 38.0 MB
  171. 19. Completing the output BS sheet for the historical period.srt 4.0 KB
  172. 19.1 18. Completing the Balance Sheet_before.xlsm 57.2 KB
  173. 19.2 18. Completing the Balance Sheet_after.xlsm 58.1 KB
  174. 2. Introduction to the DCF exercise.mp4 7.9 MB
  175. 2. Introduction to the DCF exercise.srt 1.3 KB
  176. 20. Creating a structure for the calculation of Unlevered free cash flows.mp4 22.8 MB
  177. 20. Creating a structure for the calculation of Unlevered free cash flows.srt 3.2 KB
  178. 20.1 19. Cash flow structure_before.xlsm 58.5 KB
  179. 20.2 19. Cash flow structure_after.xlsm 58.6 KB
  180. 21. Bridging Unlevered free cash flow to Net cash flow.mp4 14.6 MB
  181. 21. Bridging Unlevered free cash flow to Net cash flow.srt 2.0 KB
  182. 21.1 20. Bridge UFCF to Net cash flow_after.xlsm 58.7 KB
  183. 21.2 20. Bridge UFCF to Net cash flow_before.xlsm 58.6 KB
  184. 22. Calculating Unlevered free cash flow.mp4 59.7 MB
  185. 22. Calculating Unlevered free cash flow.srt 6.6 KB
  186. 22.1 21. Calculating UFCF_before.xlsm 58.7 KB
  187. 22.2 21. Calculating UFCF_after.xlsm 59.2 KB
  188. 23. Calculating Net cash flow.mp4 37.9 MB
  189. 23. Calculating Net cash flow.srt 4.3 KB
  190. 23.1 22. Calculating Net Cash Flow_before.xlsm 59.2 KB
  191. 23.2 22. Calculating Net Cash Flow_after.xlsm 59.4 KB
  192. 23.3 Cash Flow Classification By Activities.xlsx 55.9 KB
  193. 24. Obtaining the rest of the cash flows through Find and Replace.mp4 46.7 MB
  194. 24. Obtaining the rest of the cash flows through Find and Replace.srt 4.4 KB
  195. 24.1 23. Find and replace_before.xlsm 59.5 KB
  196. 24.2 23. Find and replace_after.xlsm 62.5 KB
  197. 25. Introducing Weighted average cost of capital and Perpetuity growth.mp4 13.2 MB
  198. 25. Introducing Weighted average cost of capital and Perpetuity growth.srt 2.4 KB
  199. 25.1 24. Introducing WACC and g_before.xlsm 62.5 KB
  200. 25.2 24. Introducing WACC and g_after.xlsm 62.6 KB
  201. 26. Discounting Unlevered free cash flows to obtain their Present value.mp4 20.2 MB
  202. 26. Discounting Unlevered free cash flows to obtain their Present value.srt 3.2 KB
  203. 26.1 25. Calculating PV of Cash Flows_before.xlsm 62.6 KB
  204. 26.2 25. Calculating PV of Cash Flows_after.xlsm 62.7 KB
  205. 27. Calculating Continuing value and Enterprise value of the business.mp4 17.7 MB
  206. 27. Calculating Continuing value and Enterprise value of the business.srt 2.6 KB
  207. 27.1 26. Calculating CV and EV_before.xlsm 62.7 KB
  208. 27.2 26. Calculating CV and EV_after.xlsm 63.1 KB
  209. 28. Calculating Equity value.mp4 12.2 MB
  210. 28. Calculating Equity value.srt 1.7 KB
  211. 28.1 27. Calculating equity value_before.xlsm 63.1 KB
  212. 28.2 27. Calculating equity value_after.xlsm 63.3 KB
  213. 29. Sensitivity analysis for WACC and perpetuity growth.mp4 40.5 MB
  214. 29. Sensitivity analysis for WACC and perpetuity growth.srt 4.6 KB
  215. 29.1 28. Sensitivity analysis_before.xlsm 63.3 KB
  216. 29.2 28. Sensitivity analysis_after.xlsm 64.8 KB
  217. 29.3 Sensitivity Analysis.xlsx 60.8 KB
  218. 3. The stages of a complete DCF Valuation.mp4 49.2 MB
  219. 3. The stages of a complete DCF Valuation.srt 7.3 KB
  220. 3.1 Valuation exercise.pdf 411.8 KB
  221. 30. A possible application of Goal seek.mp4 15.6 MB
  222. 30. A possible application of Goal seek.srt 2.0 KB
  223. 30.1 29. Goal seek_before.xlsm 64.8 KB
  224. 30.2 29. Goal seek_ater.xlsm 64.8 KB
  225. 31. Using charts to summarize the results of the DCF model.mp4 32.9 MB
  226. 31. Using charts to summarize the results of the DCF model.srt 5.5 KB
  227. 31.1 30. Charts.xlsm 101.2 KB
  228. 32. You made it!.mp4 11.3 MB
  229. 32. You made it!.srt 2.8 KB
  230. 4. Description of the structure of the DCF model.mp4 18.5 MB
  231. 4. Description of the structure of the DCF model.srt 3.3 KB
  232. 4.1 3. Structure of the DCF model.xlsm 47.9 KB
  233. 4.2 DCF Model structure.pdf 240.8 KB
  234. 5. A glimpse at the company we are valuing - Cheeseco.mp4 15.7 MB
  235. 5. A glimpse at the company we are valuing - Cheeseco.srt 1.4 KB
  236. 5.1 Cheeseco.pptx 80.1 KB
  237. 6. Modeling the top line.mp4 26.3 MB
  238. 6. Modeling the top line.srt 4.0 KB
  239. 6.1 5. Modeling revenues_after.xlsm 48.2 KB
  240. 6.2 5. Modeling revenues_before.xlsm 47.9 KB
  241. 7. Introducing scenarios to the model with Choose.mp4 17.8 MB
  242. 7. Introducing scenarios to the model with Choose.srt 2.6 KB
  243. 7.1 6. Choose_before.xlsm 48.2 KB
  244. 7.2 6. Choose_after.xlsm 48.4 KB
  245. 8. Modeling other items Other revenues and Cogs.mp4 44.6 MB
  246. 8. Modeling other items Other revenues and Cogs.srt 4.5 KB
  247. 8.1 7. Other revenues and Cogs_after.xlsm 50.1 KB
  248. 8.2 7. Other revenues and Cogs_before.xlsm 48.4 KB
  249. 9. Modeling other items Operating expenses and D&A.mp4 26.3 MB
  250. 9. Modeling other items Operating expenses and D&A.srt 2.8 KB
  251. 9.1 8. Opex and D&A_before.xlsm 50.1 KB
  252. 9.2 8. Opex and D&A_after.xlsm 50.6 KB
  253. 1. Organizing external inputs in a 'Drivers' sheet.mp4 31.0 MB
  254. 1. Organizing external inputs in a 'Drivers' sheet.srt 4.4 KB
  255. 1.1 Tesla Company Valuation - Detailed walkthrough.pdf 5.1 MB
  256. 1.2 Tesla 2015.pdf 1.3 MB
  257. 1.3 0a. Drivers_before.xlsx 1.3 MB
  258. 1.4 Tesla 2016.pdf 2.2 MB
  259. 1.5 0a. Drivers_after.xlsx 1.3 MB
  260. 1.6 Tesla 2017.pdf 2.5 MB
  261. 1.7 Tesla 2018 Q2.pdf 635.1 KB
  262. 10. Forecasting 'energy' and 'services' revenue.mp4 25.3 MB
  263. 10. Forecasting 'energy' and 'services' revenue.srt 3.1 KB
  264. 10.1 6. Energy and Other revenue - After.xlsx 1.3 MB
  265. 10.2 6. Energy and Other revenue - Before.xlsx 1.3 MB
  266. 11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4 26.8 MB
  267. 11. Calculating 'energy' and 'services' gross profit and cost of sales.srt 2.5 KB
  268. 11.1 7. Energy and Other - Gross profit, cost of sales - After.xlsx 1.4 MB
  269. 11.2 7. Energy and Other - Gross profit, cost of sales - Before.xlsx 1.4 MB
  270. 12. Forecasting operating expenses.mp4 34.9 MB
  271. 12. Forecasting operating expenses.srt 5.4 KB
  272. 12.1 8. Opex - After.xlsx 1.4 MB
  273. 12.2 8. Opex - Before.xlsx 1.4 MB
  274. 13. Building a fixed asset roll forward estimating Capex.mp4 56.6 MB
  275. 13. Building a fixed asset roll forward estimating Capex.srt 6.4 KB
  276. 13.1 9. PP&E forecasting and comparables_before.xlsx 1.4 MB
  277. 13.2 9. PP&E forecasting and comparables_after.xlsx 1.4 MB
  278. 14. Building a fixed asset roll forward D&A schedule.mp4 54.2 MB
  279. 14. Building a fixed asset roll forward D&A schedule.srt 4.4 KB
  280. 14.1 10. PP&E schedule_before.xlsx 1.4 MB
  281. 14.2 10. PP&E schedule_after.xlsx 1.4 MB
  282. 15. Peer comparison D&A as a percentage of revenues.mp4 13.6 MB
  283. 15. Peer comparison D&A as a percentage of revenues.srt 1.6 KB
  284. 15.1 10a. PP&E comparison.xlsx 1.4 MB
  285. 16. FAQ Why model D&A as a % of revenues or as a % of beginning PP&E.html 818 bytes
  286. 17. Calculating DSO, DIO, DPO.mp4 17.5 MB
  287. 17. Calculating DSO, DIO, DPO.srt 2.1 KB
  288. 17.1 11. Working capital forecasting_before.xlsx 1.4 MB
  289. 17.2 11. Working capital forecasting_after.xlsx 1.5 MB
  290. 18. Producing a clean P&L output sheet.mp4 8.4 MB
  291. 18. Producing a clean P&L output sheet.srt 1.6 KB
  292. 18.1 12. P&L.xlsx 1.4 MB
  293. 19. Fill in the P&L output sheet.mp4 18.3 MB
  294. 19. Fill in the P&L output sheet.srt 1.8 KB
  295. 19.1 12a. P&L fill in_before.xlsx 1.4 MB
  296. 19.2 12a. P&L fill in_after.xlsx 1.4 MB
  297. 2. The input data we will work with.mp4 15.8 MB
  298. 2. The input data we will work with.srt 1.7 KB
  299. 2.1 0aa. Inputs_after.xlsx 1.3 MB
  300. 2.2 0aa. Inputs_before.xlsx 1.3 MB
  301. 20. Calculating investments in working capital.mp4 19.0 MB
  302. 20. Calculating investments in working capital.srt 2.2 KB
  303. 20.1 13. Calculating working capital_before.xlsx 1.4 MB
  304. 20.2 13. Calculating working capital_after.xlsx 1.4 MB
  305. 21. Forecasting Unlevered free cash flow.mp4 55.9 MB
  306. 21. Forecasting Unlevered free cash flow.srt 6.1 KB
  307. 21.1 14. Cash flow - UFCF_after.xlsx 1.4 MB
  308. 21.2 14. Cash flow - UFCF_before.xlsx 1.4 MB
  309. 22. Forecasting other assets.mp4 45.2 MB
  310. 22. Forecasting other assets.srt 4.6 KB
  311. 22.1 15. Balance Sheet forecasting assets_before.xlsx 1.4 MB
  312. 22.2 15. Balance Sheet forecasting assets_after.xlsx 1.4 MB
  313. 23. Forecasting other liabilities.mp4 22.0 MB
  314. 23. Forecasting other liabilities.srt 2.4 KB
  315. 23.1 16. Balance Sheet forecasting liabilities_before.xlsx 1.4 MB
  316. 23.2 16. Balance Sheet forecasting liabilities_after.xlsx 1.4 MB
  317. 24. Completing Unlevered free cash flow.mp4 40.9 MB
  318. 24. Completing Unlevered free cash flow.srt 3.7 KB
  319. 24.1 16a. Complete UFCF_before.xlsx 1.4 MB
  320. 24.2 16a. Complete UFCF_after.xlsx 1.4 MB
  321. 25. Modeling Tesla's financing needs in the forecast period.mp4 42.4 MB
  322. 25. Modeling Tesla's financing needs in the forecast period.srt 5.6 KB
  323. 25.1 17. Financing_before.xlsx 1.4 MB
  324. 25.2 17. Financing_after.xlsx 1.4 MB
  325. 26. Calculating Net income.mp4 14.8 MB
  326. 26. Calculating Net income.srt 1.4 KB
  327. 26.1 18. P&L complete_after.xlsx 1.4 MB
  328. 26.2 18. P&L complete_before.xlsx 1.4 MB
  329. 27. Bridging Unlevered free cash flow to Net cash flow.mp4 50.7 MB
  330. 27. Bridging Unlevered free cash flow to Net cash flow.srt 4.5 KB
  331. 27.1 19. Cash flow_complete_after.xlsx 1.4 MB
  332. 27.2 19. Cash flow_complete_before.xlsx 1.4 MB
  333. 28. Balancing the Balance sheet.mp4 13.3 MB
  334. 28. Balancing the Balance sheet.srt 1.2 KB
  335. 28.1 20. Complete the BS_after.xlsx 1.4 MB
  336. 28.2 20. Complete the BS_before.xlsx 1.4 MB
  337. 29. Estimating Weighted average cost of capital (WACC).mp4 44.3 MB
  338. 29. Estimating Weighted average cost of capital (WACC).srt 6.8 KB
  339. 29.1 21. WACC_before.xlsx 1.4 MB
  340. 29.2 21. WACC_after.xlsx 1.4 MB
  341. 3. Forecasting Tesla's expected deliveries.mp4 100.3 MB
  342. 3. Forecasting Tesla's expected deliveries.srt 16.0 KB
  343. 3.1 1. Deliveries_before.xlsx 1.3 MB
  344. 3.2 1. Deliveries_after.xlsx 1.3 MB
  345. 30. Performing discounted cash flow valuation (DCF).mp4 34.9 MB
  346. 30. Performing discounted cash flow valuation (DCF).srt 4.1 KB
  347. 30.1 22. DCF_before.xlsx 1.5 MB
  348. 30.2 22. DCF_after.xlsx 1.4 MB
  349. 31. Calculating enterprise value, equity value, and price per share.mp4 22.6 MB
  350. 31. Calculating enterprise value, equity value, and price per share.srt 2.2 KB
  351. 31.1 23. EV, Equity value, Price per share_after.xlsx 1.4 MB
  352. 31.2 23. EV, Equity value, Price per share_before.xlsx 1.4 MB
  353. 32. Final comments.mp4 44.9 MB
  354. 32. Final comments.srt 4.4 KB
  355. 4. Comparing delivery figures with the ones of industry peers.mp4 20.9 MB
  356. 4. Comparing delivery figures with the ones of industry peers.srt 3.1 KB
  357. 4.1 1a. Deliveries development.xlsx 1.3 MB
  358. 5. Estimating an average selling price of Tesla vehicles.mp4 41.9 MB
  359. 5. Estimating an average selling price of Tesla vehicles.srt 5.2 KB
  360. 5.1 2. Average price_after.xlsx 1.3 MB
  361. 5.2 2. Average price_before.xlsx 1.3 MB
  362. 6. Calculating automotive revenue.mp4 46.6 MB
  363. 6. Calculating automotive revenue.srt 4.9 KB
  364. 6.1 3. Revenue calculation and scenarios - after.xlsx 1.3 MB
  365. 6.2 3. Revenue calculation and scenarios - before.xlsx 1.3 MB
  366. 7. Peer comparison Gross profit %.mp4 17.2 MB
  367. 7. Peer comparison Gross profit %.srt 2.7 KB
  368. 7.1 4. Gross profit automotive.xlsx 1.3 MB
  369. 8. Calculating automotive gross profit.mp4 27.8 MB
  370. 8. Calculating automotive gross profit.srt 2.9 KB
  371. 8.1 4a. Gross profit automotive - after.xlsx 1.3 MB
  372. 8.2 4a. Gross profit automotive - before.xlsx 1.5 MB
  373. 9. Calculating automotive cost of sales.mp4 17.5 MB
  374. 9. Calculating automotive cost of sales.srt 2.3 KB
  375. 9.1 5. Cost of sales and chart.xlsx 1.3 MB
  376. 1. Introduction to Capital budgeting.mp4 5.4 MB
  377. 1. Introduction to Capital budgeting.srt 1.9 KB
  378. 2. Why we need Capital budgeting.mp4 6.9 MB
  379. 2. Why we need Capital budgeting.srt 2.7 KB
  380. 3. The time value of money.mp4 6.7 MB
  381. 3. The time value of money.srt 2.8 KB
  382. 4. Calculating future and present value.mp4 13.1 MB
  383. 4. Calculating future and present value.srt 6.7 KB
  384. 5. Calculating cost of equity.mp4 19.2 MB
  385. 5. Calculating cost of equity.srt 8.0 KB
  386. 6. Coming up with project-specific beta.mp4 9.0 MB
  387. 6. Coming up with project-specific beta.srt 3.8 KB
  388. 7. Weighted average cost of capital (WACC).mp4 5.5 MB
  389. 7. Weighted average cost of capital (WACC).srt 2.5 KB
  390. 8. The type of cash flows we will have in a project.mp4 9.3 MB
  391. 8. The type of cash flows we will have in a project.srt 4.2 KB
  392. 9. Estimating the project's cash flows.mp4 18.8 MB
  393. 9. Estimating the project's cash flows.srt 7.1 KB
  394. 1. Introduction to the Capital budgeting exercise.mp4 8.6 MB
  395. 1. Introduction to the Capital budgeting exercise.srt 3.4 KB
  396. 10. Finding cost of equity.mp4 13.9 MB
  397. 10. Finding cost of equity.srt 7.6 KB
  398. 10.1 8. WACC.xlsx 38.0 KB
  399. 10.2 8. WACC_unsolved.xlsx 35.9 KB
  400. 11. Discounting the project's cash flows and residual value.mp4 25.9 MB
  401. 11. Discounting the project's cash flows and residual value.srt 3.8 KB
  402. 11.1 9. Discounted cash flow_unsolved.xlsx 38.7 KB
  403. 11.2 9. Discounted cash flow.xlsx 39.7 KB
  404. 12. Performing sensitivity analysis and completing the exercise.mp4 43.0 MB
  405. 12. Performing sensitivity analysis and completing the exercise.srt 5.6 KB
  406. 12.1 10. Sensitivity analysis_unsolved.xlsx 39.7 KB
  407. 12.2 10. Sensitivity analysis.xlsx 40.7 KB
  408. 13. FAQ Data does not change in the DCF sheet, it changes from the Drivers sheet.html 378 bytes
  409. 14. Build a complete capital budgeting model from scratch.html 170 bytes
  410. 15. Congratulations!!.mp4 2.3 MB
  411. 15. Congratulations!!.srt 1.6 KB
  412. 2. Organizing an Inputs sheet.mp4 11.1 MB
  413. 2. Organizing an Inputs sheet.srt 6.6 KB
  414. 2.1 1. Drivers.xlsx 11.5 KB
  415. 3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4 9.2 MB
  416. 3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.srt 4.3 KB
  417. 3.1 2. Savings Forecast_unsolved.xlsx 14.7 KB
  418. 3.2 2. Savings Forecast.xlsx 16.6 KB
  419. 4. Fixed asset rollforward.mp4 12.2 MB
  420. 4. Fixed asset rollforward.srt 5.6 KB
  421. 4.1 3. Fixed Asset Rollforward_unsolved.xlsx 18.5 KB
  422. 4.2 3. Fixed Asset Rollforward.xlsx 19.7 KB
  423. 5. The impact of working capital.mp4 5.4 MB
  424. 5. The impact of working capital.srt 3.0 KB
  425. 5.1 4. Working Capital.xlsx 21.9 KB
  426. 5.2 4. Working Capital_unsolved.xlsx 21.2 KB
  427. 6. Modeling debt financing.mp4 6.2 MB
  428. 6. Modeling debt financing.srt 3.4 KB
  429. 6.1 5. Financing.xlsx 31.0 KB
  430. 6.2 5. Financing_unsolved.xlsx 30.0 KB
  431. 7. Adding a P&L sheet.mp4 4.9 MB
  432. 7. Adding a P&L sheet.srt 2.2 KB
  433. 7.1 6. P&L.xlsx 31.0 KB
  434. 7.2 6. P&L_unsolved.xlsx 29.7 KB
  435. 8. Calculating project cash flows.mp4 10.1 MB
  436. 8. Calculating project cash flows.srt 4.0 KB
  437. 8.1 7. Cash flow_unsolved.xlsx 29.6 KB
  438. 8.2 7. Cash flow.xlsx 31.4 KB
  439. 9. Estimating the weighted average cost of capital (WACC).mp4 5.6 MB
  440. 9. Estimating the weighted average cost of capital (WACC).srt 3.5 KB
  441. 9.1 8. WACC_unsolved.xlsx 35.9 KB
  442. 9.2 8. WACC.xlsx 38.0 KB
  443. 1. Introduction to Excel.mp4 2.0 MB
  444. 1. Introduction to Excel.srt 925 bytes
  445. 10. Introduction to Excel formulas.html 167 bytes
  446. 11. Introduction to Excel functions.mp4 18.7 MB
  447. 11. Introduction to Excel functions.srt 4.0 KB
  448. 11.1 13. Functions- Exercise_after.xlsx 81.1 KB
  449. 11.2 13. Functions - Lecture_after.xlsx 9.3 KB
  450. 11.3 13. Functions- Lecture_before.xlsx 9.2 KB
  451. 11.4 13. Functions-Exercise_before.xlsx 13.3 KB
  452. 11.5 Introduction to Excel.pdf 2.0 MB
  453. 12. Cut, copy, & paste.mp4 13.0 MB
  454. 12. Cut, copy, & paste.srt 2.3 KB
  455. 12.1 14. Copy-Cut-Paste-Exercise_after.xlsx 12.6 KB
  456. 12.2 Introduction to Excel.pdf 2.0 MB
  457. 12.3 14. Copy-Cut-Paste-Exercise_before.xlsx 11.3 KB
  458. 13. Cut, copy, & paste.html 167 bytes
  459. 14. Paste special.mp4 10.9 MB
  460. 14. Paste special.srt 1.4 KB
  461. 14.1 15. Paste-Special-Exercise_after.xlsx 13.5 KB
  462. 14.2 15. Paste-Special-Exercise_before.xlsx 13.5 KB
  463. 14.3 Introduction to Excel.pdf 2.0 MB
  464. 15. Format cells.mp4 29.1 MB
  465. 15. Format cells.srt 6.5 KB
  466. 15.1 10. Format cells_before.xlsx 9.8 KB
  467. 15.2 10. Format cells_after.xlsx 9.8 KB
  468. 16. Basic operations in Excel - 38 pages.html 171 bytes
  469. 2. Overview of Excel.mp4 20.7 MB
  470. 2. Overview of Excel.srt 4.0 KB
  471. 2.1 7. Overview-of-Excel-Exercise_before.xlsx 10.5 KB
  472. 2.2 7. Overview-of-Excel-Exercise_after.xlsx 10.9 KB
  473. 2.3 Introduction to Excel.pdf 2.0 MB
  474. 3. Overview of Excel.html 167 bytes
  475. 4. The Excel ribbon.mp4 13.6 MB
  476. 4. The Excel ribbon.srt 2.7 KB
  477. 4.1 Introduction to Excel.pdf 2.0 MB
  478. 4.2 8. The-Ribbon-Exercise_before.xlsx 12.1 KB
  479. 4.3 8. The-Ribbon-Exercise_after.xlsx 403.2 KB
  480. 5. Basic operations with rows and columns.mp4 11.2 MB
  481. 5. Basic operations with rows and columns.srt 1.9 KB
  482. 5.1 9. Basic Manipulations - Lecture.xlsx 8.1 KB
  483. 5.2 9. Basic-Manipulations - Exercise_before.xlsx 11.1 KB
  484. 5.3 9. Basic-Manipulations - Exercise_after.xlsx 32.4 KB
  485. 5.4 Introduction to Excel.pdf 2.0 MB
  486. 6. Data entry in Excel.mp4 16.0 MB
  487. 6. Data entry in Excel.srt 3.4 KB
  488. 6.1 10. Data-Entry-Exercise_before.xlsx 11.0 KB
  489. 6.2 10. Data-Entry - Lecture.xlsx 8.1 KB
  490. 6.3 Introduction to Excel.pdf 2.0 MB
  491. 6.4 10. Data-Entry- Exercise_after.xlsx 32.8 KB
  492. 7. Introduction to formatting.mp4 38.2 MB
  493. 7. Introduction to formatting.srt 5.9 KB
  494. 7.1 11. Formatting - Lecture_after.xlsx 9.8 KB
  495. 7.2 11. Formatting- Lecture_before.xlsx 8.9 KB
  496. 7.3 Introduction to Excel.pdf 2.0 MB
  497. 7.4 11. Formatting-Exercise_before.xlsx 21.6 KB
  498. 7.5 11. Formatting- Exercise_after.xlsx 11.6 KB
  499. 8. Rows and columns.html 167 bytes
  500. 9. Introduction to Excel formulas.mp4 20.7 MB
  501. 9. Introduction to Excel formulas.srt 42.2 MB
  502. 9.1 12. Formulas- Exercise_after.xlsx 80.1 KB
  503. 9.2 12. Formulas- Lecture_after.xlsx 9.4 KB
  504. 9.3 12. Formulas - Exercise_before.xlsx 11.7 KB
  505. 9.4 12. Formulas- Lecture_before.xlsx 9.3 KB
  506. 9.5 Introduction to Excel.pdf 2.0 MB
  507. 1. Next steps.html 2.3 KB
  508. [CourseClub.Me].url 48 bytes
  509. [DesireCourse.Net].url 51 bytes
  510. 1. Overview of Excel.mp4 41.2 MB
  511. 1. Overview of Excel.srt 4.1 KB
  512. 1.1 7. Overview-of-Excel-Exercise-Solved.xlsx 10.9 KB
  513. 1.2 7. Introduction to Excel.pdf 2.3 MB
  514. 1.3 7. Overview-of-Excel-Exercise-Unsolved.xlsx 10.5 KB
  515. 2. Basic manipulations with rows and columns.mp4 20.4 MB
  516. 2. Basic manipulations with rows and columns.srt 2.1 KB
  517. 2.1 8. Basic manipulations - Lecture.xlsx 8.1 KB
  518. 2.2 8. Basic-Manipulations - Exercise - Solved.xlsx 32.4 KB
  519. 2.3 8. Basic-Manipulations - Exercise - Unsolved.xlsx 11.1 KB
  520. 3. The Excel ribbon.mp4 28.9 MB
  521. 3. The Excel ribbon.srt 3.2 KB
  522. 3.1 9. The-Ribbon-Exercise-Solved.xlsx 403.2 KB
  523. 3.2 9. The-Ribbon-Exercise-Exercise - Unsolved.xlsx 12.1 KB
  524. 4. Data entry in Excel.mp4 31.5 MB
  525. 4. Data entry in Excel.srt 3.5 KB
  526. 4.1 10. Data-Entry-Exercise - Unsolved.xlsx 11.0 KB
  527. 4.2 10. Data-Entry - Lecture.xlsx 8.1 KB
  528. 4.3 10. Data-Entry- Exercise -Solved.xlsx 32.8 KB
  529. 5. Introduction to formatting.mp4 75.4 MB
  530. 5. Introduction to formatting.srt 6.6 KB
  531. 5.1 11. Formatting - Lecture - Solved.xlsx 9.8 KB
  532. 5.2 11. Formatting-Exercise - Unsolved.xlsx 11.6 KB
  533. 5.3 11. Formatting- Exercise - Solved.xlsx 11.6 KB
  534. 5.4 11. Formatting- Lecture - Unsolved.xlsx 8.9 KB
  535. 6. Introduction to Excel formulas.mp4 18.8 MB
  536. 6. Introduction to Excel formulas.srt 4.3 KB
  537. 6.1 12. Formulas - Exercise - Unsolved.xlsx 11.7 KB
  538. 6.2 12. Formulas- Lecture - Unsolved.xlsx 9.3 KB
  539. 6.3 Introduction-to-Excels-basic-features.pdf 2.3 MB
  540. 6.4 12. Formulas- Exercise - Solved.xlsx 80.1 KB
  541. 6.5 12. Formulas- Lecture - Solved.xlsx 9.4 KB
  542. 7. Introduction to Excel functions.mp4 37.1 MB
  543. 7. Introduction to Excel functions.srt 4.7 KB
  544. 7.1 13. Functions- Lecture - Unsolved.xlsx 9.2 KB
  545. 7.2 13. Functions-Exercise - Unsolved.xlsx 13.3 KB
  546. 7.3 13. Functions- Exercise - Solved.xlsx 81.1 KB
  547. 7.4 13. Functions - Lecture -Solved.xlsx 9.3 KB
  548. 7.5 Introduction-to-Excels-basic-features.pdf 2.3 MB
  549. 8. Cut, copy, & paste.mp4 7.6 MB
  550. 8. Cut, copy, & paste.srt 2.4 KB
  551. 8.1 Introduction-to-Excels-basic-features.pdf 2.3 MB
  552. 8.2 14. Copy-Cut-Paste-Exercise - Unsolved.xlsx 11.3 KB
  553. 8.3 14. Copy-Cut-Paste-Exercise - Solved.xlsx 12.6 KB
  554. 9. Paste special.mp4 6.7 MB
  555. 9. Paste special.srt 1.6 KB
  556. 9.1 Introduction-to-Excels-basic-features.pdf 2.3 MB
  557. 9.2 15. Paste-Special-Exercise - Solved.xlsx 13.5 KB
  558. 9.3 15. Paste-Special-Exercise - Unsolved.xlsx 13.5 KB
  559. 1. Initial formatting of an Excel sheet to render it professional.mp4 8.0 MB
  560. 1. Initial formatting of an Excel sheet to render it professional.srt 2.3 KB
  561. 1.1 18. Formatting-a-Worksheet-Exercise - Unsolved.xlsx 10.6 KB
  562. 1.2 18. Formatting-a-Worksheet-Exercise - Solved.xlsx 10.8 KB
  563. 1.3 18. Formatting-a-worksheet-Lecture - Solved.xlsx 9.6 KB
  564. 1.4 18. Formatting-a-worksheet-Lecture - Unsolved.xlsx 9.0 KB
  565. 1.5 Useful-Tips-Tools.pdf 3.3 MB
  566. 10. Find and select special types of cells with Select Special (F5).mp4 9.8 MB
  567. 10. Find and select special types of cells with Select Special (F5).srt 2.0 KB
  568. 10.1 26. Select-Special-F5-Exercise - Solved.xlsx 22.3 KB
  569. 10.2 Useful-Tips-Tools.pdf 3.3 MB
  570. 10.3 26. Select-Special-Lecture.xlsx 10.6 KB
  571. 10.4 26. Select-Special-F5-Exercise - Unsolved.xlsx 21.6 KB
  572. 11. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4 5.4 MB
  573. 11. Assign custom formats to specific cells within a financial model (e.g Multiples).srt 2.0 KB
  574. 11.1 Useful-Tips-Tools.pdf 3.3 MB
  575. 11.2 29. Assigning Custom Formats - Exercise - Solved.xlsx 11.1 KB
  576. 11.3 29. Assigning Custom Formats - Exercise - Unsolved.xlsx 11.4 KB
  577. 12. Define a named range in Excel.mp4 5.4 MB
  578. 12. Define a named range in Excel.srt 1.7 KB
  579. 12.1 28. Naming-ranges-Lecture - Unsolved.xlsx 8.8 KB
  580. 12.2 Useful-Tips-Tools.pdf 3.3 MB
  581. 12.3 28. Defining-a-Named-Range-Exercise - Solved.xlsx 11.7 KB
  582. 12.4 28. Naming-ranges-Lecture - Solved.xlsx 10.3 KB
  583. 12.5 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx 11.1 KB
  584. 13. Learn how to organize your data with Text to Columns.mp4 12.5 MB
  585. 13. Learn how to organize your data with Text to Columns.srt 2.3 KB
  586. 13.1 Useful-Tips-Tools.pdf 3.3 MB
  587. 13.2 23. Text-to-Columns-Exercise - Unsolved.xlsx 10.6 KB
  588. 13.3 23. Text-to-Columns-Exercise - Solved.xlsx 11.3 KB
  589. 13.4 23.Text-to-columns-Lecture - Solved.xlsx 9.9 KB
  590. 13.5 23. Text-to-columns-Lecture - Unsolved.xlsx 9.8 KB
  591. 14. Learn how to assign dynamic names within a financial model.mp4 7.3 MB
  592. 14. Learn how to assign dynamic names within a financial model.srt 1.6 KB
  593. 14.1 27. Assigning-Dynamic-Names-Exercise - Solved.xlsx 11.7 KB
  594. 14.2 Useful-Tips-Tools.pdf 3.3 MB
  595. 14.3 27. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx 11.2 KB
  596. 14.4 27. Dynamic-Naming-Lecture - Solved.xlsx 13.8 KB
  597. 14.5 27. Dynamic-Naming-Lecture - Unsolved.xlsx 13.5 KB
  598. 15. Create easily printable documents in Excel by using Set Print Area.mp4 4.7 MB
  599. 15. Create easily printable documents in Excel by using Set Print Area.srt 1.6 KB
  600. 15.1 25. Set-Print-Area-Lecture - Solved.xlsx 11.2 KB
  601. 15.2 Useful-Tips-Tools.pdf 3.3 MB
  602. 15.3 25. Set-Print-Area-Lecture - Unsolved.xlsx 11.4 KB
  603. 16. Using the 'Alt + Enter' combination.mp4 3.3 MB
  604. 16. Using the 'Alt + Enter' combination.srt 1.0 KB
  605. 16.1 22. Alt-Enter-Exercise - Unsolved.xlsx 11.1 KB
  606. 16.2 22. Alt-Enter-Exercise - Solved.xlsx 11.4 KB
  607. 16.3 22. Alt-Enter- Lecture - Solved.xlsx 9.6 KB
  608. 16.4 22. Alt-Enter- Lecture - Unsolved.xlsx 9.6 KB
  609. 2. Fast scrolling through Excel sheets.mp4 22.2 MB
  610. 2. Fast scrolling through Excel sheets.srt 1.8 KB
  611. 2.1 19. Fast-Scrolling-Exercise - Unsolved.xlsx 43.9 KB
  612. 2.2 19. Fast-Scrolling - Lecture.xlsx 642.8 KB
  613. 2.3 Useful-Tips-Tools.pdf 3.3 MB
  614. 2.4 19. Fast-Scrolling-Exercise - Solved.xlsx 44.4 KB
  615. 3. Introduction to fixing of cell references.mp4 20.4 MB
  616. 3. Introduction to fixing of cell references.srt 2.7 KB
  617. 3.1 21. Fixing-references-Lecture - Unsolved.xlsx 644.0 KB
  618. 3.2 21. Fixing-Cells-Exercise - Solved.xlsx 10.8 KB
  619. 3.3 21. Fixing-references-Lecture - Solved.xlsx 645.2 KB
  620. 3.4 Useful-Tips-Tools.pdf 3.3 MB
  621. 3.5 21. Fixing-Cells-Exercise - Unsolved.xlsx 10.7 KB
  622. 4. Learn how to use the Wrap Text button.mp4 2.1 MB
  623. 4. Learn how to use the Wrap Text button.srt 903 bytes
  624. 4.1 24. Wrap-Text-Exercise - Solved.xlsx 10.2 KB
  625. 4.2 Useful-Tips-Tools.pdf 3.3 MB
  626. 4.3 24. Wrap-Text-Exercise - Unsolved.xlsx 10.2 KB
  627. 4.4 24. Wrap-text-Lecture - Solved.xlsx 9.6 KB
  628. 4.5 24. Wrap-text-Lecture - Unsolved.xlsx 9.6 KB
  629. 5. Create a drop-down list by using Data Validation.mp4 10.6 MB
  630. 5. Create a drop-down list by using Data Validation.srt 2.2 KB
  631. 5.1 Useful-Tips-Tools.pdf 3.3 MB
  632. 5.2 32. Drop-down-List-Exercise - Unsolved.xlsx 11.3 KB
  633. 5.3 32. Data-Validation-Lecture - Unsolved.xlsx 10.8 KB
  634. 5.4 32. Drop-down-List-Exercise - Solved.xlsx 77.0 KB
  635. 5.5 32. Data-Validation-Lecture - Solved.xlsx 10.8 KB
  636. 6. Using Custom-sort in order to sort multiple columns within a table.mp4 9.1 MB
  637. 6. Using Custom-sort in order to sort multiple columns within a table.srt 1.7 KB
  638. 6.1 33. Custom-Sort-Exercise - Unsolved.xlsx 11.4 KB
  639. 6.2 33. Sort-data-Lecture - Unsolved.xlsx 145.3 KB
  640. 6.3 33. Sort-data-Lecture - Solved.xlsx 145.6 KB
  641. 6.4 33. Custom-Sort-Exercise - Solved.xlsx 11.5 KB
  642. 6.5 Useful-Tips-Tools.pdf 3.3 MB
  643. 7. Create a great Index page at the beginning of your models - Hyperlinks.mp4 5.4 MB
  644. 7. Create a great Index page at the beginning of your models - Hyperlinks.srt 1.6 KB
  645. 7.1 34. Hyperlinks-Exercise - Solved.xlsx 137.1 KB
  646. 7.2 Useful-Tips-Tools.pdf 3.3 MB
  647. 7.3 34. Hyperlinks-Exercise - Unsolved.xlsx 136.9 KB
  648. 8. Fix the top row of your table with Freeze Panes.mp4 17.7 MB
  649. 8. Fix the top row of your table with Freeze Panes.srt 1.5 KB
  650. 8.1 Useful-Tips-Tools.pdf 3.3 MB
  651. 8.2 35. Freeze-Panes-Lecture - Unsolved.xlsx 643.9 KB
  652. 8.3 35. Freeze-Panes-Lecture - Solved.xlsx 643.9 KB
  653. 9. Macros are a great timesaver! Here's why!.mp4 11.1 MB
  654. 9. Macros are a great timesaver! Here's why!.srt 3.6 KB
  655. 9.1 Useful-Tips-Tools.pdf 3.3 MB
  656. 9.2 30. Macros-Exercise - Solved.xlsx 145.0 KB
  657. 9.3 30. Macros-Exercise - Unsolved.xlsx 10.3 KB
  658. 9.4 30. Creating-a-Macro-Lecture - Unsolved.xlsx 9.7 KB
  659. 9.5 30. Creating-a-Macro-Lecture - Solved.xlsx 11.2 KB
  660. 1. Keyboard shortcuts Save LOTS of time in Excel 2010.mp4 30.4 MB
  661. 1. Keyboard shortcuts Save LOTS of time in Excel 2010.srt 5.5 KB
  662. 1. Excel best practices - Welcome lecture.mp4 2.1 MB
  663. 1. Excel best practices - Welcome lecture.srt 1.0 KB
  664. 1.1 Useful Tips & Tools.pdf 3.1 MB
  665. 10. Learn how to organize your data with text to columns.html 167 bytes
  666. 11. The wrap text button.mp4 3.7 MB
  667. 11. The wrap text button.srt 914 bytes
  668. 11.1 Wrap-text-Lecture - Solved.xlsx 9.6 KB
  669. 11.2 Wrap-Text-Exercise - Solved.xlsx 10.2 KB
  670. 11.3 Wrap-text-Lecture - Unsolved.xlsx 9.6 KB
  671. 11.4 Wrap-Text-Exercise - Unsolved.xlsx 10.2 KB
  672. 12. Set print area.mp4 7.6 MB
  673. 12. Set print area.srt 1.5 KB
  674. 12.1 Set-Print-Area-Lecture - Solved.xlsx 11.2 KB
  675. 12.2 Set-Print-Area-Lecture - Unsolved.xlsx 11.8 KB
  676. 13. Custom sort helps you sort multiple columns in Excel tables.mp4 11.2 MB
  677. 13. Custom sort helps you sort multiple columns in Excel tables.srt 1.7 KB
  678. 13.1 Custom-Sort-Exercise - Solved.xlsx 11.5 KB
  679. 13.2 Custom-Sort-Exercise - Unsolved.xlsx 11.4 KB
  680. 13.3 Sort-data-Lecture - Unsolved.xlsx 145.3 KB
  681. 13.4 Sort-data-Lecture - Solved.xlsx 145.6 KB
  682. 14. Create drop-down lists with data validation.mp4 14.1 MB
  683. 14. Create drop-down lists with data validation.srt 1.9 KB
  684. 14.1 Data-Validation-Lecture - Solved.xlsx 11.3 KB
  685. 14.2 Drop-down-List-Exercise - Solved.xlsx 77.0 KB
  686. 14.3 Data-Validation-Lecture - Unsolved.xlsx 11.2 KB
  687. 14.4 Drop-down-List-Exercise - Unsolved.xlsx 11.3 KB
  688. 15. Find and select special types of cells with Select special (F5).mp4 13.9 MB
  689. 15. Find and select special types of cells with Select special (F5).srt 1.7 KB
  690. 15.1 Select-Special-Lecture-Solved.xlsx 10.9 KB
  691. 15.2 Select-Special-F5-Exercise - Unsolved.xlsx 21.6 KB
  692. 15.3 Select-Special-F5-Exercise - Solved.xlsx 22.3 KB
  693. 15.4 Select-Special-Lecture.xlsx 10.6 KB
  694. 16. Select Special.html 167 bytes
  695. 17. Assign dynamic names in a financial model.mp4 7.7 MB
  696. 17. Assign dynamic names in a financial model.srt 1.5 KB
  697. 17.1 Dynamic-Naming-Lecture - Unsolved.xlsx 13.7 KB
  698. 17.2 Dynamic-Naming-Lecture - Solved.xlsx 12.4 KB
  699. 17.3 Assigning-Dynamic-Names-Exercise - Unsolved.xlsx 11.2 KB
  700. 17.4 Assigning-Dynamic-Names-Exercise - Solved.xlsx 11.7 KB
  701. 18. Assigning dynamic names.html 167 bytes
  702. 19. Define a named range in Excel.mp4 7.7 MB
  703. 19. Define a named range in Excel.srt 1.8 KB
  704. 19.1 28. Defining-a-Named-Range-Exercise - Solved.xlsx 11.7 KB
  705. 19.2 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx 11.1 KB
  706. 19.3 28. Naming-ranges-Lecture - Unsolved.xlsx 8.8 KB
  707. 19.4 28. Naming-ranges-Lecture - Solved.xlsx 10.3 KB
  708. 2. Initial formatting of Excel sheets for a professional layout.mp4 11.6 MB
  709. 2. Initial formatting of Excel sheets for a professional layout.srt 2.3 KB
  710. 2.1 Useful Tips & Tools.pdf 3.1 MB
  711. 2.2 Formatting-a-Worksheet-Exercise - Solved.xlsx 10.8 KB
  712. 2.3 Formatting-a-worksheet-Lecture - Solved.xlsx 9.6 KB
  713. 2.4 Formatting-a-Worksheet-Exercise - Unsolved.xlsx 10.6 KB
  714. 2.5 Formatting-a-worksheet-Lecture - Unsolved.xlsx 9.0 KB
  715. 20. Create a great Index page at the beginning of your models - Hyperlinks.mp4 8.6 MB
  716. 20. Create a great Index page at the beginning of your models - Hyperlinks.srt 1.4 KB
  717. 20.1 Hyperlinks - Lecture - Solved.xlsx 14.3 KB
  718. 20.2 Hyperlinks - Lecture - Unsolved.xlsx 14.2 KB
  719. 20.3 Hyperlinks-Exercise - Solved.xlsx 137.1 KB
  720. 20.4 Hyperlinks-Exercise - Unsolved.xlsx 136.9 KB
  721. 21. Introduction to custom formatting in Excel.mp4 38.0 MB
  722. 21. Introduction to custom formatting in Excel.srt 8.1 KB
  723. 21.1 19. Custom formatting_before.xlsx 10.7 KB
  724. 21.2 19. Custom formatting_after.xlsx 10.8 KB
  725. 22. Apply custom formatting in a financial model.mp4 9.2 MB
  726. 22. Apply custom formatting in a financial model.srt 1.6 KB
  727. 22.1 Assigning Custom Formats - Exercise - Unsolved.xlsx 11.4 KB
  728. 22.2 Custom formats - Lecture - Solved.xlsx 8.8 KB
  729. 22.3 Assigning Custom Formats - Exercise - Solved.xlsx 11.1 KB
  730. 22.4 Custom formats - Lecture - Unsolved.xlsx 8.3 KB
  731. 23. Macros are a great timesaver! Here's why!.mp4 17.2 MB
  732. 23. Macros are a great timesaver! Here's why!.srt 3.1 KB
  733. 23.1 Recording a Macro - Lecture - Solved.ods 3.0 KB
  734. 23.2 Recording a Macro - Lecture - Unsolved.ods 2.6 KB
  735. 24. How to save macros and use them across several workbooks.mp4 12.8 MB
  736. 24. How to save macros and use them across several workbooks.srt 1.7 KB
  737. 24.1 31. Another-file.xlsx 8.8 KB
  738. 24.2 31. How-to-save-macros-Lecture-after.xlsm 12.6 KB
  739. 24.3 31. How-to-save-macros-Lecture-before.xlsx 6.0 KB
  740. 25. Excel macros - quiz.html 167 bytes
  741. 26. Fix the top row of your table with freeze panes.mp4 14.5 MB
  742. 26. Fix the top row of your table with freeze panes.srt 1.3 KB
  743. 26.1 Freeze-Panes-Lecture - Solved.xlsx 644.2 KB
  744. 26.2 Freeze-Panes-Lecture - Unsolved.xlsx 644.2 KB
  745. 27. How to search functionalities in Excel.mp4 7.5 MB
  746. 27. How to search functionalities in Excel.srt 853 bytes
  747. 27.1 Search.xlsx 644.2 KB
  748. 28. Filter by color - an excellent tool.mp4 9.9 MB
  749. 28. Filter by color - an excellent tool.srt 2.2 KB
  750. 28.1 36. Exercise-Filter-by-Color-Solved.xlsx 153.5 KB
  751. 28.2 36. Exercise-Filter-by-Color-Unsolved.xlsx 20.5 KB
  752. 29. Working with conditional formatting.mp4 15.1 MB
  753. 29. Working with conditional formatting.srt 6.1 KB
  754. 29.1 Exercise_Conditional Formatting.xlsx 12.9 KB
  755. 29.2 Conditional Formatting - Lecture.xlsx 12.5 KB
  756. 29.3 Solution_Conditional Formatting.xlsx 51.5 KB
  757. 3. Fast scrolling through Excel sheets.mp4 17.5 MB
  758. 3. Fast scrolling through Excel sheets.srt 1.9 KB
  759. 3.1 Fast-Scrolling - Lecture.xlsx 643.7 KB
  760. 3.2 Fast-Scrolling-Exercise - Solved.xlsx 44.4 KB
  761. 3.3 Fast-Scrolling-Exercise - Unsolved.xlsx 43.9 KB
  762. 30. Useful tips and tools for your work in Excel - quiz.html 166 bytes
  763. 31. A neat trick - Multiply by 1.mp4 14.9 MB
  764. 31. A neat trick - Multiply by 1.srt 1.7 KB
  765. 31.1 38. Multiply-by-1-Lecture-before.xlsx 16.5 KB
  766. 31.2 38. Multiply-by-1-Lecture-after.xlsx 17.2 KB
  767. 32. Find and replace - references.mp4 24.0 MB
  768. 32. Find and replace - references.srt 3.5 KB
  769. 32.1 39. Find-and-Replace-references-Lecture-before.xlsx 38.8 KB
  770. 32.2 39. Find-and-Replace-references-Lecture-after.xlsx 37.9 KB
  771. 33. FAQ Why do we replace external references and how does this help us.html 702 bytes
  772. 34. Find and replace - formatting.mp4 13.8 MB
  773. 34. Find and replace - formatting.srt 1.9 KB
  774. 34.1 40. Find-replace-Lecture-after.xlsx 17.2 KB
  775. 34.2 40. Find-replace-Lecture-before.xlsx 17.2 KB
  776. 35. Removing (automatic) green arrows.mp4 12.6 MB
  777. 35. Removing (automatic) green arrows.srt 1.7 KB
  778. 35.1 41. Green-references-Lecture.xlsx 22.0 KB
  779. 36. Beauty saving - The professional way of saving files.mp4 14.0 MB
  780. 36. Beauty saving - The professional way of saving files.srt 2.5 KB
  781. 36.1 42. Beauty-saving-Lecture-after.xlsx 17.0 KB
  782. 36.2 42. Beauty-saving-Lecture-before.xlsx 17.2 KB
  783. 37. Formula auditing with F2.mp4 17.7 MB
  784. 37. Formula auditing with F2.srt 2.2 KB
  785. 37.1 43. F2-Lecture.xlsm 50.8 KB
  786. 4. Fast scrolling through Excel sheets.html 167 bytes
  787. 5. Be even quicker F5 + Enter.mp4 19.8 MB
  788. 5. Be even quicker F5 + Enter.srt 2.2 KB
  789. 5.1 20. F5-go-to - Lecture.xlsm 50.8 KB
  790. 6. Fixing cell references.mp4 24.1 MB
  791. 6. Fixing cell references.srt 2.5 KB
  792. 6.1 Fixing-references-Lecture - Solved.xlsx 644.6 KB
  793. 6.2 Fixing-references-Lecture - Unsolved.xlsx 644.1 KB
  794. 6.3 Fixing-Cells-Exercise - Unsolved.xlsx 10.7 KB
  795. 6.4 Fixing-Cells-Exercise - Solved.xlsx 10.8 KB
  796. 7. Introduction to fixing of cell references.html 167 bytes
  797. 8. Alt + Enter.mp4 4.2 MB
  798. 8. Alt + Enter.srt 961 bytes
  799. 8.1 Alt-Enter-Exercise - Unsolved.xlsx 11.1 KB
  800. 8.2 Alt-Enter- Lecture - Solved.xlsx 10.0 KB
  801. 8.3 Alt-Enter- Lecture - Unsolved.xlsx 9.9 KB
  802. 8.4 Alt-Enter-Exercise - Solved.xlsx 11.4 KB
  803. 9. Organize your data with text to columns.mp4 13.9 MB
  804. 9. Organize your data with text to columns.srt 2.5 KB
  805. 9.1 Text-to-Columns-Exercise - Unsolved.xlsx 10.6 KB
  806. 9.2 Text-to-columns-Lecture - Unsolved.xlsx 9.8 KB
  807. 9.3 Text-to-columns-Lecture - Solved.xlsx 10.2 KB
  808. 9.4 Text-to-Columns-Exercise - Solved.xlsx 11.3 KB
  809. 9.5 Invoice example.pdf 44.5 KB
  810. 1. Keyboard shortcuts save LOTS of time in Excel.mp4 51.2 MB
  811. 1. Keyboard shortcuts save LOTS of time in Excel.srt 5.9 KB
  812. 1.1 Beginner to Pro in Excel - Shortcuts for PC.pdf 1.0 MB
  813. 1.2 Beginner to Pro in Excel - Shortcuts for MAC.pdf 447.6 KB
  814. 2. Keyboard shortcuts in Excel.html 171 bytes
  815. 1. Excel's key functions - Welcome lecture.mp4 2.3 MB
  816. 1. Excel's key functions - Welcome lecture.srt 1.1 KB
  817. 10. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.html 167 bytes
  818. 11. Working with text in Excel.mp4 16.0 MB
  819. 11. Working with text in Excel.srt 3.1 KB
  820. 11.1 53. Work-with-text-Lecture-before.xlsx 10.3 KB
  821. 11.2 53. Work-with-text-Lecture-after.xlsx 10.9 KB
  822. 12. Find the minimum or maximum value in a range of cells in Excel.mp4 5.9 MB
  823. 12. Find the minimum or maximum value in a range of cells in Excel.srt 1.1 KB
  824. 12.1 54. Max-min-Lecture - Unsolved.xlsx 8.9 KB
  825. 12.2 54. MIN-MAX-Exercise - Unsolved.xlsx 14.4 KB
  826. 12.3 54. MIN-MAX-Exercise - Solved.xlsx 14.8 KB
  827. 12.4 54. Max-min-Lecture - Solved.xlsx 9.2 KB
  828. 13. Include ROUND in your financial models.mp4 3.1 MB
  829. 13. Include ROUND in your financial models.srt 1.2 KB
  830. 13.1 55. Excel-functions-Lecture.xlsx 889.9 KB
  831. 13.2 Excel-Functions.pdf 3.2 MB
  832. 13.3 55. Round-Exercise - Unsolved.xlsx 11.3 KB
  833. 13.4 55. Round-Exercise - Solved.xlsx 11.7 KB
  834. 14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4 34.6 MB
  835. 14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.srt 9.0 KB
  836. 14.1 56. Vlookup-Hlookup- Lecture - Unsolved.xlsx 10.7 KB
  837. 14.2 56. Vlookup-Hlookup- Lecture - Solved.xlsx 11.1 KB
  838. 14.3 Excel-Functions.pdf 3.2 MB
  839. 14.4 56. Vlookup-Hlookup-Exercise - Solved.xlsx 13.7 KB
  840. 14.5 56. Vlookup-Hlookup-Exercise - Unsolved.xlsx 11.9 KB
  841. 15. How to enlarge the formula bar.mp4 6.3 MB
  842. 15. How to enlarge the formula bar.srt 1.4 KB
  843. 15.1 57. Enlarge-the-formula-bar-Lecture.xlsm 46.9 KB
  844. 16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4 39.0 MB
  845. 16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.srt 8.8 KB
  846. 16.1 Excel-Functions.pdf 3.2 MB
  847. 16.2 58. Index-Match-Lecture - Unsolved.xlsx 11.3 KB
  848. 16.3 58. Index-Match-Lecture - Solved.xlsx 11.7 KB
  849. 16.4 58. Index-Match-Exercise - Solved.xlsx 12.1 KB
  850. 16.5 58. Index-Match-Exercise - Unsolved.xlsx 11.6 KB
  851. 17. A great Excel technique INDEX, MATCH, MATCH.mp4 11.8 MB
  852. 17. A great Excel technique INDEX, MATCH, MATCH.srt 5.6 KB
  853. 17.1 59. Exercise-Index-Match-Match-Solved.xlsx 12.2 KB
  854. 17.2 59. Exercise-Index-Match-Match-Unsolved.xlsx 11.6 KB
  855. 17.3 Index, Match, Match - Lecture.xlsx 22.3 KB
  856. 18. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.html 167 bytes
  857. 19. Using Excel's IFERROR function to trap spreadsheet errors.mp4 7.5 MB
  858. 19. Using Excel's IFERROR function to trap spreadsheet errors.srt 2.2 KB
  859. 19.1 60. Iferror-Exercise - Solved.xlsx 15.4 KB
  860. 19.2 60. Iferror - Lecture - Unsolved.xlsm 897.3 KB
  861. 19.3 60. Iferror-Exercise - Unsolved.xlsx 14.3 KB
  862. 19.4 60. Iferror - Lecture - Solved.xlsm 896.4 KB
  863. 19.5 Excel-Functions.pdf 3.2 MB
  864. 2. A helpful consideration.html 1.4 KB
  865. 20. RANK is a valuable tool when using Excel for financial and business analysis.mp4 23.2 MB
  866. 20. RANK is a valuable tool when using Excel for financial and business analysis.srt 2.9 KB
  867. 20.1 61. Rank-function-Lecture-before.xlsx 12.3 KB
  868. 20.2 61. Rank-function-Lecture-after.xlsx 12.6 KB
  869. 21. Learn how to render your models flexible with CHOOSE.mp4 9.0 MB
  870. 21. Learn how to render your models flexible with CHOOSE.srt 2.8 KB
  871. 21.1 Excel-Functions.pdf 3.2 MB
  872. 21.2 62. Choose-Lecture - Unsolved.xlsx 3.2 MB
  873. 21.3 62. Choose-Exercise-Solved.xlsx 11.7 KB
  874. 21.4 62. Choose-Lecture - Solved.xlsx 9.7 KB
  875. 21.5 62. Choose-Exercise - Unsolved.xlsx 11.3 KB
  876. 22. Use Goal Seek to find the result that you are looking for.mp4 7.9 MB
  877. 22. Use Goal Seek to find the result that you are looking for.srt 2.7 KB
  878. 22.1 63. Goal-Seek-Exercise-Solved.xlsx 16.2 KB
  879. 22.2 63. Goal-Seek-Lecture - Solved.xlsx 9.2 KB
  880. 22.3 63. Goal-Seek-Lecture - Unsolved.xlsx 9.1 KB
  881. 22.4 Excel-Functions.pdf 3.2 MB
  882. 22.5 63. Goal-Seek-Exercise - Unsolved.xlsx 16.1 KB
  883. 23. Use Goal Seek in order to find the result that you are looking for.html 167 bytes
  884. 24. Include sensitivity analysis in your models through Data Tables.mp4 14.3 MB
  885. 24. Include sensitivity analysis in your models through Data Tables.srt 5.0 KB
  886. 24.1 64. Sensitivity-analysis-Exercise-Solved.xlsm 63.9 KB
  887. 24.2 64. Sensitivity analysis - Lecture - Solved.xlsm 897.3 KB
  888. 24.3 64. Sensitivity analysis - Lecture - Unsolved.xlsm 897.1 KB
  889. 24.4 64. Sensitivity-analysis-Exercise-Unsolved.xlsm 66.8 KB
  890. 25. Include sensitivity analysis in your models through Data Tables.html 167 bytes
  891. 26. Excel's dynamic and interactive tables Pivot tables.mp4 23.2 MB
  892. 26. Excel's dynamic and interactive tables Pivot tables.srt 2.6 KB
  893. 26.1 65. Pivot tables - Lecture - Unsolved.xlsm 687.8 KB
  894. 26.2 65. Pivot Tables - Exercise - Solved.xlsx 190.5 KB
  895. 26.3 65. Pivot tables - Lecture - Solved.xlsm 897.3 KB
  896. 26.4 65. Pivot Tables - Exercise - Unsolved.xlsx 152.2 KB
  897. 27. Excel's key functions and functionalities made easy.html 166 bytes
  898. 3. Key functions in Excel IF.mp4 16.7 MB
  899. 3. Key functions in Excel IF.srt 2.9 KB
  900. 3.1 Functions - English to German.pdf 102.3 KB
  901. 3.2 Functions - English to Spanish.pdf 102.4 KB
  902. 3.3 Functions - English to Portuguese.pdf 146.1 KB
  903. 3.4 47. IF-function--Lecture-before.xlsm 17.0 KB
  904. 3.5 47. IF-function-Lecture-after.xlsm 17.9 KB
  905. 3.6 Key functions - Excel.pdf 8.5 MB
  906. 4. Key Excel functions SUM, SUMIF and SUMIFS.mp4 19.3 MB
  907. 4. Key Excel functions SUM, SUMIF and SUMIFS.srt 5.3 KB
  908. 4.1 48. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx 14.5 KB
  909. 4.2 Excel-Functions.pdf 3.2 MB
  910. 4.3 48. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx 12.9 KB
  911. 4.4 48. Sum-Sumif-Sumifs-Lecture - Solved.xlsx 13.0 KB
  912. 4.5 48. Sum-Sumif-Sumifs-Exercise - Solved.xlsx 14.8 KB
  913. 5. = and + are interchangeable when you start typing a formula.mp4 5.8 MB
  914. 5. = and + are interchangeable when you start typing a formula.srt 974 bytes
  915. 5.1 49. = and + are interchangeable - before.xlsm 17.0 KB
  916. 5.2 49. = and + are interchangeable -after.xlsm 17.0 KB
  917. 6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 17.0 MB
  918. 6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.srt 4.8 KB
  919. 6.1 05 38 Counts Solved.xlsx 16.1 KB
  920. 6.2 05 38 Counts Exercise & Text.xlsx 15.7 KB
  921. 6.3 Lecture-Count-Countif-Countifs-Unsolved.xlsx 11.3 KB
  922. 6.4 Excel-Functions.pdf 3.2 MB
  923. 6.5 Lecture-Count-Countif-Countifs-Solved.xlsx 11.7 KB
  924. 7. Key Excel functions AVERAGE and AVERAGEIF.mp4 7.9 MB
  925. 7. Key Excel functions AVERAGE and AVERAGEIF.srt 2.4 KB
  926. 7.1 51. Average-AverageIF-Exercise - Unsolved.xlsx 14.6 KB
  927. 7.2 51. Average-Averageif- Lecture - Solved.xlsx 9.4 KB
  928. 7.3 51. Average-AverageIF-Exercise - Solved.xlsx 15.0 KB
  929. 7.4 Excel-Functions.pdf 3.2 MB
  930. 7.5 51. Average-Averageif- Lecture - Unsolved.xlsx 9.0 KB
  931. 8. Key Excel functions AVERAGE and AVERAGEIF.html 167 bytes
  932. 9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4 16.8 MB
  933. 9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.srt 5.7 KB
  934. 9.1 52. Text functions - Exercise - Solved.xlsx 12.2 KB
  935. 9.2 52. Text functions - Exercise - Unsolved.xlsx 11.7 KB
  936. 9.3 52. Text-Functions- Lecture - Solved.xlsx 11.1 KB
  937. 9.4 52. Text-Functions- Lecture - Unsolved.xlsx 10.6 KB
  938. [CourseClub.Me].url 48 bytes
  939. [DesireCourse.Net].url 51 bytes
  940. 1. Exercise - Excel's SUMIFS function - unsolved.html 171 bytes
  941. 2. Exercise - Excel's SUMIFS function - solved & explained.mp4 35.3 MB
  942. 2. Exercise - Excel's SUMIFS function - solved & explained.srt 10.7 KB
  943. 2.1 67. Exercise-Sumifs-With-Solutions.xlsx 1.3 MB
  944. 1. Future and present values in Excel.mp4 15.0 MB
  945. 1. Future and present values in Excel.srt 6.9 KB
  946. 1.1 68. FV and PV-Lecture.xlsx 10.6 KB
  947. 2. Calculating the rate of return of an investment with the IRR function.mp4 7.6 MB
  948. 2. Calculating the rate of return of an investment with the IRR function.srt 3.7 KB
  949. 2.1 69. Exercise-IRR-Solved.xlsx 12.3 KB
  950. 2.2 69. Exercise-IRR-Unsolved.xlsx 11.5 KB
  951. 2.3 69. IRR-Lecture.xlsx 11.2 KB
  952. 3. Calculating a complete loan schedule in Excel.mp4 14.8 MB
  953. 3. Calculating a complete loan schedule in Excel.srt 6.5 KB
  954. 3.1 70. Exercise-Loan-Schedule-Unsolved.xlsx 15.8 KB
  955. 3.2 70. Exercise-Loan-Schedule-Solved.xlsx 22.7 KB
  956. 3.3 70. Loan Schedule-Lecture.xlsx 20.2 KB
  957. 4. Date functions in Excel.mp4 11.4 MB
  958. 4. Date functions in Excel.srt 5.8 KB
  959. 4.1 71. Date Functions-Exercise-Unsolved.xlsx 11.4 KB
  960. 4.2 71. Date Functions-Exercise-Solved.xlsx 12.4 KB
  961. 4.3 71. Date Functions-Lecture.xlsx 12.3 KB
  962. 1. Introduction to Pivot Tables and the way they are applied.mp4 6.0 MB
  963. 1. Introduction to Pivot Tables and the way they are applied.srt 2.1 KB
  964. 2. Creating Pivot Tables easily!.mp4 19.4 MB
  965. 2. Creating Pivot Tables easily!.srt 4.3 KB
  966. 2.1 73. Creating-a-Pivot-Table - Lecture – before.xlsx 1.2 MB
  967. 2.2 73. Creating-a-Pivot-Table - Lecture - after.xlsx 1.4 MB
  968. 3. Give your Excel Pivot Tables a makeover.mp4 11.3 MB
  969. 3. Give your Excel Pivot Tables a makeover.srt 2.4 KB
  970. 3.1 74. Formatting-a-Pivot-Table - Lecture - before.xlsx 1.4 MB
  971. 3.2 74. Formatting-a-Pivot-Table - Lecture - after.xlsx 1.4 MB
  972. 4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4 23.0 MB
  973. 4. Modifying and pivoting fields to obtain the Pivot Table you need.srt 4.7 KB
  974. 4.1 75. Working-with-Pivot-Tables - Lecture - after.xlsx 1.9 MB
  975. 4.2 75. Working-with-Pivot-Tables - Lecture - before.xlsx 1.4 MB
  976. 5. Learn more about GETPIVOTDATA - A very important Excel function.mp4 18.1 MB
  977. 5. Learn more about GETPIVOTDATA - A very important Excel function.srt 4.0 KB
  978. 5.1 76. GetPivotData - Lecture - before.xlsx 1.9 MB
  979. 5.2 76. GetPivotData - Lecture – after.xlsx 1.9 MB
  980. 6. An introduction to slicers - The modern-day Pivot Table filters.mp4 22.2 MB
  981. 6. An introduction to slicers - The modern-day Pivot Table filters.srt 4.7 KB
  982. 6.1 77. Slicers - Lecture - after.xlsx 1.9 MB
  983. 6.2 77. Slicers - Lecture - before.xlsx 1.9 MB
  984. 1. Case study - Build a P&L from scratch - Welcome lecture.mp4 3.1 MB
  985. 1. Case study - Build a P&L from scratch - Welcome lecture.srt 1.6 KB
  986. 10. FAQ Sum of FY2018 doens't go down to zero.html 1.3 KB
  987. 11. Use INDEX & MATCH as a substitute for VLOOKUP.mp4 49.6 MB
  988. 11. Use INDEX & MATCH as a substitute for VLOOKUP.srt 4.3 KB
  989. 11.1 87. Index Match-Lecture-before.xlsm 41.0 KB
  990. 11.2 87. Index Match-Lecture-after.xlsm 13.9 MB
  991. 12. Mapping the rows in the database sheet.mp4 32.5 MB
  992. 12. Mapping the rows in the database sheet.srt 2.8 KB
  993. 12.1 88. Mapping-Lecture-after.xlsm 50.2 KB
  994. 12.2 88. Mapping_before.xlsm 50.6 KB
  995. 13. In case you have any doubts about the Mapping exercise.mp4 38.6 MB
  996. 13. In case you have any doubts about the Mapping exercise.srt 6.7 KB
  997. 13.1 89. Mapping-Lecture-Solved.xlsx 47.5 KB
  998. 13.2 89. Mapping-exercise-explained.pdf 243.0 KB
  999. 13.3 89. Mapping-Lecture-Unsolved.xlsm 50.6 KB
  1000. 14. Building the structure of the P&L sheet.mp4 20.8 MB
  1001. 14. Building the structure of the P&L sheet.srt 2.3 KB
  1002. 14.1 90. Building a P&L-Lecture-before.xlsm 50.2 KB
  1003. 14.2 90. Building a P&L-Lecture-after.xlsm 51.8 KB
  1004. 15. Formatting sets You apart from the competition in Excel - A Practical Example.mp4 25.4 MB
  1005. 15. Formatting sets You apart from the competition in Excel - A Practical Example.srt 3.4 KB
  1006. 15.1 91. Formatting the P&L-Lecture-after.xlsm 52.0 KB
  1007. 15.2 91. Formatting a P&L-Lecture-before.xlsm 51.8 KB
  1008. 16. Populate the P&L sheet with SUMIF.mp4 30.3 MB
  1009. 16. Populate the P&L sheet with SUMIF.srt 3.0 KB
  1010. 16.1 92. Formatting the P&L-Lecture-after.xlsm 53.5 KB
  1011. 16.2 92. Formatting the P&L-Lecture-before.xlsm 52.0 KB
  1012. 17. FAQ Why the sum of the check should be 0.html 542 bytes
  1013. 18. Learn how to find mistakes with COUNTIF.mp4 27.9 MB
  1014. 18. Learn how to find mistakes with COUNTIF.srt 2.8 KB
  1015. 18.1 93. Countif-Lecture-before.xlsm 53.5 KB
  1016. 18.2 93. Countif-Lecture-after.xlsm 54.8 KB
  1017. 19. Calculating year-on-year percentage variations the proper way.mp4 30.0 MB
  1018. 19. Calculating year-on-year percentage variations the proper way.srt 3.3 KB
  1019. 19.1 94. Adding % variations-Lecture-after.xlsm 56.5 KB
  1020. 19.2 Y-o-Y Function explanation.pdf 164.9 KB
  1021. 19.3 94. Adding % variations-Lecture-before.xlsm 54.8 KB
  1022. 2. Introduction to the case study.mp4 10.2 MB
  1023. 2. Introduction to the case study.srt 1.1 KB
  1024. 20. FAQ Why do we subtract -1 when calculating year-on-year growth.html 1.2 KB
  1025. 3. Understand your data source before you start working on it.mp4 28.2 MB
  1026. 3. Understand your data source before you start working on it.srt 3.2 KB
  1027. 3.1 80. Get to know the data source.xlsm 43.0 KB
  1028. 4. Order the source worksheets.mp4 26.5 MB
  1029. 4. Order the source worksheets.srt 2.5 KB
  1030. 4.1 81. Order a worksheet_after.xlsm 41.0 KB
  1031. 4.2 81. Order a worksheet_before.xlsm 43.1 KB
  1032. 5. Create a code the best way to organize your data and work efficiently with it.mp4 24.5 MB
  1033. 5. Create a code the best way to organize your data and work efficiently with it.srt 2.2 KB
  1034. 5.1 82. Creating a code_before.xlsm 41.0 KB
  1035. 5.2 82. Creating a code_after.xlsm 41.7 KB
  1036. 6. Learn how to create a database.mp4 20.7 MB
  1037. 6. Learn how to create a database.srt 2.1 KB
  1038. 6.1 83. Creating a database_before.xlsm 41.7 KB
  1039. 6.2 83. Creating a database_after.xlsm 39.4 KB
  1040. 7. Use VLOOKUP to fill the database sheet.mp4 61.6 MB
  1041. 7. Use VLOOKUP to fill the database sheet.srt 5.6 KB
  1042. 7.1 84. Vlookup_before.xlsm 39.5 KB
  1043. 7.2 84. Vlookup_after.xlsm 44.5 KB
  1044. 8. 50% completed!.mp4 4.3 MB
  1045. 8. 50% completed!.srt 41 bytes
  1046. 9. Use SUMIF to complete the database sheet.mp4 47.9 MB
  1047. 9. Use SUMIF to complete the database sheet.srt 4.4 KB
  1048. 9.1 86. Sumif_before.xlsm 44.5 KB
  1049. 9.2 86. Sumif_after.xlsm 49.5 KB
  1050. [CourseClub.Me].url 48 bytes
  1051. [DesireCourse.Net].url 51 bytes
  1052. [CourseClub.Me].url 48 bytes
  1053. [DesireCourse.Net].url 51 bytes

Discussion