Download Udemy - Beginner to Pro in Excel Financial Modeling and Valuation [Course Drive] Torrent

Torrent Contents Size: 2.99 GB

Udemy - Beginner to Pro in Excel Financial Modeling and Valuation [Course Drive]

Course Downloaded from coursedrive.net.txt

TXT

428 B

Udemy - Beginner to Pro in Excel Financial Modeling and Valuation

1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!

1. What does the course cover.mp4	MP4	8.95 MB
1. What does the course cover.vtt	VTT	3.11 KB
1.1 Course Notes - Beginner to Pro in Excel.pdf.pdf	PDF	19.04 MB
2. Bonus! Welcome gift.html	HTML	167 B
3. Welcome gift number 2.html	HTML	167 B
4. The approach to take this course.mp4	MP4	7.83 MB
4. The approach to take this course.vtt	VTT	2.37 KB
5. Download all course materials.html	HTML	758 B

10. Case Study - Building an FMCG Model from Scratch

1. Introduction to the Case Study.mp4	MP4	12.05 MB
1. Introduction to the Case Study.vtt	VTT	2.45 KB
1.1 0. Exercise - Build an FMCG Model_before.xlsx.xlsx	XLSX	13.27 MB
10. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4	MP4	17.12 MB
10. Getting fancy with Excel slicers - Good-looking Excel slicers.vtt	VTT	3.4 KB
10.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx	XLSX	22.82 MB
11. This is how the report can be used in practice by high-level executives.mp4	MP4	19.81 MB
11. This is how the report can be used in practice by high-level executives.vtt	VTT	4.38 KB
11.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx	XLSX	22.81 MB
12. Dynamic reporting with GETPIVOTDATA and slicers.html	HTML	166 B
2. Preliminary mapping of the data extraction.mp4	MP4	22.6 MB
2. Preliminary mapping of the data extraction.vtt	VTT	2.43 KB
2.1 1. Exercise - Build an FMCG Model_Mapping.xlsx.xlsx	XLSX	14.9 MB
3. Working with an SAP data extraction.mp4	MP4	21.96 MB
3. Working with an SAP data extraction.vtt	VTT	3.84 KB
4. Creating an output structure of the FMCG model.mp4	MP4	11.66 MB
4. Creating an output structure of the FMCG model.vtt	VTT	2.8 KB
4.1 2. Exercise - Build an FMCG Model_Structure.xlsx.xlsx	XLSX	14.92 MB
5. Improving the layout and appearance of the FMCG report.mp4	MP4	13.51 MB
5. Improving the layout and appearance of the FMCG report.vtt	VTT	4.63 KB
5.1 2. Exercise - Build an FMCG Model_Layout.xlsx.xlsx	XLSX	14.91 MB
6. Inserting formulas and automating calculations.mp4	MP4	8.83 MB
6. Inserting formulas and automating calculations.vtt	VTT	4.63 KB
6.1 4. Exercise - Build an FMCG Model_Adding Calculations.xlsx.xlsx	XLSX	14.92 MB
7. Creating a Master Pivot Table The main data source for the FMCG report.mp4	MP4	13.82 MB
7. Creating a Master Pivot Table The main data source for the FMCG report.vtt	VTT	2.1 KB
7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table.xlsx.xlsx	XLSX	20.82 MB
8. GetPivotData is great! Extracting data from the Master Pivot Table.mp4	MP4	31.05 MB
8. GetPivotData is great! Extracting data from the Master Pivot Table.vtt	VTT	6.68 KB
8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA.xlsx.xlsx	XLSX	20.81 MB
9. Combining Slicers and GetPivotData The key to our success.mp4	MP4	17.83 MB
9. Combining Slicers and GetPivotData The key to our success.vtt	VTT	3.4 KB
9.1 8. Exercise - Build an FMCG Model_Inserting Slicers.xlsx.xlsx	XLSX	20.77 MB

11. Financial Modeling Fundamentals

1. Financial Modeling basics - Welcome lecture.mp4	MP4	2.1 MB
1. Financial Modeling basics - Welcome lecture.vtt	VTT	1.07 KB
10. Forecasting financials - Quiz.html	HTML	163 B
11. Building a complete model - Important considerations.mp4	MP4	6.44 MB
11. Building a complete model - Important considerations.vtt	VTT	2.72 KB
12. Modeling the Income statement.mp4	MP4	12.44 MB
12. Modeling the Income statement.vtt	VTT	7 KB
13. Modeling the Balance sheet - Part 1.mp4	MP4	5.22 MB
13. Modeling the Balance sheet - Part 1.vtt	VTT	3.18 KB
14. Modeling the Balance sheet - Part 2.mp4	MP4	9.38 MB
14. Modeling the Balance sheet - Part 2.vtt	VTT	5.72 KB
15. Building a financial model - Quiz.html	HTML	163 B
2. What is a financial model.mp4	MP4	4.6 MB
2. What is a financial model.vtt	VTT	2.35 KB
3. Why use financial models.mp4	MP4	7.69 MB
3. Why use financial models.vtt	VTT	3.11 KB
4. Financial modeling - worst practices - things you should avoid.mp4	MP4	19.91 MB
4. Financial modeling - worst practices - things you should avoid.vtt	VTT	6.86 KB
5. Financial modeling - best practices.mp4	MP4	17.22 MB
5. Financial modeling - best practices.vtt	VTT	5.69 KB
6. Financial modeling - The types of models that are built in practice.mp4	MP4	12.5 MB
6. Financial modeling - The types of models that are built in practice.vtt	VTT	5.49 KB
7. Financial modeling - Quiz.html	HTML	163 B
8. Financial modeling The right level of detail in a model.mp4	MP4	5.68 MB
8. Financial modeling The right level of detail in a model.vtt	VTT	2.93 KB
9. Financial modeling Forecasting guidelines.mp4	MP4	6.44 MB
9. Financial modeling Forecasting guidelines.vtt	VTT	3.34 KB

12. Introduction to Company Valuation

1. The core theory behind Company Valuation.html

HTML

167 B

13. Introduction to Mergers & Acquisitions

1. Introduction to Mergers & Acquisitions.html

HTML

167 B

14. Learn how to build a Discounted Cash Flow model in Excel

