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

Latest Search: 1.veni vidi vici 2.weight workouts 3.gdcm- 4.Pornochic Lola & Angelika 5.Faith Makes Great

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

magnet:?xt=urn:btih:23ED6054427F9DDF7B09750B07087C356AB9CA43&dn=%5BTutorialsplanet.NET%5D%20Udemy%20-%20Beginner%20to%20Pro%20in%20Excel%20Financial%20Modeling%20and%20Valuation

QR Code Copy to Clipboard Open with BT Client

Torrent Hash:

23ED6054427F9DDF7B09750B07087C356AB9CA43

Number of Files:

858

Content Size:

4.72GB

Convert On:

2019-09-27

Keywords:

Tutorialsplanet NET Udemy Beginner to Pro in Excel Financial Modeling and Valuation

Magnet Link:

magnet:?xt=urn:btih:23ED6054427F9DDF7B09750B07087C356AB9CA43&dn=%5BTutorialsplanet.NET%5D%20Udemy%20-%20Beginner%20to%20Pro%20in%20Excel%20Financial%20Modeling%20and%20Valuation

Link:

//btsow.motorcycles/magnet/detail/hash/23ED6054427F9DDF7B09750B07087C356AB9CA43

Download

Play Now

File Name

Size

1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp4

8.94MB

1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.vtt

3.11KB

1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1.1 Course Notes - Beginner to Pro in Excel.pdf.pdf

19.03MB

1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/2. Bonus! Welcome gift.html

164B

1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/3. Welcome gift number 2.html

164B

1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The best way to take this course.mp4

20.16MB

1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The best way to take this course.vtt

2.48KB

1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/5. Download all course materials.html

775B

10. Introduction to Excel charts/1. How to insert a chart in Excel.mp4

22.27MB

10. Introduction to Excel charts/1. How to insert a chart in Excel.vtt

2.57KB

10. Introduction to Excel charts/1.1 95. Inserting-Charts-Lecture.xlsm.xlsm

11.45MB

10. Introduction to Excel charts/2. Editing Excel charts.mp4

26.05MB

10. Introduction to Excel charts/2. Editing Excel charts.vtt

2.9KB

10. Introduction to Excel charts/2.1 96. Formatting-a-Chart-Lecture.xlsm.xlsm

11.45MB

10. Introduction to Excel charts/3. Excel chart formatting.mp4

32.74MB

10. Introduction to Excel charts/3. Excel chart formatting.vtt

3.4KB

10. Introduction to Excel charts/3.1 97. Modifying-a-Chart-Lecture.xlsm.xlsm

11.4MB

10. Introduction to Excel charts/4. How to create a bridge chart in Excel.mp4

13.66MB

10. Introduction to Excel charts/4. How to create a bridge chart in Excel.vtt

1.92KB

10. Introduction to Excel charts/4.1 98. Bridge-Charts-Lecture.xlsx.xlsx

13.1KB

10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.mp4

11.49MB

10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.vtt

1.67KB

10. Introduction to Excel charts/5.1 99. Treemap-Charts-Lecture.xlsx.xlsx

12.62KB

10. Introduction to Excel charts/6. Sparklines.mp4

27.56MB

10. Introduction to Excel charts/6. Sparklines.vtt

4.17KB

10. Introduction to Excel charts/6.1 100. Sparklines-Lecture.xlsx.xlsx

9.59KB

11/1. Create professional and good-looking charts - Introduction.mp4

6.21MB

11/1. Create professional and good-looking charts - Introduction.vtt

727B

11/2. Build a column stacked chart with a secondary line axis in Excel.mp4

46.37MB

11/2. Build a column stacked chart with a secondary line axis in Excel.vtt

5.63KB

11/2.1 102. Column stacked chart-Lecture-before.xlsm.xlsm

11.5MB

11/2.2 102. Column stacked chart-Lecture-after.xlsm.xlsm

11.5MB

11/3. Learn how to build effective doughnut charts in Excel.mp4

38MB

11/3. Learn how to build effective doughnut charts in Excel.vtt

5.42KB

11/3.1 103. Doughnut chart-Lecture-after.xlsm.xlsm

11.51MB

11/3.2 103. Doughnut chart-Lecture-before.xlsm.xlsm

11.52MB

11/4. Learn how to build an area chart in Excel.mp4

28.58MB

11/4. Learn how to build an area chart in Excel.vtt

3.48KB

11/4.1 104. Area chart-Lecture-after.xlsm.xlsm

11.52MB

11/4.2 104. Area chart-Lecture-before.xlsm.xlsm

11.51MB

11/5. Learn how to create bridge charts.mp4

52.07MB

11/5. Learn how to create bridge charts.vtt

7.45KB

11/5.1 105. Bridge chart-Lecture-after.xlsm.xlsm

11.54MB

11/5.2 105. Bridge chart-Lecture-before.xlsm.xlsm

11.52MB

11/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4

136.12MB

11/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.vtt

11.75KB

11/7. Case Study - Building a Complete P&L from scratch in Excel.html

159B

11/8. Course Challenge - Apply your skills in practice!.mp4

7.92MB

11/8. Course Challenge - Apply your skills in practice!.vtt

1.17KB

11/8.1 107. Course-Challenge - Solved.xlsx.xlsx

543.93KB

11/8.2 107. Course-Challenge - Unsolved.xlsx.xlsx

505.49KB

12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.mp4

12.06MB

12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.vtt

2.45KB

12. Case Study - Building an FMCG Model from Scratch/1.1 108. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx.xlsx

13.26MB

12. Case Study - Building an FMCG Model from Scratch/10. Combining Slicers and GETPIVOTDATA The key to our success.mp4

17.84MB

12. Case Study - Building an FMCG Model from Scratch/10. Combining Slicers and GETPIVOTDATA The key to our success.vtt

3.4KB

12. Case Study - Building an FMCG Model from Scratch/10.1 117. Exercise-Build-an-FMCG-Model-Inserting-Slicers-Lecture.xlsx.xlsx

20.77MB

12. Case Study - Building an FMCG Model from Scratch/11. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4

17.12MB

12. Case Study - Building an FMCG Model from Scratch/11. Getting fancy with Excel slicers - Good-looking Excel slicers.vtt

3.4KB

12. Case Study - Building an FMCG Model from Scratch/11.1 118. Exercise-Build-an-FMCG-Model-Complete-Lecture.xlsx.xlsx

22.81MB

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

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

12. Case Study - Building an FMCG Model from Scratch/12.1 119. Exercise-Build-an-FMCG-Model-Complete.xlsx.xlsx

22.81MB

12. Case Study - Building an FMCG Model from Scratch/13. Dynamic reporting with GETPIVOTDATA and slicers.html

163B

12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.mp4

22.6MB

12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.vtt

2.43KB

12. Case Study - Building an FMCG Model from Scratch/2.1 109. Exercise-Build-an-FMCG-Model-Mapping-Lecture.xlsx.xlsx

14.89MB

12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp4

21.95MB

12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.vtt

3.84KB

12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.mp4

11.65MB

12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.vtt

2.8KB

12. Case Study - Building an FMCG Model from Scratch/4.1 111. Exercise-Build-an-FMCG-Model-Structure-Lecture.xlsx.xlsx

14.91MB

12. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.mp4

13.5MB

12. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.vtt

4.63KB

12. Case Study - Building an FMCG Model from Scratch/5.1 112. Exercise-Build-an-FMCG-Model-Formatting-Lecture.xlsx.xlsx

14.91MB

12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.mp4

8.84MB

12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.vtt

4.63KB

12. Case Study - Building an FMCG Model from Scratch/6.1 113. Exercise-Build-an-FMCG-Model-Adding-Calculations-Lecture.xlsx.xlsx

14.91MB

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

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.1KB

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

12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4

31.04MB

12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.vtt

6.68KB

12. Case Study - Building an FMCG Model from Scratch/8.1 115. Exercise-Build-an-FMCG-Model-GETPIVOTDATA-Lecture.xlsx.xlsx

20.81MB

12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4

13.76MB

12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.vtt

1.48KB

13. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.mp4

2.1MB

13. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.vtt

1.07KB

13. Financial Modeling Fundamentals/10. Forecasting financials - Quiz.html

160B

13. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.mp4

6.44MB

13. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.vtt

2.72KB

13. Financial Modeling Fundamentals/12. Modeling the Income statement.mp4

12.43MB

13. Financial Modeling Fundamentals/12. Modeling the Income statement.vtt

7KB

13. Financial Modeling Fundamentals/13. Modeling the Balance sheet - Part 1.mp4

5.22MB

13. Financial Modeling Fundamentals/13. Modeling the Balance sheet - Part 1.vtt

3.18KB

13. Financial Modeling Fundamentals/14. Modeling the Balance sheet - Part 2.mp4

9.38MB

13. Financial Modeling Fundamentals/14. Modeling the Balance sheet - Part 2.vtt

5.72KB

13. Financial Modeling Fundamentals/15. Building a financial model - Quiz.html

160B

13. Financial Modeling Fundamentals/2. What is a financial model.mp4

4.59MB

13. Financial Modeling Fundamentals/2. What is a financial model.vtt

2.35KB

13. Financial Modeling Fundamentals/3. Why use financial models.mp4

7.69MB

13. Financial Modeling Fundamentals/3. Why use financial models.vtt

3.11KB

13. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.mp4

19.91MB

13. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.vtt

6.86KB

13. Financial Modeling Fundamentals/5. Financial modeling - best practices.mp4

17.22MB

13. Financial Modeling Fundamentals/5. Financial modeling - best practices.vtt

5.69KB

13. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.mp4

12.51MB

13. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.vtt

5.49KB

13. Financial Modeling Fundamentals/7. Financial modeling - Quiz.html

160B

13. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.mp4

