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

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

Name	[Tutorialsplanet.NET] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	5.1 GB
Total Files	858
Last Seen	2025-07-18 23:36
Hash	23ED6054427F9DDF7B09750B07087C356AB9CA43

/1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/
1. What does the course cover.mp4	9.4 MB
1. What does the course cover.vtt	3.2 KB
1.1 Course Notes - Beginner to Pro in Excel.pdf.pdf	20.0 MB
2. Bonus! Welcome gift.html	0.2 KB
3. Welcome gift number 2.html	0.2 KB
4. The best way to take this course.mp4	21.1 MB
4. The best way to take this course.vtt	2.5 KB
5. Download all course materials.html	0.8 KB
/10. Introduction to Excel charts/
1. How to insert a chart in Excel.mp4	23.4 MB
1. How to insert a chart in Excel.vtt	2.6 KB
1.1 95. Inserting-Charts-Lecture.xlsm.xlsm	12.0 MB
2. Editing Excel charts.mp4	27.3 MB
2. Editing Excel charts.vtt	3.0 KB
2.1 96. Formatting-a-Chart-Lecture.xlsm.xlsm	12.0 MB
3. Excel chart formatting.mp4	34.3 MB
3. Excel chart formatting.vtt	3.5 KB
3.1 97. Modifying-a-Chart-Lecture.xlsm.xlsm	12.0 MB
4. How to create a bridge chart in Excel.mp4	14.3 MB
4. How to create a bridge chart in Excel.vtt	2.0 KB
4.1 98. Bridge-Charts-Lecture.xlsx.xlsx	13.4 KB
5. New ways to visualize your data - Treemap charts.mp4	12.0 MB
5. New ways to visualize your data - Treemap charts.vtt	1.7 KB
5.1 99. Treemap-Charts-Lecture.xlsx.xlsx	12.9 KB
6. Sparklines.mp4	28.9 MB
6. Sparklines.vtt	4.3 KB
6.1 100. Sparklines-Lecture.xlsx.xlsx	9.8 KB
/11/
1. Create professional and good-looking charts - Introduction.mp4	6.5 MB
1. Create professional and good-looking charts - Introduction.vtt	0.7 KB
2. Build a column stacked chart with a secondary line axis in Excel.mp4	48.6 MB
2. Build a column stacked chart with a secondary line axis in Excel.vtt	5.8 KB
2.1 102. Column stacked chart-Lecture-before.xlsm.xlsm	12.1 MB
2.2 102. Column stacked chart-Lecture-after.xlsm.xlsm	12.1 MB
3. Learn how to build effective doughnut charts in Excel.mp4	39.8 MB
3. Learn how to build effective doughnut charts in Excel.vtt	5.6 KB
3.1 103. Doughnut chart-Lecture-after.xlsm.xlsm	12.1 MB
3.2 103. Doughnut chart-Lecture-before.xlsm.xlsm	12.1 MB
4. Learn how to build an area chart in Excel.mp4	30.0 MB
4. Learn how to build an area chart in Excel.vtt	3.6 KB
4.1 104. Area chart-Lecture-after.xlsm.xlsm	12.1 MB
4.2 104. Area chart-Lecture-before.xlsm.xlsm	12.1 MB
5. Learn how to create bridge charts.mp4	54.6 MB
5. Learn how to create bridge charts.vtt	7.6 KB
5.1 105. Bridge chart-Lecture-after.xlsm.xlsm	12.1 MB
5.2 105. Bridge chart-Lecture-before.xlsm.xlsm	12.1 MB
6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4	142.7 MB
6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.vtt	12.0 KB
7. Case Study - Building a Complete P&L from scratch in Excel.html	0.2 KB
8. Course Challenge - Apply your skills in practice!.mp4	8.3 MB
8. Course Challenge - Apply your skills in practice!.vtt	1.2 KB
8.1 107. Course-Challenge - Solved.xlsx.xlsx	557.0 KB
8.2 107. Course-Challenge - Unsolved.xlsx.xlsx	517.6 KB
/12. Case Study - Building an FMCG Model from Scratch/
1. Introduction to the Case Study.mp4	12.6 MB
1. Introduction to the Case Study.vtt	2.5 KB
1.1 108. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx.xlsx	13.9 MB
10. Combining Slicers and GETPIVOTDATA The key to our success.mp4	18.7 MB
10. Combining Slicers and GETPIVOTDATA The key to our success.vtt	3.5 KB
10.1 117. Exercise-Build-an-FMCG-Model-Inserting-Slicers-Lecture.xlsx.xlsx	21.8 MB
11. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4	18.0 MB
11. Getting fancy with Excel slicers - Good-looking Excel slicers.vtt	3.5 KB
11.1 118. Exercise-Build-an-FMCG-Model-Complete-Lecture.xlsx.xlsx	23.9 MB
12. This is how the report can be used in practice by high-level executives.mp4	20.8 MB
12. This is how the report can be used in practice by high-level executives.vtt	4.5 KB
12.1 119. Exercise-Build-an-FMCG-Model-Complete.xlsx.xlsx	23.9 MB
13. Dynamic reporting with GETPIVOTDATA and slicers.html	0.2 KB
2. Preliminary mapping of the data extraction.mp4	23.7 MB
2. Preliminary mapping of the data extraction.vtt	2.5 KB
2.1 109. Exercise-Build-an-FMCG-Model-Mapping-Lecture.xlsx.xlsx	15.6 MB
3. Working with an SAP data extraction.mp4	23.0 MB
3. Working with an SAP data extraction.vtt	3.9 KB
4. Creating an output structure of the FMCG model.mp4	12.2 MB
4. Creating an output structure of the FMCG model.vtt	2.9 KB
4.1 111. Exercise-Build-an-FMCG-Model-Structure-Lecture.xlsx.xlsx	15.6 MB
5. Improving the layout and appearance of the FMCG report.mp4	14.2 MB
5. Improving the layout and appearance of the FMCG report.vtt	4.7 KB
5.1 112. Exercise-Build-an-FMCG-Model-Formatting-Lecture.xlsx.xlsx	15.6 MB
6. Inserting formulas and automating calculations.mp4	9.3 MB
6. Inserting formulas and automating calculations.vtt	4.7 KB
6.1 113. Exercise-Build-an-FMCG-Model-Adding-Calculations-Lecture.xlsx.xlsx	15.6 MB
7. Creating a Master Pivot Table The main data source for the FMCG report.mp4	14.5 MB
7. Creating a Master Pivot Table The main data source for the FMCG report.vtt	2.2 KB
7.1 114. Exercise-Build-an-FMCG-Model-Creating-a-Pivot-Table-Lecture.xlsx.xlsx	21.8 MB
8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4	32.5 MB
8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.vtt	6.8 KB
8.1 115. Exercise-Build-an-FMCG-Model-GETPIVOTDATA-Lecture.xlsx.xlsx	21.8 MB
9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4	14.4 MB
9. A potential error with GETPIVOTDATA you might encounter and its fix.vtt	1.5 KB
/13. Financial Modeling Fundamentals/
1. Financial Modeling basics - Welcome lecture.mp4	2.2 MB
1. Financial Modeling basics - Welcome lecture.vtt	1.1 KB
10. Forecasting financials - Quiz.html	0.2 KB
11. Building a complete model - Important considerations.mp4	6.7 MB
11. Building a complete model - Important considerations.vtt	2.8 KB
12. Modeling the Income statement.mp4	13.0 MB
12. Modeling the Income statement.vtt	7.2 KB
13. Modeling the Balance sheet - Part 1.mp4	5.5 MB
13. Modeling the Balance sheet - Part 1.vtt	3.3 KB
14. Modeling the Balance sheet - Part 2.mp4	9.8 MB
14. Modeling the Balance sheet - Part 2.vtt	5.9 KB
15. Building a financial model - Quiz.html	0.2 KB
2. What is a financial model.mp4	4.8 MB
2. What is a financial model.vtt	2.4 KB
3. Why use financial models.mp4	8.1 MB
3. Why use financial models.vtt	3.2 KB
4. Financial modeling - worst practices - things you should avoid.mp4	20.9 MB
4. Financial modeling - worst practices - things you should avoid.vtt	7.0 KB
5. Financial modeling - best practices.mp4	18.1 MB
5. Financial modeling - best practices.vtt	5.8 KB
6. Financial modeling - The types of models that are built in practice.mp4	13.1 MB
6. Financial modeling - The types of models that are built in practice.vtt	5.6 KB
7. Financial modeling - Quiz.html	0.2 KB
8. Financial modeling The right level of detail in a model.mp4	6.0 MB
8. Financial modeling The right level of detail in a model.vtt	3.0 KB
9. Financial modeling Forecasting guidelines.mp4	6.7 MB
9. Financial modeling Forecasting guidelines.vtt	3.4 KB
/14. Introduction to Company Valuation/
1. The core theory behind Company Valuation.html	0.2 KB
/15. Introduction to Mergers & Acquisitions/
1. Introduction to Mergers & Acquisitions.html	0.2 KB
/16/
1. Valuation Case study - Welcome lecture.mp4	1.9 MB
1. Valuation Case study - Welcome lecture.vtt	0.9 KB
10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4	31.5 MB
10. Modeling other items Interest expenses, Extraordinary items and Taxes.vtt	3.0 KB
10.1 9. Interest expenses, taxes_before.xlsm.xlsm	51.8 KB
10.2 9. Interest expenses, taxes_after.xlsm.xlsm	52.1 KB
11. Forecasting Balance sheet items.mp4	4.9 MB
11. Forecasting Balance sheet items.vtt	0.9 KB
11.1 10. Introduction to Balance sheet items.xlsm.xlsm	52.2 KB
12. An introduction to the Days methodology.mp4	10.6 MB
12. An introduction to the Days methodology.vtt	1.8 KB
12.1 Working Capital Days.pptx.pptx	97.0 KB
13. Calculation of DSO, DPO and DOI for the historical period.mp4	12.7 MB
13. Calculation of DSO, DPO and DOI for the historical period.vtt	1.4 KB
13.1 12. Days calculation_before.xlsm.xlsm	52.4 KB
13.2 12. Days calculation_after.xlsm.xlsm	52.7 KB
14. Forecasting DSO, DPO and DOI.mp4	21.9 MB
14. Forecasting DSO, DPO and DOI.vtt	2.8 KB
14.1 13. Forecasting DSO, DPO, DIO_before.xlsm.xlsm	52.7 KB
14.2 13. Forecasting DSO, DPO, DIO_after.xlsm.xlsm	53.2 KB
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4	23.7 MB
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.vtt	2.7 KB
15.1 14. Forecasting PP&E, Other assets, and Other liabilities_after.xlsm.xlsm	54.2 KB
15.2 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm.xlsm	53.2 KB
16. Creating an output P&L sheet.mp4	19.7 MB
16. Creating an output P&L sheet.vtt	2.4 KB
16.1 15. P&L structure_after.xlsm.xlsm	55.0 KB
16.2 15. P&L structure_before.xlsm.xlsm	54.9 KB
17. Populating the output P&L sheet.mp4	26.8 MB
17. Populating the output P&L sheet.vtt	2.5 KB
17.1 16. Populating the P&L sheet_after.xlsm.xlsm	56.6 KB
17.2 16. Populating the P&L sheet_before.xlsm.xlsm	55.0 KB
18. Populating the output BS sheet.mp4	17.8 MB
18. Populating the output BS sheet.vtt	1.8 KB
18.1 17. Populating BS sheet_before.xlsm.xlsm	56.6 KB
18.2 17. Populating BS sheet_after.xlsm.xlsm	58.6 KB
19. Completing the output BS sheet for the historical period.mp4	39.9 MB
19. Completing the output BS sheet for the historical period.vtt	4.2 KB
19.1 18. Completing the Balance Sheet_after.xlsm.xlsm	59.5 KB
19.2 18. Completing the Balance Sheet_before.xlsm.xlsm	58.6 KB
2. Introduction to the DCF exercise.mp4	8.3 MB
2. Introduction to the DCF exercise.vtt	1.3 KB
20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp4	23.9 MB
20. Creating a structure for the calculation of Unlevered Free Cash Flows.vtt	3.3 KB
20.1 19. Cash flow structure_after.xlsm.xlsm	60.0 KB
20.2 19. Cash flow structure_before.xlsm.xlsm	59.9 KB
21. Bridging Unlevered free cash flow to Net cash flow.mp4	15.3 MB
21. Bridging Unlevered free cash flow to Net cash flow.vtt	2.2 KB
21.1 20. Bridge UFCF to Net cash flow_before.xlsm.xlsm	60.0 KB
21.2 20. Bridge UFCF to Net cash flow_after.xlsm.xlsm	60.1 KB
22. Calculating Unlevered free cash flow.mp4	62.6 MB
22. Calculating Unlevered free cash flow.vtt	6.8 KB
22.1 21. Calculating UFCF_after.xlsm.xlsm	60.6 KB
22.2 21. Calculating UFCF_before.xlsm.xlsm	60.1 KB
23. Calculating Net cash flow.mp4	39.7 MB
23. Calculating Net cash flow.vtt	4.3 KB
23.1 22. Calculating Net Cash Flow_before.xlsm.xlsm	60.6 KB
23.2 Cash Flow Classification By Activities.xlsx	57.3 KB
23.3 22. Calculating Net Cash Flow_after.xlsm.xlsm	60.8 KB
24. Obtaining the rest of the cash flows through Find and Replace.mp4	49.0 MB
24. Obtaining the rest of the cash flows through Find and Replace.vtt	4.3 KB
24.1 23. Find and replace_after.xlsm.xlsm	64.0 KB
24.2 23. Find and replace_before.xlsm.xlsm	61.0 KB
25. Introducing Weighted average cost of capital and Perpetuity growth.mp4	13.9 MB
25. Introducing Weighted average cost of capital and Perpetuity growth.vtt	2.3 KB
25.1 24. Introducing WACC and g_before.xlsm.xlsm	64.0 KB
25.2 24. Introducing WACC and g_after.xlsm.xlsm	64.1 KB
26. Discounting Unlevered free cash flows to obtain their Present value.mp4	21.2 MB
26. Discounting Unlevered free cash flows to obtain their Present value.vtt	3.1 KB
26.1 25. Calculating PV of Cash Flows_after.xlsm.xlsm	64.2 KB
26.2 25. Calculating PV of Cash Flows_before.xlsm.xlsm	64.1 KB
27. Calculating Continuing value and Enterprise value of the business.mp4	18.6 MB
27. Calculating Continuing value and Enterprise value of the business.vtt	2.4 KB
27.1 26. Calculating CV and EV_after.xlsm.xlsm	64.6 KB
27.2 26. Calculating CV and EV_before.xlsm.xlsm	64.2 KB
28. Calculating Equity value.mp4	12.8 MB
28. Calculating Equity value.vtt	1.7 KB
28.1 27. Calculating equity value_before.xlsm.xlsm	64.6 KB
28.2 27. Calculating equity value_after.xlsm.xlsm	64.8 KB
29. Sensitivity analysis for WACC and perpetuity growth.mp4	42.4 MB
29. Sensitivity analysis for WACC and perpetuity growth.vtt	4.7 KB
29.1 28. Sensitivity analysis_before.xlsm.xlsm	64.8 KB
29.2 28. Sensitivity analysis_after.xlsm.xlsm	66.4 KB
29.3 Sensitivity Analysis.xlsx	62.3 KB
3. The stages of a complete DCF Valuation.mp4	51.6 MB
3. The stages of a complete DCF Valuation.vtt	6.8 KB
3.1 Valuation exercise.pdf.pdf	421.6 KB
30. A possible application of Goal seek.mp4	16.4 MB
30. A possible application of Goal seek.vtt	2.0 KB
30.1 29. Goal seek_before.xlsm.xlsm	66.4 KB
30.2 29. Goal seek_ater.xlsm.xlsm	66.4 KB
31. Using charts to summarize the results of the DCF model.mp4	34.5 MB
31.1 30. Charts.xlsm.xlsm	103.6 KB
32. You made it!.mp4	11.8 MB
32. You made it!.vtt	3.0 KB
4. Description of the structure of the DCF model.mp4	19.4 MB
4. Description of the structure of the DCF model.vtt	3.1 KB
4.1 3. Structure of the DCF model.xlsm.xlsm	49.0 KB
4.2 DCF Model structure.pdf.pdf	246.6 KB
5. A glimpse at the company we are valuing - Cheeseco.mp4	16.4 MB
5. A glimpse at the company we are valuing - Cheeseco.vtt	1.4 KB
5.1 Cheeseco.pptx.pptx	82.0 KB
6. Modeling the top line.mp4	27.6 MB
6. Modeling the top line.vtt	4.0 KB
6.1 5. Modeling revenues_after.xlsm.xlsm	49.3 KB
6.2 5. Modeling revenues_before.xlsm.xlsm	49.0 KB
7. Introducing scenarios to the model with Choose.mp4	18.7 MB
7. Introducing scenarios to the model with Choose.vtt	2.6 KB
7.1 6. Choose_after.xlsm.xlsm	49.5 KB
7.2 6. Choose_before.xlsm.xlsm	49.3 KB
8. Modeling other items Other revenues and Cogs.mp4	46.7 MB
8. Modeling other items Other revenues and Cogs.vtt	4.6 KB
8.1 7. Other revenues and Cogs_after.xlsm.xlsm	51.3 KB
8.2 7. Other revenues and Cogs_before.xlsm.xlsm	49.5 KB
9. Modeling other items Operating expenses and D&A.mp4	27.6 MB
9. Modeling other items Operating expenses and D&A.vtt	2.6 KB
9.1 8. Opex and D&A_before.xlsm.xlsm	51.3 KB
9.2 8. Opex and D&A_after.xlsm.xlsm	51.8 KB
/17. Tesla valuation - Complete practical exercise/
1. Organizing external inputs in a 'Drivers' sheet.mp4	32.5 MB
1. Organizing external inputs in a 'Drivers' sheet.vtt	4.4 KB
1.1 Tesla 2017.pdf.pdf	2.6 MB
1.2 Tesla 2016.pdf.pdf	2.3 MB
1.3 0a. Drivers_before.xlsx.xlsx	1.3 MB
1.4 Tesla 2018 Q2.pdf.pdf	650.3 KB
1.5 Tesla Company Valuation - Detailed walkthrough.pdf.pdf	5.3 MB
1.6 Tesla 2015.pdf.pdf	1.4 MB
1.7 0a. Drivers_after.xlsx.xlsx	1.3 MB
10. Forecasting 'energy' and 'services' revenue.mp4	26.5 MB
10. Forecasting 'energy' and 'services' revenue.vtt	3.1 KB
10.1 6. Energy and Other revenue - Before.xlsx.xlsx	1.4 MB
10.2 6. Energy and Other revenue - After.xlsx.xlsx	1.4 MB
11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4	28.1 MB
11. Calculating 'energy' and 'services' gross profit and cost of sales.vtt	2.4 KB
11.1 7. Energy and Other - Gross profit, cost of sales - Before.xlsx.xlsx	1.4 MB
11.2 7. Energy and Other - Gross profit, cost of sales - After.xlsx.xlsx	1.4 MB
12. Forecasting operating expenses.mp4	36.6 MB
12. Forecasting operating expenses.vtt	5.3 KB
12.1 8. Opex - Before.xlsx.xlsx	1.4 MB
12.2 8. Opex - After.xlsx.xlsx	1.4 MB
13. Building a fixed asset roll forward estimating Capex.mp4	59.3 MB
13. Building a fixed asset roll forward estimating Capex.vtt	6.2 KB
13.1 9. PP&E forecasting and comparables_before.xlsx.xlsx	1.4 MB
13.2 9. PP&E forecasting and comparables_after.xlsx.xlsx	1.4 MB
14. Building a fixed asset roll forward D&A schedule.mp4	56.8 MB
14. Building a fixed asset roll forward D&A schedule.vtt	4.2 KB
14.1 10. PP&E schedule_after.xlsx.xlsx	1.4 MB
14.2 10. PP&E schedule_before.xlsx.xlsx	1.4 MB
15. Peer comparison D&A as a percentage of revenues.mp4	14.3 MB
15. Peer comparison D&A as a percentage of revenues.vtt	1.7 KB
15.1 10a. PP&E comparison.xlsx.xlsx	1.4 MB
16. Calculating DSO, DIO, DPO.mp4	18.4 MB
16. Calculating DSO, DIO, DPO.vtt	2.1 KB
16.1 11. Working capital forecasting_before.xlsx.xlsx	1.4 MB
16.2 11. Working capital forecasting_after.xlsx.xlsx	1.6 MB
17. Producing a clean P&L output sheet.mp4	8.9 MB
17. Producing a clean P&L output sheet.vtt	1.6 KB
17.1 12. P&L.xlsx.xlsx	1.5 MB
18. Fill in the P&L output sheet.mp4	19.2 MB
18. Fill in the P&L output sheet.vtt	1.8 KB
18.1 12a. P&L fill in_after.xlsx.xlsx	1.5 MB
18.2 12a. P&L fill in_before.xlsx.xlsx	1.5 MB
19. Calculating investments in working capital.mp4	20.0 MB
19. Calculating investments in working capital.vtt	2.1 KB
19.1 13. Calculating working capital_after.xlsx.xlsx	1.5 MB
19.2 13. Calculating working capital_before.xlsx.xlsx	1.5 MB
2. The input data we will work with.mp4	16.6 MB
2. The input data we will work with.vtt	1.6 KB
2.1 0aa. Inputs_before.xlsx.xlsx	1.3 MB
2.2 0aa. Inputs_after.xlsx.xlsx	1.3 MB
20. Forecasting Unlevered free cash flow.mp4	58.6 MB
20. Forecasting Unlevered free cash flow.vtt	5.9 KB
20.1 14. Cash flow - UFCF_after.xlsx.xlsx	1.5 MB
20.2 14. Cash flow - UFCF_before.xlsx.xlsx	1.5 MB
21. Forecasting other assets.mp4	47.4 MB
21. Forecasting other assets.vtt	4.4 KB
21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx	1.5 MB
21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx	1.5 MB
22. Forecasting other liabilities.mp4	23.0 MB
22. Forecasting other liabilities.vtt	2.4 KB
22.1 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx	1.5 MB
22.2 16. Balance Sheet forecasting liabilities_before.xlsx.xlsx	1.5 MB
23. Completing Unlevered free cash flow.mp4	42.9 MB
23. Completing Unlevered free cash flow.vtt	3.4 KB
23.1 16a. Complete UFCF_after.xlsx.xlsx	1.5 MB
23.2 16a. Complete UFCF_before.xlsx.xlsx	1.5 MB
24. Modeling Tesla's financing needs in the forecast period.mp4	44.4 MB
24. Modeling Tesla's financing needs in the forecast period.vtt	5.2 KB
24.1 17. Financing_before.xlsx.xlsx	1.5 MB
24.2 17. Financing_after.xlsx.xlsx	1.5 MB
25. Calculating Net income.mp4	15.5 MB
25. Calculating Net income.vtt	1.3 KB
25.1 18. P&L complete_before.xlsx.xlsx	1.5 MB
25.2 18. P&L complete_after.xlsx.xlsx	1.5 MB
26. Bridging Unlevered free cash flow to Net cash flow.mp4	53.2 MB
26. Bridging Unlevered free cash flow to Net cash flow.vtt	4.3 KB
26.1 19. Cash flow_complete_after.xlsx.xlsx	1.5 MB
26.2 19. Cash flow_complete_before.xlsx.xlsx	1.5 MB
27. Balancing the Balance sheet.mp4	13.9 MB
27. Balancing the Balance sheet.vtt	1.1 KB
27.1 20. Complete the BS_before.xlsx.xlsx	1.5 MB
27.2 20. Complete the BS_after.xlsx.xlsx	1.5 MB
28. Estimating Weighted average cost of capital (WACC).mp4	46.4 MB
28. Estimating Weighted average cost of capital (WACC).vtt	6.5 KB
28.1 21. WACC_before.xlsx.xlsx	1.5 MB
28.2 21. WACC_after.xlsx.xlsx	1.5 MB
29. Performing discounted cash flow valuation (DCF).mp4	36.6 MB
29. Performing discounted cash flow valuation (DCF).vtt	3.9 KB
29.1 22. DCF_after.xlsx.xlsx	1.5 MB
29.2 22. DCF_before.xlsx.xlsx	1.6 MB
3. Forecasting Tesla's expected deliveries.mp4	120.5 MB
3. Forecasting Tesla's expected deliveries.vtt	14.7 KB
3.1 1. Deliveries_before.xlsx.xlsx	1.4 MB
3.2 1. Deliveries_after.xlsx.xlsx	1.4 MB
30. Calculating enterprise value, equity value, and price per share.mp4	23.6 MB
30. Calculating enterprise value, equity value, and price per share.vtt	2.1 KB
30.1 23. EV, Equity value, Price per share_before.xlsx.xlsx	1.5 MB
30.2 23. EV, Equity value, Price per share_after.xlsx.xlsx	1.5 MB
31. Final comments.mp4	47.1 MB
31. Final comments.vtt	4.3 KB
4. Comparing delivery figures with the ones of industry peers.mp4	22.0 MB
4. Comparing delivery figures with the ones of industry peers.vtt	3.1 KB
4.1 1a. Deliveries development.xlsx.xlsx	1.4 MB
5. Estimating an average selling price of Tesla vehicles.mp4	44.0 MB
5. Estimating an average selling price of Tesla vehicles.vtt	4.9 KB
5.1 2. Average price_before.xlsx.xlsx	1.4 MB
5.2 2. Average price_after.xlsx.xlsx	1.4 MB
6. Calculating automotive revenue.mp4	48.8 MB
6. Calculating automotive revenue.vtt	4.9 KB
6.1 3. Revenue calculation and scenarios - before.xlsx.xlsx	1.4 MB
6.2 3. Revenue calculation and scenarios - after.xlsx.xlsx	1.4 MB
7. Peer comparison Gross profit %.mp4	18.0 MB
7. Peer comparison Gross profit %.vtt	2.7 KB
7.1 4. Gross profit automotive.xlsx.xlsx	1.4 MB
8. Calculating automotive gross profit.mp4	29.1 MB
8. Calculating automotive gross profit.vtt	2.9 KB
8.1 4a. Gross profit automotive - before.xlsx.xlsx	1.6 MB
8.2 4a. Gross profit automotive - after.xlsx.xlsx	1.4 MB
9. Calculating automotive cost of sales.mp4	18.3 MB
9. Calculating automotive cost of sales.vtt	2.2 KB
9.1 5. Cost of sales and chart.xlsx.xlsx	1.4 MB
/18. Capital budgeting - The theory/
1. Introduction to Capital budgeting.mp4	5.7 MB
1. Introduction to Capital budgeting.vtt	1.8 KB
2. Why we need Capital budgeting.mp4	7.2 MB
2. Why we need Capital budgeting.vtt	2.7 KB
3. The time value of money.mp4	7.0 MB
3. The time value of money.vtt	2.9 KB
4. Calculating future and present Value.mp4	13.7 MB
4. Calculating future and present Value.vtt	6.4 KB
5. Calculating cost of equity.mp4	20.1 MB
5. Calculating cost of equity.vtt	7.6 KB
6. Coming up with project-specific beta.mp4	9.4 MB
6. Coming up with project-specific beta.vtt	3.6 KB
7. Weighted average cost of capital (WACC).mp4	5.8 MB
7. Weighted average cost of capital (WACC).vtt	2.4 KB
8. The type of cash flows we will have in a project.mp4	9.8 MB
8. The type of cash flows we will have in a project.vtt	4.0 KB
9. Estimating the project's cash flows.mp4	19.7 MB
9. Estimating the project's cash flows.vtt	6.8 KB
/19. Capital Budgeting - A Complete Case Study/
1. Introduction to the Capital budgeting exercise.mp4	9.1 MB
1. Introduction to the Capital budgeting exercise.vtt	3.3 KB
10. Finding cost of equity.mp4	14.6 MB
10. Finding cost of equity.vtt	7.3 KB
10.1 8. WACC_unsolved.xlsx.xlsx	36.8 KB
10.2 8. WACC.xlsx.xlsx	38.9 KB
11. Discounting the project's cash flows and residual value.mp4	27.2 MB
11. Discounting the project's cash flows and residual value.vtt	3.6 KB
11.1 9. Discounted cash flow_unsolved.xlsx.xlsx	39.6 KB
11.2 9. Discounted cash flow.xlsx.xlsx	40.7 KB
12. Performing sensitivity analysis and completing the exercise.mp4	45.1 MB
12. Performing sensitivity analysis and completing the exercise.vtt	5.4 KB
12.1 10. Sensitivity analysis.xlsx.xlsx	41.6 KB
12.2 10. Sensitivity analysis_unsolved.xlsx.xlsx	40.6 KB
13. Build a complete capital budgeting model from scratch.html	0.2 KB
14. Congratulations!!.mp4	2.4 MB
14. Congratulations!!.vtt	1.5 KB
2. Organizing an Inputs sheet.mp4	11.6 MB
2. Organizing an Inputs sheet.vtt	6.4 KB
2.1 1. Drivers.xlsx.xlsx	11.8 KB
3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4	9.7 MB
3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.vtt	4.2 KB
3.1 2. Savings Forecast.xlsx.xlsx	17.0 KB
3.2 2. Savings Forecast_unsolved.xlsx.xlsx	15.1 KB
4. Fixed asset rollforward.mp4	12.7 MB
4. Fixed asset rollforward.vtt	5.4 KB
4.1 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx	19.0 KB
4.2 3. Fixed Asset Rollforward.xlsx.xlsx	20.1 KB
5. The impact of working capital.mp4	5.6 MB
5. The impact of working capital.vtt	2.9 KB
5.1 4. Working Capital.xlsx.xlsx	22.5 KB
5.2 4. Working Capital_unsolved.xlsx.xlsx	21.7 KB
6. Modeling debt financing.mp4	6.5 MB
6. Modeling debt financing.vtt	3.4 KB
6.1 5. Financing_unsolved.xlsx.xlsx	30.7 KB
6.2 5. Financing.xlsx.xlsx	31.7 KB
7. Adding a P&L sheet.mp4	5.1 MB
7. Adding a P&L sheet.vtt	2.2 KB
7.1 6. P&L.xlsx.xlsx	31.8 KB
7.2 6. P&L_unsolved.xlsx.xlsx	30.4 KB
8. Calculating project cash flows.mp4	10.6 MB
8. Calculating project cash flows.vtt	3.8 KB
8.1 7. Cash flow_unsolved.xlsx.xlsx	30.4 KB
8.2 7. Cash flow.xlsx.xlsx	32.1 KB
9. Estimating the weighted average cost of capital (WACC).mp4	5.9 MB
9. Estimating the weighted average cost of capital (WACC).vtt	3.3 KB
9.1 8. WACC.xlsx.xlsx	38.9 KB
9.2 8. WACC_unsolved.xlsx.xlsx	36.8 KB
/2. Introduction to Excel/
1. Introduction to Excel - welcome lecture.mp4	2.1 MB
1. Introduction to Excel - welcome lecture.vtt	0.9 KB
10. Introduction to Excel formulas.html	0.2 KB
11. Introduction to Excel functions.mp4	12.6 MB
11. Introduction to Excel functions.vtt	4.5 KB
11.1 13. Functions- Exercise - Solved.xlsx.xlsx	83.0 KB
11.2 13. Functions - Lecture -Solved.xlsx.xlsx	9.6 KB
11.3 Introduction-to-Excels-basic-features.pdf.pdf	2.4 MB
11.4 13. Functions- Lecture - Unsolved.xlsx.xlsx	9.5 KB
11.5 13. Functions-Exercise - Unsolved.xlsx.xlsx	13.6 KB
12. Cut, copy, & paste.mp4	7.9 MB
12. Cut, copy, & paste.vtt	2.4 KB
12.1 Introduction-to-Excels-basic-features.pdf.pdf	2.4 MB
12.2 14. Copy-Cut-Paste-Exercise - Unsolved.xlsx.xlsx	11.6 KB
12.3 14. Copy-Cut-Paste-Exercise - Solved.xlsx.xlsx	12.9 KB
13. Cut, copy, & paste.html	0.2 KB
14. Paste special.mp4	7.0 MB
14. Paste special.vtt	1.5 KB
14.1 15. Paste-Special-Exercise - Unsolved.xlsx.xlsx	13.8 KB
14.2 15. Paste-Special-Exercise - Solved.xlsx.xlsx	13.8 KB
14.3 Introduction-to-Excels-basic-features.pdf.pdf	2.4 MB
15. Basic operations in Excel - 38 pages.html	0.2 KB
2. Overview of Excel.mp4	14.6 MB
2. Overview of Excel.vtt	4.0 KB
2.1 7. Introduction to Excel.pdf.pdf	2.4 MB
2.2 7. Overview-of-Excel-Exercise-Solved.xlsx.xlsx	11.1 KB
2.3 7. Overview-of-Excel-Exercise-Unsolved.xlsx.xlsx	10.7 KB
3. Overview of Excel.html	0.2 KB
4. Basic manipulations with rows and columns.mp4	7.2 MB
4. Basic manipulations with rows and columns.vtt	2.0 KB
4.1 8. Basic manipulations - Lecture.xlsx.xlsx	8.3 KB
4.2 8. Basic-Manipulations - Exercise - Unsolved.xlsx.xlsx	11.3 KB
4.3 8. Basic-Manipulations - Exercise - Solved.xlsx.xlsx	33.2 KB
5. Rows and columns.html	0.2 KB
6. The Excel ribbon.mp4	9.2 MB
6. The Excel ribbon.vtt	3.1 KB
6.1 9. The-Ribbon-Exercise-Solved.xlsx.xlsx	412.9 KB
6.2 9. The-Ribbon-Exercise-Exercise - Unsolved.xlsx.xlsx	12.4 KB
7. Data entry in Excel.mp4	10.9 MB
7. Data entry in Excel.vtt	3.4 KB
7.1 10. Data-Entry - Lecture.xlsx.xlsx	8.3 KB
7.2 10. Data-Entry-Exercise - Unsolved.xlsx.xlsx	11.2 KB
7.3 10. Data-Entry- Exercise -Solved.xlsx.xlsx	33.5 KB
8. Introduction to formatting.mp4	25.9 MB
8. Introduction to formatting.vtt	6.3 KB
8.1 11. Formatting - Lecture - Solved.xlsx.xlsx	10.1 KB
8.2 11. Formatting-Exercise - Unsolved.xlsx.xlsx	11.9 KB
8.3 11. Formatting- Exercise - Solved.xlsx.xlsx	11.9 KB
8.4 11. Formatting- Lecture - Unsolved.xlsx.xlsx	9.1 KB
9. Introduction to Excel formulas.mp4	24.8 MB
9. Introduction to Excel formulas.vtt	4.2 KB
9.1 12. Formulas- Lecture - Solved.xlsx.xlsx	9.6 KB
9.2 12. Formulas- Lecture - Unsolved.xlsx.xlsx	9.5 KB
9.3 12. Formulas- Exercise - Solved.xlsx.xlsx	82.1 KB
9.4 12. Formulas - Exercise - Unsolved.xlsx.xlsx	12.0 KB
9.5 Introduction-to-Excels-basic-features.pdf.pdf	2.4 MB
/20. Bonus lecture/
1. Bonus lecture Next steps.html	2.2 KB
/3/
1. Excel best practices - Welcome lecture.mp4	2.2 MB
1. Excel best practices - Welcome lecture.vtt	1.0 KB
10. Learn how to organize your data with Text to Columns.html	0.2 KB
11. Learn how to use the Wrap Text button.mp4	2.3 MB
11. Learn how to use the Wrap Text button.vtt	0.9 KB
11.1 24. Wrap-Text-Exercise - Solved.xlsx.xlsx	10.4 KB
11.2 24. Wrap-text-Lecture - Solved.xlsx.xlsx	9.8 KB
11.3 24. Wrap-Text-Exercise - Unsolved.xlsx.xlsx	10.4 KB
11.4 24. Wrap-text-Lecture - Unsolved.xlsx.xlsx	9.8 KB
11.5 Useful-Tips-Tools.pdf.pdf	3.5 MB
12. Create easily printable documents in Excel by using Set Print Area.mp4	5.0 MB
12. Create easily printable documents in Excel by using Set Print Area.vtt	1.5 KB
12.1 25. Set-Print-Area-Lecture - Unsolved.xlsx.xlsx	11.7 KB
12.2 25. Set-Print-Area-Lecture - Solved.xlsx.xlsx	11.5 KB
12.3 Useful-Tips-Tools.pdf.pdf	3.5 MB
13. Find and select special types of cells with Select Special (F5).mp4	10.3 MB
13. Find and select special types of cells with Select Special (F5).vtt	1.9 KB
13.1 26. Select-Special-Lecture.xlsx.xlsx	10.8 KB
13.2 26. Select-Special-F5-Exercise - Solved.xlsx.xlsx	22.8 KB
13.3 26. Select-Special-F5-Exercise - Unsolved.xlsx.xlsx	22.1 KB
13.4 Useful-Tips-Tools.pdf.pdf	3.5 MB
14. Select Special.html	0.2 KB
15. Learn how to assign dynamic names within a financial model.mp4	7.7 MB
15. Learn how to assign dynamic names within a financial model.vtt	1.6 KB
15.1 27. Dynamic-Naming-Lecture - Unsolved.xlsx.xlsx	13.9 KB
15.2 Useful-Tips-Tools.pdf.pdf	3.5 MB
15.3 27. Assigning-Dynamic-Names-Exercise - Solved.xlsx.xlsx	12.0 KB
15.4 27. Dynamic-Naming-Lecture - Solved.xlsx.xlsx	14.2 KB
15.5 27. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx.xlsx	11.5 KB
16. Assigning dynamic names.html	0.2 KB
17. Define a named range in Excel.mp4	5.7 MB
17. Define a named range in Excel.vtt	1.7 KB
17.1 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx.xlsx	11.3 KB
17.2 28. Naming-ranges-Lecture - Unsolved.xlsx.xlsx	9.0 KB
17.3 28. Naming-ranges-Lecture - Solved.xlsx.xlsx	10.6 KB
17.4 Useful-Tips-Tools.pdf.pdf	3.5 MB
17.5 28. Defining-a-Named-Range-Exercise - Solved.xlsx.xlsx	11.9 KB
18. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4	5.7 MB
18. Assign custom formats to specific cells within a financial model (e.g Multiples).vtt	1.9 KB
18.1 29. Assigning Custom Formats - Exercise - Unsolved.xlsx.xlsx	11.6 KB
18.2 Useful-Tips-Tools.pdf.pdf	3.5 MB
18.3 29. Assigning Custom Formats - Exercise - Solved.xlsx.xlsx	11.3 KB
19. Macros are a great timesaver! Here's why!.mp4	11.6 MB
19. Macros are a great timesaver! Here's why!.vtt	3.4 KB
19.1 Useful-Tips-Tools.pdf.pdf	3.5 MB
19.2 30. Creating-a-Macro-Lecture - Solved.xlsx.xlsx	11.4 KB
19.3 30. Macros-Exercise - Solved.xlsx.xlsx	148.5 KB
19.4 30. Creating-a-Macro-Lecture - Unsolved.xlsx.xlsx	9.9 KB
19.5 30. Macros-Exercise - Unsolved.xlsx.xlsx	10.6 KB
2. Initial formatting of an Excel sheet to render it professional.mp4	8.4 MB
2. Initial formatting of an Excel sheet to render it professional.vtt	2.2 KB
2.1 18. Formatting-a-Worksheet-Exercise - Unsolved.xlsx.xlsx	10.9 KB
2.2 18. Formatting-a-Worksheet-Exercise - Solved.xlsx.xlsx	11.0 KB
2.3 Useful-Tips-Tools.pdf.pdf	3.5 MB
2.4 18. Formatting-a-worksheet-Lecture - Solved.xlsx.xlsx	9.8 KB
2.5 18. Formatting-a-worksheet-Lecture - Unsolved.xlsx.xlsx	9.2 KB
20. How to save macros and use them across several workbooks.mp4	13.4 MB
20. How to save macros and use them across several workbooks.vtt	1.8 KB
20.1 31. Another-file.xlsx.xlsx	9.0 KB
20.2 31. How-to-save-macros-Lecture-before.xlsx.xlsx	6.2 KB
20.3 31. How-to-save-macros-Lecture-after.xlsm.xlsm	12.9 KB
21. Excel Macros - quiz.html	0.2 KB
22. Create a drop-down list by using Data Validation.mp4	11.1 MB
22. Create a drop-down list by using Data Validation.vtt	2.2 KB
22.1 32. Data-Validation-Lecture - Solved.xlsx.xlsx	11.1 KB
22.2 32. Drop-down-List-Exercise - Solved.xlsx.xlsx	78.9 KB
22.3 32. Drop-down-List-Exercise - Unsolved.xlsx.xlsx	11.6 KB
22.4 32. Data-Validation-Lecture - Unsolved.xlsx.xlsx	11.1 KB
22.5 Useful-Tips-Tools.pdf.pdf	3.5 MB
23. Using Custom-sort in order to sort multiple columns within a table.mp4	9.6 MB
23. Using Custom-sort in order to sort multiple columns within a table.vtt	1.6 KB
23.1 33. Custom-Sort-Exercise - Unsolved.xlsx.xlsx	11.6 KB
23.2 33. Sort-data-Lecture - Solved.xlsx.xlsx	149.1 KB
23.3 33. Sort-data-Lecture - Unsolved.xlsx.xlsx	148.8 KB
23.4 Useful-Tips-Tools.pdf.pdf	3.5 MB
23.5 33. Custom-Sort-Exercise - Solved.xlsx.xlsx	11.7 KB
24. Create a great Index page at the beginning of your models - Hyperlinks.mp4	5.6 MB
24. Create a great Index page at the beginning of your models - Hyperlinks.vtt	1.5 KB
24.1 34. Hyperlinks-Exercise - Unsolved.xlsx.xlsx	140.2 KB
24.2 34. Hyperlinks-Exercise - Solved.xlsx.xlsx	140.4 KB
24.3 Useful-Tips-Tools.pdf.pdf	3.5 MB
25. Fix the top row of your table with Freeze Panes.mp4	18.5 MB
25. Fix the top row of your table with Freeze Panes.vtt	1.5 KB
25.1 35. Freeze-Panes-Lecture - Unsolved.xlsx.xlsx	659.3 KB
25.2 35. Freeze-Panes-Lecture - Solved.xlsx.xlsx	659.4 KB
25.3 Useful-Tips-Tools.pdf.pdf	3.5 MB
26. Filter by color - an excellent tool.mp4	10.4 MB
26. Filter by color - an excellent tool.vtt	2.0 KB
26.1 36. Exercise-Filter-by-Color-Unsolved.xlsx.xlsx	21.0 KB
26.2 36. Exercise-Filter-by-Color-Solved.xlsx.xlsx	157.2 KB
27. Working with conditional formatting.mp4	15.8 MB
27. Working with conditional formatting.vtt	5.7 KB
27.1 Solution_Conditional Formatting.xlsx.xlsx	52.8 KB
27.2 Exercise_Conditional Formatting.xlsx.xlsx	13.2 KB
28. A neat trick - Multiply by 1.mp4	15.6 MB
28. A neat trick - Multiply by 1.vtt	1.7 KB
28.1 38. Multiply-by-1-Lecture-before.xlsx.xlsx	16.9 KB
28.2 38. Multiply-by-1-Lecture-after.xlsx.xlsx	17.6 KB
29. Useful tips and tools for your work in Excel - quiz.html	0.2 KB
3. Fast scrolling through Excel sheets.mp4	23.2 MB
3. Fast scrolling through Excel sheets.vtt	1.8 KB
3.1 Useful-Tips-Tools.pdf.pdf	3.5 MB
3.2 19. Fast-Scrolling-Exercise - Unsolved.xlsx.xlsx	45.0 KB
3.3 19. Fast-Scrolling-Exercise - Solved.xlsx.xlsx	45.4 KB
3.4 19. Fast-Scrolling - Lecture.xlsx.xlsx	658.2 KB
30. Find and replace - references.mp4	25.2 MB
30. Find and replace - references.vtt	3.4 KB
30.1 39. Find-and-Replace-references-Lecture-after.xlsx.xlsx	38.8 KB
30.2 39. Find-and-Replace-references-Lecture-before.xlsx.xlsx	39.7 KB
31. Find and replace - formatting.mp4	14.4 MB
31. Find and replace - formatting.vtt	1.9 KB
31.1 40. Find-replace-Lecture-before.xlsx.xlsx	17.6 KB
31.2 40. Find-replace-Lecture-after.xlsx.xlsx	17.6 KB
32. Removing (automatic) green arrows.mp4	13.2 MB
32. Removing (automatic) green arrows.vtt	1.7 KB
32.1 41. Green-references-Lecture.xlsx.xlsx	12.3 KB
33. Beauty saving - The professional way of saving files.mp4	14.7 MB
33. Beauty saving - The professional way of saving files.vtt	2.7 KB
33.1 42. Beauty-saving-Lecture-before.xlsx.xlsx	17.6 KB
33.2 42. Beauty-saving-Lecture-after.xlsx.xlsx	17.5 KB
34. Formula auditing with F2.mp4	18.6 MB
34. Formula auditing with F2.vtt	2.2 KB
34.1 43. F2-Lecture.xlsm.xlsm	52.0 KB
4. Be even quicker F5 + Enter.mp4	20.7 MB
4. Be even quicker F5 + Enter.vtt	2.2 KB
4.1 20. F5-go-to - Lecture.xlsm.xlsm	52.0 KB
5. Fast scrolling through Excel sheets.html	0.2 KB
6. Introduction to fixing of cell references.mp4	21.4 MB
6. Introduction to fixing of cell references.vtt	2.6 KB
6.1 Useful-Tips-Tools.pdf.pdf	3.5 MB
6.2 21. Fixing-Cells-Exercise - Unsolved.xlsx.xlsx	10.9 KB
6.3 21. Fixing-references-Lecture - Unsolved.xlsx.xlsx	659.4 KB
6.4 21. Fixing-Cells-Exercise - Solved.xlsx.xlsx	11.1 KB
6.5 21. Fixing-references-Lecture - Solved.xlsx.xlsx	660.7 KB
7. Introduction to fixing of cell references.html	0.2 KB
8. Using the 'Alt + Enter' combination.mp4	3.5 MB
8. Using the 'Alt + Enter' combination.vtt	1.0 KB
8.1 22. Alt-Enter-Exercise - Unsolved.xlsx.xlsx	11.4 KB
8.2 22. Alt-Enter- Lecture - Unsolved.xlsx.xlsx	9.9 KB
8.3 22. Alt-Enter- Lecture - Solved.xlsx.xlsx	9.9 KB
8.4 22. Alt-Enter-Exercise - Solved.xlsx.xlsx	11.7 KB
9. Learn how to organize your data with Text to Columns.mp4	13.2 MB
9. Learn how to organize your data with Text to Columns.vtt	2.3 KB
9.1 23. Text-to-Columns-Exercise - Solved.xlsx.xlsx	11.6 KB
9.2 23. Text-to-Columns-Exercise - Unsolved.xlsx.xlsx	10.8 KB
9.3 23. Text-to-columns-Lecture - Unsolved.xlsx.xlsx	10.0 KB
9.4 Useful-Tips-Tools.pdf.pdf	3.5 MB
9.5 23.Text-to-columns-Lecture - Solved.xlsx.xlsx	10.1 KB
/4. Keyboard shortcuts in Excel/
1. Keyboard shortcuts Save LOTS of time in Excel.mp4	31.9 MB
1. Keyboard shortcuts Save LOTS of time in Excel.vtt	5.3 KB
2. Keyboard shortcuts in Excel.html	0.2 KB
/5/
1. Excel's key functions - Welcome lecture.mp4	2.4 MB
1. Excel's key functions - Welcome lecture.vtt	1.1 KB
10. Working with text in Excel.mp4	16.8 MB
10. Working with text in Excel.vtt	3.1 KB
10.1 53. Work-with-text-Lecture-after.xlsx.xlsx	11.2 KB
10.2 53. Work-with-text-Lecture-before.xlsx.xlsx	10.6 KB
11. Find the minimum or maximum value in a range of cells in Excel.mp4	6.2 MB
11. Find the minimum or maximum value in a range of cells in Excel.vtt	1.1 KB
11.1 54. Max-min-Lecture - Unsolved.xlsx.xlsx	9.2 KB
11.2 54. MIN-MAX-Exercise - Unsolved.xlsx.xlsx	14.7 KB
11.3 54. Max-min-Lecture - Solved.xlsx.xlsx	9.4 KB
11.4 54. MIN-MAX-Exercise - Solved.xlsx.xlsx	15.2 KB
12. Include ROUND in your financial models.mp4	3.3 MB
12. Include ROUND in your financial models.vtt	1.2 KB
12.1 Excel-Functions.pdf.pdf	3.3 MB
12.2 55. Excel-functions-Lecture.xlsx.xlsx	911.3 KB
12.3 55. Round-Exercise - Unsolved.xlsx.xlsx	11.6 KB
12.4 55. Round-Exercise - Solved.xlsx.xlsx	12.0 KB
13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4	36.3 MB
13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.vtt	8.7 KB
13.1 56. Vlookup-Hlookup- Lecture - Unsolved.xlsx.xlsx	11.0 KB
13.2 56. Vlookup-Hlookup- Lecture - Solved.xlsx.xlsx	11.4 KB
13.3 Excel-Functions.pdf.pdf	3.3 MB
13.4 56. Vlookup-Hlookup-Exercise - Solved.xlsx.xlsx	14.0 KB
13.5 56. Vlookup-Hlookup-Exercise - Unsolved.xlsx.xlsx	12.2 KB
14. How to enlarge the formula bar.mp4	6.6 MB
14. How to enlarge the formula bar.vtt	1.4 KB
14.1 57. Enlarge-the-formula-bar-Lecture.xlsm.xlsm	48.0 KB
15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4	40.8 MB
15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.vtt	8.4 KB
15.1 58. Index-Match-Lecture - Solved.xlsx.xlsx	12.0 KB
15.2 Excel-Functions.pdf.pdf	3.3 MB
15.3 58. Index-Match-Exercise - Solved.xlsx.xlsx	12.4 KB
15.4 58. Index-Match-Lecture - Unsolved.xlsx.xlsx	11.6 KB
15.5 58. Index-Match-Exercise - Unsolved.xlsx.xlsx	11.9 KB
16. A great Excel technique INDEX, MATCH, MATCH.mp4	12.3 MB
16. A great Excel technique INDEX, MATCH, MATCH.vtt	5.4 KB
16.1 59. Exercise-Index-Match-Match-Solved.xlsx.xlsx	12.5 KB
16.2 59. Exercise-Index-Match-Match-Unsolved.xlsx.xlsx	11.9 KB
17. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.html	0.2 KB
18. Using Excel's IFERROR function to trap spreadsheet errors.mp4	7.9 MB
18. Using Excel's IFERROR function to trap spreadsheet errors.vtt	2.1 KB
18.1 60. Iferror - Lecture - Unsolved.xlsm.xlsm	918.8 KB
18.2 60. Iferror-Exercise - Solved.xlsx.xlsx	15.7 KB
18.3 60. Iferror-Exercise - Unsolved.xlsx.xlsx	14.6 KB
18.4 Excel-Functions.pdf.pdf	3.3 MB
18.5 60. Iferror - Lecture - Solved.xlsm.xlsm	917.9 KB
19. RANK is a valuable tool when using Excel for Financial and Business analysis.mp4	24.4 MB
19. RANK is a valuable tool when using Excel for Financial and Business analysis.vtt	2.9 KB
19.1 61. Rank-function-Lecture-after.xlsx.xlsx	12.9 KB
19.2 61. Rank-function-Lecture-before.xlsx.xlsx	12.6 KB
2. Key functions in Excel IF.mp4	17.5 MB
2. Key functions in Excel IF.vtt	2.9 KB
2.1 47. IF-function--Lecture-before.xlsm.xlsm	17.4 KB
2.2 Functions - English to German.pdf.pdf	104.8 KB
2.3 Key functions - Excel.pdf.pdf	8.9 MB
2.4 47. IF-function-Lecture-after.xlsm.xlsm	18.4 KB
2.5 Functions - English to Spanish.pdf.pdf	104.8 KB
2.6 Functions - English to Portuguese.pdf.pdf	149.6 KB
20. Learn how to render your models flexible with CHOOSE.mp4	9.4 MB
20. Learn how to render your models flexible with CHOOSE.vtt	2.7 KB
20.1 62. Choose-Lecture - Unsolved.xlsx.xlsx	9.6 KB
20.2 62. Choose-Lecture - Solved.xlsx.xlsx	9.9 KB
20.3 62. Choose-Exercise-Solved.xlsx.xlsx	12.0 KB
20.4 Excel-Functions.pdf.pdf	3.3 MB
20.5 62. Choose-Exercise - Unsolved.xlsx.xlsx	11.6 KB
21. Use Goal Seek to find the result that you are looking for.mp4	8.2 MB
21. Use Goal Seek to find the result that you are looking for.vtt	2.6 KB
21.1 63. Goal-Seek-Exercise - Unsolved.xlsx.xlsx	16.5 KB
21.2 Excel-Functions.pdf.pdf	3.3 MB
21.3 63. Goal-Seek-Exercise-Solved.xlsx.xlsx	16.6 KB
21.4 63. Goal-Seek-Lecture - Solved.xlsx.xlsx	9.4 KB
21.5 63. Goal-Seek-Lecture - Unsolved.xlsx.xlsx	9.4 KB
22. Use Goal Seek in order to find the result that you are looking for.html	0.2 KB
23. Include sensitivity analysis in your models through Data Tables.mp4	15.0 MB
23. Include sensitivity analysis in your models through Data Tables.vtt	4.8 KB
23.1 64. Sensitivity analysis - Lecture - Solved.xlsm.xlsm	918.8 KB
23.2 64. Sensitivity-analysis-Exercise-Unsolved.xlsm.xlsm	68.4 KB
23.3 64. Sensitivity-analysis-Exercise-Solved.xlsm.xlsm	65.4 KB
23.4 64. Sensitivity analysis - Lecture - Unsolved.xlsm.xlsm	918.6 KB
24. Include sensitivity analysis in your models through Data Tables.html	0.2 KB
25. Excel's dynamic and interactive tables Pivot tables.mp4	17.4 MB
25. Excel's dynamic and interactive tables Pivot tables.vtt	2.6 KB
25.1 65. Pivot tables - Lecture - Unsolved.xlsm.xlsm	704.3 KB
25.2 65. Pivot Tables - Exercise - Unsolved.xlsx.xlsx	155.8 KB
25.3 65. Pivot tables - Lecture - Solved.xlsm.xlsm	918.8 KB
25.4 65. Pivot Tables - Exercise - Solved.xlsx.xlsx	195.0 KB
26. Excel's key functions and functionalities made easy.html	0.2 KB
3. Key Excel functions SUM, SUMIF and SUMIFS.mp4	20.3 MB
3. Key Excel functions SUM, SUMIF and SUMIFS.vtt	5.0 KB
3.1 48. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx.xlsx	13.2 KB
3.2 48. Sum-Sumif-Sumifs-Lecture - Solved.xlsx.xlsx	13.3 KB
3.3 48. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx.xlsx	14.8 KB
3.4 Excel-Functions.pdf.pdf	3.3 MB
3.5 48. Sum-Sumif-Sumifs-Exercise - Solved.xlsx.xlsx	15.2 KB
4. = and + are interchangeable when you start typing a formula.mp4	6.1 MB
4. = and + are interchangeable when you start typing a formula.vtt	1.0 KB
4.1 49. = and + are interchangeable -after.xlsm.xlsm	17.4 KB
4.2 49. = and + are interchangeable - before.xlsm.xlsm	17.4 KB
5. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4	17.8 MB
5. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.vtt	4.6 KB
5.1 50.Counts-Exercise-Solved.xlsx.xlsx	16.5 KB
5.2 Excel-Functions.pdf.pdf	3.3 MB
5.3 Lecture-Count-Countif-Countifs-Solved.xlsx.xlsx	12.0 KB
5.4 Lecture-Count-Countif-Countifs-Unsolved.xlsx.xlsx	11.6 KB
5.5 50.Counts-Exercise-Unsolved.xlsx.xlsx	15.9 KB
6. Key Excel functions AVERAGE and AVERAGEIF.mp4	8.2 MB
6. Key Excel functions AVERAGE and AVERAGEIF.vtt	2.3 KB
6.1 Excel-Functions.pdf.pdf	3.3 MB
6.2 51. Average-AverageIF-Exercise - Solved.xlsx.xlsx	15.4 KB
6.3 51. Average-Averageif- Lecture - Unsolved.xlsx.xlsx	9.2 KB
6.4 51. Average-AverageIF-Exercise - Unsolved.xlsx.xlsx	15.0 KB
6.5 51. Average-Averageif- Lecture - Solved.xlsx.xlsx	9.6 KB
7. Key Excel functions AVERAGE and AVERAGEIF.html	0.2 KB
8. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4	17.6 MB
8. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.vtt	5.4 KB
8.1 52. Text-Functions- Lecture - Solved.xlsx.xlsx	11.4 KB
8.2 52. Text functions - Exercise - Unsolved.xlsx.xlsx	12.0 KB
8.3 52. Text functions - Exercise - Solved.xlsx.xlsx	12.5 KB
8.4 52. Text-Functions- Lecture - Unsolved.xlsx.xlsx	10.9 KB
9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.html	0.2 KB
/6. Update! SUMIFS - Exercise/
1. Exercise - Excel's SUMIFS function - unsolved.html	0.2 KB
2. Exercise - Excel's SUMIFS function - solved & explained.mp4	37.0 MB
2. Exercise - Excel's SUMIFS function - solved & explained.vtt	10.3 KB
2.1 67. Exercise-Sumifs-With-Solutions.xlsx.xlsx	1.4 MB
/7. Financial functions in Excel/
1. Future and present values in Excel.mp4	15.7 MB
1. Future and present values in Excel.vtt	6.5 KB
1.1 68. FV and PV-Lecture.xlsx.xlsx	10.9 KB
2. Calculating the rate of return of an investment with the IRR function.mp4	7.9 MB
2. Calculating the rate of return of an investment with the IRR function.vtt	3.4 KB
2.1 69. Exercise-IRR-Solved.xlsx.xlsx	12.6 KB
2.2 69. IRR-Lecture.xlsx.xlsx	11.5 KB
2.3 69. Exercise-IRR-Unsolved.xlsx.xlsx	11.8 KB
3. Calculating a complete loan schedule in Excel.mp4	15.5 MB
3. Calculating a complete loan schedule in Excel.vtt	6.0 KB
3.1 70. Loan Schedule-Lecture.xlsx.xlsx	20.7 KB
3.2 70. Exercise-Loan-Schedule-Solved.xlsx.xlsx	23.2 KB
3.3 70. Exercise-Loan-Schedule-Unsolved.xlsx.xlsx	16.2 KB
4. Date functions in Excel.mp4	11.9 MB
4. Date functions in Excel.vtt	5.6 KB
4.1 71. Date Functions-Exercise-Solved.xlsx.xlsx	12.7 KB
4.2 71. Date Functions-Lecture.xlsx.xlsx	12.5 KB
4.3 71. Date Functions-Exercise-Unsolved.xlsx.xlsx	11.7 KB
/8. Microsoft Excel's Pivot Tables in Depth/
1. Introduction to Pivot Tables and the way they are applied.mp4	6.3 MB
1. Introduction to Pivot Tables and the way they are applied.vtt	2.0 KB
2. Creating Pivot Tables easily!.mp4	20.3 MB
2. Creating Pivot Tables easily!.vtt	4.1 KB
2.1 73. Creating-a-Pivot-Table - Lecture - after.xlsx.xlsx	1.5 MB
2.2 73. Creating-a-Pivot-Table - Lecture – before.xlsx.xlsx	1.3 MB
3. Give your Excel Pivot Tables a makeover.mp4	11.8 MB
3. Give your Excel Pivot Tables a makeover.vtt	2.3 KB
3.1 74. Formatting-a-Pivot-Table - Lecture - after.xlsx.xlsx	1.5 MB
3.2 74. Formatting-a-Pivot-Table - Lecture - before.xlsx.xlsx	1.5 MB
4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4	24.1 MB
4. Modifying and pivoting fields to obtain the Pivot Table you need.vtt	4.4 KB
4.1 75. Working-with-Pivot-Tables - Lecture - before.xlsx.xlsx	1.5 MB
4.2 75. Working-with-Pivot-Tables - Lecture - after.xlsx.xlsx	2.0 MB
5. Learn more about GETPIVOTDATA - A very important Excel function.mp4	18.9 MB
5. Learn more about GETPIVOTDATA - A very important Excel function.vtt	3.9 KB
5.1 76. GetPivotData - Lecture - before.xlsx.xlsx	2.0 MB
5.2 76. GetPivotData - Lecture – after.xlsx.xlsx	2.0 MB
6. An introduction to slicers - The modern-day Pivot Table filters.mp4	23.2 MB
6. An introduction to slicers - The modern-day Pivot Table filters.vtt	4.5 KB
6.1 77. Slicers - Lecture - after.xlsx.xlsx	2.0 MB
6.2 77. Slicers - Lecture - before.xlsx.xlsx	2.0 MB
/9/
1. Case study - Build a P&L from scratch - Welcome lecture.mp4	3.3 MB
1. Case study - Build a P&L from scratch - Welcome lecture.vtt	1.6 KB
10. Use INDEX & MATCH as a substitute for VLOOKUP.mp4	52.0 MB
10. Use INDEX & MATCH as a substitute for VLOOKUP.vtt	4.3 KB
10.1 87. Index Match-Lecture-before.xlsm.xlsm	42.0 KB
10.2 87. Index Match-Lecture-after.xlsm.xlsm	14.5 MB
11. Mapping the rows in the Database sheet.mp4	34.1 MB
11. Mapping the rows in the Database sheet.vtt	2.7 KB
11.1 88. Mapping-Lecture-after.xlsm.xlsm	51.4 KB
11.2 88. Mapping_before.xlsm.xlsm	51.8 KB
12. In case you have any doubts about the Mapping exercise.mp4	40.4 MB
12. In case you have any doubts about the Mapping exercise.vtt	6.5 KB
12.1 89. Mapping-Lecture-Unsolved.xlsm.xlsm	51.8 KB
12.2 89. Mapping-exercise-explained.pdf.pdf	248.9 KB
12.3 89. Mapping-Lecture-Solved.xlsx.xlsx	48.6 KB
13. Building the structure of the P&L sheet.mp4	21.9 MB
13. Building the structure of the P&L sheet.vtt	2.2 KB
13.1 90. Building a P&L-Lecture-before.xlsm.xlsm	51.4 KB
13.2 90. Building a P&L-Lecture-after.xlsm.xlsm	53.1 KB
14. Formatting sets You apart from the competition in Excel - A Practical Example.mp4	26.7 MB
14. Formatting sets You apart from the competition in Excel - A Practical Example.vtt	23.1 MB
14.1 91. Formatting a P&L-Lecture-before.xlsm.xlsm	53.1 KB
14.2 91. Formatting the P&L-Lecture-after.xlsm.xlsm	53.2 KB
15. Populate the P&L sheet with SUMIF.mp4	31.7 MB
15. Populate the P&L sheet with SUMIF.vtt	3.0 KB
15.1 92. Formatting the P&L-Lecture-after.xlsm.xlsm	54.8 KB
15.2 92. Formatting the P&L-Lecture-before.xlsm.xlsm	53.2 KB
16. Learn how to find mistakes with COUNTIF.mp4	29.2 MB
16. Learn how to find mistakes with COUNTIF.vtt	2.9 KB
16.1 93. Countif-Lecture-after.xlsm.xlsm	56.1 KB
16.2 93. Countif-Lecture-before.xlsm.xlsm	54.8 KB
17. Calculating year-on-year percentage variations the proper way.mp4	31.4 MB
17. Calculating year-on-year percentage variations the proper way.vtt	3.3 KB
17.1 94. Adding % variations-Lecture-after.xlsm.xlsm	57.9 KB
17.2 94. Adding % variations-Lecture-before.xlsm.xlsm	56.1 KB
17.3 Y-o-Y Function explanation.pdf.pdf	168.9 KB
2. Introduction to the case study.mp4	10.7 MB
2. Introduction to the case study.vtt	1.1 KB
3. Understand your data source before you start working on it.mp4	29.5 MB
3. Understand your data source before you start working on it.vtt	3.1 KB
3.1 80. Get to know the data source.xlsm.xlsm	44.1 KB
4. Order the source worksheets.mp4	27.8 MB
4. Order the source worksheets.vtt	2.5 KB
4.1 81. Order a worksheet_before.xlsm.xlsm	44.1 KB
4.2 81. Order a worksheet_after.xlsm.xlsm	42.0 KB
5. Create a code the best way to organize your data and work efficiently with it.mp4	25.7 MB
5. Create a code the best way to organize your data and work efficiently with it.vtt	2.2 KB
5.1 82. Creating a code_before.xlsm.xlsm	42.0 KB
5.2 82. Creating a code_after.xlsm.xlsm	42.7 KB
6. Learn how to create a database.mp4	21.7 MB
6. Learn how to create a database.vtt	2.2 KB
6.1 83. Creating a database_after.xlsm.xlsm	40.3 KB
6.2 83. Creating a database_before.xlsm.xlsm	42.7 KB
7. Use VLOOKUP to fill the Database sheet.mp4	64.6 MB
7. Use VLOOKUP to fill the Database sheet.vtt	5.5 KB
7.1 84. Vlookup_before.xlsm.xlsm	40.5 KB
7.2 84. Vlookup_after.xlsm.xlsm	45.5 KB
8. 50% Completed!.mp4	4.5 MB
8. 50% Completed!.vtt	0.1 KB
9. Use SUMIF to complete the Database sheet.mp4	50.3 MB
9. Use SUMIF to complete the Database sheet.vtt	4.3 KB
9.1 86. Sumif_after.xlsm.xlsm	50.7 KB
9.2 86. Sumif_before.xlsm.xlsm	45.5 KB
/
[Tutorialsplanet.NET].url	0.1 KB
Total files 858