1. Valuation Case study - Welcome lecture.mp4	MP4	1.78 MB
1. Valuation Case study - Welcome lecture.vtt	VTT	869 B
10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4	MP4	5.14 MB
10. Modeling other items Interest expenses, Extraordinary items and Taxes.vtt	VTT	2.8 KB
10.1 9. Interest expenses, Extraordinary items and Taxes - Solved.xlsm.xlsm	XLSM	52.69 KB
10.2 9. Interest expenses, Extraordinary items and Taxes – Unsolved.xlsm.xlsm	XLSM	51.62 KB
11. Forecasting Balance Sheet items.mp4	MP4	1012.43 KB
11. Forecasting Balance Sheet items.vtt	VTT	893 B
11.1 10. Project BS items - Solved.xlsm.xlsm	XLSM	52.7 KB
11.2 10. Project BS items – Unsolved.xlsm.xlsm	XLSM	52.7 KB
12. An introduction to the Days methodology.mp4	MP4	2.28 MB
12. An introduction to the Days methodology.vtt	VTT	1.81 KB
12.1 Working Capital Days.pptx.pptx	PPTX	121.55 KB
13. Calculation of DSO, DPO and DOI for the historical period.mp4	MP4	2.69 MB
13. Calculation of DSO, DPO and DOI for the historical period.vtt	VTT	1.67 KB
13.1 12. Calculating DSO, DPO and DIO - Solved.xlsm.xlsm	XLSM	52.32 KB
13.2 12. Calculating DSO, DPO and DIO - Unsolved.xlsm.xlsm	XLSM	49.85 KB
14. Forecasting DSO, DPO and DOI.mp4	MP4	3.95 MB
14. Forecasting DSO, DPO and DOI.vtt	VTT	2.86 KB
14.1 13. Forecasting DSO, DPO and DIO - Solved.xlsm.xlsm	XLSM	53.65 KB
14.2 13. Forecasting DSO, DPO and DIO - Unsolved.xlsm.xlsm	XLSM	50.09 KB
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4	MP4	4.73 MB
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.vtt	VTT	2.99 KB
15.1 14. Forecasting PP&E, Other assets and Other liabilities - Unsolved.xlsm.xlsm	XLSM	51.05 KB
15.2 14. Forecasting PP&E, Other assets and Other liabilities - Solved.xlsm.xlsm	XLSM	51.03 KB
16. Creating an output P&L sheet.mp4	MP4	3.74 MB
16. Creating an output P&L sheet.vtt	VTT	2.49 KB
16.1 15. P&L structure - Solved.xlsm.xlsm	XLSM	55.38 KB
16.2 15. P&L structure – Unsolved.xlsm.xlsm	XLSM	50.34 KB
17. Populating the output P&L sheet.mp4	MP4	5.36 MB
17. Populating the output P&L sheet.vtt	VTT	2.63 KB
17.1 16. Populating the P&L sheet - Solved.xlsm.xlsm	XLSM	57.18 KB
17.2 16. Populating the P&L sheet – Unsolved.xlsm.xlsm	XLSM	52.73 KB
18. Populating the output BS sheet.mp4	MP4	3.39 MB
18. Populating the output BS sheet.vtt	VTT	2.1 KB
18.1 17. Populating the Balance sheet – Unsolved.xlsm.xlsm	XLSM	54.82 KB
18.2 17. Populating the BS sheet - Solved.xlsm.xlsm	XLSM	58.78 KB
19. Completing the output BS sheet for the historical period.mp4	MP4	7.53 MB
19. Completing the output BS sheet for the historical period.vtt	VTT	4.42 KB
19.1 18. Completing the BS items - Solved.xlsm.xlsm	XLSM	60.02 KB
19.2 18. Completing the BS items – Unsolved.xlsm.xlsm	XLSM	55.7 KB
2. Introduction to the DCF exercise.mp4	MP4	4.5 MB
2. Introduction to the DCF exercise.vtt	VTT	1.29 KB
20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp4	MP4	4.07 MB
20. Creating a structure for the calculation of Unlevered Free Cash Flows.vtt	VTT	3.35 KB
20.1 19. Building a Cash Flow Format – Solved.xlsm.xlsm	XLSM	57.27 KB
20.2 19. Building a Cash Flow Format – Unsolved.xlsm.xlsm	XLSM	56.2 KB
21. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4	MP4	2.73 MB
21. Bridging Unlevered Free Cash Flow to Net Cash Flow.vtt	VTT	2.12 KB
21.1 20. From UFCF to Net Cash Flow – Solved.xlsm.xlsm	XLSM	60.38 KB
21.2 20. From UFCF to Net Cash Flow - Unsolved.xlsm.xlsm	XLSM	56.83 KB
22. Calculating Unlevered Free Cash Flow.mp4	MP4	10.79 MB
22. Calculating Unlevered Free Cash Flow.vtt	VTT	6.77 KB
22.1 21. Calculating UFCF - Unsolved.xlsm.xlsm	XLSM	59.52 KB
22.2 21. Calculating UFCF - Solved.xlsm.xlsm	XLSM	57.96 KB
23. Calculating Net Cash Flow.mp4	MP4	7.1 MB
23. Calculating Net Cash Flow.vtt	VTT	4.52 KB
23.1 Cash Flow Classification By Activities.xlsx	XLSX	55.95 KB
23.2 22. From UFCF to Net Cash Flow - Unsolved.xlsm.xlsm	XLSM	57.89 KB
23.3 22. From UFCF to Net Cash Flow - Solved.xlsm.xlsm	XLSM	61.31 KB
24. Obtaining the rest of the cash flows through Find and Replace.mp4	MP4	9.74 MB
24. Obtaining the rest of the cash flows through Find and Replace.vtt	VTT	4.25 KB
24.1 23. Use Find and Replace - Unsolved.xlsm.xlsm	XLSM	61.31 KB
24.2 23. Use Find and Replace - Solved.xlsm.xlsm	XLSM	64.44 KB
25. Introducing Weighted Average Cost of Capital and Perpetuity Growth.mp4	MP4	2.71 MB
25. Introducing Weighted Average Cost of Capital and Perpetuity Growth.vtt	VTT	2.19 KB
25.1 24. Introducing WACC and g - Unsolved.xlsm.xlsm	XLSM	60.94 KB
25.2 24. Introducing WACC and g - Solved.xlsm.xlsm	XLSM	61.04 KB
26. Discounting Unlevered Free Cash Flows to obtain their Present Value.mp4	MP4	3.97 MB
26. Discounting Unlevered Free Cash Flows to obtain their Present Value.vtt	VTT	3.04 KB
26.1 25. Calculating PV of Cash Flows - Unsolved.xlsm.xlsm	XLSM	58.23 KB
26.2 25. Calculating PV of Cash Flows - Solved.xlsm.xlsm	XLSM	62 KB
27. Calculating Continuing Value and Enterprise Value of the business.mp4	MP4	3.45 MB
27. Calculating Continuing Value and Enterprise Value of the business.vtt	VTT	2.43 KB
27.1 26. Calculating CV of the business - Solved.xlsm.xlsm	XLSM	62.33 KB
27.2 26. Calculating CV of the business - Unsolved.xlsm.xlsm	XLSM	62 KB
28. Calculating Equity Value.mp4	MP4	2.48 MB
28. Calculating Equity Value.vtt	VTT	1.62 KB
28.1 27. Calculating Equity Value - Unsolved.xlsm.xlsm	XLSM	62.33 KB
28.2 27. Calculating Equity Value - Solved.xlsm.xlsm	XLSM	62.56 KB
29. Sensitivity analysis for WACC and perpetuity growth.mp4	MP4	8.61 MB
29. Sensitivity analysis for WACC and perpetuity growth.vtt	VTT	4.52 KB
29.1 28. Sensitivity analysis - Solved.xlsm.xlsm	XLSM	63.87 KB
29.2 Sensitivity Analysis.xlsx	XLSX	60.81 KB
29.3 28. Sensitivity analysis - Unsolved.xlsm.xlsm	XLSM	62.56 KB
3. The various stages of a complete DCF Valuation.mp4	MP4	8.58 MB
3. The various stages of a complete DCF Valuation.vtt	VTT	7.65 KB
3.1 Valuation exercise.pdf.pdf	PDF	411.76 KB
30. A possible application of Goal Seek.mp4	MP4	3.2 MB
30. A possible application of Goal Seek.vtt	VTT	1.86 KB
30.1 29. Goal Seek - Unsolved.xlsm.xlsm	XLSM	63.87 KB
30.2 29. Goal seek - Solved.xlsm.xlsm	XLSM	63.89 KB
31. Using charts to summarize the results of the DCF model.mp4	MP4	8.24 MB
31. Using charts to summarize the results of the DCF model.vtt	VTT	5.56 KB
31.1 30. Charts – Unsolved.xlsm.xlsm	XLSM	63.89 KB
31.2 30. Charts - Solved.xlsm.xlsm	XLSM	97.09 KB
32. You Made It!.mp4	MP4	7.6 MB
32. You Made It!.vtt	VTT	2.63 KB
4. Description of the structure of the DCF model.mp4	MP4	4.48 MB
4. Description of the structure of the DCF model.vtt	VTT	3.45 KB
4.1 DCF Model structure.pdf.pdf	PDF	240.8 KB
4.2 3. Beginning of exercise.xlsm.xlsm	XLSM	48.83 KB
5. A glimpse at the company we are valuing - Cheeseco.mp4	MP4	1.74 MB
5. A glimpse at the company we are valuing - Cheeseco.vtt	VTT	1.43 KB
5.1 Beginning Of Exercise.xlsx	XLSX	42.43 KB
6. Modeling the top line.mp4	MP4	5.14 MB
6. Modeling the top line.vtt	VTT	4.13 KB
6.1 5. Modeling revenues - Solved.xlsm.xlsm	XLSM	49.28 KB
6.2 5. Modeling revenues - Unsolved.xlsm.xlsm	XLSM	48.62 KB
7. Introducing scenarios to the model with Choose.mp4	MP4	3.2 MB
7. Introducing scenarios to the model with Choose.vtt	VTT	2.64 KB
7.1 6. Choose - Solved.xlsm.xlsm	XLSM	49.52 KB
7.2 6. Choose – Unsolved.xlsm.xlsm	XLSM	46.44 KB
8. Modeling other items Other revenues and Cogs.mp4	MP4	7.42 MB
8. Modeling other items Other revenues and Cogs.vtt	VTT	4.37 KB
8.1 7. Modeling Cogs – Unsolved.xlsm.xlsm	XLSM	48.69 KB
8.2 7. Modeling Cogs - Solved.xlsm.xlsm	XLSM	51.89 KB
9. Modeling other items Operating expenses and D&A.mp4	MP4	5.27 MB
9. Modeling other items Operating expenses and D&A.vtt	VTT	2.86 KB
9.1 8. Opex and D&A - Solved.xlsm.xlsm	XLSM	52.3 KB
9.2 8. Opex and D&A - Unsolved.xlsm.xlsm	XLSM	48.95 KB

15. Tesla valuation - Complete practical exercise