5.68MB

13. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.vtt

2.93KB

13. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.mp4

6.44MB

13. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.vtt

3.34KB

14. Introduction to Company Valuation/1. The core theory behind Company Valuation.html

164B

15. Introduction to Mergers & Acquisitions/1. Introduction to Mergers & Acquisitions.html

164B

16/1. Valuation Case study - Welcome lecture.mp4

1.78MB

16/1. Valuation Case study - Welcome lecture.vtt

869B

16/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4

30.01MB

16/10. Modeling other items Interest expenses, Extraordinary items and Taxes.vtt

2.92KB

16/10.1 9. Interest expenses, taxes_before.xlsm.xlsm

50.57KB

16/10.2 9. Interest expenses, taxes_after.xlsm.xlsm

50.89KB

16/11. Forecasting Balance sheet items.mp4

4.66MB

16/11. Forecasting Balance sheet items.vtt

914B

16/11.1 10. Introduction to Balance sheet items.xlsm.xlsm

51.02KB

16/12. An introduction to the Days methodology.mp4

10.08MB

16/12. An introduction to the Days methodology.vtt

1.77KB

16/12.1 Working Capital Days.pptx.pptx

94.77KB

16/13. Calculation of DSO, DPO and DOI for the historical period.mp4

12.11MB

16/13. Calculation of DSO, DPO and DOI for the historical period.vtt

1.36KB

16/13.1 12. Days calculation_before.xlsm.xlsm

51.2KB

16/13.2 12. Days calculation_after.xlsm.xlsm

51.47KB

16/14. Forecasting DSO, DPO and DOI.mp4

20.86MB

16/14. Forecasting DSO, DPO and DOI.vtt

2.73KB

16/14.1 13. Forecasting DSO, DPO, DIO_before.xlsm.xlsm

51.47KB

16/14.2 13. Forecasting DSO, DPO, DIO_after.xlsm.xlsm

51.98KB

16/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4

22.63MB

16/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.vtt

2.6KB

16/15.1 14. Forecasting PP&E, Other assets, and Other liabilities_after.xlsm.xlsm

52.88KB

16/15.2 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm.xlsm

51.98KB

16/16. Creating an output P&L sheet.mp4

18.8MB

16/16. Creating an output P&L sheet.vtt

2.32KB

16/16.1 15. P&L structure_after.xlsm.xlsm

53.67KB

16/16.2 15. P&L structure_before.xlsm.xlsm

53.6KB

16/17. Populating the output P&L sheet.mp4

25.53MB

16/17. Populating the output P&L sheet.vtt

2.44KB

16/17.1 16. Populating the P&L sheet_after.xlsm.xlsm

55.32KB

16/17.2 16. Populating the P&L sheet_before.xlsm.xlsm

53.67KB

16/18. Populating the output BS sheet.mp4

16.93MB

16/18. Populating the output BS sheet.vtt

1.75KB

16/18.1 17. Populating BS sheet_before.xlsm.xlsm

55.32KB

16/18.2 17. Populating BS sheet_after.xlsm.xlsm

57.18KB

16/19. Completing the output BS sheet for the historical period.mp4

38.03MB

16/19. Completing the output BS sheet for the historical period.vtt

4.09KB

16/19.1 18. Completing the Balance Sheet_after.xlsm.xlsm

58.1KB

16/19.2 18. Completing the Balance Sheet_before.xlsm.xlsm

57.18KB

16/2. Introduction to the DCF exercise.mp4

7.88MB

16/2. Introduction to the DCF exercise.vtt

1.26KB

16/20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp4

22.76MB

16/20. Creating a structure for the calculation of Unlevered Free Cash Flows.vtt

3.23KB

16/20.1 19. Cash flow structure_after.xlsm.xlsm

58.58KB

16/20.2 19. Cash flow structure_before.xlsm.xlsm

58.48KB

16/21. Bridging Unlevered free cash flow to Net cash flow.mp4

14.58MB

16/21. Bridging Unlevered free cash flow to Net cash flow.vtt

2.11KB

16/21.1 20. Bridge UFCF to Net cash flow_before.xlsm.xlsm

58.58KB

16/21.2 20. Bridge UFCF to Net cash flow_after.xlsm.xlsm

58.7KB

16/22. Calculating Unlevered free cash flow.mp4

59.72MB

16/22. Calculating Unlevered free cash flow.vtt

6.63KB

16/22.1 21. Calculating UFCF_after.xlsm.xlsm

59.18KB

16/22.2 21. Calculating UFCF_before.xlsm.xlsm

58.66KB

16/23. Calculating Net cash flow.mp4

37.9MB

16/23. Calculating Net cash flow.vtt

4.23KB

16/23.1 22. Calculating Net Cash Flow_before.xlsm.xlsm

59.18KB

16/23.2 Cash Flow Classification By Activities.xlsx

55.95KB

16/23.3 22. Calculating Net Cash Flow_after.xlsm.xlsm

59.38KB

16/24. Obtaining the rest of the cash flows through Find and Replace.mp4

46.73MB

16/24. Obtaining the rest of the cash flows through Find and Replace.vtt

4.18KB

16/24.1 23. Find and replace_after.xlsm.xlsm

62.5KB

16/24.2 23. Find and replace_before.xlsm.xlsm

59.55KB

16/25. Introducing Weighted average cost of capital and Perpetuity growth.mp4

13.21MB

16/25. Introducing Weighted average cost of capital and Perpetuity growth.vtt

2.2KB

16/25.1 24. Introducing WACC and g_before.xlsm.xlsm

62.49KB

16/25.2 24. Introducing WACC and g_after.xlsm.xlsm

62.58KB

16/26. Discounting Unlevered free cash flows to obtain their Present value.mp4

20.22MB

16/26. Discounting Unlevered free cash flows to obtain their Present value.vtt

2.99KB

16/26.1 25. Calculating PV of Cash Flows_after.xlsm.xlsm

62.71KB

16/26.2 25. Calculating PV of Cash Flows_before.xlsm.xlsm

62.58KB

16/27. Calculating Continuing value and Enterprise value of the business.mp4

17.72MB

16/27. Calculating Continuing value and Enterprise value of the business.vtt

2.33KB

16/27.1 26. Calculating CV and EV_after.xlsm.xlsm

63.1KB

16/27.2 26. Calculating CV and EV_before.xlsm.xlsm

62.71KB

16/28. Calculating Equity value.mp4

12.2MB

16/28. Calculating Equity value.vtt

1.66KB

16/28.1 27. Calculating equity value_before.xlsm.xlsm

63.1KB

16/28.2 27. Calculating equity value_after.xlsm.xlsm

63.27KB

16/29. Sensitivity analysis for WACC and perpetuity growth.mp4

40.48MB

16/29. Sensitivity analysis for WACC and perpetuity growth.vtt

4.56KB

16/29.1 28. Sensitivity analysis_before.xlsm.xlsm

63.27KB

16/29.2 28. Sensitivity analysis_after.xlsm.xlsm

64.83KB

16/29.3 Sensitivity Analysis.xlsx

60.81KB

16/3. The stages of a complete DCF Valuation.mp4

49.24MB

16/3. The stages of a complete DCF Valuation.vtt

6.61KB

16/3.1 Valuation exercise.pdf.pdf

411.76KB

16/30. A possible application of Goal seek.mp4

15.62MB

16/30. A possible application of Goal seek.vtt

1.94KB

16/30.1 29. Goal seek_before.xlsm.xlsm

64.83KB

16/30.2 29. Goal seek_ater.xlsm.xlsm

64.84KB

16/31. Using charts to summarize the results of the DCF model.mp4

32.88MB

16/31.1 30. Charts.xlsm.xlsm

101.22KB

16/32. You made it!.mp4

11.27MB

16/32. You made it!.vtt

2.9KB

16/4. Description of the structure of the DCF model.mp4

18.53MB

16/4. Description of the structure of the DCF model.vtt

3.06KB

16/4.1 3. Structure of the DCF model.xlsm.xlsm

47.9KB

16/4.2 DCF Model structure.pdf.pdf

240.8KB

16/5. A glimpse at the company we are valuing - Cheeseco.mp4

15.67MB

16/5. A glimpse at the company we are valuing - Cheeseco.vtt

1.35KB

16/5.1 Cheeseco.pptx.pptx

80.09KB

16/6. Modeling the top line.mp4

26.3MB

16/6. Modeling the top line.vtt

3.88KB

16/6.1 5. Modeling revenues_after.xlsm.xlsm

48.16KB

16/6.2 5. Modeling revenues_before.xlsm.xlsm

47.85KB

16/7. Introducing scenarios to the model with Choose.mp4

17.83MB

16/7. Introducing scenarios to the model with Choose.vtt

2.49KB

16/7.1 6. Choose_after.xlsm.xlsm

48.36KB

16/7.2 6. Choose_before.xlsm.xlsm

48.16KB

16/8. Modeling other items Other revenues and Cogs.mp4

44.56MB

16/8. Modeling other items Other revenues and Cogs.vtt

4.5KB

16/8.1 7. Other revenues and Cogs_after.xlsm.xlsm

50.08KB

16/8.2 7. Other revenues and Cogs_before.xlsm.xlsm

48.36KB

16/9. Modeling other items Operating expenses and D&A.mp4

26.33MB

16/9. Modeling other items Operating expenses and D&A.vtt

2.53KB

16/9.1 8. Opex and D&A_before.xlsm.xlsm

50.08KB

16/9.2 8. Opex and D&A_after.xlsm.xlsm

50.57KB

17. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.mp4

31.01MB

17. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.vtt

4.27KB

17. Tesla valuation - Complete practical exercise/1.1 Tesla 2017.pdf.pdf

2.51MB

17. Tesla valuation - Complete practical exercise/1.2 Tesla 2016.pdf.pdf

