DesireCourse Net Udemy Beginner to Pro in Excel Financial Modeling and Valuation

DesireCourse Net Udemy Beginner to Pro in Excel Financial Modeling and Valuation

Name	[DesireCourse.Net] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	6.1 GB
Total Files	1053
Last Seen	2025-07-24 23:46
Hash	6EFA437E6486BF66436578D3083E9748DFAA1A40

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