1. Organizing external inputs in a 'Drivers' sheet.mp4	MP4	31.01 MB
1. Organizing external inputs in a 'Drivers' sheet.vtt	VTT	4.24 KB
1.1 0a. Drivers_before.xlsx.xlsx	XLSX	1.27 MB
1.2 0a. Drivers_after.xlsx.xlsx	XLSX	1.27 MB
10. Forecasting 'energy' and 'services' revenue.mp4	MP4	25.3 MB
10. Forecasting 'energy' and 'services' revenue.vtt	VTT	3.15 KB
10.1 6. Energy and Other revenue - After.xlsx.xlsx	XLSX	1.34 MB
10.2 6. Energy and Other revenue - Before.xlsx.xlsx	XLSX	1.34 MB
11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4	MP4	26.8 MB
11. Calculating 'energy' and 'services' gross profit and cost of sales.vtt	VTT	2.52 KB
11.1 7. Energy and Other - Gross profit, cost of sales - Before.xlsx.xlsx	XLSX	1.35 MB
11.2 7. Energy and Other - Gross profit, cost of sales - After.xlsx.xlsx	XLSX	1.35 MB
12. Forecasting operating expenses.mp4	MP4	34.45 MB
12. Forecasting operating expenses.vtt	VTT	5.21 KB
12.1 8. Opex - Before.xlsx.xlsx	XLSX	1.36 MB
12.2 8. Opex - After.xlsx.xlsx	XLSX	1.36 MB
13. Building a fixed asset roll forward estimating Capex.mp4	MP4	56.59 MB
13. Building a fixed asset roll forward estimating Capex.vtt	VTT	6.23 KB
13.1 9. PP&E forecasting and comparables_after.xlsx.xlsx	XLSX	1.37 MB
13.2 9. PP&E forecasting and comparables_before.xlsx.xlsx	XLSX	1.37 MB
14. Building a fixed asset roll forward D&A schedule.mp4	MP4	54.2 MB
14. Building a fixed asset roll forward D&A schedule.vtt	VTT	4.13 KB
14.1 10. PP&E schedule_before.xlsx.xlsx	XLSX	1.37 MB
14.2 10. PP&E schedule_after.xlsx.xlsx	XLSX	1.37 MB
15. Peer comparison D&A as a percentage of revenues.mp4	MP4	13.61 MB
15. Peer comparison D&A as a percentage of revenues.vtt	VTT	1.59 KB
15.1 10a. PP&E comparison.xlsx.xlsx	XLSX	1.37 MB
16. Calculating DSO, DIO, DPO.mp4	MP4	17.51 MB
16. Calculating DSO, DIO, DPO.vtt	VTT	2.1 KB
16.1 11. Working capital forecasting_after.xlsx.xlsx	XLSX	1.52 MB
16.2 11. Working capital forecasting_before.xlsx.xlsx	XLSX	1.38 MB
17. Producing a clean P&L output sheet.mp4	MP4	8.43 MB
17. Producing a clean P&L output sheet.vtt	VTT	1.63 KB
17.1 12. P&L.xlsx.xlsx	XLSX	1.39 MB
18. Fill in the P&L output sheet.mp4	MP4	18.34 MB
18. Fill in the P&L output sheet.vtt	VTT	1.74 KB
18.1 12a. P&L fill in_before.xlsx.xlsx	XLSX	1.39 MB
18.2 12a. P&L fill in_after.xlsx.xlsx	XLSX	1.39 MB
19. Calculating investments in working capital.mp4	MP4	19.03 MB
19. Calculating investments in working capital.vtt	VTT	2.11 KB
19.1 13. Calculating working capital_before.xlsx.xlsx	XLSX	1.4 MB
19.2 13. Calculating working capital_after.xlsx.xlsx	XLSX	1.4 MB
2. The input data we will work with.mp4	MP4	15.81 MB
2. The input data we will work with.vtt	VTT	1.64 KB
2.1 0aa. Inputs_after.xlsx.xlsx	XLSX	1.28 MB
2.2 0aa. Inputs_before.xlsx.xlsx	XLSX	1.28 MB
20. Forecasting Unlevered Free Cash Flow.mp4	MP4	55.93 MB
20. Forecasting Unlevered Free Cash Flow.vtt	VTT	6.04 KB
20.1 14. Cash flow - UFCF_before.xlsx.xlsx	XLSX	1.41 MB
20.2 14. Cash flow - UFCF_after.xlsx.xlsx	XLSX	1.41 MB
21. Forecasting other assets.mp4	MP4	45.24 MB
21. Forecasting other assets.vtt	VTT	4.55 KB
21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx	XLSX	1.41 MB
21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx	XLSX	1.41 MB
22. Forecasting other liabilities.mp4	MP4	21.97 MB
22. Forecasting other liabilities.vtt	VTT	2.37 KB
22.1 16. Balance Sheet forecasting liabilities_before.xlsx.xlsx	XLSX	1.41 MB
22.2 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx	XLSX	1.42 MB
23. Completing Unlevered Free Cash Flow.mp4	MP4	40.88 MB
23. Completing Unlevered Free Cash Flow.vtt	VTT	3.52 KB
23.1 16a. Complete UFCF_after.xlsx.xlsx	XLSX	1.42 MB
23.2 16a. Complete UFCF_before.xlsx.xlsx	XLSX	1.42 MB
24. Modeling Tesla's financing needs in the forecast period.mp4	MP4	42.36 MB
24. Modeling Tesla's financing needs in the forecast period.vtt	VTT	5.47 KB
24.1 17. Financing_after.xlsx.xlsx	XLSX	1.43 MB
24.2 17. Financing_before.xlsx.xlsx	XLSX	1.43 MB
25. Calculating Net income.mp4	MP4	14.8 MB
25. Calculating Net income.vtt	VTT	1.39 KB
25.1 18. P&L complete_before.xlsx.xlsx	XLSX	1.43 MB
25.2 18. P&L complete_after.xlsx.xlsx	XLSX	1.43 MB
26. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4	MP4	50.73 MB
26. Bridging Unlevered Free Cash Flow to Net Cash Flow.vtt	VTT	4.38 KB
26.1 19. Cash flow_complete_before.xlsx.xlsx	XLSX	1.43 MB
26.2 19. Cash flow_complete_after.xlsx.xlsx	XLSX	1.43 MB
27. Balancing the Balance sheet.mp4	MP4	13.27 MB
27. Balancing the Balance sheet.vtt	VTT	1.16 KB
27.1 20. Complete the BS_before.xlsx.xlsx	XLSX	1.43 MB
27.2 20. Complete the BS_after.xlsx.xlsx	XLSX	1.43 MB
28. Estimating Weighted Average Cost of Capital (WACC).mp4	MP4	44.27 MB
28. Estimating Weighted Average Cost of Capital (WACC).vtt	VTT	6.79 KB
28.1 21. WACC_after.xlsx.xlsx	XLSX	1.43 MB
28.2 21. WACC_before.xlsx.xlsx	XLSX	1.43 MB
29. Performing Discounted Cash Flow valuation (DCF).mp4	MP4	34.9 MB
29. Performing Discounted Cash Flow valuation (DCF).vtt	VTT	3.93 KB
29.1 22. DCF_before.xlsx.xlsx	XLSX	1.52 MB
29.2 22. DCF_after.xlsx.xlsx	XLSX	1.44 MB
3. Forecasting Tesla's expected deliveries.mp4	MP4	114.91 MB
3. Forecasting Tesla's expected deliveries.vtt	VTT	14.53 KB
3.1 1. Deliveries_before.xlsx.xlsx	XLSX	1.29 MB
3.2 1. Deliveries_after.xlsx.xlsx	XLSX	1.29 MB
30. Calculating enterprise value, equity value, and price per share.mp4	MP4	22.56 MB
30. Calculating enterprise value, equity value, and price per share.vtt	VTT	2.11 KB
30.1 23. EV, Equity value, Price per share_after.xlsx.xlsx	XLSX	1.44 MB
30.2 23. EV, Equity value, Price per share_before.xlsx.xlsx	XLSX	1.44 MB
31. Final comments.mp4	MP4	44.88 MB
31. Final comments.vtt	VTT	4.29 KB
4. Comparing delivery figures with the ones of industry peers.mp4	MP4	20.93 MB
4. Comparing delivery figures with the ones of industry peers.vtt	VTT	3 KB
4.1 1a. Deliveries development.xlsx.xlsx	XLSX	1.3 MB
5. Estimating an average selling price of Tesla vehicles.mp4	MP4	41.92 MB
5. Estimating an average selling price of Tesla vehicles.vtt	VTT	5.04 KB
5.1 2. Average price_after.xlsx.xlsx	XLSX	1.31 MB
5.2 2. Average price_before.xlsx.xlsx	XLSX	1.31 MB
6. Calculating automotive revenue.mp4	MP4	46.57 MB
6. Calculating automotive revenue.vtt	VTT	4.82 KB
6.1 3. Revenue calculation and scenarios - after.xlsx.xlsx	XLSX	1.31 MB
6.2 3. Revenue calculation and scenarios - before.xlsx.xlsx	XLSX	1.31 MB
7. Peer comparison Gross profit %.mp4	MP4	17.17 MB
7. Peer comparison Gross profit %.vtt	VTT	2.73 KB
7.1 4. Gross profit automotive.xlsx.xlsx	XLSX	1.32 MB
8. Calculating automotive gross profit.mp4	MP4	27.76 MB
8. Calculating automotive gross profit.vtt	VTT	2.87 KB
8.1 4a. Gross profit automotive - after.xlsx.xlsx	XLSX	1.32 MB
8.2 4a. Gross profit automotive - before.xlsx.xlsx	XLSX	1.51 MB
9. Calculating automotive cost of sales.mp4	MP4	17.49 MB
9. Calculating automotive cost of sales.vtt	VTT	2.22 KB
9.1 5. Cost of sales and chart.xlsx.xlsx	XLSX	1.34 MB