2.21MB

17. Tesla valuation - Complete practical exercise/1.3 0a. Drivers_before.xlsx.xlsx

1.27MB

17. Tesla valuation - Complete practical exercise/1.4 Tesla 2018 Q2.pdf.pdf

635.07KB

17. Tesla valuation - Complete practical exercise/1.5 Tesla Company Valuation - Detailed walkthrough.pdf.pdf

5.08MB

17. Tesla valuation - Complete practical exercise/1.6 Tesla 2015.pdf.pdf

1.29MB

17. Tesla valuation - Complete practical exercise/1.7 0a. Drivers_after.xlsx.xlsx

1.27MB

17. Tesla valuation - Complete practical exercise/10. Forecasting 'energy' and 'services' revenue.mp4

25.29MB

17. Tesla valuation - Complete practical exercise/10. Forecasting 'energy' and 'services' revenue.vtt

2.99KB

17. Tesla valuation - Complete practical exercise/10.1 6. Energy and Other revenue - Before.xlsx.xlsx

1.34MB

17. Tesla valuation - Complete practical exercise/10.2 6. Energy and Other revenue - After.xlsx.xlsx

1.34MB

17. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4

26.8MB

17. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.vtt

2.36KB

17. Tesla valuation - Complete practical exercise/11.1 7. Energy and Other - Gross profit, cost of sales - Before.xlsx.xlsx

1.35MB

17. Tesla valuation - Complete practical exercise/11.2 7. Energy and Other - Gross profit, cost of sales - After.xlsx.xlsx

1.35MB

17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp4

34.91MB

17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.vtt

5.15KB

17. Tesla valuation - Complete practical exercise/12.1 8. Opex - Before.xlsx.xlsx

1.36MB

17. Tesla valuation - Complete practical exercise/12.2 8. Opex - After.xlsx.xlsx

1.36MB

17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp4

56.58MB

17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.vtt

6.1KB

17. Tesla valuation - Complete practical exercise/13.1 9. PP&E forecasting and comparables_before.xlsx.xlsx

1.37MB

17. Tesla valuation - Complete practical exercise/13.2 9. PP&E forecasting and comparables_after.xlsx.xlsx

1.37MB

17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp4

54.2MB

17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.vtt

4.13KB

17. Tesla valuation - Complete practical exercise/14.1 10. PP&E schedule_after.xlsx.xlsx

1.37MB

17. Tesla valuation - Complete practical exercise/14.2 10. PP&E schedule_before.xlsx.xlsx

1.37MB

17. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.mp4

13.61MB

17. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.vtt

1.62KB

17. Tesla valuation - Complete practical exercise/15.1 10a. PP&E comparison.xlsx.xlsx

1.37MB

17. Tesla valuation - Complete practical exercise/16. Calculating DSO, DIO, DPO.mp4

17.52MB

17. Tesla valuation - Complete practical exercise/16. Calculating DSO, DIO, DPO.vtt

2.03KB

17. Tesla valuation - Complete practical exercise/16.1 11. Working capital forecasting_before.xlsx.xlsx

1.38MB

17. Tesla valuation - Complete practical exercise/16.2 11. Working capital forecasting_after.xlsx.xlsx

1.52MB

17. Tesla valuation - Complete practical exercise/17. Producing a clean P&L output sheet.mp4

8.44MB

17. Tesla valuation - Complete practical exercise/17. Producing a clean P&L output sheet.vtt

1.54KB

17. Tesla valuation - Complete practical exercise/17.1 12. P&L.xlsx.xlsx

1.39MB

17. Tesla valuation - Complete practical exercise/18. Fill in the P&L output sheet.mp4

18.34MB

17. Tesla valuation - Complete practical exercise/18. Fill in the P&L output sheet.vtt

1.74KB

17. Tesla valuation - Complete practical exercise/18.1 12a. P&L fill in_after.xlsx.xlsx

1.39MB

17. Tesla valuation - Complete practical exercise/18.2 12a. P&L fill in_before.xlsx.xlsx

1.39MB

17. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.mp4

19.03MB

17. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.vtt

2.09KB

17. Tesla valuation - Complete practical exercise/19.1 13. Calculating working capital_after.xlsx.xlsx

1.4MB

17. Tesla valuation - Complete practical exercise/19.2 13. Calculating working capital_before.xlsx.xlsx

1.4MB

17. Tesla valuation - Complete practical exercise/2. The input data we will work with.mp4

15.81MB

17. Tesla valuation - Complete practical exercise/2. The input data we will work with.vtt

1.58KB

17. Tesla valuation - Complete practical exercise/2.1 0aa. Inputs_before.xlsx.xlsx

1.28MB

17. Tesla valuation - Complete practical exercise/2.2 0aa. Inputs_after.xlsx.xlsx

1.28MB

17. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered free cash flow.mp4

55.93MB

17. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered free cash flow.vtt

5.79KB

17. Tesla valuation - Complete practical exercise/20.1 14. Cash flow - UFCF_after.xlsx.xlsx

1.41MB

17. Tesla valuation - Complete practical exercise/20.2 14. Cash flow - UFCF_before.xlsx.xlsx

1.41MB

17. Tesla valuation - Complete practical exercise/21. Forecasting other assets.mp4

45.24MB

17. Tesla valuation - Complete practical exercise/21. Forecasting other assets.vtt

4.33KB

17. Tesla valuation - Complete practical exercise/21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx

1.41MB

17. Tesla valuation - Complete practical exercise/21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx

1.41MB

17. Tesla valuation - Complete practical exercise/22. Forecasting other liabilities.mp4

21.97MB

17. Tesla valuation - Complete practical exercise/22. Forecasting other liabilities.vtt

2.39KB

17. Tesla valuation - Complete practical exercise/22.1 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx

1.42MB

17. Tesla valuation - Complete practical exercise/22.2 16. Balance Sheet forecasting liabilities_before.xlsx.xlsx

1.41MB

17. Tesla valuation - Complete practical exercise/23. Completing Unlevered free cash flow.mp4

40.88MB

17. Tesla valuation - Complete practical exercise/23. Completing Unlevered free cash flow.vtt

3.35KB

17. Tesla valuation - Complete practical exercise/23.1 16a. Complete UFCF_after.xlsx.xlsx

1.42MB

17. Tesla valuation - Complete practical exercise/23.2 16a. Complete UFCF_before.xlsx.xlsx

1.42MB

17. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.mp4

42.35MB

17. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.vtt

5.04KB

17. Tesla valuation - Complete practical exercise/24.1 17. Financing_before.xlsx.xlsx

1.43MB

17. Tesla valuation - Complete practical exercise/24.2 17. Financing_after.xlsx.xlsx

1.43MB

17. Tesla valuation - Complete practical exercise/25. Calculating Net income.mp4

14.8MB

17. Tesla valuation - Complete practical exercise/25. Calculating Net income.vtt

1.29KB

17. Tesla valuation - Complete practical exercise/25.1 18. P&L complete_before.xlsx.xlsx

1.43MB

17. Tesla valuation - Complete practical exercise/25.2 18. P&L complete_after.xlsx.xlsx

1.43MB

17. Tesla valuation - Complete practical exercise/26. Bridging Unlevered free cash flow to Net cash flow.mp4

50.72MB

17. Tesla valuation - Complete practical exercise/26. Bridging Unlevered free cash flow to Net cash flow.vtt

4.17KB

17. Tesla valuation - Complete practical exercise/26.1 19. Cash flow_complete_after.xlsx.xlsx

1.43MB

17. Tesla valuation - Complete practical exercise/26.2 19. Cash flow_complete_before.xlsx.xlsx

1.43MB

17. Tesla valuation - Complete practical exercise/27. Balancing the Balance sheet.mp4

13.27MB

17. Tesla valuation - Complete practical exercise/27. Balancing the Balance sheet.vtt

1.12KB

17. Tesla valuation - Complete practical exercise/27.1 20. Complete the BS_before.xlsx.xlsx

1.43MB

17. Tesla valuation - Complete practical exercise/27.2 20. Complete the BS_after.xlsx.xlsx

1.43MB

17. Tesla valuation - Complete practical exercise/28. Estimating Weighted average cost of capital (WACC).mp4

44.27MB

17. Tesla valuation - Complete practical exercise/28. Estimating Weighted average cost of capital (WACC).vtt

6.36KB

17. Tesla valuation - Complete practical exercise/28.1 21. WACC_before.xlsx.xlsx

1.43MB

17. Tesla valuation - Complete practical exercise/28.2 21. WACC_after.xlsx.xlsx

1.43MB

17. Tesla valuation - Complete practical exercise/29. Performing discounted cash flow valuation (DCF).mp4

34.9MB

17. Tesla valuation - Complete practical exercise/29. Performing discounted cash flow valuation (DCF).vtt

3.83KB

17. Tesla valuation - Complete practical exercise/29.1 22. DCF_after.xlsx.xlsx

1.44MB

17. Tesla valuation - Complete practical exercise/29.2 22. DCF_before.xlsx.xlsx

1.52MB

17. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.mp4

114.9MB

17. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.vtt

14.38KB

17. Tesla valuation - Complete practical exercise/3.1 1. Deliveries_before.xlsx.xlsx

1.29MB

17. Tesla valuation - Complete practical exercise/3.2 1. Deliveries_after.xlsx.xlsx

1.29MB

17. Tesla valuation - Complete practical exercise/30. Calculating enterprise value, equity value, and price per share.mp4

22.55MB

17. Tesla valuation - Complete practical exercise/30. Calculating enterprise value, equity value, and price per share.vtt

2.01KB

17. Tesla valuation - Complete practical exercise/30.1 23. EV, Equity value, Price per share_before.xlsx.xlsx

1.44MB

