FreeCourseSite com Udemy Beginner to Pro in Excel Financial Modeling and Valuation

FreeCourseSite com Udemy Beginner to Pro in Excel Financial Modeling and Valuation

Name	[FreeCourseSite.com] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	3.2 GB
Total Files	776
Last Seen	2025-07-21 00:47
Hash	CF7DD8960C6B7C655B414780D9E1F63299C7B247

/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 approach to take this course.mp4	8.2 MB
4. The approach to take this course.vtt	2.4 KB
5. Download all course materials.html	0.8 KB
/10. 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 0. Exercise - Build an FMCG Model_before.xlsx.xlsx	13.9 MB
10. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4	18.0 MB
10. Getting fancy with Excel slicers - Good-looking Excel slicers.vtt	3.5 KB
10.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx	23.9 MB
11. This is how the report can be used in practice by high-level executives.mp4	20.8 MB
11. This is how the report can be used in practice by high-level executives.vtt	4.5 KB
11.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx	23.9 MB
12. 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 1. Exercise - Build an FMCG Model_Mapping.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 2. Exercise - Build an FMCG Model_Structure.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 2. Exercise - Build an FMCG Model_Layout.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 4. Exercise - Build an FMCG Model_Adding Calculations.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 5. Exercise - Build an FMCG Model_Creating a Pivot Table.xlsx.xlsx	21.8 MB
8. GetPivotData is great! Extracting data from the Master Pivot Table.mp4	32.6 MB
8. GetPivotData is great! Extracting data from the Master Pivot Table.vtt	6.8 KB
8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA.xlsx.xlsx	21.8 MB
9. Combining Slicers and GetPivotData The key to our success.mp4	18.7 MB
9. Combining Slicers and GetPivotData The key to our success.vtt	3.5 KB
9.1 8. Exercise - Build an FMCG Model_Inserting Slicers.xlsx.xlsx	21.8 MB
/11. 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
/12. Introduction to Company Valuation/
1. The core theory behind Company Valuation.html	0.2 KB
/13. Introduction to Mergers & Acquisitions/
1. Introduction to Mergers & Acquisitions.html	0.2 KB
/14. Learn how to build a Discounted Cash Flow model in Excel/
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	5.4 MB
10. Modeling other items Interest expenses, Extraordinary items and Taxes.vtt	2.9 KB
10.1 9. Interest expenses, Extraordinary items and Taxes - Solved.xlsm.xlsm	54.0 KB
10.2 9. Interest expenses, Extraordinary items and Taxes – Unsolved.xlsm.xlsm	52.9 KB
11. Forecasting Balance Sheet items.mp4	1.0 MB
11. Forecasting Balance Sheet items.vtt	0.9 KB
11.1 10. Project BS items - Solved.xlsm.xlsm	54.0 KB
11.2 10. Project BS items – Unsolved.xlsm.xlsm	54.0 KB
12. An introduction to the Days methodology.mp4	2.4 MB
12. An introduction to the Days methodology.vtt	1.9 KB
12.1 Working Capital Days.pptx.pptx	124.5 KB
13. Calculation of DSO, DPO and DOI for the historical period.mp4	2.8 MB
13. Calculation of DSO, DPO and DOI for the historical period.vtt	1.7 KB
13.1 12. Calculating DSO, DPO and DIO - Solved.xlsm.xlsm	53.6 KB
13.2 12. Calculating DSO, DPO and DIO - Unsolved.xlsm.xlsm	51.1 KB
14. Forecasting DSO, DPO and DOI.mp4	4.1 MB
14. Forecasting DSO, DPO and DOI.vtt	2.9 KB
14.1 13. Forecasting DSO, DPO and DIO - Solved.xlsm.xlsm	54.9 KB
14.2 13. Forecasting DSO, DPO and DIO - Unsolved.xlsm.xlsm	51.3 KB
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4	5.0 MB
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.vtt	3.1 KB
15.1 14. Forecasting PP&E, Other assets and Other liabilities - Unsolved.xlsm.xlsm	52.3 KB
15.2 14. Forecasting PP&E, Other assets and Other liabilities - Solved.xlsm.xlsm	52.3 KB
16. Creating an output P&L sheet.mp4	3.9 MB
16. Creating an output P&L sheet.vtt	2.6 KB
16.1 15. P&L structure - Solved.xlsm.xlsm	56.7 KB
16.2 15. P&L structure – Unsolved.xlsm.xlsm	51.6 KB
17. Populating the output P&L sheet.mp4	5.6 MB
17. Populating the output P&L sheet.vtt	2.7 KB
17.1 16. Populating the P&L sheet - Solved.xlsm.xlsm	58.5 KB
17.2 16. Populating the P&L sheet – Unsolved.xlsm.xlsm	54.0 KB
18. Populating the output BS sheet.mp4	3.6 MB
18. Populating the output BS sheet.vtt	2.2 KB
18.1 17. Populating the Balance sheet – Unsolved.xlsm.xlsm	56.1 KB
18.2 17. Populating the BS sheet - Solved.xlsm.xlsm	60.2 KB
19. Completing the output BS sheet for the historical period.mp4	7.9 MB
19. Completing the output BS sheet for the historical period.vtt	4.5 KB
19.1 18. Completing the BS items - Solved.xlsm.xlsm	61.5 KB
19.2 18. Completing the BS items – Unsolved.xlsm.xlsm	57.0 KB
2. Introduction to the DCF exercise.mp4	4.7 MB
2. Introduction to the DCF exercise.vtt	1.3 KB
20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp4	4.3 MB
20. Creating a structure for the calculation of Unlevered Free Cash Flows.vtt	3.4 KB
20.1 19. Building a Cash Flow Format – Solved.xlsm.xlsm	58.6 KB
20.2 19. Building a Cash Flow Format – Unsolved.xlsm.xlsm	57.5 KB
21. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4	2.9 MB
21. Bridging Unlevered Free Cash Flow to Net Cash Flow.vtt	2.2 KB
21.1 20. From UFCF to Net Cash Flow – Solved.xlsm.xlsm	61.8 KB
21.2 20. From UFCF to Net Cash Flow - Unsolved.xlsm.xlsm	58.2 KB
22. Calculating Unlevered Free Cash Flow.mp4	11.3 MB
22. Calculating Unlevered Free Cash Flow.vtt	6.9 KB
22.1 21. Calculating UFCF - Unsolved.xlsm.xlsm	60.9 KB
22.2 21. Calculating UFCF - Solved.xlsm.xlsm	59.3 KB
23. Calculating Net Cash Flow.mp4	7.4 MB
23. Calculating Net Cash Flow.vtt	4.6 KB
23.1 Cash Flow Classification By Activities.xlsx	57.3 KB
23.2 22. From UFCF to Net Cash Flow - Unsolved.xlsm.xlsm	59.3 KB
23.3 22. From UFCF to Net Cash Flow - Solved.xlsm.xlsm	62.8 KB
24. Obtaining the rest of the cash flows through Find and Replace.mp4	10.2 MB
24. Obtaining the rest of the cash flows through Find and Replace.vtt	4.3 KB
24.1 23. Use Find and Replace - Unsolved.xlsm.xlsm	62.8 KB
24.2 23. Use Find and Replace - Solved.xlsm.xlsm	66.0 KB
25. Introducing Weighted Average Cost of Capital and Perpetuity Growth.mp4	2.8 MB
25. Introducing Weighted Average Cost of Capital and Perpetuity Growth.vtt	2.2 KB
25.1 24. Introducing WACC and g - Unsolved.xlsm.xlsm	62.4 KB
25.2 24. Introducing WACC and g - Solved.xlsm.xlsm	62.5 KB
26. Discounting Unlevered Free Cash Flows to obtain their Present Value.mp4	4.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 - Unsolved.xlsm.xlsm	59.6 KB
26.2 25. Calculating PV of Cash Flows - Solved.xlsm.xlsm	63.5 KB
27. Calculating Continuing Value and Enterprise Value of the business.mp4	3.6 MB
27. Calculating Continuing Value and Enterprise Value of the business.vtt	2.5 KB
27.1 26. Calculating CV of the business - Solved.xlsm.xlsm	63.8 KB
27.2 26. Calculating CV of the business - Unsolved.xlsm.xlsm	63.5 KB
28. Calculating Equity Value.mp4	2.6 MB
28. Calculating Equity Value.vtt	1.7 KB
28.1 27. Calculating Equity Value - Unsolved.xlsm.xlsm	63.8 KB
28.2 27. Calculating Equity Value - Solved.xlsm.xlsm	64.1 KB
29. Sensitivity analysis for WACC and perpetuity growth.mp4	9.0 MB
29. Sensitivity analysis for WACC and perpetuity growth.vtt	4.6 KB
29.1 28. Sensitivity analysis - Solved.xlsm.xlsm	65.4 KB
29.2 Sensitivity Analysis.xlsx	62.3 KB
29.3 28. Sensitivity analysis - Unsolved.xlsm.xlsm	64.1 KB
3. The various stages of a complete DCF Valuation.mp4	9.0 MB
3. The various stages of a complete DCF Valuation.vtt	7.8 KB
3.1 Valuation exercise.pdf.pdf	421.6 KB
30. A possible application of Goal Seek.mp4	3.4 MB
30. A possible application of Goal Seek.vtt	1.9 KB
30.1 29. Goal Seek - Unsolved.xlsm.xlsm	65.4 KB
30.2 29. Goal seek - Solved.xlsm.xlsm	65.4 KB
31. Using charts to summarize the results of the DCF model.mp4	8.6 MB
31. Using charts to summarize the results of the DCF model.vtt	5.7 KB
31.1 30. Charts – Unsolved.xlsm.xlsm	65.4 KB
31.2 30. Charts - Solved.xlsm.xlsm	99.4 KB
32. You Made It!.mp4	8.0 MB
32. You Made It!.vtt	2.7 KB
4. Description of the structure of the DCF model.mp4	4.7 MB
4. Description of the structure of the DCF model.vtt	3.5 KB
4.1 DCF Model structure.pdf.pdf	246.6 KB
4.2 3. Beginning of exercise.xlsm.xlsm	50.0 KB
5. A glimpse at the company we are valuing - Cheeseco.mp4	1.8 MB
5. A glimpse at the company we are valuing - Cheeseco.vtt	1.5 KB
5.1 Beginning Of Exercise.xlsx	43.4 KB
6. Modeling the top line.mp4	5.4 MB
6. Modeling the top line.vtt	4.2 KB
6.1 5. Modeling revenues - Solved.xlsm.xlsm	50.5 KB
6.2 5. Modeling revenues - Unsolved.xlsm.xlsm	49.8 KB
7. Introducing scenarios to the model with Choose.mp4	3.4 MB
7. Introducing scenarios to the model with Choose.vtt	2.7 KB
7.1 6. Choose - Solved.xlsm.xlsm	50.7 KB
7.2 6. Choose – Unsolved.xlsm.xlsm	47.6 KB
8. Modeling other items Other revenues and Cogs.mp4	7.8 MB
8. Modeling other items Other revenues and Cogs.vtt	4.5 KB
8.1 7. Modeling Cogs – Unsolved.xlsm.xlsm	49.9 KB
8.2 7. Modeling Cogs - Solved.xlsm.xlsm	53.1 KB
9. Modeling other items Operating expenses and D&A.mp4	5.5 MB
9. Modeling other items Operating expenses and D&A.vtt	2.9 KB
9.1 8. Opex and D&A - Solved.xlsm.xlsm	53.6 KB
9.2 8. Opex and D&A - Unsolved.xlsm.xlsm	50.1 KB
/15. 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.3 KB
1.1 0a. Drivers_before.xlsx.xlsx	1.3 MB
1.2 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.2 KB
10.1 6. Energy and Other revenue - After.xlsx.xlsx	1.4 MB
10.2 6. Energy and Other revenue - Before.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.6 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.1 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.4 KB
13.1 9. PP&E forecasting and comparables_after.xlsx.xlsx	1.4 MB
13.2 9. PP&E forecasting and comparables_before.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_before.xlsx.xlsx	1.4 MB
14.2 10. PP&E schedule_after.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.6 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.2 KB
16.1 11. Working capital forecasting_after.xlsx.xlsx	1.6 MB
16.2 11. Working capital forecasting_before.xlsx.xlsx	1.4 MB
17. Producing a clean P&L output sheet.mp4	8.8 MB
17. Producing a clean P&L output sheet.vtt	1.7 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_before.xlsx.xlsx	1.5 MB
18.2 12a. P&L fill in_after.xlsx.xlsx	1.5 MB
19. Calculating investments in working capital.mp4	20.0 MB
19. Calculating investments in working capital.vtt	2.2 KB
19.1 13. Calculating working capital_before.xlsx.xlsx	1.5 MB
19.2 13. Calculating working capital_after.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.7 KB
2.1 0aa. Inputs_after.xlsx.xlsx	1.3 MB
2.2 0aa. Inputs_before.xlsx.xlsx	1.3 MB
20. Forecasting Unlevered Free Cash Flow.mp4	58.6 MB
20. Forecasting Unlevered Free Cash Flow.vtt	6.2 KB
20.1 14. Cash flow - UFCF_before.xlsx.xlsx	1.5 MB
20.2 14. Cash flow - UFCF_after.xlsx.xlsx	1.5 MB
21. Forecasting other assets.mp4	47.4 MB
21. Forecasting other assets.vtt	4.7 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_before.xlsx.xlsx	1.5 MB
22.2 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx	1.5 MB
23. Completing Unlevered Free Cash Flow.mp4	42.9 MB
23. Completing Unlevered Free Cash Flow.vtt	3.6 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.6 KB
24.1 17. Financing_after.xlsx.xlsx	1.5 MB
24.2 17. Financing_before.xlsx.xlsx	1.5 MB
25. Calculating Net income.mp4	15.5 MB
25. Calculating Net income.vtt	1.4 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.5 KB
26.1 19. Cash flow_complete_before.xlsx.xlsx	1.5 MB
26.2 19. Cash flow_complete_after.xlsx.xlsx	1.5 MB
27. Balancing the Balance sheet.mp4	13.9 MB
27. Balancing the Balance sheet.vtt	1.2 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	7.0 KB
28.1 21. WACC_after.xlsx.xlsx	1.5 MB
28.2 21. WACC_before.xlsx.xlsx	1.5 MB
29. Performing Discounted Cash Flow valuation (DCF).mp4	36.6 MB
29. Performing Discounted Cash Flow valuation (DCF).vtt	4.0 KB
29.1 22. DCF_before.xlsx.xlsx	1.6 MB
29.2 22. DCF_after.xlsx.xlsx	1.5 MB
3. Forecasting Tesla's expected deliveries.mp4	120.5 MB
3. Forecasting Tesla's expected deliveries.vtt	14.9 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.7 MB
30. Calculating enterprise value, equity value, and price per share.vtt	2.2 KB
30.1 23. EV, Equity value, Price per share_after.xlsx.xlsx	1.5 MB
30.2 23. EV, Equity value, Price per share_before.xlsx.xlsx	1.5 MB
31. Final comments.mp4	47.1 MB
31. Final comments.vtt	4.4 KB
4. Comparing delivery figures with the ones of industry peers.mp4	21.9 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	5.2 KB
5.1 2. Average price_after.xlsx.xlsx	1.4 MB
5.2 2. Average price_before.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 - after.xlsx.xlsx	1.4 MB
6.2 3. Revenue calculation and scenarios - before.xlsx.xlsx	1.4 MB
7. Peer comparison Gross profit %.mp4	18.0 MB
7. Peer comparison Gross profit %.vtt	2.8 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 - after.xlsx.xlsx	1.4 MB
8.2 4a. Gross profit automotive - before.xlsx.xlsx	1.6 MB
9. Calculating automotive cost of sales.mp4	18.3 MB
9. Calculating automotive cost of sales.vtt	2.3 KB
9.1 5. Cost of sales and chart.xlsx.xlsx	1.4 MB
/16. 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.8 KB
3. The time value of money.mp4	7.0 MB
3. The time value of money.vtt	2.7 KB
4. Calculating future and present Value.mp4	13.7 MB
4. Calculating future and present Value.vtt	6.2 KB
5. Calculating cost of equity.mp4	20.1 MB
5. Calculating cost of equity.vtt	7.7 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.5 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
/17. 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	23.6 MB
11. Discounting the project's cash flows and residual value.vtt	3.4 KB
11.1 9. Discounted cash flow.xlsx.xlsx	39.0 KB
11.2 9. Discounted cash flow_unsolved.xlsx.xlsx	38.1 KB
12. Performing sensitivity analysis and completing the exercise.mp4	35.8 MB
12. Performing sensitivity analysis and completing the exercise.vtt	5.0 KB
12.1 10. Sensitivty analysis_unsolved.xlsx.xlsx	39.6 KB
12.2 10. Sensitivty analysis.xlsx.xlsx	39.7 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.2 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.0 KB
3.1 2. Savings Forecast_unsolved.xlsx.xlsx	15.1 KB
3.2 2. Savings Forecast.xlsx.xlsx	17.0 KB
4. Fixed asset rollforward.mp4	12.8 MB
4. Fixed asset rollforward.vtt	5.2 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	3.0 KB
5.1 4. Working Capital_unsolved.xlsx.xlsx	21.7 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.3 KB
6.1 5. Financing.xlsx.xlsx	31.7 KB
6.2 5. Financing_unsolved.xlsx.xlsx	30.7 KB
7. Adding a P&L sheet.mp4	5.1 MB
7. Adding a P&L sheet.vtt	2.1 KB
7.1 6. P&L_unsolved.xlsx.xlsx	30.4 KB
7.2 6. P&L.xlsx.xlsx	31.8 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.4 KB
9.1 8. WACC.xlsx.xlsx	38.9 KB
9.2 8. WACC_unsolved.xlsx.xlsx	36.8 KB
/18. Bonus lecture/
1. Bonus lecture Next steps.html	2.2 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 02 12 Functions Exercise & Text.xlsx.xlsx	13.6 KB
11.2 Functions - Solved.xlsx.xlsx	9.6 KB
11.3 02 12 Functions Solved.xlsx.xlsx	83.0 KB
11.4 Functions – Unsolved.xlsx.xlsx	9.5 KB
12. Cut, copy, & paste.mp4	7.9 MB
12. Cut, copy, & paste.vtt	2.4 KB
12.1 02 13 Copy Cut Paste Exercise Text.xlsx.xlsx	11.6 KB
12.2 02 13 Copy Cut Paste 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 02 14 Paste Special Exercise & Text.xlsx.xlsx	13.8 KB
14.2 02 14 Paste Special Solved.xlsx.xlsx	13.8 KB
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 02 6 Overview of Excel Exercise & Text.xlsx.xlsx	10.7 KB
2.2 02 6 Overview of Excel Solved.xlsx.xlsx	11.1 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 02 7 Basic Manipulations Exercise Text.xlsx.xlsx	11.7 KB
4.2 02 7 Basic Manipulations Solved.xlsx.xlsx	33.7 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 02 8 The Ribbon Solved.xlsx.xlsx	412.9 KB
6.2 02 8 The Ribbon Exercise & Text.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 02 9 Data Entry Exercise Text.xlsx.xlsx	11.2 KB
7.2 02 9 Data Entry Solved.xlsx.xlsx	33.5 KB
8. Introduction to formatting.mp4	25.9 MB
8. Introduction to formatting.vtt	6.3 KB
8.1 Formatting - Solved.xlsx.xlsx	10.1 KB
8.2 02 10 Formatting Solved.xlsx.xlsx	11.9 KB
8.3 02 10 Formatting Exercise Text.xlsx.xlsx	11.9 KB
8.4 Formatting - Unsolved.xlsx.xlsx	19.4 KB
9. Introduction to Excel formulas.mp4	6.1 MB
9. Introduction to Excel formulas.vtt	4.2 KB
9.1 Formulas – Unsolved.xlsx.xlsx	9.5 KB
9.2 Formulas - Solved.xlsx.xlsx	9.6 KB
9.3 02 11 Formulas Exercise Text.xlsx.xlsx	12.0 KB
9.4 02 11 Formulas Solved.xlsx.xlsx	82.1 KB
/3. Useful tips and tools for your work in Excel/
1. Excel best practices - Welcome lecture.mp4	2.2 MB
1. Excel best practices - Welcome lecture.vtt	1.0 KB
10. Learn how to use the Wrap Text button.mp4	930.2 KB
10. Learn how to use the Wrap Text button.vtt	0.9 KB
10.1 Useful Tips & Tools PDF Version.pdf	9.9 MB
10.2 03 22 Wrap Text Exercise & Text.xlsx.xlsx	10.4 KB
10.3 03 22 Wrap Text Solved.xlsx.xlsx	10.4 KB
10.4 Wrap text – Unsolved.xlsx.xlsx	9.8 KB
10.5 Wrap text - Solved.xlsx.xlsx	9.8 KB
11. Create easily printable documents in Excel by using Set Print Area.mp4	1.8 MB
11. Create easily printable documents in Excel by using Set Print Area.vtt	1.5 KB
11.1 Useful Tips & Tools PDF Version.pdf	9.9 MB
11.2 Set Print Area – Unsolved.xlsx.xlsx	11.7 KB
11.3 Set Print Area - Solved.xlsx.xlsx	11.5 KB
12. Find and select special types of cells with Select Special (F5).mp4	3.2 MB
12. Find and select special types of cells with Select Special (F5).vtt	1.9 KB
12.1 Useful Tips & Tools PDF Version.pdf	9.9 MB
12.2 03 24 Select Special (F5) Solved.xlsx.xlsx	22.8 KB
12.3 03 24 Select Special (F5) Exercise & Text.xlsx.xlsx	22.1 KB
12.4 Select Special.xlsx.xlsx	10.8 KB
13. Select Special.html	0.2 KB
14. Learn how to assign dynamic names within a financial model.mp4	2.4 MB
14. Learn how to assign dynamic names within a financial model.vtt	1.6 KB
14.1 03 25 Assigning Dynamic Names Exercise & Text.xlsx.xlsx	11.5 KB
14.2 Dynamic Naming – Unsolved.xlsx.xlsx	13.9 KB
14.3 Dynamic Naming - Solved.xlsx.xlsx	14.2 KB
14.4 Useful Tips & Tools PDF Version.pdf	9.9 MB
14.5 03 25 Assigning Dynamic Names Solved.xlsx.xlsx	12.0 KB
15. Assigning dynamic names.html	0.2 KB
16. Define a named range in Excel.mp4	2.2 MB
16. Define a named range in Excel.vtt	1.7 KB
16.1 Naming ranges - Solved.xlsx.xlsx	10.6 KB
16.2 Naming ranges – Unsolved.xlsx.xlsx	9.0 KB
16.3 Useful Tips & Tools PDF Version.pdf	9.9 MB
16.4 03 26 Defining a Named Range Solved.xlsx.xlsx	11.9 KB
16.5 03 26 Defining a Named Range Exercise & Text.xlsx.xlsx	11.3 KB
17. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4	2.2 MB
17. Assign custom formats to specific cells within a financial model (e.g Multiples).vtt	1.9 KB
17.1 Useful Tips & Tools PDF Version.pdf	9.9 MB
17.2 03 27 Assigning Custom Formats Solved.xlsx.xlsx	11.3 KB
17.3 03 27 Assigning Custom Formats Exercise & Text.xlsx.xlsx	11.6 KB
18. Macros are a great timesaver! Here's why!.mp4	4.5 MB
18. Macros are a great timesaver! Here's why!.vtt	3.4 KB
18.1 03 28 Macros Solved.xlsx.xlsx	148.5 KB
18.2 03 28 Macros Exercise & Text.xlsx.xlsx	10.6 KB
18.3 Creating a Macro - Unsolved.xlsx.xlsx	9.9 KB
18.4 Creating a Macro - Solved.xlsx.xlsx	11.4 KB
18.5 Useful Tips & Tools PDF Version.pdf	9.9 MB
19. Excel Macros - quiz.html	0.2 KB
2. Initial formatting of an Excel sheet to render it professional.mp4	3.5 MB
2. Initial formatting of an Excel sheet to render it professional.vtt	2.2 KB
2.1 Formatting a worksheet – Unsolved.xlsx.xlsx	9.2 KB
2.2 Useful Tips & Tools PDF Version.pdf	9.9 MB
2.3 03 17 Formatting a Worksheet Exercise & Text.xlsx.xlsx	10.9 KB
2.4 Formatting a worksheet - Solved.xlsx.xlsx	9.8 KB
2.5 03 17 Formatting a Worksheet Solved.xlsx.xlsx	11.0 KB
20. Create a drop-down list by using Data Validation.mp4	3.5 MB
20. Create a drop-down list by using Data Validation.vtt	2.2 KB
20.1 03 29 Drop-down List Exercise & Text.xlsx.xlsx	11.6 KB
20.2 03 29 Drop-down List Solved.xlsx.xlsx	78.9 KB
20.3 Data Validation - Solved.xlsx.xlsx	11.1 KB
20.4 Data Validation – Unsolved.xlsx.xlsx	11.1 KB
20.5 Useful Tips & Tools PDF Version.pdf	9.9 MB
21. Using Custom-sort in order to sort multiple columns within a table.mp4	2.9 MB
21. Using Custom-sort in order to sort multiple columns within a table.vtt	1.6 KB
21.1 03 30 Custom Sort Solved.xlsx.xlsx	11.7 KB
21.2 Sort data - Solved.xlsx.xlsx	149.1 KB
21.3 03 30 Custom Sort Exercise & Text.xlsx.xlsx	11.6 KB
21.4 Useful Tips & Tools PDF Version.pdf	9.9 MB
21.5 Sort data – Unsolved.xlsx.xlsx	148.8 KB
22. Create a great Index page at the beginning of your models - Hyperlinks.mp4	2.0 MB
22. Create a great Index page at the beginning of your models - Hyperlinks.vtt	1.5 KB
22.1 Useful Tips & Tools PDF Version.pdf	9.9 MB
22.2 Useful Tips And Tools Excel File.xlsx	2.4 MB
22.3 03 31 Hyperlinks Exercise & Text.xlsx.xlsx	140.2 KB
22.4 03 31 Hyperlinks Solved.xlsx.xlsx	140.4 KB
23. Fix the top row of your table with Freeze Panes.mp4	5.4 MB
23. Fix the top row of your table with Freeze Panes.vtt	1.5 KB
23.1 Freeze Panes - Solved.xlsx.xlsx	659.4 KB
23.2 Freeze Panes – Unsolved.xlsx.xlsx	659.3 KB
23.3 Useful Tips & Tools PDF Version.pdf	9.9 MB
24. Filter by color - an excellent tool.mp4	10.4 MB
24. Filter by color - an excellent tool.vtt	2.1 KB
24.1 Exercise_Filter by Color.xlsx.xlsx	21.0 KB
24.2 Solution_Filter by Color.xlsx.xlsx	157.2 KB
25. Working with conditional formatting.mp4	15.8 MB
25. Working with conditional formatting.vtt	5.7 KB
25.1 Exercise_Conditional Formatting.xlsx.xlsx	13.2 KB
25.2 Solution_Conditional Formatting.xlsx.xlsx	52.8 KB
26. Useful tips and tools for your work in Excel - quiz.html	0.2 KB
3. Fast scrolling through Excel sheets.mp4	6.6 MB
3. Fast scrolling through Excel sheets.vtt	1.8 KB
3.1 2. Fast Scrolling - Solved.xlsx.xlsx	657.9 KB
3.2 Useful tips and tools - Excel file.xlsx.xlsx	2.3 MB
3.3 03 18 Fast Scrolling Exercise & Text.xlsx.xlsx	45.0 KB
3.4 Useful Tips & Tools PDF Version.pdf	9.9 MB
3.5 03 18 Fast Scrolling Solved.xlsx.xlsx	45.4 KB
4. Fast scrolling through Excel sheets.html	0.2 KB
5. Introduction to fixing of cell references.mp4	6.4 MB
5. Introduction to fixing of cell references.vtt	2.6 KB
5.1 Useful Tips & Tools PDF Version.pdf	9.9 MB
5.2 Fixing references - Solved.xlsx.xlsx	660.7 KB
5.3 Fixing references – Unsolved.xlsx.xlsx	659.4 KB
5.4 03 19 Fixing Cells Solved.xlsx.xlsx	11.1 KB
5.5 03 19 Fixing Cells Exercise & Text.xlsx.xlsx	10.9 KB
6. Introduction to fixing of cell references.html	0.2 KB
7. Using the 'Alt + Enter' combination.mp4	1.5 MB
7. Using the 'Alt + Enter' combination.vtt	1.0 KB
7.1 Alt + Enter – Unsolved.xlsx.xlsx	9.9 KB
7.2 Useful Tips & Tools PDF Version.pdf	9.9 MB
7.3 Alt + Enter - Solved.xlsx.xlsx	9.9 KB
7.4 03 20 Alt+Enter Exercise & Text.xlsx.xlsx	11.4 KB
7.5 03 20 Alt+Enter Solved.xlsx.xlsx	11.7 KB
8. Learn how to organize your data with Text to Columns.mp4	4.1 MB
8. Learn how to organize your data with Text to Columns.vtt	2.3 KB
8.1 Useful Tips & Tools PDF Version.pdf	9.9 MB
8.2 Text to columns – Unsolved.xlsx.xlsx	10.0 KB
8.3 03 21 Text to Columns Exercise & Text.xlsx.xlsx	10.8 KB
8.4 03 21 Text to Columns Solved.xlsx.xlsx	11.6 KB
8.5 Text to columns - Solved.xlsx.xlsx	10.1 KB
9. Learn how to organize your data with Text to Columns.html	0.2 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. Excel's key functions and functionalities made easy/
1. Excel's key functions - Welcome lecture.mp4	2.4 MB
1. Excel's key functions - Welcome lecture.vtt	1.1 KB
10. Include Round in your financial models.mp4	1.3 MB
10. Include Round in your financial models.vtt	1.2 KB
10.1 Excel Functions.xlsx	994.3 KB
10.2 Key Functions In Excel.pdf	10.3 MB
10.3 05 42 Round Exercise & Text.xlsx.xlsx	11.6 KB
10.4 05 42 Round Solved.xlsx.xlsx	12.0 KB
11. Learn how to transfer data efficiently in Excel Vlookup and Hlookup.mp4	12.7 MB
11. Learn how to transfer data efficiently in Excel Vlookup and Hlookup.vtt	8.7 KB
11.1 Key Functions In Excel.pdf	10.3 MB
11.2 05 43 Vlookup, Hlookup Solved.xlsx.xlsx	14.5 KB
11.3 05 43 Vlookup, Hlookup Exercise & Text.xlsx.xlsx	12.2 KB
11.4 Vlookup, Hlookup - Unsolved.xlsx.xlsx	11.0 KB
11.5 Vlookup, Hlookup – Solved.xlsx.xlsx	11.4 KB
12. Index, Match and their combination - the perfect substitute for Vlookup.mp4	13.4 MB
12. Index, Match and their combination - the perfect substitute for Vlookup.vtt	8.4 KB
12.1 Solution_Index; Match; Index and Match.xlsx.xlsx	17.4 KB
12.2 Index & Match - Unsolved.xlsx.xlsx	11.6 KB
12.3 Index & Match – Solved.xlsx.xlsx	12.0 KB
12.4 05 44 Index, Match Solved.xlsx.xlsx	12.4 KB
12.5 Key Functions In Excel.pdf	10.3 MB
12.6 Exercise-Index-Match-Index-and-Match (1).xlsx.xlsx	15.8 KB
12.7 05 44 Index, Match Exercise & Text.xlsx.xlsx	11.9 KB
13. A great Excel technique Index, Match, Match.mp4	12.3 MB
13. A great Excel technique Index, Match, Match.vtt	5.4 KB
13.1 Exercise_Index, Match, Match.xlsx.xlsx	11.9 KB
13.2 Solution_Index, Match, Match.xlsx.xlsx	12.5 KB
14. Index, Match and their combination - the perfect substitute for Vlookup.html	0.2 KB
15. Using Excel's Iferror function to trap spreadsheet errors.mp4	2.7 MB
15. Using Excel's Iferror function to trap spreadsheet errors.vtt	2.1 KB
15.1 Iferror.xlsx.xlsx	9.8 KB
15.2 05 45 IFERROR Solved.xlsx.xlsx	15.7 KB
15.3 05 45 IFERROR Exercise & Text.xlsx.xlsx	14.6 KB
15.4 Key Functions In Excel.pdf	10.3 MB
15.5 Iferror – Unsolved.xlsx.xlsx	9.6 KB
16. Learn how to render your models flexible with Choose.mp4	3.6 MB
16. Learn how to render your models flexible with Choose.vtt	2.7 KB
16.1 Key Functions In Excel.pdf	10.3 MB
16.2 Choose – Unsolved.xlsx.xlsx	9.6 KB
16.3 05 46 Choose Solved.xlsx.xlsx	12.0 KB
16.4 Choose - Solved.xlsx.xlsx	9.9 KB
16.5 05 46 Choose Exercise & Text.xlsx.xlsx	11.6 KB
17. Use Goal Seek to find the result that you are looking for.mp4	3.2 MB
17. Use Goal Seek to find the result that you are looking for.vtt	2.6 KB
17.1 Goal Seek – Unsolved.xlsx.xlsx	9.1 KB
17.2 Key Functions In Excel.pdf	10.3 MB
17.3 Goal Seek - Solved.xlsx.xlsx	9.1 KB
17.4 05 47 Goal Seek Exercise & Text.xlsx.xlsx	16.5 KB
17.5 05 47 Goal Seek Solved.xlsx.xlsx	16.6 KB
18. Use Goal Seek in order to find the result that you are looking for.html	0.2 KB
19. Include sensitivity analysis in your models through Data Tables.mp4	5.7 MB
19. Include sensitivity analysis in your models through Data Tables.vtt	4.8 KB
19.1 Data Tables – Unsolved.xlsx.xlsx	9.5 KB
19.2 Key Functions In Excel.pdf	10.3 MB
19.3 05 48 Sensitivity Analysis Solved.xlsx.xlsx	13.4 KB
19.4 Data Tables - Solved.xlsx.xlsx	9.7 KB
19.5 05 48 Sensitivity Analysis Exercise & Text.xlsx.xlsx	12.9 KB
2. Key functions in Excel If.html	0.2 KB
20. Include sensitivity analysis in your models through Data Tables.html	0.2 KB
21. Excel's dynamic and interactive tables Pivot tables.mp4	5.6 MB
21. Excel's dynamic and interactive tables Pivot tables.vtt	2.6 KB
21.1 Key Functions In Excel.pdf	10.3 MB
21.2 05 49 Pivot Tables Intro Exercise & Text.xlsx.xlsx	155.8 KB
21.3 Excel Functions.xlsx	994.3 KB
21.4 05 49 Pivot Tables Intro Solved.xlsx.xlsx	194.6 KB
21.5 Excel functions.xlsx.xlsx	908.6 KB
22. Excel's key functions and functionalities made easy.html	0.2 KB
3. Key Excel functions Sum, Sumif and Sumifs.mp4	7.1 MB
3. Key Excel functions Sum, Sumif and Sumifs.vtt	5.0 KB
3.1 Sum, Sumif, Sumifs - Unsolved.xlsx.xlsx	13.2 KB
3.2 Key Functions In Excel.pdf	10.3 MB
3.3 05 37 Sum, Sumif, Sumifs Exercise & Text.xlsx.xlsx	14.8 KB
3.4 Sum, Sumif, Sumifs – Solved.xlsx.xlsx	13.3 KB
3.5 05 37 Sum, Sumif, Sumifs Solved.xlsx.xlsx	15.2 KB
4. Key Excel functions Count, Counta, Countif, Countifs.mp4	6.3 MB
4. Key Excel functions Count, Counta, Countif, Countifs.vtt	4.6 KB
4.1 05-38-Counts-Solved.xlsx.xlsx	16.5 KB
4.2 Count, Countif, Countifs – Unsolved.xlsx.xlsx	11.6 KB
4.3 05 38 Counts Exercise & Text.xlsx.xlsx	15.6 KB
4.4 Count, Countif, Countifs - Solved.xlsx.xlsx	12.0 KB
4.5 Key Functions In Excel.pdf	10.3 MB
5. Key Excel functions Average and Averageif.mp4	2.9 MB
5. Key Excel functions Average and Averageif.vtt	2.3 KB
5.1 Average, Averageif - Solved.xlsx.xlsx	9.6 KB
5.2 05 39 Average, AverageIF Exercise & Text.xlsx.xlsx	15.0 KB
5.3 Average, Averageif – Unsolved.xlsx.xlsx	9.2 KB
5.4 05 39 Average, AverageIF Solution.xlsx.xlsx	15.4 KB
6. Key Excel functions Average and Averageif.html	0.2 KB
7. Elaborate text efficiently Left, Right, Mid, Upper, Lower,Proper, Concatenate.mp4	6.6 MB
7. Elaborate text efficiently Left, Right, Mid, Upper, Lower,Proper, Concatenate.vtt	5.4 KB
7.1 Key Functions In Excel.pdf	10.3 MB
7.2 Text Functions - Solved.xlsx.xlsx	11.4 KB
7.3 Text Functions - Unsolved.xlsx.xlsx	10.9 KB
7.4 05 40 2 Left, Right etc Exercise & Text.xlsx.xlsx	12.0 KB
7.5 05 40 2 Left, Right etc Solved.xlsx.xlsx	12.5 KB
8. Elaborate text efficiently Left, Right, Mid, Upper, Lower,Proper, Concatenate.html	0.2 KB
9. Find the minimum or maximum value in a range of cells in Excel.mp4	2.0 MB
9. Find the minimum or maximum value in a range of cells in Excel.vtt	1.1 KB
9.1 Max, min – Solved.xlsx.xlsx	9.4 KB
9.2 05 41 MIN MAX Exercise & Text.xlsx.xlsx	14.7 KB
9.3 05 41 MIN MAX Solved.xlsx.xlsx	15.2 KB
9.4 Max, min - Unsolved.xlsx.xlsx	9.2 KB
/6. Update! 15 December - Exercise/
1. Exercise - Excel's Sumifs function - unsolved.html	0.2 KB
2. Exercise - Excel's Sumifs function - solved & explained.mp4	13.3 MB
2. Exercise - Excel's Sumifs function - solved & explained.vtt	10.3 KB
2.1 Exercise Sumifs With Solutions.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.3 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.3 KB
2.1 Solution-IRR.xlsx.xlsx	12.6 KB
2.2 05 14 IRR.xlsx.xlsx	11.5 KB
2.3 Exercise-IRR.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 Solution-Loan-Schedule.xlsx.xlsx	23.2 KB
3.2 05 15 PMT.xlsx.xlsx	20.7 KB
3.3 Exercise-Loan-Schedule.xlsx.xlsx	16.2 KB
4. Date functions in Excel.mp4	11.9 MB
4. Date functions in Excel.vtt	5.4 KB
4.1 Exercise-Date-Functions.xlsx.xlsx	11.7 KB
4.2 Solution-Date-Functions (2).xlsx.xlsx	12.7 KB
4.3 Exercise-Date-Functions.xlsx.xlsx	11.7 KB
4.4 05 16 Date Functions.xlsx.xlsx	12.5 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 2. Creating a Pivot Table.xlsx.xlsx	1.5 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 3. Formatting a Pivot Table.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.5 KB
4.1 4. Working with Pivot Tables.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 5. GetPivotData.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 6. Slicers.xlsx.xlsx	2.0 MB
6.2 Database - Pivot & Slicers.xlsm.xlsm	871.7 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	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	13.3 MB
10. Use Index & Match as a substitute for Vlookup.vtt	4.3 KB
10.1 9. Index & Match - Unsolved.xlsx.xlsx	39.4 KB
10.2 9. Index & Match - Solved.xlsx.xlsx	43.9 KB
11. Mapping the rows in the Database sheet.mp4	9.9 MB
11. Mapping the rows in the Database sheet.vtt	2.7 KB
11.1 10. Mapping - Solved.xlsx.xlsx	48.6 KB
11.2 10. Mapping - Unsolved.xlsx.xlsx	40.0 KB
12. Building the structure of the P&L sheet.mp4	4.1 MB
12. Building the structure of the P&L sheet.vtt	2.5 KB
12.1 11 Building A P&L.xlsx	55.1 KB
12.2 11. Building a P&L - Solved.xlsx.xlsx	55.1 KB
13. Formatting sets You apart from the competition in Excel - A Practical Example.mp4	6.0 MB
13. Formatting sets You apart from the competition in Excel - A Practical Example.vtt	3.4 KB
13.1 12. Formatting the P&L sheet - Solved.xlsx.xlsx	54.8 KB
13.2 12. Formatting the P&L - Unsolved.xlsx.xlsx	50.5 KB
14. Populate the P&L sheet with Sumif.mp4	6.7 MB
14. Populate the P&L sheet with Sumif.vtt	3.1 KB
14.1 13. Populating the P&L sheet - Solved.xlsm.xlsm	60.4 KB
14.2 13. Populating the P&L sheet - Unsolved.xlsx.xlsx	50.4 KB
15. Learn how to find mistakes with Countif.mp4	7.8 MB
15. Learn how to find mistakes with Countif.vtt	2.7 KB
15.1 14. Countif - Solved.xlsx.xlsx	58.7 KB
15.2 14. Countif - Unsolved.xlsm.xlsm	55.3 KB
16. Calculating year-on-year percentage variations the proper way.mp4	7.2 MB
16. Calculating year-on-year percentage variations the proper way.vtt	3.3 KB
16.1 15. Adding % variations - Unsolved.xlsx.xlsx	52.4 KB
16.2 15. Adding % variations - Solved.xlsx.xlsx	57.9 KB
17. Create professional and good-looking charts - Introduction.mp4	1.3 MB
17. Create professional and good-looking charts - Introduction.vtt	0.5 KB
18. Build a Column Stacked chart with a secondary line axis in Excel.mp4	11.9 MB
18. Build a Column Stacked chart with a secondary line axis in Excel.vtt	6.9 KB
18.1 Column Stacked Chart - Solved.xlsm.xlsm	12.1 MB
18.2 Case Study Building A P&L From Scratch Complete.xlsx	12.8 MB
18.3 Column Stacked Chart - Unsolved.xlsm.xlsm	12.1 MB
19. Learn how to build effective Doughnut charts in Excel.mp4	7.8 MB
19. Learn how to build effective Doughnut charts in Excel.vtt	4.9 KB
19.1 Doughnut Chart - Unsolved.xlsm.xlsm	12.1 MB
19.2 Doughnut Chart - Solved.xlsm.xlsm	12.1 MB
2. Introduction to the case study.mp4	2.5 MB
2. Introduction to the case study.vtt	1.0 KB
20. Learn how to build an Area chart in Excel.mp4	8.4 MB
20. Learn how to build an Area chart in Excel.vtt	4.8 KB
20.1 Area Chart - Solved.xlsm.xlsm	12.1 MB
20.2 Area Chart - Unsolved.xlsm.xlsm	12.1 MB
21. Learn how to create Bridge charts.mp4	19.7 MB
21. Learn how to create Bridge charts.vtt	12.7 KB
21.1 Bridge Chart - Solved.xlsm.xlsm	12.1 MB
21.2 Case Study Building A P&L From Scratch Complete.xlsx	12.8 MB
21.3 Bridge Chart – Unsolved.xlsm.xlsm	12.1 MB
22. Case Study - Building a Complete P&L from scratch in Excel.html	0.2 KB
23. Course Challenge - Apply your skills in practice!.mp4	8.3 MB
23. Course Challenge - Apply your skills in practice!.vtt	1.2 KB
23.1 1. SOULUTIONS - Course Challenge.xlsx.xlsx	557.0 KB
23.2 1. Course Challenge.xlsx.xlsx	517.6 KB
3. Understand your data source before you start working on it.mp4	7.1 MB
3. Understand your data source before you start working on it.vtt	3.0 KB
4. Order the source worksheets.mp4	6.0 MB
4. Order the source worksheets.vtt	2.4 KB
4.1 4. Order a worksheet - Unsolved.xlsx.xlsx	29.3 KB
4.2 4. Order a worksheet - Solved.xlsm.xlsm	37.5 KB
5. Create a code the best way to organize your data and work efficiently with it.mp4	6.3 MB
5. Create a code the best way to organize your data and work efficiently with it.vtt	2.2 KB
5.1 5. Creating a code - Unsolved.xlsm.xlsm	33.5 KB
5.2 5. Creating a code - Solved.xlsx.xlsx	34.7 KB
6. Learn how to create a database.mp4	5.7 MB
6. Learn how to create a database.vtt	2.3 KB
6.1 6. Creating a database - Solved.xlsx.xlsx	36.3 KB
6.2 6. Creating a database - Unsolved.xlsx.xlsx	31.4 KB
7. Use Vlookup to fill the Database sheet.mp4	15.4 MB
7. Use Vlookup to fill the Database sheet.vtt	5.7 KB
7.1 7. Vlookup - Solved.xlsx.xlsx	42.3 KB
7.2 7 Vlookup.xlsx	41.7 KB
7.3 7. Vlookup - Unsolved.xlsx.xlsx	33.3 KB
8. 50% Completed!.mp4	4.5 MB
8. 50% Completed!.vtt	0.1 KB
9. Use SUMIF to complete the Database sheet.mp4	13.9 MB
9. Use SUMIF to complete the Database sheet.vtt	4.6 KB
9.1 8. Sumif - Solved.xlsx.xlsx	48.4 KB
9.2 8. Sumif - Unsolved.xlsx.xlsx	38.3 KB
/
[CourseClub.NET].url	0.1 KB
[FCS Forum].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
Total files 776