16. Capital budgeting - The theory

1. Introduction to Capital budgeting.mp4	MP4	5.43 MB
1. Introduction to Capital budgeting.vtt	VTT	1.79 KB
2. Why we need Capital budgeting.mp4	MP4	6.88 MB
2. Why we need Capital budgeting.vtt	VTT	2.7 KB
3. The time value of money.mp4	MP4	6.69 MB
3. The time value of money.vtt	VTT	2.61 KB
4. Calculating future and present Value.mp4	MP4	13.09 MB
4. Calculating future and present Value.vtt	VTT	6.06 KB
5. Calculating cost of equity.mp4	MP4	19.2 MB
5. Calculating cost of equity.vtt	VTT	7.52 KB
6. Coming up with project-specific beta.mp4	MP4	9.01 MB
6. Coming up with project-specific beta.vtt	VTT	3.47 KB
7. Weighted Average Cost of Capital (WACC).mp4	MP4	5.51 MB
7. Weighted Average Cost of Capital (WACC).vtt	VTT	2.4 KB
8. The type of cash flows we will have in a project.mp4	MP4	9.33 MB
8. The type of cash flows we will have in a project.vtt	VTT	3.88 KB
9. Estimating the project's cash flows.mp4	MP4	18.79 MB
9. Estimating the project's cash flows.vtt	VTT	6.61 KB

17. Capital Budgeting - A Complete Case Study

1. Introduction to the Capital Budgeting exercise.mp4	MP4	8.63 MB
1. Introduction to the Capital Budgeting exercise.vtt	VTT	3.21 KB
10. Finding cost of equity.mp4	MP4	13.92 MB
10. Finding cost of equity.vtt	VTT	7.11 KB
10.1 8. WACC_unsolved.xlsx.xlsx	XLSX	35.93 KB
10.2 8. WACC.xlsx.xlsx	XLSX	38.03 KB
11. Discounting the project's cash flows and residual value.mp4	MP4	22.54 MB
11. Discounting the project's cash flows and residual value.vtt	VTT	3.28 KB
11.1 9. Discounted cash flow.xlsx.xlsx	XLSX	38.06 KB
11.2 9. Discounted cash flow_unsolved.xlsx.xlsx	XLSX	37.25 KB
12. Performing sensitivity analysis and completing the exercise.mp4	MP4	34.11 MB
12. Performing sensitivity analysis and completing the exercise.vtt	VTT	4.85 KB
12.1 10. Sensitivty analysis_unsolved.xlsx.xlsx	XLSX	38.63 KB
12.2 10. Sensitivty analysis.xlsx.xlsx	XLSX	38.81 KB
13. Build a complete capital budgeting model from scratch.html	HTML	166 B
14. Congratulations!!.mp4	MP4	2.31 MB
14. Congratulations!!.vtt	VTT	1.5 KB
2. Organizing an Inputs sheet.mp4	MP4	11.05 MB
2. Organizing an Inputs sheet.vtt	VTT	6.04 KB
2.1 1. Drivers.xlsx.xlsx	XLSX	11.5 KB
3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4	MP4	9.21 MB
3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.vtt	VTT	3.95 KB
3.1 2. Savings Forecast_unsolved.xlsx.xlsx	XLSX	14.74 KB
3.2 2. Savings Forecast.xlsx.xlsx	XLSX	16.58 KB
4. Fixed asset rollforward.mp4	MP4	12.16 MB
4. Fixed asset rollforward.vtt	VTT	5.04 KB
4.1 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx	XLSX	18.54 KB
4.2 3. Fixed Asset Rollforward.xlsx.xlsx	XLSX	19.66 KB
5. The impact of working capital.mp4	MP4	5.36 MB
5. The impact of working capital.vtt	VTT	2.94 KB
5.1 4. Working Capital_unsolved.xlsx.xlsx	XLSX	21.19 KB
5.2 4. Working Capital_unsolved.xlsx.xlsx	XLSX	21.19 KB
6. Modeling debt financing.mp4	MP4	6.18 MB
6. Modeling debt financing.vtt	VTT	3.24 KB
6.1 5. Financing.xlsx.xlsx	XLSX	30.97 KB
6.2 5. Financing_unsolved.xlsx.xlsx	XLSX	29.99 KB
7. Adding a P&L sheet.mp4	MP4	4.88 MB
7. Adding a P&L sheet.vtt	VTT	2.06 KB
7.1 6. P&L_unsolved.xlsx.xlsx	XLSX	29.7 KB
7.2 6. P&L.xlsx.xlsx	XLSX	31.03 KB
8. Calculating project cash flows.mp4	MP4	10.14 MB
8. Calculating project cash flows.vtt	VTT	3.72 KB
8.1 7. Cash flow_unsolved.xlsx.xlsx	XLSX	29.64 KB
8.2 7. Cash flow.xlsx.xlsx	XLSX	31.36 KB
9. Estimating the weighted average cost of capital (WACC).mp4	MP4	5.58 MB
9. Estimating the weighted average cost of capital (WACC).vtt	VTT	3.29 KB
9.1 8. WACC.xlsx.xlsx	XLSX	38.03 KB
9.2 8. WACC_unsolved.xlsx.xlsx	XLSX	35.93 KB

18. Bonus lecture

1. Bonus lecture Next steps.html

HTML

2.13 KB

2. Introduction to Excel

1. Introduction to Excel - welcome lecture.mp4	MP4	1.99 MB
1. Introduction to Excel - welcome lecture.vtt	VTT	911 B
10. Introduction to Excel formulas.html	HTML	163 B
11. Introduction to Excel functions.mp4	MP4	12.06 MB
11. Introduction to Excel functions.vtt	VTT	4.36 KB
11.1 02 12 Functions Exercise & Text.xlsx.xlsx	XLSX	13.26 KB
11.2 Functions - Solved.xlsx.xlsx	XLSX	9.34 KB
11.3 02 12 Functions Solved.xlsx.xlsx	XLSX	81.1 KB
11.4 Functions – Unsolved.xlsx.xlsx	XLSX	9.24 KB
12. Cut, copy, & paste.mp4	MP4	7.57 MB
12. Cut, copy, & paste.vtt	VTT	2.3 KB
12.1 02 13 Copy Cut Paste Exercise Text.xlsx.xlsx	XLSX	11.34 KB
12.2 02 13 Copy Cut Paste Solved.xlsx.xlsx	XLSX	12.56 KB
13. Cut, copy, & paste.html	HTML	163 B
14. Paste special.mp4	MP4	6.69 MB
14. Paste special.vtt	VTT	1.49 KB
14.1 02 14 Paste Special Exercise & Text.xlsx.xlsx	XLSX	13.47 KB
14.2 02 14 Paste Special Solved.xlsx.xlsx	XLSX	13.46 KB
15. Basic operations in Excel - 38 pages.html	HTML	167 B
2. Overview of Excel.mp4	MP4	13.96 MB
2. Overview of Excel.vtt	VTT	3.87 KB
2.1 02 6 Overview of Excel Exercise & Text.xlsx.xlsx	XLSX	10.47 KB
2.2 02 6 Overview of Excel Solved.xlsx.xlsx	XLSX	10.88 KB
3. Overview of Excel.html	HTML	163 B
4. Basic manipulations with rows and columns.mp4	MP4	6.9 MB
4. Basic manipulations with rows and columns.vtt	VTT	1.96 KB
4.1 02 7 Basic Manipulations Exercise Text.xlsx.xlsx	XLSX	11.4 KB
4.2 02 7 Basic Manipulations Solved.xlsx.xlsx	XLSX	32.87 KB
5. Rows and columns.html	HTML	163 B
6. The Excel ribbon.mp4	MP4	8.8 MB
6. The Excel ribbon.vtt	VTT	2.99 KB
6.1 02 8 The Ribbon Solved.xlsx.xlsx	XLSX	403.25 KB
6.2 02 8 The Ribbon Exercise & Text.xlsx.xlsx	XLSX	12.09 KB
7. Data entry in Excel.mp4	MP4	10.39 MB
7. Data entry in Excel.vtt	VTT	3.32 KB
7.1 02 9 Data Entry Exercise Text.xlsx.xlsx	XLSX	10.97 KB
7.2 02 9 Data Entry Solved.xlsx.xlsx	XLSX	32.76 KB
8. Introduction to formatting.mp4	MP4	24.75 MB
8. Introduction to formatting.vtt	VTT	6.14 KB
8.1 Formatting - Solved.xlsx.xlsx	XLSX	9.85 KB
8.2 02 10 Formatting Solved.xlsx.xlsx	XLSX	11.59 KB
8.3 02 10 Formatting Exercise Text.xlsx.xlsx	XLSX	11.61 KB
8.4 Formatting - Unsolved.xlsx.xlsx	XLSX	18.91 KB
9. Introduction to Excel formulas.mp4	MP4	5.85 MB
9. Introduction to Excel formulas.vtt	VTT	4.13 KB
9.1 Formulas – Unsolved.xlsx.xlsx	XLSX	9.3 KB
9.2 Formulas - Solved.xlsx.xlsx	XLSX	9.36 KB
9.3 02 11 Formulas Exercise Text.xlsx.xlsx	XLSX	11.72 KB
9.4 02 11 Formulas Solved.xlsx.xlsx	XLSX	80.13 KB