17. Tesla valuation - Complete practical exercise/30.2 23. EV, Equity value, Price per share_after.xlsx.xlsx

1.44MB

17. Tesla valuation - Complete practical exercise/31. Final comments.mp4

44.88MB

17. Tesla valuation - Complete practical exercise/31. Final comments.vtt

4.18KB

17. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.mp4

20.94MB

17. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.vtt

3.01KB

17. Tesla valuation - Complete practical exercise/4.1 1a. Deliveries development.xlsx.xlsx

1.3MB

17. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.mp4

41.92MB

17. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.vtt

4.8KB

17. Tesla valuation - Complete practical exercise/5.1 2. Average price_before.xlsx.xlsx

1.31MB

17. Tesla valuation - Complete practical exercise/5.2 2. Average price_after.xlsx.xlsx

1.31MB

17. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.mp4

46.56MB

17. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.vtt

4.79KB

17. Tesla valuation - Complete practical exercise/6.1 3. Revenue calculation and scenarios - before.xlsx.xlsx

1.31MB

17. Tesla valuation - Complete practical exercise/6.2 3. Revenue calculation and scenarios - after.xlsx.xlsx

1.31MB

17. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.mp4

17.18MB

17. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.vtt

2.6KB

17. Tesla valuation - Complete practical exercise/7.1 4. Gross profit automotive.xlsx.xlsx

1.32MB

17. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.mp4

27.77MB

17. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.vtt

2.83KB

17. Tesla valuation - Complete practical exercise/8.1 4a. Gross profit automotive - before.xlsx.xlsx

1.51MB

17. Tesla valuation - Complete practical exercise/8.2 4a. Gross profit automotive - after.xlsx.xlsx

1.32MB

17. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.mp4

17.49MB

17. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.vtt

2.14KB

17. Tesla valuation - Complete practical exercise/9.1 5. Cost of sales and chart.xlsx.xlsx

1.34MB

18. Capital budgeting - The theory/1. Introduction to Capital budgeting.mp4

5.43MB

18. Capital budgeting - The theory/1. Introduction to Capital budgeting.vtt

1.79KB

18. Capital budgeting - The theory/2. Why we need Capital budgeting.mp4

6.89MB

18. Capital budgeting - The theory/2. Why we need Capital budgeting.vtt

2.61KB

18. Capital budgeting - The theory/3. The time value of money.mp4

6.7MB

18. Capital budgeting - The theory/3. The time value of money.vtt

2.79KB

18. Capital budgeting - The theory/4. Calculating future and present Value.mp4

13.08MB

18. Capital budgeting - The theory/4. Calculating future and present Value.vtt

6.27KB

18. Capital budgeting - The theory/5. Calculating cost of equity.mp4

19.21MB

18. Capital budgeting - The theory/5. Calculating cost of equity.vtt

7.44KB

18. Capital budgeting - The theory/6. Coming up with project-specific beta.mp4

9.01MB

18. Capital budgeting - The theory/6. Coming up with project-specific beta.vtt

3.49KB

18. Capital budgeting - The theory/7. Weighted average cost of capital (WACC).mp4

5.5MB

18. Capital budgeting - The theory/7. Weighted average cost of capital (WACC).vtt

2.34KB

18. Capital budgeting - The theory/8. The type of cash flows we will have in a project.mp4

9.34MB

18. Capital budgeting - The theory/8. The type of cash flows we will have in a project.vtt

3.88KB

18. Capital budgeting - The theory/9. Estimating the project's cash flows.mp4

18.79MB

18. Capital budgeting - The theory/9. Estimating the project's cash flows.vtt

6.68KB

19. Capital Budgeting - A Complete Case Study/1. Introduction to the Capital budgeting exercise.mp4

8.63MB

19. Capital Budgeting - A Complete Case Study/1. Introduction to the Capital budgeting exercise.vtt

3.23KB

19. Capital Budgeting - A Complete Case Study/10. Finding cost of equity.mp4

13.92MB

19. Capital Budgeting - A Complete Case Study/10. Finding cost of equity.vtt

7.16KB

19. Capital Budgeting - A Complete Case Study/10.1 8. WACC_unsolved.xlsx.xlsx

35.93KB

19. Capital Budgeting - A Complete Case Study/10.2 8. WACC.xlsx.xlsx

38.03KB

19. Capital Budgeting - A Complete Case Study/11. Discounting the project's cash flows and residual value.mp4

25.9MB

19. Capital Budgeting - A Complete Case Study/11. Discounting the project's cash flows and residual value.vtt

3.51KB

19. Capital Budgeting - A Complete Case Study/11.1 9. Discounted cash flow_unsolved.xlsx.xlsx

38.72KB

19. Capital Budgeting - A Complete Case Study/11.2 9. Discounted cash flow.xlsx.xlsx

39.74KB

19. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and completing the exercise.mp4

43.04MB

19. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and completing the exercise.vtt

5.28KB

19. Capital Budgeting - A Complete Case Study/12.1 10. Sensitivity analysis.xlsx.xlsx

40.67KB

19. Capital Budgeting - A Complete Case Study/12.2 10. Sensitivity analysis_unsolved.xlsx.xlsx

39.7KB

19. Capital Budgeting - A Complete Case Study/13. Build a complete capital budgeting model from scratch.html

163B

19. Capital Budgeting - A Complete Case Study/14. Congratulations!!.mp4

2.3MB

19. Capital Budgeting - A Complete Case Study/14. Congratulations!!.vtt

1.5KB

19. Capital Budgeting - A Complete Case Study/2. Organizing an Inputs sheet.mp4

11.05MB

19. Capital Budgeting - A Complete Case Study/2. Organizing an Inputs sheet.vtt

6.22KB

19. Capital Budgeting - A Complete Case Study/2.1 1. Drivers.xlsx.xlsx

11.5KB

19. Capital Budgeting - A Complete Case Study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4

9.21MB

19. Capital Budgeting - A Complete Case Study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.vtt

4.12KB

19. Capital Budgeting - A Complete Case Study/3.1 2. Savings Forecast.xlsx.xlsx

16.58KB

19. Capital Budgeting - A Complete Case Study/3.2 2. Savings Forecast_unsolved.xlsx.xlsx

14.74KB

19. Capital Budgeting - A Complete Case Study/4. Fixed asset rollforward.mp4

12.15MB

19. Capital Budgeting - A Complete Case Study/4. Fixed asset rollforward.vtt

5.28KB

19. Capital Budgeting - A Complete Case Study/4.1 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx

18.54KB

19. Capital Budgeting - A Complete Case Study/4.2 3. Fixed Asset Rollforward.xlsx.xlsx

19.66KB

19. Capital Budgeting - A Complete Case Study/5. The impact of working capital.mp4

5.37MB

19. Capital Budgeting - A Complete Case Study/5. The impact of working capital.vtt

2.85KB

19. Capital Budgeting - A Complete Case Study/5.1 4. Working Capital.xlsx.xlsx

21.93KB

19. Capital Budgeting - A Complete Case Study/5.2 4. Working Capital_unsolved.xlsx.xlsx

21.19KB

19. Capital Budgeting - A Complete Case Study/6. Modeling debt financing.mp4

6.18MB

19. Capital Budgeting - A Complete Case Study/6. Modeling debt financing.vtt

3.3KB

19. Capital Budgeting - A Complete Case Study/6.1 5. Financing_unsolved.xlsx.xlsx

29.99KB

19. Capital Budgeting - A Complete Case Study/6.2 5. Financing.xlsx.xlsx

30.97KB

19. Capital Budgeting - A Complete Case Study/7. Adding a P&L sheet.mp4

4.88MB

19. Capital Budgeting - A Complete Case Study/7. Adding a P&L sheet.vtt

2.12KB

19. Capital Budgeting - A Complete Case Study/7.1 6. P&L.xlsx.xlsx

31.03KB

19. Capital Budgeting - A Complete Case Study/7.2 6. P&L_unsolved.xlsx.xlsx

29.7KB

19. Capital Budgeting - A Complete Case Study/8. Calculating project cash flows.mp4

10.15MB

19. Capital Budgeting - A Complete Case Study/8. Calculating project cash flows.vtt

3.7KB

19. Capital Budgeting - A Complete Case Study/8.1 7. Cash flow_unsolved.xlsx.xlsx

29.64KB

19. Capital Budgeting - A Complete Case Study/8.2 7. Cash flow.xlsx.xlsx

31.36KB

19. Capital Budgeting - A Complete Case Study/9. Estimating the weighted average cost of capital (WACC).mp4

5.59MB

19. Capital Budgeting - A Complete Case Study/9. Estimating the weighted average cost of capital (WACC).vtt

3.26KB

19. Capital Budgeting - A Complete Case Study/9.1 8. WACC.xlsx.xlsx

38.03KB

19. Capital Budgeting - A Complete Case Study/9.2 8. WACC_unsolved.xlsx.xlsx

35.93KB

2. Introduction to Excel/1. Introduction to Excel - welcome lecture.mp4

1.99MB

2. Introduction to Excel/1. Introduction to Excel - welcome lecture.vtt

911B

2. Introduction to Excel/10. Introduction to Excel formulas.html

160B

2. Introduction to Excel/11. Introduction to Excel functions.mp4

12.05MB

2. Introduction to Excel/11. Introduction to Excel functions.vtt

4.36KB

2. Introduction to Excel/11.1 13. Functions- Exercise - Solved.xlsx.xlsx

81.1KB

2. Introduction to Excel/11.2 13. Functions - Lecture -Solved.xlsx.xlsx

9.34KB

2. Introduction to Excel/11.3 Introduction-to-Excels-basic-features.pdf.pdf

2.27MB

2. Introduction to Excel/11.4 13. Functions- Lecture - Unsolved.xlsx.xlsx

