Download Udemy - Beginner to Pro in Excel: Financial Modeling and Valuation [FreeAllCourse] Torrent

Torrent Contents Size: 6.03 GB

Udemy - Beginner to Pro in Excel: Financial Modeling and Valuation [FreeAllCourse]

▼ show more 1026 files

0. Websites you may like

[FreeAllCourse.Com].url

URL

52 B

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

1. What does the course cover.mp4	MP4	32.78 MB
1. What does the course cover.srt	SRT	4.95 KB
1.1 Course Notes - Beginner to Pro in Excel.pdf	PDF	19.03 MB
2. Bonus! Welcome gift.html	HTML	171 B
3. Welcome gift number 2.html	HTML	171 B
4. The best way to take this course.mp4	MP4	17.62 MB
4. The best way to take this course.srt	SRT	2.52 KB
5. Download all course materials and frequently asked questions (FAQ).html	HTML	5.37 KB

10. Introduction to Excel charts

1. How to insert a chart in Excel.mp4	MP4	22.28 MB
1. How to insert a chart in Excel.srt	SRT	2.67 KB
1.1 95. Inserting-Charts-Lecture.xlsm	XLSM	11.45 MB
2. Editing Excel charts.mp4	MP4	26.06 MB
2. Editing Excel charts.srt	SRT	2.89 KB
2.1 96. Formatting-a-Chart-Lecture.xlsm	XLSM	11.45 MB
3. Excel chart formatting.mp4	MP4	32.75 MB
3. Excel chart formatting.srt	SRT	3.47 KB
3.1 97. Modifying-a-Chart-Lecture.xlsm	XLSM	11.41 MB
4. How to create a bridge chart in Excel.mp4	MP4	13.66 MB
4. How to create a bridge chart in Excel.srt	SRT	1.89 KB
4.1 98. Bridge-Charts-Lecture.xlsx	XLSX	13.1 KB
5. New ways to visualize your data - Treemap charts.mp4	MP4	11.5 MB
5. New ways to visualize your data - Treemap charts.srt	SRT	1.72 KB
5.1 99. Treemap-Charts-Lecture.xlsx	XLSX	12.62 KB
6. Sparklines.mp4	MP4	27.56 MB
6. Sparklines.srt	SRT	4.25 KB
6.1 100. Sparklines-Lecture.xlsx	XLSX	9.59 KB

11. P&L Case Study continued - Let's create some great-looking professional charts

1. Create professional and good-looking charts - Introduction.mp4	MP4	6.21 MB
1. Create professional and good-looking charts - Introduction.srt	SRT	662 B
2. Build a column stacked chart with a secondary line axis in Excel.mp4	MP4	46.38 MB
2. Build a column stacked chart with a secondary line axis in Excel.srt	SRT	5.7 KB
2.1 102. Column stacked chart-Lecture-after.xlsm	XLSM	11.51 MB
2.2 102. Column stacked chart-Lecture-before.xlsm	XLSM	11.51 MB
3. Learn how to build effective doughnut charts in Excel.mp4	MP4	38 MB
3. Learn how to build effective doughnut charts in Excel.srt	SRT	5.44 KB
3.1 103. Doughnut chart-Lecture-after.xlsm	XLSM	11.51 MB
3.2 103. Doughnut chart-Lecture-before.xlsm	XLSM	11.52 MB
4. Learn how to build an area chart in Excel.mp4	MP4	28.59 MB
4. Learn how to build an area chart in Excel.srt	SRT	3.56 KB
4.1 104. Area chart-Lecture-after.xlsm	XLSM	11.53 MB
4.2 104. Area chart-Lecture-before.xlsm	XLSM	11.51 MB
5. Learn how to create bridge charts.mp4	MP4	52.07 MB
5. Learn how to create bridge charts.srt	SRT	7.61 KB
5.1 105. Bridge chart-Lecture-before.xlsm	XLSM	11.52 MB
5.2 105. Bridge chart-Lecture-after.xlsm	XLSM	11.54 MB
6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4	MP4	136.12 MB
6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.srt	SRT	12.69 KB
6.1 20. Bridge chart_after.xlsm	XLSM	11.53 MB
6.2 20. Bridge chart_before.xlsm	XLSM	11.53 MB
7. Case Study - Building a Complete P&L from scratch in Excel.html	HTML	166 B
8. Course Challenge - Apply your skills in practice!.mp4	MP4	7.92 MB
8. Course Challenge - Apply your skills in practice!.srt	SRT	1.29 KB
8.1 107. Course-Challenge - Unsolved.xlsx	XLSX	505.49 KB
8.2 107. Course-Challenge - Solved.xlsx	XLSX	543.93 KB

12. Case Study - Building an FMCG Model from Scratch

1. Introduction to the Case Study.mp4	MP4	24.07 MB
1. Introduction to the Case Study.srt	SRT	2.58 KB
1.1 108. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx	XLSX	13.26 MB
10. FAQ My GETPIVOTDATA function doesn't work.html	HTML	651 B
11. Combining Slicers and GETPIVOTDATA The key to our success.mp4	MP4	33.62 MB
11. Combining Slicers and GETPIVOTDATA The key to our success.srt	SRT	3.62 KB
11.1 7. Exercise - Build an FMCG Model_Inserting Slicers_before.xlsx	XLSX	20.82 MB
11.2 7. Exercise - Build an FMCG Model_Inserting Slicers_after.xlsx	XLSX	20.78 MB
12. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4	MP4	32.42 MB
12. Getting fancy with Excel slicers - Good-looking Excel slicers.srt	SRT	3.61 KB
12.1 8. Exercise - Build an FMCG Model_Formatting Slicers_after.xlsx	XLSX	18.25 MB
12.2 8. Exercise - Build an FMCG Model_Formatting Slicers_before.xlsx	XLSX	20.77 MB
13. This is how the report can be used in practice by high-level executives.mp4	MP4	36.15 MB
13. This is how the report can be used in practice by high-level executives.srt	SRT	4.66 KB
13.1 9. Exercise - Build an FMCG Model_Complete_after.xlsx	XLSX	22.82 MB
13.2 9. Exercise - Build an FMCG Model_Complete_before.xlsx	XLSX	18.26 MB
14. Dynamic reporting with GETPIVOTDATA and slicers.html	HTML	170 B
2. Preliminary mapping of the data extraction.mp4	MP4	30.45 MB
2. Preliminary mapping of the data extraction.srt	SRT	2.56 KB
2.1 1. Exercise - Build an FMCG Model_Mapping_before.xlsx	XLSX	13.26 MB
2.2 1. Exercise - Build an FMCG Model_Mapping_after.xlsx	XLSX	14.89 MB
3. Working with an SAP data extraction.mp4	MP4	37.13 MB
3. Working with an SAP data extraction.srt	SRT	4.08 KB
4. Creating an output structure of the FMCG model.mp4	MP4	19.7 MB
4. Creating an output structure of the FMCG model.srt	SRT	2.98 KB
4.1 2. Exercise - Build an FMCG Model_Layout_before.xlsx	XLSX	14.9 MB
4.2 2. Exercise - Build an FMCG Model_Layout_after.xlsx	XLSX	14.92 MB
5. Improving the layout and appearance of the FMCG report.mp4	MP4	25.36 MB
5. Improving the layout and appearance of the FMCG report.srt	SRT	4.94 KB
5.1 3. Exercise - Build an FMCG Model_Formatting_before.xlsx	XLSX	14.92 MB
5.2 3. Exercise - Build an FMCG Model_Formatting_after.xlsx	XLSX	14.92 MB
6. Inserting formulas and automating calculations.mp4	MP4	16.15 MB
6. Inserting formulas and automating calculations.srt	SRT	4.94 KB
6.1 4. Exercise - Build an FMCG Model_Adding Calculations_after.xlsx	XLSX	14.92 MB
6.2 4. Exercise - Build an FMCG Model_Adding Calculations_before.xlsx	XLSX	14.91 MB
7. Creating a Master Pivot Table The main data source for the FMCG report.mp4	MP4	20.14 MB
7. Creating a Master Pivot Table The main data source for the FMCG report.srt	SRT	2.21 KB
7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table_after.xlsx	XLSX	20.81 MB
7.2 5. Exercise - Build an FMCG Model_Creating a Pivot Table_before.xlsx	XLSX	14.92 MB
8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4	MP4	49.98 MB
8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.srt	SRT	7.14 KB
8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA_before.xlsx	XLSX	20.81 MB
8.2 6a. Exercise - Build an FMCG Model_Copying Get Pivot_after.xlsx	XLSX	20.82 MB
9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4	MP4	13.76 MB
9. A potential error with GETPIVOTDATA you might encounter and its fix.srt	SRT	1.5 KB

13. Financial modeling fundamentals

1. Financial modeling basics - Welcome lecture.mp4	MP4	2.09 MB
1. Financial modeling basics - Welcome lecture.srt	SRT	1.1 KB
10. Forecasting financials - Quiz.html	HTML	167 B
11. Building a complete model - Important considerations.mp4	MP4	8.45 MB
11. Building a complete model - Important considerations.srt	SRT	2.9 KB
12. Modeling the Income statement.mp4	MP4	13.33 MB
12. Modeling the Income statement.srt	SRT	7.46 KB
13. Modeling the Balance sheet - Part 1.mp4	MP4	6.15 MB
13. Modeling the Balance sheet - Part 1.srt	SRT	3.41 KB
14. Modeling the Balance sheet - Part 2.mp4	MP4	10.6 MB
14. Modeling the Balance sheet - Part 2.srt	SRT	6.09 KB
15. Building a financial model - Quiz.html	HTML	167 B
2. What is a financial model.mp4	MP4	5.48 MB
2. What is a financial model.srt	SRT	2.46 KB
3. Why use financial models.mp4	MP4	10.04 MB
3. Why use financial models.srt	SRT	3.31 KB
4. Financial modeling - worst practices - things you should avoid.mp4	MP4	19.92 MB
4. Financial modeling - worst practices - things you should avoid.srt	SRT	7.33 KB
5. Financial modeling - best practices.mp4	MP4	17.22 MB
5. Financial modeling - best practices.srt	SRT	6.04 KB
6. Financial modeling - The types of models that are built in practice.mp4	MP4	14.26 MB
6. Financial modeling - The types of models that are built in practice.srt	SRT	5.84 KB
7. Financial modeling - Quiz.html	HTML	167 B
8. Financial modeling The right level of detail in a model.mp4	MP4	7.29 MB
8. Financial modeling The right level of detail in a model.srt	SRT	3.1 KB
9. Financial modeling Forecasting guidelines.mp4	MP4	7.12 MB
9. Financial modeling Forecasting guidelines.srt	SRT	3.54 KB

14. Introduction to Company Valuation

1. The core theory behind Company Valuation.html

HTML

171 B

15. Introduction to Mergers & Acquisitions

1. Introduction to Mergers & Acquisitions.html

HTML

171 B

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