3. Useful tips and tools for your work in Excel

1. Excel best practices - Welcome lecture.mp4	MP4	2.13 MB
1. Excel best practices - Welcome lecture.vtt	VTT	1.02 KB
10. Learn how to use the Wrap Text button.mp4	MP4	908.39 KB
10. Learn how to use the Wrap Text button.vtt	VTT	869 B
10.1 Useful Tips & Tools PDF Version.pdf	PDF	9.43 MB
10.2 03 22 Wrap Text Exercise & Text.xlsx.xlsx	XLSX	10.17 KB
10.3 03 22 Wrap Text Solved.xlsx.xlsx	XLSX	10.2 KB
10.4 Wrap text – Unsolved.xlsx.xlsx	XLSX	9.61 KB
10.5 Wrap text - Solved.xlsx.xlsx	XLSX	9.61 KB
11. Create easily printable documents in Excel by using Set Print Area.mp4	MP4	1.71 MB
11. Create easily printable documents in Excel by using Set Print Area.vtt	VTT	1.5 KB
11.1 Useful Tips & Tools PDF Version.pdf	PDF	9.43 MB
11.2 Set Print Area – Unsolved.xlsx.xlsx	XLSX	11.42 KB
11.3 Set Print Area - Solved.xlsx.xlsx	XLSX	11.22 KB
12. Find and select special types of cells with Select Special (F5).mp4	MP4	3.04 MB
12. Find and select special types of cells with Select Special (F5).vtt	VTT	1.83 KB
12.1 Useful Tips & Tools PDF Version.pdf	PDF	9.43 MB
12.2 03 24 Select Special (F5) Solved.xlsx.xlsx	XLSX	22.27 KB
12.3 03 24 Select Special (F5) Exercise & Text.xlsx.xlsx	XLSX	21.59 KB
12.4 Select Special.xlsx.xlsx	XLSX	10.56 KB
13. Select Special.html	HTML	163 B
14. Learn how to assign dynamic names within a financial model.mp4	MP4	2.33 MB
14. Learn how to assign dynamic names within a financial model.vtt	VTT	1.56 KB
14.1 03 25 Assigning Dynamic Names Exercise & Text.xlsx.xlsx	XLSX	11.23 KB
14.2 Dynamic Naming – Unsolved.xlsx.xlsx	XLSX	13.54 KB
14.3 Dynamic Naming - Solved.xlsx.xlsx	XLSX	13.83 KB
14.4 Useful Tips & Tools PDF Version.pdf	PDF	9.44 MB
14.5 03 25 Assigning Dynamic Names Solved.xlsx.xlsx	XLSX	11.73 KB
15. Assigning dynamic names.html	HTML	163 B
16. Define a named range in Excel.mp4	MP4	2.12 MB
16. Define a named range in Excel.vtt	VTT	1.62 KB
16.1 Naming ranges - Solved.xlsx.xlsx	XLSX	10.34 KB
16.2 Naming ranges – Unsolved.xlsx.xlsx	XLSX	8.79 KB
16.3 Useful Tips & Tools PDF Version.pdf	PDF	9.43 MB
16.4 03 26 Defining a Named Range Solved.xlsx.xlsx	XLSX	11.65 KB
16.5 03 26 Defining a Named Range Exercise & Text.xlsx.xlsx	XLSX	11.07 KB
17. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4	MP4	2.14 MB
17. Assign custom formats to specific cells within a financial model (e.g Multiples).vtt	VTT	1.87 KB
17.1 Useful Tips & Tools PDF Version.pdf	PDF	9.43 MB
17.2 03 27 Assigning Custom Formats Solved.xlsx.xlsx	XLSX	11.08 KB
17.3 03 27 Assigning Custom Formats Exercise & Text.xlsx.xlsx	XLSX	11.35 KB
18. Macros are a great timesaver! Here's why!.mp4	MP4	4.33 MB
18. Macros are a great timesaver! Here's why!.vtt	VTT	3.34 KB
18.1 03 28 Macros Solved.xlsx.xlsx	XLSX	145.02 KB
18.2 03 28 Macros Exercise & Text.xlsx.xlsx	XLSX	10.34 KB
18.3 Creating a Macro - Unsolved.xlsx.xlsx	XLSX	9.66 KB
18.4 Creating a Macro - Solved.xlsx.xlsx	XLSX	11.17 KB
18.5 Useful Tips & Tools PDF Version.pdf	PDF	9.43 MB
19. Excel Macros - quiz.html	HTML	163 B
2. Initial formatting of an Excel sheet to render it professional.mp4	MP4	3.35 MB
2. Initial formatting of an Excel sheet to render it professional.vtt	VTT	2.16 KB
2.1 Formatting a worksheet – Unsolved.xlsx.xlsx	XLSX	8.98 KB
2.2 Useful Tips & Tools PDF Version.pdf	PDF	9.43 MB
2.3 03 17 Formatting a Worksheet Exercise & Text.xlsx.xlsx	XLSX	10.63 KB
2.4 Formatting a worksheet - Solved.xlsx.xlsx	XLSX	9.56 KB
2.5 03 17 Formatting a Worksheet Solved.xlsx.xlsx	XLSX	10.76 KB
20. Create a drop-down list by using Data Validation.mp4	MP4	3.3 MB
20. Create a drop-down list by using Data Validation.vtt	VTT	2.1 KB
20.1 03 29 Drop-down List Exercise & Text.xlsx.xlsx	XLSX	11.34 KB
20.2 03 29 Drop-down List Solved.xlsx.xlsx	XLSX	77.02 KB
20.3 Data Validation - Solved.xlsx.xlsx	XLSX	10.84 KB
20.4 Data Validation – Unsolved.xlsx.xlsx	XLSX	10.84 KB
20.5 Useful Tips & Tools PDF Version.pdf	PDF	9.43 MB
21. Using Custom-sort in order to sort multiple columns within a table.mp4	MP4	2.79 MB
21. Using Custom-sort in order to sort multiple columns within a table.vtt	VTT	1.59 KB
21.1 03 30 Custom Sort Solved.xlsx.xlsx	XLSX	11.46 KB
21.2 Sort data - Solved.xlsx.xlsx	XLSX	145.65 KB
21.3 03 30 Custom Sort Exercise & Text.xlsx.xlsx	XLSX	11.37 KB
21.4 Useful Tips & Tools PDF Version.pdf	PDF	9.43 MB
21.5 Sort data – Unsolved.xlsx.xlsx	XLSX	145.35 KB
22. Create a great Index page at the beginning of your models - Hyperlinks.mp4	MP4	1.9 MB
22. Create a great Index page at the beginning of your models - Hyperlinks.vtt	VTT	1.51 KB
22.1 Useful Tips & Tools PDF Version.pdf	PDF	9.43 MB
22.2 Useful Tips And Tools Excel File.xlsx	XLSX	2.25 MB
22.3 03 31 Hyperlinks Exercise & Text.xlsx.xlsx	XLSX	136.89 KB
22.4 03 31 Hyperlinks Solved.xlsx.xlsx	XLSX	137.06 KB
23. Fix the top row of your table with Freeze Panes.mp4	MP4	5.2 MB
23. Fix the top row of your table with Freeze Panes.vtt	VTT	1.42 KB
23.1 Freeze Panes - Solved.xlsx.xlsx	XLSX	643.94 KB
23.2 Freeze Panes – Unsolved.xlsx.xlsx	XLSX	643.87 KB
23.3 Useful Tips & Tools PDF Version.pdf	PDF	9.44 MB
24. Filter by color - an excellent tool.mp4	MP4	9.87 MB
24. Filter by color - an excellent tool.vtt	VTT	2.02 KB
24.1 Exercise_Filter by Color.xlsx.xlsx	XLSX	20.47 KB
24.2 Solution_Filter by Color.xlsx.xlsx	XLSX	153.48 KB
25. Working with conditional formatting.mp4	MP4	15.09 MB
25. Working with conditional formatting.vtt	VTT	5.6 KB
25.1 Exercise_Conditional Formatting.xlsx.xlsx	XLSX	12.88 KB
25.2 Solution_Conditional Formatting.xlsx.xlsx	XLSX	51.52 KB
26. Useful tips and tools for your work in Excel - quiz.html	HTML	162 B
3. Fast scrolling through Excel sheets.mp4	MP4	6.26 MB
3. Fast scrolling through Excel sheets.vtt	VTT	1.73 KB
3.1 2. Fast Scrolling - Solved.xlsx.xlsx	XLSX	642.51 KB
3.2 Useful tips and tools - Excel file.xlsx.xlsx	XLSX	2.24 MB
3.3 03 18 Fast Scrolling Exercise & Text.xlsx.xlsx	XLSX	43.9 KB
3.4 Useful Tips & Tools PDF Version.pdf	PDF	9.44 MB
3.5 03 18 Fast Scrolling Solved.xlsx.xlsx	XLSX	44.35 KB
4. Fast scrolling through Excel sheets.html	HTML	163 B
5. Introduction to fixing of cell references.mp4	MP4	6.13 MB
5. Introduction to fixing of cell references.vtt	VTT	2.53 KB
5.1 Useful Tips & Tools PDF Version.pdf	PDF	9.43 MB
5.2 Fixing references - Solved.xlsx.xlsx	XLSX	645.17 KB
5.3 Fixing references – Unsolved.xlsx.xlsx	XLSX	643.98 KB
5.4 03 19 Fixing Cells Solved.xlsx.xlsx	XLSX	10.82 KB
5.5 03 19 Fixing Cells Exercise & Text.xlsx.xlsx	XLSX	10.67 KB
6. Introduction to fixing of cell references.html	HTML	163 B
7. Using the 'Alt + Enter' combination.mp4	MP4	1.46 MB
7. Using the 'Alt + Enter' combination.vtt	VTT	1008 B
7.1 Alt + Enter – Unsolved.xlsx.xlsx	XLSX	9.64 KB
7.2 Useful Tips & Tools PDF Version.pdf	PDF	9.43 MB
7.3 Alt + Enter - Solved.xlsx.xlsx	XLSX	9.65 KB
7.4 03 20 Alt+Enter Exercise & Text.xlsx.xlsx	XLSX	11.12 KB
7.5 03 20 Alt+Enter Solved.xlsx.xlsx	XLSX	11.4 KB
8. Learn how to organize your data with Text to Columns.mp4	MP4	3.94 MB
8. Learn how to organize your data with Text to Columns.vtt	VTT	2.21 KB
8.1 Useful Tips & Tools PDF Version.pdf	PDF	9.44 MB
8.2 Text to columns – Unsolved.xlsx.xlsx	XLSX	9.76 KB
8.3 03 21 Text to Columns Exercise & Text.xlsx.xlsx	XLSX	10.57 KB
8.4 03 21 Text to Columns Solved.xlsx.xlsx	XLSX	11.3 KB
8.5 Text to columns - Solved.xlsx.xlsx	XLSX	9.9 KB
9. Learn how to organize your data with Text to Columns.html	HTML	163 B

