Torrents Search Engine
Search Any Type Of Torrents
Torrent Details
-
[FreeAllCourse.Com] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation
-
0. Websites you may like
-
[FreeAllCourse.Com].url - 52 B
-
-
1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!
-
1. What does the course cover.mp4 - 32.78 MB
-
1. What does the course cover.srt - 4.95 KB
-
1.1 Course Notes - Beginner to Pro in Excel.pdf - 19.03 MB
-
2. Bonus! Welcome gift.html - 171 B
-
3. Welcome gift number 2.html - 171 B
-
4. The best way to take this course.mp4 - 17.62 MB
-
4. The best way to take this course.srt - 2.52 KB
-
5. Download all course materials and frequently asked questions (FAQ).html - 5.37 KB
-
-
10. Introduction to Excel charts
-
1. How to insert a chart in Excel.mp4 - 22.28 MB
-
1. How to insert a chart in Excel.srt - 2.67 KB
-
1.1 95. Inserting-Charts-Lecture.xlsm - 11.45 MB
-
2. Editing Excel charts.mp4 - 26.06 MB
-
2. Editing Excel charts.srt - 2.89 KB
-
2.1 96. Formatting-a-Chart-Lecture.xlsm - 11.45 MB
-
3. Excel chart formatting.mp4 - 32.75 MB
-
3. Excel chart formatting.srt - 3.47 KB
-
3.1 97. Modifying-a-Chart-Lecture.xlsm - 11.41 MB
-
4. How to create a bridge chart in Excel.mp4 - 13.66 MB
-
4. How to create a bridge chart in Excel.srt - 1.89 KB
-
4.1 98. Bridge-Charts-Lecture.xlsx - 13.1 KB
-
5. New ways to visualize your data - Treemap charts.mp4 - 11.5 MB
-
5. New ways to visualize your data - Treemap charts.srt - 1.72 KB
-
5.1 99. Treemap-Charts-Lecture.xlsx - 12.62 KB
-
6. Sparklines.mp4 - 27.56 MB
-
6. Sparklines.srt - 4.25 KB
-
6.1 100. Sparklines-Lecture.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 - 6.21 MB
-
1. Create professional and good-looking charts - Introduction.srt - 662 B
-
2. Build a column stacked chart with a secondary line axis in Excel.mp4 - 46.38 MB
-
2. Build a column stacked chart with a secondary line axis in Excel.srt - 5.7 KB
-
2.1 102. Column stacked chart-Lecture-after.xlsm - 11.51 MB
-
2.2 102. Column stacked chart-Lecture-before.xlsm - 11.51 MB
-
3. Learn how to build effective doughnut charts in Excel.mp4 - 38 MB
-
3. Learn how to build effective doughnut charts in Excel.srt - 5.44 KB
-
3.1 103. Doughnut chart-Lecture-after.xlsm - 11.51 MB
-
3.2 103. Doughnut chart-Lecture-before.xlsm - 11.52 MB
-
4. Learn how to build an area chart in Excel.mp4 - 28.59 MB
-
4. Learn how to build an area chart in Excel.srt - 3.56 KB
-
4.1 104. Area chart-Lecture-after.xlsm - 11.53 MB
-
4.2 104. Area chart-Lecture-before.xlsm - 11.51 MB
-
5. Learn how to create bridge charts.mp4 - 52.07 MB
-
5. Learn how to create bridge charts.srt - 7.61 KB
-
5.1 105. Bridge chart-Lecture-before.xlsm - 11.52 MB
-
5.2 105. Bridge chart-Lecture-after.xlsm - 11.54 MB
-
6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4 - 136.12 MB
-
6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.srt - 12.69 KB
-
6.1 20. Bridge chart_after.xlsm - 11.53 MB
-
6.2 20. Bridge chart_before.xlsm - 11.53 MB
-
7. Case Study - Building a Complete P&L from scratch in Excel.html - 166 B
-
8. Course Challenge - Apply your skills in practice!.mp4 - 7.92 MB
-
8. Course Challenge - Apply your skills in practice!.srt - 1.29 KB
-
8.1 107. Course-Challenge - Unsolved.xlsx - 505.49 KB
-
8.2 107. Course-Challenge - Solved.xlsx - 543.93 KB
-
-
12. Case Study - Building an FMCG Model from Scratch
-
1. Introduction to the Case Study.mp4 - 24.07 MB
-
1. Introduction to the Case Study.srt - 2.58 KB
-
1.1 108. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx - 13.26 MB
-
10. FAQ My GETPIVOTDATA function doesn't work.html - 651 B
-
11. Combining Slicers and GETPIVOTDATA The key to our success.mp4 - 33.62 MB
-
11. Combining Slicers and GETPIVOTDATA The key to our success.srt - 3.62 KB
-
11.1 7. Exercise - Build an FMCG Model_Inserting Slicers_before.xlsx - 20.82 MB
-
11.2 7. Exercise - Build an FMCG Model_Inserting Slicers_after.xlsx - 20.78 MB
-
12. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 - 32.42 MB
-
12. Getting fancy with Excel slicers - Good-looking Excel slicers.srt - 3.61 KB
-
12.1 8. Exercise - Build an FMCG Model_Formatting Slicers_after.xlsx - 18.25 MB
-
12.2 8. Exercise - Build an FMCG Model_Formatting Slicers_before.xlsx - 20.77 MB
-
13. This is how the report can be used in practice by high-level executives.mp4 - 36.15 MB
-
13. This is how the report can be used in practice by high-level executives.srt - 4.66 KB
-
13.1 9. Exercise - Build an FMCG Model_Complete_after.xlsx - 22.82 MB
-
13.2 9. Exercise - Build an FMCG Model_Complete_before.xlsx - 18.26 MB
-
14. Dynamic reporting with GETPIVOTDATA and slicers.html - 170 B
-
2. Preliminary mapping of the data extraction.mp4 - 30.45 MB
-
2. Preliminary mapping of the data extraction.srt - 2.56 KB
-
2.1 1. Exercise - Build an FMCG Model_Mapping_before.xlsx - 13.26 MB
-
2.2 1. Exercise - Build an FMCG Model_Mapping_after.xlsx - 14.89 MB
-
3. Working with an SAP data extraction.mp4 - 37.13 MB
-
3. Working with an SAP data extraction.srt - 4.08 KB
-
4. Creating an output structure of the FMCG model.mp4 - 19.7 MB
-
4. Creating an output structure of the FMCG model.srt - 2.98 KB
-
4.1 2. Exercise - Build an FMCG Model_Layout_before.xlsx - 14.9 MB
-
4.2 2. Exercise - Build an FMCG Model_Layout_after.xlsx - 14.92 MB
-
5. Improving the layout and appearance of the FMCG report.mp4 - 25.36 MB
-
5. Improving the layout and appearance of the FMCG report.srt - 4.94 KB
-
5.1 3. Exercise - Build an FMCG Model_Formatting_before.xlsx - 14.92 MB
-
5.2 3. Exercise - Build an FMCG Model_Formatting_after.xlsx - 14.92 MB
-
6. Inserting formulas and automating calculations.mp4 - 16.15 MB
-
6. Inserting formulas and automating calculations.srt - 4.94 KB
-
6.1 4. Exercise - Build an FMCG Model_Adding Calculations_after.xlsx - 14.92 MB
-
6.2 4. Exercise - Build an FMCG Model_Adding Calculations_before.xlsx - 14.91 MB
-
7. Creating a Master Pivot Table The main data source for the FMCG report.mp4 - 20.14 MB
-
7. Creating a Master Pivot Table The main data source for the FMCG report.srt - 2.21 KB
-
7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table_after.xlsx - 20.81 MB
-
7.2 5. Exercise - Build an FMCG Model_Creating a Pivot Table_before.xlsx - 14.92 MB
-
8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4 - 49.98 MB
-
8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.srt - 7.14 KB
-
8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA_before.xlsx - 20.81 MB
-
8.2 6a. Exercise - Build an FMCG Model_Copying Get Pivot_after.xlsx - 20.82 MB
-
9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4 - 13.76 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.09 MB
-
1. Financial modeling basics - Welcome lecture.srt - 1.1 KB
-
10. Forecasting financials - Quiz.html - 167 B
-
11. Building a complete model - Important considerations.mp4 - 8.45 MB
-
11. Building a complete model - Important considerations.srt - 2.9 KB
-
12. Modeling the Income statement.mp4 - 13.33 MB
-
12. Modeling the Income statement.srt - 7.46 KB
-
13. Modeling the Balance sheet - Part 1.mp4 - 6.15 MB
-
13. Modeling the Balance sheet - Part 1.srt - 3.41 KB
-
14. Modeling the Balance sheet - Part 2.mp4 - 10.6 MB
-
14. Modeling the Balance sheet - Part 2.srt - 6.09 KB
-
15. Building a financial model - Quiz.html - 167 B
-
2. What is a financial model.mp4 - 5.48 MB
-
2. What is a financial model.srt - 2.46 KB
-
3. Why use financial models.mp4 - 10.04 MB
-
3. Why use financial models.srt - 3.31 KB
-
4. Financial modeling - worst practices - things you should avoid.mp4 - 19.92 MB
-
4. Financial modeling - worst practices - things you should avoid.srt - 7.33 KB
-
5. Financial modeling - best practices.mp4 - 17.22 MB
-
5. Financial modeling - best practices.srt - 6.04 KB
-
6. Financial modeling - The types of models that are built in practice.mp4 - 14.26 MB
-
6. Financial modeling - The types of models that are built in practice.srt - 5.84 KB
-
7. Financial modeling - Quiz.html - 167 B
-
8. Financial modeling The right level of detail in a model.mp4 - 7.29 MB
-
8. Financial modeling The right level of detail in a model.srt - 3.1 KB
-
9. Financial modeling Forecasting guidelines.mp4 - 7.12 MB
-
9. Financial modeling Forecasting guidelines.srt - 3.54 KB
-
-
14. Introduction to Company Valuation
-
1. The core theory behind Company Valuation.html - 171 B
-
-
15. Introduction to Mergers & Acquisitions
-
1. Introduction to Mergers & Acquisitions.html - 171 B
-
-
16. Learn how to build a Discounted Cash Flow model in Excel
-
1. Valuation Case study - Welcome lecture.mp4 - 1.78 MB
-
1. Valuation Case study - Welcome lecture.srt - 883 B
-
10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4 - 30.02 MB
-
10. Modeling other items Interest expenses, Extraordinary items and Taxes.srt - 3.05 KB
-
10.1 9. Interest expenses, taxes_after.xlsm - 50.89 KB
-
10.2 9. Interest expenses, taxes_before.xlsm - 50.57 KB
-
11. Forecasting Balance sheet items.mp4 - 4.66 MB
-
11. Forecasting Balance sheet items.srt - 870 B
-
11.1 10. Introduction to Balance sheet items.xlsm - 51.02 KB
-
12. An introduction to the Days methodology.mp4 - 10.08 MB
-
12. An introduction to the Days methodology.srt - 1.85 KB
-
12.1 Working Capital Days.pptx - 94.77 KB
-
13. Calculation of DSO, DPO and DOI for the historical period.mp4 - 12.11 MB
-
13. Calculation of DSO, DPO and DOI for the historical period.srt - 1.39 KB
-
13.1 12. Days calculation_before.xlsm - 51.2 KB
-
13.2 12. Days calculation_after.xlsm - 51.47 KB
-
14. Forecasting DSO, DPO and DOI.mp4 - 20.86 MB
-
14. Forecasting DSO, DPO and DOI.srt - 2.54 KB
-
14.1 13. Forecasting DSO, DPO, DIO_after.xlsm - 51.98 KB
-
14.2 13. Forecasting DSO, DPO, DIO_before.xlsm - 51.47 KB
-
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4 - 22.63 MB
-
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.srt - 2.82 KB
-
15.1 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm - 51.98 KB
-
15.2 14. Forecasting PP&E, Other assets, and Other liabilities_after.xlsm - 52.88 KB
-
16. Creating an output P&L sheet.mp4 - 18.81 MB
-
16. Creating an output P&L sheet.srt - 2.39 KB
-
16.1 15. P&L structure_before.xlsm - 53.6 KB
-
16.2 15. P&L structure_after.xlsm - 53.67 KB
-
17. Populating the output P&L sheet.mp4 - 25.53 MB
-
17. Populating the output P&L sheet.srt - 2.5 KB
-
17.1 16. Populating the P&L sheet_before.xlsm - 53.67 KB
-
17.2 16. Populating the P&L sheet_after.xlsm - 55.32 KB
-
18. Populating the output BS sheet.mp4 - 16.93 MB
-
18. Populating the output BS sheet.srt - 1.78 KB
-
18.1 17. Populating BS sheet_after.xlsm - 57.18 KB
-
18.2 17. Populating BS sheet_before.xlsm - 55.32 KB
-
19. Completing the output BS sheet for the historical period.mp4 - 38.04 MB
-
19. Completing the output BS sheet for the historical period.srt - 4.03 KB
-
19.1 18. Completing the Balance Sheet_before.xlsm - 57.18 KB
-
19.2 18. Completing the Balance Sheet_after.xlsm - 58.1 KB
-
2. Introduction to the DCF exercise.mp4 - 7.88 MB
-
2. Introduction to the DCF exercise.srt - 1.31 KB
-
20. Creating a structure for the calculation of Unlevered free cash flows.mp4 - 22.76 MB
-
20. Creating a structure for the calculation of Unlevered free cash flows.srt - 3.24 KB
-
20.1 19. Cash flow structure_before.xlsm - 58.48 KB
-
20.2 19. Cash flow structure_after.xlsm - 58.58 KB
-
21. Bridging Unlevered free cash flow to Net cash flow.mp4 - 14.57 MB
-
21. Bridging Unlevered free cash flow to Net cash flow.srt - 2.04 KB
-
21.1 20. Bridge UFCF to Net cash flow_before.xlsm - 58.58 KB
-
21.2 20. Bridge UFCF to Net cash flow_after.xlsm - 58.7 KB
-
22. Calculating Unlevered free cash flow.mp4 - 59.73 MB
-
22. Calculating Unlevered free cash flow.srt - 6.57 KB
-
22.1 21. Calculating UFCF_after.xlsm - 59.18 KB
-
22.2 21. Calculating UFCF_before.xlsm - 58.66 KB
-
23. Calculating Net cash flow.mp4 - 37.91 MB
-
23. Calculating Net cash flow.srt - 4.28 KB
-
23.1 22. Calculating Net Cash Flow_before.xlsm - 59.18 KB
-
23.2 Cash Flow Classification By Activities.xlsx - 55.95 KB
-
23.3 22. Calculating Net Cash Flow_after.xlsm - 59.38 KB
-
24. Obtaining the rest of the cash flows through Find and Replace.mp4 - 46.74 MB
-
24. Obtaining the rest of the cash flows through Find and Replace.srt - 4.35 KB
-
24.1 23. Find and replace_before.xlsm - 59.55 KB
-
24.2 23. Find and replace_after.xlsm - 62.5 KB
-
25. Introducing Weighted average cost of capital and Perpetuity growth.mp4 - 13.21 MB
-
25. Introducing Weighted average cost of capital and Perpetuity growth.srt - 2.39 KB
-
25.1 24. Introducing WACC and g_before.xlsm - 62.49 KB
-
25.2 24. Introducing WACC and g_after.xlsm - 62.58 KB
-
26. Discounting Unlevered free cash flows to obtain their Present value.mp4 - 20.23 MB
-
26. Discounting Unlevered free cash flows to obtain their Present value.srt - 3.17 KB
-
26.1 25. Calculating PV of Cash Flows_before.xlsm - 62.58 KB
-
26.2 25. Calculating PV of Cash Flows_after.xlsm - 62.71 KB
-
27. Calculating Continuing value and Enterprise value of the business.mp4 - 17.73 MB
-
27. Calculating Continuing value and Enterprise value of the business.srt - 2.55 KB
-
27.1 26. Calculating CV and EV_before.xlsm - 62.71 KB
-
27.2 26. Calculating CV and EV_after.xlsm - 63.1 KB
-
28. Calculating Equity value.mp4 - 12.2 MB
-
28. Calculating Equity value.srt - 12.22 MB
-
28.1 27. Calculating equity value_after.xlsm - 63.27 KB
-
28.2 27. Calculating equity value_before.xlsm - 63.1 KB
-
29. Sensitivity analysis for WACC and perpetuity growth.mp4 - 40.49 MB
-
29. Sensitivity analysis for WACC and perpetuity growth.srt - 4.57 KB
-
29.1 Sensitivity Analysis.xlsx - 60.81 KB
-
29.2 28. Sensitivity analysis_after.xlsm - 64.83 KB
-
29.3 28. Sensitivity analysis_before.xlsm - 63.27 KB
-
3. The stages of a complete DCF Valuation.mp4 - 49.25 MB
-
3. The stages of a complete DCF Valuation.srt - 7.33 KB
-
3.1 Valuation exercise.pdf - 411.76 KB
-
30. A possible application of Goal seek.mp4 - 15.63 MB
-
30. A possible application of Goal seek.srt - 1.98 KB
-
30.1 29. Goal seek_ater.xlsm - 64.84 KB
-
30.2 29. Goal seek_before.xlsm - 64.83 KB
-
31. Using charts to summarize the results of the DCF model.mp4 - 32.89 MB
-
31.1 30. Charts.xlsm - 101.22 KB
-
32. You made it!.mp4 - 11.26 MB
-
32. You made it!.srt - 2.84 KB
-
4. Description of the structure of the DCF model.mp4 - 18.54 MB
-
4. Description of the structure of the DCF model.srt - 3.33 KB
-
4.1 DCF Model structure.pdf - 240.8 KB
-
4.2 3. Structure of the DCF model.xlsm - 47.9 KB
-
5. A glimpse at the company we are valuing - Cheeseco.mp4 - 15.68 MB
-
5. A glimpse at the company we are valuing - Cheeseco.srt - 1.41 KB
-
5.1 Cheeseco.pptx - 80.09 KB
-
6. Modeling the top line.mp4 - 26.31 MB
-
6. Modeling the top line.srt - 4 KB
-
6.1 5. Modeling revenues_before.xlsm - 47.85 KB
-
6.2 5. Modeling revenues_after.xlsm - 48.16 KB
-
7. Introducing scenarios to the model with Choose.mp4 - 17.83 MB
-
7. Introducing scenarios to the model with Choose.srt - 2.63 KB
-
7.1 6. Choose_before.xlsm - 48.16 KB
-
7.2 6. Choose_after.xlsm - 48.36 KB
-
8. Modeling other items Other revenues and Cogs.mp4 - 44.56 MB
-
8. Modeling other items Other revenues and Cogs.srt - 4.55 KB
-
8.1 7. Other revenues and Cogs_before.xlsm - 48.36 KB
-
8.2 7. Other revenues and Cogs_after.xlsm - 50.08 KB
-
9. Modeling other items Operating expenses and D&A.mp4 - 26.34 MB
-
9. Modeling other items Operating expenses and D&A.srt - 2.77 KB
-
9.1 8. Opex and D&A_after.xlsm - 50.57 KB
-
9.2 8. Opex and D&A_before.xlsm - 50.08 KB
-
-
17. Tesla valuation - Complete practical exercise
-
1. Organizing external inputs in a 'Drivers' sheet.mp4 - 31.01 MB
-
1. Organizing external inputs in a 'Drivers' sheet.srt - 4.37 KB
-
1.1 0a. Drivers_before.xlsx - 1.27 MB
-
1.2 Tesla 2017.pdf - 2.5 MB
-
1.3 Tesla 2016.pdf - 2.21 MB
-
1.4 Tesla Company Valuation - Detailed walkthrough.pdf - 5.09 MB
-
1.5 Tesla 2015.pdf - 1.29 MB
-
1.6 Tesla 2018 Q2.pdf - 635.07 KB
-
1.7 0a. Drivers_after.xlsx - 1.27 MB
-
10. Forecasting 'energy' and 'services' revenue.mp4 - 25.29 MB
-
10. Forecasting 'energy' and 'services' revenue.srt - 3.14 KB
-
10.1 6. Energy and Other revenue - After.xlsx - 1.34 MB
-
10.2 6. Energy and Other revenue - Before.xlsx - 1.34 MB
-
11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4 - 26.81 MB
-
11. Calculating 'energy' and 'services' gross profit and cost of sales.srt - 2.53 KB
-
11.1 7. Energy and Other - Gross profit, cost of sales - Before.xlsx - 1.35 MB
-
11.2 7. Energy and Other - Gross profit, cost of sales - After.xlsx - 1.35 MB
-
12. Forecasting operating expenses.mp4 - 34.91 MB
-
12. Forecasting operating expenses.srt - 5.41 KB
-
12.1 8. Opex - After.xlsx - 1.36 MB
-
12.2 8. Opex - Before.xlsx - 1.36 MB
-
13. Building a fixed asset roll forward estimating Capex.mp4 - 56.58 MB
-
13. Building a fixed asset roll forward estimating Capex.srt - 6.43 KB
-
13.1 9. PP&E forecasting and comparables_after.xlsx - 1.37 MB
-
13.2 9. PP&E forecasting and comparables_before.xlsx - 1.37 MB
-
14. Building a fixed asset roll forward D&A schedule.mp4 - 54.21 MB
-
14. Building a fixed asset roll forward D&A schedule.srt - 4.45 KB
-
14.1 10. PP&E schedule_after.xlsx - 1.37 MB
-
14.2 10. PP&E schedule_before.xlsx - 1.37 MB
-
15. Peer comparison D&A as a percentage of revenues.mp4 - 13.61 MB
-
15. Peer comparison D&A as a percentage of revenues.srt - 1.62 KB
-
15.1 10a. PP&E comparison.xlsx - 1.37 MB
-
16. FAQ Why model D&A as a % of revenues or as a % of beginning PP&E.html - 818 B
-
17. Calculating DSO, DIO, DPO.mp4 - 17.51 MB
-
17. Calculating DSO, DIO, DPO.srt - 2.11 KB
-
17.1 11. Working capital forecasting_before.xlsx - 1.38 MB
-
17.2 11. Working capital forecasting_after.xlsx - 1.52 MB
-
18. Producing a clean P&L output sheet.mp4 - 8.44 MB
-
18. Producing a clean P&L output sheet.srt - 1.62 KB
-
18.1 12. P&L.xlsx - 1.39 MB
-
19. Fill in the P&L output sheet.mp4 - 18.35 MB
-
19. Fill in the P&L output sheet.srt - 1.83 KB
-
19.1 12a. P&L fill in_before.xlsx - 1.39 MB
-
19.2 12a. P&L fill in_after.xlsx - 1.39 MB
-
2. The input data we will work with.mp4 - 15.81 MB
-
2. The input data we will work with.srt - 1.72 KB
-
2.1 0aa. Inputs_after.xlsx - 1.28 MB
-
2.2 0aa. Inputs_before.xlsx - 1.28 MB
-
20. Calculating investments in working capital.mp4 - 19.03 MB
-
20. Calculating investments in working capital.srt - 2.16 KB
-
20.1 13. Calculating working capital_before.xlsx - 1.4 MB
-
20.2 13. Calculating working capital_after.xlsx - 1.4 MB
-
21. Forecasting Unlevered free cash flow.mp4 - 55.94 MB
-
21. Forecasting Unlevered free cash flow.srt - 6.09 KB
-
21.1 14. Cash flow - UFCF_before.xlsx - 1.41 MB
-
21.2 14. Cash flow - UFCF_after.xlsx - 1.41 MB
-
22. Forecasting other assets.mp4 - 45.24 MB
-
22. Forecasting other assets.srt - 4.62 KB
-
22.1 15. Balance Sheet forecasting assets_after.xlsx - 1.41 MB
-
22.2 15. Balance Sheet forecasting assets_before.xlsx - 1.41 MB
-
23. Forecasting other liabilities.mp4 - 21.96 MB
-
23. Forecasting other liabilities.srt - 2.36 KB
-
23.1 16. Balance Sheet forecasting liabilities_before.xlsx - 1.41 MB
-
23.2 16. Balance Sheet forecasting liabilities_after.xlsx - 1.42 MB
-
24. Completing Unlevered free cash flow.mp4 - 40.89 MB
-
24. Completing Unlevered free cash flow.srt - 3.71 KB
-
24.1 16a. Complete UFCF_before.xlsx - 1.42 MB
-
24.2 16a. Complete UFCF_after.xlsx - 1.42 MB
-
25. Modeling Tesla's financing needs in the forecast period.mp4 - 42.36 MB
-
25. Modeling Tesla's financing needs in the forecast period.srt - 5.64 KB
-
25.1 17. Financing_before.xlsx - 1.43 MB
-
25.2 17. Financing_after.xlsx - 1.43 MB
-
26. Calculating Net income.mp4 - 14.81 MB
-
26. Calculating Net income.srt - 1.39 KB
-
26.1 18. P&L complete_after.xlsx - 1.43 MB
-
26.2 18. P&L complete_before.xlsx - 1.43 MB
-
27. Bridging Unlevered free cash flow to Net cash flow.mp4 - 50.73 MB
-
27. Bridging Unlevered free cash flow to Net cash flow.srt - 4.51 KB
-
27.1 19. Cash flow_complete_after.xlsx - 1.43 MB
-
27.2 19. Cash flow_complete_before.xlsx - 1.43 MB
-
28. Balancing the Balance sheet.mp4 - 13.27 MB
-
28. Balancing the Balance sheet.srt - 1.18 KB
-
28.1 20. Complete the BS_before.xlsx - 1.43 MB
-
28.2 20. Complete the BS_after.xlsx - 1.43 MB
-
29. Estimating Weighted average cost of capital (WACC).mp4 - 44.27 MB
-
29. Estimating Weighted average cost of capital (WACC).srt - 6.77 KB
-
29.1 21. WACC_before.xlsx - 1.43 MB
-
29.2 21. WACC_after.xlsx - 1.43 MB
-
3. Forecasting Tesla's expected deliveries.mp4 - 114.91 MB
-
3. Forecasting Tesla's expected deliveries.srt - 15.38 KB
-
3.1 1. Deliveries_after.xlsx - 1.29 MB
-
3.2 1. Deliveries_before.xlsx - 1.29 MB
-
30. Performing discounted cash flow valuation (DCF).mp4 - 34.91 MB
-
30. Performing discounted cash flow valuation (DCF).srt - 4.06 KB
-
30.1 22. DCF_after.xlsx - 1.44 MB
-
30.2 22. DCF_before.xlsx - 1.52 MB
-
31. Calculating enterprise value, equity value, and price per share.mp4 - 22.55 MB
-
31. Calculating enterprise value, equity value, and price per share.srt - 2.15 KB
-
31.1 23. EV, Equity value, Price per share_after.xlsx - 1.44 MB
-
31.2 23. EV, Equity value, Price per share_before.xlsx - 1.44 MB
-
32. Final comments.mp4 - 44.89 MB
-
32. Final comments.srt - 4.43 KB
-
4. Comparing delivery figures with the ones of industry peers.mp4 - 20.93 MB
-
4. Comparing delivery figures with the ones of industry peers.srt - 3.1 KB
-
4.1 1a. Deliveries development.xlsx - 1.3 MB
-
5. Estimating an average selling price of Tesla vehicles.mp4 - 41.92 MB
-
5. Estimating an average selling price of Tesla vehicles.srt - 5.17 KB
-
5.1 2. Average price_after.xlsx - 1.31 MB
-
5.2 2. Average price_before.xlsx - 1.31 MB
-
6. Calculating automotive revenue.mp4 - 46.57 MB
-
6. Calculating automotive revenue.srt - 4.93 KB
-
6.1 3. Revenue calculation and scenarios - after.xlsx - 1.31 MB
-
6.2 3. Revenue calculation and scenarios - before.xlsx - 1.31 MB
-
7. Peer comparison Gross profit %.mp4 - 17.17 MB
-
7. Peer comparison Gross profit %.srt - 2.72 KB
-
7.1 4. Gross profit automotive.xlsx - 1.32 MB
-
8. Calculating automotive gross profit.mp4 - 27.76 MB
-
8. Calculating automotive gross profit.srt - 2.88 KB
-
8.1 4a. Gross profit automotive - after.xlsx - 1.32 MB
-
8.2 4a. Gross profit automotive - before.xlsx - 1.51 MB
-
9. Calculating automotive cost of sales.mp4 - 17.5 MB
-
9. Calculating automotive cost of sales.srt - 17.52 MB
-
9.1 5. Cost of sales and chart.xlsx - 1.34 MB
-
-
18. Capital budgeting - The theory
-
1. Introduction to Capital budgeting.mp4 - 5.43 MB
-
1. Introduction to Capital budgeting.srt - 1.89 KB
-
2. Why we need Capital budgeting.mp4 - 6.88 MB
-
2. Why we need Capital budgeting.srt - 2.7 KB
-
3. The time value of money.mp4 - 6.69 MB
-
3. The time value of money.srt - 2.78 KB
-
4. Calculating future and present value.mp4 - 13.08 MB
-
4. Calculating future and present value.srt - 6.66 KB
-
5. Calculating cost of equity.mp4 - 19.21 MB
-
5. Calculating cost of equity.srt - 8.01 KB
-
6. Coming up with project-specific beta.mp4 - 9 MB
-
6. Coming up with project-specific beta.srt - 3.83 KB
-
7. Weighted average cost of capital (WACC).mp4 - 5.5 MB
-
7. Weighted average cost of capital (WACC).srt - 2.48 KB
-
8. The type of cash flows we will have in a project.mp4 - 9.34 MB
-
8. The type of cash flows we will have in a project.srt - 4.16 KB
-
9. Estimating the project's cash flows.mp4 - 18.8 MB
-
9. Estimating the project's cash flows.srt - 7.15 KB
-
-
19. Capital Budgeting - A complete Case study
-
1. Introduction to the Capital budgeting exercise.mp4 - 8.63 MB
-
1. Introduction to the Capital budgeting exercise.srt - 3.42 KB
-
10. Finding cost of equity.mp4 - 13.93 MB
-
10. Finding cost of equity.srt - 7.63 KB
-
10.1 8. WACC_unsolved.xlsx - 35.93 KB
-
10.2 8. WACC.xlsx - 38.03 KB
-
11. Discounting the project's cash flows and residual value.mp4 - 25.91 MB
-
11. Discounting the project's cash flows and residual value.srt - 3.76 KB
-
11.1 9. Discounted cash flow.xlsx - 39.74 KB
-
11.2 9. Discounted cash flow_unsolved.xlsx - 38.72 KB
-
12. Performing sensitivity analysis and completing the exercise.mp4 - 43.05 MB
-
12. Performing sensitivity analysis and completing the exercise.srt - 5.56 KB
-
12.1 10. Sensitivity analysis_unsolved.xlsx - 39.7 KB
-
12.2 10. Sensitivity analysis.xlsx - 40.67 KB
-
13. FAQ Data does not change in the DCF sheet, it changes from the Drivers sheet.html - 378 B
-
14. Build a complete capital budgeting model from scratch.html - 170 B
-
15. Congratulations!!.mp4 - 2.31 MB
-
15. Congratulations!!.srt - 1.56 KB
-
2. Organizing an Inputs sheet.mp4 - 11.06 MB
-
2. Organizing an Inputs sheet.srt - 6.59 KB
-
2.1 1. Drivers.xlsx - 11.5 KB
-
3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4 - 9.21 MB
-
3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.srt - 4.26 KB
-
3.1 2. Savings Forecast_unsolved.xlsx - 14.74 KB
-
3.2 2. Savings Forecast.xlsx - 16.58 KB
-
4. Fixed asset rollforward.mp4 - 12.16 MB
-
4. Fixed asset rollforward.srt - 5.55 KB
-
4.1 3. Fixed Asset Rollforward_unsolved.xlsx - 18.54 KB
-
4.2 3. Fixed Asset Rollforward.xlsx - 19.66 KB
-
5. The impact of working capital.mp4 - 5.36 MB
-
5. The impact of working capital.srt - 3.03 KB
-
5.1 4. Working Capital_unsolved.xlsx - 21.19 KB
-
5.2 4. Working Capital.xlsx - 21.93 KB
-
6. Modeling debt financing.mp4 - 6.18 MB
-
6. Modeling debt financing.srt - 3.43 KB
-
6.1 5. Financing_unsolved.xlsx - 29.99 KB
-
6.2 5. Financing.xlsx - 30.97 KB
-
7. Adding a P&L sheet.mp4 - 4.88 MB
-
7. Adding a P&L sheet.srt - 2.23 KB
-
7.1 6. P&L_unsolved.xlsx - 29.7 KB
-
7.2 6. P&L.xlsx - 31.03 KB
-
8. Calculating project cash flows.mp4 - 10.15 MB
-
8. Calculating project cash flows.srt - 3.98 KB
-
8.1 7. Cash flow.xlsx - 31.36 KB
-
8.2 7. Cash flow_unsolved.xlsx - 29.64 KB
-
9. Estimating the weighted average cost of capital (WACC).mp4 - 5.58 MB
-
9. Estimating the weighted average cost of capital (WACC).srt - 3.52 KB
-
9.1 8. WACC.xlsx - 38.03 KB
-
9.2 8. WACC_unsolved.xlsx - 35.93 KB
-
-
2. Introduction to Excel
-
1. Introduction to Excel.mp4 - 1.99 MB
-
1. Introduction to Excel.srt - 925 B
-
10. Introduction to Excel formulas.html - 167 B
-
11. Introduction to Excel functions.mp4 - 18.69 MB
-
11. Introduction to Excel functions.srt - 3.97 KB
-
11.1 13. Functions- Exercise_after.xlsx - 81.1 KB
-
11.2 13. Functions - Lecture_after.xlsx - 9.34 KB
-
11.3 13. Functions-Exercise_before.xlsx - 13.26 KB
-
11.4 13. Functions- Lecture_before.xlsx - 9.24 KB
-
11.5 Introduction to Excel.pdf - 2.03 MB
-
12. Cut, copy, & paste.mp4 - 12.99 MB
-
12. Cut, copy, & paste.srt - 2.32 KB
-
12.1 14. Copy-Cut-Paste-Exercise_after.xlsx - 12.56 KB
-
12.2 Introduction to Excel.pdf - 2.03 MB
-
12.3 14. Copy-Cut-Paste-Exercise_before.xlsx - 11.34 KB
-
13. Cut, copy, & paste.html - 167 B
-
14. Paste special.mp4 - 10.88 MB
-
14. Paste special.srt - 1.44 KB
-
14.1 Introduction to Excel.pdf - 2.03 MB
-
14.2 15. Paste-Special-Exercise_before.xlsx - 13.47 KB
-
14.3 15. Paste-Special-Exercise_after.xlsx - 13.46 KB
-
15. Format cells.mp4 - 29.12 MB
-
15. Format cells.srt - 6.51 KB
-
15.1 10. Format cells_before.xlsx - 9.81 KB
-
15.2 10. Format cells_after.xlsx - 9.81 KB
-
16. Basic operations in Excel - 38 pages.html - 171 B
-
2. Overview of Excel.mp4 - 20.69 MB
-
2. Overview of Excel.srt - 4.03 KB
-
2.1 Introduction to Excel.pdf - 2.03 MB
-
2.2 7. Overview-of-Excel-Exercise_before.xlsx - 10.47 KB
-
2.3 7. Overview-of-Excel-Exercise_after.xlsx - 10.88 KB
-
3. Overview of Excel.html - 167 B
-
4. The Excel ribbon.mp4 - 13.58 MB
-
4. The Excel ribbon.srt - 2.67 KB
-
4.1 8. The-Ribbon-Exercise_after.xlsx - 403.25 KB
-
4.2 Introduction to Excel.pdf - 2.03 MB
-
4.3 8. The-Ribbon-Exercise_before.xlsx - 12.09 KB
-
5. Basic operations with rows and columns.mp4 - 11.2 MB
-
5. Basic operations with rows and columns.srt - 1.9 KB
-
5.1 Introduction to Excel.pdf - 2.03 MB
-
5.2 9. Basic Manipulations - Lecture.xlsx - 8.07 KB
-
5.3 9. Basic-Manipulations - Exercise_after.xlsx - 32.43 KB
-
5.4 9. Basic-Manipulations - Exercise_before.xlsx - 11.06 KB
-
6. Data entry in Excel.mp4 - 15.99 MB
-
6. Data entry in Excel.srt - 3.43 KB
-
6.1 Introduction to Excel.pdf - 2.02 MB
-
6.2 10. Data-Entry- Exercise_after.xlsx - 32.76 KB
-
6.3 10. Data-Entry - Lecture.xlsx - 8.07 KB
-
6.4 10. Data-Entry-Exercise_before.xlsx - 10.97 KB
-
7. Introduction to formatting.mp4 - 38.22 MB
-
7. Introduction to formatting.srt - 5.86 KB
-
7.1 11. Formatting- Exercise_after.xlsx - 11.59 KB
-
7.2 11. Formatting- Lecture_before.xlsx - 8.91 KB
-
7.3 11. Formatting-Exercise_before.xlsx - 11.61 KB
-
7.4 Introduction to Excel.pdf - 2.02 MB
-
7.5 11. Formatting - Lecture_after.xlsx - 9.85 KB
-
8. Rows and columns.html - 167 B
-
9. Introduction to Excel formulas.mp4 - 20.67 MB
-
9. Introduction to Excel formulas.srt - 4.39 KB
-
9.1 12. Formulas- Lecture_before.xlsx - 9.3 KB
-
9.2 12. Formulas- Exercise_after.xlsx - 80.13 KB
-
9.3 12. Formulas - Exercise_before.xlsx - 11.72 KB
-
9.4 Introduction to Excel.pdf - 2.03 MB
-
9.5 12. Formulas- Lecture_after.xlsx - 277.47 MB
-
-
20. Next steps
-
1. Next steps.html - 2.29 KB
-
-
21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel
-
1. Overview of Excel.mp4 - 41.17 MB
-
1. Overview of Excel.srt - 4.14 KB
-
1.1 7. Overview-of-Excel-Exercise-Unsolved.xlsx - 10.47 KB
-
1.2 7. Overview-of-Excel-Exercise-Solved.xlsx - 10.88 KB
-
1.3 7. Introduction to Excel.pdf - 2.27 MB
-
2. Basic manipulations with rows and columns.mp4 - 20.42 MB
-
2. Basic manipulations with rows and columns.srt - 2.1 KB
-
2.1 8. Basic-Manipulations - Exercise - Unsolved.xlsx - 11.06 KB
-
2.2 8. Basic-Manipulations - Exercise - Solved.xlsx - 32.43 KB
-
2.3 8. Basic manipulations - Lecture.xlsx - 8.07 KB
-
3. The Excel ribbon.mp4 - 28.91 MB
-
3. The Excel ribbon.srt - 3.2 KB
-
3.1 9. The-Ribbon-Exercise-Exercise - Unsolved.xlsx - 12.09 KB
-
3.2 9. The-Ribbon-Exercise-Solved.xlsx - 403.25 KB
-
4. Data entry in Excel.mp4 - 31.5 MB
-
4. Data entry in Excel.srt - 3.53 KB
-
4.1 10. Data-Entry-Exercise - Unsolved.xlsx - 10.97 KB
-
4.2 10. Data-Entry- Exercise -Solved.xlsx - 32.76 KB
-
4.3 10. Data-Entry - Lecture.xlsx - 8.07 KB
-
5. Introduction to formatting.mp4 - 75.39 MB
-
5. Introduction to formatting.srt - 6.64 KB
-
5.1 11. Formatting-Exercise - Unsolved.xlsx - 11.61 KB
-
5.2 11. Formatting - Lecture - Solved.xlsx - 9.85 KB
-
5.3 11. Formatting- Exercise - Solved.xlsx - 11.59 KB
-
5.4 11. Formatting- Lecture - Unsolved.xlsx - 8.91 KB
-
6. Introduction to Excel formulas.mp4 - 18.77 MB
-
6. Introduction to Excel formulas.srt - 4.28 KB
-
6.1 12. Formulas- Lecture - Unsolved.xlsx - 9.3 KB
-
6.2 12. Formulas- Exercise - Solved.xlsx - 80.13 KB
-
6.3 Introduction-to-Excels-basic-features.pdf - 2.26 MB
-
6.4 12. Formulas - Exercise - Unsolved.xlsx - 11.72 KB
-
6.5 12. Formulas- Lecture - Solved.xlsx - 9.36 KB
-
7. Introduction to Excel functions.mp4 - 37.13 MB
-
7. Introduction to Excel functions.srt - 4.68 KB
-
7.1 Introduction-to-Excels-basic-features.pdf - 2.27 MB
-
7.2 13. Functions - Lecture -Solved.xlsx - 9.34 KB
-
7.3 13. Functions-Exercise - Unsolved.xlsx - 13.26 KB
-
7.4 13. Functions- Lecture - Unsolved.xlsx - 9.24 KB
-
7.5 13. Functions- Exercise - Solved.xlsx - 81.1 KB
-
8. Cut, copy, & paste.mp4 - 7.56 MB
-
8. Cut, copy, & paste.srt - 2.41 KB
-
8.1 14. Copy-Cut-Paste-Exercise - Solved.xlsx - 12.56 KB
-
8.2 Introduction-to-Excels-basic-features.pdf - 2.27 MB
-
8.3 14. Copy-Cut-Paste-Exercise - Unsolved.xlsx - 11.34 KB
-
9. Paste special.mp4 - 6.7 MB
-
9. Paste special.srt - 1.57 KB
-
9.1 15. Paste-Special-Exercise - Solved.xlsx - 13.46 KB
-
9.2 Introduction-to-Excels-basic-features.pdf - 2.26 MB
-
9.3 15. Paste-Special-Exercise - Unsolved.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 - 7.98 MB
-
1. Initial formatting of an Excel sheet to render it professional.srt - 2.3 KB
-
1.1 18. Formatting-a-Worksheet-Exercise - Solved.xlsx - 10.76 KB
-
1.2 Useful-Tips-Tools.pdf - 3.3 MB
-
1.3 18. Formatting-a-Worksheet-Exercise - Unsolved.xlsx - 10.63 KB
-
1.4 18. Formatting-a-worksheet-Lecture - Solved.xlsx - 9.56 KB
-
1.5 18. Formatting-a-worksheet-Lecture - Unsolved.xlsx - 8.98 KB
-
10. Find and select special types of cells with Select Special (F5).mp4 - 9.78 MB
-
10. Find and select special types of cells with Select Special (F5).srt - 1.95 KB
-
10.1 26. Select-Special-F5-Exercise - Unsolved.xlsx - 21.59 KB
-
10.2 26. Select-Special-Lecture.xlsx - 10.56 KB
-
10.3 Useful-Tips-Tools.pdf - 3.3 MB
-
10.4 26. Select-Special-F5-Exercise - Solved.xlsx - 22.27 KB
-
11. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4 - 5.42 MB
-
11. Assign custom formats to specific cells within a financial model (e.g Multiples).srt - 1.98 KB
-
11.1 29. Assigning Custom Formats - Exercise - Solved.xlsx - 11.08 KB
-
11.2 Useful-Tips-Tools.pdf - 3.3 MB
-
11.3 29. Assigning Custom Formats - Exercise - Unsolved.xlsx - 11.35 KB
-
12. Define a named range in Excel.mp4 - 5.43 MB
-
12. Define a named range in Excel.srt - 1.7 KB
-
12.1 28. Defining-a-Named-Range-Exercise - Solved.xlsx - 11.65 KB
-
12.2 28. Naming-ranges-Lecture - Unsolved.xlsx - 8.79 KB
-
12.3 28. Naming-ranges-Lecture - Solved.xlsx - 10.34 KB
-
12.4 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx - 11.07 KB
-
12.5 Useful-Tips-Tools.pdf - 3.3 MB
-
13. Learn how to organize your data with Text to Columns.mp4 - 12.53 MB
-
13. Learn how to organize your data with Text to Columns.srt - 2.34 KB
-
13.1 Useful-Tips-Tools.pdf - 3.31 MB
-
13.2 23.Text-to-columns-Lecture - Solved.xlsx - 9.9 KB
-
13.3 23. Text-to-Columns-Exercise - Solved.xlsx - 11.3 KB
-
13.4 23. Text-to-columns-Lecture - Unsolved.xlsx - 9.76 KB
-
13.5 23. Text-to-Columns-Exercise - Unsolved.xlsx - 10.57 KB
-
14. Learn how to assign dynamic names within a financial model.mp4 - 7.32 MB
-
14. Learn how to assign dynamic names within a financial model.srt - 1.64 KB
-
14.1 27. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx - 11.23 KB
-
14.2 27. Dynamic-Naming-Lecture - Solved.xlsx - 13.83 KB
-
14.3 Useful-Tips-Tools.pdf - 3.3 MB
-
14.4 27. Dynamic-Naming-Lecture - Unsolved.xlsx - 13.54 KB
-
14.5 27. Assigning-Dynamic-Names-Exercise - Solved.xlsx - 11.73 KB
-
15. Create easily printable documents in Excel by using Set Print Area.mp4 - 4.74 MB
-
15. Create easily printable documents in Excel by using Set Print Area.srt - 1.59 KB
-
15.1 Useful-Tips-Tools.pdf - 3.3 MB
-
15.2 25. Set-Print-Area-Lecture - Unsolved.xlsx - 11.42 KB
-
15.3 25. Set-Print-Area-Lecture - Solved.xlsx - 11.22 KB
-
16. Using the 'Alt + Enter' combination.mp4 - 3.33 MB
-
16. Using the 'Alt + Enter' combination.srt - 1.04 KB
-
16.1 22. Alt-Enter-Exercise - Solved.xlsx - 11.4 KB
-
16.2 22. Alt-Enter- Lecture - Solved.xlsx - 9.65 KB
-
16.3 22. Alt-Enter- Lecture - Unsolved.xlsx - 9.64 KB
-
16.4 22. Alt-Enter-Exercise - Unsolved.xlsx - 11.12 KB
-
2. Fast scrolling through Excel sheets.mp4 - 22.17 MB
-
2. Fast scrolling through Excel sheets.srt - 1.82 KB
-
2.1 19. Fast-Scrolling-Exercise - Solved.xlsx - 44.35 KB
-
2.2 Useful-Tips-Tools.pdf - 3.3 MB
-
2.3 19. Fast-Scrolling-Exercise - Unsolved.xlsx - 43.9 KB
-
2.4 19. Fast-Scrolling - Lecture.xlsx - 642.82 KB
-
3. Introduction to fixing of cell references.mp4 - 20.37 MB
-
3. Introduction to fixing of cell references.srt - 2.69 KB
-
3.1 21. Fixing-references-Lecture - Solved.xlsx - 645.17 KB
-
3.2 21. Fixing-Cells-Exercise - Unsolved.xlsx - 10.67 KB
-
3.3 Useful-Tips-Tools.pdf - 3.3 MB
-
3.4 21. Fixing-Cells-Exercise - Solved.xlsx - 10.82 KB
-
3.5 21. Fixing-references-Lecture - Unsolved.xlsx - 643.98 KB
-
4. Learn how to use the Wrap Text button.mp4 - 2.15 MB
-
4. Learn how to use the Wrap Text button.srt - 903 B
-
4.1 24. Wrap-text-Lecture - Solved.xlsx - 9.61 KB
-
4.2 Useful-Tips-Tools.pdf - 3.3 MB
-
4.3 24. Wrap-Text-Exercise - Solved.xlsx - 10.2 KB
-
4.4 24. Wrap-text-Lecture - Unsolved.xlsx - 9.61 KB
-
4.5 24. Wrap-Text-Exercise - Unsolved.xlsx - 10.17 KB
-
5. Create a drop-down list by using Data Validation.mp4 - 10.59 MB
-
5. Create a drop-down list by using Data Validation.srt - 2.22 KB
-
5.1 32. Data-Validation-Lecture - Solved.xlsx - 10.84 KB
-
5.2 32. Drop-down-List-Exercise - Solved.xlsx - 77.02 KB
-
5.3 Useful-Tips-Tools.pdf - 3.3 MB
-
5.4 32. Data-Validation-Lecture - Unsolved.xlsx - 10.84 KB
-
5.5 32. Drop-down-List-Exercise - Unsolved.xlsx - 11.34 KB
-
6. Using Custom-sort in order to sort multiple columns within a table.mp4 - 9.14 MB
-
6. Using Custom-sort in order to sort multiple columns within a table.srt - 1.68 KB
-
6.1 33. Custom-Sort-Exercise - Solved.xlsx - 11.46 KB
-
6.2 33. Sort-data-Lecture - Solved.xlsx - 145.65 KB
-
6.3 33. Sort-data-Lecture - Unsolved.xlsx - 145.35 KB
-
6.4 33. Custom-Sort-Exercise - Unsolved.xlsx - 11.37 KB
-
6.5 Useful-Tips-Tools.pdf - 3.3 MB
-
7. Create a great Index page at the beginning of your models - Hyperlinks.mp4 - 5.35 MB
-
7. Create a great Index page at the beginning of your models - Hyperlinks.srt - 1.6 KB
-
7.1 34. Hyperlinks-Exercise - Unsolved.xlsx - 136.89 KB
-
7.2 34. Hyperlinks-Exercise - Solved.xlsx - 137.06 KB
-
7.3 Useful-Tips-Tools.pdf - 3.3 MB
-
8. Fix the top row of your table with Freeze Panes.mp4 - 17.67 MB
-
8. Fix the top row of your table with Freeze Panes.srt - 1.5 KB
-
8.1 35. Freeze-Panes-Lecture - Solved.xlsx - 643.94 KB
-
8.2 Useful-Tips-Tools.pdf - 3.3 MB
-
8.3 35. Freeze-Panes-Lecture - Unsolved.xlsx - 643.87 KB
-
9. Macros are a great timesaver! Here's why!.mp4 - 11.1 MB
-
9. Macros are a great timesaver! Here's why!.srt - 3.57 KB
-
9.1 Useful-Tips-Tools.pdf - 3.3 MB
-
9.2 30. Macros-Exercise - Solved.xlsx - 145.02 KB
-
9.3 30. Creating-a-Macro-Lecture - Solved.xlsx - 11.17 KB
-
9.4 30. Creating-a-Macro-Lecture - Unsolved.xlsx - 9.66 KB
-
9.5 30. Macros-Exercise - Unsolved.xlsx - 10.34 KB
-
-
23. APPENDIX - Microsoft Excel 2010 - Keyboard shortcuts
-
1. Keyboard shortcuts Save LOTS of time in Excel 2010.mp4 - 30.43 MB
-
1. Keyboard shortcuts Save LOTS of time in Excel 2010.srt - 5.53 KB
-
-
3. Useful tips and tools for your work in Excel
-
1. Excel best practices - Welcome lecture.mp4 - 2.14 MB
-
1. Excel best practices - Welcome lecture.srt - 1.04 KB
-
1.1 Useful Tips & Tools.pdf - 3.06 MB
-
10. Learn how to organize your data with text to columns.html - 167 B
-
11. The wrap text button.mp4 - 3.66 MB
-
11. The wrap text button.srt - 914 B
-
11.1 Wrap-Text-Exercise - Solved.xlsx - 10.2 KB
-
11.2 Wrap-Text-Exercise - Unsolved.xlsx - 10.17 KB
-
11.3 Wrap-text-Lecture - Solved.xlsx - 9.61 KB
-
11.4 Wrap-text-Lecture - Unsolved.xlsx - 9.61 KB
-
12. Set print area.mp4 - 7.58 MB
-
12. Set print area.srt - 1.5 KB
-
12.1 Set-Print-Area-Lecture - Unsolved.xlsx - 11.79 KB
-
12.2 Set-Print-Area-Lecture - Solved.xlsx - 11.22 KB
-
13. Custom sort helps you sort multiple columns in Excel tables.mp4 - 11.18 MB
-
13. Custom sort helps you sort multiple columns in Excel tables.srt - 1.67 KB
-
13.1 Sort-data-Lecture - Unsolved.xlsx - 145.35 KB
-
13.2 Custom-Sort-Exercise - Unsolved.xlsx - 11.37 KB
-
13.3 Custom-Sort-Exercise - Solved.xlsx - 11.46 KB
-
13.4 Sort-data-Lecture - Solved.xlsx - 145.65 KB
-
14. Create drop-down lists with data validation.mp4 - 14.13 MB
-
14. Create drop-down lists with data validation.srt - 1.91 KB
-
14.1 Drop-down-List-Exercise - Unsolved.xlsx - 11.34 KB
-
14.2 Data-Validation-Lecture - Solved.xlsx - 11.26 KB
-
14.3 Drop-down-List-Exercise - Solved.xlsx - 77.02 KB
-
14.4 Data-Validation-Lecture - Unsolved.xlsx - 11.18 KB
-
15. Find and select special types of cells with Select special (F5).mp4 - 13.92 MB
-
15. Find and select special types of cells with Select special (F5).srt - 1.72 KB
-
15.1 Select-Special-Lecture.xlsx - 10.56 KB
-
15.2 Select-Special-F5-Exercise - Unsolved.xlsx - 21.59 KB
-
15.3 Select-Special-Lecture-Solved.xlsx - 10.91 KB
-
15.4 Select-Special-F5-Exercise - Solved.xlsx - 22.27 KB
-
16. Select Special.html - 167 B
-
17. Assign dynamic names in a financial model.mp4 - 7.73 MB
-
17. Assign dynamic names in a financial model.srt - 1.55 KB
-
17.1 Dynamic-Naming-Lecture - Unsolved.xlsx - 13.71 KB
-
17.2 Assigning-Dynamic-Names-Exercise - Solved.xlsx - 11.73 KB
-
17.3 Assigning-Dynamic-Names-Exercise - Unsolved.xlsx - 11.23 KB
-
17.4 Dynamic-Naming-Lecture - Solved.xlsx - 12.42 KB
-
18. Assigning dynamic names.html - 167 B
-
19. Define a named range in Excel.mp4 - 7.67 MB
-
19. Define a named range in Excel.srt - 1.76 KB
-
19.1 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx - 11.07 KB
-
19.2 28. Defining-a-Named-Range-Exercise - Solved.xlsx - 11.65 KB
-
19.3 28. Naming-ranges-Lecture - Solved.xlsx - 10.34 KB
-
19.4 28. Naming-ranges-Lecture - Unsolved.xlsx - 8.79 KB
-
2. Initial formatting of Excel sheets for a professional layout.mp4 - 11.59 MB
-
2. Initial formatting of Excel sheets for a professional layout.srt - 2.32 KB
-
2.1 Formatting-a-Worksheet-Exercise - Unsolved.xlsx - 10.63 KB
-
2.2 Useful Tips & Tools.pdf - 3.05 MB
-
2.3 Formatting-a-Worksheet-Exercise - Solved.xlsx - 10.76 KB
-
2.4 Formatting-a-worksheet-Lecture - Solved.xlsx - 9.56 KB
-
2.5 Formatting-a-worksheet-Lecture - Unsolved.xlsx - 8.98 KB
-
20. Create a great Index page at the beginning of your models - Hyperlinks.mp4 - 8.57 MB
-
20. Create a great Index page at the beginning of your models - Hyperlinks.srt - 1.44 KB
-
20.1 Hyperlinks-Exercise - Unsolved.xlsx - 136.89 KB
-
20.2 Hyperlinks - Lecture - Unsolved.xlsx - 14.18 KB
-
20.3 Hyperlinks-Exercise - Solved.xlsx - 137.06 KB
-
20.4 Hyperlinks - Lecture - Solved.xlsx - 14.34 KB
-
21. Introduction to custom formatting in Excel.mp4 - 37.96 MB
-
21. Introduction to custom formatting in Excel.srt - 8.06 KB
-
21.1 19. Custom formatting_before.xlsx - 10.69 KB
-
21.2 19. Custom formatting_after.xlsx - 10.75 KB
-
22. Apply custom formatting in a financial model.mp4 - 9.15 MB
-
22. Apply custom formatting in a financial model.srt - 1.59 KB
-
22.1 Custom formats - Lecture - Unsolved.xlsx - 8.33 KB
-
22.2 Custom formats - Lecture - Solved.xlsx - 8.79 KB
-
22.3 Assigning Custom Formats - Exercise - Solved.xlsx - 11.08 KB
-
22.4 Assigning Custom Formats - Exercise - Unsolved.xlsx - 11.35 KB
-
23. Macros are a great timesaver! Here's why!.mp4 - 17.17 MB
-
23. Macros are a great timesaver! Here's why!.srt - 3.11 KB
-
23.1 Recording a Macro - Lecture - Solved.ods - 3.02 KB
-
23.2 Recording a Macro - Lecture - Unsolved.ods - 2.58 KB
-
24. How to save macros and use them across several workbooks.mp4 - 12.79 MB
-
24. How to save macros and use them across several workbooks.srt - 1.68 KB
-
24.1 31. How-to-save-macros-Lecture-after.xlsm - 12.59 KB
-
24.2 31. How-to-save-macros-Lecture-before.xlsx - 6.02 KB
-
24.3 31. Another-file.xlsx - 8.81 KB
-
25. Excel macros - quiz.html - 167 B
-
26. Fix the top row of your table with freeze panes.mp4 - 14.47 MB
-
26. Fix the top row of your table with freeze panes.srt - 1.34 KB
-
26.1 Freeze-Panes-Lecture - Solved.xlsx - 644.18 KB
-
26.2 Freeze-Panes-Lecture - Unsolved.xlsx - 644.18 KB
-
27. How to search functionalities in Excel.mp4 - 7.54 MB
-
27. How to search functionalities in Excel.srt - 853 B
-
27.1 Search.xlsx - 644.18 KB
-
28. Filter by color - an excellent tool.mp4 - 9.87 MB
-
28. Filter by color - an excellent tool.srt - 2.21 KB
-
28.1 36. Exercise-Filter-by-Color-Solved.xlsx - 153.48 KB
-
28.2 36. Exercise-Filter-by-Color-Unsolved.xlsx - 20.47 KB
-
29. Working with conditional formatting.mp4 - 15.09 MB
-
29. Working with conditional formatting.srt - 6.07 KB
-
29.1 Exercise_Conditional Formatting.xlsx - 12.88 KB
-
29.2 Conditional Formatting - Lecture.xlsx - 12.47 KB
-
29.3 Solution_Conditional Formatting.xlsx - 51.52 KB
-
3. Fast scrolling through Excel sheets.mp4 - 17.53 MB
-
3. Fast scrolling through Excel sheets.srt - 1.9 KB
-
3.1 Fast-Scrolling - Lecture.xlsx - 643.69 KB
-
3.2 Fast-Scrolling-Exercise - Solved.xlsx - 44.35 KB
-
3.3 Fast-Scrolling-Exercise - Unsolved.xlsx - 43.9 KB
-
30. Useful tips and tools for your work in Excel - quiz.html - 166 B
-
31. A neat trick - Multiply by 1.mp4 - 14.84 MB
-
31. A neat trick - Multiply by 1.srt - 1.74 KB
-
31.1 38. Multiply-by-1-Lecture-before.xlsx - 16.47 KB
-
31.2 38. Multiply-by-1-Lecture-after.xlsx - 17.21 KB
-
32. Find and replace - references.mp4 - 24.04 MB
-
32. Find and replace - references.srt - 3.45 KB
-
32.1 39. Find-and-Replace-references-Lecture-after.xlsx - 37.91 KB
-
32.2 39. Find-and-Replace-references-Lecture-before.xlsx - 38.79 KB
-
33. FAQ Why do we replace external references and how does this help us.html - 702 B
-
34. Find and replace - formatting.mp4 - 13.78 MB
-
34. Find and replace - formatting.srt - 1.91 KB
-
34.1 40. Find-replace-Lecture-after.xlsx - 17.19 KB
-
34.2 40. Find-replace-Lecture-before.xlsx - 17.19 KB
-
35. Removing (automatic) green arrows.mp4 - 12.6 MB
-
35. Removing (automatic) green arrows.srt - 1.7 KB
-
35.1 41. Green-references-Lecture.xlsx - 12 KB
-
36. Beauty saving - The professional way of saving files.mp4 - 14.03 MB
-
36. Beauty saving - The professional way of saving files.srt - 2.54 KB
-
36.1 42. Beauty-saving-Lecture-after.xlsx - 17.05 KB
-
36.2 42. Beauty-saving-Lecture-before.xlsx - 17.17 KB
-
37. Formula auditing with F2.mp4 - 17.74 MB
-
37. Formula auditing with F2.srt - 2.19 KB
-
37.1 43. F2-Lecture.xlsm - 50.76 KB
-
4. Fast scrolling through Excel sheets.html - 167 B
-
5. Be even quicker F5 + Enter.mp4 - 19.79 MB
-
5. Be even quicker F5 + Enter.srt - 2.16 KB
-
5.1 20. F5-go-to - Lecture.xlsm - 50.76 KB
-
6. Fixing cell references.mp4 - 24.11 MB
-
6. Fixing cell references.srt - 2.5 KB
-
6.1 Fixing-references-Lecture - Unsolved.xlsx - 644.12 KB
-
6.2 Fixing-Cells-Exercise - Unsolved.xlsx - 10.67 KB
-
6.3 Fixing-references-Lecture - Solved.xlsx - 644.55 KB
-
6.4 Fixing-Cells-Exercise - Solved.xlsx - 10.82 KB
-
7. Introduction to fixing of cell references.html - 167 B
-
8. Alt + Enter.mp4 - 4.16 MB
-
8. Alt + Enter.srt - 961 B
-
8.1 Alt-Enter-Exercise - Solved.xlsx - 11.4 KB
-
8.2 Alt-Enter- Lecture - Solved.xlsx - 10.01 KB
-
8.3 Alt-Enter- Lecture - Unsolved.xlsx - 9.95 KB
-
8.4 Alt-Enter-Exercise - Unsolved.xlsx - 11.12 KB
-
9. Organize your data with text to columns.mp4 - 13.95 MB
-
9. Organize your data with text to columns.srt - 2.47 KB
-
9.1 Text-to-columns-Lecture - Solved.xlsx - 10.2 KB
-
9.2 Invoice example.pdf - 44.47 KB
-
9.3 Text-to-Columns-Exercise - Solved.xlsx - 11.3 KB
-
9.4 Text-to-columns-Lecture - Unsolved.xlsx - 9.76 KB
-
9.5 Text-to-Columns-Exercise - Unsolved.xlsx - 10.57 KB
-
-
4. Keyboard shortcuts in Excel
-
1. Keyboard shortcuts save LOTS of time in Excel.mp4 - 51.17 MB
-
1. Keyboard shortcuts save LOTS of time in Excel.srt - 5.9 KB
-
1.1 Beginner to Pro in Excel - Shortcuts for PC.pdf - 1.04 MB
-
1.2 Beginner to Pro in Excel - Shortcuts for MAC.pdf - 447.56 KB
-
2. Keyboard shortcuts in Excel.html - 171 B
-
-
5. Excel's key functions and functionalities made easy
-
1. Excel's key functions - Welcome lecture.mp4 - 2.31 MB
-
1. Excel's key functions - Welcome lecture.srt - 1.11 KB
-
10. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.html - 167 B
-
11. Working with text in Excel.mp4 - 16.01 MB
-
11. Working with text in Excel.srt - 3.08 KB
-
11.1 53. Work-with-text-Lecture-before.xlsx - 10.33 KB
-
11.2 53. Work-with-text-Lecture-after.xlsx - 10.91 KB
-
12. Find the minimum or maximum value in a range of cells in Excel.mp4 - 5.92 MB
-
12. Find the minimum or maximum value in a range of cells in Excel.srt - 1.15 KB
-
12.1 54. MIN-MAX-Exercise - Solved.xlsx - 14.8 KB
-
12.2 54. Max-min-Lecture - Solved.xlsx - 9.23 KB
-
12.3 54. MIN-MAX-Exercise - Unsolved.xlsx - 14.39 KB
-
12.4 54. Max-min-Lecture - Unsolved.xlsx - 8.95 KB
-
13. Include ROUND in your financial models.mp4 - 3.13 MB
-
13. Include ROUND in your financial models.srt - 1.2 KB
-
13.1 55. Round-Exercise - Solved.xlsx - 11.71 KB
-
13.2 55. Round-Exercise - Unsolved.xlsx - 11.34 KB
-
13.3 55. Excel-functions-Lecture.xlsx - 889.91 KB
-
13.4 Excel-Functions.pdf - 3.18 MB
-
14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4 - 34.6 MB
-
14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.srt - 9.02 KB
-
14.1 56. Vlookup-Hlookup-Exercise - Unsolved.xlsx - 11.95 KB
-
14.2 56. Vlookup-Hlookup- Lecture - Unsolved.xlsx - 10.74 KB
-
14.3 Excel-Functions.pdf - 3.19 MB
-
14.4 56. Vlookup-Hlookup-Exercise - Solved.xlsx - 13.68 KB
-
14.5 56. Vlookup-Hlookup- Lecture - Solved.xlsx - 11.13 KB
-
15. How to enlarge the formula bar.mp4 - 6.25 MB
-
15. How to enlarge the formula bar.srt - 1.4 KB
-
15.1 57. Enlarge-the-formula-bar-Lecture.xlsm - 46.89 KB
-
16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4 - 38.95 MB
-
16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.srt - 8.83 KB
-
16.1 58. Index-Match-Lecture - Solved.xlsx - 11.7 KB
-
16.2 58. Index-Match-Exercise - Solved.xlsx - 12.08 KB
-
16.3 58. Index-Match-Exercise - Unsolved.xlsx - 11.59 KB
-
16.4 58. Index-Match-Lecture - Unsolved.xlsx - 11.29 KB
-
16.5 Excel-Functions.pdf - 3.18 MB
-
17. A great Excel technique INDEX, MATCH, MATCH.mp4 - 11.77 MB
-
17. A great Excel technique INDEX, MATCH, MATCH.srt - 5.65 KB
-
17.1 59. Exercise-Index-Match-Match-Unsolved.xlsx - 11.58 KB
-
17.2 59. Exercise-Index-Match-Match-Solved.xlsx - 12.21 KB
-
17.3 Index, Match, Match - Lecture.xlsx - 22.32 KB
-
18. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.html - 167 B
-
19. Using Excel's IFERROR function to trap spreadsheet errors.mp4 - 7.52 MB
-
19. Using Excel's IFERROR function to trap spreadsheet errors.srt - 2.18 KB
-
19.1 60. Iferror - Lecture - Unsolved.xlsm - 897.26 KB
-
19.2 60. Iferror - Lecture - Solved.xlsm - 896.43 KB
-
19.3 Excel-Functions.pdf - 3.18 MB
-
19.4 60. Iferror-Exercise - Unsolved.xlsx - 14.26 KB
-
19.5 60. Iferror-Exercise - Solved.xlsx - 15.37 KB
-
2. A helpful consideration.html - 1.1 KB
-
20. RANK is a valuable tool when using Excel for financial and business analysis.mp4 - 23.25 MB
-
20. RANK is a valuable tool when using Excel for financial and business analysis.srt - 2.86 KB
-
20.1 61. Rank-function-Lecture-before.xlsx - 12.27 KB
-
20.2 61. Rank-function-Lecture-after.xlsx - 12.61 KB
-
21. Learn how to render your models flexible with CHOOSE.mp4 - 8.98 MB
-
21. Learn how to render your models flexible with CHOOSE.srt - 2.81 KB
-
21.1 62. Choose-Exercise-Solved.xlsx - 11.73 KB
-
21.2 62. Choose-Lecture - Solved.xlsx - 9.69 KB
-
21.3 62. Choose-Lecture - Unsolved.xlsx - 9.33 KB
-
21.4 Excel-Functions.pdf - 3.18 MB
-
21.5 62. Choose-Exercise - Unsolved.xlsx - 11.32 KB
-
22. Use Goal Seek to find the result that you are looking for.mp4 - 7.86 MB
-
22. Use Goal Seek to find the result that you are looking for.srt - 7.86 MB
-
22.1 63. Goal-Seek-Lecture - Solved.xlsx - 9.17 KB
-
22.2 63. Goal-Seek-Exercise-Solved.xlsx - 16.21 KB
-
22.3 Excel-Functions.pdf - 3.18 MB
-
22.4 63. Goal-Seek-Lecture - Unsolved.xlsx - 9.15 KB
-
22.5 63. Goal-Seek-Exercise - Unsolved.xlsx - 16.09 KB
-
23. Use Goal Seek in order to find the result that you are looking for.html - 167 B
-
24. Include sensitivity analysis in your models through Data Tables.mp4 - 14.29 MB
-
24. Include sensitivity analysis in your models through Data Tables.srt - 4.95 KB
-
24.1 64. Sensitivity analysis - Lecture - Unsolved.xlsm - 897.09 KB
-
24.2 64. Sensitivity-analysis-Exercise-Solved.xlsm - 63.87 KB
-
24.3 64. Sensitivity-analysis-Exercise-Unsolved.xlsm - 66.82 KB
-
24.4 64. Sensitivity analysis - Lecture - Solved.xlsm - 897.3 KB
-
25. Include sensitivity analysis in your models through Data Tables.html - 167 B
-
26. Excel's dynamic and interactive tables Pivot tables.mp4 - 23.2 MB
-
26. Excel's dynamic and interactive tables Pivot tables.srt - 2.61 KB
-
26.1 65. Pivot Tables - Exercise - Solved.xlsx - 190.47 KB
-
26.2 65. Pivot tables - Lecture - Unsolved.xlsm - 687.83 KB
-
26.3 65. Pivot Tables - Exercise - Unsolved.xlsx - 152.17 KB
-
26.4 65. Pivot tables - Lecture - Solved.xlsm - 897.26 KB
-
27. Excel's key functions and functionalities made easy.html - 166 B
-
3. Key functions in Excel IF.mp4 - 16.65 MB
-
3. Key functions in Excel IF.srt - 2.95 KB
-
3.1 Key functions - Excel.pdf - 8.47 MB
-
3.2 47. IF-function--Lecture-before.xlsm - 17 KB
-
3.3 47. IF-function-Lecture-after.xlsm - 17.94 KB
-
3.4 Functions - English to Spanish.pdf - 102.37 KB
-
3.5 Functions - English to German.pdf - 102.32 KB
-
3.6 Functions - English to Portuguese.pdf - 146.09 KB
-
4. Key Excel functions SUM, SUMIF and SUMIFS.mp4 - 19.32 MB
-
4. Key Excel functions SUM, SUMIF and SUMIFS.srt - 5.27 KB
-
4.1 48. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx - 14.46 KB
-
4.2 48. Sum-Sumif-Sumifs-Lecture - Solved.xlsx - 13.01 KB
-
4.3 48. Sum-Sumif-Sumifs-Exercise - Solved.xlsx - 14.84 KB
-
4.4 48. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx - 12.93 KB
-
4.5 Excel-Functions.pdf - 3.19 MB
-
5. = and + are interchangeable when you start typing a formula.mp4 - 5.79 MB
-
5. = and + are interchangeable when you start typing a formula.srt - 974 B
-
5.1 49. = and + are interchangeable - before.xlsm - 17.01 KB
-
5.2 49. = and + are interchangeable -after.xlsm - 17.04 KB
-
6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 - 16.99 MB
-
6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.srt - 4.8 KB
-
6.1 50.Counts-Exercise-Unsolved.xlsx - 15.56 KB
-
6.2 50.Counts-Exercise-Solved.xlsx - 16.07 KB
-
6.3 Lecture-Count-Countif-Countifs-Unsolved.xlsx - 11.29 KB
-
6.4 Excel-Functions.pdf - 3.19 MB
-
6.5 Lecture-Count-Countif-Countifs-Solved.xlsx - 11.68 KB
-
7. Key Excel functions AVERAGE and AVERAGEIF.mp4 - 7.85 MB
-
7. Key Excel functions AVERAGE and AVERAGEIF.srt - 2.38 KB
-
7.1 Excel-Functions.pdf - 3.19 MB
-
7.2 51. Average-Averageif- Lecture - Unsolved.xlsx - 9.03 KB
-
7.3 51. Average-AverageIF-Exercise - Unsolved.xlsx - 14.6 KB
-
7.4 51. Average-AverageIF-Exercise - Solved.xlsx - 15.02 KB
-
7.5 51. Average-Averageif- Lecture - Solved.xlsx - 9.4 KB
-
8. Key Excel functions AVERAGE and AVERAGEIF.html - 167 B
-
9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4 - 16.79 MB
-
9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.srt - 5.66 KB
-
9.1 52. Text functions - Exercise - Unsolved.xlsx - 11.71 KB
-
9.2 52. Text-Functions- Lecture - Unsolved.xlsx - 10.6 KB
-
9.3 52. Text-Functions- Lecture - Solved.xlsx - 11.1 KB
-
9.4 52. Text functions - Exercise - Solved.xlsx - 12.24 KB
-
-
6. Update! SUMIFS - Exercise
-
1. Exercise - Excel's SUMIFS function - unsolved.html - 171 B
-
2. Exercise - Excel's SUMIFS function - solved & explained.mp4 - 35.32 MB
-
2. Exercise - Excel's SUMIFS function - solved & explained.srt - 10.69 KB
-
2.1 67. Exercise-Sumifs-With-Solutions.xlsx - 1.29 MB
-
-
7. Financial functions in Excel
-
1. Future and present values in Excel.mp4 - 14.97 MB
-
1. Future and present values in Excel.srt - 6.94 KB
-
1.1 68. FV and PV-Lecture.xlsx - 10.64 KB
-
2. Calculating the rate of return of an investment with the IRR function.mp4 - 7.58 MB
-
2. Calculating the rate of return of an investment with the IRR function.srt - 3.65 KB
-
2.1 69. Exercise-IRR-Unsolved.xlsx - 11.52 KB
-
2.2 69. IRR-Lecture.xlsx - 11.2 KB
-
2.3 69. Exercise-IRR-Solved.xlsx - 12.31 KB
-
3. Calculating a complete loan schedule in Excel.mp4 - 14.82 MB
-
3. Calculating a complete loan schedule in Excel.srt - 6.52 KB
-
3.1 70. Loan Schedule-Lecture.xlsx - 20.17 KB
-
3.2 70. Exercise-Loan-Schedule-Solved.xlsx - 22.68 KB
-
3.3 70. Exercise-Loan-Schedule-Unsolved.xlsx - 15.81 KB
-
4. Date functions in Excel.mp4 - 11.36 MB
-
4. Date functions in Excel.srt - 5.79 KB
-
4.1 71. Date Functions-Exercise-Unsolved.xlsx - 11.41 KB
-
4.2 71. Date Functions-Lecture.xlsx - 12.25 KB
-
4.3 71. Date Functions-Exercise-Solved.xlsx - 12.43 KB
-
-
8. Microsoft Excel's Pivot Tables in depth
-
1. Introduction to Pivot Tables and the way they are applied.mp4 - 6 MB
-
1. Introduction to Pivot Tables and the way they are applied.srt - 2.08 KB
-
2. Creating Pivot Tables easily!.mp4 - 19.38 MB
-
2. Creating Pivot Tables easily!.srt - 4.25 KB
-
2.1 73. Creating-a-Pivot-Table - Lecture - after.xlsx - 1.43 MB
-
2.2 73. Creating-a-Pivot-Table - Lecture – before.xlsx - 1.23 MB
-
3. Give your Excel Pivot Tables a makeover.mp4 - 11.28 MB
-
3. Give your Excel Pivot Tables a makeover.srt - 2.37 KB
-
3.1 74. Formatting-a-Pivot-Table - Lecture - before.xlsx - 1.43 MB
-
3.2 74. Formatting-a-Pivot-Table - Lecture - after.xlsx - 1.43 MB
-
4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4 - 23.01 MB
-
4. Modifying and pivoting fields to obtain the Pivot Table you need.srt - 4.74 KB
-
4.1 75. Working-with-Pivot-Tables - Lecture - before.xlsx - 1.43 MB
-
4.2 75. Working-with-Pivot-Tables - Lecture - after.xlsx - 1.88 MB
-
5. Learn more about GETPIVOTDATA - A very important Excel function.mp4 - 18.06 MB
-
5. Learn more about GETPIVOTDATA - A very important Excel function.srt - 4 KB
-
5.1 76. GetPivotData - Lecture – after.xlsx - 1.88 MB
-
5.2 76. GetPivotData - Lecture - before.xlsx - 1.88 MB
-
6. An introduction to slicers - The modern-day Pivot Table filters.mp4 - 22.17 MB
-
6. An introduction to slicers - The modern-day Pivot Table filters.srt - 4.74 KB
-
6.1 77. Slicers - Lecture - after.xlsx - 1.88 MB
-
6.2 77. Slicers - Lecture - before.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 - 3.13 MB
-
1. Case study - Build a P&L from scratch - Welcome lecture.srt - 1.59 KB
-
10. FAQ Sum of FY2018 doens't go down to zero.html - 1.28 KB
-
11. Use INDEX & MATCH as a substitute for VLOOKUP.mp4 - 49.59 MB
-
11. Use INDEX & MATCH as a substitute for VLOOKUP.srt - 4.25 KB
-
11.1 87. Index Match-Lecture-before.xlsm - 41.04 KB
-
11.2 87. Index Match-Lecture-after.xlsm - 13.85 MB
-
12. Mapping the rows in the database sheet.mp4 - 32.48 MB
-
12. Mapping the rows in the database sheet.srt - 2.76 KB
-
12.1 88. Mapping_before.xlsm - 50.55 KB
-
12.2 88. Mapping-Lecture-after.xlsm - 50.24 KB
-
13. In case you have any doubts about the Mapping exercise.mp4 - 38.57 MB
-
13. In case you have any doubts about the Mapping exercise.srt - 6.7 KB
-
13.1 89. Mapping-exercise-explained.pdf - 243.03 KB
-
13.2 89. Mapping-Lecture-Unsolved.xlsm - 50.55 KB
-
13.3 89. Mapping-Lecture-Solved.xlsx - 47.5 KB
-
14. Building the structure of the P&L sheet.mp4 - 20.85 MB
-
14. Building the structure of the P&L sheet.srt - 20.87 MB
-
14.1 90. Building a P&L-Lecture-after.xlsm - 51.83 KB
-
14.2 90. Building a P&L-Lecture-before.xlsm - 50.24 KB
-
15. Formatting sets You apart from the competition in Excel - A Practical Example.mp4 - 25.43 MB
-
15. Formatting sets You apart from the competition in Excel - A Practical Example.srt - 3.41 KB
-
15.1 91. Formatting the P&L-Lecture-after.xlsm - 51.96 KB
-
15.2 91. Formatting a P&L-Lecture-before.xlsm - 51.84 KB
-
16. Populate the P&L sheet with SUMIF.mp4 - 30.27 MB
-
16. Populate the P&L sheet with SUMIF.srt - 3 KB
-
16.1 92. Formatting the P&L-Lecture-after.xlsm - 53.51 KB
-
16.2 92. Formatting the P&L-Lecture-before.xlsm - 52 KB
-
17. FAQ Why the sum of the check should be 0.html - 542 B
-
18. Learn how to find mistakes with COUNTIF.mp4 - 27.87 MB
-
18. Learn how to find mistakes with COUNTIF.srt - 2.8 KB
-
18.1 93. Countif-Lecture-after.xlsm - 54.78 KB
-
18.2 93. Countif-Lecture-before.xlsm - 53.51 KB
-
19. Calculating year-on-year percentage variations the proper way.mp4 - 29.97 MB
-
19. Calculating year-on-year percentage variations the proper way.srt - 3.31 KB
-
19.1 Y-o-Y Function explanation.pdf - 164.92 KB
-
19.2 94. Adding % variations-Lecture-after.xlsm - 56.51 KB
-
19.3 94. Adding % variations-Lecture-before.xlsm - 54.78 KB
-
2. Introduction to the case study.mp4 - 10.21 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.25 KB
-
3. Understand your data source before you start working on it.mp4 - 28.17 MB
-
3. Understand your data source before you start working on it.srt - 3.17 KB
-
3.1 80. Get to know the data source.xlsm - 43.03 KB
-
4. Order the source worksheets.mp4 - 26.54 MB
-
4. Order the source worksheets.srt - 26.56 MB
-
4.1 81. Order a worksheet_after.xlsm - 41.01 KB
-
4.2 81. Order a worksheet_before.xlsm - 43.08 KB
-
5. Create a code the best way to organize your data and work efficiently with it.mp4 - 24.48 MB
-
5. Create a code the best way to organize your data and work efficiently with it.srt - 2.25 KB
-
5.1 82. Creating a code_before.xlsm - 41.01 KB
-
5.2 82. Creating a code_after.xlsm - 41.73 KB
-
6. Learn how to create a database.mp4 - 20.7 MB
-
6. Learn how to create a database.srt - 2.13 KB
-
6.1 83. Creating a database_before.xlsm - 41.73 KB
-
6.2 83. Creating a database_after.xlsm - 39.39 KB
-
7. Use VLOOKUP to fill the database sheet.mp4 - 61.58 MB
-
7. Use VLOOKUP to fill the database sheet.srt - 5.6 KB
-
7.1 84. Vlookup_before.xlsm - 39.5 KB
-
7.2 84. Vlookup_after.xlsm - 44.45 KB
-
8. 50% completed!.mp4 - 4.31 MB
-
8. 50% completed!.srt - 41 B
-
9. Use SUMIF to complete the database sheet.mp4 - 47.95 MB
-
9. Use SUMIF to complete the database sheet.srt - 4.4 KB
-
9.1 86. Sumif_before.xlsm - 44.45 KB
-
9.2 86. Sumif_after.xlsm - 49.53 KB
-
-
Verify Files.txt - 1.04 KB
-
[FreeAllCourse.Com].url - 52 B
-
| Trackers | Seeders | Leechers | Downloads |
|---|---|---|---|
| udp://open.stealth.si:80/announce | 2 | 1 | 699 |
InfoHash:
DE9D26F90F11073D70336B8B3518BDC77D75E446
Last updated:
Jan 23, 2022
File count:
1.02 KB
File Category:
9
Tags:
FreeAllCourse, Valuation, Modeling, Financial, Excel, Pro, Beginner, Other, Tutorials