1. Valuation Case study - Welcome lecture.mp4	MP4	1.78 MB
1. Valuation Case study - Welcome lecture.srt	SRT	883 B
10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4	MP4	30.02 MB
10. Modeling other items Interest expenses, Extraordinary items and Taxes.srt	SRT	3.05 KB
10.1 9. Interest expenses, taxes_after.xlsm	XLSM	50.89 KB
10.2 9. Interest expenses, taxes_before.xlsm	XLSM	50.57 KB
11. Forecasting Balance sheet items.mp4	MP4	4.66 MB
11. Forecasting Balance sheet items.srt	SRT	870 B
11.1 10. Introduction to Balance sheet items.xlsm	XLSM	51.02 KB
12. An introduction to the Days methodology.mp4	MP4	10.08 MB
12. An introduction to the Days methodology.srt	SRT	1.85 KB
12.1 Working Capital Days.pptx	PPTX	94.77 KB
13. Calculation of DSO, DPO and DOI for the historical period.mp4	MP4	12.11 MB
13. Calculation of DSO, DPO and DOI for the historical period.srt	SRT	1.39 KB
13.1 12. Days calculation_before.xlsm	XLSM	51.2 KB
13.2 12. Days calculation_after.xlsm	XLSM	51.47 KB
14. Forecasting DSO, DPO and DOI.mp4	MP4	20.86 MB
14. Forecasting DSO, DPO and DOI.srt	SRT	2.54 KB
14.1 13. Forecasting DSO, DPO, DIO_after.xlsm	XLSM	51.98 KB
14.2 13. Forecasting DSO, DPO, DIO_before.xlsm	XLSM	51.47 KB
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4	MP4	22.63 MB
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.srt	SRT	2.82 KB
15.1 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm	XLSM	51.98 KB
15.2 14. Forecasting PP&E, Other assets, and Other liabilities_after.xlsm	XLSM	52.88 KB
16. Creating an output P&L sheet.mp4	MP4	18.81 MB
16. Creating an output P&L sheet.srt	SRT	2.39 KB
16.1 15. P&L structure_before.xlsm	XLSM	53.6 KB
16.2 15. P&L structure_after.xlsm	XLSM	53.67 KB
17. Populating the output P&L sheet.mp4	MP4	25.53 MB
17. Populating the output P&L sheet.srt	SRT	2.5 KB
17.1 16. Populating the P&L sheet_before.xlsm	XLSM	53.67 KB
17.2 16. Populating the P&L sheet_after.xlsm	XLSM	55.32 KB
18. Populating the output BS sheet.mp4	MP4	16.93 MB
18. Populating the output BS sheet.srt	SRT	1.78 KB
18.1 17. Populating BS sheet_after.xlsm	XLSM	57.18 KB
18.2 17. Populating BS sheet_before.xlsm	XLSM	55.32 KB
19. Completing the output BS sheet for the historical period.mp4	MP4	38.04 MB
19. Completing the output BS sheet for the historical period.srt	SRT	4.03 KB
19.1 18. Completing the Balance Sheet_before.xlsm	XLSM	57.18 KB
19.2 18. Completing the Balance Sheet_after.xlsm	XLSM	58.1 KB
2. Introduction to the DCF exercise.mp4	MP4	7.88 MB
2. Introduction to the DCF exercise.srt	SRT	1.31 KB
20. Creating a structure for the calculation of Unlevered free cash flows.mp4	MP4	22.76 MB
20. Creating a structure for the calculation of Unlevered free cash flows.srt	SRT	3.24 KB
20.1 19. Cash flow structure_before.xlsm	XLSM	58.48 KB
20.2 19. Cash flow structure_after.xlsm	XLSM	58.58 KB
21. Bridging Unlevered free cash flow to Net cash flow.mp4	MP4	14.57 MB
21. Bridging Unlevered free cash flow to Net cash flow.srt	SRT	2.04 KB
21.1 20. Bridge UFCF to Net cash flow_before.xlsm	XLSM	58.58 KB
21.2 20. Bridge UFCF to Net cash flow_after.xlsm	XLSM	58.7 KB
22. Calculating Unlevered free cash flow.mp4	MP4	59.73 MB
22. Calculating Unlevered free cash flow.srt	SRT	6.57 KB
22.1 21. Calculating UFCF_after.xlsm	XLSM	59.18 KB
22.2 21. Calculating UFCF_before.xlsm	XLSM	58.66 KB
23. Calculating Net cash flow.mp4	MP4	37.91 MB
23. Calculating Net cash flow.srt	SRT	4.28 KB
23.1 22. Calculating Net Cash Flow_before.xlsm	XLSM	59.18 KB
23.2 Cash Flow Classification By Activities.xlsx	XLSX	55.95 KB
23.3 22. Calculating Net Cash Flow_after.xlsm	XLSM	59.38 KB
24. Obtaining the rest of the cash flows through Find and Replace.mp4	MP4	46.74 MB
24. Obtaining the rest of the cash flows through Find and Replace.srt	SRT	4.35 KB
24.1 23. Find and replace_before.xlsm	XLSM	59.55 KB
24.2 23. Find and replace_after.xlsm	XLSM	62.5 KB
25. Introducing Weighted average cost of capital and Perpetuity growth.mp4	MP4	13.21 MB
25. Introducing Weighted average cost of capital and Perpetuity growth.srt	SRT	2.39 KB
25.1 24. Introducing WACC and g_before.xlsm	XLSM	62.49 KB
25.2 24. Introducing WACC and g_after.xlsm	XLSM	62.58 KB
26. Discounting Unlevered free cash flows to obtain their Present value.mp4	MP4	20.23 MB
26. Discounting Unlevered free cash flows to obtain their Present value.srt	SRT	3.17 KB
26.1 25. Calculating PV of Cash Flows_before.xlsm	XLSM	62.58 KB
26.2 25. Calculating PV of Cash Flows_after.xlsm	XLSM	62.71 KB
27. Calculating Continuing value and Enterprise value of the business.mp4	MP4	17.73 MB
27. Calculating Continuing value and Enterprise value of the business.srt	SRT	2.55 KB
27.1 26. Calculating CV and EV_before.xlsm	XLSM	62.71 KB
27.2 26. Calculating CV and EV_after.xlsm	XLSM	63.1 KB
28. Calculating Equity value.mp4	MP4	12.2 MB
28. Calculating Equity value.srt	SRT	12.22 MB
28.1 27. Calculating equity value_after.xlsm	XLSM	63.27 KB
28.2 27. Calculating equity value_before.xlsm	XLSM	63.1 KB
29. Sensitivity analysis for WACC and perpetuity growth.mp4	MP4	40.49 MB
29. Sensitivity analysis for WACC and perpetuity growth.srt	SRT	4.57 KB
29.1 Sensitivity Analysis.xlsx	XLSX	60.81 KB
29.2 28. Sensitivity analysis_after.xlsm	XLSM	64.83 KB
29.3 28. Sensitivity analysis_before.xlsm	XLSM	63.27 KB
3. The stages of a complete DCF Valuation.mp4	MP4	49.25 MB
3. The stages of a complete DCF Valuation.srt	SRT	7.33 KB
3.1 Valuation exercise.pdf	PDF	411.76 KB
30. A possible application of Goal seek.mp4	MP4	15.63 MB
30. A possible application of Goal seek.srt	SRT	1.98 KB
30.1 29. Goal seek_ater.xlsm	XLSM	64.84 KB
30.2 29. Goal seek_before.xlsm	XLSM	64.83 KB
31. Using charts to summarize the results of the DCF model.mp4	MP4	32.89 MB
31.1 30. Charts.xlsm	XLSM	101.22 KB
32. You made it!.mp4	MP4	11.26 MB
32. You made it!.srt	SRT	2.84 KB
4. Description of the structure of the DCF model.mp4	MP4	18.54 MB
4. Description of the structure of the DCF model.srt	SRT	3.33 KB
4.1 DCF Model structure.pdf	PDF	240.8 KB
4.2 3. Structure of the DCF model.xlsm	XLSM	47.9 KB
5. A glimpse at the company we are valuing - Cheeseco.mp4	MP4	15.68 MB
5. A glimpse at the company we are valuing - Cheeseco.srt	SRT	1.41 KB
5.1 Cheeseco.pptx	PPTX	80.09 KB
6. Modeling the top line.mp4	MP4	26.31 MB
6. Modeling the top line.srt	SRT	4 KB
6.1 5. Modeling revenues_before.xlsm	XLSM	47.85 KB
6.2 5. Modeling revenues_after.xlsm	XLSM	48.16 KB
7. Introducing scenarios to the model with Choose.mp4	MP4	17.83 MB
7. Introducing scenarios to the model with Choose.srt	SRT	2.63 KB
7.1 6. Choose_before.xlsm	XLSM	48.16 KB
7.2 6. Choose_after.xlsm	XLSM	48.36 KB
8. Modeling other items Other revenues and Cogs.mp4	MP4	44.56 MB
8. Modeling other items Other revenues and Cogs.srt	SRT	4.55 KB
8.1 7. Other revenues and Cogs_before.xlsm	XLSM	48.36 KB
8.2 7. Other revenues and Cogs_after.xlsm	XLSM	50.08 KB
9. Modeling other items Operating expenses and D&A.mp4	MP4	26.34 MB
9. Modeling other items Operating expenses and D&A.srt	SRT	2.77 KB
9.1 8. Opex and D&A_after.xlsm	XLSM	50.57 KB
9.2 8. Opex and D&A_before.xlsm	XLSM	50.08 KB

17. Tesla valuation - Complete practical exercise