4. Keyboard shortcuts in Excel

1. Keyboard shortcuts Save LOTS of time in Excel.mp4	MP4	30.43 MB
1. Keyboard shortcuts Save LOTS of time in Excel.vtt	VTT	5.16 KB
2. Keyboard shortcuts in Excel.html	HTML	167 B

5. Excel's key functions and functionalities made easy

1. Excel's key functions - Welcome lecture.mp4	MP4	2.32 MB
1. Excel's key functions - Welcome lecture.vtt	VTT	1.09 KB
10. Include Round in your financial models.mp4	MP4	1.23 MB
10. Include Round in your financial models.vtt	VTT	1.14 KB
10.1 Excel Functions.xlsx	XLSX	971.02 KB
10.2 Key Functions In Excel.pdf	PDF	9.85 MB
10.3 05 42 Round Exercise & Text.xlsx.xlsx	XLSX	11.34 KB
10.4 05 42 Round Solved.xlsx.xlsx	XLSX	11.71 KB
11. Learn how to transfer data efficiently in Excel Vlookup and Hlookup.mp4	MP4	12.11 MB
11. Learn how to transfer data efficiently in Excel Vlookup and Hlookup.vtt	VTT	8.45 KB
11.1 Key Functions In Excel.pdf	PDF	9.84 MB
11.2 05 43 Vlookup, Hlookup Solved.xlsx.xlsx	XLSX	14.19 KB
11.3 05 43 Vlookup, Hlookup Exercise & Text.xlsx.xlsx	XLSX	11.95 KB
11.4 Vlookup, Hlookup - Unsolved.xlsx.xlsx	XLSX	10.74 KB
11.5 Vlookup, Hlookup – Solved.xlsx.xlsx	XLSX	11.13 KB
12. Index, Match and their combination - the perfect substitute for Vlookup.mp4	MP4	12.81 MB
12. Index, Match and their combination - the perfect substitute for Vlookup.vtt	VTT	8.22 KB
12.1 Solution_Index; Match; Index and Match.xlsx.xlsx	XLSX	17.03 KB
12.2 Index & Match - Unsolved.xlsx.xlsx	XLSX	11.29 KB
12.3 Index & Match – Solved.xlsx.xlsx	XLSX	11.7 KB
12.4 05 44 Index, Match Solved.xlsx.xlsx	XLSX	12.08 KB
12.5 Key Functions In Excel.pdf	PDF	9.84 MB
12.6 Exercise-Index-Match-Index-and-Match (1).xlsx.xlsx	XLSX	15.45 KB
12.7 05 44 Index, Match Exercise & Text.xlsx.xlsx	XLSX	11.59 KB
13. A great Excel technique Index, Match, Match.mp4	MP4	11.76 MB
13. A great Excel technique Index, Match, Match.vtt	VTT	5.27 KB
13.1 Exercise_Index, Match, Match.xlsx.xlsx	XLSX	11.58 KB
13.2 Solution_Index, Match, Match.xlsx.xlsx	XLSX	12.21 KB
14. Index, Match and their combination - the perfect substitute for Vlookup.html	HTML	163 B
15. Using Excel's Iferror function to trap spreadsheet errors.mp4	MP4	2.62 MB
15. Using Excel's Iferror function to trap spreadsheet errors.vtt	VTT	2.05 KB
15.1 Iferror.xlsx.xlsx	XLSX	9.61 KB
15.2 05 45 IFERROR Solved.xlsx.xlsx	XLSX	15.37 KB
15.3 05 45 IFERROR Exercise & Text.xlsx.xlsx	XLSX	14.26 KB
15.4 Key Functions In Excel.pdf	PDF	9.84 MB
15.5 Iferror – Unsolved.xlsx.xlsx	XLSX	9.41 KB
16. Learn how to render your models flexible with Choose.mp4	MP4	3.39 MB
16. Learn how to render your models flexible with Choose.vtt	VTT	2.64 KB
16.1 Key Functions In Excel.pdf	PDF	9.85 MB
16.2 Choose – Unsolved.xlsx.xlsx	XLSX	9.33 KB
16.3 05 46 Choose Solved.xlsx.xlsx	XLSX	11.73 KB
16.4 Choose - Solved.xlsx.xlsx	XLSX	9.69 KB
16.5 05 46 Choose Exercise & Text.xlsx.xlsx	XLSX	11.32 KB
17. Use Goal Seek to find the result that you are looking for.mp4	MP4	3.02 MB
17. Use Goal Seek to find the result that you are looking for.vtt	VTT	2.56 KB
17.1 Goal Seek – Unsolved.xlsx.xlsx	XLSX	8.85 KB
17.2 Key Functions In Excel.pdf	PDF	9.84 MB
17.3 Goal Seek - Solved.xlsx.xlsx	XLSX	8.86 KB
17.4 05 47 Goal Seek Exercise & Text.xlsx.xlsx	XLSX	16.09 KB
17.5 05 47 Goal Seek Solved.xlsx.xlsx	XLSX	16.21 KB
18. Use Goal Seek in order to find the result that you are looking for.html	HTML	163 B
19. Include sensitivity analysis in your models through Data Tables.mp4	MP4	5.43 MB
19. Include sensitivity analysis in your models through Data Tables.vtt	VTT	4.65 KB
19.1 Data Tables – Unsolved.xlsx.xlsx	XLSX	9.25 KB
19.2 Key Functions In Excel.pdf	PDF	9.84 MB
19.3 05 48 Sensitivity Analysis Solved.xlsx.xlsx	XLSX	13.05 KB
19.4 Data Tables - Solved.xlsx.xlsx	XLSX	9.46 KB
19.5 05 48 Sensitivity Analysis Exercise & Text.xlsx.xlsx	XLSX	12.59 KB
2. Key functions in Excel If.html	HTML	167 B
20. Include sensitivity analysis in your models through Data Tables.html	HTML	163 B
21. Excel's dynamic and interactive tables Pivot tables.mp4	MP4	5.32 MB
21. Excel's dynamic and interactive tables Pivot tables.vtt	VTT	2.58 KB
21.1 Key Functions In Excel.pdf	PDF	9.84 MB
21.2 05 49 Pivot Tables Intro Exercise & Text.xlsx.xlsx	XLSX	152.17 KB
21.3 Excel Functions.xlsx	XLSX	971.02 KB
21.4 05 49 Pivot Tables Intro Solved.xlsx.xlsx	XLSX	190.07 KB
21.5 Excel functions.xlsx.xlsx	XLSX	887.32 KB
22. Excel's key functions and functionalities made easy.html	HTML	162 B
3. Key Excel functions Sum, Sumif and Sumifs.mp4	MP4	6.73 MB
3. Key Excel functions Sum, Sumif and Sumifs.vtt	VTT	4.92 KB
3.1 Sum, Sumif, Sumifs - Unsolved.xlsx.xlsx	XLSX	12.93 KB
3.2 Key Functions In Excel.pdf	PDF	9.84 MB
3.3 05 37 Sum, Sumif, Sumifs Exercise & Text.xlsx.xlsx	XLSX	14.46 KB
3.4 Sum, Sumif, Sumifs – Solved.xlsx.xlsx	XLSX	13.01 KB
3.5 05 37 Sum, Sumif, Sumifs Solved.xlsx.xlsx	XLSX	14.84 KB
4. Key Excel functions Count, Counta, Countif, Countifs.mp4	MP4	6 MB
4. Key Excel functions Count, Counta, Countif, Countifs.vtt	VTT	4.48 KB
4.1 05-38-Counts-Solved.xlsx.xlsx	XLSX	16.11 KB
4.2 Count, Countif, Countifs – Unsolved.xlsx.xlsx	XLSX	11.29 KB
4.3 05 38 Counts Exercise & Text.xlsx.xlsx	XLSX	15.26 KB
4.4 Count, Countif, Countifs - Solved.xlsx.xlsx	XLSX	11.68 KB
4.5 Key Functions In Excel.pdf	PDF	9.84 MB
5. Key Excel functions Average and Averageif.mp4	MP4	2.77 MB
5. Key Excel functions Average and Averageif.vtt	VTT	2.24 KB
5.1 Average, Averageif - Solved.xlsx.xlsx	XLSX	9.4 KB
5.2 05 39 Average, AverageIF Exercise & Text.xlsx.xlsx	XLSX	14.6 KB
5.3 Average, Averageif – Unsolved.xlsx.xlsx	XLSX	9.03 KB
5.4 05 39 Average, AverageIF Solution.xlsx.xlsx	XLSX	15.02 KB
6. Key Excel functions Average and Averageif.html	HTML	163 B
7. Elaborate text efficiently Left, Right, Mid, Upper, Lower,Proper, Concatenate.mp4	MP4	6.31 MB
7. Elaborate text efficiently Left, Right, Mid, Upper, Lower,Proper, Concatenate.vtt	VTT	5.3 KB
7.1 Key Functions In Excel.pdf	PDF	9.84 MB
7.2 Text Functions - Solved.xlsx.xlsx	XLSX	11.1 KB
7.3 Text Functions - Unsolved.xlsx.xlsx	XLSX	10.6 KB
7.4 05 40 2 Left, Right etc Exercise & Text.xlsx.xlsx	XLSX	11.71 KB
7.5 05 40 2 Left, Right etc Solved.xlsx.xlsx	XLSX	12.24 KB
8. Elaborate text efficiently Left, Right, Mid, Upper, Lower,Proper, Concatenate.html	HTML	163 B
9. Find the minimum or maximum value in a range of cells in Excel.mp4	MP4	1.9 MB
9. Find the minimum or maximum value in a range of cells in Excel.vtt	VTT	1.09 KB
9.1 Max, min – Solved.xlsx.xlsx	XLSX	9.23 KB
9.2 05 41 MIN MAX Exercise & Text.xlsx.xlsx	XLSX	14.39 KB
9.3 05 41 MIN MAX Solved.xlsx.xlsx	XLSX	14.8 KB
9.4 Max, min - Unsolved.xlsx.xlsx	XLSX	8.95 KB