9.24KB

2. Introduction to Excel/11.5 13. Functions-Exercise - Unsolved.xlsx.xlsx

13.26KB

2. Introduction to Excel/12. Cut, copy, & paste.mp4

7.57MB

2. Introduction to Excel/12. Cut, copy, & paste.vtt

2.3KB

2. Introduction to Excel/12.1 Introduction-to-Excels-basic-features.pdf.pdf

2.27MB

2. Introduction to Excel/12.2 14. Copy-Cut-Paste-Exercise - Unsolved.xlsx.xlsx

11.34KB

2. Introduction to Excel/12.3 14. Copy-Cut-Paste-Exercise - Solved.xlsx.xlsx

12.56KB

2. Introduction to Excel/13. Cut, copy, & paste.html

160B

2. Introduction to Excel/14. Paste special.mp4

6.7MB

2. Introduction to Excel/14. Paste special.vtt

1.49KB

2. Introduction to Excel/14.1 15. Paste-Special-Exercise - Unsolved.xlsx.xlsx

13.47KB

2. Introduction to Excel/14.2 15. Paste-Special-Exercise - Solved.xlsx.xlsx

13.46KB

2. Introduction to Excel/14.3 Introduction-to-Excels-basic-features.pdf.pdf

2.27MB

2. Introduction to Excel/15. Basic operations in Excel - 38 pages.html

164B

2. Introduction to Excel/2. Overview of Excel.mp4

13.95MB

2. Introduction to Excel/2. Overview of Excel.vtt

3.87KB

2. Introduction to Excel/2.1 7. Introduction to Excel.pdf.pdf

2.26MB

2. Introduction to Excel/2.2 7. Overview-of-Excel-Exercise-Solved.xlsx.xlsx

10.88KB

2. Introduction to Excel/2.3 7. Overview-of-Excel-Exercise-Unsolved.xlsx.xlsx

10.47KB

2. Introduction to Excel/3. Overview of Excel.html

160B

2. Introduction to Excel/4. Basic manipulations with rows and columns.mp4

6.91MB

2. Introduction to Excel/4. Basic manipulations with rows and columns.vtt

1.96KB

2. Introduction to Excel/4.1 8. Basic manipulations - Lecture.xlsx.xlsx

8.07KB

2. Introduction to Excel/4.2 8. Basic-Manipulations - Exercise - Unsolved.xlsx.xlsx

11.06KB

2. Introduction to Excel/4.3 8. Basic-Manipulations - Exercise - Solved.xlsx.xlsx

32.43KB

2. Introduction to Excel/5. Rows and columns.html

160B

2. Introduction to Excel/6. The Excel ribbon.mp4

8.81MB

2. Introduction to Excel/6. The Excel ribbon.vtt

2.99KB

2. Introduction to Excel/6.1 9. The-Ribbon-Exercise-Solved.xlsx.xlsx

403.25KB

2. Introduction to Excel/6.2 9. The-Ribbon-Exercise-Exercise - Unsolved.xlsx.xlsx

12.09KB

2. Introduction to Excel/7. Data entry in Excel.mp4

10.39MB

2. Introduction to Excel/7. Data entry in Excel.vtt

3.32KB

2. Introduction to Excel/7.1 10. Data-Entry - Lecture.xlsx.xlsx

8.07KB

2. Introduction to Excel/7.2 10. Data-Entry-Exercise - Unsolved.xlsx.xlsx

10.97KB

2. Introduction to Excel/7.3 10. Data-Entry- Exercise -Solved.xlsx.xlsx

32.76KB

2. Introduction to Excel/8. Introduction to formatting.mp4

24.75MB

2. Introduction to Excel/8. Introduction to formatting.vtt

6.14KB

2. Introduction to Excel/8.1 11. Formatting - Lecture - Solved.xlsx.xlsx

9.85KB

2. Introduction to Excel/8.2 11. Formatting-Exercise - Unsolved.xlsx.xlsx

11.61KB

2. Introduction to Excel/8.3 11. Formatting- Exercise - Solved.xlsx.xlsx

11.59KB

2. Introduction to Excel/8.4 11. Formatting- Lecture - Unsolved.xlsx.xlsx

8.91KB

2. Introduction to Excel/9. Introduction to Excel formulas.mp4

23.68MB

2. Introduction to Excel/9. Introduction to Excel formulas.vtt

4.09KB

2. Introduction to Excel/9.1 12. Formulas- Lecture - Solved.xlsx.xlsx

9.36KB

2. Introduction to Excel/9.2 12. Formulas- Lecture - Unsolved.xlsx.xlsx

9.3KB

2. Introduction to Excel/9.3 12. Formulas- Exercise - Solved.xlsx.xlsx

80.13KB

2. Introduction to Excel/9.4 12. Formulas - Exercise - Unsolved.xlsx.xlsx

11.72KB

2. Introduction to Excel/9.5 Introduction-to-Excels-basic-features.pdf.pdf

2.26MB

20. Bonus lecture/1. Bonus lecture Next steps.html

2.13KB

3/1. Excel best practices - Welcome lecture.mp4

2.13MB

3/1. Excel best practices - Welcome lecture.vtt

1.02KB

3/10. Learn how to organize your data with Text to Columns.html

160B

3/11. Learn how to use the Wrap Text button.mp4

2.15MB

3/11. Learn how to use the Wrap Text button.vtt

869B

3/11.1 24. Wrap-Text-Exercise - Solved.xlsx.xlsx

10.2KB

3/11.2 24. Wrap-text-Lecture - Solved.xlsx.xlsx

9.61KB

3/11.3 24. Wrap-Text-Exercise - Unsolved.xlsx.xlsx

10.17KB

3/11.4 24. Wrap-text-Lecture - Unsolved.xlsx.xlsx

9.61KB

3/11.5 Useful-Tips-Tools.pdf.pdf

3.31MB

3/12. Create easily printable documents in Excel by using Set Print Area.mp4

4.74MB

3/12. Create easily printable documents in Excel by using Set Print Area.vtt

1.5KB

3/12.1 25. Set-Print-Area-Lecture - Unsolved.xlsx.xlsx

11.42KB

3/12.2 25. Set-Print-Area-Lecture - Solved.xlsx.xlsx

11.22KB

3/12.3 Useful-Tips-Tools.pdf.pdf

3.31MB

3/13. Find and select special types of cells with Select Special (F5).mp4

9.78MB

3/13. Find and select special types of cells with Select Special (F5).vtt

1.83KB

3/13.1 26. Select-Special-Lecture.xlsx.xlsx

10.56KB

3/13.2 26. Select-Special-F5-Exercise - Solved.xlsx.xlsx

22.27KB

3/13.3 26. Select-Special-F5-Exercise - Unsolved.xlsx.xlsx

21.59KB

3/13.4 Useful-Tips-Tools.pdf.pdf

3.31MB

3/14. Select Special.html

160B

3/15. Learn how to assign dynamic names within a financial model.mp4

7.32MB

3/15. Learn how to assign dynamic names within a financial model.vtt

1.56KB

3/15.1 27. Dynamic-Naming-Lecture - Unsolved.xlsx.xlsx

13.54KB

3/15.2 Useful-Tips-Tools.pdf.pdf

3.31MB

3/15.3 27. Assigning-Dynamic-Names-Exercise - Solved.xlsx.xlsx

11.73KB

3/15.4 27. Dynamic-Naming-Lecture - Solved.xlsx.xlsx

13.83KB

3/15.5 27. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx.xlsx

11.23KB

3/16. Assigning dynamic names.html

160B

3/17. Define a named range in Excel.mp4

5.42MB

3/17. Define a named range in Excel.vtt

1.62KB

3/17.1 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx.xlsx

11.07KB

3/17.2 28. Naming-ranges-Lecture - Unsolved.xlsx.xlsx

8.79KB

3/17.3 28. Naming-ranges-Lecture - Solved.xlsx.xlsx

10.34KB

3/17.4 Useful-Tips-Tools.pdf.pdf

3.31MB

3/17.5 28. Defining-a-Named-Range-Exercise - Solved.xlsx.xlsx

11.65KB

3/18. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4

5.41MB

3/18. Assign custom formats to specific cells within a financial model (e.g Multiples).vtt

1.87KB

3/18.1 29. Assigning Custom Formats - Exercise - Unsolved.xlsx.xlsx

11.35KB

3/18.2 Useful-Tips-Tools.pdf.pdf

3.3MB

3/18.3 29. Assigning Custom Formats - Exercise - Solved.xlsx.xlsx

11.08KB

3/19. Macros are a great timesaver! Here's why!.mp4

11.1MB

3/19. Macros are a great timesaver! Here's why!.vtt

3.34KB

3/19.1 Useful-Tips-Tools.pdf.pdf

3.3MB

3/19.2 30. Creating-a-Macro-Lecture - Solved.xlsx.xlsx

11.17KB

3/19.3 30. Macros-Exercise - Solved.xlsx.xlsx

145.02KB

3/19.4 30. Creating-a-Macro-Lecture - Unsolved.xlsx.xlsx

9.66KB

3/19.5 30. Macros-Exercise - Unsolved.xlsx.xlsx

10.34KB

3/2. Initial formatting of an Excel sheet to render it professional.mp4

7.99MB

3/2. Initial formatting of an Excel sheet to render it professional.vtt

2.16KB

3/2.1 18. Formatting-a-Worksheet-Exercise - Unsolved.xlsx.xlsx

10.63KB

3/2.2 18. Formatting-a-Worksheet-Exercise - Solved.xlsx.xlsx

10.76KB

3/2.3 Useful-Tips-Tools.pdf.pdf

3.3MB

3/2.4 18. Formatting-a-worksheet-Lecture - Solved.xlsx.xlsx

9.56KB