1. Organizing external inputs in a 'Drivers' sheet.mp4	MP4	31.01 MB
1. Organizing external inputs in a 'Drivers' sheet.srt	SRT	4.37 KB
1.1 0a. Drivers_before.xlsx	XLSX	1.27 MB
1.2 Tesla 2017.pdf	PDF	2.5 MB
1.3 Tesla 2016.pdf	PDF	2.21 MB
1.4 Tesla Company Valuation - Detailed walkthrough.pdf	PDF	5.09 MB
1.5 Tesla 2015.pdf	PDF	1.29 MB
1.6 Tesla 2018 Q2.pdf	PDF	635.07 KB
1.7 0a. Drivers_after.xlsx	XLSX	1.27 MB
10. Forecasting 'energy' and 'services' revenue.mp4	MP4	25.29 MB
10. Forecasting 'energy' and 'services' revenue.srt	SRT	3.14 KB
10.1 6. Energy and Other revenue - After.xlsx	XLSX	1.34 MB
10.2 6. Energy and Other revenue - Before.xlsx	XLSX	1.34 MB
11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4	MP4	26.81 MB
11. Calculating 'energy' and 'services' gross profit and cost of sales.srt	SRT	2.53 KB
11.1 7. Energy and Other - Gross profit, cost of sales - Before.xlsx	XLSX	1.35 MB
11.2 7. Energy and Other - Gross profit, cost of sales - After.xlsx	XLSX	1.35 MB
12. Forecasting operating expenses.mp4	MP4	34.91 MB
12. Forecasting operating expenses.srt	SRT	5.41 KB
12.1 8. Opex - After.xlsx	XLSX	1.36 MB
12.2 8. Opex - Before.xlsx	XLSX	1.36 MB
13. Building a fixed asset roll forward estimating Capex.mp4	MP4	56.58 MB
13. Building a fixed asset roll forward estimating Capex.srt	SRT	6.43 KB
13.1 9. PP&E forecasting and comparables_after.xlsx	XLSX	1.37 MB
13.2 9. PP&E forecasting and comparables_before.xlsx	XLSX	1.37 MB
14. Building a fixed asset roll forward D&A schedule.mp4	MP4	54.21 MB
14. Building a fixed asset roll forward D&A schedule.srt	SRT	4.45 KB
14.1 10. PP&E schedule_after.xlsx	XLSX	1.37 MB
14.2 10. PP&E schedule_before.xlsx	XLSX	1.37 MB
15. Peer comparison D&A as a percentage of revenues.mp4	MP4	13.61 MB
15. Peer comparison D&A as a percentage of revenues.srt	SRT	1.62 KB
15.1 10a. PP&E comparison.xlsx	XLSX	1.37 MB
16. FAQ Why model D&A as a % of revenues or as a % of beginning PP&E.html	HTML	818 B
17. Calculating DSO, DIO, DPO.mp4	MP4	17.51 MB
17. Calculating DSO, DIO, DPO.srt	SRT	2.11 KB
17.1 11. Working capital forecasting_before.xlsx	XLSX	1.38 MB
17.2 11. Working capital forecasting_after.xlsx	XLSX	1.52 MB
18. Producing a clean P&L output sheet.mp4	MP4	8.44 MB
18. Producing a clean P&L output sheet.srt	SRT	1.62 KB
18.1 12. P&L.xlsx	XLSX	1.39 MB
19. Fill in the P&L output sheet.mp4	MP4	18.35 MB
19. Fill in the P&L output sheet.srt	SRT	1.83 KB
19.1 12a. P&L fill in_before.xlsx	XLSX	1.39 MB
19.2 12a. P&L fill in_after.xlsx	XLSX	1.39 MB
2. The input data we will work with.mp4	MP4	15.81 MB
2. The input data we will work with.srt	SRT	1.72 KB
2.1 0aa. Inputs_after.xlsx	XLSX	1.28 MB
2.2 0aa. Inputs_before.xlsx	XLSX	1.28 MB
20. Calculating investments in working capital.mp4	MP4	19.03 MB
20. Calculating investments in working capital.srt	SRT	2.16 KB
20.1 13. Calculating working capital_before.xlsx	XLSX	1.4 MB
20.2 13. Calculating working capital_after.xlsx	XLSX	1.4 MB
21. Forecasting Unlevered free cash flow.mp4	MP4	55.94 MB
21. Forecasting Unlevered free cash flow.srt	SRT	6.09 KB
21.1 14. Cash flow - UFCF_before.xlsx	XLSX	1.41 MB
21.2 14. Cash flow - UFCF_after.xlsx	XLSX	1.41 MB
22. Forecasting other assets.mp4	MP4	45.24 MB
22. Forecasting other assets.srt	SRT	4.62 KB
22.1 15. Balance Sheet forecasting assets_after.xlsx	XLSX	1.41 MB
22.2 15. Balance Sheet forecasting assets_before.xlsx	XLSX	1.41 MB
23. Forecasting other liabilities.mp4	MP4	21.96 MB
23. Forecasting other liabilities.srt	SRT	2.36 KB
23.1 16. Balance Sheet forecasting liabilities_before.xlsx	XLSX	1.41 MB
23.2 16. Balance Sheet forecasting liabilities_after.xlsx	XLSX	1.42 MB
24. Completing Unlevered free cash flow.mp4	MP4	40.89 MB
24. Completing Unlevered free cash flow.srt	SRT	3.71 KB
24.1 16a. Complete UFCF_before.xlsx	XLSX	1.42 MB
24.2 16a. Complete UFCF_after.xlsx	XLSX	1.42 MB
25. Modeling Tesla's financing needs in the forecast period.mp4	MP4	42.36 MB
25. Modeling Tesla's financing needs in the forecast period.srt	SRT	5.64 KB
25.1 17. Financing_before.xlsx	XLSX	1.43 MB
25.2 17. Financing_after.xlsx	XLSX	1.43 MB
26. Calculating Net income.mp4	MP4	14.81 MB
26. Calculating Net income.srt	SRT	1.39 KB
26.1 18. P&L complete_after.xlsx	XLSX	1.43 MB
26.2 18. P&L complete_before.xlsx	XLSX	1.43 MB
27. Bridging Unlevered free cash flow to Net cash flow.mp4	MP4	50.73 MB
27. Bridging Unlevered free cash flow to Net cash flow.srt	SRT	4.51 KB
27.1 19. Cash flow_complete_after.xlsx	XLSX	1.43 MB
27.2 19. Cash flow_complete_before.xlsx	XLSX	1.43 MB
28. Balancing the Balance sheet.mp4	MP4	13.27 MB
28. Balancing the Balance sheet.srt	SRT	1.18 KB
28.1 20. Complete the BS_before.xlsx	XLSX	1.43 MB
28.2 20. Complete the BS_after.xlsx	XLSX	1.43 MB
29. Estimating Weighted average cost of capital (WACC).mp4	MP4	44.27 MB
29. Estimating Weighted average cost of capital (WACC).srt	SRT	6.77 KB
29.1 21. WACC_before.xlsx	XLSX	1.43 MB
29.2 21. WACC_after.xlsx	XLSX	1.43 MB
3. Forecasting Tesla's expected deliveries.mp4	MP4	114.91 MB
3. Forecasting Tesla's expected deliveries.srt	SRT	15.38 KB
3.1 1. Deliveries_after.xlsx	XLSX	1.29 MB
3.2 1. Deliveries_before.xlsx	XLSX	1.29 MB
30. Performing discounted cash flow valuation (DCF).mp4	MP4	34.91 MB
30. Performing discounted cash flow valuation (DCF).srt	SRT	4.06 KB
30.1 22. DCF_after.xlsx	XLSX	1.44 MB
30.2 22. DCF_before.xlsx	XLSX	1.52 MB
31. Calculating enterprise value, equity value, and price per share.mp4	MP4	22.55 MB
31. Calculating enterprise value, equity value, and price per share.srt	SRT	2.15 KB
31.1 23. EV, Equity value, Price per share_after.xlsx	XLSX	1.44 MB
31.2 23. EV, Equity value, Price per share_before.xlsx	XLSX	1.44 MB
32. Final comments.mp4	MP4	44.89 MB
32. Final comments.srt	SRT	4.43 KB
4. Comparing delivery figures with the ones of industry peers.mp4	MP4	20.93 MB
4. Comparing delivery figures with the ones of industry peers.srt	SRT	3.1 KB
4.1 1a. Deliveries development.xlsx	XLSX	1.3 MB
5. Estimating an average selling price of Tesla vehicles.mp4	MP4	41.92 MB
5. Estimating an average selling price of Tesla vehicles.srt	SRT	5.17 KB
5.1 2. Average price_after.xlsx	XLSX	1.31 MB
5.2 2. Average price_before.xlsx	XLSX	1.31 MB
6. Calculating automotive revenue.mp4	MP4	46.57 MB
6. Calculating automotive revenue.srt	SRT	4.93 KB
6.1 3. Revenue calculation and scenarios - after.xlsx	XLSX	1.31 MB
6.2 3. Revenue calculation and scenarios - before.xlsx	XLSX	1.31 MB
7. Peer comparison Gross profit %.mp4	MP4	17.17 MB
7. Peer comparison Gross profit %.srt	SRT	2.72 KB
7.1 4. Gross profit automotive.xlsx	XLSX	1.32 MB
8. Calculating automotive gross profit.mp4	MP4	27.76 MB
8. Calculating automotive gross profit.srt	SRT	2.88 KB
8.1 4a. Gross profit automotive - after.xlsx	XLSX	1.32 MB
8.2 4a. Gross profit automotive - before.xlsx	XLSX	1.51 MB
9. Calculating automotive cost of sales.mp4	MP4	17.5 MB
9. Calculating automotive cost of sales.srt	SRT	17.52 MB
9.1 5. Cost of sales and chart.xlsx	XLSX	1.34 MB

18. Capital budgeting - The theory

1. Introduction to Capital budgeting.mp4	MP4	5.43 MB
1. Introduction to Capital budgeting.srt	SRT	1.89 KB
2. Why we need Capital budgeting.mp4	MP4	6.88 MB
2. Why we need Capital budgeting.srt	SRT	2.7 KB
3. The time value of money.mp4	MP4	6.69 MB
3. The time value of money.srt	SRT	2.78 KB
4. Calculating future and present value.mp4	MP4	13.08 MB
4. Calculating future and present value.srt	SRT	6.66 KB
5. Calculating cost of equity.mp4	MP4	19.21 MB
5. Calculating cost of equity.srt	SRT	8.01 KB
6. Coming up with project-specific beta.mp4	MP4	9 MB
6. Coming up with project-specific beta.srt	SRT	3.83 KB
7. Weighted average cost of capital (WACC).mp4	MP4	5.5 MB
7. Weighted average cost of capital (WACC).srt	SRT	2.48 KB
8. The type of cash flows we will have in a project.mp4	MP4	9.34 MB
8. The type of cash flows we will have in a project.srt	SRT	4.16 KB
9. Estimating the project's cash flows.mp4	MP4	18.8 MB
9. Estimating the project's cash flows.srt	SRT	7.15 KB

19. Capital Budgeting - A complete Case study

1. Introduction to the Capital budgeting exercise.mp4	MP4	8.63 MB
1. Introduction to the Capital budgeting exercise.srt	SRT	3.42 KB
10. Finding cost of equity.mp4	MP4	13.93 MB
10. Finding cost of equity.srt	SRT	7.63 KB
10.1 8. WACC_unsolved.xlsx	XLSX	35.93 KB
10.2 8. WACC.xlsx	XLSX	38.03 KB
11. Discounting the project's cash flows and residual value.mp4	MP4	25.91 MB
11. Discounting the project's cash flows and residual value.srt	SRT	3.76 KB
11.1 9. Discounted cash flow.xlsx	XLSX	39.74 KB
11.2 9. Discounted cash flow_unsolved.xlsx	XLSX	38.72 KB
12. Performing sensitivity analysis and completing the exercise.mp4	MP4	43.05 MB
12. Performing sensitivity analysis and completing the exercise.srt	SRT	5.56 KB
12.1 10. Sensitivity analysis_unsolved.xlsx	XLSX	39.7 KB
12.2 10. Sensitivity analysis.xlsx	XLSX	40.67 KB
13. FAQ Data does not change in the DCF sheet, it changes from the Drivers sheet.html	HTML	378 B
14. Build a complete capital budgeting model from scratch.html	HTML	170 B
15. Congratulations!!.mp4	MP4	2.31 MB
15. Congratulations!!.srt	SRT	1.56 KB
2. Organizing an Inputs sheet.mp4	MP4	11.06 MB
2. Organizing an Inputs sheet.srt	SRT	6.59 KB
2.1 1. Drivers.xlsx	XLSX	11.5 KB
3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4	MP4	9.21 MB
3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.srt	SRT	4.26 KB
3.1 2. Savings Forecast_unsolved.xlsx	XLSX	14.74 KB
3.2 2. Savings Forecast.xlsx	XLSX	16.58 KB
4. Fixed asset rollforward.mp4	MP4	12.16 MB
4. Fixed asset rollforward.srt	SRT	5.55 KB
4.1 3. Fixed Asset Rollforward_unsolved.xlsx	XLSX	18.54 KB
4.2 3. Fixed Asset Rollforward.xlsx	XLSX	19.66 KB
5. The impact of working capital.mp4	MP4	5.36 MB
5. The impact of working capital.srt	SRT	3.03 KB
5.1 4. Working Capital_unsolved.xlsx	XLSX	21.19 KB
5.2 4. Working Capital.xlsx	XLSX	21.93 KB
6. Modeling debt financing.mp4	MP4	6.18 MB
6. Modeling debt financing.srt	SRT	3.43 KB
6.1 5. Financing_unsolved.xlsx	XLSX	29.99 KB
6.2 5. Financing.xlsx	XLSX	30.97 KB
7. Adding a P&L sheet.mp4	MP4	4.88 MB
7. Adding a P&L sheet.srt	SRT	2.23 KB
7.1 6. P&L_unsolved.xlsx	XLSX	29.7 KB
7.2 6. P&L.xlsx	XLSX	31.03 KB
8. Calculating project cash flows.mp4	MP4	10.15 MB
8. Calculating project cash flows.srt	SRT	3.98 KB
8.1 7. Cash flow.xlsx	XLSX	31.36 KB
8.2 7. Cash flow_unsolved.xlsx	XLSX	29.64 KB
9. Estimating the weighted average cost of capital (WACC).mp4	MP4	5.58 MB
9. Estimating the weighted average cost of capital (WACC).srt	SRT	3.52 KB
9.1 8. WACC.xlsx	XLSX	38.03 KB
9.2 8. WACC_unsolved.xlsx	XLSX	35.93 KB

