Общая информация
Название GetFreeCourses.Co-Udemy-Beginner to Pro in Excel Financial Modeling and Valuation
Тип
Размер 4.56Гб

Файлы в торренте
Обратите внимание, что наш сайт не размещает какие-либо файлы из списка. Вы не можете скачать эти файлы или скачать torrent-файл.
1.1 108. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx.xlsx 13.27Мб
1.1 68. FV and PV-Lecture.xlsx.xlsx 10.64Кб
1.1 95. Inserting-Charts-Lecture.xlsm.xlsm 11.46Мб
1.1 Course Notes - Beginner to Pro in Excel.pdf.pdf 19.04Мб
1.1 Tesla 2015.pdf.pdf 1.29Мб
1.2 Tesla 2017.pdf.pdf 2.51Мб
1.3 Tesla 2018 Q2.pdf.pdf 635.07Кб
1.4 Tesla 2016.pdf.pdf 2.22Мб
1.5 0a. Drivers_before.xlsx.xlsx 1.27Мб
1.6 Tesla Company Valuation - Detailed walkthrough.pdf.pdf 5.08Мб
1.7 0a. Drivers_after.xlsx.xlsx 1.27Мб
1. Bonus lecture Next steps.html 2.13Кб
1. Case study - Build a P&L from scratch - Welcome lecture.mp4 3.14Мб
1. Case study - Build a P&L from scratch - Welcome lecture.srt 1.59Кб
1. Create professional and good-looking charts - Introduction.mp4 6.21Мб
1. Create professional and good-looking charts - Introduction.srt 662б
1. Excel's key functions - Welcome lecture.mp4 2.32Мб
1. Excel's key functions - Welcome lecture.srt 1.11Кб
1. Excel best practices - Welcome lecture.mp4 2.13Мб
1. Excel best practices - Welcome lecture.srt 1.04Кб
1. Exercise - Excel's SUMIFS function - unsolved.html 171б
1. Financial Modeling basics - Welcome lecture.mp4 2.09Мб
1. Financial Modeling basics - Welcome lecture.srt 1.10Кб
1. Future and present values in Excel.mp4 14.96Мб
1. Future and present values in Excel.srt 6.94Кб
1. How to insert a chart in Excel.mp4 22.28Мб
1. How to insert a chart in Excel.srt 2.67Кб
1. Introduction to Capital budgeting.mp4 5.44Мб
1. Introduction to Capital budgeting.srt 1.89Кб
1. Introduction to Excel - welcome lecture.mp4 1.99Мб
1. Introduction to Excel - welcome lecture.srt 925б
1. Introduction to Mergers & Acquisitions.html 171б
1. Introduction to Pivot Tables and the way they are applied.mp4 6.00Мб
1. Introduction to Pivot Tables and the way they are applied.srt 2.08Кб
1. Introduction to the Capital budgeting exercise.mp4 8.63Мб
1. Introduction to the Capital budgeting exercise.srt 3.42Кб
1. Introduction to the Case Study.mp4 12.06Мб
1. Introduction to the Case Study.srt 2.58Кб
1. Keyboard shortcuts Save LOTS of time in Excel.mp4 30.43Мб
1. Keyboard shortcuts Save LOTS of time in Excel.srt 5.53Кб
1. Organizing external inputs in a 'Drivers' sheet.mp4 31.00Мб
1. Organizing external inputs in a 'Drivers' sheet.srt 4.37Кб
1. The core theory behind Company Valuation.html 171б
1. Valuation Case study - Welcome lecture.mp4 1.78Мб
1. Valuation Case study - Welcome lecture.srt 883б
1. What does the course cover.mp4 8.95Мб
1. What does the course cover.srt 3.28Кб
10.1 117. Exercise-Build-an-FMCG-Model-Inserting-Slicers-Lecture.xlsx.xlsx 20.77Мб
10.1 6. Energy and Other revenue - Before.xlsx.xlsx 1.34Мб
10.1 8. WACC_unsolved.xlsx.xlsx 35.93Кб
10.1 87. Index Match-Lecture-before.xlsm.xlsm 41.04Кб
10.1 9. Interest expenses, taxes_before.xlsm.xlsm 50.57Кб
10.2 6. Energy and Other revenue - After.xlsx.xlsx 1.34Мб
10.2 8. WACC.xlsx.xlsx 38.03Кб
10.2 87. Index Match-Lecture-after.xlsm.xlsm 13.86Мб
10.2 9. Interest expenses, taxes_after.xlsm.xlsm 50.89Кб
10. Combining Slicers and GETPIVOTDATA The key to our success.mp4 17.84Мб
10. Combining Slicers and GETPIVOTDATA The key to our success.srt 3.62Кб
10. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.html 167б
10. Finding cost of equity.mp4 13.93Мб
10. Finding cost of equity.srt 7.63Кб
10. Forecasting 'energy' and 'services' revenue.mp4 25.30Мб
10. Forecasting 'energy' and 'services' revenue.srt 3.14Кб
10. Forecasting financials - Quiz.html 167б
10. Introduction to Excel formulas.html 167б
10. Learn how to organize your data with Text to Columns.html 167б
10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4 30.01Мб
10. Modeling other items Interest expenses, Extraordinary items and Taxes.srt 3.05Кб
10. Use INDEX & MATCH as a substitute for VLOOKUP.mp4 49.59Мб
10. Use INDEX & MATCH as a substitute for VLOOKUP.srt 4.25Кб
11.1 10. Introduction to Balance sheet items.xlsm.xlsm 51.02Кб
11.1 118. Exercise-Build-an-FMCG-Model-Complete-Lecture.xlsx.xlsx 22.82Мб
11.1 13. Functions- Exercise - Solved.xlsx.xlsx 81.10Кб
11.1 24. Wrap-Text-Exercise - Solved.xlsx.xlsx 10.20Кб
11.1 53. Work-with-text-Lecture-before.xlsx.xlsx 10.33Кб
11.1 7. Energy and Other - Gross profit, cost of sales - Before.xlsx.xlsx 1.35Мб
11.1 88. Mapping-Lecture-after.xlsm.xlsm 50.24Кб
11.1 9. Discounted cash flow.xlsx.xlsx 39.74Кб
11.2 13. Functions- Lecture - Unsolved.xlsx.xlsx 9.24Кб
11.2 24. Wrap-text-Lecture - Solved.xlsx.xlsx 9.61Кб
11.2 53. Work-with-text-Lecture-after.xlsx.xlsx 10.91Кб
11.2 7. Energy and Other - Gross profit, cost of sales - After.xlsx.xlsx 1.35Мб
11.2 88. Mapping_before.xlsm.xlsm 50.55Кб
11.2 9. Discounted cash flow_unsolved.xlsx.xlsx 38.72Кб
11.3 13. Functions-Exercise - Unsolved.xlsx.xlsx 13.26Кб
11.3 24. Wrap-text-Lecture - Unsolved.xlsx.xlsx 9.61Кб
11.4 13. Functions - Lecture -Solved.xlsx.xlsx 9.34Кб
11.4 Useful-Tips-Tools.pdf.pdf 3.31Мб
11.5 24. Wrap-Text-Exercise - Unsolved.xlsx.xlsx 10.17Кб
11.5 Introduction-to-Excels-basic-features.pdf.pdf 2.27Мб
11. Building a complete model - Important considerations.mp4 6.43Мб
11. Building a complete model - Important considerations.srt 2.90Кб
11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4 26.81Мб
11. Calculating 'energy' and 'services' gross profit and cost of sales.srt 2.53Кб
11. Discounting the project's cash flows and residual value.mp4 25.90Мб
11. Discounting the project's cash flows and residual value.srt 3.76Кб
11. Forecasting Balance sheet items.mp4 4.67Мб
11. Forecasting Balance sheet items.srt 870б
11. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 17.11Мб
11. Getting fancy with Excel slicers - Good-looking Excel slicers.srt 3.61Кб
11. Introduction to Excel functions.mp4 12.06Мб
11. Introduction to Excel functions.srt 4.68Кб
11. Learn how to use the Wrap Text button.mp4 908.39Кб
11. Learn how to use the Wrap Text button.srt 903б
11. Mapping the rows in the Database sheet.mp4 32.49Мб
11. Mapping the rows in the Database sheet.srt 2.76Кб
11. Working with text in Excel.mp4 16.00Мб
11. Working with text in Excel.srt 3.08Кб
12.1 10. Sensitivity analysis.xlsx.xlsx 40.67Кб
12.1 119. Exercise-Build-an-FMCG-Model-Complete.xlsx.xlsx 22.82Мб
12.1 14. Copy-Cut-Paste-Exercise - Solved.xlsx.xlsx 12.56Кб
12.1 25. Set-Print-Area-Lecture - Solved.xlsx.xlsx 11.22Кб
12.1 54. MIN-MAX-Exercise - Solved.xlsx.xlsx 14.80Кб
12.1 8. Opex - After.xlsx.xlsx 1.36Мб
12.1 89. Mapping-Lecture-Solved.xlsx.xlsx 47.50Кб
12.1 Working Capital Days.pptx.pptx 94.77Кб
12.2 10. Sensitivity analysis_unsolved.xlsx.xlsx 39.70Кб
12.2 25. Set-Print-Area-Lecture - Unsolved.xlsx.xlsx 11.42Кб
12.2 54. Max-min-Lecture - Unsolved.xlsx.xlsx 8.95Кб
12.2 8. Opex - Before.xlsx.xlsx 1.36Мб
12.2 89. Mapping-exercise-explained.pdf.pdf 243.03Кб
12.2 Introduction-to-Excels-basic-features.pdf.pdf 2.26Мб
12.3 14. Copy-Cut-Paste-Exercise - Unsolved.xlsx.xlsx 11.34Кб
12.3 54. MIN-MAX-Exercise - Unsolved.xlsx.xlsx 14.39Кб
12.3 89. Mapping-Lecture-Unsolved.xlsm.xlsm 50.55Кб
12.3 Useful-Tips-Tools.pdf.pdf 3.30Мб
12.4 54. Max-min-Lecture - Solved.xlsx.xlsx 9.23Кб
12. An introduction to the Days methodology.mp4 10.08Мб
12. An introduction to the Days methodology.srt 1.85Кб
12. Create easily printable documents in Excel by using Set Print Area.mp4 1.71Мб
12. Create easily printable documents in Excel by using Set Print Area.srt 1.59Кб
12. Cut, copy, & paste.mp4 7.57Мб
12. Cut, copy, & paste.srt 2.41Кб
12. Find the minimum or maximum value in a range of cells in Excel.mp4 1.90Мб
12. Find the minimum or maximum value in a range of cells in Excel.srt 1.15Кб
12. Forecasting operating expenses.mp4 34.92Мб
12. Forecasting operating expenses.srt 5.41Кб
12. In case you have any doubts about the Mapping exercise.mp4 38.56Мб
12. In case you have any doubts about the Mapping exercise.srt 38.58Мб
12. Modeling the Income statement.mp4 12.44Мб
12. Modeling the Income statement.srt 7.46Кб
12. Performing sensitivity analysis and completing the exercise.mp4 43.04Мб
12. Performing sensitivity analysis and completing the exercise.srt 5.56Кб
12. This is how the report can be used in practice by high-level executives.mp4 19.81Мб
12. This is how the report can be used in practice by high-level executives.srt 4.66Кб
13.1 12. Days calculation_before.xlsm.xlsm 51.20Кб
13.1 26. Select-Special-Lecture.xlsx.xlsx 10.56Кб
13.1 9. PP&E forecasting and comparables_after.xlsx.xlsx 1.37Мб
13.1 90. Building a P&L-Lecture-before.xlsm.xlsm 50.24Кб
13.1 Excel-Functions.pdf.pdf 3.19Мб
13.2 12. Days calculation_after.xlsm.xlsm 51.47Кб
13.2 55. Round-Exercise - Unsolved.xlsx.xlsx 11.34Кб
13.2 9. PP&E forecasting and comparables_before.xlsx.xlsx 1.37Мб
13.2 90. Building a P&L-Lecture-after.xlsm.xlsm 51.83Кб
13.2 Useful-Tips-Tools.pdf.pdf 3.30Мб
13.3 26. Select-Special-F5-Exercise - Solved.xlsx.xlsx 22.27Кб
13.3 55. Round-Exercise - Solved.xlsx.xlsx 11.71Кб
13.4 26. Select-Special-F5-Exercise - Unsolved.xlsx.xlsx 21.59Кб
13.4 55. Excel-functions-Lecture.xlsx.xlsx 889.91Кб
13. Build a complete capital budgeting model from scratch.html 170б
13. Building a fixed asset roll forward estimating Capex.mp4 56.59Мб
13. Building a fixed asset roll forward estimating Capex.srt 6.43Кб
13. Building the structure of the P&L sheet.mp4 20.86Мб
13. Building the structure of the P&L sheet.srt 2.34Кб
13. Calculation of DSO, DPO and DOI for the historical period.mp4 12.12Мб
13. Calculation of DSO, DPO and DOI for the historical period.srt 1.39Кб
13. Cut, copy, & paste.html 167б
13. Dynamic reporting with GETPIVOTDATA and slicers.html 170б
13. Find and select special types of cells with Select Special (F5).mp4 3.05Мб
13. Find and select special types of cells with Select Special (F5).srt 1.95Кб
13. Include ROUND in your financial models.mp4 1.23Мб
13. Include ROUND in your financial models.srt 1.20Кб
13. Modeling the Balance sheet - Part 1.mp4 5.23Мб
13. Modeling the Balance sheet - Part 1.srt 3.41Кб
14.1 10. PP&E schedule_after.xlsx.xlsx 1.37Мб
14.1 13. Forecasting DSO, DPO, DIO_after.xlsm.xlsm 51.98Кб
14.1 56. Vlookup-Hlookup- Lecture - Unsolved.xlsx.xlsx 10.74Кб
14.1 91. Formatting a P&L-Lecture-before.xlsm.xlsm 51.84Кб
14.1 Introduction-to-Excels-basic-features.pdf.pdf 2.26Мб
14.2 10. PP&E schedule_before.xlsx.xlsx 1.37Мб
14.2 13. Forecasting DSO, DPO, DIO_before.xlsm.xlsm 51.47Кб
14.2 15. Paste-Special-Exercise - Unsolved.xlsx.xlsx 13.47Кб
14.2 91. Formatting the P&L-Lecture-after.xlsm.xlsm 51.96Кб
14.2 Excel-Functions.pdf.pdf 3.19Мб
14.3 15. Paste-Special-Exercise - Solved.xlsx.xlsx 13.46Кб
14.3 56. Vlookup-Hlookup-Exercise - Unsolved.xlsx.xlsx 11.95Кб
14.4 56. Vlookup-Hlookup-Exercise - Solved.xlsx.xlsx 13.68Кб
14.5 56. Vlookup-Hlookup- Lecture - Solved.xlsx.xlsx 11.13Кб
14. Building a fixed asset roll forward D&A schedule.mp4 54.20Мб
14. Building a fixed asset roll forward D&A schedule.srt 4.45Кб
14. Congratulations!!.mp4 2.30Мб
14. Congratulations!!.srt 1.56Кб
14. Forecasting DSO, DPO and DOI.mp4 20.87Мб
14. Forecasting DSO, DPO and DOI.srt 2.54Кб
14. Formatting sets You apart from the competition in Excel - A Practical Example.mp4 25.43Мб
14. Formatting sets You apart from the competition in Excel - A Practical Example.srt 3.41Кб
14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4 12.11Мб
14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.srt 9.02Кб
14. Modeling the Balance sheet - Part 2.mp4 9.39Мб
14. Modeling the Balance sheet - Part 2.srt 7.57Мб
14. Paste special.mp4 6.70Мб
14. Paste special.srt 1.57Кб
14. Select Special.html 167б
15.1 10a. PP&E comparison.xlsx.xlsx 1.37Мб
15.1 14. Forecasting PP&E, Other assets, and Other liabilities_after.xlsm.xlsm 52.88Кб
15.1 27. Assigning-Dynamic-Names-Exercise - Solved.xlsx.xlsx 11.73Кб
15.1 57. Enlarge-the-formula-bar-Lecture.xlsm.xlsm 46.89Кб
15.1 92. Formatting the P&L-Lecture-after.xlsm.xlsm 53.51Кб
15.2 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm.xlsm 51.98Кб
15.2 27. Dynamic-Naming-Lecture - Solved.xlsx.xlsx 13.83Кб
15.2 92. Formatting the P&L-Lecture-before.xlsm.xlsm 52.00Кб
15.3 Useful-Tips-Tools.pdf.pdf 3.31Мб
15.4 27. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx.xlsx 11.23Кб
15.5 27. Dynamic-Naming-Lecture - Unsolved.xlsx.xlsx 13.54Кб
15. Basic operations in Excel - 38 pages.html 171б
15. Building a financial model - Quiz.html 167б
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4 22.62Мб
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.srt 22.63Мб
15. How to enlarge the formula bar.mp4 6.26Мб
15. How to enlarge the formula bar.srt 1.40Кб
15. Learn how to assign dynamic names within a financial model.mp4 2.33Мб
15. Learn how to assign dynamic names within a financial model.srt 1.64Кб
15. Peer comparison D&A as a percentage of revenues.mp4 13.62Мб
15. Peer comparison D&A as a percentage of revenues.srt 1.62Кб
15. Populate the P&L sheet with SUMIF.mp4 30.27Мб
15. Populate the P&L sheet with SUMIF.srt 3.00Кб
16.1 11. Working capital forecasting_after.xlsx.xlsx 1.52Мб
16.1 15. P&L structure_before.xlsm.xlsm 53.60Кб
16.1 58. Index-Match-Lecture - Unsolved.xlsx.xlsx 11.29Кб
16.1 93. Countif-Lecture-after.xlsm.xlsm 54.78Кб
16.2 11. Working capital forecasting_before.xlsx.xlsx 1.38Мб
16.2 15. P&L structure_after.xlsm.xlsm 53.67Кб
16.2 93. Countif-Lecture-before.xlsm.xlsm 53.51Кб
16.2 Excel-Functions.pdf.pdf 3.19Мб
16.3 58. Index-Match-Exercise - Solved.xlsx.xlsx 12.08Кб
16.4 58. Index-Match-Exercise - Unsolved.xlsx.xlsx 11.59Кб
16.5 58. Index-Match-Lecture - Solved.xlsx.xlsx 11.70Кб
16. Assigning dynamic names.html 167б
16. Calculating DSO, DIO, DPO.mp4 17.52Мб
16. Calculating DSO, DIO, DPO.srt 2.11Кб
16. Creating an output P&L sheet.mp4 18.81Мб
16. Creating an output P&L sheet.srt 2.39Кб
16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4 12.81Мб
16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.srt 8.83Кб
16. Learn how to find mistakes with COUNTIF.mp4 27.88Мб
16. Learn how to find mistakes with COUNTIF.srt 2.80Кб
17.1 12. P&L.xlsx.xlsx 1.39Мб
17.1 16. Populating the P&L sheet_after.xlsm.xlsm 55.32Кб
17.1 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx.xlsx 11.07Кб
17.1 59. Exercise-Index-Match-Match-Unsolved.xlsx.xlsx 11.58Кб
17.1 94. Adding % variations-Lecture-before.xlsm.xlsm 54.78Кб
17.2 16. Populating the P&L sheet_before.xlsm.xlsm 53.67Кб
17.2 28. Defining-a-Named-Range-Exercise - Solved.xlsx.xlsx 11.65Кб
17.2 59. Exercise-Index-Match-Match-Solved.xlsx.xlsx 12.21Кб
17.2 94. Adding % variations-Lecture-after.xlsm.xlsm 56.51Кб
17.3 28. Naming-ranges-Lecture - Unsolved.xlsx.xlsx 8.79Кб
17.3 Y-o-Y Function explanation.pdf.pdf 164.92Кб
17.4 28. Naming-ranges-Lecture - Solved.xlsx.xlsx 10.34Кб
17.5 Useful-Tips-Tools.pdf.pdf 3.30Мб
17. A great Excel technique INDEX, MATCH, MATCH.mp4 11.77Мб
17. A great Excel technique INDEX, MATCH, MATCH.srt 5.65Кб
17. Calculating year-on-year percentage variations the proper way.mp4 29.97Мб
17. Calculating year-on-year percentage variations the proper way.srt 3.31Кб
17. Define a named range in Excel.mp4 2.12Мб
17. Define a named range in Excel.srt 1.70Кб
17. Populating the output P&L sheet.mp4 25.54Мб
17. Populating the output P&L sheet.srt 2.50Кб
17. Producing a clean P&L output sheet.mp4 8.44Мб
17. Producing a clean P&L output sheet.srt 1.62Кб
18.1 12a. P&L fill in_before.xlsx.xlsx 1.39Мб
18.1 17. Populating BS sheet_before.xlsm.xlsm 55.32Кб
18.1 Useful-Tips-Tools.pdf.pdf 3.31Мб
18.2 12a. P&L fill in_after.xlsx.xlsx 1.39Мб
18.2 17. Populating BS sheet_after.xlsm.xlsm 57.18Кб
18.2 29. Assigning Custom Formats - Exercise - Unsolved.xlsx.xlsx 11.35Кб
18.3 29. Assigning Custom Formats - Exercise - Solved.xlsx.xlsx 11.08Кб
18. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4 2.14Мб
18. Assign custom formats to specific cells within a financial model (e.g Multiples).srt 1.98Кб
18. Fill in the P&L output sheet.mp4 18.34Мб
18. Fill in the P&L output sheet.srt 1.83Кб
18. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.html 167б
18. Populating the output BS sheet.mp4 16.94Мб
18. Populating the output BS sheet.srt 1.78Кб
19.1 13. Calculating working capital_before.xlsx.xlsx 1.40Мб
19.1 18. Completing the Balance Sheet_after.xlsm.xlsm 58.10Кб
19.1 60. Iferror - Lecture - Unsolved.xlsm.xlsm 897.26Кб
19.1 Useful-Tips-Tools.pdf.pdf 3.31Мб
19.2 13. Calculating working capital_after.xlsx.xlsx 1.40Мб
19.2 18. Completing the Balance Sheet_before.xlsm.xlsm 57.18Кб
19.2 30. Macros-Exercise - Unsolved.xlsx.xlsx 10.34Кб
19.2 60. Iferror-Exercise - Solved.xlsx.xlsx 15.37Кб
19.3 30. Creating-a-Macro-Lecture - Solved.xlsx.xlsx 11.17Кб
19.3 60. Iferror - Lecture - Solved.xlsm.xlsm 896.43Кб
19.4 30. Creating-a-Macro-Lecture - Unsolved.xlsx.xlsx 9.66Кб
19.4 60. Iferror-Exercise - Unsolved.xlsx.xlsx 14.26Кб
19.5 30. Macros-Exercise - Solved.xlsx.xlsx 145.02Кб
19.5 Excel-Functions.pdf.pdf 3.19Мб
19. Calculating investments in working capital.mp4 19.04Мб
19. Calculating investments in working capital.srt 2.16Кб
19. Completing the output BS sheet for the historical period.mp4 38.03Мб
19. Completing the output BS sheet for the historical period.srt 4.03Кб
19. Macros are a great timesaver! Here's why!.mp4 4.34Мб
19. Macros are a great timesaver! Here's why!.srt 3.57Кб
19. Using Excel's IFERROR function to trap spreadsheet errors.mp4 2.62Мб
19. Using Excel's IFERROR function to trap spreadsheet errors.srt 2.18Кб
2.1 0aa. Inputs_before.xlsx.xlsx 1.28Мб
2.1 1. Drivers.xlsx.xlsx 11.50Кб
2.1 102. Column stacked chart-Lecture-after.xlsm.xlsm 11.51Мб
2.1 109. Exercise-Build-an-FMCG-Model-Mapping-Lecture.xlsx.xlsx 14.90Мб
2.1 18. Formatting-a-Worksheet-Exercise - Solved.xlsx.xlsx 10.76Кб
2.1 67. Exercise-Sumifs-With-Solutions.xlsx.xlsx 1.29Мб
2.1 69. IRR-Lecture.xlsx.xlsx 11.20Кб
2.1 7. Overview-of-Excel-Exercise-Solved.xlsx.xlsx 10.88Кб
2.1 73. Creating-a-Pivot-Table - Lecture - after.xlsx.xlsx 1.43Мб
2.1 96. Formatting-a-Chart-Lecture.xlsm.xlsm 11.46Мб
2.2 0aa. Inputs_after.xlsx.xlsx 1.28Мб
2.2 102. Column stacked chart-Lecture-before.xlsm.xlsm 11.51Мб
2.2 69. Exercise-IRR-Solved.xlsx.xlsx 12.31Кб
2.2 7. Overview-of-Excel-Exercise-Unsolved.xlsx.xlsx 10.47Кб
2.2 73. Creating-a-Pivot-Table - Lecture – before.xlsx.xlsx 1.23Мб
2.2 Useful-Tips-Tools.pdf.pdf 3.31Мб
2.3 18. Formatting-a-worksheet-Lecture - Solved.xlsx.xlsx 9.56Кб
2.3 69. Exercise-IRR-Unsolved.xlsx.xlsx 11.52Кб
2.3 7. Introduction to Excel.pdf.pdf 2.26Мб
2.4 18. Formatting-a-Worksheet-Exercise - Unsolved.xlsx.xlsx 10.63Кб
2.5 18. Formatting-a-worksheet-Lecture - Unsolved.xlsx.xlsx 8.98Кб
2. A helpful consideration.html 1.10Кб
2. Bonus! Welcome gift.html 171б
2. Build a column stacked chart with a secondary line axis in Excel.mp4 46.37Мб
2. Build a column stacked chart with a secondary line axis in Excel.srt 5.70Кб
2. Calculating the rate of return of an investment with the IRR function.mp4 7.58Мб
2. Calculating the rate of return of an investment with the IRR function.srt 3.65Кб
2. Creating Pivot Tables easily!.mp4 19.37Мб
2. Creating Pivot Tables easily!.srt 4.25Кб
2. Editing Excel charts.mp4 26.06Мб
2. Editing Excel charts.srt 2.89Кб
2. Exercise - Excel's SUMIFS function - solved & explained.mp4 12.69Мб
2. Exercise - Excel's SUMIFS function - solved & explained.srt 10.69Кб
2. Initial formatting of an Excel sheet to render it professional.mp4 3.36Мб
2. Initial formatting of an Excel sheet to render it professional.srt 2.30Кб
2. Introduction to the case study.mp4 10.20Мб
2. Introduction to the case study.srt 1.10Кб
2. Introduction to the DCF exercise.mp4 7.88Мб
2. Introduction to the DCF exercise.srt 1.31Кб
2. Keyboard shortcuts in Excel.html 171б
2. Organizing an Inputs sheet.mp4 11.05Мб
2. Organizing an Inputs sheet.srt 6.59Кб
2. Overview of Excel.mp4 13.96Мб
2. Overview of Excel.srt 4.14Кб
2. Preliminary mapping of the data extraction.mp4 22.60Мб
2. Preliminary mapping of the data extraction.srt 2.56Кб
2. The input data we will work with.mp4 15.80Мб
2. The input data we will work with.srt 1.72Кб
2. What is a financial model.mp4 4.60Мб
2. What is a financial model.srt 2.46Кб
2. Why we need Capital budgeting.mp4 6.89Мб
2. Why we need Capital budgeting.srt 2.70Кб
20.1 14. Cash flow - UFCF_after.xlsx.xlsx 1.41Мб
20.1 19. Cash flow structure_before.xlsm.xlsm 58.48Кб
20.1 31. How-to-save-macros-Lecture-after.xlsm.xlsm 12.59Кб
20.1 61. Rank-function-Lecture-before.xlsx.xlsx 12.27Кб
20.2 14. Cash flow - UFCF_before.xlsx.xlsx 1.41Мб
20.2 19. Cash flow structure_after.xlsm.xlsm 58.58Кб
20.2 31. Another-file.xlsx.xlsx 8.81Кб
20.2 61. Rank-function-Lecture-after.xlsx.xlsx 12.61Кб
20.3 31. How-to-save-macros-Lecture-before.xlsx.xlsx 6.02Кб
20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp4 22.77Мб
20. Creating a structure for the calculation of Unlevered Free Cash Flows.srt 3.24Кб
20. Forecasting Unlevered free cash flow.mp4 55.94Мб
20. Forecasting Unlevered free cash flow.srt 6.09Кб
20. How to save macros and use them across several workbooks.mp4 12.79Мб
20. How to save macros and use them across several workbooks.srt 1.68Кб
20. RANK is a valuable tool when using Excel for Financial and Business analysis.mp4 23.25Мб
20. RANK is a valuable tool when using Excel for Financial and Business analysis.srt 2.86Кб
21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx 1.41Мб
21.1 20. Bridge UFCF to Net cash flow_after.xlsm.xlsm 58.70Кб
21.1 62. Choose-Exercise - Unsolved.xlsx.xlsx 11.32Кб
21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx 1.41Мб
21.2 20. Bridge UFCF to Net cash flow_before.xlsm.xlsm 58.58Кб
21.2 62. Choose-Lecture - Solved.xlsx.xlsx 9.69Кб
21.3 Excel-Functions.pdf.pdf 3.19Мб
21.4 62. Choose-Exercise-Solved.xlsx.xlsx 11.73Кб
21.5 62. Choose-Lecture - Unsolved.xlsx.xlsx 9.33Кб
21. Bridging Unlevered free cash flow to Net cash flow.mp4 14.58Мб
21. Bridging Unlevered free cash flow to Net cash flow.srt 2.04Кб
21. Excel Macros - quiz.html 167б
21. Forecasting other assets.mp4 45.24Мб
21. Forecasting other assets.srt 4.62Кб
21. Learn how to render your models flexible with CHOOSE.mp4 3.40Мб
21. Learn how to render your models flexible with CHOOSE.srt 2.81Кб
22.1 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx 1.42Мб
22.1 21. Calculating UFCF_before.xlsm.xlsm 58.66Кб
22.1 32. Drop-down-List-Exercise - Solved.xlsx.xlsx 77.02Кб
22.1 Excel-Functions.pdf.pdf 3.19Мб
22.2 16. Balance Sheet forecasting liabilities_before.xlsx.xlsx 1.41Мб
22.2 21. Calculating UFCF_after.xlsm.xlsm 59.18Кб
22.2 32. Data-Validation-Lecture - Solved.xlsx.xlsx 10.84Кб
22.2 63. Goal-Seek-Lecture - Solved.xlsx.xlsx 9.17Кб
22.3 32. Drop-down-List-Exercise - Unsolved.xlsx.xlsx 11.34Кб
22.3 63. Goal-Seek-Exercise-Solved.xlsx.xlsx 16.21Кб
22.4 63. Goal-Seek-Exercise - Unsolved.xlsx.xlsx 16.09Кб
22.4 Useful-Tips-Tools.pdf.pdf 3.31Мб
22.5 32. Data-Validation-Lecture - Unsolved.xlsx.xlsx 10.84Кб
22.5 63. Goal-Seek-Lecture - Unsolved.xlsx.xlsx 9.15Кб
22. Calculating Unlevered free cash flow.mp4 59.73Мб
22. Calculating Unlevered free cash flow.srt 6.57Кб
22. Create a drop-down list by using Data Validation.mp4 3.30Мб
22. Create a drop-down list by using Data Validation.srt 2.22Кб
22. Forecasting other liabilities.mp4 21.97Мб
22. Forecasting other liabilities.srt 2.36Кб
22. Use Goal Seek to find the result that you are looking for.mp4 3.02Мб
22. Use Goal Seek to find the result that you are looking for.srt 2.73Кб
23.1 16a. Complete UFCF_before.xlsx.xlsx 1.42Мб
23.1 22. Calculating Net Cash Flow_after.xlsm.xlsm 59.38Кб
23.1 33. Custom-Sort-Exercise - Unsolved.xlsx.xlsx 11.37Кб
23.2 16a. Complete UFCF_after.xlsx.xlsx 1.42Мб
23.2 33. Sort-data-Lecture - Solved.xlsx.xlsx 145.65Кб
23.2 Cash Flow Classification By Activities.xlsx 55.95Кб
23.3 22. Calculating Net Cash Flow_before.xlsm.xlsm 59.18Кб
23.3 33. Custom-Sort-Exercise - Solved.xlsx.xlsx 11.46Кб
23.4 Useful-Tips-Tools.pdf.pdf 3.31Мб
23.5 33. Sort-data-Lecture - Unsolved.xlsx.xlsx 145.35Кб
23. Calculating Net cash flow.mp4 37.90Мб
23. Calculating Net cash flow.srt 4.28Кб
23. Completing Unlevered free cash flow.mp4 40.89Мб
23. Completing Unlevered free cash flow.srt 3.71Кб
23. Use Goal Seek in order to find the result that you are looking for.html 167б
23. Using Custom-sort in order to sort multiple columns within a table.mp4 2.80Мб
23. Using Custom-sort in order to sort multiple columns within a table.srt 1.68Кб
24.1 17. Financing_before.xlsx.xlsx 1.43Мб
24.1 23. Find and replace_before.xlsm.xlsm 59.55Кб
24.1 34. Hyperlinks-Exercise - Unsolved.xlsx.xlsx 136.89Кб
24.1 64. Sensitivity analysis - Lecture - Unsolved.xlsm.xlsm 897.09Кб
24.2 17. Financing_after.xlsx.xlsx 1.43Мб
24.2 23. Find and replace_after.xlsm.xlsm 62.50Кб
24.2 34. Hyperlinks-Exercise - Solved.xlsx.xlsx 137.06Кб
24.2 64. Sensitivity-analysis-Exercise-Solved.xlsm.xlsm 63.87Кб
24.3 64. Sensitivity analysis - Lecture - Solved.xlsm.xlsm 897.30Кб
24.3 Useful-Tips-Tools.pdf.pdf 3.31Мб
24.4 64. Sensitivity-analysis-Exercise-Unsolved.xlsm.xlsm 66.82Кб
24. Create a great Index page at the beginning of your models - Hyperlinks.mp4 1.90Мб
24. Create a great Index page at the beginning of your models - Hyperlinks.srt 1.60Кб
24. Include sensitivity analysis in your models through Data Tables.mp4 5.43Мб
24. Include sensitivity analysis in your models through Data Tables.srt 4.95Кб
24. Modeling Tesla's financing needs in the forecast period.mp4 42.36Мб
24. Modeling Tesla's financing needs in the forecast period.srt 5.64Кб
24. Obtaining the rest of the cash flows through Find and Replace.mp4 46.74Мб
24. Obtaining the rest of the cash flows through Find and Replace.srt 4.35Кб
25.1 18. P&L complete_after.xlsx.xlsx 1.43Мб
25.1 24. Introducing WACC and g_before.xlsm.xlsm 62.49Кб
25.1 35. Freeze-Panes-Lecture - Unsolved.xlsx.xlsx 643.87Кб
25.2 18. P&L complete_before.xlsx.xlsx 1.43Мб
25.2 24. Introducing WACC and g_after.xlsm.xlsm 62.58Кб
25.2 35. Freeze-Panes-Lecture - Solved.xlsx.xlsx 643.94Кб
25.3 Useful-Tips-Tools.pdf.pdf 3.31Мб
25. Calculating Net income.mp4 14.81Мб
25. Calculating Net income.srt 1.39Кб
25. Fix the top row of your table with Freeze Panes.mp4 5.20Мб
25. Fix the top row of your table with Freeze Panes.srt 1.50Кб
25. Include sensitivity analysis in your models through Data Tables.html 167б
25. Introducing Weighted average cost of capital and Perpetuity growth.mp4 13.21Мб
25. Introducing Weighted average cost of capital and Perpetuity growth.srt 7.03Мб
26.1 19. Cash flow_complete_before.xlsx.xlsx 1.43Мб
26.1 25. Calculating PV of Cash Flows_after.xlsm.xlsm 62.71Кб
26.1 36. Exercise-Filter-by-Color-Solved.xlsx.xlsx 153.48Кб
26.1 65. Pivot tables - Lecture - Solved.xlsm.xlsm 897.26Кб
26.2 19. Cash flow_complete_after.xlsx.xlsx 1.43Мб
26.2 25. Calculating PV of Cash Flows_before.xlsm.xlsm 62.58Кб
26.2 36. Exercise-Filter-by-Color-Unsolved.xlsx.xlsx 20.47Кб
26.2 65. Pivot tables - Lecture - Unsolved.xlsm.xlsm 687.83Кб
26.3 65. Pivot Tables - Exercise - Solved.xlsx.xlsx 190.47Кб
26.4 65. Pivot Tables - Exercise - Unsolved.xlsx.xlsx 152.17Кб
26. Bridging Unlevered free cash flow to Net cash flow.mp4 50.73Мб
26. Bridging Unlevered free cash flow to Net cash flow.srt 4.51Кб
26. Discounting Unlevered free cash flows to obtain their Present value.mp4 20.22Мб
26. Discounting Unlevered free cash flows to obtain their Present value.srt 3.17Кб
26. Excel's dynamic and interactive tables Pivot tables.mp4 23.20Мб
26. Excel's dynamic and interactive tables Pivot tables.srt 2.61Кб
26. Filter by color - an excellent tool.mp4 9.88Мб
26. Filter by color - an excellent tool.srt 2.21Кб
27.1 20. Complete the BS_after.xlsx.xlsx 1.43Мб
27.1 26. Calculating CV and EV_after.xlsm.xlsm 63.10Кб
27.1 Exercise_Conditional Formatting.xlsx.xlsx 12.88Кб
27.2 20. Complete the BS_before.xlsx.xlsx 1.43Мб
27.2 26. Calculating CV and EV_before.xlsm.xlsm 62.71Кб
27.2 Solution_Conditional Formatting.xlsx.xlsx 51.52Кб
27. Balancing the Balance sheet.mp4 13.26Мб
27. Balancing the Balance sheet.srt 13.27Мб
27. Calculating Continuing value and Enterprise value of the business.mp4 17.72Мб
27. Calculating Continuing value and Enterprise value of the business.srt 2.55Кб
27. Excel's key functions and functionalities made easy.html 166б
27. Working with conditional formatting.mp4 15.09Мб
27. Working with conditional formatting.srt 6.07Кб
28.1 21. WACC_before.xlsx.xlsx 1.43Мб
28.1 27. Calculating equity value_before.xlsm.xlsm 63.10Кб
28.1 38. Multiply-by-1-Lecture-before.xlsx.xlsx 16.47Кб
28.2 21. WACC_after.xlsx.xlsx 1.43Мб
28.2 27. Calculating equity value_after.xlsm.xlsm 63.27Кб
28.2 38. Multiply-by-1-Lecture-after.xlsx.xlsx 17.21Кб
28. A neat trick - Multiply by 1.mp4 14.85Мб
28. A neat trick - Multiply by 1.srt 1.74Кб
28. Calculating Equity value.mp4 12.21Мб
28. Calculating Equity value.srt 1.70Кб
28. Estimating Weighted average cost of capital (WACC).mp4 44.26Мб
28. Estimating Weighted average cost of capital (WACC).srt 6.77Кб
29.1 22. DCF_after.xlsx.xlsx 1.44Мб
29.1 28. Sensitivity analysis_after.xlsm.xlsm 64.83Кб
29.2 22. DCF_before.xlsx.xlsx 1.52Мб
29.2 Sensitivity Analysis.xlsx 60.81Кб
29.3 28. Sensitivity analysis_before.xlsm.xlsm 63.27Кб
29. Performing discounted cash flow valuation (DCF).mp4 34.90Мб
29. Performing discounted cash flow valuation (DCF).srt 4.06Кб
29. Sensitivity analysis for WACC and perpetuity growth.mp4 40.49Мб
29. Sensitivity analysis for WACC and perpetuity growth.srt 4.57Кб
29. Useful tips and tools for your work in Excel - quiz.html 166б
3.1 1. Deliveries_after.xlsx.xlsx 1.29Мб
3.1 103. Doughnut chart-Lecture-before.xlsm.xlsm 11.52Мб
3.1 2. Savings Forecast_unsolved.xlsx.xlsx 14.74Кб
3.1 70. Loan Schedule-Lecture.xlsx.xlsx 20.17Кб
3.1 74. Formatting-a-Pivot-Table - Lecture - before.xlsx.xlsx 1.43Мб
3.1 80. Get to know the data source.xlsm.xlsm 43.03Кб
3.1 97. Modifying-a-Chart-Lecture.xlsm.xlsm 11.40Мб
3.1 Functions - English to German.pdf.pdf 102.32Кб
3.1 Useful-Tips-Tools.pdf.pdf 3.31Мб
3.1 Valuation exercise.pdf.pdf 411.76Кб
3.2 1. Deliveries_before.xlsx.xlsx 1.29Мб
3.2 103. Doughnut chart-Lecture-after.xlsm.xlsm 11.52Мб
3.2 19. Fast-Scrolling-Exercise - Solved.xlsx.xlsx 44.35Кб
3.2 2. Savings Forecast.xlsx.xlsx 16.58Кб
3.2 47. IF-function--Lecture-before.xlsm.xlsm 17.00Кб
3.2 70. Exercise-Loan-Schedule-Solved.xlsx.xlsx 22.68Кб
3.2 74. Formatting-a-Pivot-Table - Lecture - after.xlsx.xlsx 1.43Мб
3.3 19. Fast-Scrolling - Lecture.xlsx.xlsx 642.82Кб
3.3 70. Exercise-Loan-Schedule-Unsolved.xlsx.xlsx 15.81Кб
3.3 Key functions - Excel.pdf.pdf 8.46Мб
3.4 19. Fast-Scrolling-Exercise - Unsolved.xlsx.xlsx 43.90Кб
3.4 Functions - English to Portuguese.pdf.pdf 146.09Кб
3.5 47. IF-function-Lecture-after.xlsm.xlsm 17.94Кб
3.6 Functions - English to Spanish.pdf.pdf 102.37Кб
3. Calculating a complete loan schedule in Excel.mp4 14.81Мб
3. Calculating a complete loan schedule in Excel.srt 6.52Кб
3. Excel chart formatting.mp4 32.75Мб
3. Excel chart formatting.srt 3.47Кб
3. Fast scrolling through Excel sheets.mp4 6.26Мб
3. Fast scrolling through Excel sheets.srt 1.82Кб
3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4 9.22Мб
3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.srt 4.26Кб
3. Forecasting Tesla's expected deliveries.mp4 114.90Мб
3. Forecasting Tesla's expected deliveries.srt 15.38Кб
3. Give your Excel Pivot Tables a makeover.mp4 11.27Мб
3. Give your Excel Pivot Tables a makeover.srt 2.37Кб
3. Key functions in Excel IF.mp4 16.66Мб
3. Key functions in Excel IF.srt 2.95Кб
3. Learn how to build effective doughnut charts in Excel.mp4 38.00Мб
3. Learn how to build effective doughnut charts in Excel.srt 5.44Кб
3. Overview of Excel.html 167б
3. The stages of a complete DCF Valuation.mp4 49.24Мб
3. The stages of a complete DCF Valuation.srt 7.33Кб
3. The time value of money.mp4 6.70Мб
3. The time value of money.srt 2.78Кб
3. Understand your data source before you start working on it.mp4 28.16Мб
3. Understand your data source before you start working on it.srt 3.17Кб
3. Welcome gift number 2.html 171б
3. Why use financial models.mp4 7.69Мб
3. Why use financial models.srt 3.31Кб
3. Working with an SAP data extraction.mp4 21.96Мб
3. Working with an SAP data extraction.srt 4.08Кб
30.1 23. EV, Equity value, Price per share_before.xlsx.xlsx 1.44Мб
30.1 29. Goal seek_before.xlsm.xlsm 64.83Кб
30.1 39. Find-and-Replace-references-Lecture-after.xlsx.xlsx 37.91Кб
30.2 23. EV, Equity value, Price per share_after.xlsx.xlsx 1.44Мб
30.2 29. Goal seek_ater.xlsm.xlsm 64.84Кб
30.2 39. Find-and-Replace-references-Lecture-before.xlsx.xlsx 38.79Кб
30. A possible application of Goal seek.mp4 15.62Мб
30. A possible application of Goal seek.srt 1.98Кб
30. Calculating enterprise value, equity value, and price per share.mp4 22.55Мб
30. Calculating enterprise value, equity value, and price per share.srt 2.15Кб
30. Find and replace - references.mp4 24.03Мб
30. Find and replace - references.srt 3.45Кб
31.1 30. Charts.xlsm.xlsm 101.22Кб
31.1 40. Find-replace-Lecture-before.xlsx.xlsx 17.19Кб
31.2 40. Find-replace-Lecture-after.xlsx.xlsx 17.19Кб
31. Final comments.mp4 44.89Мб
31. Final comments.srt 4.43Кб
31. Find and replace - formatting.mp4 13.79Мб
31. Find and replace - formatting.srt 1.91Кб
31. Using charts to summarize the results of the DCF model.mp4 32.89Мб
32.1 41. Green-references-Lecture.xlsx.xlsx 12.00Кб
32. Removing (automatic) green arrows.mp4 12.61Мб
32. Removing (automatic) green arrows.srt 12.61Мб
32. You made it!.mp4 11.27Мб
32. You made it!.srt 2.84Кб
33.1 42. Beauty-saving-Lecture-after.xlsx.xlsx 17.05Кб
33.2 42. Beauty-saving-Lecture-before.xlsx.xlsx 17.17Кб
33. Beauty saving - The professional way of saving files.mp4 14.03Мб
33. Beauty saving - The professional way of saving files.srt 2.54Кб
34.1 43. F2-Lecture.xlsm.xlsm 50.76Кб
34. Formula auditing with F2.mp4 17.75Мб
34. Formula auditing with F2.srt 2.19Кб
4.1 104. Area chart-Lecture-after.xlsm.xlsm 11.53Мб
4.1 111. Exercise-Build-an-FMCG-Model-Structure-Lecture.xlsx.xlsx 14.92Мб
4.1 1a. Deliveries development.xlsx.xlsx 1.30Мб
4.1 20. F5-go-to - Lecture.xlsm.xlsm 50.76Кб
4.1 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx 18.54Кб
4.1 3. Structure of the DCF model.xlsm.xlsm 47.90Кб
4.1 48. Sum-Sumif-Sumifs-Lecture - Solved.xlsx.xlsx 13.01Кб
4.1 71. Date Functions-Exercise-Unsolved.xlsx.xlsx 11.41Кб
4.1 75. Working-with-Pivot-Tables - Lecture - before.xlsx.xlsx 1.43Мб
4.1 8. Basic-Manipulations - Exercise - Unsolved.xlsx.xlsx 11.06Кб
4.1 81. Order a worksheet_before.xlsm.xlsm 43.08Кб
4.1 98. Bridge-Charts-Lecture.xlsx.xlsx 13.10Кб
4.2 104. Area chart-Lecture-before.xlsm.xlsm 11.51Мб
4.2 3. Fixed Asset Rollforward.xlsx.xlsx 19.66Кб
4.2 71. Date Functions-Exercise-Solved.xlsx.xlsx 12.43Кб
4.2 75. Working-with-Pivot-Tables - Lecture - after.xlsx.xlsx 1.88Мб
4.2 8. Basic manipulations - Lecture.xlsx.xlsx 8.07Кб
4.2 81. Order a worksheet_after.xlsm.xlsm 41.01Кб
4.2 DCF Model structure.pdf.pdf 240.80Кб
4.2 Excel-Functions.pdf.pdf 3.19Мб
4.3 48. Sum-Sumif-Sumifs-Exercise - Solved.xlsx.xlsx 14.84Кб
4.3 71. Date Functions-Lecture.xlsx.xlsx 12.25Кб
4.3 8. Basic-Manipulations - Exercise - Solved.xlsx.xlsx 32.43Кб
4.4 48. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx.xlsx 12.93Кб
4.5 48. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx.xlsx 14.46Кб
4. Basic manipulations with rows and columns.mp4 6.91Мб
4. Basic manipulations with rows and columns.srt 2.10Кб
4. Be even quicker F5 + Enter.mp4 19.79Мб
4. Be even quicker F5 + Enter.srt 2.16Кб
4. Calculating future and present Value.mp4 13.09Мб
4. Calculating future and present Value.srt 6.66Кб
4. Comparing delivery figures with the ones of industry peers.mp4 20.94Мб
4. Comparing delivery figures with the ones of industry peers.srt 3.10Кб
4. Creating an output structure of the FMCG model.mp4 11.65Мб
4. Creating an output structure of the FMCG model.srt 2.98Кб
4. Date functions in Excel.mp4 11.35Мб
4. Date functions in Excel.srt 5.79Кб
4. Description of the structure of the DCF model.mp4 18.54Мб
4. Description of the structure of the DCF model.srt 3.33Кб
4. Financial modeling - worst practices - things you should avoid.mp4 19.92Мб
4. Financial modeling - worst practices - things you should avoid.srt 7.33Кб
4. Fixed asset rollforward.mp4 12.16Мб
4. Fixed asset rollforward.srt 5.55Кб
4. How to create a bridge chart in Excel.mp4 13.66Мб
4. How to create a bridge chart in Excel.srt 1.89Кб
4. Key Excel functions SUM, SUMIF and SUMIFS.mp4 6.73Мб
4. Key Excel functions SUM, SUMIF and SUMIFS.srt 5.27Кб
4. Learn how to build an area chart in Excel.mp4 28.59Мб
4. Learn how to build an area chart in Excel.srt 3.56Кб
4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4 23.01Мб
4. Modifying and pivoting fields to obtain the Pivot Table you need.srt 4.74Кб
4. Order the source worksheets.mp4 26.55Мб
4. Order the source worksheets.srt 2.52Кб
4. The best way to take this course.mp4 17.62Мб
4. The best way to take this course.srt 2.52Кб
5. = and + are interchangeable when you start typing a formula.mp4 5.80Мб
5. = and + are interchangeable when you start typing a formula.srt 974б
5.1 105. Bridge chart-Lecture-after.xlsm.xlsm 11.54Мб
5.1 112. Exercise-Build-an-FMCG-Model-Formatting-Lecture.xlsx.xlsx 14.92Мб
5.1 2. Average price_before.xlsx.xlsx 1.31Мб
5.1 4. Working Capital.xlsx.xlsx 21.93Кб
5.1 49. = and + are interchangeable -after.xlsm.xlsm 17.04Кб
5.1 76. GetPivotData - Lecture – after.xlsx.xlsx 1.88Мб
5.1 82. Creating a code_after.xlsm.xlsm 41.73Кб
5.1 99. Treemap-Charts-Lecture.xlsx.xlsx 12.62Кб
5.1 Cheeseco.pptx.pptx 80.09Кб
5.2 105. Bridge chart-Lecture-before.xlsm.xlsm 11.53Мб
5.2 2. Average price_after.xlsx.xlsx 1.31Мб
5.2 4. Working Capital_unsolved.xlsx.xlsx 21.19Кб
5.2 49. = and + are interchangeable - before.xlsm.xlsm 17.01Кб
5.2 76. GetPivotData - Lecture - before.xlsx.xlsx 1.88Мб
5.2 82. Creating a code_before.xlsm.xlsm 41.01Кб
5. A glimpse at the company we are valuing - Cheeseco.mp4 15.68Мб
5. A glimpse at the company we are valuing - Cheeseco.srt 1.41Кб
5. Calculating cost of equity.mp4 19.21Мб
5. Calculating cost of equity.srt 8.01Кб
5. Create a code the best way to organize your data and work efficiently with it.mp4 24.49Мб
5. Create a code the best way to organize your data and work efficiently with it.srt 2.25Кб
5. Download all course materials.html 761б
5. Estimating an average selling price of Tesla vehicles.mp4 41.92Мб
5. Estimating an average selling price of Tesla vehicles.srt 5.17Кб
5. Fast scrolling through Excel sheets.html 167б
5. Financial modeling - best practices.mp4 17.22Мб
5. Financial modeling - best practices.srt 6.04Кб
5. Improving the layout and appearance of the FMCG report.mp4 13.50Мб
5. Improving the layout and appearance of the FMCG report.srt 4.94Кб
5. Learn how to create bridge charts.mp4 52.07Мб
5. Learn how to create bridge charts.srt 7.61Кб
5. Learn more about GETPIVOTDATA - A very important Excel function.mp4 18.06Мб
5. Learn more about GETPIVOTDATA - A very important Excel function.srt 4.00Кб
5. New ways to visualize your data - Treemap charts.mp4 11.50Мб
5. New ways to visualize your data - Treemap charts.srt 1.72Кб
5. Rows and columns.html 167б
5. The impact of working capital.mp4 5.37Мб
5. The impact of working capital.srt 3.03Кб
6.1 100. Sparklines-Lecture.xlsx.xlsx 9.59Кб
6.1 113. Exercise-Build-an-FMCG-Model-Adding-Calculations-Lecture.xlsx.xlsx 14.92Мб
6.1 21. Fixing-references-Lecture - Unsolved.xlsx.xlsx 643.98Кб
6.1 3. Revenue calculation and scenarios - before.xlsx.xlsx 1.31Мб
6.1 5. Financing_unsolved.xlsx.xlsx 29.99Кб
6.1 5. Modeling revenues_before.xlsm.xlsm 47.85Кб
6.1 77. Slicers - Lecture - after.xlsx.xlsx 1.88Мб
6.1 83. Creating a database_after.xlsm.xlsm 39.39Кб
6.1 9. The-Ribbon-Exercise-Exercise - Unsolved.xlsx.xlsx 12.09Кб
6.1 Excel-Functions.pdf.pdf 3.19Мб
6.2 21. Fixing-Cells-Exercise - Unsolved.xlsx.xlsx 10.67Кб
6.2 3. Revenue calculation and scenarios - after.xlsx.xlsx 1.31Мб
6.2 5. Financing.xlsx.xlsx 30.97Кб
6.2 5. Modeling revenues_after.xlsm.xlsm 48.16Кб
6.2 77. Slicers - Lecture - before.xlsx.xlsx 1.88Мб
6.2 83. Creating a database_before.xlsm.xlsm 41.73Кб
6.2 9. The-Ribbon-Exercise-Solved.xlsx.xlsx 403.25Кб
6.2 Lecture-Count-Countif-Countifs-Solved.xlsx.xlsx 11.68Кб
6.3 21. Fixing-references-Lecture - Solved.xlsx.xlsx 645.17Кб
6.3 50.Counts-Exercise-Solved.xlsx.xlsx 16.07Кб
6.4 21. Fixing-Cells-Exercise - Solved.xlsx.xlsx 10.82Кб
6.4 50.Counts-Exercise-Unsolved.xlsx.xlsx 15.56Кб
6.5 Lecture-Count-Countif-Countifs-Unsolved.xlsx.xlsx 11.29Кб
6.5 Useful-Tips-Tools.pdf.pdf 3.31Мб
6. An introduction to slicers - The modern-day Pivot Table filters.mp4 22.17Мб
6. An introduction to slicers - The modern-day Pivot Table filters.srt 4.74Кб
6. Calculating automotive revenue.mp4 46.56Мб
6. Calculating automotive revenue.srt 4.93Кб
6. Coming up with project-specific beta.mp4 9.01Мб
6. Coming up with project-specific beta.srt 3.83Кб
6. Financial modeling - The types of models that are built in practice.mp4 12.50Мб
6. Financial modeling - The types of models that are built in practice.srt 5.84Кб
6. Inserting formulas and automating calculations.mp4 8.84Мб
6. Inserting formulas and automating calculations.srt 4.94Кб
6. Introduction to fixing of cell references.mp4 6.12Мб
6. Introduction to fixing of cell references.srt 2.69Кб
6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 6.01Мб
6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.srt 4.80Кб
6. Learn how to create a database.mp4 20.70Мб
6. Learn how to create a database.srt 2.13Кб
6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4 136.11Мб
6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.srt 12.69Кб
6. Modeling debt financing.mp4 6.17Мб
6. Modeling debt financing.srt 3.43Кб
6. Modeling the top line.mp4 26.31Мб
6. Modeling the top line.srt 4.00Кб
6. Sparklines.mp4 27.56Мб
6. Sparklines.srt 4.25Кб
6. The Excel ribbon.mp4 8.81Мб
6. The Excel ribbon.srt 3.20Кб
7.1 10. Data-Entry - Lecture.xlsx.xlsx 8.07Кб
7.1 114. Exercise-Build-an-FMCG-Model-Creating-a-Pivot-Table-Lecture.xlsx.xlsx 20.82Мб
7.1 4. Gross profit automotive.xlsx.xlsx 1.32Мб
7.1 51. Average-Averageif- Lecture - Solved.xlsx.xlsx 9.40Кб
7.1 6. Choose_before.xlsm.xlsm 48.16Кб
7.1 6. P&L_unsolved.xlsx.xlsx 29.70Кб
7.1 84. Vlookup_after.xlsm.xlsm 44.45Кб
7.2 10. Data-Entry-Exercise - Unsolved.xlsx.xlsx 10.97Кб
7.2 51. Average-Averageif- Lecture - Unsolved.xlsx.xlsx 9.03Кб
7.2 6. Choose_after.xlsm.xlsm 48.36Кб
7.2 6. P&L.xlsx.xlsx 31.03Кб
7.2 84. Vlookup_before.xlsm.xlsm 39.50Кб
7.3 10. Data-Entry- Exercise -Solved.xlsx.xlsx 32.76Кб
7.3 51. Average-AverageIF-Exercise - Solved.xlsx.xlsx 15.02Кб
7.4 Excel-Functions.pdf.pdf 3.19Мб
7.5 51. Average-AverageIF-Exercise - Unsolved.xlsx.xlsx 14.60Кб
7. Adding a P&L sheet.mp4 4.89Мб
7. Adding a P&L sheet.srt 2.23Кб
7. Case Study - Building a Complete P&L from scratch in Excel.html 166б
7. Creating a Master Pivot Table The main data source for the FMCG report.mp4 13.82Мб
7. Creating a Master Pivot Table The main data source for the FMCG report.srt 2.21Кб
7. Data entry in Excel.mp4 10.40Мб
7. Data entry in Excel.srt 3.53Кб
7. Financial modeling - Quiz.html 167б
7. Introducing scenarios to the model with Choose.mp4 17.83Мб
7. Introducing scenarios to the model with Choose.srt 2.63Кб
7. Introduction to fixing of cell references.html 167б
7. Key Excel functions AVERAGE and AVERAGEIF.mp4 2.78Мб
7. Key Excel functions AVERAGE and AVERAGEIF.srt 2.38Кб
7. Peer comparison Gross profit %.mp4 17.17Мб
7. Peer comparison Gross profit %.srt 2.72Кб
7. Use VLOOKUP to fill the Database sheet.mp4 61.57Мб
7. Use VLOOKUP to fill the Database sheet.srt 5.60Кб
7. Weighted average cost of capital (WACC).mp4 5.51Мб
7. Weighted average cost of capital (WACC).srt 2.48Кб
8.1 107. Course-Challenge - Unsolved.xlsx.xlsx 505.49Кб
8.1 11. Formatting- Exercise - Solved.xlsx.xlsx 11.59Кб
8.1 115. Exercise-Build-an-FMCG-Model-GETPIVOTDATA-Lecture.xlsx.xlsx 20.82Мб
8.1 22. Alt-Enter-Exercise - Unsolved.xlsx.xlsx 11.12Кб
8.1 4a. Gross profit automotive - before.xlsx.xlsx 1.51Мб
8.1 7. Cash flow_unsolved.xlsx.xlsx 29.64Кб
8.1 7. Other revenues and Cogs_after.xlsm.xlsm 50.08Кб
8.2 107. Course-Challenge - Solved.xlsx.xlsx 543.93Кб
8.2 11. Formatting-Exercise - Unsolved.xlsx.xlsx 11.61Кб
8.2 22. Alt-Enter- Lecture - Unsolved.xlsx.xlsx 9.64Кб
8.2 4a. Gross profit automotive - after.xlsx.xlsx 1.32Мб
8.2 7. Cash flow.xlsx.xlsx 31.36Кб
8.2 7. Other revenues and Cogs_before.xlsm.xlsm 48.36Кб
8.3 11. Formatting- Lecture - Unsolved.xlsx.xlsx 8.91Кб
8.3 22. Alt-Enter-Exercise - Solved.xlsx.xlsx 11.40Кб
8.4 11. Formatting - Lecture - Solved.xlsx.xlsx 9.85Кб
8.4 22. Alt-Enter- Lecture - Solved.xlsx.xlsx 9.65Кб
8. 50% Completed!.mp4 4.31Мб
8. 50% Completed!.srt 41б
8. Calculating automotive gross profit.mp4 27.76Мб
8. Calculating automotive gross profit.srt 2.88Кб
8. Calculating project cash flows.mp4 10.15Мб
8. Calculating project cash flows.srt 3.98Кб
8. Course Challenge - Apply your skills in practice!.mp4 7.91Мб
8. Course Challenge - Apply your skills in practice!.srt 1.29Кб
8. Financial modeling The right level of detail in a model.mp4 5.69Мб
8. Financial modeling The right level of detail in a model.srt 3.10Кб
8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4 31.05Мб
8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.srt 7.14Кб
8. Introduction to formatting.mp4 24.76Мб
8. Introduction to formatting.srt 6.64Кб
8. Key Excel functions AVERAGE and AVERAGEIF.html 167б
8. Modeling other items Other revenues and Cogs.mp4 44.56Мб
8. Modeling other items Other revenues and Cogs.srt 4.55Кб
8. The type of cash flows we will have in a project.mp4 9.33Мб
8. The type of cash flows we will have in a project.srt 4.16Кб
8. Using the 'Alt + Enter' combination.mp4 1.46Мб
8. Using the 'Alt + Enter' combination.srt 1.04Кб
9.1 12. Formulas- Exercise - Solved.xlsx.xlsx 80.13Кб
9.1 5. Cost of sales and chart.xlsx.xlsx 1.34Мб
9.1 52. Text functions - Exercise - Unsolved.xlsx.xlsx 11.71Кб
9.1 8. Opex and D&A_before.xlsm.xlsm 50.08Кб
9.1 8. WACC_unsolved.xlsx.xlsx 35.93Кб
9.1 86. Sumif_before.xlsm.xlsm 44.45Кб
9.1 Useful-Tips-Tools.pdf.pdf 3.31Мб
9.2 12. Formulas- Lecture - Solved.xlsx.xlsx 9.36Кб
9.2 23. Text-to-Columns-Exercise - Solved.xlsx.xlsx 11.30Кб
9.2 52. Text-Functions- Lecture - Solved.xlsx.xlsx 11.10Кб
9.2 8. Opex and D&A_after.xlsm.xlsm 50.57Кб
9.2 8. WACC.xlsx.xlsx 38.03Кб
9.2 86. Sumif_after.xlsm.xlsm 49.53Кб
9.3 23. Text-to-Columns-Exercise - Unsolved.xlsx.xlsx 10.57Кб
9.3 52. Text functions - Exercise - Solved.xlsx.xlsx 12.24Кб
9.3 Introduction-to-Excels-basic-features.pdf.pdf 2.26Мб
9.4 12. Formulas- Lecture - Unsolved.xlsx.xlsx 9.30Кб
9.4 23.Text-to-columns-Lecture - Solved.xlsx.xlsx 9.90Кб
9.4 52. Text-Functions- Lecture - Unsolved.xlsx.xlsx 10.60Кб
9.5 12. Formulas - Exercise - Unsolved.xlsx.xlsx 11.72Кб
9.5 23. Text-to-columns-Lecture - Unsolved.xlsx.xlsx 9.76Кб
9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4 13.77Мб
9. A potential error with GETPIVOTDATA you might encounter and its fix.srt 1.50Кб
9. Calculating automotive cost of sales.mp4 17.49Мб
9. Calculating automotive cost of sales.srt 2.27Кб
9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4 6.31Мб
9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.srt 6.32Мб
9. Estimating the project's cash flows.mp4 18.80Мб
9. Estimating the project's cash flows.srt 7.15Кб
9. Estimating the weighted average cost of capital (WACC).mp4 5.59Мб
9. Estimating the weighted average cost of capital (WACC).srt 3.52Кб
9. Financial modeling Forecasting guidelines.mp4 6.44Мб
9. Financial modeling Forecasting guidelines.srt 3.54Кб
9. Introduction to Excel formulas.mp4 18.77Мб
9. Introduction to Excel formulas.srt 4.28Кб
9. Learn how to organize your data with Text to Columns.mp4 3.94Мб
9. Learn how to organize your data with Text to Columns.srt 2.34Кб
9. Modeling other items Operating expenses and D&A.mp4 26.34Мб
9. Modeling other items Operating expenses and D&A.srt 2.77Кб
9. Use SUMIF to complete the Database sheet.mp4 47.95Мб
9. Use SUMIF to complete the Database sheet.srt 4.40Кб
Download Paid Udemy Courses For Free.url 116б
GetFreeCourses.Co.url 116б
How you can help GetFreeCourses.Co.txt 182б
Статистика распространения по странам
Китай (CN) 2
Россия (RU) 2
Великобритания (GB) 1
США (US) 1
Южная Корея (KR) 1
Италия (IT) 1
Индия (IN) 1
Франция (FR) 1
Всего 10
Список IP Полный список IP-адресов, которые скачивают или раздают этот торрент