3/2.5 18. Formatting-a-worksheet-Lecture - Unsolved.xlsx.xlsx

8.98KB

3/20. How to save macros and use them across several workbooks.mp4

12.78MB

3/20. How to save macros and use them across several workbooks.vtt

1.72KB

3/20.1 31. Another-file.xlsx.xlsx

8.81KB

3/20.2 31. How-to-save-macros-Lecture-before.xlsx.xlsx

6.02KB

3/20.3 31. How-to-save-macros-Lecture-after.xlsm.xlsm

12.59KB

3/21. Excel Macros - quiz.html

160B

3/22. Create a drop-down list by using Data Validation.mp4

10.59MB

3/22. Create a drop-down list by using Data Validation.vtt

2.1KB

3/22.1 32. Data-Validation-Lecture - Solved.xlsx.xlsx

10.84KB

3/22.2 32. Drop-down-List-Exercise - Solved.xlsx.xlsx

77.02KB

3/22.3 32. Drop-down-List-Exercise - Unsolved.xlsx.xlsx

11.34KB

3/22.4 32. Data-Validation-Lecture - Unsolved.xlsx.xlsx

10.84KB

3/22.5 Useful-Tips-Tools.pdf.pdf

3.31MB

3/23. Using Custom-sort in order to sort multiple columns within a table.mp4

9.15MB

3/23. Using Custom-sort in order to sort multiple columns within a table.vtt

1.59KB

3/23.1 33. Custom-Sort-Exercise - Unsolved.xlsx.xlsx

11.37KB

3/23.2 33. Sort-data-Lecture - Solved.xlsx.xlsx

145.65KB

3/23.3 33. Sort-data-Lecture - Unsolved.xlsx.xlsx

145.35KB

3/23.4 Useful-Tips-Tools.pdf.pdf

3.31MB

3/23.5 33. Custom-Sort-Exercise - Solved.xlsx.xlsx

11.46KB

3/24. Create a great Index page at the beginning of your models - Hyperlinks.mp4

5.35MB

3/24. Create a great Index page at the beginning of your models - Hyperlinks.vtt

1.51KB

3/24.1 34. Hyperlinks-Exercise - Unsolved.xlsx.xlsx

136.89KB

3/24.2 34. Hyperlinks-Exercise - Solved.xlsx.xlsx

137.06KB

3/24.3 Useful-Tips-Tools.pdf.pdf

3.3MB

3/25. Fix the top row of your table with Freeze Panes.mp4

17.67MB

3/25. Fix the top row of your table with Freeze Panes.vtt

1.42KB

3/25.1 35. Freeze-Panes-Lecture - Unsolved.xlsx.xlsx

643.87KB

3/25.2 35. Freeze-Panes-Lecture - Solved.xlsx.xlsx

643.94KB

3/25.3 Useful-Tips-Tools.pdf.pdf

3.31MB

3/26. Filter by color - an excellent tool.mp4

9.88MB

3/26. Filter by color - an excellent tool.vtt

1.99KB

3/26.1 36. Exercise-Filter-by-Color-Unsolved.xlsx.xlsx

20.47KB

3/26.2 36. Exercise-Filter-by-Color-Solved.xlsx.xlsx

153.48KB

3/27. Working with conditional formatting.mp4

15.08MB

3/27. Working with conditional formatting.vtt

5.61KB

3/27.1 Solution_Conditional Formatting.xlsx.xlsx

51.52KB

3/27.2 Exercise_Conditional Formatting.xlsx.xlsx

12.88KB

3/28. A neat trick - Multiply by 1.mp4

14.84MB

3/28. A neat trick - Multiply by 1.vtt

1.64KB

3/28.1 38. Multiply-by-1-Lecture-before.xlsx.xlsx

16.47KB

3/28.2 38. Multiply-by-1-Lecture-after.xlsx.xlsx

17.21KB

3/29. Useful tips and tools for your work in Excel - quiz.html

159B

3/3. Fast scrolling through Excel sheets.mp4

22.16MB

3/3. Fast scrolling through Excel sheets.vtt

1.73KB

3/3.1 Useful-Tips-Tools.pdf.pdf

3.31MB

3/3.2 19. Fast-Scrolling-Exercise - Unsolved.xlsx.xlsx

43.9KB

3/3.3 19. Fast-Scrolling-Exercise - Solved.xlsx.xlsx

44.35KB

3/3.4 19. Fast-Scrolling - Lecture.xlsx.xlsx

642.82KB

3/30. Find and replace - references.mp4

24.04MB

3/30. Find and replace - references.vtt

3.32KB

3/30.1 39. Find-and-Replace-references-Lecture-after.xlsx.xlsx

37.91KB

3/30.2 39. Find-and-Replace-references-Lecture-before.xlsx.xlsx

38.79KB

3/31. Find and replace - formatting.mp4

13.78MB

3/31. Find and replace - formatting.vtt

1.88KB

3/31.1 40. Find-replace-Lecture-before.xlsx.xlsx

17.19KB

3/31.2 40. Find-replace-Lecture-after.xlsx.xlsx

17.19KB

3/32. Removing (automatic) green arrows.mp4

12.6MB

3/32. Removing (automatic) green arrows.vtt

1.63KB

3/32.1 41. Green-references-Lecture.xlsx.xlsx

12KB

3/33. Beauty saving - The professional way of saving files.mp4

14.02MB

3/33. Beauty saving - The professional way of saving files.vtt

2.59KB

3/33.1 42. Beauty-saving-Lecture-before.xlsx.xlsx

17.17KB

3/33.2 42. Beauty-saving-Lecture-after.xlsx.xlsx

17.05KB

3/34. Formula auditing with F2.mp4

17.74MB

3/34. Formula auditing with F2.vtt

2.14KB

3/34.1 43. F2-Lecture.xlsm.xlsm

50.76KB

3/4. Be even quicker F5 + Enter.mp4

19.78MB

3/4. Be even quicker F5 + Enter.vtt

2.11KB

3/4.1 20. F5-go-to - Lecture.xlsm.xlsm

50.76KB

3/5. Fast scrolling through Excel sheets.html

160B

3/6. Introduction to fixing of cell references.mp4

20.37MB

3/6. Introduction to fixing of cell references.vtt

2.53KB

3/6.1 Useful-Tips-Tools.pdf.pdf

3.31MB

3/6.2 21. Fixing-Cells-Exercise - Unsolved.xlsx.xlsx

10.67KB

3/6.3 21. Fixing-references-Lecture - Unsolved.xlsx.xlsx

643.98KB

3/6.4 21. Fixing-Cells-Exercise - Solved.xlsx.xlsx

10.82KB

3/6.5 21. Fixing-references-Lecture - Solved.xlsx.xlsx

645.17KB

3/7. Introduction to fixing of cell references.html

160B

3/8. Using the 'Alt + Enter' combination.mp4

3.33MB

3/8. Using the 'Alt + Enter' combination.vtt

1008B

3/8.1 22. Alt-Enter-Exercise - Unsolved.xlsx.xlsx

11.12KB

3/8.2 22. Alt-Enter- Lecture - Unsolved.xlsx.xlsx

9.64KB

3/8.3 22. Alt-Enter- Lecture - Solved.xlsx.xlsx

9.65KB

3/8.4 22. Alt-Enter-Exercise - Solved.xlsx.xlsx

11.4KB

3/9. Learn how to organize your data with Text to Columns.mp4

12.54MB

3/9. Learn how to organize your data with Text to Columns.vtt

2.21KB

3/9.1 23. Text-to-Columns-Exercise - Solved.xlsx.xlsx

11.3KB

3/9.2 23. Text-to-Columns-Exercise - Unsolved.xlsx.xlsx

10.57KB

3/9.3 23. Text-to-columns-Lecture - Unsolved.xlsx.xlsx

9.76KB

3/9.4 Useful-Tips-Tools.pdf.pdf

3.31MB

3/9.5 23.Text-to-columns-Lecture - Solved.xlsx.xlsx

9.9KB

4. Keyboard shortcuts in Excel/1. Keyboard shortcuts Save LOTS of time in Excel.mp4

30.43MB

4. Keyboard shortcuts in Excel/1. Keyboard shortcuts Save LOTS of time in Excel.vtt

5.16KB

4. Keyboard shortcuts in Excel/2. Keyboard shortcuts in Excel.html

164B

5/1. Excel's key functions - Welcome lecture.mp4

2.31MB

5/1. Excel's key functions - Welcome lecture.vtt

1.09KB

5/10. Working with text in Excel.mp4

16.01MB

5/10. Working with text in Excel.vtt

3.03KB

5/10.1 53. Work-with-text-Lecture-after.xlsx.xlsx

10.91KB

5/10.2 53. Work-with-text-Lecture-before.xlsx.xlsx

10.33KB

5/11. Find the minimum or maximum value in a range of cells in Excel.mp4

5.91MB

5/11. Find the minimum or maximum value in a range of cells in Excel.vtt

1.09KB

5/11.1 54. Max-min-Lecture - Unsolved.xlsx.xlsx

8.95KB

5/11.2 54. MIN-MAX-Exercise - Unsolved.xlsx.xlsx

14.39KB

5/11.3 54. Max-min-Lecture - Solved.xlsx.xlsx

9.23KB

5/11.4 54. MIN-MAX-Exercise - Solved.xlsx.xlsx

14.8KB

5/12. Include ROUND in your financial models.mp4

3.13MB

5/12. Include ROUND in your financial models.vtt

1.14KB

5/12.1 Excel-Functions.pdf.pdf

3.18MB

5/12.2 55. Excel-functions-Lecture.xlsx.xlsx

889.91KB

5/12.3 55. Round-Exercise - Unsolved.xlsx.xlsx

11.34KB

5/12.4 55. Round-Exercise - Solved.xlsx.xlsx

