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