6. Update! 15 December - Exercise

1. Exercise - Excel's Sumifs function - unsolved.html	HTML	167 B
2. Exercise - Excel's Sumifs function - solved & explained.mp4	MP4	12.68 MB
2. Exercise - Excel's Sumifs function - solved & explained.vtt	VTT	10.03 KB
2.1 Exercise Sumifs With Solutions.xlsx	XLSX	1.29 MB

7. Financial functions in Excel

1. Future and present values in Excel.mp4	MP4	14.96 MB
1. Future and present values in Excel.vtt	VTT	6.13 KB
2. Calculating the rate of return of an investment with the IRR function.mp4	MP4	7.58 MB
2. Calculating the rate of return of an investment with the IRR function.vtt	VTT	3.25 KB
2.1 Solution-IRR.xlsx.xlsx	XLSX	12.31 KB
2.2 05 14 IRR.xlsx.xlsx	XLSX	11.2 KB
2.3 Exercise-IRR.xlsx.xlsx	XLSX	11.52 KB
3. Calculating a complete loan schedule in Excel.mp4	MP4	14.82 MB
3. Calculating a complete loan schedule in Excel.vtt	VTT	5.85 KB
3.1 Solution-Loan-Schedule.xlsx.xlsx	XLSX	22.68 KB
3.2 05 15 PMT.xlsx.xlsx	XLSX	20.17 KB
3.3 Exercise-Loan-Schedule.xlsx.xlsx	XLSX	15.81 KB
4. Date functions in Excel.mp4	MP4	11.36 MB
4. Date functions in Excel.vtt	VTT	5.27 KB
4.1 Exercise-Date-Functions.xlsx.xlsx	XLSX	11.41 KB
4.2 Solution-Date-Functions (2).xlsx.xlsx	XLSX	12.43 KB
4.3 Exercise-Date-Functions.xlsx.xlsx	XLSX	11.41 KB
4.4 05 16 Date Functions.xlsx.xlsx	XLSX	12.25 KB

8. Microsoft Excel's Pivot Tables in Depth

1. Introduction to Pivot Tables and the way they are applied.mp4	MP4	6 MB
1. Introduction to Pivot Tables and the way they are applied.vtt	VTT	1.99 KB
2. Creating Pivot Tables easily!.mp4	MP4	19.37 MB
2. Creating Pivot Tables easily!.vtt	VTT	4.01 KB
2.1 2. Creating a Pivot Table.xlsx.xlsx	XLSX	1.43 MB
3. Give your Excel Pivot Tables a makeover.mp4	MP4	11.27 MB
3. Give your Excel Pivot Tables a makeover.vtt	VTT	2.22 KB
3.1 3. Formatting a Pivot Table.xlsx.xlsx	XLSX	1.43 MB
4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4	MP4	23.01 MB
4. Modifying and pivoting fields to obtain the Pivot Table you need.vtt	VTT	4.39 KB
4.1 4. Working with Pivot Tables.xlsx.xlsx	XLSX	1.88 MB
5. Learn more about GetPivotData - A very important Excel function.mp4	MP4	18.06 MB
5. Learn more about GetPivotData - A very important Excel function.vtt	VTT	3.77 KB
5.1 5. GetPivotData.xlsx.xlsx	XLSX	1.88 MB
6. An introduction to slicers - The modern-day Pivot Table filters.mp4	MP4	22.16 MB
6. An introduction to slicers - The modern-day Pivot Table filters.vtt	VTT	4.42 KB
6.1 6. Slicers.xlsx.xlsx	XLSX	1.88 MB
6.2 Database - Pivot & Slicers.xlsm.xlsm	XLSM	851.23 KB

9. Case study - Building a complete P&L from scratch in Excel