11.71KB

5/13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4

34.59MB

5/13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.vtt

8.45KB

5/13.1 56. Vlookup-Hlookup- Lecture - Unsolved.xlsx.xlsx

10.74KB

5/13.2 56. Vlookup-Hlookup- Lecture - Solved.xlsx.xlsx

11.13KB

5/13.3 Excel-Functions.pdf.pdf

3.19MB

5/13.4 56. Vlookup-Hlookup-Exercise - Solved.xlsx.xlsx

13.68KB

5/13.5 56. Vlookup-Hlookup-Exercise - Unsolved.xlsx.xlsx

11.95KB

5/14. How to enlarge the formula bar.mp4

6.26MB

5/14. How to enlarge the formula bar.vtt

1.37KB

5/14.1 57. Enlarge-the-formula-bar-Lecture.xlsm.xlsm

46.89KB

5/15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4

38.95MB

5/15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.vtt

8.22KB

5/15.1 58. Index-Match-Lecture - Solved.xlsx.xlsx

11.7KB

5/15.2 Excel-Functions.pdf.pdf

3.18MB

5/15.3 58. Index-Match-Exercise - Solved.xlsx.xlsx

12.08KB

5/15.4 58. Index-Match-Lecture - Unsolved.xlsx.xlsx

11.29KB

5/15.5 58. Index-Match-Exercise - Unsolved.xlsx.xlsx

11.59KB

5/16. A great Excel technique INDEX, MATCH, MATCH.mp4

11.76MB

5/16. A great Excel technique INDEX, MATCH, MATCH.vtt

5.27KB

5/16.1 59. Exercise-Index-Match-Match-Solved.xlsx.xlsx

12.21KB

5/16.2 59. Exercise-Index-Match-Match-Unsolved.xlsx.xlsx

11.58KB

5/17. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.html

160B

5/18. Using Excel's IFERROR function to trap spreadsheet errors.mp4

7.52MB

5/18. Using Excel's IFERROR function to trap spreadsheet errors.vtt

2.05KB

5/18.1 60. Iferror - Lecture - Unsolved.xlsm.xlsm

897.26KB

5/18.2 60. Iferror-Exercise - Solved.xlsx.xlsx

15.37KB

5/18.3 60. Iferror-Exercise - Unsolved.xlsx.xlsx

14.26KB

5/18.4 Excel-Functions.pdf.pdf

3.19MB

5/18.5 60. Iferror - Lecture - Solved.xlsm.xlsm

896.43KB

5/19. RANK is a valuable tool when using Excel for Financial and Business analysis.mp4

23.24MB

5/19. RANK is a valuable tool when using Excel for Financial and Business analysis.vtt

2.82KB

5/19.1 61. Rank-function-Lecture-after.xlsx.xlsx

12.61KB

5/19.2 61. Rank-function-Lecture-before.xlsx.xlsx

12.27KB

5/2. Key functions in Excel IF.mp4

16.65MB

5/2. Key functions in Excel IF.vtt

2.87KB

5/2.1 47. IF-function--Lecture-before.xlsm.xlsm

17KB

5/2.2 Functions - English to German.pdf.pdf

102.32KB

5/2.3 Key functions - Excel.pdf.pdf

8.46MB

5/2.4 47. IF-function-Lecture-after.xlsm.xlsm

17.94KB

5/2.5 Functions - English to Spanish.pdf.pdf

102.37KB

5/2.6 Functions - English to Portuguese.pdf.pdf

146.09KB

5/20. Learn how to render your models flexible with CHOOSE.mp4

8.98MB

5/20. Learn how to render your models flexible with CHOOSE.vtt

2.64KB

5/20.1 62. Choose-Lecture - Unsolved.xlsx.xlsx

9.33KB

5/20.2 62. Choose-Lecture - Solved.xlsx.xlsx

9.69KB

5/20.3 62. Choose-Exercise-Solved.xlsx.xlsx

11.73KB

5/20.4 Excel-Functions.pdf.pdf

3.19MB

5/20.5 62. Choose-Exercise - Unsolved.xlsx.xlsx

11.32KB

5/21. Use Goal Seek to find the result that you are looking for.mp4

7.86MB

5/21. Use Goal Seek to find the result that you are looking for.vtt

2.56KB

5/21.1 63. Goal-Seek-Exercise - Unsolved.xlsx.xlsx

16.09KB

5/21.2 Excel-Functions.pdf.pdf

3.19MB

5/21.3 63. Goal-Seek-Exercise-Solved.xlsx.xlsx

16.21KB

5/21.4 63. Goal-Seek-Lecture - Solved.xlsx.xlsx

9.17KB

5/21.5 63. Goal-Seek-Lecture - Unsolved.xlsx.xlsx

9.15KB

5/22. Use Goal Seek in order to find the result that you are looking for.html

160B

5/23. Include sensitivity analysis in your models through Data Tables.mp4

14.29MB

5/23. Include sensitivity analysis in your models through Data Tables.vtt

4.65KB

5/23.1 64. Sensitivity analysis - Lecture - Solved.xlsm.xlsm

897.3KB

5/23.2 64. Sensitivity-analysis-Exercise-Unsolved.xlsm.xlsm

66.82KB

5/23.3 64. Sensitivity-analysis-Exercise-Solved.xlsm.xlsm

63.87KB

5/23.4 64. Sensitivity analysis - Lecture - Unsolved.xlsm.xlsm

897.09KB

5/24. Include sensitivity analysis in your models through Data Tables.html

160B

5/25. Excel's dynamic and interactive tables Pivot tables.mp4

16.59MB

5/25. Excel's dynamic and interactive tables Pivot tables.vtt

2.58KB

5/25.1 65. Pivot tables - Lecture - Unsolved.xlsm.xlsm

687.83KB

5/25.2 65. Pivot Tables - Exercise - Unsolved.xlsx.xlsx

152.17KB

5/25.3 65. Pivot tables - Lecture - Solved.xlsm.xlsm

897.26KB

5/25.4 65. Pivot Tables - Exercise - Solved.xlsx.xlsx

190.47KB

5/26. Excel's key functions and functionalities made easy.html

159B

5/3. Key Excel functions SUM, SUMIF and SUMIFS.mp4

19.32MB

5/3. Key Excel functions SUM, SUMIF and SUMIFS.vtt

4.92KB

5/3.1 48. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx.xlsx

12.93KB

5/3.2 48. Sum-Sumif-Sumifs-Lecture - Solved.xlsx.xlsx

13.01KB

5/3.3 48. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx.xlsx

14.46KB

5/3.4 Excel-Functions.pdf.pdf

3.18MB

5/3.5 48. Sum-Sumif-Sumifs-Exercise - Solved.xlsx.xlsx

14.84KB

5/4. = and + are interchangeable when you start typing a formula.mp4

5.79MB

5/4. = and + are interchangeable when you start typing a formula.vtt

975B

5/4.1 49. = and + are interchangeable -after.xlsm.xlsm

17.04KB

5/4.2 49. = and + are interchangeable - before.xlsm.xlsm

17.01KB

5/5. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4

16.99MB

5/5. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.vtt

4.48KB

5/5.1 50.Counts-Exercise-Solved.xlsx.xlsx

16.07KB

5/5.2 Excel-Functions.pdf.pdf

3.18MB

5/5.3 Lecture-Count-Countif-Countifs-Solved.xlsx.xlsx

11.68KB

5/5.4 Lecture-Count-Countif-Countifs-Unsolved.xlsx.xlsx

11.29KB

5/5.5 50.Counts-Exercise-Unsolved.xlsx.xlsx

15.56KB

5/6. Key Excel functions AVERAGE and AVERAGEIF.mp4

7.86MB

5/6. Key Excel functions AVERAGE and AVERAGEIF.vtt

2.24KB

5/6.1 Excel-Functions.pdf.pdf

3.18MB

5/6.2 51. Average-AverageIF-Exercise - Solved.xlsx.xlsx

15.02KB

5/6.3 51. Average-Averageif- Lecture - Unsolved.xlsx.xlsx

9.03KB

5/6.4 51. Average-AverageIF-Exercise - Unsolved.xlsx.xlsx

14.6KB

5/6.5 51. Average-Averageif- Lecture - Solved.xlsx.xlsx

9.4KB

5/7. Key Excel functions AVERAGE and AVERAGEIF.html

160B

5/8. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4

16.8MB

5/8. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.vtt

5.3KB

5/8.1 52. Text-Functions- Lecture - Solved.xlsx.xlsx

11.1KB

5/8.2 52. Text functions - Exercise - Unsolved.xlsx.xlsx

11.71KB

5/8.3 52. Text functions - Exercise - Solved.xlsx.xlsx

12.24KB

5/8.4 52. Text-Functions- Lecture - Unsolved.xlsx.xlsx

10.6KB

5/9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.html

160B

6. Update! SUMIFS - Exercise/1. Exercise - Excel's SUMIFS function - unsolved.html

164B

6. Update! SUMIFS - Exercise/2. Exercise - Excel's SUMIFS function - solved & explained.mp4

35.31MB

6. Update! SUMIFS - Exercise/2. Exercise - Excel's SUMIFS function - solved & explained.vtt

10.03KB

6. Update! SUMIFS - Exercise/2.1 67. Exercise-Sumifs-With-Solutions.xlsx.xlsx

1.29MB

7. Financial functions in Excel/1. Future and present values in Excel.mp4

14.96MB

7. Financial functions in Excel/1. Future and present values in Excel.vtt

6.31KB

7. Financial functions in Excel/1.1 68. FV and PV-Lecture.xlsx.xlsx

10.64KB

7. Financial functions in Excel/2. Calculating the rate of return of an investment with the IRR function.mp4

7.58MB

7. Financial functions in Excel/2. Calculating the rate of return of an investment with the IRR function.vtt