2. Introduction to Excel

1. Introduction to Excel.mp4	MP4	1.99 MB
1. Introduction to Excel.srt	SRT	925 B
10. Introduction to Excel formulas.html	HTML	167 B
11. Introduction to Excel functions.mp4	MP4	18.69 MB
11. Introduction to Excel functions.srt	SRT	3.97 KB
11.1 13. Functions- Exercise_after.xlsx	XLSX	81.1 KB
11.2 13. Functions - Lecture_after.xlsx	XLSX	9.34 KB
11.3 13. Functions-Exercise_before.xlsx	XLSX	13.26 KB
11.4 13. Functions- Lecture_before.xlsx	XLSX	9.24 KB
11.5 Introduction to Excel.pdf	PDF	2.03 MB
12. Cut, copy, & paste.mp4	MP4	12.99 MB
12. Cut, copy, & paste.srt	SRT	2.32 KB
12.1 14. Copy-Cut-Paste-Exercise_after.xlsx	XLSX	12.56 KB
12.2 Introduction to Excel.pdf	PDF	2.03 MB
12.3 14. Copy-Cut-Paste-Exercise_before.xlsx	XLSX	11.34 KB
13. Cut, copy, & paste.html	HTML	167 B
14. Paste special.mp4	MP4	10.88 MB
14. Paste special.srt	SRT	1.44 KB
14.1 Introduction to Excel.pdf	PDF	2.03 MB
14.2 15. Paste-Special-Exercise_before.xlsx	XLSX	13.47 KB
14.3 15. Paste-Special-Exercise_after.xlsx	XLSX	13.46 KB
15. Format cells.mp4	MP4	29.12 MB
15. Format cells.srt	SRT	6.51 KB
15.1 10. Format cells_before.xlsx	XLSX	9.81 KB
15.2 10. Format cells_after.xlsx	XLSX	9.81 KB
16. Basic operations in Excel - 38 pages.html	HTML	171 B
2. Overview of Excel.mp4	MP4	20.69 MB
2. Overview of Excel.srt	SRT	4.03 KB
2.1 Introduction to Excel.pdf	PDF	2.03 MB
2.2 7. Overview-of-Excel-Exercise_before.xlsx	XLSX	10.47 KB
2.3 7. Overview-of-Excel-Exercise_after.xlsx	XLSX	10.88 KB
3. Overview of Excel.html	HTML	167 B
4. The Excel ribbon.mp4	MP4	13.58 MB
4. The Excel ribbon.srt	SRT	2.67 KB
4.1 8. The-Ribbon-Exercise_after.xlsx	XLSX	403.25 KB
4.2 Introduction to Excel.pdf	PDF	2.03 MB
4.3 8. The-Ribbon-Exercise_before.xlsx	XLSX	12.09 KB
5. Basic operations with rows and columns.mp4	MP4	11.2 MB
5. Basic operations with rows and columns.srt	SRT	1.9 KB
5.1 Introduction to Excel.pdf	PDF	2.03 MB
5.2 9. Basic Manipulations - Lecture.xlsx	XLSX	8.07 KB
5.3 9. Basic-Manipulations - Exercise_after.xlsx	XLSX	32.43 KB
5.4 9. Basic-Manipulations - Exercise_before.xlsx	XLSX	11.06 KB
6. Data entry in Excel.mp4	MP4	15.99 MB
6. Data entry in Excel.srt	SRT	3.43 KB
6.1 Introduction to Excel.pdf	PDF	2.02 MB
6.2 10. Data-Entry- Exercise_after.xlsx	XLSX	32.76 KB
6.3 10. Data-Entry - Lecture.xlsx	XLSX	8.07 KB
6.4 10. Data-Entry-Exercise_before.xlsx	XLSX	10.97 KB
7. Introduction to formatting.mp4	MP4	38.22 MB
7. Introduction to formatting.srt	SRT	5.86 KB
7.1 11. Formatting- Exercise_after.xlsx	XLSX	11.59 KB
7.2 11. Formatting- Lecture_before.xlsx	XLSX	8.91 KB
7.3 11. Formatting-Exercise_before.xlsx	XLSX	11.61 KB
7.4 Introduction to Excel.pdf	PDF	2.02 MB
7.5 11. Formatting - Lecture_after.xlsx	XLSX	9.85 KB
8. Rows and columns.html	HTML	167 B
9. Introduction to Excel formulas.mp4	MP4	20.67 MB
9. Introduction to Excel formulas.srt	SRT	4.39 KB
9.1 12. Formulas- Lecture_before.xlsx	XLSX	9.3 KB
9.2 12. Formulas- Exercise_after.xlsx	XLSX	80.13 KB
9.3 12. Formulas - Exercise_before.xlsx	XLSX	11.72 KB
9.4 Introduction to Excel.pdf	PDF	2.03 MB
9.5 12. Formulas- Lecture_after.xlsx	XLSX	277.47 MB

20. Next steps

1. Next steps.html

HTML

2.29 KB

21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel

1. Overview of Excel.mp4	MP4	41.17 MB
1. Overview of Excel.srt	SRT	4.14 KB
1.1 7. Overview-of-Excel-Exercise-Unsolved.xlsx	XLSX	10.47 KB
1.2 7. Overview-of-Excel-Exercise-Solved.xlsx	XLSX	10.88 KB
1.3 7. Introduction to Excel.pdf	PDF	2.27 MB
2. Basic manipulations with rows and columns.mp4	MP4	20.42 MB
2. Basic manipulations with rows and columns.srt	SRT	2.1 KB
2.1 8. Basic-Manipulations - Exercise - Unsolved.xlsx	XLSX	11.06 KB
2.2 8. Basic-Manipulations - Exercise - Solved.xlsx	XLSX	32.43 KB
2.3 8. Basic manipulations - Lecture.xlsx	XLSX	8.07 KB
3. The Excel ribbon.mp4	MP4	28.91 MB
3. The Excel ribbon.srt	SRT	3.2 KB
3.1 9. The-Ribbon-Exercise-Exercise - Unsolved.xlsx	XLSX	12.09 KB
3.2 9. The-Ribbon-Exercise-Solved.xlsx	XLSX	403.25 KB
4. Data entry in Excel.mp4	MP4	31.5 MB
4. Data entry in Excel.srt	SRT	3.53 KB
4.1 10. Data-Entry-Exercise - Unsolved.xlsx	XLSX	10.97 KB
4.2 10. Data-Entry- Exercise -Solved.xlsx	XLSX	32.76 KB
4.3 10. Data-Entry - Lecture.xlsx	XLSX	8.07 KB
5. Introduction to formatting.mp4	MP4	75.39 MB
5. Introduction to formatting.srt	SRT	6.64 KB
5.1 11. Formatting-Exercise - Unsolved.xlsx	XLSX	11.61 KB
5.2 11. Formatting - Lecture - Solved.xlsx	XLSX	9.85 KB
5.3 11. Formatting- Exercise - Solved.xlsx	XLSX	11.59 KB
5.4 11. Formatting- Lecture - Unsolved.xlsx	XLSX	8.91 KB
6. Introduction to Excel formulas.mp4	MP4	18.77 MB
6. Introduction to Excel formulas.srt	SRT	4.28 KB
6.1 12. Formulas- Lecture - Unsolved.xlsx	XLSX	9.3 KB
6.2 12. Formulas- Exercise - Solved.xlsx	XLSX	80.13 KB
6.3 Introduction-to-Excels-basic-features.pdf	PDF	2.26 MB
6.4 12. Formulas - Exercise - Unsolved.xlsx	XLSX	11.72 KB
6.5 12. Formulas- Lecture - Solved.xlsx	XLSX	9.36 KB
7. Introduction to Excel functions.mp4	MP4	37.13 MB
7. Introduction to Excel functions.srt	SRT	4.68 KB
7.1 Introduction-to-Excels-basic-features.pdf	PDF	2.27 MB
7.2 13. Functions - Lecture -Solved.xlsx	XLSX	9.34 KB
7.3 13. Functions-Exercise - Unsolved.xlsx	XLSX	13.26 KB
7.4 13. Functions- Lecture - Unsolved.xlsx	XLSX	9.24 KB
7.5 13. Functions- Exercise - Solved.xlsx	XLSX	81.1 KB
8. Cut, copy, & paste.mp4	MP4	7.56 MB
8. Cut, copy, & paste.srt	SRT	2.41 KB
8.1 14. Copy-Cut-Paste-Exercise - Solved.xlsx	XLSX	12.56 KB
8.2 Introduction-to-Excels-basic-features.pdf	PDF	2.27 MB
8.3 14. Copy-Cut-Paste-Exercise - Unsolved.xlsx	XLSX	11.34 KB
9. Paste special.mp4	MP4	6.7 MB
9. Paste special.srt	SRT	1.57 KB
9.1 15. Paste-Special-Exercise - Solved.xlsx	XLSX	13.46 KB
9.2 Introduction-to-Excels-basic-features.pdf	PDF	2.26 MB
9.3 15. Paste-Special-Exercise - Unsolved.xlsx	XLSX	13.47 KB

22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks

1. Initial formatting of an Excel sheet to render it professional.mp4	MP4	7.98 MB
1. Initial formatting of an Excel sheet to render it professional.srt	SRT	2.3 KB
1.1 18. Formatting-a-Worksheet-Exercise - Solved.xlsx	XLSX	10.76 KB
1.2 Useful-Tips-Tools.pdf	PDF	3.3 MB
1.3 18. Formatting-a-Worksheet-Exercise - Unsolved.xlsx	XLSX	10.63 KB
1.4 18. Formatting-a-worksheet-Lecture - Solved.xlsx	XLSX	9.56 KB
1.5 18. Formatting-a-worksheet-Lecture - Unsolved.xlsx	XLSX	8.98 KB
10. Find and select special types of cells with Select Special (F5).mp4	MP4	9.78 MB
10. Find and select special types of cells with Select Special (F5).srt	SRT	1.95 KB
10.1 26. Select-Special-F5-Exercise - Unsolved.xlsx	XLSX	21.59 KB
10.2 26. Select-Special-Lecture.xlsx	XLSX	10.56 KB
10.3 Useful-Tips-Tools.pdf	PDF	3.3 MB
10.4 26. Select-Special-F5-Exercise - Solved.xlsx	XLSX	22.27 KB
11. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4	MP4	5.42 MB
11. Assign custom formats to specific cells within a financial model (e.g Multiples).srt	SRT	1.98 KB
11.1 29. Assigning Custom Formats - Exercise - Solved.xlsx	XLSX	11.08 KB
11.2 Useful-Tips-Tools.pdf	PDF	3.3 MB
11.3 29. Assigning Custom Formats - Exercise - Unsolved.xlsx	XLSX	11.35 KB
12. Define a named range in Excel.mp4	MP4	5.43 MB
12. Define a named range in Excel.srt	SRT	1.7 KB
12.1 28. Defining-a-Named-Range-Exercise - Solved.xlsx	XLSX	11.65 KB
12.2 28. Naming-ranges-Lecture - Unsolved.xlsx	XLSX	8.79 KB
12.3 28. Naming-ranges-Lecture - Solved.xlsx	XLSX	10.34 KB
12.4 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx	XLSX	11.07 KB
12.5 Useful-Tips-Tools.pdf	PDF	3.3 MB
13. Learn how to organize your data with Text to Columns.mp4	MP4	12.53 MB
13. Learn how to organize your data with Text to Columns.srt	SRT	2.34 KB
13.1 Useful-Tips-Tools.pdf	PDF	3.31 MB
13.2 23.Text-to-columns-Lecture - Solved.xlsx	XLSX	9.9 KB
13.3 23. Text-to-Columns-Exercise - Solved.xlsx	XLSX	11.3 KB
13.4 23. Text-to-columns-Lecture - Unsolved.xlsx	XLSX	9.76 KB
13.5 23. Text-to-Columns-Exercise - Unsolved.xlsx	XLSX	10.57 KB
14. Learn how to assign dynamic names within a financial model.mp4	MP4	7.32 MB
14. Learn how to assign dynamic names within a financial model.srt	SRT	1.64 KB
14.1 27. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx	XLSX	11.23 KB
14.2 27. Dynamic-Naming-Lecture - Solved.xlsx	XLSX	13.83 KB
14.3 Useful-Tips-Tools.pdf	PDF	3.3 MB
14.4 27. Dynamic-Naming-Lecture - Unsolved.xlsx	XLSX	13.54 KB
14.5 27. Assigning-Dynamic-Names-Exercise - Solved.xlsx	XLSX	11.73 KB
15. Create easily printable documents in Excel by using Set Print Area.mp4	MP4	4.74 MB
15. Create easily printable documents in Excel by using Set Print Area.srt	SRT	1.59 KB
15.1 Useful-Tips-Tools.pdf	PDF	3.3 MB
15.2 25. Set-Print-Area-Lecture - Unsolved.xlsx	XLSX	11.42 KB
15.3 25. Set-Print-Area-Lecture - Solved.xlsx	XLSX	11.22 KB
16. Using the 'Alt + Enter' combination.mp4	MP4	3.33 MB
16. Using the 'Alt + Enter' combination.srt	SRT	1.04 KB
16.1 22. Alt-Enter-Exercise - Solved.xlsx	XLSX	11.4 KB
16.2 22. Alt-Enter- Lecture - Solved.xlsx	XLSX	9.65 KB
16.3 22. Alt-Enter- Lecture - Unsolved.xlsx	XLSX	9.64 KB
16.4 22. Alt-Enter-Exercise - Unsolved.xlsx	XLSX	11.12 KB
2. Fast scrolling through Excel sheets.mp4	MP4	22.17 MB
2. Fast scrolling through Excel sheets.srt	SRT	1.82 KB
2.1 19. Fast-Scrolling-Exercise - Solved.xlsx	XLSX	44.35 KB
2.2 Useful-Tips-Tools.pdf	PDF	3.3 MB
2.3 19. Fast-Scrolling-Exercise - Unsolved.xlsx	XLSX	43.9 KB
2.4 19. Fast-Scrolling - Lecture.xlsx	XLSX	642.82 KB
3. Introduction to fixing of cell references.mp4	MP4	20.37 MB
3. Introduction to fixing of cell references.srt	SRT	2.69 KB
3.1 21. Fixing-references-Lecture - Solved.xlsx	XLSX	645.17 KB
3.2 21. Fixing-Cells-Exercise - Unsolved.xlsx	XLSX	10.67 KB
3.3 Useful-Tips-Tools.pdf	PDF	3.3 MB
3.4 21. Fixing-Cells-Exercise - Solved.xlsx	XLSX	10.82 KB
3.5 21. Fixing-references-Lecture - Unsolved.xlsx	XLSX	643.98 KB
4. Learn how to use the Wrap Text button.mp4	MP4	2.15 MB
4. Learn how to use the Wrap Text button.srt	SRT	903 B
4.1 24. Wrap-text-Lecture - Solved.xlsx	XLSX	9.61 KB
4.2 Useful-Tips-Tools.pdf	PDF	3.3 MB
4.3 24. Wrap-Text-Exercise - Solved.xlsx	XLSX	10.2 KB
4.4 24. Wrap-text-Lecture - Unsolved.xlsx	XLSX	9.61 KB
4.5 24. Wrap-Text-Exercise - Unsolved.xlsx	XLSX	10.17 KB
5. Create a drop-down list by using Data Validation.mp4	MP4	10.59 MB
5. Create a drop-down list by using Data Validation.srt	SRT	2.22 KB
5.1 32. Data-Validation-Lecture - Solved.xlsx	XLSX	10.84 KB
5.2 32. Drop-down-List-Exercise - Solved.xlsx	XLSX	77.02 KB
5.3 Useful-Tips-Tools.pdf	PDF	3.3 MB
5.4 32. Data-Validation-Lecture - Unsolved.xlsx	XLSX	10.84 KB
5.5 32. Drop-down-List-Exercise - Unsolved.xlsx	XLSX	11.34 KB
6. Using Custom-sort in order to sort multiple columns within a table.mp4	MP4	9.14 MB
6. Using Custom-sort in order to sort multiple columns within a table.srt	SRT	1.68 KB
6.1 33. Custom-Sort-Exercise - Solved.xlsx	XLSX	11.46 KB
6.2 33. Sort-data-Lecture - Solved.xlsx	XLSX	145.65 KB
6.3 33. Sort-data-Lecture - Unsolved.xlsx	XLSX	145.35 KB
6.4 33. Custom-Sort-Exercise - Unsolved.xlsx	XLSX	11.37 KB
6.5 Useful-Tips-Tools.pdf	PDF	3.3 MB
7. Create a great Index page at the beginning of your models - Hyperlinks.mp4	MP4	5.35 MB
7. Create a great Index page at the beginning of your models - Hyperlinks.srt	SRT	1.6 KB
7.1 34. Hyperlinks-Exercise - Unsolved.xlsx	XLSX	136.89 KB
7.2 34. Hyperlinks-Exercise - Solved.xlsx	XLSX	137.06 KB
7.3 Useful-Tips-Tools.pdf	PDF	3.3 MB
8. Fix the top row of your table with Freeze Panes.mp4	MP4	17.67 MB
8. Fix the top row of your table with Freeze Panes.srt	SRT	1.5 KB
8.1 35. Freeze-Panes-Lecture - Solved.xlsx	XLSX	643.94 KB
8.2 Useful-Tips-Tools.pdf	PDF	3.3 MB
8.3 35. Freeze-Panes-Lecture - Unsolved.xlsx	XLSX	643.87 KB
9. Macros are a great timesaver! Here's why!.mp4	MP4	11.1 MB
9. Macros are a great timesaver! Here's why!.srt	SRT	3.57 KB
9.1 Useful-Tips-Tools.pdf	PDF	3.3 MB
9.2 30. Macros-Exercise - Solved.xlsx	XLSX	145.02 KB
9.3 30. Creating-a-Macro-Lecture - Solved.xlsx	XLSX	11.17 KB
9.4 30. Creating-a-Macro-Lecture - Unsolved.xlsx	XLSX	9.66 KB
9.5 30. Macros-Exercise - Unsolved.xlsx	XLSX	10.34 KB

23. APPENDIX - Microsoft Excel 2010 - Keyboard shortcuts

	1. Keyboard shortcuts Save LOTS of time in Excel 2010.mp4	MP4	30.43 MB
	1. Keyboard shortcuts Save LOTS of time in Excel 2010.srt	SRT	5.53 KB

3. Useful tips and tools for your work in Excel

