Name [Tutorialsplanet.NET] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation

File Type video

Size 4.72GB

UpdateDate 2025-3-19

hash *****054427F9DDF7B09750B07087C356AB9CA4

Hot 1

Files 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp4 | 8.94MB 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.vtt | 3.11KB 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1.1 Course Notes - Beginner to Pro in Excel.pdf.pdf | 19.03MB 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/2. Bonus! Welcome gift.html | 164B 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/3. Welcome gift number 2.html | 164B 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The best way to take this course.mp4 | 20.16MB 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The best way to take this course.vtt | 2.48KB 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/5. Download all course materials.html | 775B 10. Introduction to Excel charts/1. How to insert a chart in Excel.mp4 | 22.27MB 10. Introduction to Excel charts/1. How to insert a chart in Excel.vtt | 2.57KB 10. Introduction to Excel charts/1.1 95. Inserting-Charts-Lecture.xlsm.xlsm | 11.45MB 10. Introduction to Excel charts/2. Editing Excel charts.mp4 | 26.05MB 10. Introduction to Excel charts/2. Editing Excel charts.vtt | 2.90KB 10. Introduction to Excel charts/2.1 96. Formatting-a-Chart-Lecture.xlsm.xlsm | 11.45MB 10. Introduction to Excel charts/3. Excel chart formatting.mp4 | 32.74MB 10. Introduction to Excel charts/3. Excel chart formatting.vtt | 3.40KB 10. Introduction to Excel charts/3.1 97. Modifying-a-Chart-Lecture.xlsm.xlsm | 11.40MB 10. Introduction to Excel charts/4. How to create a bridge chart in Excel.mp4 | 13.66MB 10. Introduction to Excel charts/4. How to create a bridge chart in Excel.vtt | 1.92KB 10. Introduction to Excel charts/4.1 98. Bridge-Charts-Lecture.xlsx.xlsx | 13.10KB 10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.mp4 | 11.49MB 10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.vtt | 1.67KB 10. Introduction to Excel charts/5.1 99. Treemap-Charts-Lecture.xlsx.xlsx | 12.62KB 10. Introduction to Excel charts/6. Sparklines.mp4 | 27.56MB 10. Introduction to Excel charts/6. Sparklines.vtt | 4.17KB 10. Introduction to Excel charts/6.1 100. Sparklines-Lecture.xlsx.xlsx | 9.59KB 11/1. Create professional and good-looking charts - Introduction.mp4 | 6.21MB 11/1. Create professional and good-looking charts - Introduction.vtt | 727B 11/2. Build a column stacked chart with a secondary line axis in Excel.mp4 | 46.37MB 11/2. Build a column stacked chart with a secondary line axis in Excel.vtt | 5.63KB 11/2.1 102. Column stacked chart-Lecture-before.xlsm.xlsm | 11.50MB 11/2.2 102. Column stacked chart-Lecture-after.xlsm.xlsm | 11.50MB 11/3. Learn how to build effective doughnut charts in Excel.mp4 | 38.00MB 11/3. Learn how to build effective doughnut charts in Excel.vtt | 5.42KB 11/3.1 103. Doughnut chart-Lecture-after.xlsm.xlsm | 11.51MB 11/3.2 103. Doughnut chart-Lecture-before.xlsm.xlsm | 11.52MB 11/4. Learn how to build an area chart in Excel.mp4 | 28.58MB 11/4. Learn how to build an area chart in Excel.vtt | 3.48KB 11/4.1 104. Area chart-Lecture-after.xlsm.xlsm | 11.52MB 11/4.2 104. Area chart-Lecture-before.xlsm.xlsm | 11.51MB 11/5. Learn how to create bridge charts.mp4 | 52.07MB 11/5. Learn how to create bridge charts.vtt | 7.45KB 11/5.1 105. Bridge chart-Lecture-after.xlsm.xlsm | 11.54MB 11/5.2 105. Bridge chart-Lecture-before.xlsm.xlsm | 11.52MB 11/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4 | 136.12MB 11/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.vtt | 11.75KB 11/7. Case Study - Building a Complete P&L from scratch in Excel.html | 159B 11/8. Course Challenge - Apply your skills in practice!.mp4 | 7.92MB 11/8. Course Challenge - Apply your skills in practice!.vtt | 1.17KB 11/8.1 107. Course-Challenge - Solved.xlsx.xlsx | 543.93KB 11/8.2 107. Course-Challenge - Unsolved.xlsx.xlsx | 505.49KB 12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.mp4 | 12.06MB 12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.vtt | 2.45KB 12. Case Study - Building an FMCG Model from Scratch/1.1 108. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx.xlsx | 13.26MB 12. Case Study - Building an FMCG Model from Scratch/10. Combining Slicers and GETPIVOTDATA The key to our success.mp4 | 17.84MB 12. Case Study - Building an FMCG Model from Scratch/10. Combining Slicers and GETPIVOTDATA The key to our success.vtt | 3.40KB 12. Case Study - Building an FMCG Model from Scratch/10.1 117. Exercise-Build-an-FMCG-Model-Inserting-Slicers-Lecture.xlsx.xlsx | 20.77MB 12. Case Study - Building an FMCG Model from Scratch/11. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 | 17.12MB 12. Case Study - Building an FMCG Model from Scratch/11. Getting fancy with Excel slicers - Good-looking Excel slicers.vtt | 3.40KB 12. Case Study - Building an FMCG Model from Scratch/11.1 118. Exercise-Build-an-FMCG-Model-Complete-Lecture.xlsx.xlsx | 22.81MB 12. Case Study - Building an FMCG Model from Scratch/12. This is how the report can be used in practice by high-level executives.mp4 | 19.81MB 12. Case Study - Building an FMCG Model from Scratch/12. This is how the report can be used in practice by high-level executives.vtt | 4.38KB 12. Case Study - Building an FMCG Model from Scratch/12.1 119. Exercise-Build-an-FMCG-Model-Complete.xlsx.xlsx | 22.81MB 12. Case Study - Building an FMCG Model from Scratch/13. Dynamic reporting with GETPIVOTDATA and slicers.html | 163B 12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.mp4 | 22.60MB 12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.vtt | 2.43KB 12. Case Study - Building an FMCG Model from Scratch/2.1 109. Exercise-Build-an-FMCG-Model-Mapping-Lecture.xlsx.xlsx | 14.89MB 12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp4 | 21.95MB 12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.vtt | 3.84KB 12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.mp4 | 11.65MB 12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.vtt | 2.80KB 12. Case Study - Building an FMCG Model from Scratch/4.1 111. Exercise-Build-an-FMCG-Model-Structure-Lecture.xlsx.xlsx | 14.91MB 12. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.mp4 | 13.50MB 12. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.vtt | 4.63KB 12. Case Study - Building an FMCG Model from Scratch/5.1 112. Exercise-Build-an-FMCG-Model-Formatting-Lecture.xlsx.xlsx | 14.91MB 12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.mp4 | 8.84MB 12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.vtt | 4.63KB 12. Case Study - Building an FMCG Model from Scratch/6.1 113. Exercise-Build-an-FMCG-Model-Adding-Calculations-Lecture.xlsx.xlsx | 14.91MB 12. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.mp4 | 13.83MB 12. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.vtt | 2.10KB 12. Case Study - Building an FMCG Model from Scratch/7.1 114. Exercise-Build-an-FMCG-Model-Creating-a-Pivot-Table-Lecture.xlsx.xlsx | 20.81MB 12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4 | 31.04MB 12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.vtt | 6.68KB 12. Case Study - Building an FMCG Model from Scratch/8.1 115. Exercise-Build-an-FMCG-Model-GETPIVOTDATA-Lecture.xlsx.xlsx | 20.81MB 12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4 | 13.76MB 12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.vtt | 1.48KB 13. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.mp4 | 2.10MB 13. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.vtt | 1.07KB 13. Financial Modeling Fundamentals/10. Forecasting financials - Quiz.html | 160B 13. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.mp4 | 6.44MB 13. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.vtt | 2.72KB 13. Financial Modeling Fundamentals/12. Modeling the Income statement.mp4 | 12.43MB 13. Financial Modeling Fundamentals/12. Modeling the Income statement.vtt | 7.00KB 13. Financial Modeling Fundamentals/13. Modeling the Balance sheet - Part 1.mp4 | 5.22MB 13. Financial Modeling Fundamentals/13. Modeling the Balance sheet - Part 1.vtt | 3.18KB 13. Financial Modeling Fundamentals/14. Modeling the Balance sheet - Part 2.mp4 | 9.38MB 13. Financial Modeling Fundamentals/14. Modeling the Balance sheet - Part 2.vtt | 5.72KB 13. Financial Modeling Fundamentals/15. Building a financial model - Quiz.html | 160B 13. Financial Modeling Fundamentals/2. What is a financial model.mp4 | 4.59MB 13. Financial Modeling Fundamentals/2. What is a financial model.vtt | 2.35KB 13. Financial Modeling Fundamentals/3. Why use financial models.mp4 | 7.69MB 13. Financial Modeling Fundamentals/3. Why use financial models.vtt | 3.11KB 13. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.mp4 | 19.91MB 13. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.vtt | 6.86KB 13. Financial Modeling Fundamentals/5. Financial modeling - best practices.mp4 | 17.22MB 13. Financial Modeling Fundamentals/5. Financial modeling - best practices.vtt | 5.69KB 13. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.mp4 | 12.51MB 13. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.vtt | 5.49KB 13. Financial Modeling Fundamentals/7. Financial modeling - Quiz.html | 160B 13. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.mp4 | 5.68MB 13. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.vtt | 2.93KB 13. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.mp4 | 6.44MB 13. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.vtt | 3.34KB 14. Introduction to Company Valuation/1. The core theory behind Company Valuation.html | 164B 15. Introduction to Mergers & Acquisitions/1. Introduction to Mergers & Acquisitions.html | 164B 16/1. Valuation Case study - Welcome lecture.mp4 | 1.78MB 16/1. Valuation Case study - Welcome lecture.vtt | 869B 16/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4 | 30.01MB 16/10. Modeling other items Interest expenses, Extraordinary items and Taxes.vtt | 2.92KB 16/10.1 9. Interest expenses, taxes_before.xlsm.xlsm | 50.57KB 16/10.2 9. Interest expenses, taxes_after.xlsm.xlsm | 50.89KB 16/11. Forecasting Balance sheet items.mp4 | 4.66MB 16/11. Forecasting Balance sheet items.vtt | 914B 16/11.1 10. Introduction to Balance sheet items.xlsm.xlsm | 51.02KB 16/12. An introduction to the Days methodology.mp4 | 10.08MB 16/12. An introduction to the Days methodology.vtt | 1.77KB 16/12.1 Working Capital Days.pptx.pptx | 94.77KB 16/13. Calculation of DSO, DPO and DOI for the historical period.mp4 | 12.11MB 16/13. Calculation of DSO, DPO and DOI for the historical period.vtt | 1.36KB 16/13.1 12. Days calculation_before.xlsm.xlsm | 51.20KB 16/13.2 12. Days calculation_after.xlsm.xlsm | 51.47KB 16/14. Forecasting DSO, DPO and DOI.mp4 | 20.86MB 16/14. Forecasting DSO, DPO and DOI.vtt | 2.73KB 16/14.1 13. Forecasting DSO, DPO, DIO_before.xlsm.xlsm | 51.47KB 16/14.2 13. Forecasting DSO, DPO, DIO_after.xlsm.xlsm | 51.98KB 16/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4 | 22.63MB 16/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.vtt | 2.60KB 16/15.1 14. Forecasting PP&E, Other assets, and Other liabilities_after.xlsm.xlsm | 52.88KB 16/15.2 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm.xlsm | 51.98KB 16/16. Creating an output P&L sheet.mp4 | 18.80MB 16/16. Creating an output P&L sheet.vtt | 2.32KB 16/16.1 15. P&L structure_after.xlsm.xlsm | 53.67KB 16/16.2 15. P&L structure_before.xlsm.xlsm | 53.60KB 16/17. Populating the output P&L sheet.mp4 | 25.53MB 16/17. Populating the output P&L sheet.vtt | 2.44KB 16/17.1 16. Populating the P&L sheet_after.xlsm.xlsm | 55.32KB 16/17.2 16. Populating the P&L sheet_before.xlsm.xlsm | 53.67KB 16/18. Populating the output BS sheet.mp4 | 16.93MB 16/18. Populating the output BS sheet.vtt | 1.75KB 16/18.1 17. Populating BS sheet_before.xlsm.xlsm | 55.32KB 16/18.2 17. Populating BS sheet_after.xlsm.xlsm | 57.18KB 16/19. Completing the output BS sheet for the historical period.mp4 | 38.03MB 16/19. Completing the output BS sheet for the historical period.vtt | 4.09KB 16/19.1 18. Completing the Balance Sheet_after.xlsm.xlsm | 58.10KB 16/19.2 18. Completing the Balance Sheet_before.xlsm.xlsm | 57.18KB 16/2. Introduction to the DCF exercise.mp4 | 7.88MB 16/2. Introduction to the DCF exercise.vtt | 1.26KB 16/20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp4 | 22.76MB 16/20. Creating a structure for the calculation of Unlevered Free Cash Flows.vtt | 3.23KB 16/20.1 19. Cash flow structure_after.xlsm.xlsm | 58.58KB 16/20.2 19. Cash flow structure_before.xlsm.xlsm | 58.48KB 16/21. Bridging Unlevered free cash flow to Net cash flow.mp4 | 14.58MB 16/21. Bridging Unlevered free cash flow to Net cash flow.vtt | 2.11KB 16/21.1 20. Bridge UFCF to Net cash flow_before.xlsm.xlsm | 58.58KB 16/21.2 20. Bridge UFCF to Net cash flow_after.xlsm.xlsm | 58.70KB 16/22. Calculating Unlevered free cash flow.mp4 | 59.72MB 16/22. Calculating Unlevered free cash flow.vtt | 6.63KB 16/22.1 21. Calculating UFCF_after.xlsm.xlsm | 59.18KB 16/22.2 21. Calculating UFCF_before.xlsm.xlsm | 58.66KB 16/23. Calculating Net cash flow.mp4 | 37.90MB 16/23. Calculating Net cash flow.vtt | 4.23KB 16/23.1 22. Calculating Net Cash Flow_before.xlsm.xlsm | 59.18KB 16/23.2 Cash Flow Classification By Activities.xlsx | 55.95KB 16/23.3 22. Calculating Net Cash Flow_after.xlsm.xlsm | 59.38KB 16/24. Obtaining the rest of the cash flows through Find and Replace.mp4 | 46.73MB 16/24. Obtaining the rest of the cash flows through Find and Replace.vtt | 4.18KB 16/24.1 23. Find and replace_after.xlsm.xlsm | 62.50KB 16/24.2 23. Find and replace_before.xlsm.xlsm | 59.55KB 16/25. Introducing Weighted average cost of capital and Perpetuity growth.mp4 | 13.21MB 16/25. Introducing Weighted average cost of capital and Perpetuity growth.vtt | 2.20KB 16/25.1 24. Introducing WACC and g_before.xlsm.xlsm | 62.49KB 16/25.2 24. Introducing WACC and g_after.xlsm.xlsm | 62.58KB 16/26. Discounting Unlevered free cash flows to obtain their Present value.mp4 | 20.22MB 16/26. Discounting Unlevered free cash flows to obtain their Present value.vtt | 2.99KB 16/26.1 25. Calculating PV of Cash Flows_after.xlsm.xlsm | 62.71KB 16/26.2 25. Calculating PV of Cash Flows_before.xlsm.xlsm | 62.58KB 16/27. Calculating Continuing value and Enterprise value of the business.mp4 | 17.72MB 16/27. Calculating Continuing value and Enterprise value of the business.vtt | 2.33KB 16/27.1 26. Calculating CV and EV_after.xlsm.xlsm | 63.10KB 16/27.2 26. Calculating CV and EV_before.xlsm.xlsm | 62.71KB 16/28. Calculating Equity value.mp4 | 12.20MB 16/28. Calculating Equity value.vtt | 1.66KB 16/28.1 27. Calculating equity value_before.xlsm.xlsm | 63.10KB 16/28.2 27. Calculating equity value_after.xlsm.xlsm | 63.27KB 16/29. Sensitivity analysis for WACC and perpetuity growth.mp4 | 40.48MB 16/29. Sensitivity analysis for WACC and perpetuity growth.vtt | 4.56KB 16/29.1 28. Sensitivity analysis_before.xlsm.xlsm | 63.27KB 16/29.2 28. Sensitivity analysis_after.xlsm.xlsm | 64.83KB 16/29.3 Sensitivity Analysis.xlsx | 60.81KB 16/3. The stages of a complete DCF Valuation.mp4 | 49.24MB 16/3. The stages of a complete DCF Valuation.vtt | 6.61KB 16/3.1 Valuation exercise.pdf.pdf | 411.76KB 16/30. A possible application of Goal seek.mp4 | 15.62MB 16/30. A possible application of Goal seek.vtt | 1.94KB 16/30.1 29. Goal seek_before.xlsm.xlsm | 64.83KB 16/30.2 29. Goal seek_ater.xlsm.xlsm | 64.84KB 16/31. Using charts to summarize the results of the DCF model.mp4 | 32.88MB 16/31.1 30. Charts.xlsm.xlsm | 101.22KB 16/32. You made it!.mp4 | 11.27MB 16/32. You made it!.vtt | 2.90KB 16/4. Description of the structure of the DCF model.mp4 | 18.53MB 16/4. Description of the structure of the DCF model.vtt | 3.06KB 16/4.1 3. Structure of the DCF model.xlsm.xlsm | 47.90KB 16/4.2 DCF Model structure.pdf.pdf | 240.80KB 16/5. A glimpse at the company we are valuing - Cheeseco.mp4 | 15.67MB 16/5. A glimpse at the company we are valuing - Cheeseco.vtt | 1.35KB 16/5.1 Cheeseco.pptx.pptx | 80.09KB 16/6. Modeling the top line.mp4 | 26.30MB 16/6. Modeling the top line.vtt | 3.88KB 16/6.1 5. Modeling revenues_after.xlsm.xlsm | 48.16KB 16/6.2 5. Modeling revenues_before.xlsm.xlsm | 47.85KB 16/7. Introducing scenarios to the model with Choose.mp4 | 17.83MB 16/7. Introducing scenarios to the model with Choose.vtt | 2.49KB 16/7.1 6. Choose_after.xlsm.xlsm | 48.36KB 16/7.2 6. Choose_before.xlsm.xlsm | 48.16KB 16/8. Modeling other items Other revenues and Cogs.mp4 | 44.56MB 16/8. Modeling other items Other revenues and Cogs.vtt | 4.50KB 16/8.1 7. Other revenues and Cogs_after.xlsm.xlsm | 50.08KB 16/8.2 7. Other revenues and Cogs_before.xlsm.xlsm | 48.36KB 16/9. Modeling other items Operating expenses and D&A.mp4 | 26.33MB 16/9. Modeling other items Operating expenses and D&A.vtt | 2.53KB 16/9.1 8. Opex and D&A_before.xlsm.xlsm | 50.08KB 16/9.2 8. Opex and D&A_after.xlsm.xlsm | 50.57KB 17. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.mp4 | 31.01MB 17. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.vtt | 4.27KB 17. Tesla valuation - Complete practical exercise/1.1 Tesla 2017.pdf.pdf | 2.51MB 17. Tesla valuation - Complete practical exercise/1.2 Tesla 2016.pdf.pdf | 2.21MB 17. Tesla valuation - Complete practical exercise/1.3 0a. Drivers_before.xlsx.xlsx | 1.27MB 17. Tesla valuation - Complete practical exercise/1.4 Tesla 2018 Q2.pdf.pdf | 635.07KB 17. Tesla valuation - Complete practical exercise/1.5 Tesla Company Valuation - Detailed walkthrough.pdf.pdf | 5.08MB 17. Tesla valuation - Complete practical exercise/1.6 Tesla 2015.pdf.pdf | 1.29MB 17. Tesla valuation - Complete practical exercise/1.7 0a. Drivers_after.xlsx.xlsx | 1.27MB 17. Tesla valuation - Complete practical exercise/10. Forecasting 'energy' and 'services' revenue.mp4 | 25.29MB 17. Tesla valuation - Complete practical exercise/10. Forecasting 'energy' and 'services' revenue.vtt | 2.99KB 17. Tesla valuation - Complete practical exercise/10.1 6. Energy and Other revenue - Before.xlsx.xlsx | 1.34MB 17. Tesla valuation - Complete practical exercise/10.2 6. Energy and Other revenue - After.xlsx.xlsx | 1.34MB 17. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4 | 26.80MB 17. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.vtt | 2.36KB 17. Tesla valuation - Complete practical exercise/11.1 7. Energy and Other - Gross profit, cost of sales - Before.xlsx.xlsx | 1.35MB 17. Tesla valuation - Complete practical exercise/11.2 7. Energy and Other - Gross profit, cost of sales - After.xlsx.xlsx | 1.35MB 17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp4 | 34.91MB 17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.vtt | 5.15KB 17. Tesla valuation - Complete practical exercise/12.1 8. Opex - Before.xlsx.xlsx | 1.36MB 17. Tesla valuation - Complete practical exercise/12.2 8. Opex - After.xlsx.xlsx | 1.36MB 17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp4 | 56.58MB 17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.vtt | 6.10KB 17. Tesla valuation - Complete practical exercise/13.1 9. PP&E forecasting and comparables_before.xlsx.xlsx | 1.37MB 17. Tesla valuation - Complete practical exercise/13.2 9. PP&E forecasting and comparables_after.xlsx.xlsx | 1.37MB 17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp4 | 54.20MB 17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.vtt | 4.13KB 17. Tesla valuation - Complete practical exercise/14.1 10. PP&E schedule_after.xlsx.xlsx | 1.37MB 17. Tesla valuation - Complete practical exercise/14.2 10. PP&E schedule_before.xlsx.xlsx | 1.37MB 17. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.mp4 | 13.61MB 17. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.vtt | 1.62KB 17. Tesla valuation - Complete practical exercise/15.1 10a. PP&E comparison.xlsx.xlsx | 1.37MB 17. Tesla valuation - Complete practical exercise/16. Calculating DSO, DIO, DPO.mp4 | 17.52MB 17. Tesla valuation - Complete practical exercise/16. Calculating DSO, DIO, DPO.vtt | 2.03KB 17. Tesla valuation - Complete practical exercise/16.1 11. Working capital forecasting_before.xlsx.xlsx | 1.38MB 17. Tesla valuation - Complete practical exercise/16.2 11. Working capital forecasting_after.xlsx.xlsx | 1.52MB 17. Tesla valuation - Complete practical exercise/17. Producing a clean P&L output sheet.mp4 | 8.44MB 17. Tesla valuation - Complete practical exercise/17. Producing a clean P&L output sheet.vtt | 1.54KB 17. Tesla valuation - Complete practical exercise/17.1 12. P&L.xlsx.xlsx | 1.39MB 17. Tesla valuation - Complete practical exercise/18. Fill in the P&L output sheet.mp4 | 18.34MB 17. Tesla valuation - Complete practical exercise/18. Fill in the P&L output sheet.vtt | 1.74KB 17. Tesla valuation - Complete practical exercise/18.1 12a. P&L fill in_after.xlsx.xlsx | 1.39MB 17. Tesla valuation - Complete practical exercise/18.2 12a. P&L fill in_before.xlsx.xlsx | 1.39MB 17. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.mp4 | 19.03MB 17. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.vtt | 2.09KB 17. Tesla valuation - Complete practical exercise/19.1 13. Calculating working capital_after.xlsx.xlsx | 1.40MB 17. Tesla valuation - Complete practical exercise/19.2 13. Calculating working capital_before.xlsx.xlsx | 1.40MB 17. Tesla valuation - Complete practical exercise/2. The input data we will work with.mp4 | 15.81MB 17. Tesla valuation - Complete practical exercise/2. The input data we will work with.vtt | 1.58KB 17. Tesla valuation - Complete practical exercise/2.1 0aa. Inputs_before.xlsx.xlsx | 1.28MB 17. Tesla valuation - Complete practical exercise/2.2 0aa. Inputs_after.xlsx.xlsx | 1.28MB 17. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered free cash flow.mp4 | 55.93MB 17. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered free cash flow.vtt | 5.79KB 17. Tesla valuation - Complete practical exercise/20.1 14. Cash flow - UFCF_after.xlsx.xlsx | 1.41MB 17. Tesla valuation - Complete practical exercise/20.2 14. Cash flow - UFCF_before.xlsx.xlsx | 1.41MB 17. Tesla valuation - Complete practical exercise/21. Forecasting other assets.mp4 | 45.24MB 17. Tesla valuation - Complete practical exercise/21. Forecasting other assets.vtt | 4.33KB 17. Tesla valuation - Complete practical exercise/21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx | 1.41MB 17. Tesla valuation - Complete practical exercise/21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx | 1.41MB 17. Tesla valuation - Complete practical exercise/22. Forecasting other liabilities.mp4 | 21.97MB 17. Tesla valuation - Complete practical exercise/22. Forecasting other liabilities.vtt | 2.39KB 17. Tesla valuation - Complete practical exercise/22.1 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx | 1.42MB 17. Tesla valuation - Complete practical exercise/22.2 16. Balance Sheet forecasting liabilities_before.xlsx.xlsx | 1.41MB 17. Tesla valuation - Complete practical exercise/23. Completing Unlevered free cash flow.mp4 | 40.88MB 17. Tesla valuation - Complete practical exercise/23. Completing Unlevered free cash flow.vtt | 3.35KB 17. Tesla valuation - Complete practical exercise/23.1 16a. Complete UFCF_after.xlsx.xlsx | 1.42MB 17. Tesla valuation - Complete practical exercise/23.2 16a. Complete UFCF_before.xlsx.xlsx | 1.42MB 17. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.mp4 | 42.35MB 17. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.vtt | 5.04KB 17. Tesla valuation - Complete practical exercise/24.1 17. Financing_before.xlsx.xlsx | 1.43MB 17. Tesla valuation - Complete practical exercise/24.2 17. Financing_after.xlsx.xlsx | 1.43MB 17. Tesla valuation - Complete practical exercise/25. Calculating Net income.mp4 | 14.80MB 17. Tesla valuation - Complete practical exercise/25. Calculating Net income.vtt | 1.29KB 17. Tesla valuation - Complete practical exercise/25.1 18. P&L complete_before.xlsx.xlsx | 1.43MB 17. Tesla valuation - Complete practical exercise/25.2 18. P&L complete_after.xlsx.xlsx | 1.43MB 17. Tesla valuation - Complete practical exercise/26. Bridging Unlevered free cash flow to Net cash flow.mp4 | 50.72MB 17. Tesla valuation - Complete practical exercise/26. Bridging Unlevered free cash flow to Net cash flow.vtt | 4.17KB 17. Tesla valuation - Complete practical exercise/26.1 19. Cash flow_complete_after.xlsx.xlsx | 1.43MB 17. Tesla valuation - Complete practical exercise/26.2 19. Cash flow_complete_before.xlsx.xlsx | 1.43MB 17. Tesla valuation - Complete practical exercise/27. Balancing the Balance sheet.mp4 | 13.27MB 17. Tesla valuation - Complete practical exercise/27. Balancing the Balance sheet.vtt | 1.12KB 17. Tesla valuation - Complete practical exercise/27.1 20. Complete the BS_before.xlsx.xlsx | 1.43MB 17. Tesla valuation - Complete practical exercise/27.2 20. Complete the BS_after.xlsx.xlsx | 1.43MB 17. Tesla valuation - Complete practical exercise/28. Estimating Weighted average cost of capital (WACC).mp4 | 44.27MB 17. Tesla valuation - Complete practical exercise/28. Estimating Weighted average cost of capital (WACC).vtt | 6.36KB 17. Tesla valuation - Complete practical exercise/28.1 21. WACC_before.xlsx.xlsx | 1.43MB 17. Tesla valuation - Complete practical exercise/28.2 21. WACC_after.xlsx.xlsx | 1.43MB 17. Tesla valuation - Complete practical exercise/29. Performing discounted cash flow valuation (DCF).mp4 | 34.90MB 17. Tesla valuation - Complete practical exercise/29. Performing discounted cash flow valuation (DCF).vtt | 3.83KB 17. Tesla valuation - Complete practical exercise/29.1 22. DCF_after.xlsx.xlsx | 1.44MB 17. Tesla valuation - Complete practical exercise/29.2 22. DCF_before.xlsx.xlsx | 1.52MB 17. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.mp4 | 114.90MB 17. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.vtt | 14.38KB 17. Tesla valuation - Complete practical exercise/3.1 1. Deliveries_before.xlsx.xlsx | 1.29MB 17. Tesla valuation - Complete practical exercise/3.2 1. Deliveries_after.xlsx.xlsx | 1.29MB 17. Tesla valuation - Complete practical exercise/30. Calculating enterprise value, equity value, and price per share.mp4 | 22.55MB 17. Tesla valuation - Complete practical exercise/30. Calculating enterprise value, equity value, and price per share.vtt | 2.01KB 17. Tesla valuation - Complete practical exercise/30.1 23. EV, Equity value, Price per share_before.xlsx.xlsx | 1.44MB 17. Tesla valuation - Complete practical exercise/30.2 23. EV, Equity value, Price per share_after.xlsx.xlsx | 1.44MB 17. Tesla valuation - Complete practical exercise/31. Final comments.mp4 | 44.88MB 17. Tesla valuation - Complete practical exercise/31. Final comments.vtt | 4.18KB 17. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.mp4 | 20.94MB 17. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.vtt | 3.01KB 17. Tesla valuation - Complete practical exercise/4.1 1a. Deliveries development.xlsx.xlsx | 1.30MB 17. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.mp4 | 41.92MB 17. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.vtt | 4.80KB 17. Tesla valuation - Complete practical exercise/5.1 2. Average price_before.xlsx.xlsx | 1.31MB 17. Tesla valuation - Complete practical exercise/5.2 2. Average price_after.xlsx.xlsx | 1.31MB 17. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.mp4 | 46.56MB 17. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.vtt | 4.79KB 17. Tesla valuation - Complete practical exercise/6.1 3. Revenue calculation and scenarios - before.xlsx.xlsx | 1.31MB 17. Tesla valuation - Complete practical exercise/6.2 3. Revenue calculation and scenarios - after.xlsx.xlsx | 1.31MB 17. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.mp4 | 17.18MB 17. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.vtt | 2.60KB 17. Tesla valuation - Complete practical exercise/7.1 4. Gross profit automotive.xlsx.xlsx | 1.32MB 17. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.mp4 | 27.77MB 17. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.vtt | 2.83KB 17. Tesla valuation - Complete practical exercise/8.1 4a. Gross profit automotive - before.xlsx.xlsx | 1.51MB 17. Tesla valuation - Complete practical exercise/8.2 4a. Gross profit automotive - after.xlsx.xlsx | 1.32MB 17. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.mp4 | 17.49MB 17. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.vtt | 2.14KB 17. Tesla valuation - Complete practical exercise/9.1 5. Cost of sales and chart.xlsx.xlsx | 1.34MB 18. Capital budgeting - The theory/1. Introduction to Capital budgeting.mp4 | 5.43MB 18. Capital budgeting - The theory/1. Introduction to Capital budgeting.vtt | 1.79KB 18. Capital budgeting - The theory/2. Why we need Capital budgeting.mp4 | 6.89MB 18. Capital budgeting - The theory/2. Why we need Capital budgeting.vtt | 2.61KB 18. Capital budgeting - The theory/3. The time value of money.mp4 | 6.70MB 18. Capital budgeting - The theory/3. The time value of money.vtt | 2.79KB 18. Capital budgeting - The theory/4. Calculating future and present Value.mp4 | 13.08MB 18. Capital budgeting - The theory/4. Calculating future and present Value.vtt | 6.27KB 18. Capital budgeting - The theory/5. Calculating cost of equity.mp4 | 19.21MB 18. Capital budgeting - The theory/5. Calculating cost of equity.vtt | 7.44KB 18. Capital budgeting - The theory/6. Coming up with project-specific beta.mp4 | 9.01MB 18. Capital budgeting - The theory/6. Coming up with project-specific beta.vtt | 3.49KB 18. Capital budgeting - The theory/7. Weighted average cost of capital (WACC).mp4 | 5.50MB 18. Capital budgeting - The theory/7. Weighted average cost of capital (WACC).vtt | 2.34KB 18. Capital budgeting - The theory/8. The type of cash flows we will have in a project.mp4 | 9.34MB 18. Capital budgeting - The theory/8. The type of cash flows we will have in a project.vtt | 3.88KB 18. Capital budgeting - The theory/9. Estimating the project's cash flows.mp4 | 18.79MB 18. Capital budgeting - The theory/9. Estimating the project's cash flows.vtt | 6.68KB 19. Capital Budgeting - A Complete Case Study/1. Introduction to the Capital budgeting exercise.mp4 | 8.63MB 19. Capital Budgeting - A Complete Case Study/1. Introduction to the Capital budgeting exercise.vtt | 3.23KB 19. Capital Budgeting - A Complete Case Study/10. Finding cost of equity.mp4 | 13.92MB 19. Capital Budgeting - A Complete Case Study/10. Finding cost of equity.vtt | 7.16KB 19. Capital Budgeting - A Complete Case Study/10.1 8. WACC_unsolved.xlsx.xlsx | 35.93KB 19. Capital Budgeting - A Complete Case Study/10.2 8. WACC.xlsx.xlsx | 38.03KB 19. Capital Budgeting - A Complete Case Study/11. Discounting the project's cash flows and residual value.mp4 | 25.90MB 19. Capital Budgeting - A Complete Case Study/11. Discounting the project's cash flows and residual value.vtt | 3.51KB 19. Capital Budgeting - A Complete Case Study/11.1 9. Discounted cash flow_unsolved.xlsx.xlsx | 38.72KB 19. Capital Budgeting - A Complete Case Study/11.2 9. Discounted cash flow.xlsx.xlsx | 39.74KB 19. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and completing the exercise.mp4 | 43.04MB 19. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and completing the exercise.vtt | 5.28KB 19. Capital Budgeting - A Complete Case Study/12.1 10. Sensitivity analysis.xlsx.xlsx | 40.67KB 19. Capital Budgeting - A Complete Case Study/12.2 10. Sensitivity analysis_unsolved.xlsx.xlsx | 39.70KB 19. Capital Budgeting - A Complete Case Study/13. Build a complete capital budgeting model from scratch.html | 163B 19. Capital Budgeting - A Complete Case Study/14. Congratulations!!.mp4 | 2.30MB 19. Capital Budgeting - A Complete Case Study/14. Congratulations!!.vtt | 1.50KB 19. Capital Budgeting - A Complete Case Study/2. Organizing an Inputs sheet.mp4 | 11.05MB 19. Capital Budgeting - A Complete Case Study/2. Organizing an Inputs sheet.vtt | 6.22KB 19. Capital Budgeting - A Complete Case Study/2.1 1. Drivers.xlsx.xlsx | 11.50KB 19. Capital Budgeting - A Complete Case Study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4 | 9.21MB 19. Capital Budgeting - A Complete Case Study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.vtt | 4.12KB 19. Capital Budgeting - A Complete Case Study/3.1 2. Savings Forecast.xlsx.xlsx | 16.58KB 19. Capital Budgeting - A Complete Case Study/3.2 2. Savings Forecast_unsolved.xlsx.xlsx | 14.74KB 19. Capital Budgeting - A Complete Case Study/4. Fixed asset rollforward.mp4 | 12.15MB 19. Capital Budgeting - A Complete Case Study/4. Fixed asset rollforward.vtt | 5.28KB 19. Capital Budgeting - A Complete Case Study/4.1 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx | 18.54KB 19. Capital Budgeting - A Complete Case Study/4.2 3. Fixed Asset Rollforward.xlsx.xlsx | 19.66KB 19. Capital Budgeting - A Complete Case Study/5. The impact of working capital.mp4 | 5.37MB 19. Capital Budgeting - A Complete Case Study/5. The impact of working capital.vtt | 2.85KB 19. Capital Budgeting - A Complete Case Study/5.1 4. Working Capital.xlsx.xlsx | 21.93KB 19. Capital Budgeting - A Complete Case Study/5.2 4. Working Capital_unsolved.xlsx.xlsx | 21.19KB 19. Capital Budgeting - A Complete Case Study/6. Modeling debt financing.mp4 | 6.18MB 19. Capital Budgeting - A Complete Case Study/6. Modeling debt financing.vtt | 3.30KB 19. Capital Budgeting - A Complete Case Study/6.1 5. Financing_unsolved.xlsx.xlsx | 29.99KB 19. Capital Budgeting - A Complete Case Study/6.2 5. Financing.xlsx.xlsx | 30.97KB 19. Capital Budgeting - A Complete Case Study/7. Adding a P&L sheet.mp4 | 4.88MB 19. Capital Budgeting - A Complete Case Study/7. Adding a P&L sheet.vtt | 2.12KB 19. Capital Budgeting - A Complete Case Study/7.1 6. P&L.xlsx.xlsx | 31.03KB 19. Capital Budgeting - A Complete Case Study/7.2 6. P&L_unsolved.xlsx.xlsx | 29.70KB 19. Capital Budgeting - A Complete Case Study/8. Calculating project cash flows.mp4 | 10.15MB 19. Capital Budgeting - A Complete Case Study/8. Calculating project cash flows.vtt | 3.70KB 19. Capital Budgeting - A Complete Case Study/8.1 7. Cash flow_unsolved.xlsx.xlsx | 29.64KB 19. Capital Budgeting - A Complete Case Study/8.2 7. Cash flow.xlsx.xlsx | 31.36KB 19. Capital Budgeting - A Complete Case Study/9. Estimating the weighted average cost of capital (WACC).mp4 | 5.59MB 19. Capital Budgeting - A Complete Case Study/9. Estimating the weighted average cost of capital (WACC).vtt | 3.26KB 19. Capital Budgeting - A Complete Case Study/9.1 8. WACC.xlsx.xlsx | 38.03KB 19. Capital Budgeting - A Complete Case Study/9.2 8. WACC_unsolved.xlsx.xlsx | 35.93KB 2. Introduction to Excel/1. Introduction to Excel - welcome lecture.mp4 | 1.99MB 2. Introduction to Excel/1. Introduction to Excel - welcome lecture.vtt | 911B 2. Introduction to Excel/10. Introduction to Excel formulas.html | 160B 2. Introduction to Excel/11. Introduction to Excel functions.mp4 | 12.05MB 2. Introduction to Excel/11. Introduction to Excel functions.vtt | 4.36KB 2. Introduction to Excel/11.1 13. Functions- Exercise - Solved.xlsx.xlsx | 81.10KB 2. Introduction to Excel/11.2 13. Functions - Lecture -Solved.xlsx.xlsx | 9.34KB 2. Introduction to Excel/11.3 Introduction-to-Excels-basic-features.pdf.pdf | 2.27MB 2. Introduction to Excel/11.4 13. Functions- Lecture - Unsolved.xlsx.xlsx | 9.24KB 2. Introduction to Excel/11.5 13. Functions-Exercise - Unsolved.xlsx.xlsx | 13.26KB 2. Introduction to Excel/12. Cut, copy, & paste.mp4 | 7.57MB 2. Introduction to Excel/12. Cut, copy, & paste.vtt | 2.30KB 2. Introduction to Excel/12.1 Introduction-to-Excels-basic-features.pdf.pdf | 2.27MB 2. Introduction to Excel/12.2 14. Copy-Cut-Paste-Exercise - Unsolved.xlsx.xlsx | 11.34KB 2. Introduction to Excel/12.3 14. Copy-Cut-Paste-Exercise - Solved.xlsx.xlsx | 12.56KB 2. Introduction to Excel/13. Cut, copy, & paste.html | 160B 2. Introduction to Excel/14. Paste special.mp4 | 6.70MB 2. Introduction to Excel/14. Paste special.vtt | 1.49KB 2. Introduction to Excel/14.1 15. Paste-Special-Exercise - Unsolved.xlsx.xlsx | 13.47KB 2. Introduction to Excel/14.2 15. Paste-Special-Exercise - Solved.xlsx.xlsx | 13.46KB 2. Introduction to Excel/14.3 Introduction-to-Excels-basic-features.pdf.pdf | 2.27MB 2. Introduction to Excel/15. Basic operations in Excel - 38 pages.html | 164B 2. Introduction to Excel/2. Overview of Excel.mp4 | 13.95MB 2. Introduction to Excel/2. Overview of Excel.vtt | 3.87KB 2. Introduction to Excel/2.1 7. Introduction to Excel.pdf.pdf | 2.26MB 2. Introduction to Excel/2.2 7. Overview-of-Excel-Exercise-Solved.xlsx.xlsx | 10.88KB 2. Introduction to Excel/2.3 7. Overview-of-Excel-Exercise-Unsolved.xlsx.xlsx | 10.47KB 2. Introduction to Excel/3. Overview of Excel.html | 160B 2. Introduction to Excel/4. Basic manipulations with rows and columns.mp4 | 6.91MB 2. Introduction to Excel/4. Basic manipulations with rows and columns.vtt | 1.96KB 2. Introduction to Excel/4.1 8. Basic manipulations - Lecture.xlsx.xlsx | 8.07KB 2. Introduction to Excel/4.2 8. Basic-Manipulations - Exercise - Unsolved.xlsx.xlsx | 11.06KB 2. Introduction to Excel/4.3 8. Basic-Manipulations - Exercise - Solved.xlsx.xlsx | 32.43KB 2. Introduction to Excel/5. Rows and columns.html | 160B 2. Introduction to Excel/6. The Excel ribbon.mp4 | 8.81MB 2. Introduction to Excel/6. The Excel ribbon.vtt | 2.99KB 2. Introduction to Excel/6.1 9. The-Ribbon-Exercise-Solved.xlsx.xlsx | 403.25KB 2. Introduction to Excel/6.2 9. The-Ribbon-Exercise-Exercise - Unsolved.xlsx.xlsx | 12.09KB 2. Introduction to Excel/7. Data entry in Excel.mp4 | 10.39MB 2. Introduction to Excel/7. Data entry in Excel.vtt | 3.32KB 2. Introduction to Excel/7.1 10. Data-Entry - Lecture.xlsx.xlsx | 8.07KB 2. Introduction to Excel/7.2 10. Data-Entry-Exercise - Unsolved.xlsx.xlsx | 10.97KB 2. Introduction to Excel/7.3 10. Data-Entry- Exercise -Solved.xlsx.xlsx | 32.76KB 2. Introduction to Excel/8. Introduction to formatting.mp4 | 24.75MB 2. Introduction to Excel/8. Introduction to formatting.vtt | 6.14KB 2. Introduction to Excel/8.1 11. Formatting - Lecture - Solved.xlsx.xlsx | 9.85KB 2. Introduction to Excel/8.2 11. Formatting-Exercise - Unsolved.xlsx.xlsx | 11.61KB 2. Introduction to Excel/8.3 11. Formatting- Exercise - Solved.xlsx.xlsx | 11.59KB 2. Introduction to Excel/8.4 11. Formatting- Lecture - Unsolved.xlsx.xlsx | 8.91KB 2. Introduction to Excel/9. Introduction to Excel formulas.mp4 | 23.68MB 2. Introduction to Excel/9. Introduction to Excel formulas.vtt | 4.09KB 2. Introduction to Excel/9.1 12. Formulas- Lecture - Solved.xlsx.xlsx | 9.36KB 2. Introduction to Excel/9.2 12. Formulas- Lecture - Unsolved.xlsx.xlsx | 9.30KB 2. Introduction to Excel/9.3 12. Formulas- Exercise - Solved.xlsx.xlsx | 80.13KB 2. Introduction to Excel/9.4 12. Formulas - Exercise - Unsolved.xlsx.xlsx | 11.72KB 2. Introduction to Excel/9.5 Introduction-to-Excels-basic-features.pdf.pdf | 2.26MB 20. Bonus lecture/1. Bonus lecture Next steps.html | 2.13KB 3/1. Excel best practices - Welcome lecture.mp4 | 2.13MB 3/1. Excel best practices - Welcome lecture.vtt | 1.02KB 3/10. Learn how to organize your data with Text to Columns.html | 160B 3/11. Learn how to use the Wrap Text button.mp4 | 2.15MB 3/11. Learn how to use the Wrap Text button.vtt | 869B 3/11.1 24. Wrap-Text-Exercise - Solved.xlsx.xlsx | 10.20KB 3/11.2 24. Wrap-text-Lecture - Solved.xlsx.xlsx | 9.61KB 3/11.3 24. Wrap-Text-Exercise - Unsolved.xlsx.xlsx | 10.17KB 3/11.4 24. Wrap-text-Lecture - Unsolved.xlsx.xlsx | 9.61KB 3/11.5 Useful-Tips-Tools.pdf.pdf | 3.31MB 3/12. Create easily printable documents in Excel by using Set Print Area.mp4 | 4.74MB 3/12. Create easily printable documents in Excel by using Set Print Area.vtt | 1.50KB 3/12.1 25. Set-Print-Area-Lecture - Unsolved.xlsx.xlsx | 11.42KB 3/12.2 25. Set-Print-Area-Lecture - Solved.xlsx.xlsx | 11.22KB 3/12.3 Useful-Tips-Tools.pdf.pdf | 3.31MB 3/13. Find and select special types of cells with Select Special (F5).mp4 | 9.78MB 3/13. Find and select special types of cells with Select Special (F5).vtt | 1.83KB 3/13.1 26. Select-Special-Lecture.xlsx.xlsx | 10.56KB 3/13.2 26. Select-Special-F5-Exercise - Solved.xlsx.xlsx | 22.27KB 3/13.3 26. Select-Special-F5-Exercise - Unsolved.xlsx.xlsx | 21.59KB 3/13.4 Useful-Tips-Tools.pdf.pdf | 3.31MB 3/14. Select Special.html | 160B 3/15. Learn how to assign dynamic names within a financial model.mp4 | 7.32MB 3/15. Learn how to assign dynamic names within a financial model.vtt | 1.56KB 3/15.1 27. Dynamic-Naming-Lecture - Unsolved.xlsx.xlsx | 13.54KB 3/15.2 Useful-Tips-Tools.pdf.pdf | 3.31MB 3/15.3 27. Assigning-Dynamic-Names-Exercise - Solved.xlsx.xlsx | 11.73KB 3/15.4 27. Dynamic-Naming-Lecture - Solved.xlsx.xlsx | 13.83KB 3/15.5 27. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx.xlsx | 11.23KB 3/16. Assigning dynamic names.html | 160B 3/17. Define a named range in Excel.mp4 | 5.42MB 3/17. Define a named range in Excel.vtt | 1.62KB 3/17.1 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx.xlsx | 11.07KB 3/17.2 28. Naming-ranges-Lecture - Unsolved.xlsx.xlsx | 8.79KB 3/17.3 28. Naming-ranges-Lecture - Solved.xlsx.xlsx | 10.34KB 3/17.4 Useful-Tips-Tools.pdf.pdf | 3.31MB 3/17.5 28. Defining-a-Named-Range-Exercise - Solved.xlsx.xlsx | 11.65KB 3/18. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4 | 5.41MB 3/18. Assign custom formats to specific cells within a financial model (e.g Multiples).vtt | 1.87KB 3/18.1 29. Assigning Custom Formats - Exercise - Unsolved.xlsx.xlsx | 11.35KB 3/18.2 Useful-Tips-Tools.pdf.pdf | 3.30MB 3/18.3 29. Assigning Custom Formats - Exercise - Solved.xlsx.xlsx | 11.08KB 3/19. Macros are a great timesaver! Here's why!.mp4 | 11.10MB 3/19. Macros are a great timesaver! Here's why!.vtt | 3.34KB 3/19.1 Useful-Tips-Tools.pdf.pdf | 3.30MB 3/19.2 30. Creating-a-Macro-Lecture - Solved.xlsx.xlsx | 11.17KB 3/19.3 30. Macros-Exercise - Solved.xlsx.xlsx | 145.02KB 3/19.4 30. Creating-a-Macro-Lecture - Unsolved.xlsx.xlsx | 9.66KB 3/19.5 30. Macros-Exercise - Unsolved.xlsx.xlsx | 10.34KB 3/2. Initial formatting of an Excel sheet to render it professional.mp4 | 7.99MB 3/2. Initial formatting of an Excel sheet to render it professional.vtt | 2.16KB 3/2.1 18. Formatting-a-Worksheet-Exercise - Unsolved.xlsx.xlsx | 10.63KB 3/2.2 18. Formatting-a-Worksheet-Exercise - Solved.xlsx.xlsx | 10.76KB 3/2.3 Useful-Tips-Tools.pdf.pdf | 3.30MB 3/2.4 18. Formatting-a-worksheet-Lecture - Solved.xlsx.xlsx | 9.56KB 3/2.5 18. Formatting-a-worksheet-Lecture - Unsolved.xlsx.xlsx | 8.98KB 3/20. How to save macros and use them across several workbooks.mp4 | 12.78MB 3/20. How to save macros and use them across several workbooks.vtt | 1.72KB 3/20.1 31. Another-file.xlsx.xlsx | 8.81KB 3/20.2 31. How-to-save-macros-Lecture-before.xlsx.xlsx | 6.02KB 3/20.3 31. How-to-save-macros-Lecture-after.xlsm.xlsm | 12.59KB 3/21. Excel Macros - quiz.html | 160B 3/22. Create a drop-down list by using Data Validation.mp4 | 10.59MB 3/22. Create a drop-down list by using Data Validation.vtt | 2.10KB 3/22.1 32. Data-Validation-Lecture - Solved.xlsx.xlsx | 10.84KB 3/22.2 32. Drop-down-List-Exercise - Solved.xlsx.xlsx | 77.02KB 3/22.3 32. Drop-down-List-Exercise - Unsolved.xlsx.xlsx | 11.34KB 3/22.4 32. Data-Validation-Lecture - Unsolved.xlsx.xlsx | 10.84KB 3/22.5 Useful-Tips-Tools.pdf.pdf | 3.31MB 3/23. Using Custom-sort in order to sort multiple columns within a table.mp4 | 9.15MB 3/23. Using Custom-sort in order to sort multiple columns within a table.vtt | 1.59KB 3/23.1 33. Custom-Sort-Exercise - Unsolved.xlsx.xlsx | 11.37KB 3/23.2 33. Sort-data-Lecture - Solved.xlsx.xlsx | 145.65KB 3/23.3 33. Sort-data-Lecture - Unsolved.xlsx.xlsx | 145.35KB 3/23.4 Useful-Tips-Tools.pdf.pdf | 3.31MB 3/23.5 33. Custom-Sort-Exercise - Solved.xlsx.xlsx | 11.46KB 3/24. Create a great Index page at the beginning of your models - Hyperlinks.mp4 | 5.35MB 3/24. Create a great Index page at the beginning of your models - Hyperlinks.vtt | 1.51KB 3/24.1 34. Hyperlinks-Exercise - Unsolved.xlsx.xlsx | 136.89KB 3/24.2 34. Hyperlinks-Exercise - Solved.xlsx.xlsx | 137.06KB 3/24.3 Useful-Tips-Tools.pdf.pdf | 3.30MB 3/25. Fix the top row of your table with Freeze Panes.mp4 | 17.67MB 3/25. Fix the top row of your table with Freeze Panes.vtt | 1.42KB 3/25.1 35. Freeze-Panes-Lecture - Unsolved.xlsx.xlsx | 643.87KB 3/25.2 35. Freeze-Panes-Lecture - Solved.xlsx.xlsx | 643.94KB 3/25.3 Useful-Tips-Tools.pdf.pdf | 3.31MB 3/26. Filter by color - an excellent tool.mp4 | 9.88MB 3/26. Filter by color - an excellent tool.vtt | 1.99KB 3/26.1 36. Exercise-Filter-by-Color-Unsolved.xlsx.xlsx | 20.47KB 3/26.2 36. Exercise-Filter-by-Color-Solved.xlsx.xlsx | 153.48KB 3/27. Working with conditional formatting.mp4 | 15.08MB 3/27. Working with conditional formatting.vtt | 5.61KB 3/27.1 Solution_Conditional Formatting.xlsx.xlsx | 51.52KB 3/27.2 Exercise_Conditional Formatting.xlsx.xlsx | 12.88KB 3/28. A neat trick - Multiply by 1.mp4 | 14.84MB 3/28. A neat trick - Multiply by 1.vtt | 1.64KB 3/28.1 38. Multiply-by-1-Lecture-before.xlsx.xlsx | 16.47KB 3/28.2 38. Multiply-by-1-Lecture-after.xlsx.xlsx | 17.21KB 3/29. Useful tips and tools for your work in Excel - quiz.html | 159B 3/3. Fast scrolling through Excel sheets.mp4 | 22.16MB 3/3. Fast scrolling through Excel sheets.vtt | 1.73KB 3/3.1 Useful-Tips-Tools.pdf.pdf | 3.31MB 3/3.2 19. Fast-Scrolling-Exercise - Unsolved.xlsx.xlsx | 43.90KB 3/3.3 19. Fast-Scrolling-Exercise - Solved.xlsx.xlsx | 44.35KB 3/3.4 19. Fast-Scrolling - Lecture.xlsx.xlsx | 642.82KB 3/30. Find and replace - references.mp4 | 24.04MB 3/30. Find and replace - references.vtt | 3.32KB 3/30.1 39. Find-and-Replace-references-Lecture-after.xlsx.xlsx | 37.91KB 3/30.2 39. Find-and-Replace-references-Lecture-before.xlsx.xlsx | 38.79KB 3/31. Find and replace - formatting.mp4 | 13.78MB 3/31. Find and replace - formatting.vtt | 1.88KB 3/31.1 40. Find-replace-Lecture-before.xlsx.xlsx | 17.19KB 3/31.2 40. Find-replace-Lecture-after.xlsx.xlsx | 17.19KB 3/32. Removing (automatic) green arrows.mp4 | 12.60MB 3/32. Removing (automatic) green arrows.vtt | 1.63KB 3/32.1 41. Green-references-Lecture.xlsx.xlsx | 12.00KB 3/33. Beauty saving - The professional way of saving files.mp4 | 14.02MB 3/33. Beauty saving - The professional way of saving files.vtt | 2.59KB 3/33.1 42. Beauty-saving-Lecture-before.xlsx.xlsx | 17.17KB 3/33.2 42. Beauty-saving-Lecture-after.xlsx.xlsx | 17.05KB 3/34. Formula auditing with F2.mp4 | 17.74MB 3/34. Formula auditing with F2.vtt | 2.14KB 3/34.1 43. F2-Lecture.xlsm.xlsm | 50.76KB 3/4. Be even quicker F5 + Enter.mp4 | 19.78MB 3/4. Be even quicker F5 + Enter.vtt | 2.11KB 3/4.1 20. F5-go-to - Lecture.xlsm.xlsm | 50.76KB 3/5. Fast scrolling through Excel sheets.html | 160B 3/6. Introduction to fixing of cell references.mp4 | 20.37MB 3/6. Introduction to fixing of cell references.vtt | 2.53KB 3/6.1 Useful-Tips-Tools.pdf.pdf | 3.31MB 3/6.2 21. Fixing-Cells-Exercise - Unsolved.xlsx.xlsx | 10.67KB 3/6.3 21. Fixing-references-Lecture - Unsolved.xlsx.xlsx | 643.98KB 3/6.4 21. Fixing-Cells-Exercise - Solved.xlsx.xlsx | 10.82KB 3/6.5 21. Fixing-references-Lecture - Solved.xlsx.xlsx | 645.17KB 3/7. Introduction to fixing of cell references.html | 160B 3/8. Using the 'Alt + Enter' combination.mp4 | 3.33MB 3/8. Using the 'Alt + Enter' combination.vtt | 1008B 3/8.1 22. Alt-Enter-Exercise - Unsolved.xlsx.xlsx | 11.12KB 3/8.2 22. Alt-Enter- Lecture - Unsolved.xlsx.xlsx | 9.64KB 3/8.3 22. Alt-Enter- Lecture - Solved.xlsx.xlsx | 9.65KB 3/8.4 22. Alt-Enter-Exercise - Solved.xlsx.xlsx | 11.40KB 3/9. Learn how to organize your data with Text to Columns.mp4 | 12.54MB 3/9. Learn how to organize your data with Text to Columns.vtt | 2.21KB 3/9.1 23. Text-to-Columns-Exercise - Solved.xlsx.xlsx | 11.30KB 3/9.2 23. Text-to-Columns-Exercise - Unsolved.xlsx.xlsx | 10.57KB 3/9.3 23. Text-to-columns-Lecture - Unsolved.xlsx.xlsx | 9.76KB 3/9.4 Useful-Tips-Tools.pdf.pdf | 3.31MB 3/9.5 23.Text-to-columns-Lecture - Solved.xlsx.xlsx | 9.90KB 4. Keyboard shortcuts in Excel/1. Keyboard shortcuts Save LOTS of time in Excel.mp4 | 30.43MB 4. Keyboard shortcuts in Excel/1. Keyboard shortcuts Save LOTS of time in Excel.vtt | 5.16KB 4. Keyboard shortcuts in Excel/2. Keyboard shortcuts in Excel.html | 164B 5/1. Excel's key functions - Welcome lecture.mp4 | 2.31MB 5/1. Excel's key functions - Welcome lecture.vtt | 1.09KB 5/10. Working with text in Excel.mp4 | 16.01MB 5/10. Working with text in Excel.vtt | 3.03KB 5/10.1 53. Work-with-text-Lecture-after.xlsx.xlsx | 10.91KB 5/10.2 53. Work-with-text-Lecture-before.xlsx.xlsx | 10.33KB 5/11. Find the minimum or maximum value in a range of cells in Excel.mp4 | 5.91MB 5/11. Find the minimum or maximum value in a range of cells in Excel.vtt | 1.09KB 5/11.1 54. Max-min-Lecture - Unsolved.xlsx.xlsx | 8.95KB 5/11.2 54. MIN-MAX-Exercise - Unsolved.xlsx.xlsx | 14.39KB 5/11.3 54. Max-min-Lecture - Solved.xlsx.xlsx | 9.23KB 5/11.4 54. MIN-MAX-Exercise - Solved.xlsx.xlsx | 14.80KB 5/12. Include ROUND in your financial models.mp4 | 3.13MB 5/12. Include ROUND in your financial models.vtt | 1.14KB 5/12.1 Excel-Functions.pdf.pdf | 3.18MB 5/12.2 55. Excel-functions-Lecture.xlsx.xlsx | 889.91KB 5/12.3 55. Round-Exercise - Unsolved.xlsx.xlsx | 11.34KB 5/12.4 55. Round-Exercise - Solved.xlsx.xlsx | 11.71KB 5/13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4 | 34.59MB 5/13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.vtt | 8.45KB 5/13.1 56. Vlookup-Hlookup- Lecture - Unsolved.xlsx.xlsx | 10.74KB 5/13.2 56. Vlookup-Hlookup- Lecture - Solved.xlsx.xlsx | 11.13KB 5/13.3 Excel-Functions.pdf.pdf | 3.19MB 5/13.4 56. Vlookup-Hlookup-Exercise - Solved.xlsx.xlsx | 13.68KB 5/13.5 56. Vlookup-Hlookup-Exercise - Unsolved.xlsx.xlsx | 11.95KB 5/14. How to enlarge the formula bar.mp4 | 6.26MB 5/14. How to enlarge the formula bar.vtt | 1.37KB 5/14.1 57. Enlarge-the-formula-bar-Lecture.xlsm.xlsm | 46.89KB 5/15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4 | 38.95MB 5/15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.vtt | 8.22KB 5/15.1 58. Index-Match-Lecture - Solved.xlsx.xlsx | 11.70KB 5/15.2 Excel-Functions.pdf.pdf | 3.18MB 5/15.3 58. Index-Match-Exercise - Solved.xlsx.xlsx | 12.08KB 5/15.4 58. Index-Match-Lecture - Unsolved.xlsx.xlsx | 11.29KB 5/15.5 58. Index-Match-Exercise - Unsolved.xlsx.xlsx | 11.59KB 5/16. A great Excel technique INDEX, MATCH, MATCH.mp4 | 11.76MB 5/16. A great Excel technique INDEX, MATCH, MATCH.vtt | 5.27KB 5/16.1 59. Exercise-Index-Match-Match-Solved.xlsx.xlsx | 12.21KB 5/16.2 59. Exercise-Index-Match-Match-Unsolved.xlsx.xlsx | 11.58KB 5/17. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.html | 160B 5/18. Using Excel's IFERROR function to trap spreadsheet errors.mp4 | 7.52MB 5/18. Using Excel's IFERROR function to trap spreadsheet errors.vtt | 2.05KB 5/18.1 60. Iferror - Lecture - Unsolved.xlsm.xlsm | 897.26KB 5/18.2 60. Iferror-Exercise - Solved.xlsx.xlsx | 15.37KB 5/18.3 60. Iferror-Exercise - Unsolved.xlsx.xlsx | 14.26KB 5/18.4 Excel-Functions.pdf.pdf | 3.19MB 5/18.5 60. Iferror - Lecture - Solved.xlsm.xlsm | 896.43KB 5/19. RANK is a valuable tool when using Excel for Financial and Business analysis.mp4 | 23.24MB 5/19. RANK is a valuable tool when using Excel for Financial and Business analysis.vtt | 2.82KB 5/19.1 61. Rank-function-Lecture-after.xlsx.xlsx | 12.61KB 5/19.2 61. Rank-function-Lecture-before.xlsx.xlsx | 12.27KB 5/2. Key functions in Excel IF.mp4 | 16.65MB 5/2. Key functions in Excel IF.vtt | 2.87KB 5/2.1 47. IF-function--Lecture-before.xlsm.xlsm | 17.00KB 5/2.2 Functions - English to German.pdf.pdf | 102.32KB 5/2.3 Key functions - Excel.pdf.pdf | 8.46MB 5/2.4 47. IF-function-Lecture-after.xlsm.xlsm | 17.94KB 5/2.5 Functions - English to Spanish.pdf.pdf | 102.37KB 5/2.6 Functions - English to Portuguese.pdf.pdf | 146.09KB 5/20. Learn how to render your models flexible with CHOOSE.mp4 | 8.98MB 5/20. Learn how to render your models flexible with CHOOSE.vtt | 2.64KB 5/20.1 62. Choose-Lecture - Unsolved.xlsx.xlsx | 9.33KB 5/20.2 62. Choose-Lecture - Solved.xlsx.xlsx | 9.69KB 5/20.3 62. Choose-Exercise-Solved.xlsx.xlsx | 11.73KB 5/20.4 Excel-Functions.pdf.pdf | 3.19MB 5/20.5 62. Choose-Exercise - Unsolved.xlsx.xlsx | 11.32KB 5/21. Use Goal Seek to find the result that you are looking for.mp4 | 7.86MB 5/21. Use Goal Seek to find the result that you are looking for.vtt | 2.56KB 5/21.1 63. Goal-Seek-Exercise - Unsolved.xlsx.xlsx | 16.09KB 5/21.2 Excel-Functions.pdf.pdf | 3.19MB 5/21.3 63. Goal-Seek-Exercise-Solved.xlsx.xlsx | 16.21KB 5/21.4 63. Goal-Seek-Lecture - Solved.xlsx.xlsx | 9.17KB 5/21.5 63. Goal-Seek-Lecture - Unsolved.xlsx.xlsx | 9.15KB 5/22. Use Goal Seek in order to find the result that you are looking for.html | 160B 5/23. Include sensitivity analysis in your models through Data Tables.mp4 | 14.29MB 5/23. Include sensitivity analysis in your models through Data Tables.vtt | 4.65KB 5/23.1 64. Sensitivity analysis - Lecture - Solved.xlsm.xlsm | 897.30KB 5/23.2 64. Sensitivity-analysis-Exercise-Unsolved.xlsm.xlsm | 66.82KB 5/23.3 64. Sensitivity-analysis-Exercise-Solved.xlsm.xlsm | 63.87KB 5/23.4 64. Sensitivity analysis - Lecture - Unsolved.xlsm.xlsm | 897.09KB 5/24. Include sensitivity analysis in your models through Data Tables.html | 160B 5/25. Excel's dynamic and interactive tables Pivot tables.mp4 | 16.59MB 5/25. Excel's dynamic and interactive tables Pivot tables.vtt | 2.58KB 5/25.1 65. Pivot tables - Lecture - Unsolved.xlsm.xlsm | 687.83KB 5/25.2 65. Pivot Tables - Exercise - Unsolved.xlsx.xlsx | 152.17KB 5/25.3 65. Pivot tables - Lecture - Solved.xlsm.xlsm | 897.26KB 5/25.4 65. Pivot Tables - Exercise - Solved.xlsx.xlsx | 190.47KB 5/26. Excel's key functions and functionalities made easy.html | 159B 5/3. Key Excel functions SUM, SUMIF and SUMIFS.mp4 | 19.32MB 5/3. Key Excel functions SUM, SUMIF and SUMIFS.vtt | 4.92KB 5/3.1 48. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx.xlsx | 12.93KB 5/3.2 48. Sum-Sumif-Sumifs-Lecture - Solved.xlsx.xlsx | 13.01KB 5/3.3 48. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx.xlsx | 14.46KB 5/3.4 Excel-Functions.pdf.pdf | 3.18MB 5/3.5 48. Sum-Sumif-Sumifs-Exercise - Solved.xlsx.xlsx | 14.84KB 5/4. = and + are interchangeable when you start typing a formula.mp4 | 5.79MB 5/4. = and + are interchangeable when you start typing a formula.vtt | 975B 5/4.1 49. = and + are interchangeable -after.xlsm.xlsm | 17.04KB 5/4.2 49. = and + are interchangeable - before.xlsm.xlsm | 17.01KB 5/5. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 | 16.99MB 5/5. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.vtt | 4.48KB 5/5.1 50.Counts-Exercise-Solved.xlsx.xlsx | 16.07KB 5/5.2 Excel-Functions.pdf.pdf | 3.18MB 5/5.3 Lecture-Count-Countif-Countifs-Solved.xlsx.xlsx | 11.68KB 5/5.4 Lecture-Count-Countif-Countifs-Unsolved.xlsx.xlsx | 11.29KB 5/5.5 50.Counts-Exercise-Unsolved.xlsx.xlsx | 15.56KB 5/6. Key Excel functions AVERAGE and AVERAGEIF.mp4 | 7.86MB 5/6. Key Excel functions AVERAGE and AVERAGEIF.vtt | 2.24KB 5/6.1 Excel-Functions.pdf.pdf | 3.18MB 5/6.2 51. Average-AverageIF-Exercise - Solved.xlsx.xlsx | 15.02KB 5/6.3 51. Average-Averageif- Lecture - Unsolved.xlsx.xlsx | 9.03KB 5/6.4 51. Average-AverageIF-Exercise - Unsolved.xlsx.xlsx | 14.60KB 5/6.5 51. Average-Averageif- Lecture - Solved.xlsx.xlsx | 9.40KB 5/7. Key Excel functions AVERAGE and AVERAGEIF.html | 160B 5/8. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4 | 16.80MB 5/8. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.vtt | 5.30KB 5/8.1 52. Text-Functions- Lecture - Solved.xlsx.xlsx | 11.10KB 5/8.2 52. Text functions - Exercise - Unsolved.xlsx.xlsx | 11.71KB 5/8.3 52. Text functions - Exercise - Solved.xlsx.xlsx | 12.24KB 5/8.4 52. Text-Functions- Lecture - Unsolved.xlsx.xlsx | 10.60KB 5/9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.html | 160B 6. Update! SUMIFS - Exercise/1. Exercise - Excel's SUMIFS function - unsolved.html | 164B 6. Update! SUMIFS - Exercise/2. Exercise - Excel's SUMIFS function - solved & explained.mp4 | 35.31MB 6. Update! SUMIFS - Exercise/2. Exercise - Excel's SUMIFS function - solved & explained.vtt | 10.03KB 6. Update! SUMIFS - Exercise/2.1 67. Exercise-Sumifs-With-Solutions.xlsx.xlsx | 1.29MB 7. Financial functions in Excel/1. Future and present values in Excel.mp4 | 14.96MB 7. Financial functions in Excel/1. Future and present values in Excel.vtt | 6.31KB 7. Financial functions in Excel/1.1 68. FV and PV-Lecture.xlsx.xlsx | 10.64KB 7. Financial functions in Excel/2. Calculating the rate of return of an investment with the IRR function.mp4 | 7.58MB 7. Financial functions in Excel/2. Calculating the rate of return of an investment with the IRR function.vtt | 3.28KB 7. Financial functions in Excel/2.1 69. Exercise-IRR-Solved.xlsx.xlsx | 12.31KB 7. Financial functions in Excel/2.2 69. IRR-Lecture.xlsx.xlsx | 11.20KB 7. Financial functions in Excel/2.3 69. Exercise-IRR-Unsolved.xlsx.xlsx | 11.52KB 7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.mp4 | 14.82MB 7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.vtt | 5.90KB 7. Financial functions in Excel/3.1 70. Loan Schedule-Lecture.xlsx.xlsx | 20.17KB 7. Financial functions in Excel/3.2 70. Exercise-Loan-Schedule-Solved.xlsx.xlsx | 22.68KB 7. Financial functions in Excel/3.3 70. Exercise-Loan-Schedule-Unsolved.xlsx.xlsx | 15.81KB 7. Financial functions in Excel/4. Date functions in Excel.mp4 | 11.35MB 7. Financial functions in Excel/4. Date functions in Excel.vtt | 5.51KB 7. Financial functions in Excel/4.1 71. Date Functions-Exercise-Solved.xlsx.xlsx | 12.43KB 7. Financial functions in Excel/4.2 71. Date Functions-Lecture.xlsx.xlsx | 12.25KB 7. Financial functions in Excel/4.3 71. Date Functions-Exercise-Unsolved.xlsx.xlsx | 11.41KB 8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.mp4 | 6.00MB 8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.vtt | 1.99KB 8. Microsoft Excel's Pivot Tables in Depth/2. Creating Pivot Tables easily!.mp4 | 19.38MB 8. Microsoft Excel's Pivot Tables in Depth/2. Creating Pivot Tables easily!.vtt | 4.01KB 8. Microsoft Excel's Pivot Tables in Depth/2.1 73. Creating-a-Pivot-Table - Lecture - after.xlsx.xlsx | 1.43MB 8. Microsoft Excel's Pivot Tables in Depth/2.2 73. Creating-a-Pivot-Table - Lecture – before.xlsx.xlsx | 1.23MB 8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.mp4 | 11.28MB 8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.vtt | 2.22KB 8. Microsoft Excel's Pivot Tables in Depth/3.1 74. Formatting-a-Pivot-Table - Lecture - after.xlsx.xlsx | 1.43MB 8. Microsoft Excel's Pivot Tables in Depth/3.2 74. Formatting-a-Pivot-Table - Lecture - before.xlsx.xlsx | 1.43MB 8. Microsoft Excel's Pivot Tables in Depth/4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4 | 23.00MB 8. Microsoft Excel's Pivot Tables in Depth/4. Modifying and pivoting fields to obtain the Pivot Table you need.vtt | 4.28KB 8. Microsoft Excel's Pivot Tables in Depth/4.1 75. Working-with-Pivot-Tables - Lecture - before.xlsx.xlsx | 1.43MB 8. Microsoft Excel's Pivot Tables in Depth/4.2 75. Working-with-Pivot-Tables - Lecture - after.xlsx.xlsx | 1.88MB 8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GETPIVOTDATA - A very important Excel function.mp4 | 18.06MB 8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GETPIVOTDATA - A very important Excel function.vtt | 3.77KB 8. Microsoft Excel's Pivot Tables in Depth/5.1 76. GetPivotData - Lecture - before.xlsx.xlsx | 1.88MB 8. Microsoft Excel's Pivot Tables in Depth/5.2 76. GetPivotData - Lecture – after.xlsx.xlsx | 1.88MB 8. Microsoft Excel's Pivot Tables in Depth/6. An introduction to slicers - The modern-day Pivot Table filters.mp4 | 22.17MB 8. Microsoft Excel's Pivot Tables in Depth/6. An introduction to slicers - The modern-day Pivot Table filters.vtt | 4.42KB 8. Microsoft Excel's Pivot Tables in Depth/6.1 77. Slicers - Lecture - after.xlsx.xlsx | 1.88MB 8. Microsoft Excel's Pivot Tables in Depth/6.2 77. Slicers - Lecture - before.xlsx.xlsx | 1.88MB 9/1. Case study - Build a P&L from scratch - Welcome lecture.mp4 | 3.14MB 9/1. Case study - Build a P&L from scratch - Welcome lecture.vtt | 1.53KB 9/10. Use INDEX & MATCH as a substitute for VLOOKUP.mp4 | 49.58MB 9/10. Use INDEX & MATCH as a substitute for VLOOKUP.vtt | 4.24KB 9/10.1 87. Index Match-Lecture-before.xlsm.xlsm | 41.04KB 9/10.2 87. Index Match-Lecture-after.xlsm.xlsm | 13.86MB 9/11. Mapping the rows in the Database sheet.mp4 | 32.48MB 9/11. Mapping the rows in the Database sheet.vtt | 2.66KB 9/11.1 88. Mapping-Lecture-after.xlsm.xlsm | 50.24KB 9/11.2 88. Mapping_before.xlsm.xlsm | 50.55KB 9/12. In case you have any doubts about the Mapping exercise.mp4 | 38.56MB 9/12. In case you have any doubts about the Mapping exercise.vtt | 6.34KB 9/12.1 89. Mapping-Lecture-Unsolved.xlsm.xlsm | 50.55KB 9/12.2 89. Mapping-exercise-explained.pdf.pdf | 243.03KB 9/12.3 89. Mapping-Lecture-Solved.xlsx.xlsx | 47.50KB 9/13. Building the structure of the P&L sheet.mp4 | 20.86MB 9/13. Building the structure of the P&L sheet.vtt | 2.19KB 9/13.1 90. Building a P&L-Lecture-before.xlsm.xlsm | 50.24KB 9/13.2 90. Building a P&L-Lecture-after.xlsm.xlsm | 51.83KB 9/14. Formatting sets You apart from the competition in Excel - A Practical Example.mp4 | 25.42MB 9/14. Formatting sets You apart from the competition in Excel - A Practical Example.vtt | 22.02MB 9/14.1 91. Formatting a P&L-Lecture-before.xlsm.xlsm | 51.84KB 9/14.2 91. Formatting the P&L-Lecture-after.xlsm.xlsm | 51.96KB 9/15. Populate the P&L sheet with SUMIF.mp4 | 30.26MB 9/15. Populate the P&L sheet with SUMIF.vtt | 2.92KB 9/15.1 92. Formatting the P&L-Lecture-after.xlsm.xlsm | 53.51KB 9/15.2 92. Formatting the P&L-Lecture-before.xlsm.xlsm | 52.00KB 9/16. Learn how to find mistakes with COUNTIF.mp4 | 27.87MB 9/16. Learn how to find mistakes with COUNTIF.vtt | 2.80KB 9/16.1 93. Countif-Lecture-after.xlsm.xlsm | 54.78KB 9/16.2 93. Countif-Lecture-before.xlsm.xlsm | 53.51KB 9/17. Calculating year-on-year percentage variations the proper way.mp4 | 29.98MB 9/17. Calculating year-on-year percentage variations the proper way.vtt | 3.24KB 9/17.1 94. Adding % variations-Lecture-after.xlsm.xlsm | 56.51KB 9/17.2 94. Adding % variations-Lecture-before.xlsm.xlsm | 54.78KB 9/17.3 Y-o-Y Function explanation.pdf.pdf | 164.92KB 9/2. Introduction to the case study.mp4 | 10.21MB 9/2. Introduction to the case study.vtt | 1.09KB 9/3. Understand your data source before you start working on it.mp4 | 28.16MB 9/3. Understand your data source before you start working on it.vtt | 2.99KB 9/3.1 80. Get to know the data source.xlsm.xlsm | 43.03KB 9/4. Order the source worksheets.mp4 | 26.54MB 9/4. Order the source worksheets.vtt | 2.41KB 9/4.1 81. Order a worksheet_before.xlsm.xlsm | 43.08KB 9/4.2 81. Order a worksheet_after.xlsm.xlsm | 41.01KB 9/5. Create a code the best way to organize your data and work efficiently with it.mp4 | 24.49MB 9/5. Create a code the best way to organize your data and work efficiently with it.vtt | 2.17KB 9/5.1 82. Creating a code_before.xlsm.xlsm | 41.01KB 9/5.2 82. Creating a code_after.xlsm.xlsm | 41.73KB 9/6. Learn how to create a database.mp4 | 20.70MB 9/6. Learn how to create a database.vtt | 2.15KB 9/6.1 83. Creating a database_after.xlsm.xlsm | 39.39KB 9/6.2 83. Creating a database_before.xlsm.xlsm | 41.73KB 9/7. Use VLOOKUP to fill the Database sheet.mp4 | 61.57MB 9/7. Use VLOOKUP to fill the Database sheet.vtt | 5.40KB 9/7.1 84. Vlookup_before.xlsm.xlsm | 39.50KB 9/7.2 84. Vlookup_after.xlsm.xlsm | 44.45KB 9/8. 50% Completed!.mp4 | 4.31MB 9/8. 50% Completed!.vtt | 51B 9/9. Use SUMIF to complete the Database sheet.mp4 | 47.94MB 9/9. Use SUMIF to complete the Database sheet.vtt | 4.17KB 9/9.1 86. Sumif_after.xlsm.xlsm | 49.53KB 9/9.2 86. Sumif_before.xlsm.xlsm | 44.45KB [Tutorialsplanet.NET].url | 128B