3.28KB

7. Financial functions in Excel/2.1 69. Exercise-IRR-Solved.xlsx.xlsx

12.31KB

7. Financial functions in Excel/2.2 69. IRR-Lecture.xlsx.xlsx

11.2KB

7. Financial functions in Excel/2.3 69. Exercise-IRR-Unsolved.xlsx.xlsx

11.52KB

7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.mp4

14.82MB

7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.vtt

5.9KB

7. Financial functions in Excel/3.1 70. Loan Schedule-Lecture.xlsx.xlsx

20.17KB

7. Financial functions in Excel/3.2 70. Exercise-Loan-Schedule-Solved.xlsx.xlsx

22.68KB

7. Financial functions in Excel/3.3 70. Exercise-Loan-Schedule-Unsolved.xlsx.xlsx

15.81KB

7. Financial functions in Excel/4. Date functions in Excel.mp4

11.35MB

7. Financial functions in Excel/4. Date functions in Excel.vtt

5.51KB

7. Financial functions in Excel/4.1 71. Date Functions-Exercise-Solved.xlsx.xlsx

12.43KB

7. Financial functions in Excel/4.2 71. Date Functions-Lecture.xlsx.xlsx

12.25KB

7. Financial functions in Excel/4.3 71. Date Functions-Exercise-Unsolved.xlsx.xlsx

11.41KB

8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.mp4

6MB

8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.vtt

1.99KB

8. Microsoft Excel's Pivot Tables in Depth/2. Creating Pivot Tables easily!.mp4

19.38MB

8. Microsoft Excel's Pivot Tables in Depth/2. Creating Pivot Tables easily!.vtt

4.01KB

8. Microsoft Excel's Pivot Tables in Depth/2.1 73. Creating-a-Pivot-Table - Lecture - after.xlsx.xlsx

1.43MB

8. Microsoft Excel's Pivot Tables in Depth/2.2 73. Creating-a-Pivot-Table - Lecture – before.xlsx.xlsx

1.23MB

8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.mp4

11.28MB

8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.vtt

2.22KB

8. Microsoft Excel's Pivot Tables in Depth/3.1 74. Formatting-a-Pivot-Table - Lecture - after.xlsx.xlsx

1.43MB

8. Microsoft Excel's Pivot Tables in Depth/3.2 74. Formatting-a-Pivot-Table - Lecture - before.xlsx.xlsx

1.43MB

8. Microsoft Excel's Pivot Tables in Depth/4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4

23MB

8. Microsoft Excel's Pivot Tables in Depth/4. Modifying and pivoting fields to obtain the Pivot Table you need.vtt

4.28KB

8. Microsoft Excel's Pivot Tables in Depth/4.1 75. Working-with-Pivot-Tables - Lecture - before.xlsx.xlsx

1.43MB

8. Microsoft Excel's Pivot Tables in Depth/4.2 75. Working-with-Pivot-Tables - Lecture - after.xlsx.xlsx

1.88MB

8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GETPIVOTDATA - A very important Excel function.mp4

18.06MB

8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GETPIVOTDATA - A very important Excel function.vtt

3.77KB

8. Microsoft Excel's Pivot Tables in Depth/5.1 76. GetPivotData - Lecture - before.xlsx.xlsx

1.88MB

8. Microsoft Excel's Pivot Tables in Depth/5.2 76. GetPivotData - Lecture – after.xlsx.xlsx

1.88MB

8. Microsoft Excel's Pivot Tables in Depth/6. An introduction to slicers - The modern-day Pivot Table filters.mp4

22.17MB

8. Microsoft Excel's Pivot Tables in Depth/6. An introduction to slicers - The modern-day Pivot Table filters.vtt

4.42KB

8. Microsoft Excel's Pivot Tables in Depth/6.1 77. Slicers - Lecture - after.xlsx.xlsx

1.88MB

8. Microsoft Excel's Pivot Tables in Depth/6.2 77. Slicers - Lecture - before.xlsx.xlsx

1.88MB

9/1. Case study - Build a P&L from scratch - Welcome lecture.mp4

3.14MB

9/1. Case study - Build a P&L from scratch - Welcome lecture.vtt

1.53KB

9/10. Use INDEX & MATCH as a substitute for VLOOKUP.mp4

49.58MB

9/10. Use INDEX & MATCH as a substitute for VLOOKUP.vtt

4.24KB

9/10.1 87. Index Match-Lecture-before.xlsm.xlsm

41.04KB

9/10.2 87. Index Match-Lecture-after.xlsm.xlsm

13.86MB

9/11. Mapping the rows in the Database sheet.mp4

32.48MB

9/11. Mapping the rows in the Database sheet.vtt

2.66KB

9/11.1 88. Mapping-Lecture-after.xlsm.xlsm

50.24KB

9/11.2 88. Mapping_before.xlsm.xlsm

50.55KB

9/12. In case you have any doubts about the Mapping exercise.mp4

38.56MB

9/12. In case you have any doubts about the Mapping exercise.vtt

6.34KB

9/12.1 89. Mapping-Lecture-Unsolved.xlsm.xlsm

50.55KB

9/12.2 89. Mapping-exercise-explained.pdf.pdf

243.03KB

9/12.3 89. Mapping-Lecture-Solved.xlsx.xlsx

47.5KB

9/13. Building the structure of the P&L sheet.mp4

20.86MB

9/13. Building the structure of the P&L sheet.vtt

2.19KB

9/13.1 90. Building a P&L-Lecture-before.xlsm.xlsm

50.24KB

9/13.2 90. Building a P&L-Lecture-after.xlsm.xlsm

51.83KB

9/14. Formatting sets You apart from the competition in Excel - A Practical Example.mp4

25.42MB

9/14. Formatting sets You apart from the competition in Excel - A Practical Example.vtt

22.02MB

9/14.1 91. Formatting a P&L-Lecture-before.xlsm.xlsm

51.84KB

9/14.2 91. Formatting the P&L-Lecture-after.xlsm.xlsm

51.96KB

9/15. Populate the P&L sheet with SUMIF.mp4

30.26MB

9/15. Populate the P&L sheet with SUMIF.vtt

2.92KB

9/15.1 92. Formatting the P&L-Lecture-after.xlsm.xlsm

53.51KB

9/15.2 92. Formatting the P&L-Lecture-before.xlsm.xlsm

52KB

9/16. Learn how to find mistakes with COUNTIF.mp4

27.87MB

9/16. Learn how to find mistakes with COUNTIF.vtt

2.8KB

9/16.1 93. Countif-Lecture-after.xlsm.xlsm

54.78KB

9/16.2 93. Countif-Lecture-before.xlsm.xlsm

53.51KB

9/17. Calculating year-on-year percentage variations the proper way.mp4

29.98MB

9/17. Calculating year-on-year percentage variations the proper way.vtt

3.24KB

9/17.1 94. Adding % variations-Lecture-after.xlsm.xlsm

56.51KB

9/17.2 94. Adding % variations-Lecture-before.xlsm.xlsm

54.78KB

9/17.3 Y-o-Y Function explanation.pdf.pdf

164.92KB

9/2. Introduction to the case study.mp4

10.21MB

9/2. Introduction to the case study.vtt

1.09KB

9/3. Understand your data source before you start working on it.mp4

28.16MB

9/3. Understand your data source before you start working on it.vtt

2.99KB

9/3.1 80. Get to know the data source.xlsm.xlsm

43.03KB

9/4. Order the source worksheets.mp4

26.54MB

9/4. Order the source worksheets.vtt

2.41KB

9/4.1 81. Order a worksheet_before.xlsm.xlsm

43.08KB

9/4.2 81. Order a worksheet_after.xlsm.xlsm

41.01KB

9/5. Create a code the best way to organize your data and work efficiently with it.mp4

24.49MB

9/5. Create a code the best way to organize your data and work efficiently with it.vtt

2.17KB

9/5.1 82. Creating a code_before.xlsm.xlsm

41.01KB

9/5.2 82. Creating a code_after.xlsm.xlsm

41.73KB

9/6. Learn how to create a database.mp4

20.7MB

9/6. Learn how to create a database.vtt

2.15KB

9/6.1 83. Creating a database_after.xlsm.xlsm

39.39KB

9/6.2 83. Creating a database_before.xlsm.xlsm

41.73KB

9/7. Use VLOOKUP to fill the Database sheet.mp4

61.57MB

9/7. Use VLOOKUP to fill the Database sheet.vtt

5.4KB

9/7.1 84. Vlookup_before.xlsm.xlsm

39.5KB

9/7.2 84. Vlookup_after.xlsm.xlsm

44.45KB

9/8. 50% Completed!.mp4

4.31MB

9/8. 50% Completed!.vtt

51B

9/9. Use SUMIF to complete the Database sheet.mp4

47.94MB

9/9. Use SUMIF to complete the Database sheet.vtt

4.17KB

9/9.1 86. Sumif_after.xlsm.xlsm

49.53KB

9/9.2 86. Sumif_before.xlsm.xlsm

44.45KB

[Tutorialsplanet.NET].url

128B

Latest Search:

1.veni vidi vici 2.weight workouts 3.gdcm- 4.Pornochic Lola & Angelika 5.Faith Makes Great 6.little 7.electric wizard 8.MK05 9.AMWF 10.本能畢露單挑4性交 11.yuna-chan 12.peppa.pig 13.MTVQ1-EP4 14.sprd423 15.sofia+star 16.mybb 17.miaa842 18.legsjapan-1075 19.YST-262 20.T-38013 21.RoccoSiffredi.2160 22.LULU-275 23.Bambi Black 24.BT 4k 25.2021-7-2 26.pkpl-044 27.jewellery 28.hitozuma1396 29.fc-3572974 30.Wicked.19