1. Excel best practices - Welcome lecture.mp4	MP4	2.14 MB
1. Excel best practices - Welcome lecture.srt	SRT	1.04 KB
1.1 Useful Tips & Tools.pdf	PDF	3.06 MB
10. Learn how to organize your data with text to columns.html	HTML	167 B
11. The wrap text button.mp4	MP4	3.66 MB
11. The wrap text button.srt	SRT	914 B
11.1 Wrap-Text-Exercise - Solved.xlsx	XLSX	10.2 KB
11.2 Wrap-Text-Exercise - Unsolved.xlsx	XLSX	10.17 KB
11.3 Wrap-text-Lecture - Solved.xlsx	XLSX	9.61 KB
11.4 Wrap-text-Lecture - Unsolved.xlsx	XLSX	9.61 KB
12. Set print area.mp4	MP4	7.58 MB
12. Set print area.srt	SRT	1.5 KB
12.1 Set-Print-Area-Lecture - Unsolved.xlsx	XLSX	11.79 KB
12.2 Set-Print-Area-Lecture - Solved.xlsx	XLSX	11.22 KB
13. Custom sort helps you sort multiple columns in Excel tables.mp4	MP4	11.18 MB
13. Custom sort helps you sort multiple columns in Excel tables.srt	SRT	1.67 KB
13.1 Sort-data-Lecture - Unsolved.xlsx	XLSX	145.35 KB
13.2 Custom-Sort-Exercise - Unsolved.xlsx	XLSX	11.37 KB
13.3 Custom-Sort-Exercise - Solved.xlsx	XLSX	11.46 KB
13.4 Sort-data-Lecture - Solved.xlsx	XLSX	145.65 KB
14. Create drop-down lists with data validation.mp4	MP4	14.13 MB
14. Create drop-down lists with data validation.srt	SRT	1.91 KB
14.1 Drop-down-List-Exercise - Unsolved.xlsx	XLSX	11.34 KB
14.2 Data-Validation-Lecture - Solved.xlsx	XLSX	11.26 KB
14.3 Drop-down-List-Exercise - Solved.xlsx	XLSX	77.02 KB
14.4 Data-Validation-Lecture - Unsolved.xlsx	XLSX	11.18 KB
15. Find and select special types of cells with Select special (F5).mp4	MP4	13.92 MB
15. Find and select special types of cells with Select special (F5).srt	SRT	1.72 KB
15.1 Select-Special-Lecture.xlsx	XLSX	10.56 KB
15.2 Select-Special-F5-Exercise - Unsolved.xlsx	XLSX	21.59 KB
15.3 Select-Special-Lecture-Solved.xlsx	XLSX	10.91 KB
15.4 Select-Special-F5-Exercise - Solved.xlsx	XLSX	22.27 KB
16. Select Special.html	HTML	167 B
17. Assign dynamic names in a financial model.mp4	MP4	7.73 MB
17. Assign dynamic names in a financial model.srt	SRT	1.55 KB
17.1 Dynamic-Naming-Lecture - Unsolved.xlsx	XLSX	13.71 KB
17.2 Assigning-Dynamic-Names-Exercise - Solved.xlsx	XLSX	11.73 KB
17.3 Assigning-Dynamic-Names-Exercise - Unsolved.xlsx	XLSX	11.23 KB
17.4 Dynamic-Naming-Lecture - Solved.xlsx	XLSX	12.42 KB
18. Assigning dynamic names.html	HTML	167 B
19. Define a named range in Excel.mp4	MP4	7.67 MB
19. Define a named range in Excel.srt	SRT	1.76 KB
19.1 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx	XLSX	11.07 KB
19.2 28. Defining-a-Named-Range-Exercise - Solved.xlsx	XLSX	11.65 KB
19.3 28. Naming-ranges-Lecture - Solved.xlsx	XLSX	10.34 KB
19.4 28. Naming-ranges-Lecture - Unsolved.xlsx	XLSX	8.79 KB
2. Initial formatting of Excel sheets for a professional layout.mp4	MP4	11.59 MB
2. Initial formatting of Excel sheets for a professional layout.srt	SRT	2.32 KB
2.1 Formatting-a-Worksheet-Exercise - Unsolved.xlsx	XLSX	10.63 KB
2.2 Useful Tips & Tools.pdf	PDF	3.05 MB
2.3 Formatting-a-Worksheet-Exercise - Solved.xlsx	XLSX	10.76 KB
2.4 Formatting-a-worksheet-Lecture - Solved.xlsx	XLSX	9.56 KB
2.5 Formatting-a-worksheet-Lecture - Unsolved.xlsx	XLSX	8.98 KB
20. Create a great Index page at the beginning of your models - Hyperlinks.mp4	MP4	8.57 MB
20. Create a great Index page at the beginning of your models - Hyperlinks.srt	SRT	1.44 KB
20.1 Hyperlinks-Exercise - Unsolved.xlsx	XLSX	136.89 KB
20.2 Hyperlinks - Lecture - Unsolved.xlsx	XLSX	14.18 KB
20.3 Hyperlinks-Exercise - Solved.xlsx	XLSX	137.06 KB
20.4 Hyperlinks - Lecture - Solved.xlsx	XLSX	14.34 KB
21. Introduction to custom formatting in Excel.mp4	MP4	37.96 MB
21. Introduction to custom formatting in Excel.srt	SRT	8.06 KB
21.1 19. Custom formatting_before.xlsx	XLSX	10.69 KB
21.2 19. Custom formatting_after.xlsx	XLSX	10.75 KB
22. Apply custom formatting in a financial model.mp4	MP4	9.15 MB
22. Apply custom formatting in a financial model.srt	SRT	1.59 KB
22.1 Custom formats - Lecture - Unsolved.xlsx	XLSX	8.33 KB
22.2 Custom formats - Lecture - Solved.xlsx	XLSX	8.79 KB
22.3 Assigning Custom Formats - Exercise - Solved.xlsx	XLSX	11.08 KB
22.4 Assigning Custom Formats - Exercise - Unsolved.xlsx	XLSX	11.35 KB
23. Macros are a great timesaver! Here's why!.mp4	MP4	17.17 MB
23. Macros are a great timesaver! Here's why!.srt	SRT	3.11 KB
23.1 Recording a Macro - Lecture - Solved.ods	ODS	3.02 KB
23.2 Recording a Macro - Lecture - Unsolved.ods	ODS	2.58 KB
24. How to save macros and use them across several workbooks.mp4	MP4	12.79 MB
24. How to save macros and use them across several workbooks.srt	SRT	1.68 KB
24.1 31. How-to-save-macros-Lecture-after.xlsm	XLSM	12.59 KB
24.2 31. How-to-save-macros-Lecture-before.xlsx	XLSX	6.02 KB
24.3 31. Another-file.xlsx	XLSX	8.81 KB
25. Excel macros - quiz.html	HTML	167 B
26. Fix the top row of your table with freeze panes.mp4	MP4	14.47 MB
26. Fix the top row of your table with freeze panes.srt	SRT	1.34 KB
26.1 Freeze-Panes-Lecture - Solved.xlsx	XLSX	644.18 KB
26.2 Freeze-Panes-Lecture - Unsolved.xlsx	XLSX	644.18 KB
27. How to search functionalities in Excel.mp4	MP4	7.54 MB
27. How to search functionalities in Excel.srt	SRT	853 B
27.1 Search.xlsx	XLSX	644.18 KB
28. Filter by color - an excellent tool.mp4	MP4	9.87 MB
28. Filter by color - an excellent tool.srt	SRT	2.21 KB
28.1 36. Exercise-Filter-by-Color-Solved.xlsx	XLSX	153.48 KB
28.2 36. Exercise-Filter-by-Color-Unsolved.xlsx	XLSX	20.47 KB
29. Working with conditional formatting.mp4	MP4	15.09 MB
29. Working with conditional formatting.srt	SRT	6.07 KB
29.1 Exercise_Conditional Formatting.xlsx	XLSX	12.88 KB
29.2 Conditional Formatting - Lecture.xlsx	XLSX	12.47 KB
29.3 Solution_Conditional Formatting.xlsx	XLSX	51.52 KB
3. Fast scrolling through Excel sheets.mp4	MP4	17.53 MB
3. Fast scrolling through Excel sheets.srt	SRT	1.9 KB
3.1 Fast-Scrolling - Lecture.xlsx	XLSX	643.69 KB
3.2 Fast-Scrolling-Exercise - Solved.xlsx	XLSX	44.35 KB
3.3 Fast-Scrolling-Exercise - Unsolved.xlsx	XLSX	43.9 KB
30. Useful tips and tools for your work in Excel - quiz.html	HTML	166 B
31. A neat trick - Multiply by 1.mp4	MP4	14.84 MB
31. A neat trick - Multiply by 1.srt	SRT	1.74 KB
31.1 38. Multiply-by-1-Lecture-before.xlsx	XLSX	16.47 KB
31.2 38. Multiply-by-1-Lecture-after.xlsx	XLSX	17.21 KB
32. Find and replace - references.mp4	MP4	24.04 MB
32. Find and replace - references.srt	SRT	3.45 KB
32.1 39. Find-and-Replace-references-Lecture-after.xlsx	XLSX	37.91 KB
32.2 39. Find-and-Replace-references-Lecture-before.xlsx	XLSX	38.79 KB
33. FAQ Why do we replace external references and how does this help us.html	HTML	702 B
34. Find and replace - formatting.mp4	MP4	13.78 MB
34. Find and replace - formatting.srt	SRT	1.91 KB
34.1 40. Find-replace-Lecture-after.xlsx	XLSX	17.19 KB
34.2 40. Find-replace-Lecture-before.xlsx	XLSX	17.19 KB
35. Removing (automatic) green arrows.mp4	MP4	12.6 MB
35. Removing (automatic) green arrows.srt	SRT	1.7 KB
35.1 41. Green-references-Lecture.xlsx	XLSX	12 KB
36. Beauty saving - The professional way of saving files.mp4	MP4	14.03 MB
36. Beauty saving - The professional way of saving files.srt	SRT	2.54 KB
36.1 42. Beauty-saving-Lecture-after.xlsx	XLSX	17.05 KB
36.2 42. Beauty-saving-Lecture-before.xlsx	XLSX	17.17 KB
37. Formula auditing with F2.mp4	MP4	17.74 MB
37. Formula auditing with F2.srt	SRT	2.19 KB
37.1 43. F2-Lecture.xlsm	XLSM	50.76 KB
4. Fast scrolling through Excel sheets.html	HTML	167 B
5. Be even quicker F5 + Enter.mp4	MP4	19.79 MB
5. Be even quicker F5 + Enter.srt	SRT	2.16 KB
5.1 20. F5-go-to - Lecture.xlsm	XLSM	50.76 KB
6. Fixing cell references.mp4	MP4	24.11 MB
6. Fixing cell references.srt	SRT	2.5 KB
6.1 Fixing-references-Lecture - Unsolved.xlsx	XLSX	644.12 KB
6.2 Fixing-Cells-Exercise - Unsolved.xlsx	XLSX	10.67 KB
6.3 Fixing-references-Lecture - Solved.xlsx	XLSX	644.55 KB
6.4 Fixing-Cells-Exercise - Solved.xlsx	XLSX	10.82 KB
7. Introduction to fixing of cell references.html	HTML	167 B
8. Alt + Enter.mp4	MP4	4.16 MB
8. Alt + Enter.srt	SRT	961 B
8.1 Alt-Enter-Exercise - Solved.xlsx	XLSX	11.4 KB
8.2 Alt-Enter- Lecture - Solved.xlsx	XLSX	10.01 KB
8.3 Alt-Enter- Lecture - Unsolved.xlsx	XLSX	9.95 KB
8.4 Alt-Enter-Exercise - Unsolved.xlsx	XLSX	11.12 KB
9. Organize your data with text to columns.mp4	MP4	13.95 MB
9. Organize your data with text to columns.srt	SRT	2.47 KB
9.1 Text-to-columns-Lecture - Solved.xlsx	XLSX	10.2 KB
9.2 Invoice example.pdf	PDF	44.47 KB
9.3 Text-to-Columns-Exercise - Solved.xlsx	XLSX	11.3 KB
9.4 Text-to-columns-Lecture - Unsolved.xlsx	XLSX	9.76 KB
9.5 Text-to-Columns-Exercise - Unsolved.xlsx	XLSX	10.57 KB

4. Keyboard shortcuts in Excel

1. Keyboard shortcuts save LOTS of time in Excel.mp4	MP4	51.17 MB
1. Keyboard shortcuts save LOTS of time in Excel.srt	SRT	5.9 KB
1.1 Beginner to Pro in Excel - Shortcuts for PC.pdf	PDF	1.04 MB
1.2 Beginner to Pro in Excel - Shortcuts for MAC.pdf	PDF	447.56 KB
2. Keyboard shortcuts in Excel.html	HTML	171 B

5. Excel's key functions and functionalities made easy

