Torrent details for "Udemy Beginner to Pro in Excel Financial Modeling and Valuation …" Log in to bookmark
Controls:
×
Report Torrent
Please select a reason for reporting this torrent:
Your report will be reviewed by our moderation team.
×
Report Information
Loading report information...
This torrent has been reported 0 times.
Report Summary:
| User | Reason | Date |
|---|
Failed to load report information.
×
Success
Your report has been submitted successfully.
Checked by:
Category:
Language:
English
Total Size:
5.7 GB
Info Hash:
6EFA437E6486BF66436578D3083E9748DFAA1A40
Added By:
Added:
Oct. 27, 2023, 10:37 p.m.
Stats:
|
(Last updated: May 11, 2025, 7:24 p.m.)
| File | Size |
|---|---|
| [CourseClub.Me].url | 48 bytes |
| [DesireCourse.Net].url | 51 bytes |
| 1. What does the course cover.mp4 | 32.8 MB |
| 1. What does the course cover.srt | 4.9 KB |
| 1.1 Course Notes - Beginner to Pro in Excel.pdf | 19.0 MB |
| 2. Bonus! Welcome gift.html | 171 bytes |
| 3. Welcome gift number 2.html | 171 bytes |
| 4. The best way to take this course.mp4 | 17.6 MB |
| 4. The best way to take this course.srt | 2.5 KB |
| 5. Download all course materials and frequently asked questions (FAQ).html | 5.4 KB |
| [CourseClub.Me].url | 48 bytes |
| [DesireCourse.Net].url | 51 bytes |
| 1. How to insert a chart in Excel.mp4 | 22.3 MB |
| 1. How to insert a chart in Excel.srt | 2.7 KB |
| 1.1 95. Inserting-Charts-Lecture.xlsm | 11.5 MB |
| 2. Editing Excel charts.mp4 | 26.1 MB |
| 2. Editing Excel charts.srt | 2.9 KB |
| 2.1 96. Formatting-a-Chart-Lecture.xlsm | 11.5 MB |
| 3. Excel chart formatting.mp4 | 32.7 MB |
| 3. Excel chart formatting.srt | 3.5 KB |
| 3.1 97. Modifying-a-Chart-Lecture.xlsm | 11.4 MB |
| 4. How to create a bridge chart in Excel.mp4 | 13.7 MB |
| 4. How to create a bridge chart in Excel.srt | 1.9 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.7 KB |
| 5.1 99. Treemap-Charts-Lecture.xlsx | 12.6 KB |
| 6. Sparklines.mp4 | 27.6 MB |
| 6. Sparklines.srt | 4.3 KB |
| 6.1 100. Sparklines-Lecture.xlsx | 9.6 KB |
| 1. Create professional and good-looking charts - Introduction.mp4 | 6.2 MB |
| 1. Create professional and good-looking charts - Introduction.srt | 662 bytes |
| 2. Build a column stacked chart with a secondary line axis in Excel.mp4 | 46.4 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-before.xlsm | 11.5 MB |
| 2.2 102. Column stacked chart-Lecture-after.xlsm | 11.5 MB |
| 3. Learn how to build effective doughnut charts in Excel.mp4 | 38.0 MB |
| 3. Learn how to build effective doughnut charts in Excel.srt | 5.4 KB |
| 3.1 103. Doughnut chart-Lecture-after.xlsm | 11.5 MB |
| 3.2 103. Doughnut chart-Lecture-before.xlsm | 11.5 MB |
| 4. Learn how to build an area chart in Excel.mp4 | 28.6 MB |
| 4. Learn how to build an area chart in Excel.srt | 3.6 KB |
| 4.1 104. Area chart-Lecture-before.xlsm | 11.5 MB |
| 4.2 104. Area chart-Lecture-after.xlsm | 11.5 MB |
| 5. Learn how to create bridge charts.mp4 | 52.1 MB |
| 5. Learn how to create bridge charts.srt | 7.6 KB |
| 5.1 105. Bridge chart-Lecture-before.xlsm | 11.5 MB |
| 5.2 105. Bridge chart-Lecture-after.xlsm | 11.5 MB |
| 6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4 | 136.1 MB |
| 6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.srt | 12.7 KB |
| 6.1 20. Bridge chart_after.xlsm | 11.5 MB |
| 6.2 20. Bridge chart_before.xlsm | 11.5 MB |
| 7. Case Study - Building a Complete P&L from scratch in Excel.html | 166 bytes |
| 8. Course Challenge - Apply your skills in practice!.mp4 | 7.9 MB |
| 8. Course Challenge - Apply your skills in practice!.srt | 1.3 KB |
| 8.1 107. Course-Challenge - Unsolved.xlsx | 505.5 KB |
| 8.2 107. Course-Challenge - Solved.xlsx | 543.9 KB |
| 1. Introduction to the Case Study.mp4 | 24.1 MB |
| 1. Introduction to the Case Study.srt | 2.6 KB |
| 1.1 108. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx | 13.3 MB |
| 10. FAQ My GETPIVOTDATA function doesn't work.html | 651 bytes |
| 11. Combining Slicers and GETPIVOTDATA The key to our success.mp4 | 33.6 MB |
| 11. Combining Slicers and GETPIVOTDATA The key to our success.srt | 3.6 KB |
| 11.1 7. Exercise - Build an FMCG Model_Inserting Slicers_before.xlsx | 20.8 MB |
| 11.2 7. Exercise - Build an FMCG Model_Inserting Slicers_after.xlsx | 20.8 MB |
| 12. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 | 32.4 MB |
| 12. Getting fancy with Excel slicers - Good-looking Excel slicers.srt | 3.6 KB |
| 12.1 8. Exercise - Build an FMCG Model_Formatting Slicers_before.xlsx | 20.8 MB |
| 12.2 8. Exercise - Build an FMCG Model_Formatting Slicers_after.xlsx | 18.3 MB |
| 13. This is how the report can be used in practice by high-level executives.mp4 | 36.2 MB |
| 13. This is how the report can be used in practice by high-level executives.srt | 4.7 KB |
| 13.1 9. Exercise - Build an FMCG Model_Complete_after.xlsx | 22.8 MB |
| 13.2 9. Exercise - Build an FMCG Model_Complete_before.xlsx | 18.3 MB |
| 14. Dynamic reporting with GETPIVOTDATA and slicers.html | 170 bytes |
| 2. Preliminary mapping of the data extraction.mp4 | 30.5 MB |
| 2. Preliminary mapping of the data extraction.srt | 2.6 KB |
| 2.1 1. Exercise - Build an FMCG Model_Mapping_before.xlsx | 13.3 MB |
| 2.2 1. Exercise - Build an FMCG Model_Mapping_after.xlsx | 14.9 MB |
| 3. Working with an SAP data extraction.mp4 | 37.1 MB |
| 3. Working with an SAP data extraction.srt | 4.1 KB |
| 4. Creating an output structure of the FMCG model.mp4 | 19.7 MB |
| 4. Creating an output structure of the FMCG model.srt | 3.0 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.9 MB |
| 5. Improving the layout and appearance of the FMCG report.mp4 | 25.4 MB |
| 5. Improving the layout and appearance of the FMCG report.srt | 4.9 KB |
| 5.1 3. Exercise - Build an FMCG Model_Formatting_after.xlsx | 14.9 MB |
| 5.2 3. Exercise - Build an FMCG Model_Formatting_before.xlsx | 14.9 MB |
| 6. Inserting formulas and automating calculations.mp4 | 16.2 MB |
| 6. Inserting formulas and automating calculations.srt | 4.9 KB |
| 6.1 4. Exercise - Build an FMCG Model_Adding Calculations_after.xlsx | 14.9 MB |
| 6.2 4. Exercise - Build an FMCG Model_Adding Calculations_before.xlsx | 14.9 MB |
| 7. Creating a Master Pivot Table The main data source for the FMCG report.mp4 | 20.1 MB |
| 7. Creating a Master Pivot Table The main data source for the FMCG report.srt | 2.2 KB |
| 7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table_before.xlsx | 14.9 MB |
| 7.2 5. Exercise - Build an FMCG Model_Creating a Pivot Table_after.xlsx | 20.8 MB |
| 8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4 | 50.0 MB |
| 8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.srt | 7.1 KB |
| 8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA_before.xlsx | 20.8 MB |
| 8.2 6a. Exercise - Build an FMCG Model_Copying Get Pivot_after.xlsx | 20.8 MB |
| 9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4 | 13.8 MB |
| 9. A potential error with GETPIVOTDATA you might encounter and its fix.srt | 1.5 KB |
| 1. Financial modeling basics - Welcome lecture.mp4 | 2.1 MB |
| 1. Financial modeling basics - Welcome lecture.srt | 1.1 KB |
| 10. Forecasting financials - Quiz.html | 167 bytes |
| 11. Building a complete model - Important considerations.mp4 | 8.4 MB |
| 11. Building a complete model - Important considerations.srt | 2.9 KB |
| 12. Modeling the Income statement.mp4 | 13.3 MB |
| 12. Modeling the Income statement.srt | 7.5 KB |
| 13. Modeling the Balance sheet - Part 1.mp4 | 6.1 MB |
| 13. Modeling the Balance sheet - Part 1.srt | 3.4 KB |
| 14. Modeling the Balance sheet - Part 2.mp4 | 10.6 MB |
| 14. Modeling the Balance sheet - Part 2.srt | 6.1 KB |
| 15. Building a financial model - Quiz.html | 167 bytes |
| 2. What is a financial model.mp4 | 5.5 MB |
| 2. What is a financial model.srt | 2.5 KB |
| 3. Why use financial models.mp4 | 10.0 MB |
| 3. Why use financial models.srt | 3.3 KB |
| 4. Financial modeling - worst practices - things you should avoid.mp4 | 19.9 MB |
| 4. Financial modeling - worst practices - things you should avoid.srt | 7.3 KB |
| 5. Financial modeling - best practices.mp4 | 17.2 MB |
| 5. Financial modeling - best practices.srt | 6.0 KB |
| 6. Financial modeling - The types of models that are built in practice.mp4 | 14.3 MB |
| 6. Financial modeling - The types of models that are built in practice.srt | 5.8 KB |
| 7. Financial modeling - Quiz.html | 167 bytes |
| 8. Financial modeling The right level of detail in a model.mp4 | 7.3 MB |
| 8. Financial modeling The right level of detail in a model.srt | 3.1 KB |
| 9. Financial modeling Forecasting guidelines.mp4 | 7.1 MB |
| 9. Financial modeling Forecasting guidelines.srt | 3.5 KB |
| 1. The core theory behind Company Valuation.html | 171 bytes |
| 1. Introduction to Mergers & Acquisitions.html | 171 bytes |
| [CourseClub.Me].url | 48 bytes |
| [DesireCourse.Net].url | 51 bytes |
| 1. Valuation Case study - Welcome lecture.mp4 | 1.8 MB |
| 1. Valuation Case study - Welcome lecture.srt | 883 bytes |
| 10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4 | 30.0 MB |
| 10. Modeling other items Interest expenses, Extraordinary items and Taxes.srt | 3.1 KB |
| 10.1 9. Interest expenses, taxes_after.xlsm | 50.9 KB |
| 10.2 9. Interest expenses, taxes_before.xlsm | 50.6 KB |
| 11. Forecasting Balance sheet items.mp4 | 4.7 MB |
| 11. Forecasting Balance sheet items.srt | 870 bytes |
| 11.1 10. Introduction to Balance sheet items.xlsm | 51.0 KB |
| 12. An introduction to the Days methodology.mp4 | 10.1 MB |
| 12. An introduction to the Days methodology.srt | 1.8 KB |
| 12.1 Working Capital Days.pptx | 94.8 KB |
| 13. Calculation of DSO, DPO and DOI for the historical period.mp4 | 12.1 MB |
| 13. Calculation of DSO, DPO and DOI for the historical period.srt | 1.4 KB |
| 13.1 12. Days calculation_before.xlsm | 51.2 KB |
| 13.2 12. Days calculation_after.xlsm | 51.5 KB |
| 14. Forecasting DSO, DPO and DOI.mp4 | 20.9 MB |
| 14. Forecasting DSO, DPO and DOI.srt | 2.5 KB |
| 14.1 13. Forecasting DSO, DPO, DIO_before.xlsm | 51.5 KB |
| 14.2 13. Forecasting DSO, DPO, DIO_after.xlsm | 52.0 KB |
| 15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4 | 22.6 MB |
| 15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.srt | 2.8 KB |
| 15.1 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm | 52.0 KB |
| 15.2 14. Forecasting PP&E, Other assets, and Other liabilities_after.xlsm | 52.9 KB |
| 16. Creating an output P&L sheet.mp4 | 18.8 MB |
| 16. Creating an output P&L sheet.srt | 2.4 KB |
| 16.1 15. P&L structure_before.xlsm | 53.6 KB |
| 16.2 15. P&L structure_after.xlsm | 53.7 KB |
| 17. Populating the output P&L sheet.mp4 | 25.5 MB |
| 17. Populating the output P&L sheet.srt | 2.5 KB |
| 17.1 16. Populating the P&L sheet_after.xlsm | 55.3 KB |
| 17.2 16. Populating the P&L sheet_before.xlsm | 53.7 KB |
| 18. Populating the output BS sheet.mp4 | 16.9 MB |
| 18. Populating the output BS sheet.srt | 1.8 KB |
| 18.1 17. Populating BS sheet_after.xlsm | 57.2 KB |
| 18.2 17. Populating BS sheet_before.xlsm | 55.3 KB |
| 19. Completing the output BS sheet for the historical period.mp4 | 38.0 MB |
| 19. Completing the output BS sheet for the historical period.srt | 4.0 KB |
| 19.1 18. Completing the Balance Sheet_before.xlsm | 57.2 KB |
| 19.2 18. Completing the Balance Sheet_after.xlsm | 58.1 KB |
| 2. Introduction to the DCF exercise.mp4 | 7.9 MB |
| 2. Introduction to the DCF exercise.srt | 1.3 KB |
| 20. Creating a structure for the calculation of Unlevered free cash flows.mp4 | 22.8 MB |
| 20. Creating a structure for the calculation of Unlevered free cash flows.srt | 3.2 KB |
| 20.1 19. Cash flow structure_before.xlsm | 58.5 KB |
| 20.2 19. Cash flow structure_after.xlsm | 58.6 KB |
| 21. Bridging Unlevered free cash flow to Net cash flow.mp4 | 14.6 MB |
| 21. Bridging Unlevered free cash flow to Net cash flow.srt | 2.0 KB |
| 21.1 20. Bridge UFCF to Net cash flow_after.xlsm | 58.7 KB |
| 21.2 20. Bridge UFCF to Net cash flow_before.xlsm | 58.6 KB |
| 22. Calculating Unlevered free cash flow.mp4 | 59.7 MB |
| 22. Calculating Unlevered free cash flow.srt | 6.6 KB |
| 22.1 21. Calculating UFCF_before.xlsm | 58.7 KB |
| 22.2 21. Calculating UFCF_after.xlsm | 59.2 KB |
| 23. Calculating Net cash flow.mp4 | 37.9 MB |
| 23. Calculating Net cash flow.srt | 4.3 KB |
| 23.1 22. Calculating Net Cash Flow_before.xlsm | 59.2 KB |
| 23.2 22. Calculating Net Cash Flow_after.xlsm | 59.4 KB |
| 23.3 Cash Flow Classification By Activities.xlsx | 55.9 KB |
| 24. Obtaining the rest of the cash flows through Find and Replace.mp4 | 46.7 MB |
| 24. Obtaining the rest of the cash flows through Find and Replace.srt | 4.4 KB |
| 24.1 23. Find and replace_before.xlsm | 59.5 KB |
| 24.2 23. Find and replace_after.xlsm | 62.5 KB |
| 25. Introducing Weighted average cost of capital and Perpetuity growth.mp4 | 13.2 MB |
| 25. Introducing Weighted average cost of capital and Perpetuity growth.srt | 2.4 KB |
| 25.1 24. Introducing WACC and g_before.xlsm | 62.5 KB |
| 25.2 24. Introducing WACC and g_after.xlsm | 62.6 KB |
| 26. Discounting Unlevered free cash flows to obtain their Present value.mp4 | 20.2 MB |
| 26. Discounting Unlevered free cash flows to obtain their Present value.srt | 3.2 KB |
| 26.1 25. Calculating PV of Cash Flows_before.xlsm | 62.6 KB |
| 26.2 25. Calculating PV of Cash Flows_after.xlsm | 62.7 KB |
| 27. Calculating Continuing value and Enterprise value of the business.mp4 | 17.7 MB |
| 27. Calculating Continuing value and Enterprise value of the business.srt | 2.6 KB |
| 27.1 26. Calculating CV and EV_before.xlsm | 62.7 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 | 1.7 KB |
| 28.1 27. Calculating equity value_before.xlsm | 63.1 KB |
| 28.2 27. Calculating equity value_after.xlsm | 63.3 KB |
| 29. Sensitivity analysis for WACC and perpetuity growth.mp4 | 40.5 MB |
| 29. Sensitivity analysis for WACC and perpetuity growth.srt | 4.6 KB |
| 29.1 28. Sensitivity analysis_before.xlsm | 63.3 KB |
| 29.2 28. Sensitivity analysis_after.xlsm | 64.8 KB |
| 29.3 Sensitivity Analysis.xlsx | 60.8 KB |
| 3. The stages of a complete DCF Valuation.mp4 | 49.2 MB |
| 3. The stages of a complete DCF Valuation.srt | 7.3 KB |
| 3.1 Valuation exercise.pdf | 411.8 KB |
| 30. A possible application of Goal seek.mp4 | 15.6 MB |
| 30. A possible application of Goal seek.srt | 2.0 KB |
| 30.1 29. Goal seek_before.xlsm | 64.8 KB |
| 30.2 29. Goal seek_ater.xlsm | 64.8 KB |
| 31. Using charts to summarize the results of the DCF model.mp4 | 32.9 MB |
| 31. Using charts to summarize the results of the DCF model.srt | 5.5 KB |
| 31.1 30. Charts.xlsm | 101.2 KB |
| 32. You made it!.mp4 | 11.3 MB |
| 32. You made it!.srt | 2.8 KB |
| 4. Description of the structure of the DCF model.mp4 | 18.5 MB |
| 4. Description of the structure of the DCF model.srt | 3.3 KB |
| 4.1 3. Structure of the DCF model.xlsm | 47.9 KB |
| 4.2 DCF Model structure.pdf | 240.8 KB |
| 5. A glimpse at the company we are valuing - Cheeseco.mp4 | 15.7 MB |
| 5. A glimpse at the company we are valuing - Cheeseco.srt | 1.4 KB |
| 5.1 Cheeseco.pptx | 80.1 KB |
| 6. Modeling the top line.mp4 | 26.3 MB |
| 6. Modeling the top line.srt | 4.0 KB |
| 6.1 5. Modeling revenues_after.xlsm | 48.2 KB |
| 6.2 5. Modeling revenues_before.xlsm | 47.9 KB |
| 7. Introducing scenarios to the model with Choose.mp4 | 17.8 MB |
| 7. Introducing scenarios to the model with Choose.srt | 2.6 KB |
| 7.1 6. Choose_before.xlsm | 48.2 KB |
| 7.2 6. Choose_after.xlsm | 48.4 KB |
| 8. Modeling other items Other revenues and Cogs.mp4 | 44.6 MB |
| 8. Modeling other items Other revenues and Cogs.srt | 4.5 KB |
| 8.1 7. Other revenues and Cogs_after.xlsm | 50.1 KB |
| 8.2 7. Other revenues and Cogs_before.xlsm | 48.4 KB |
| 9. Modeling other items Operating expenses and D&A.mp4 | 26.3 MB |
| 9. Modeling other items Operating expenses and D&A.srt | 2.8 KB |
| 9.1 8. Opex and D&A_before.xlsm | 50.1 KB |
| 9.2 8. Opex and D&A_after.xlsm | 50.6 KB |
| 1. Organizing external inputs in a 'Drivers' sheet.mp4 | 31.0 MB |
| 1. Organizing external inputs in a 'Drivers' sheet.srt | 4.4 KB |
| 1.1 Tesla Company Valuation - Detailed walkthrough.pdf | 5.1 MB |
| 1.2 Tesla 2015.pdf | 1.3 MB |
| 1.3 0a. Drivers_before.xlsx | 1.3 MB |
| 1.4 Tesla 2016.pdf | 2.2 MB |
| 1.5 0a. Drivers_after.xlsx | 1.3 MB |
| 1.6 Tesla 2017.pdf | 2.5 MB |
| 1.7 Tesla 2018 Q2.pdf | 635.1 KB |
| 10. Forecasting 'energy' and 'services' revenue.mp4 | 25.3 MB |
| 10. Forecasting 'energy' and 'services' revenue.srt | 3.1 KB |
| 10.1 6. Energy and Other revenue - After.xlsx | 1.3 MB |
| 10.2 6. Energy and Other revenue - Before.xlsx | 1.3 MB |
| 11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4 | 26.8 MB |
| 11. Calculating 'energy' and 'services' gross profit and cost of sales.srt | 2.5 KB |
| 11.1 7. Energy and Other - Gross profit, cost of sales - After.xlsx | 1.4 MB |
| 11.2 7. Energy and Other - Gross profit, cost of sales - Before.xlsx | 1.4 MB |
| 12. Forecasting operating expenses.mp4 | 34.9 MB |
| 12. Forecasting operating expenses.srt | 5.4 KB |
| 12.1 8. Opex - After.xlsx | 1.4 MB |
| 12.2 8. Opex - Before.xlsx | 1.4 MB |
| 13. Building a fixed asset roll forward estimating Capex.mp4 | 56.6 MB |
| 13. Building a fixed asset roll forward estimating Capex.srt | 6.4 KB |
| 13.1 9. PP&E forecasting and comparables_before.xlsx | 1.4 MB |
| 13.2 9. PP&E forecasting and comparables_after.xlsx | 1.4 MB |
| 14. Building a fixed asset roll forward D&A schedule.mp4 | 54.2 MB |
| 14. Building a fixed asset roll forward D&A schedule.srt | 4.4 KB |
| 14.1 10. PP&E schedule_before.xlsx | 1.4 MB |
| 14.2 10. PP&E schedule_after.xlsx | 1.4 MB |
| 15. Peer comparison D&A as a percentage of revenues.mp4 | 13.6 MB |
| 15. Peer comparison D&A as a percentage of revenues.srt | 1.6 KB |
| 15.1 10a. PP&E comparison.xlsx | 1.4 MB |
| 16. FAQ Why model D&A as a % of revenues or as a % of beginning PP&E.html | 818 bytes |
| 17. Calculating DSO, DIO, DPO.mp4 | 17.5 MB |
| 17. Calculating DSO, DIO, DPO.srt | 2.1 KB |
| 17.1 11. Working capital forecasting_before.xlsx | 1.4 MB |
| 17.2 11. Working capital forecasting_after.xlsx | 1.5 MB |
| 18. Producing a clean P&L output sheet.mp4 | 8.4 MB |
| 18. Producing a clean P&L output sheet.srt | 1.6 KB |
| 18.1 12. P&L.xlsx | 1.4 MB |
| 19. Fill in the P&L output sheet.mp4 | 18.3 MB |
| 19. Fill in the P&L output sheet.srt | 1.8 KB |
| 19.1 12a. P&L fill in_before.xlsx | 1.4 MB |
| 19.2 12a. P&L fill in_after.xlsx | 1.4 MB |
| 2. The input data we will work with.mp4 | 15.8 MB |
| 2. The input data we will work with.srt | 1.7 KB |
| 2.1 0aa. Inputs_after.xlsx | 1.3 MB |
| 2.2 0aa. Inputs_before.xlsx | 1.3 MB |
| 20. Calculating investments in working capital.mp4 | 19.0 MB |
| 20. Calculating investments in working capital.srt | 2.2 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.9 MB |
| 21. Forecasting Unlevered free cash flow.srt | 6.1 KB |
| 21.1 14. Cash flow - UFCF_after.xlsx | 1.4 MB |
| 21.2 14. Cash flow - UFCF_before.xlsx | 1.4 MB |
| 22. Forecasting other assets.mp4 | 45.2 MB |
| 22. Forecasting other assets.srt | 4.6 KB |
| 22.1 15. Balance Sheet forecasting assets_before.xlsx | 1.4 MB |
| 22.2 15. Balance Sheet forecasting assets_after.xlsx | 1.4 MB |
| 23. Forecasting other liabilities.mp4 | 22.0 MB |
| 23. Forecasting other liabilities.srt | 2.4 KB |
| 23.1 16. Balance Sheet forecasting liabilities_before.xlsx | 1.4 MB |
| 23.2 16. Balance Sheet forecasting liabilities_after.xlsx | 1.4 MB |
| 24. Completing Unlevered free cash flow.mp4 | 40.9 MB |
| 24. Completing Unlevered free cash flow.srt | 3.7 KB |
| 24.1 16a. Complete UFCF_before.xlsx | 1.4 MB |
| 24.2 16a. Complete UFCF_after.xlsx | 1.4 MB |
| 25. Modeling Tesla's financing needs in the forecast period.mp4 | 42.4 MB |
| 25. Modeling Tesla's financing needs in the forecast period.srt | 5.6 KB |
| 25.1 17. Financing_before.xlsx | 1.4 MB |
| 25.2 17. Financing_after.xlsx | 1.4 MB |
| 26. Calculating Net income.mp4 | 14.8 MB |
| 26. Calculating Net income.srt | 1.4 KB |
| 26.1 18. P&L complete_after.xlsx | 1.4 MB |
| 26.2 18. P&L complete_before.xlsx | 1.4 MB |
| 27. Bridging Unlevered free cash flow to Net cash flow.mp4 | 50.7 MB |
| 27. Bridging Unlevered free cash flow to Net cash flow.srt | 4.5 KB |
| 27.1 19. Cash flow_complete_after.xlsx | 1.4 MB |
| 27.2 19. Cash flow_complete_before.xlsx | 1.4 MB |
| 28. Balancing the Balance sheet.mp4 | 13.3 MB |
| 28. Balancing the Balance sheet.srt | 1.2 KB |
| 28.1 20. Complete the BS_after.xlsx | 1.4 MB |
| 28.2 20. Complete the BS_before.xlsx | 1.4 MB |
| 29. Estimating Weighted average cost of capital (WACC).mp4 | 44.3 MB |
| 29. Estimating Weighted average cost of capital (WACC).srt | 6.8 KB |
| 29.1 21. WACC_before.xlsx | 1.4 MB |
| 29.2 21. WACC_after.xlsx | 1.4 MB |
| 3. Forecasting Tesla's expected deliveries.mp4 | 100.3 MB |
| 3. Forecasting Tesla's expected deliveries.srt | 16.0 KB |
| 3.1 1. Deliveries_before.xlsx | 1.3 MB |
| 3.2 1. Deliveries_after.xlsx | 1.3 MB |
| 30. Performing discounted cash flow valuation (DCF).mp4 | 34.9 MB |
| 30. Performing discounted cash flow valuation (DCF).srt | 4.1 KB |
| 30.1 22. DCF_before.xlsx | 1.5 MB |
| 30.2 22. DCF_after.xlsx | 1.4 MB |
| 31. Calculating enterprise value, equity value, and price per share.mp4 | 22.6 MB |
| 31. Calculating enterprise value, equity value, and price per share.srt | 2.2 KB |
| 31.1 23. EV, Equity value, Price per share_after.xlsx | 1.4 MB |
| 31.2 23. EV, Equity value, Price per share_before.xlsx | 1.4 MB |
| 32. Final comments.mp4 | 44.9 MB |
| 32. Final comments.srt | 4.4 KB |
| 4. Comparing delivery figures with the ones of industry peers.mp4 | 20.9 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.9 MB |
| 5. Estimating an average selling price of Tesla vehicles.srt | 5.2 KB |
| 5.1 2. Average price_after.xlsx | 1.3 MB |
| 5.2 2. Average price_before.xlsx | 1.3 MB |
| 6. Calculating automotive revenue.mp4 | 46.6 MB |
| 6. Calculating automotive revenue.srt | 4.9 KB |
| 6.1 3. Revenue calculation and scenarios - after.xlsx | 1.3 MB |
| 6.2 3. Revenue calculation and scenarios - before.xlsx | 1.3 MB |
| 7. Peer comparison Gross profit %.mp4 | 17.2 MB |
| 7. Peer comparison Gross profit %.srt | 2.7 KB |
| 7.1 4. Gross profit automotive.xlsx | 1.3 MB |
| 8. Calculating automotive gross profit.mp4 | 27.8 MB |
| 8. Calculating automotive gross profit.srt | 2.9 KB |
| 8.1 4a. Gross profit automotive - after.xlsx | 1.3 MB |
| 8.2 4a. Gross profit automotive - before.xlsx | 1.5 MB |
| 9. Calculating automotive cost of sales.mp4 | 17.5 MB |
| 9. Calculating automotive cost of sales.srt | 2.3 KB |
| 9.1 5. Cost of sales and chart.xlsx | 1.3 MB |
| 1. Introduction to Capital budgeting.mp4 | 5.4 MB |
| 1. Introduction to Capital budgeting.srt | 1.9 KB |
| 2. Why we need Capital budgeting.mp4 | 6.9 MB |
| 2. Why we need Capital budgeting.srt | 2.7 KB |
| 3. The time value of money.mp4 | 6.7 MB |
| 3. The time value of money.srt | 2.8 KB |
| 4. Calculating future and present value.mp4 | 13.1 MB |
| 4. Calculating future and present value.srt | 6.7 KB |
| 5. Calculating cost of equity.mp4 | 19.2 MB |
| 5. Calculating cost of equity.srt | 8.0 KB |
| 6. Coming up with project-specific beta.mp4 | 9.0 MB |
| 6. Coming up with project-specific beta.srt | 3.8 KB |
| 7. Weighted average cost of capital (WACC).mp4 | 5.5 MB |
| 7. Weighted average cost of capital (WACC).srt | 2.5 KB |
| 8. The type of cash flows we will have in a project.mp4 | 9.3 MB |
| 8. The type of cash flows we will have in a project.srt | 4.2 KB |
| 9. Estimating the project's cash flows.mp4 | 18.8 MB |
| 9. Estimating the project's cash flows.srt | 7.1 KB |
| 1. Introduction to the Capital budgeting exercise.mp4 | 8.6 MB |
| 1. Introduction to the Capital budgeting exercise.srt | 3.4 KB |
| 10. Finding cost of equity.mp4 | 13.9 MB |
| 10. Finding cost of equity.srt | 7.6 KB |
| 10.1 8. WACC.xlsx | 38.0 KB |
| 10.2 8. WACC_unsolved.xlsx | 35.9 KB |
| 11. Discounting the project's cash flows and residual value.mp4 | 25.9 MB |
| 11. Discounting the project's cash flows and residual value.srt | 3.8 KB |
| 11.1 9. Discounted cash flow_unsolved.xlsx | 38.7 KB |
| 11.2 9. Discounted cash flow.xlsx | 39.7 KB |
| 12. Performing sensitivity analysis and completing the exercise.mp4 | 43.0 MB |
| 12. Performing sensitivity analysis and completing the exercise.srt | 5.6 KB |
| 12.1 10. Sensitivity analysis_unsolved.xlsx | 39.7 KB |
| 12.2 10. Sensitivity analysis.xlsx | 40.7 KB |
| 13. FAQ Data does not change in the DCF sheet, it changes from the Drivers sheet.html | 378 bytes |
| 14. Build a complete capital budgeting model from scratch.html | 170 bytes |
| 15. Congratulations!!.mp4 | 2.3 MB |
| 15. Congratulations!!.srt | 1.6 KB |
| 2. Organizing an Inputs sheet.mp4 | 11.1 MB |
| 2. Organizing an Inputs sheet.srt | 6.6 KB |
| 2.1 1. Drivers.xlsx | 11.5 KB |
| 3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4 | 9.2 MB |
| 3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.srt | 4.3 KB |
| 3.1 2. Savings Forecast_unsolved.xlsx | 14.7 KB |
| 3.2 2. Savings Forecast.xlsx | 16.6 KB |
| 4. Fixed asset rollforward.mp4 | 12.2 MB |
| 4. Fixed asset rollforward.srt | 5.6 KB |
| 4.1 3. Fixed Asset Rollforward_unsolved.xlsx | 18.5 KB |
| 4.2 3. Fixed Asset Rollforward.xlsx | 19.7 KB |
| 5. The impact of working capital.mp4 | 5.4 MB |
| 5. The impact of working capital.srt | 3.0 KB |
| 5.1 4. Working Capital.xlsx | 21.9 KB |
| 5.2 4. Working Capital_unsolved.xlsx | 21.2 KB |
| 6. Modeling debt financing.mp4 | 6.2 MB |
| 6. Modeling debt financing.srt | 3.4 KB |
| 6.1 5. Financing.xlsx | 31.0 KB |
| 6.2 5. Financing_unsolved.xlsx | 30.0 KB |
| 7. Adding a P&L sheet.mp4 | 4.9 MB |
| 7. Adding a P&L sheet.srt | 2.2 KB |
| 7.1 6. P&L.xlsx | 31.0 KB |
| 7.2 6. P&L_unsolved.xlsx | 29.7 KB |
| 8. Calculating project cash flows.mp4 | 10.1 MB |
| 8. Calculating project cash flows.srt | 4.0 KB |
| 8.1 7. Cash flow_unsolved.xlsx | 29.6 KB |
| 8.2 7. Cash flow.xlsx | 31.4 KB |
| 9. Estimating the weighted average cost of capital (WACC).mp4 | 5.6 MB |
| 9. Estimating the weighted average cost of capital (WACC).srt | 3.5 KB |
| 9.1 8. WACC_unsolved.xlsx | 35.9 KB |
| 9.2 8. WACC.xlsx | 38.0 KB |
| 1. Introduction to Excel.mp4 | 2.0 MB |
| 1. Introduction to Excel.srt | 925 bytes |
| 10. Introduction to Excel formulas.html | 167 bytes |
| 11. Introduction to Excel functions.mp4 | 18.7 MB |
| 11. Introduction to Excel functions.srt | 4.0 KB |
| 11.1 13. Functions- Exercise_after.xlsx | 81.1 KB |
| 11.2 13. Functions - Lecture_after.xlsx | 9.3 KB |
| 11.3 13. Functions- Lecture_before.xlsx | 9.2 KB |
| 11.4 13. Functions-Exercise_before.xlsx | 13.3 KB |
| 11.5 Introduction to Excel.pdf | 2.0 MB |
| 12. Cut, copy, & paste.mp4 | 13.0 MB |
| 12. Cut, copy, & paste.srt | 2.3 KB |
| 12.1 14. Copy-Cut-Paste-Exercise_after.xlsx | 12.6 KB |
| 12.2 Introduction to Excel.pdf | 2.0 MB |
| 12.3 14. Copy-Cut-Paste-Exercise_before.xlsx | 11.3 KB |
| 13. Cut, copy, & paste.html | 167 bytes |
| 14. Paste special.mp4 | 10.9 MB |
| 14. Paste special.srt | 1.4 KB |
| 14.1 15. Paste-Special-Exercise_after.xlsx | 13.5 KB |
| 14.2 15. Paste-Special-Exercise_before.xlsx | 13.5 KB |
| 14.3 Introduction to Excel.pdf | 2.0 MB |
| 15. Format cells.mp4 | 29.1 MB |
| 15. Format cells.srt | 6.5 KB |
| 15.1 10. Format cells_before.xlsx | 9.8 KB |
| 15.2 10. Format cells_after.xlsx | 9.8 KB |
| 16. Basic operations in Excel - 38 pages.html | 171 bytes |
| 2. Overview of Excel.mp4 | 20.7 MB |
| 2. Overview of Excel.srt | 4.0 KB |
| 2.1 7. Overview-of-Excel-Exercise_before.xlsx | 10.5 KB |
| 2.2 7. Overview-of-Excel-Exercise_after.xlsx | 10.9 KB |
| 2.3 Introduction to Excel.pdf | 2.0 MB |
| 3. Overview of Excel.html | 167 bytes |
| 4. The Excel ribbon.mp4 | 13.6 MB |
| 4. The Excel ribbon.srt | 2.7 KB |
| 4.1 Introduction to Excel.pdf | 2.0 MB |
| 4.2 8. The-Ribbon-Exercise_before.xlsx | 12.1 KB |
| 4.3 8. The-Ribbon-Exercise_after.xlsx | 403.2 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 9. Basic Manipulations - Lecture.xlsx | 8.1 KB |
| 5.2 9. Basic-Manipulations - Exercise_before.xlsx | 11.1 KB |
| 5.3 9. Basic-Manipulations - Exercise_after.xlsx | 32.4 KB |
| 5.4 Introduction to Excel.pdf | 2.0 MB |
| 6. Data entry in Excel.mp4 | 16.0 MB |
| 6. Data entry in Excel.srt | 3.4 KB |
| 6.1 10. Data-Entry-Exercise_before.xlsx | 11.0 KB |
| 6.2 10. Data-Entry - Lecture.xlsx | 8.1 KB |
| 6.3 Introduction to Excel.pdf | 2.0 MB |
| 6.4 10. Data-Entry- Exercise_after.xlsx | 32.8 KB |
| 7. Introduction to formatting.mp4 | 38.2 MB |
| 7. Introduction to formatting.srt | 5.9 KB |
| 7.1 11. Formatting - Lecture_after.xlsx | 9.8 KB |
| 7.2 11. Formatting- Lecture_before.xlsx | 8.9 KB |
| 7.3 Introduction to Excel.pdf | 2.0 MB |
| 7.4 11. Formatting-Exercise_before.xlsx | 21.6 KB |
| 7.5 11. Formatting- Exercise_after.xlsx | 11.6 KB |
| 8. Rows and columns.html | 167 bytes |
| 9. Introduction to Excel formulas.mp4 | 20.7 MB |
| 9. Introduction to Excel formulas.srt | 42.2 MB |
| 9.1 12. Formulas- Exercise_after.xlsx | 80.1 KB |
| 9.2 12. Formulas- Lecture_after.xlsx | 9.4 KB |
| 9.3 12. Formulas - Exercise_before.xlsx | 11.7 KB |
| 9.4 12. Formulas- Lecture_before.xlsx | 9.3 KB |
| 9.5 Introduction to Excel.pdf | 2.0 MB |
| 1. Next steps.html | 2.3 KB |
| [CourseClub.Me].url | 48 bytes |
| [DesireCourse.Net].url | 51 bytes |
| 1. Overview of Excel.mp4 | 41.2 MB |
| 1. Overview of Excel.srt | 4.1 KB |
| 1.1 7. Overview-of-Excel-Exercise-Solved.xlsx | 10.9 KB |
| 1.2 7. Introduction to Excel.pdf | 2.3 MB |
| 1.3 7. Overview-of-Excel-Exercise-Unsolved.xlsx | 10.5 KB |
| 2. Basic manipulations with rows and columns.mp4 | 20.4 MB |
| 2. Basic manipulations with rows and columns.srt | 2.1 KB |
| 2.1 8. Basic manipulations - Lecture.xlsx | 8.1 KB |
| 2.2 8. Basic-Manipulations - Exercise - Solved.xlsx | 32.4 KB |
| 2.3 8. Basic-Manipulations - Exercise - Unsolved.xlsx | 11.1 KB |
| 3. The Excel ribbon.mp4 | 28.9 MB |
| 3. The Excel ribbon.srt | 3.2 KB |
| 3.1 9. The-Ribbon-Exercise-Solved.xlsx | 403.2 KB |
| 3.2 9. The-Ribbon-Exercise-Exercise - Unsolved.xlsx | 12.1 KB |
| 4. Data entry in Excel.mp4 | 31.5 MB |
| 4. Data entry in Excel.srt | 3.5 KB |
| 4.1 10. Data-Entry-Exercise - Unsolved.xlsx | 11.0 KB |
| 4.2 10. Data-Entry - Lecture.xlsx | 8.1 KB |
| 4.3 10. Data-Entry- Exercise -Solved.xlsx | 32.8 KB |
| 5. Introduction to formatting.mp4 | 75.4 MB |
| 5. Introduction to formatting.srt | 6.6 KB |
| 5.1 11. Formatting - Lecture - Solved.xlsx | 9.8 KB |
| 5.2 11. Formatting-Exercise - Unsolved.xlsx | 11.6 KB |
| 5.3 11. Formatting- Exercise - Solved.xlsx | 11.6 KB |
| 5.4 11. Formatting- Lecture - Unsolved.xlsx | 8.9 KB |
| 6. Introduction to Excel formulas.mp4 | 18.8 MB |
| 6. Introduction to Excel formulas.srt | 4.3 KB |
| 6.1 12. Formulas - Exercise - Unsolved.xlsx | 11.7 KB |
| 6.2 12. Formulas- Lecture - Unsolved.xlsx | 9.3 KB |
| 6.3 Introduction-to-Excels-basic-features.pdf | 2.3 MB |
| 6.4 12. Formulas- Exercise - Solved.xlsx | 80.1 KB |
| 6.5 12. Formulas- Lecture - Solved.xlsx | 9.4 KB |
| 7. Introduction to Excel functions.mp4 | 37.1 MB |
| 7. Introduction to Excel functions.srt | 4.7 KB |
| 7.1 13. Functions- Lecture - Unsolved.xlsx | 9.2 KB |
| 7.2 13. Functions-Exercise - Unsolved.xlsx | 13.3 KB |
| 7.3 13. Functions- Exercise - Solved.xlsx | 81.1 KB |
| 7.4 13. Functions - Lecture -Solved.xlsx | 9.3 KB |
| 7.5 Introduction-to-Excels-basic-features.pdf | 2.3 MB |
| 8. Cut, copy, & paste.mp4 | 7.6 MB |
| 8. Cut, copy, & paste.srt | 2.4 KB |
| 8.1 Introduction-to-Excels-basic-features.pdf | 2.3 MB |
| 8.2 14. Copy-Cut-Paste-Exercise - Unsolved.xlsx | 11.3 KB |
| 8.3 14. Copy-Cut-Paste-Exercise - Solved.xlsx | 12.6 KB |
| 9. Paste special.mp4 | 6.7 MB |
| 9. Paste special.srt | 1.6 KB |
| 9.1 Introduction-to-Excels-basic-features.pdf | 2.3 MB |
| 9.2 15. Paste-Special-Exercise - Solved.xlsx | 13.5 KB |
| 9.3 15. Paste-Special-Exercise - Unsolved.xlsx | 13.5 KB |
| 1. Initial formatting of an Excel sheet to render it professional.mp4 | 8.0 MB |
| 1. Initial formatting of an Excel sheet to render it professional.srt | 2.3 KB |
| 1.1 18. Formatting-a-Worksheet-Exercise - Unsolved.xlsx | 10.6 KB |
| 1.2 18. Formatting-a-Worksheet-Exercise - Solved.xlsx | 10.8 KB |
| 1.3 18. Formatting-a-worksheet-Lecture - Solved.xlsx | 9.6 KB |
| 1.4 18. Formatting-a-worksheet-Lecture - Unsolved.xlsx | 9.0 KB |
| 1.5 Useful-Tips-Tools.pdf | 3.3 MB |
| 10. Find and select special types of cells with Select Special (F5).mp4 | 9.8 MB |
| 10. Find and select special types of cells with Select Special (F5).srt | 2.0 KB |
| 10.1 26. Select-Special-F5-Exercise - Solved.xlsx | 22.3 KB |
| 10.2 Useful-Tips-Tools.pdf | 3.3 MB |
| 10.3 26. Select-Special-Lecture.xlsx | 10.6 KB |
| 10.4 26. Select-Special-F5-Exercise - Unsolved.xlsx | 21.6 KB |
| 11. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4 | 5.4 MB |
| 11. Assign custom formats to specific cells within a financial model (e.g Multiples).srt | 2.0 KB |
| 11.1 Useful-Tips-Tools.pdf | 3.3 MB |
| 11.2 29. Assigning Custom Formats - Exercise - Solved.xlsx | 11.1 KB |
| 11.3 29. Assigning Custom Formats - Exercise - Unsolved.xlsx | 11.4 KB |
| 12. Define a named range in Excel.mp4 | 5.4 MB |
| 12. Define a named range in Excel.srt | 1.7 KB |
| 12.1 28. Naming-ranges-Lecture - Unsolved.xlsx | 8.8 KB |
| 12.2 Useful-Tips-Tools.pdf | 3.3 MB |
| 12.3 28. Defining-a-Named-Range-Exercise - Solved.xlsx | 11.7 KB |
| 12.4 28. Naming-ranges-Lecture - Solved.xlsx | 10.3 KB |
| 12.5 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx | 11.1 KB |
| 13. Learn how to organize your data with Text to Columns.mp4 | 12.5 MB |
| 13. Learn how to organize your data with Text to Columns.srt | 2.3 KB |
| 13.1 Useful-Tips-Tools.pdf | 3.3 MB |
| 13.2 23. Text-to-Columns-Exercise - Unsolved.xlsx | 10.6 KB |
| 13.3 23. Text-to-Columns-Exercise - Solved.xlsx | 11.3 KB |
| 13.4 23.Text-to-columns-Lecture - Solved.xlsx | 9.9 KB |
| 13.5 23. Text-to-columns-Lecture - Unsolved.xlsx | 9.8 KB |
| 14. Learn how to assign dynamic names within a financial model.mp4 | 7.3 MB |
| 14. Learn how to assign dynamic names within a financial model.srt | 1.6 KB |
| 14.1 27. Assigning-Dynamic-Names-Exercise - Solved.xlsx | 11.7 KB |
| 14.2 Useful-Tips-Tools.pdf | 3.3 MB |
| 14.3 27. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx | 11.2 KB |
| 14.4 27. Dynamic-Naming-Lecture - Solved.xlsx | 13.8 KB |
| 14.5 27. Dynamic-Naming-Lecture - Unsolved.xlsx | 13.5 KB |
| 15. Create easily printable documents in Excel by using Set Print Area.mp4 | 4.7 MB |
| 15. Create easily printable documents in Excel by using Set Print Area.srt | 1.6 KB |
| 15.1 25. Set-Print-Area-Lecture - Solved.xlsx | 11.2 KB |
| 15.2 Useful-Tips-Tools.pdf | 3.3 MB |
| 15.3 25. Set-Print-Area-Lecture - Unsolved.xlsx | 11.4 KB |
| 16. Using the 'Alt + Enter' combination.mp4 | 3.3 MB |
| 16. Using the 'Alt + Enter' combination.srt | 1.0 KB |
| 16.1 22. Alt-Enter-Exercise - Unsolved.xlsx | 11.1 KB |
| 16.2 22. Alt-Enter-Exercise - Solved.xlsx | 11.4 KB |
| 16.3 22. Alt-Enter- Lecture - Solved.xlsx | 9.6 KB |
| 16.4 22. Alt-Enter- Lecture - Unsolved.xlsx | 9.6 KB |
| 2. Fast scrolling through Excel sheets.mp4 | 22.2 MB |
| 2. Fast scrolling through Excel sheets.srt | 1.8 KB |
| 2.1 19. Fast-Scrolling-Exercise - Unsolved.xlsx | 43.9 KB |
| 2.2 19. Fast-Scrolling - Lecture.xlsx | 642.8 KB |
| 2.3 Useful-Tips-Tools.pdf | 3.3 MB |
| 2.4 19. Fast-Scrolling-Exercise - Solved.xlsx | 44.4 KB |
| 3. Introduction to fixing of cell references.mp4 | 20.4 MB |
| 3. Introduction to fixing of cell references.srt | 2.7 KB |
| 3.1 21. Fixing-references-Lecture - Unsolved.xlsx | 644.0 KB |
| 3.2 21. Fixing-Cells-Exercise - Solved.xlsx | 10.8 KB |
| 3.3 21. Fixing-references-Lecture - Solved.xlsx | 645.2 KB |
| 3.4 Useful-Tips-Tools.pdf | 3.3 MB |
| 3.5 21. Fixing-Cells-Exercise - Unsolved.xlsx | 10.7 KB |
| 4. Learn how to use the Wrap Text button.mp4 | 2.1 MB |
| 4. Learn how to use the Wrap Text button.srt | 903 bytes |
| 4.1 24. Wrap-Text-Exercise - Solved.xlsx | 10.2 KB |
| 4.2 Useful-Tips-Tools.pdf | 3.3 MB |
| 4.3 24. Wrap-Text-Exercise - Unsolved.xlsx | 10.2 KB |
| 4.4 24. Wrap-text-Lecture - Solved.xlsx | 9.6 KB |
| 4.5 24. Wrap-text-Lecture - Unsolved.xlsx | 9.6 KB |
| 5. Create a drop-down list by using Data Validation.mp4 | 10.6 MB |
| 5. Create a drop-down list by using Data Validation.srt | 2.2 KB |
| 5.1 Useful-Tips-Tools.pdf | 3.3 MB |
| 5.2 32. Drop-down-List-Exercise - Unsolved.xlsx | 11.3 KB |
| 5.3 32. Data-Validation-Lecture - Unsolved.xlsx | 10.8 KB |
| 5.4 32. Drop-down-List-Exercise - Solved.xlsx | 77.0 KB |
| 5.5 32. Data-Validation-Lecture - Solved.xlsx | 10.8 KB |
| 6. Using Custom-sort in order to sort multiple columns within a table.mp4 | 9.1 MB |
| 6. Using Custom-sort in order to sort multiple columns within a table.srt | 1.7 KB |
| 6.1 33. Custom-Sort-Exercise - Unsolved.xlsx | 11.4 KB |
| 6.2 33. Sort-data-Lecture - Unsolved.xlsx | 145.3 KB |
| 6.3 33. Sort-data-Lecture - Solved.xlsx | 145.6 KB |
| 6.4 33. Custom-Sort-Exercise - Solved.xlsx | 11.5 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.4 MB |
| 7. Create a great Index page at the beginning of your models - Hyperlinks.srt | 1.6 KB |
| 7.1 34. Hyperlinks-Exercise - Solved.xlsx | 137.1 KB |
| 7.2 Useful-Tips-Tools.pdf | 3.3 MB |
| 7.3 34. Hyperlinks-Exercise - Unsolved.xlsx | 136.9 KB |
| 8. Fix the top row of your table with Freeze Panes.mp4 | 17.7 MB |
| 8. Fix the top row of your table with Freeze Panes.srt | 1.5 KB |
| 8.1 Useful-Tips-Tools.pdf | 3.3 MB |
| 8.2 35. Freeze-Panes-Lecture - Unsolved.xlsx | 643.9 KB |
| 8.3 35. Freeze-Panes-Lecture - Solved.xlsx | 643.9 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.6 KB |
| 9.1 Useful-Tips-Tools.pdf | 3.3 MB |
| 9.2 30. Macros-Exercise - Solved.xlsx | 145.0 KB |
| 9.3 30. Macros-Exercise - Unsolved.xlsx | 10.3 KB |
| 9.4 30. Creating-a-Macro-Lecture - Unsolved.xlsx | 9.7 KB |
| 9.5 30. Creating-a-Macro-Lecture - Solved.xlsx | 11.2 KB |
| 1. Keyboard shortcuts Save LOTS of time in Excel 2010.mp4 | 30.4 MB |
| 1. Keyboard shortcuts Save LOTS of time in Excel 2010.srt | 5.5 KB |
| 1. Excel best practices - Welcome lecture.mp4 | 2.1 MB |
| 1. Excel best practices - Welcome lecture.srt | 1.0 KB |
| 1.1 Useful Tips & Tools.pdf | 3.1 MB |
| 10. Learn how to organize your data with text to columns.html | 167 bytes |
| 11. The wrap text button.mp4 | 3.7 MB |
| 11. The wrap text button.srt | 914 bytes |
| 11.1 Wrap-text-Lecture - Solved.xlsx | 9.6 KB |
| 11.2 Wrap-Text-Exercise - Solved.xlsx | 10.2 KB |
| 11.3 Wrap-text-Lecture - Unsolved.xlsx | 9.6 KB |
| 11.4 Wrap-Text-Exercise - Unsolved.xlsx | 10.2 KB |
| 12. Set print area.mp4 | 7.6 MB |
| 12. Set print area.srt | 1.5 KB |
| 12.1 Set-Print-Area-Lecture - Solved.xlsx | 11.2 KB |
| 12.2 Set-Print-Area-Lecture - Unsolved.xlsx | 11.8 KB |
| 13. Custom sort helps you sort multiple columns in Excel tables.mp4 | 11.2 MB |
| 13. Custom sort helps you sort multiple columns in Excel tables.srt | 1.7 KB |
| 13.1 Custom-Sort-Exercise - Solved.xlsx | 11.5 KB |
| 13.2 Custom-Sort-Exercise - Unsolved.xlsx | 11.4 KB |
| 13.3 Sort-data-Lecture - Unsolved.xlsx | 145.3 KB |
| 13.4 Sort-data-Lecture - Solved.xlsx | 145.6 KB |
| 14. Create drop-down lists with data validation.mp4 | 14.1 MB |
| 14. Create drop-down lists with data validation.srt | 1.9 KB |
| 14.1 Data-Validation-Lecture - Solved.xlsx | 11.3 KB |
| 14.2 Drop-down-List-Exercise - Solved.xlsx | 77.0 KB |
| 14.3 Data-Validation-Lecture - Unsolved.xlsx | 11.2 KB |
| 14.4 Drop-down-List-Exercise - Unsolved.xlsx | 11.3 KB |
| 15. Find and select special types of cells with Select special (F5).mp4 | 13.9 MB |
| 15. Find and select special types of cells with Select special (F5).srt | 1.7 KB |
| 15.1 Select-Special-Lecture-Solved.xlsx | 10.9 KB |
| 15.2 Select-Special-F5-Exercise - Unsolved.xlsx | 21.6 KB |
| 15.3 Select-Special-F5-Exercise - Solved.xlsx | 22.3 KB |
| 15.4 Select-Special-Lecture.xlsx | 10.6 KB |
| 16. Select Special.html | 167 bytes |
| 17. Assign dynamic names in a financial model.mp4 | 7.7 MB |
| 17. Assign dynamic names in a financial model.srt | 1.5 KB |
| 17.1 Dynamic-Naming-Lecture - Unsolved.xlsx | 13.7 KB |
| 17.2 Dynamic-Naming-Lecture - Solved.xlsx | 12.4 KB |
| 17.3 Assigning-Dynamic-Names-Exercise - Unsolved.xlsx | 11.2 KB |
| 17.4 Assigning-Dynamic-Names-Exercise - Solved.xlsx | 11.7 KB |
| 18. Assigning dynamic names.html | 167 bytes |
| 19. Define a named range in Excel.mp4 | 7.7 MB |
| 19. Define a named range in Excel.srt | 1.8 KB |
| 19.1 28. Defining-a-Named-Range-Exercise - Solved.xlsx | 11.7 KB |
| 19.2 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx | 11.1 KB |
| 19.3 28. Naming-ranges-Lecture - Unsolved.xlsx | 8.8 KB |
| 19.4 28. Naming-ranges-Lecture - Solved.xlsx | 10.3 KB |
| 2. Initial formatting of Excel sheets for a professional layout.mp4 | 11.6 MB |
| 2. Initial formatting of Excel sheets for a professional layout.srt | 2.3 KB |
| 2.1 Useful Tips & Tools.pdf | 3.1 MB |
| 2.2 Formatting-a-Worksheet-Exercise - Solved.xlsx | 10.8 KB |
| 2.3 Formatting-a-worksheet-Lecture - Solved.xlsx | 9.6 KB |
| 2.4 Formatting-a-Worksheet-Exercise - Unsolved.xlsx | 10.6 KB |
| 2.5 Formatting-a-worksheet-Lecture - Unsolved.xlsx | 9.0 KB |
| 20. Create a great Index page at the beginning of your models - Hyperlinks.mp4 | 8.6 MB |
| 20. Create a great Index page at the beginning of your models - Hyperlinks.srt | 1.4 KB |
| 20.1 Hyperlinks - Lecture - Solved.xlsx | 14.3 KB |
| 20.2 Hyperlinks - Lecture - Unsolved.xlsx | 14.2 KB |
| 20.3 Hyperlinks-Exercise - Solved.xlsx | 137.1 KB |
| 20.4 Hyperlinks-Exercise - Unsolved.xlsx | 136.9 KB |
| 21. Introduction to custom formatting in Excel.mp4 | 38.0 MB |
| 21. Introduction to custom formatting in Excel.srt | 8.1 KB |
| 21.1 19. Custom formatting_before.xlsx | 10.7 KB |
| 21.2 19. Custom formatting_after.xlsx | 10.8 KB |
| 22. Apply custom formatting in a financial model.mp4 | 9.2 MB |
| 22. Apply custom formatting in a financial model.srt | 1.6 KB |
| 22.1 Assigning Custom Formats - Exercise - Unsolved.xlsx | 11.4 KB |
| 22.2 Custom formats - Lecture - Solved.xlsx | 8.8 KB |
| 22.3 Assigning Custom Formats - Exercise - Solved.xlsx | 11.1 KB |
| 22.4 Custom formats - Lecture - Unsolved.xlsx | 8.3 KB |
| 23. Macros are a great timesaver! Here's why!.mp4 | 17.2 MB |
| 23. Macros are a great timesaver! Here's why!.srt | 3.1 KB |
| 23.1 Recording a Macro - Lecture - Solved.ods | 3.0 KB |
| 23.2 Recording a Macro - Lecture - Unsolved.ods | 2.6 KB |
| 24. How to save macros and use them across several workbooks.mp4 | 12.8 MB |
| 24. How to save macros and use them across several workbooks.srt | 1.7 KB |
| 24.1 31. Another-file.xlsx | 8.8 KB |
| 24.2 31. How-to-save-macros-Lecture-after.xlsm | 12.6 KB |
| 24.3 31. How-to-save-macros-Lecture-before.xlsx | 6.0 KB |
| 25. Excel macros - quiz.html | 167 bytes |
| 26. Fix the top row of your table with freeze panes.mp4 | 14.5 MB |
| 26. Fix the top row of your table with freeze panes.srt | 1.3 KB |
| 26.1 Freeze-Panes-Lecture - Solved.xlsx | 644.2 KB |
| 26.2 Freeze-Panes-Lecture - Unsolved.xlsx | 644.2 KB |
| 27. How to search functionalities in Excel.mp4 | 7.5 MB |
| 27. How to search functionalities in Excel.srt | 853 bytes |
| 27.1 Search.xlsx | 644.2 KB |
| 28. Filter by color - an excellent tool.mp4 | 9.9 MB |
| 28. Filter by color - an excellent tool.srt | 2.2 KB |
| 28.1 36. Exercise-Filter-by-Color-Solved.xlsx | 153.5 KB |
| 28.2 36. Exercise-Filter-by-Color-Unsolved.xlsx | 20.5 KB |
| 29. Working with conditional formatting.mp4 | 15.1 MB |
| 29. Working with conditional formatting.srt | 6.1 KB |
| 29.1 Exercise_Conditional Formatting.xlsx | 12.9 KB |
| 29.2 Conditional Formatting - Lecture.xlsx | 12.5 KB |
| 29.3 Solution_Conditional Formatting.xlsx | 51.5 KB |
| 3. Fast scrolling through Excel sheets.mp4 | 17.5 MB |
| 3. Fast scrolling through Excel sheets.srt | 1.9 KB |
| 3.1 Fast-Scrolling - Lecture.xlsx | 643.7 KB |
| 3.2 Fast-Scrolling-Exercise - Solved.xlsx | 44.4 KB |
| 3.3 Fast-Scrolling-Exercise - Unsolved.xlsx | 43.9 KB |
| 30. Useful tips and tools for your work in Excel - quiz.html | 166 bytes |
| 31. A neat trick - Multiply by 1.mp4 | 14.9 MB |
| 31. A neat trick - Multiply by 1.srt | 1.7 KB |
| 31.1 38. Multiply-by-1-Lecture-before.xlsx | 16.5 KB |
| 31.2 38. Multiply-by-1-Lecture-after.xlsx | 17.2 KB |
| 32. Find and replace - references.mp4 | 24.0 MB |
| 32. Find and replace - references.srt | 3.5 KB |
| 32.1 39. Find-and-Replace-references-Lecture-before.xlsx | 38.8 KB |
| 32.2 39. Find-and-Replace-references-Lecture-after.xlsx | 37.9 KB |
| 33. FAQ Why do we replace external references and how does this help us.html | 702 bytes |
| 34. Find and replace - formatting.mp4 | 13.8 MB |
| 34. Find and replace - formatting.srt | 1.9 KB |
| 34.1 40. Find-replace-Lecture-after.xlsx | 17.2 KB |
| 34.2 40. Find-replace-Lecture-before.xlsx | 17.2 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 | 22.0 KB |
| 36. Beauty saving - The professional way of saving files.mp4 | 14.0 MB |
| 36. Beauty saving - The professional way of saving files.srt | 2.5 KB |
| 36.1 42. Beauty-saving-Lecture-after.xlsx | 17.0 KB |
| 36.2 42. Beauty-saving-Lecture-before.xlsx | 17.2 KB |
| 37. Formula auditing with F2.mp4 | 17.7 MB |
| 37. Formula auditing with F2.srt | 2.2 KB |
| 37.1 43. F2-Lecture.xlsm | 50.8 KB |
| 4. Fast scrolling through Excel sheets.html | 167 bytes |
| 5. Be even quicker F5 + Enter.mp4 | 19.8 MB |
| 5. Be even quicker F5 + Enter.srt | 2.2 KB |
| 5.1 20. F5-go-to - Lecture.xlsm | 50.8 KB |
| 6. Fixing cell references.mp4 | 24.1 MB |
| 6. Fixing cell references.srt | 2.5 KB |
| 6.1 Fixing-references-Lecture - Solved.xlsx | 644.6 KB |
| 6.2 Fixing-references-Lecture - Unsolved.xlsx | 644.1 KB |
| 6.3 Fixing-Cells-Exercise - Unsolved.xlsx | 10.7 KB |
| 6.4 Fixing-Cells-Exercise - Solved.xlsx | 10.8 KB |
| 7. Introduction to fixing of cell references.html | 167 bytes |
| 8. Alt + Enter.mp4 | 4.2 MB |
| 8. Alt + Enter.srt | 961 bytes |
| 8.1 Alt-Enter-Exercise - Unsolved.xlsx | 11.1 KB |
| 8.2 Alt-Enter- Lecture - Solved.xlsx | 10.0 KB |
| 8.3 Alt-Enter- Lecture - Unsolved.xlsx | 9.9 KB |
| 8.4 Alt-Enter-Exercise - Solved.xlsx | 11.4 KB |
| 9. Organize your data with text to columns.mp4 | 13.9 MB |
| 9. Organize your data with text to columns.srt | 2.5 KB |
| 9.1 Text-to-Columns-Exercise - Unsolved.xlsx | 10.6 KB |
| 9.2 Text-to-columns-Lecture - Unsolved.xlsx | 9.8 KB |
| 9.3 Text-to-columns-Lecture - Solved.xlsx | 10.2 KB |
| 9.4 Text-to-Columns-Exercise - Solved.xlsx | 11.3 KB |
| 9.5 Invoice example.pdf | 44.5 KB |
| 1. Keyboard shortcuts save LOTS of time in Excel.mp4 | 51.2 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.0 MB |
| 1.2 Beginner to Pro in Excel - Shortcuts for MAC.pdf | 447.6 KB |
| 2. Keyboard shortcuts in Excel.html | 171 bytes |
| 1. Excel's key functions - Welcome lecture.mp4 | 2.3 MB |
| 1. Excel's key functions - Welcome lecture.srt | 1.1 KB |
| 10. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.html | 167 bytes |
| 11. Working with text in Excel.mp4 | 16.0 MB |
| 11. Working with text in Excel.srt | 3.1 KB |
| 11.1 53. Work-with-text-Lecture-before.xlsx | 10.3 KB |
| 11.2 53. Work-with-text-Lecture-after.xlsx | 10.9 KB |
| 12. Find the minimum or maximum value in a range of cells in Excel.mp4 | 5.9 MB |
| 12. Find the minimum or maximum value in a range of cells in Excel.srt | 1.1 KB |
| 12.1 54. Max-min-Lecture - Unsolved.xlsx | 8.9 KB |
| 12.2 54. MIN-MAX-Exercise - Unsolved.xlsx | 14.4 KB |
| 12.3 54. MIN-MAX-Exercise - Solved.xlsx | 14.8 KB |
| 12.4 54. Max-min-Lecture - Solved.xlsx | 9.2 KB |
| 13. Include ROUND in your financial models.mp4 | 3.1 MB |
| 13. Include ROUND in your financial models.srt | 1.2 KB |
| 13.1 55. Excel-functions-Lecture.xlsx | 889.9 KB |
| 13.2 Excel-Functions.pdf | 3.2 MB |
| 13.3 55. Round-Exercise - Unsolved.xlsx | 11.3 KB |
| 13.4 55. Round-Exercise - Solved.xlsx | 11.7 KB |
| 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.0 KB |
| 14.1 56. Vlookup-Hlookup- Lecture - Unsolved.xlsx | 10.7 KB |
| 14.2 56. Vlookup-Hlookup- Lecture - Solved.xlsx | 11.1 KB |
| 14.3 Excel-Functions.pdf | 3.2 MB |
| 14.4 56. Vlookup-Hlookup-Exercise - Solved.xlsx | 13.7 KB |
| 14.5 56. Vlookup-Hlookup-Exercise - Unsolved.xlsx | 11.9 KB |
| 15. How to enlarge the formula bar.mp4 | 6.3 MB |
| 15. How to enlarge the formula bar.srt | 1.4 KB |
| 15.1 57. Enlarge-the-formula-bar-Lecture.xlsm | 46.9 KB |
| 16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4 | 39.0 MB |
| 16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.srt | 8.8 KB |
| 16.1 Excel-Functions.pdf | 3.2 MB |
| 16.2 58. Index-Match-Lecture - Unsolved.xlsx | 11.3 KB |
| 16.3 58. Index-Match-Lecture - Solved.xlsx | 11.7 KB |
| 16.4 58. Index-Match-Exercise - Solved.xlsx | 12.1 KB |
| 16.5 58. Index-Match-Exercise - Unsolved.xlsx | 11.6 KB |
| 17. A great Excel technique INDEX, MATCH, MATCH.mp4 | 11.8 MB |
| 17. A great Excel technique INDEX, MATCH, MATCH.srt | 5.6 KB |
| 17.1 59. Exercise-Index-Match-Match-Solved.xlsx | 12.2 KB |
| 17.2 59. Exercise-Index-Match-Match-Unsolved.xlsx | 11.6 KB |
| 17.3 Index, Match, Match - Lecture.xlsx | 22.3 KB |
| 18. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.html | 167 bytes |
| 19. Using Excel's IFERROR function to trap spreadsheet errors.mp4 | 7.5 MB |
| 19. Using Excel's IFERROR function to trap spreadsheet errors.srt | 2.2 KB |
| 19.1 60. Iferror-Exercise - Solved.xlsx | 15.4 KB |
| 19.2 60. Iferror - Lecture - Unsolved.xlsm | 897.3 KB |
| 19.3 60. Iferror-Exercise - Unsolved.xlsx | 14.3 KB |
| 19.4 60. Iferror - Lecture - Solved.xlsm | 896.4 KB |
| 19.5 Excel-Functions.pdf | 3.2 MB |
| 2. A helpful consideration.html | 1.4 KB |
| 20. RANK is a valuable tool when using Excel for financial and business analysis.mp4 | 23.2 MB |
| 20. RANK is a valuable tool when using Excel for financial and business analysis.srt | 2.9 KB |
| 20.1 61. Rank-function-Lecture-before.xlsx | 12.3 KB |
| 20.2 61. Rank-function-Lecture-after.xlsx | 12.6 KB |
| 21. Learn how to render your models flexible with CHOOSE.mp4 | 9.0 MB |
| 21. Learn how to render your models flexible with CHOOSE.srt | 2.8 KB |
| 21.1 Excel-Functions.pdf | 3.2 MB |
| 21.2 62. Choose-Lecture - Unsolved.xlsx | 3.2 MB |
| 21.3 62. Choose-Exercise-Solved.xlsx | 11.7 KB |
| 21.4 62. Choose-Lecture - Solved.xlsx | 9.7 KB |
| 21.5 62. Choose-Exercise - Unsolved.xlsx | 11.3 KB |
| 22. Use Goal Seek to find the result that you are looking for.mp4 | 7.9 MB |
| 22. Use Goal Seek to find the result that you are looking for.srt | 2.7 KB |
| 22.1 63. Goal-Seek-Exercise-Solved.xlsx | 16.2 KB |
| 22.2 63. Goal-Seek-Lecture - Solved.xlsx | 9.2 KB |
| 22.3 63. Goal-Seek-Lecture - Unsolved.xlsx | 9.1 KB |
| 22.4 Excel-Functions.pdf | 3.2 MB |
| 22.5 63. Goal-Seek-Exercise - Unsolved.xlsx | 16.1 KB |
| 23. Use Goal Seek in order to find the result that you are looking for.html | 167 bytes |
| 24. Include sensitivity analysis in your models through Data Tables.mp4 | 14.3 MB |
| 24. Include sensitivity analysis in your models through Data Tables.srt | 5.0 KB |
| 24.1 64. Sensitivity-analysis-Exercise-Solved.xlsm | 63.9 KB |
| 24.2 64. Sensitivity analysis - Lecture - Solved.xlsm | 897.3 KB |
| 24.3 64. Sensitivity analysis - Lecture - Unsolved.xlsm | 897.1 KB |
| 24.4 64. Sensitivity-analysis-Exercise-Unsolved.xlsm | 66.8 KB |
| 25. Include sensitivity analysis in your models through Data Tables.html | 167 bytes |
| 26. Excel's dynamic and interactive tables Pivot tables.mp4 | 23.2 MB |
| 26. Excel's dynamic and interactive tables Pivot tables.srt | 2.6 KB |
| 26.1 65. Pivot tables - Lecture - Unsolved.xlsm | 687.8 KB |
| 26.2 65. Pivot Tables - Exercise - Solved.xlsx | 190.5 KB |
| 26.3 65. Pivot tables - Lecture - Solved.xlsm | 897.3 KB |
| 26.4 65. Pivot Tables - Exercise - Unsolved.xlsx | 152.2 KB |
| 27. Excel's key functions and functionalities made easy.html | 166 bytes |
| 3. Key functions in Excel IF.mp4 | 16.7 MB |
| 3. Key functions in Excel IF.srt | 2.9 KB |
| 3.1 Functions - English to German.pdf | 102.3 KB |
| 3.2 Functions - English to Spanish.pdf | 102.4 KB |
| 3.3 Functions - English to Portuguese.pdf | 146.1 KB |
| 3.4 47. IF-function--Lecture-before.xlsm | 17.0 KB |
| 3.5 47. IF-function-Lecture-after.xlsm | 17.9 KB |
| 3.6 Key functions - Excel.pdf | 8.5 MB |
| 4. Key Excel functions SUM, SUMIF and SUMIFS.mp4 | 19.3 MB |
| 4. Key Excel functions SUM, SUMIF and SUMIFS.srt | 5.3 KB |
| 4.1 48. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx | 14.5 KB |
| 4.2 Excel-Functions.pdf | 3.2 MB |
| 4.3 48. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx | 12.9 KB |
| 4.4 48. Sum-Sumif-Sumifs-Lecture - Solved.xlsx | 13.0 KB |
| 4.5 48. Sum-Sumif-Sumifs-Exercise - Solved.xlsx | 14.8 KB |
| 5. = and + are interchangeable when you start typing a formula.mp4 | 5.8 MB |
| 5. = and + are interchangeable when you start typing a formula.srt | 974 bytes |
| 5.1 49. = and + are interchangeable - before.xlsm | 17.0 KB |
| 5.2 49. = and + are interchangeable -after.xlsm | 17.0 KB |
| 6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 | 17.0 MB |
| 6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.srt | 4.8 KB |
| 6.1 05 38 Counts Solved.xlsx | 16.1 KB |
| 6.2 05 38 Counts Exercise & Text.xlsx | 15.7 KB |
| 6.3 Lecture-Count-Countif-Countifs-Unsolved.xlsx | 11.3 KB |
| 6.4 Excel-Functions.pdf | 3.2 MB |
| 6.5 Lecture-Count-Countif-Countifs-Solved.xlsx | 11.7 KB |
| 7. Key Excel functions AVERAGE and AVERAGEIF.mp4 | 7.9 MB |
| 7. Key Excel functions AVERAGE and AVERAGEIF.srt | 2.4 KB |
| 7.1 51. Average-AverageIF-Exercise - Unsolved.xlsx | 14.6 KB |
| 7.2 51. Average-Averageif- Lecture - Solved.xlsx | 9.4 KB |
| 7.3 51. Average-AverageIF-Exercise - Solved.xlsx | 15.0 KB |
| 7.4 Excel-Functions.pdf | 3.2 MB |
| 7.5 51. Average-Averageif- Lecture - Unsolved.xlsx | 9.0 KB |
| 8. Key Excel functions AVERAGE and AVERAGEIF.html | 167 bytes |
| 9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4 | 16.8 MB |
| 9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.srt | 5.7 KB |
| 9.1 52. Text functions - Exercise - Solved.xlsx | 12.2 KB |
| 9.2 52. Text functions - Exercise - Unsolved.xlsx | 11.7 KB |
| 9.3 52. Text-Functions- Lecture - Solved.xlsx | 11.1 KB |
| 9.4 52. Text-Functions- Lecture - Unsolved.xlsx | 10.6 KB |
| [CourseClub.Me].url | 48 bytes |
| [DesireCourse.Net].url | 51 bytes |
| 1. Exercise - Excel's SUMIFS function - unsolved.html | 171 bytes |
| 2. Exercise - Excel's SUMIFS function - solved & explained.mp4 | 35.3 MB |
| 2. Exercise - Excel's SUMIFS function - solved & explained.srt | 10.7 KB |
| 2.1 67. Exercise-Sumifs-With-Solutions.xlsx | 1.3 MB |
| 1. Future and present values in Excel.mp4 | 15.0 MB |
| 1. Future and present values in Excel.srt | 6.9 KB |
| 1.1 68. FV and PV-Lecture.xlsx | 10.6 KB |
| 2. Calculating the rate of return of an investment with the IRR function.mp4 | 7.6 MB |
| 2. Calculating the rate of return of an investment with the IRR function.srt | 3.7 KB |
| 2.1 69. Exercise-IRR-Solved.xlsx | 12.3 KB |
| 2.2 69. Exercise-IRR-Unsolved.xlsx | 11.5 KB |
| 2.3 69. IRR-Lecture.xlsx | 11.2 KB |
| 3. Calculating a complete loan schedule in Excel.mp4 | 14.8 MB |
| 3. Calculating a complete loan schedule in Excel.srt | 6.5 KB |
| 3.1 70. Exercise-Loan-Schedule-Unsolved.xlsx | 15.8 KB |
| 3.2 70. Exercise-Loan-Schedule-Solved.xlsx | 22.7 KB |
| 3.3 70. Loan Schedule-Lecture.xlsx | 20.2 KB |
| 4. Date functions in Excel.mp4 | 11.4 MB |
| 4. Date functions in Excel.srt | 5.8 KB |
| 4.1 71. Date Functions-Exercise-Unsolved.xlsx | 11.4 KB |
| 4.2 71. Date Functions-Exercise-Solved.xlsx | 12.4 KB |
| 4.3 71. Date Functions-Lecture.xlsx | 12.3 KB |
| 1. Introduction to Pivot Tables and the way they are applied.mp4 | 6.0 MB |
| 1. Introduction to Pivot Tables and the way they are applied.srt | 2.1 KB |
| 2. Creating Pivot Tables easily!.mp4 | 19.4 MB |
| 2. Creating Pivot Tables easily!.srt | 4.3 KB |
| 2.1 73. Creating-a-Pivot-Table - Lecture – before.xlsx | 1.2 MB |
| 2.2 73. Creating-a-Pivot-Table - Lecture - after.xlsx | 1.4 MB |
| 3. Give your Excel Pivot Tables a makeover.mp4 | 11.3 MB |
| 3. Give your Excel Pivot Tables a makeover.srt | 2.4 KB |
| 3.1 74. Formatting-a-Pivot-Table - Lecture - before.xlsx | 1.4 MB |
| 3.2 74. Formatting-a-Pivot-Table - Lecture - after.xlsx | 1.4 MB |
| 4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4 | 23.0 MB |
| 4. Modifying and pivoting fields to obtain the Pivot Table you need.srt | 4.7 KB |
| 4.1 75. Working-with-Pivot-Tables - Lecture - after.xlsx | 1.9 MB |
| 4.2 75. Working-with-Pivot-Tables - Lecture - before.xlsx | 1.4 MB |
| 5. Learn more about GETPIVOTDATA - A very important Excel function.mp4 | 18.1 MB |
| 5. Learn more about GETPIVOTDATA - A very important Excel function.srt | 4.0 KB |
| 5.1 76. GetPivotData - Lecture - before.xlsx | 1.9 MB |
| 5.2 76. GetPivotData - Lecture – after.xlsx | 1.9 MB |
| 6. An introduction to slicers - The modern-day Pivot Table filters.mp4 | 22.2 MB |
| 6. An introduction to slicers - The modern-day Pivot Table filters.srt | 4.7 KB |
| 6.1 77. Slicers - Lecture - after.xlsx | 1.9 MB |
| 6.2 77. Slicers - Lecture - before.xlsx | 1.9 MB |
| 1. Case study - Build a P&L from scratch - Welcome lecture.mp4 | 3.1 MB |
| 1. Case study - Build a P&L from scratch - Welcome lecture.srt | 1.6 KB |
| 10. FAQ Sum of FY2018 doens't go down to zero.html | 1.3 KB |
| 11. Use INDEX & MATCH as a substitute for VLOOKUP.mp4 | 49.6 MB |
| 11. Use INDEX & MATCH as a substitute for VLOOKUP.srt | 4.3 KB |
| 11.1 87. Index Match-Lecture-before.xlsm | 41.0 KB |
| 11.2 87. Index Match-Lecture-after.xlsm | 13.9 MB |
| 12. Mapping the rows in the database sheet.mp4 | 32.5 MB |
| 12. Mapping the rows in the database sheet.srt | 2.8 KB |
| 12.1 88. Mapping-Lecture-after.xlsm | 50.2 KB |
| 12.2 88. Mapping_before.xlsm | 50.6 KB |
| 13. In case you have any doubts about the Mapping exercise.mp4 | 38.6 MB |
| 13. In case you have any doubts about the Mapping exercise.srt | 6.7 KB |
| 13.1 89. Mapping-Lecture-Solved.xlsx | 47.5 KB |
| 13.2 89. Mapping-exercise-explained.pdf | 243.0 KB |
| 13.3 89. Mapping-Lecture-Unsolved.xlsm | 50.6 KB |
| 14. Building the structure of the P&L sheet.mp4 | 20.8 MB |
| 14. Building the structure of the P&L sheet.srt | 2.3 KB |
| 14.1 90. Building a P&L-Lecture-before.xlsm | 50.2 KB |
| 14.2 90. Building a P&L-Lecture-after.xlsm | 51.8 KB |
| 15. Formatting sets You apart from the competition in Excel - A Practical Example.mp4 | 25.4 MB |
| 15. Formatting sets You apart from the competition in Excel - A Practical Example.srt | 3.4 KB |
| 15.1 91. Formatting the P&L-Lecture-after.xlsm | 52.0 KB |
| 15.2 91. Formatting a P&L-Lecture-before.xlsm | 51.8 KB |
| 16. Populate the P&L sheet with SUMIF.mp4 | 30.3 MB |
| 16. Populate the P&L sheet with SUMIF.srt | 3.0 KB |
| 16.1 92. Formatting the P&L-Lecture-after.xlsm | 53.5 KB |
| 16.2 92. Formatting the P&L-Lecture-before.xlsm | 52.0 KB |
| 17. FAQ Why the sum of the check should be 0.html | 542 bytes |
| 18. Learn how to find mistakes with COUNTIF.mp4 | 27.9 MB |
| 18. Learn how to find mistakes with COUNTIF.srt | 2.8 KB |
| 18.1 93. Countif-Lecture-before.xlsm | 53.5 KB |
| 18.2 93. Countif-Lecture-after.xlsm | 54.8 KB |
| 19. Calculating year-on-year percentage variations the proper way.mp4 | 30.0 MB |
| 19. Calculating year-on-year percentage variations the proper way.srt | 3.3 KB |
| 19.1 94. Adding % variations-Lecture-after.xlsm | 56.5 KB |
| 19.2 Y-o-Y Function explanation.pdf | 164.9 KB |
| 19.3 94. Adding % variations-Lecture-before.xlsm | 54.8 KB |
| 2. Introduction to the case study.mp4 | 10.2 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.2 KB |
| 3. Understand your data source before you start working on it.mp4 | 28.2 MB |
| 3. Understand your data source before you start working on it.srt | 3.2 KB |
| 3.1 80. Get to know the data source.xlsm | 43.0 KB |
| 4. Order the source worksheets.mp4 | 26.5 MB |
| 4. Order the source worksheets.srt | 2.5 KB |
| 4.1 81. Order a worksheet_after.xlsm | 41.0 KB |
| 4.2 81. Order a worksheet_before.xlsm | 43.1 KB |
| 5. Create a code the best way to organize your data and work efficiently with it.mp4 | 24.5 MB |
| 5. Create a code the best way to organize your data and work efficiently with it.srt | 2.2 KB |
| 5.1 82. Creating a code_before.xlsm | 41.0 KB |
| 5.2 82. Creating a code_after.xlsm | 41.7 KB |
| 6. Learn how to create a database.mp4 | 20.7 MB |
| 6. Learn how to create a database.srt | 2.1 KB |
| 6.1 83. Creating a database_before.xlsm | 41.7 KB |
| 6.2 83. Creating a database_after.xlsm | 39.4 KB |
| 7. Use VLOOKUP to fill the database sheet.mp4 | 61.6 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.5 KB |
| 8. 50% completed!.mp4 | 4.3 MB |
| 8. 50% completed!.srt | 41 bytes |
| 9. Use SUMIF to complete the database sheet.mp4 | 47.9 MB |
| 9. Use SUMIF to complete the database sheet.srt | 4.4 KB |
| 9.1 86. Sumif_before.xlsm | 44.5 KB |
| 9.2 86. Sumif_after.xlsm | 49.5 KB |
| [CourseClub.Me].url | 48 bytes |
| [DesireCourse.Net].url | 51 bytes |
| [CourseClub.Me].url | 48 bytes |
| [DesireCourse.Net].url | 51 bytes |
Name
DL
Uploader
Size
S/L
Added
-
3.4 GB
[24
/
17]
2025-01-13
| Uploaded by FreeCourseWeb | Size 3.4 GB | Health [ 24 /17 ] | Added 2025-01-13 |
-
873.1 MB
[8
/
9]
2024-04-26
| Uploaded by freecoursewb | Size 873.1 MB | Health [ 8 /9 ] | Added 2024-04-26 |
-
388.6 MB
[0
/
1]
2023-10-25
| Uploaded by freecoursewb | Size 388.6 MB | Health [ 0 /1 ] | Added 2023-10-25 |
NOTE
SOURCE: Udemy Beginner to Pro in Excel Financial Modeling and Valuation Desire Course
-----------------------------------------------------------------------------------
COVER
-----------------------------------------------------------------------------------
MEDIAINFO
None
×