1. Case study - Build a P&L from scratch - Welcome lecture.mp4	MP4	3.13 MB
1. Case study - Build a P&L from scratch - Welcome lecture.vtt	VTT	1.53 KB
10. Use Index & Match as a substitute for Vlookup.mp4	MP4	12.66 MB
10. Use Index & Match as a substitute for Vlookup.vtt	VTT	4.22 KB
10.1 9. Index & Match - Unsolved.xlsx.xlsx	XLSX	38.45 KB
10.2 9. Index & Match - Solved.xlsx.xlsx	XLSX	42.89 KB
11. Mapping the rows in the Database sheet.mp4	MP4	9.41 MB
11. Mapping the rows in the Database sheet.vtt	VTT	2.67 KB
11.1 10. Mapping - Solved.xlsx.xlsx	XLSX	47.5 KB
11.2 10. Mapping - Unsolved.xlsx.xlsx	XLSX	39.04 KB
12. Building the structure of the P&L sheet.mp4	MP4	3.91 MB
12. Building the structure of the P&L sheet.vtt	VTT	2.44 KB
12.1 11 Building A P&L.xlsx	XLSX	53.83 KB
12.2 11. Building a P&L - Solved.xlsx.xlsx	XLSX	53.83 KB
13. Formatting sets You apart from the competition in Excel - A Practical Example.mp4	MP4	5.71 MB
13. Formatting sets You apart from the competition in Excel - A Practical Example.vtt	VTT	3.3 KB
13.1 12. Formatting the P&L sheet - Solved.xlsx.xlsx	XLSX	53.56 KB
13.2 12. Formatting the P&L - Unsolved.xlsx.xlsx	XLSX	49.36 KB
14. Populate the P&L sheet with Sumif.mp4	MP4	6.43 MB
14. Populate the P&L sheet with Sumif.vtt	VTT	3.02 KB
14.1 13. Populating the P&L sheet - Solved.xlsm.xlsm	XLSM	59.02 KB
14.2 13. Populating the P&L sheet - Unsolved.xlsx.xlsx	XLSX	49.23 KB
15. Learn how to find mistakes with Countif.mp4	MP4	7.47 MB
15. Learn how to find mistakes with Countif.vtt	VTT	2.67 KB
15.1 14. Countif - Solved.xlsx.xlsx	XLSX	57.32 KB
15.2 14. Countif - Unsolved.xlsm.xlsm	XLSM	53.99 KB
16. Calculating year-on-year percentage variations the proper way.mp4	MP4	6.83 MB
16. Calculating year-on-year percentage variations the proper way.vtt	VTT	3.2 KB
16.1 15. Adding % variations - Unsolved.xlsx.xlsx	XLSX	51.16 KB
16.2 15. Adding % variations - Solved.xlsx.xlsx	XLSX	56.53 KB
17. Create professional and good-looking charts - Introduction.mp4	MP4	1.19 MB
17. Create professional and good-looking charts - Introduction.vtt	VTT	461 B
18. Build a Column Stacked chart with a secondary line axis in Excel.mp4	MP4	11.3 MB
18. Build a Column Stacked chart with a secondary line axis in Excel.vtt	VTT	6.76 KB
18.1 Column Stacked Chart - Solved.xlsm.xlsm	XLSM	11.52 MB
18.2 Case Study Building A P&L From Scratch Complete.xlsx	XLSX	12.16 MB
18.3 Column Stacked Chart - Unsolved.xlsm.xlsm	XLSM	11.52 MB
19. Learn how to build effective Doughnut charts in Excel.mp4	MP4	7.48 MB
19. Learn how to build effective Doughnut charts in Excel.vtt	VTT	4.74 KB
19.1 Doughnut Chart - Unsolved.xlsm.xlsm	XLSM	11.52 MB
19.2 Doughnut Chart - Solved.xlsm.xlsm	XLSM	11.52 MB
2. Introduction to the case study.mp4	MP4	2.42 MB
2. Introduction to the case study.vtt	VTT	1019 B
20. Learn how to build an Area chart in Excel.mp4	MP4	8.02 MB
20. Learn how to build an Area chart in Excel.vtt	VTT	4.64 KB
20.1 Area Chart - Solved.xlsm.xlsm	XLSM	11.52 MB
20.2 Area Chart - Unsolved.xlsm.xlsm	XLSM	11.51 MB
21. Learn how to create Bridge charts.mp4	MP4	18.77 MB
21. Learn how to create Bridge charts.vtt	VTT	12.38 KB
21.1 Bridge Chart - Solved.xlsm.xlsm	XLSM	11.51 MB
21.2 Case Study Building A P&L From Scratch Complete.xlsx	XLSX	12.17 MB
21.3 Bridge Chart – Unsolved.xlsm.xlsm	XLSM	11.52 MB
22. Case Study - Building a Complete P&L from scratch in Excel.html	HTML	162 B
23. Course Challenge - Apply your skills in practice!.mp4	MP4	7.92 MB
23. Course Challenge - Apply your skills in practice!.vtt	VTT	1.18 KB
23.1 1. SOULUTIONS - Course Challenge.xlsx.xlsx	XLSX	543.93 KB
23.2 1. Course Challenge.xlsx.xlsx	XLSX	505.49 KB
3. Understand your data source before you start working on it.mp4	MP4	6.78 MB
3. Understand your data source before you start working on it.vtt	VTT	2.96 KB
4. Order the source worksheets.mp4	MP4	5.68 MB
4. Order the source worksheets.vtt	VTT	2.37 KB
4.1 4. Order a worksheet - Unsolved.xlsx.xlsx	XLSX	28.64 KB
4.2 4. Order a worksheet - Solved.xlsm.xlsm	XLSM	36.58 KB
5. Create a code the best way to organize your data and work efficiently with it.mp4	MP4	5.99 MB
5. Create a code the best way to organize your data and work efficiently with it.vtt	VTT	2.19 KB
5.1 5. Creating a code - Unsolved.xlsm.xlsm	XLSM	32.76 KB
5.2 5. Creating a code - Solved.xlsx.xlsx	XLSX	33.84 KB
6. Learn how to create a database.mp4	MP4	5.45 MB
6. Learn how to create a database.vtt	VTT	2.22 KB
6.1 6. Creating a database - Solved.xlsx.xlsx	XLSX	35.4 KB
6.2 6. Creating a database - Unsolved.xlsx.xlsx	XLSX	30.66 KB
7. Use Vlookup to fill the Database sheet.mp4	MP4	14.65 MB
7. Use Vlookup to fill the Database sheet.vtt	VTT	5.53 KB
7.1 7. Vlookup - Solved.xlsx.xlsx	XLSX	41.26 KB
7.2 7 Vlookup.xlsx	XLSX	40.74 KB
7.3 7. Vlookup - Unsolved.xlsx.xlsx	XLSX	32.48 KB
8. 50% Completed!.mp4	MP4	4.3 MB
8. 50% Completed!.vtt	VTT	51 B
9. Use SUMIF to complete the Database sheet.mp4	MP4	13.29 MB
9. Use SUMIF to complete the Database sheet.vtt	VTT	4.46 KB
9.1 8. Sumif - Solved.xlsx.xlsx	XLSX	47.24 KB
9.2 8. Sumif - Unsolved.xlsx.xlsx	XLSX	37.41 KB

ReadMe.txt

TXT

428 B

Visit Coursedrive.net.url

URL

124 B

Visit Coursedrive.net.url

URL

124 B

Description

Show full description

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Udemy - Medical Writing Course for Beginner - Start Earning in 7 days Posted by freecoursewb in Other Posted in Other 7 3.9 GB 2 months ago freecoursewb	Size 3.9 GB	Files 16	Age 2 months ago	Seeds 7	Leechs 10	Source
Udemy - Beginner 3D Jelly Flowers - Rose, Camellia and Plum Blossom Posted by freecoursewb in Other Posted in Other 2 2.7 GB 2 months ago freecoursewb	Size 2.7 GB	Files 20	Age 2 months ago	Seeds 2	Leechs 13	Source
Udemy - Beginner Blues Improvisation for Guitarists Posted by freecoursewb in Other Posted in Other 24 1.2 GB 2 months ago freecoursewb	Size 1.2 GB	Files 45	Age 2 months ago	Seeds 24	Leechs 6	Source
Udemy - Build a Serverless API -AWS Lambda and API Gateway (Beginner) Posted by freecoursewb in Other Posted in Other 12 677.7 MB 3 months ago freecoursewb	Size 677.7 MB	Files 7	Age 3 months ago	Seeds 12	Leechs 2	Source
Udemy - SAP Intercompany Process in Fiori - From Beginner to Expert Posted by freecoursewb in Other Posted in Other 0 982 MB 3 months ago freecoursewb	Size 982 MB	Files 27	Age 3 months ago	Seeds 0	Leechs 0	Source

Udemy - Beginner to Pro in Excel Financial Modeling and Valuation [Course Drive]

Torrent Contents Size: 2.99 GB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

Tracker name
udp://tracker.leechers-paradise.org:6969/announce
udp://tracker.internetwarriors.net:1337/announce
udp://tracker.opentrackr.org:1337/announce
udp://tracker.coppersurfer.tk:6969/announce
udp://tracker.pirateparty.gr:6969/announce
udp://9.rarbg.to:2730/announce
udp://9.rarbg.to:2710/announce
udp://bt.xxx-tracker.com:2710/announce
udp://tracker.cyberia.is:6969/announce
udp://retracker.lanta-net.ru:2710/announce
udp://9.rarbg.to:2770/announce
udp://9.rarbg.me:2730/announce
udp://eddie4.nl:6969/announce
udp://tracker.mg64.net:6969/announce
udp://open.demonii.si:1337/announce
udp://tracker.zer0day.to:1337/announce
udp://tracker.tiny-vps.com:6969/announce
udp://ipv6.tracker.harry.lu:80/announce
udp://9.rarbg.me:2740/announce
udp://9.rarbg.me:2770/announce
udp://denis.stalker.upeer.me:6969/announce
udp://tracker.port443.xyz:6969/announce
udp://tracker.moeking.me:6969/announce
udp://exodus.desync.com:6969/announce
udp://9.rarbg.to:2740/announce
udp://9.rarbg.to:2720/announce
udp://tracker.justseed.it:1337/announce
udp://tracker.torrent.eu.org:451/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://tracker.open-internet.nl:6969/announce
udp://torrentclub.tech:6969/announce
udp://open.stealth.si:80/announce
http://tracker.tfile.co:80/announce