1. Excel's key functions - Welcome lecture.mp4	MP4	2.31 MB
1. Excel's key functions - Welcome lecture.srt	SRT	1.11 KB
10. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.html	HTML	167 B
11. Working with text in Excel.mp4	MP4	16.01 MB
11. Working with text in Excel.srt	SRT	3.08 KB
11.1 53. Work-with-text-Lecture-before.xlsx	XLSX	10.33 KB
11.2 53. Work-with-text-Lecture-after.xlsx	XLSX	10.91 KB
12. Find the minimum or maximum value in a range of cells in Excel.mp4	MP4	5.92 MB
12. Find the minimum or maximum value in a range of cells in Excel.srt	SRT	1.15 KB
12.1 54. MIN-MAX-Exercise - Solved.xlsx	XLSX	14.8 KB
12.2 54. Max-min-Lecture - Solved.xlsx	XLSX	9.23 KB
12.3 54. MIN-MAX-Exercise - Unsolved.xlsx	XLSX	14.39 KB
12.4 54. Max-min-Lecture - Unsolved.xlsx	XLSX	8.95 KB
13. Include ROUND in your financial models.mp4	MP4	3.13 MB
13. Include ROUND in your financial models.srt	SRT	1.2 KB
13.1 55. Round-Exercise - Solved.xlsx	XLSX	11.71 KB
13.2 55. Round-Exercise - Unsolved.xlsx	XLSX	11.34 KB
13.3 55. Excel-functions-Lecture.xlsx	XLSX	889.91 KB
13.4 Excel-Functions.pdf	PDF	3.18 MB
14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4	MP4	34.6 MB
14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.srt	SRT	9.02 KB
14.1 56. Vlookup-Hlookup-Exercise - Unsolved.xlsx	XLSX	11.95 KB
14.2 56. Vlookup-Hlookup- Lecture - Unsolved.xlsx	XLSX	10.74 KB
14.3 Excel-Functions.pdf	PDF	3.19 MB
14.4 56. Vlookup-Hlookup-Exercise - Solved.xlsx	XLSX	13.68 KB
14.5 56. Vlookup-Hlookup- Lecture - Solved.xlsx	XLSX	11.13 KB
15. How to enlarge the formula bar.mp4	MP4	6.25 MB
15. How to enlarge the formula bar.srt	SRT	1.4 KB
15.1 57. Enlarge-the-formula-bar-Lecture.xlsm	XLSM	46.89 KB
16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4	MP4	38.95 MB
16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.srt	SRT	8.83 KB
16.1 58. Index-Match-Lecture - Solved.xlsx	XLSX	11.7 KB
16.2 58. Index-Match-Exercise - Solved.xlsx	XLSX	12.08 KB
16.3 58. Index-Match-Exercise - Unsolved.xlsx	XLSX	11.59 KB
16.4 58. Index-Match-Lecture - Unsolved.xlsx	XLSX	11.29 KB
16.5 Excel-Functions.pdf	PDF	3.18 MB
17. A great Excel technique INDEX, MATCH, MATCH.mp4	MP4	11.77 MB
17. A great Excel technique INDEX, MATCH, MATCH.srt	SRT	5.65 KB
17.1 59. Exercise-Index-Match-Match-Unsolved.xlsx	XLSX	11.58 KB
17.2 59. Exercise-Index-Match-Match-Solved.xlsx	XLSX	12.21 KB
17.3 Index, Match, Match - Lecture.xlsx	XLSX	22.32 KB
18. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.html	HTML	167 B
19. Using Excel's IFERROR function to trap spreadsheet errors.mp4	MP4	7.52 MB
19. Using Excel's IFERROR function to trap spreadsheet errors.srt	SRT	2.18 KB
19.1 60. Iferror - Lecture - Unsolved.xlsm	XLSM	897.26 KB
19.2 60. Iferror - Lecture - Solved.xlsm	XLSM	896.43 KB
19.3 Excel-Functions.pdf	PDF	3.18 MB
19.4 60. Iferror-Exercise - Unsolved.xlsx	XLSX	14.26 KB
19.5 60. Iferror-Exercise - Solved.xlsx	XLSX	15.37 KB
2. A helpful consideration.html	HTML	1.1 KB
20. RANK is a valuable tool when using Excel for financial and business analysis.mp4	MP4	23.25 MB
20. RANK is a valuable tool when using Excel for financial and business analysis.srt	SRT	2.86 KB
20.1 61. Rank-function-Lecture-before.xlsx	XLSX	12.27 KB
20.2 61. Rank-function-Lecture-after.xlsx	XLSX	12.61 KB
21. Learn how to render your models flexible with CHOOSE.mp4	MP4	8.98 MB
21. Learn how to render your models flexible with CHOOSE.srt	SRT	2.81 KB
21.1 62. Choose-Exercise-Solved.xlsx	XLSX	11.73 KB
21.2 62. Choose-Lecture - Solved.xlsx	XLSX	9.69 KB
21.3 62. Choose-Lecture - Unsolved.xlsx	XLSX	9.33 KB
21.4 Excel-Functions.pdf	PDF	3.18 MB
21.5 62. Choose-Exercise - Unsolved.xlsx	XLSX	11.32 KB
22. Use Goal Seek to find the result that you are looking for.mp4	MP4	7.86 MB
22. Use Goal Seek to find the result that you are looking for.srt	SRT	7.86 MB
22.1 63. Goal-Seek-Lecture - Solved.xlsx	XLSX	9.17 KB
22.2 63. Goal-Seek-Exercise-Solved.xlsx	XLSX	16.21 KB
22.3 Excel-Functions.pdf	PDF	3.18 MB
22.4 63. Goal-Seek-Lecture - Unsolved.xlsx	XLSX	9.15 KB
22.5 63. Goal-Seek-Exercise - Unsolved.xlsx	XLSX	16.09 KB
23. Use Goal Seek in order to find the result that you are looking for.html	HTML	167 B
24. Include sensitivity analysis in your models through Data Tables.mp4	MP4	14.29 MB
24. Include sensitivity analysis in your models through Data Tables.srt	SRT	4.95 KB
24.1 64. Sensitivity analysis - Lecture - Unsolved.xlsm	XLSM	897.09 KB
24.2 64. Sensitivity-analysis-Exercise-Solved.xlsm	XLSM	63.87 KB
24.3 64. Sensitivity-analysis-Exercise-Unsolved.xlsm	XLSM	66.82 KB
24.4 64. Sensitivity analysis - Lecture - Solved.xlsm	XLSM	897.3 KB
25. Include sensitivity analysis in your models through Data Tables.html	HTML	167 B
26. Excel's dynamic and interactive tables Pivot tables.mp4	MP4	23.2 MB
26. Excel's dynamic and interactive tables Pivot tables.srt	SRT	2.61 KB
26.1 65. Pivot Tables - Exercise - Solved.xlsx	XLSX	190.47 KB
26.2 65. Pivot tables - Lecture - Unsolved.xlsm	XLSM	687.83 KB
26.3 65. Pivot Tables - Exercise - Unsolved.xlsx	XLSX	152.17 KB
26.4 65. Pivot tables - Lecture - Solved.xlsm	XLSM	897.26 KB
27. Excel's key functions and functionalities made easy.html	HTML	166 B
3. Key functions in Excel IF.mp4	MP4	16.65 MB
3. Key functions in Excel IF.srt	SRT	2.95 KB
3.1 Key functions - Excel.pdf	PDF	8.47 MB
3.2 47. IF-function--Lecture-before.xlsm	XLSM	17 KB
3.3 47. IF-function-Lecture-after.xlsm	XLSM	17.94 KB
3.4 Functions - English to Spanish.pdf	PDF	102.37 KB
3.5 Functions - English to German.pdf	PDF	102.32 KB
3.6 Functions - English to Portuguese.pdf	PDF	146.09 KB
4. Key Excel functions SUM, SUMIF and SUMIFS.mp4	MP4	19.32 MB
4. Key Excel functions SUM, SUMIF and SUMIFS.srt	SRT	5.27 KB
4.1 48. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx	XLSX	14.46 KB
4.2 48. Sum-Sumif-Sumifs-Lecture - Solved.xlsx	XLSX	13.01 KB
4.3 48. Sum-Sumif-Sumifs-Exercise - Solved.xlsx	XLSX	14.84 KB
4.4 48. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx	XLSX	12.93 KB
4.5 Excel-Functions.pdf	PDF	3.19 MB
5. = and + are interchangeable when you start typing a formula.mp4	MP4	5.79 MB
5. = and + are interchangeable when you start typing a formula.srt	SRT	974 B
5.1 49. = and + are interchangeable - before.xlsm	XLSM	17.01 KB
5.2 49. = and + are interchangeable -after.xlsm	XLSM	17.04 KB
6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4	MP4	16.99 MB
6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.srt	SRT	4.8 KB
6.1 50.Counts-Exercise-Unsolved.xlsx	XLSX	15.56 KB
6.2 50.Counts-Exercise-Solved.xlsx	XLSX	16.07 KB
6.3 Lecture-Count-Countif-Countifs-Unsolved.xlsx	XLSX	11.29 KB
6.4 Excel-Functions.pdf	PDF	3.19 MB
6.5 Lecture-Count-Countif-Countifs-Solved.xlsx	XLSX	11.68 KB
7. Key Excel functions AVERAGE and AVERAGEIF.mp4	MP4	7.85 MB
7. Key Excel functions AVERAGE and AVERAGEIF.srt	SRT	2.38 KB
7.1 Excel-Functions.pdf	PDF	3.19 MB
7.2 51. Average-Averageif- Lecture - Unsolved.xlsx	XLSX	9.03 KB
7.3 51. Average-AverageIF-Exercise - Unsolved.xlsx	XLSX	14.6 KB
7.4 51. Average-AverageIF-Exercise - Solved.xlsx	XLSX	15.02 KB
7.5 51. Average-Averageif- Lecture - Solved.xlsx	XLSX	9.4 KB
8. Key Excel functions AVERAGE and AVERAGEIF.html	HTML	167 B
9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4	MP4	16.79 MB
9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.srt	SRT	5.66 KB
9.1 52. Text functions - Exercise - Unsolved.xlsx	XLSX	11.71 KB
9.2 52. Text-Functions- Lecture - Unsolved.xlsx	XLSX	10.6 KB
9.3 52. Text-Functions- Lecture - Solved.xlsx	XLSX	11.1 KB
9.4 52. Text functions - Exercise - Solved.xlsx	XLSX	12.24 KB

6. Update! SUMIFS - Exercise

1. Exercise - Excel's SUMIFS function - unsolved.html	HTML	171 B
2. Exercise - Excel's SUMIFS function - solved & explained.mp4	MP4	35.32 MB
2. Exercise - Excel's SUMIFS function - solved & explained.srt	SRT	10.69 KB
2.1 67. Exercise-Sumifs-With-Solutions.xlsx	XLSX	1.29 MB

7. Financial functions in Excel

1. Future and present values in Excel.mp4	MP4	14.97 MB
1. Future and present values in Excel.srt	SRT	6.94 KB
1.1 68. FV and PV-Lecture.xlsx	XLSX	10.64 KB
2. Calculating the rate of return of an investment with the IRR function.mp4	MP4	7.58 MB
2. Calculating the rate of return of an investment with the IRR function.srt	SRT	3.65 KB
2.1 69. Exercise-IRR-Unsolved.xlsx	XLSX	11.52 KB
2.2 69. IRR-Lecture.xlsx	XLSX	11.2 KB
2.3 69. Exercise-IRR-Solved.xlsx	XLSX	12.31 KB
3. Calculating a complete loan schedule in Excel.mp4	MP4	14.82 MB
3. Calculating a complete loan schedule in Excel.srt	SRT	6.52 KB
3.1 70. Loan Schedule-Lecture.xlsx	XLSX	20.17 KB
3.2 70. Exercise-Loan-Schedule-Solved.xlsx	XLSX	22.68 KB
3.3 70. Exercise-Loan-Schedule-Unsolved.xlsx	XLSX	15.81 KB
4. Date functions in Excel.mp4	MP4	11.36 MB
4. Date functions in Excel.srt	SRT	5.79 KB
4.1 71. Date Functions-Exercise-Unsolved.xlsx	XLSX	11.41 KB
4.2 71. Date Functions-Lecture.xlsx	XLSX	12.25 KB
4.3 71. Date Functions-Exercise-Solved.xlsx	XLSX	12.43 KB

8. Microsoft Excel's Pivot Tables in depth

1. Introduction to Pivot Tables and the way they are applied.mp4	MP4	6 MB
1. Introduction to Pivot Tables and the way they are applied.srt	SRT	2.08 KB
2. Creating Pivot Tables easily!.mp4	MP4	19.38 MB
2. Creating Pivot Tables easily!.srt	SRT	4.25 KB
2.1 73. Creating-a-Pivot-Table - Lecture - after.xlsx	XLSX	1.43 MB
2.2 73. Creating-a-Pivot-Table - Lecture – before.xlsx	XLSX	1.23 MB
3. Give your Excel Pivot Tables a makeover.mp4	MP4	11.28 MB
3. Give your Excel Pivot Tables a makeover.srt	SRT	2.37 KB
3.1 74. Formatting-a-Pivot-Table - Lecture - before.xlsx	XLSX	1.43 MB
3.2 74. Formatting-a-Pivot-Table - Lecture - after.xlsx	XLSX	1.43 MB
4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4	MP4	23.01 MB
4. Modifying and pivoting fields to obtain the Pivot Table you need.srt	SRT	4.74 KB
4.1 75. Working-with-Pivot-Tables - Lecture - before.xlsx	XLSX	1.43 MB
4.2 75. Working-with-Pivot-Tables - Lecture - after.xlsx	XLSX	1.88 MB
5. Learn more about GETPIVOTDATA - A very important Excel function.mp4	MP4	18.06 MB
5. Learn more about GETPIVOTDATA - A very important Excel function.srt	SRT	4 KB
5.1 76. GetPivotData - Lecture – after.xlsx	XLSX	1.88 MB
5.2 76. GetPivotData - Lecture - before.xlsx	XLSX	1.88 MB
6. An introduction to slicers - The modern-day Pivot Table filters.mp4	MP4	22.17 MB
6. An introduction to slicers - The modern-day Pivot Table filters.srt	SRT	4.74 KB
6.1 77. Slicers - Lecture - after.xlsx	XLSX	1.88 MB
6.2 77. Slicers - Lecture - before.xlsx	XLSX	1.88 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	MP4	3.13 MB
1. Case study - Build a P&L from scratch - Welcome lecture.srt	SRT	1.59 KB
10. FAQ Sum of FY2018 doens't go down to zero.html	HTML	1.28 KB
11. Use INDEX & MATCH as a substitute for VLOOKUP.mp4	MP4	49.59 MB
11. Use INDEX & MATCH as a substitute for VLOOKUP.srt	SRT	4.25 KB
11.1 87. Index Match-Lecture-before.xlsm	XLSM	41.04 KB
11.2 87. Index Match-Lecture-after.xlsm	XLSM	13.85 MB
12. Mapping the rows in the database sheet.mp4	MP4	32.48 MB
12. Mapping the rows in the database sheet.srt	SRT	2.76 KB
12.1 88. Mapping_before.xlsm	XLSM	50.55 KB
12.2 88. Mapping-Lecture-after.xlsm	XLSM	50.24 KB
13. In case you have any doubts about the Mapping exercise.mp4	MP4	38.57 MB
13. In case you have any doubts about the Mapping exercise.srt	SRT	6.7 KB
13.1 89. Mapping-exercise-explained.pdf	PDF	243.03 KB
13.2 89. Mapping-Lecture-Unsolved.xlsm	XLSM	50.55 KB
13.3 89. Mapping-Lecture-Solved.xlsx	XLSX	47.5 KB
14. Building the structure of the P&L sheet.mp4	MP4	20.85 MB
14. Building the structure of the P&L sheet.srt	SRT	20.87 MB
14.1 90. Building a P&L-Lecture-after.xlsm	XLSM	51.83 KB
14.2 90. Building a P&L-Lecture-before.xlsm	XLSM	50.24 KB
15. Formatting sets You apart from the competition in Excel - A Practical Example.mp4	MP4	25.43 MB
15. Formatting sets You apart from the competition in Excel - A Practical Example.srt	SRT	3.41 KB
15.1 91. Formatting the P&L-Lecture-after.xlsm	XLSM	51.96 KB
15.2 91. Formatting a P&L-Lecture-before.xlsm	XLSM	51.84 KB
16. Populate the P&L sheet with SUMIF.mp4	MP4	30.27 MB
16. Populate the P&L sheet with SUMIF.srt	SRT	3 KB
16.1 92. Formatting the P&L-Lecture-after.xlsm	XLSM	53.51 KB
16.2 92. Formatting the P&L-Lecture-before.xlsm	XLSM	52 KB
17. FAQ Why the sum of the check should be 0.html	HTML	542 B
18. Learn how to find mistakes with COUNTIF.mp4	MP4	27.87 MB
18. Learn how to find mistakes with COUNTIF.srt	SRT	2.8 KB
18.1 93. Countif-Lecture-after.xlsm	XLSM	54.78 KB
18.2 93. Countif-Lecture-before.xlsm	XLSM	53.51 KB
19. Calculating year-on-year percentage variations the proper way.mp4	MP4	29.97 MB
19. Calculating year-on-year percentage variations the proper way.srt	SRT	3.31 KB
19.1 Y-o-Y Function explanation.pdf	PDF	164.92 KB
19.2 94. Adding % variations-Lecture-after.xlsm	XLSM	56.51 KB
19.3 94. Adding % variations-Lecture-before.xlsm	XLSM	54.78 KB
2. Introduction to the case study.mp4	MP4	10.21 MB
2. Introduction to the case study.srt	SRT	1.1 KB
20. FAQ Why do we subtract -1 when calculating year-on-year growth.html	HTML	1.25 KB
3. Understand your data source before you start working on it.mp4	MP4	28.17 MB
3. Understand your data source before you start working on it.srt	SRT	3.17 KB
3.1 80. Get to know the data source.xlsm	XLSM	43.03 KB
4. Order the source worksheets.mp4	MP4	26.54 MB
4. Order the source worksheets.srt	SRT	26.56 MB
4.1 81. Order a worksheet_after.xlsm	XLSM	41.01 KB
4.2 81. Order a worksheet_before.xlsm	XLSM	43.08 KB
5. Create a code the best way to organize your data and work efficiently with it.mp4	MP4	24.48 MB
5. Create a code the best way to organize your data and work efficiently with it.srt	SRT	2.25 KB
5.1 82. Creating a code_before.xlsm	XLSM	41.01 KB
5.2 82. Creating a code_after.xlsm	XLSM	41.73 KB
6. Learn how to create a database.mp4	MP4	20.7 MB
6. Learn how to create a database.srt	SRT	2.13 KB
6.1 83. Creating a database_before.xlsm	XLSM	41.73 KB
6.2 83. Creating a database_after.xlsm	XLSM	39.39 KB
7. Use VLOOKUP to fill the database sheet.mp4	MP4	61.58 MB
7. Use VLOOKUP to fill the database sheet.srt	SRT	5.6 KB
7.1 84. Vlookup_before.xlsm	XLSM	39.5 KB
7.2 84. Vlookup_after.xlsm	XLSM	44.45 KB
8. 50% completed!.mp4	MP4	4.31 MB
8. 50% completed!.srt	SRT	41 B
9. Use SUMIF to complete the database sheet.mp4	MP4	47.95 MB
9. Use SUMIF to complete the database sheet.srt	SRT	4.4 KB
9.1 86. Sumif_before.xlsm	XLSM	44.45 KB
9.2 86. Sumif_after.xlsm	XLSM	49.53 KB

Verify Files.txt

TXT

1.04 KB

[FreeAllCourse.Com].url

URL

52 B

Description

Show full description

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Udemy - ETF Investing 101 - A Beginner's Guide to Building Long-Term Posted by freecoursewb in Other Posted in Other 0 1.1 GB 5 days ago freecoursewb	Size 1.1 GB	Files 15	Age 5 days ago	Seeds 0	Leechs 0	Source
Udemy - Futures Day Trading - Beginner to Funded Prop Firm Trader Posted by freecoursewb in Other Posted in Other 0 294.2 MB 5 days ago freecoursewb	Size 294.2 MB	Files 65	Age 5 days ago	Seeds 0	Leechs 0	Source
Udemy - Claude Code Made Easy - Beginner's Guide to AI Coding Posted by freecoursewb in Other Posted in Other 50 3.9 GB 5 days ago freecoursewb	Size 3.9 GB	Files 82	Age 5 days ago	Seeds 50	Leechs 10	Source
Udemy - Architectural Design Fundamentals - A Beginner ' s Guide Posted by freecoursewb in Other Posted in Other 34 482.6 MB 6 days ago freecoursewb	Size 482.6 MB	Files 14	Age 6 days ago	Seeds 34	Leechs 9	Source
Udemy - Understanding the Gut-Brain Axis - A Quick Beginner Guide Posted by freecoursewb in Other Posted in Other 22 887.8 MB 2 weeks ago freecoursewb	Size 887.8 MB	Files 16	Age 2 weeks ago	Seeds 22	Leechs 3	Source

Udemy - Beginner to Pro in Excel: Financial Modeling and Valuation [FreeAllCourse]

Torrent Contents Size: 6.03 GB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

Tracker name
udp://open.stealth.si:80/announce
udp://tracker.uw0.xyz:6969/announce
udp://tracker.kamigami.org:2710/announce
http://tracker.gbitt.info:80/announce
https://tracker.nanoha.org:443/announce
udp://valakas.rollo.dnsabr.com:2710/announce
udp://xxxtor.com:2710/announce
http://tracker.nyap2p.com:8080/announce
https://tracker.sloppyta.co:443/announce
https://tracker.parrotlinux.org:443/announce
udp://opentracker.i2p.rocks:6969/announce
udp://tracker.zerobytes.xyz:1337/announce
https://tracker.nitrix.me:443/announce
udp://chihaya.de:6969/announce
udp://tracker.zer0day.to:1337/announce
udp://tracker.leechers-paradise.org:6969/announce
udp://coppersurfer.tk:6969/announce