|
Обратите внимание, что наш сайт не размещает какие-либо файлы из списка. Вы не можете скачать
эти файлы или скачать torrent-файл.
|
| [CourseClub.NET].url |
123б |
| [FCS Forum].url |
133б |
| [FreeCourseSite.com].url |
127б |
| 1.1 0. Exercise - Build an FMCG Model_before.xlsx.xlsx |
13.27Мб |
| 1.1 0a. Drivers_before.xlsx.xlsx |
1.27Мб |
| 1.1 Course Notes - Beginner to Pro in Excel.pdf.pdf |
19.04Мб |
| 1.2 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.13Мб |
| 1. Case study - Build a P&L from scratch - Welcome lecture.vtt |
1.53Кб |
| 1. Excel's key functions - Welcome lecture.mp4 |
2.32Мб |
| 1. Excel's key functions - Welcome lecture.vtt |
1.09Кб |
| 1. Excel best practices - Welcome lecture.mp4 |
2.13Мб |
| 1. Excel best practices - Welcome lecture.vtt |
1.02Кб |
| 1. Exercise - Excel's Sumifs function - unsolved.html |
167б |
| 1. Financial Modeling basics - Welcome lecture.mp4 |
2.10Мб |
| 1. Financial Modeling basics - Welcome lecture.vtt |
1.07Кб |
| 1. Future and present values in Excel.mp4 |
14.96Мб |
| 1. Future and present values in Excel.vtt |
6.13Кб |
| 1. Introduction to Capital budgeting.mp4 |
5.43Мб |
| 1. Introduction to Capital budgeting.vtt |
1.79Кб |
| 1. Introduction to Excel - welcome lecture.mp4 |
1.99Мб |
| 1. Introduction to Excel - welcome lecture.vtt |
911б |
| 1. Introduction to Mergers & Acquisitions.html |
167б |
| 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.vtt |
1.99Кб |
| 1. Introduction to the Capital Budgeting exercise.mp4 |
8.63Мб |
| 1. Introduction to the Capital Budgeting exercise.vtt |
3.21Кб |
| 1. Introduction to the Case Study.mp4 |
12.05Мб |
| 1. Introduction to the Case Study.vtt |
2.45Кб |
| 1. Keyboard shortcuts Save LOTS of time in Excel.mp4 |
30.43Мб |
| 1. Keyboard shortcuts Save LOTS of time in Excel.vtt |
5.16Кб |
| 1. Organizing external inputs in a 'Drivers' sheet.mp4 |
31.01Мб |
| 1. Organizing external inputs in a 'Drivers' sheet.vtt |
4.24Кб |
| 1. The core theory behind Company Valuation.html |
167б |
| 1. Valuation Case study - Welcome lecture.mp4 |
1.78Мб |
| 1. Valuation Case study - Welcome lecture.vtt |
869б |
| 1. What does the course cover.mp4 |
8.95Мб |
| 1. What does the course cover.vtt |
3.11Кб |
| 10.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx |
22.82Мб |
| 10.1 6. Energy and Other revenue - After.xlsx.xlsx |
1.34Мб |
| 10.1 8. WACC_unsolved.xlsx.xlsx |
35.93Кб |
| 10.1 9. Index & Match - Unsolved.xlsx.xlsx |
38.45Кб |
| 10.1 9. Interest expenses, Extraordinary items and Taxes - Solved.xlsm.xlsm |
52.69Кб |
| 10.1 Excel Functions.xlsx |
971.02Кб |
| 10.1 Useful Tips & Tools PDF Version.pdf |
9.43Мб |
| 10.2 03 22 Wrap Text Exercise & Text.xlsx.xlsx |
10.17Кб |
| 10.2 6. Energy and Other revenue - Before.xlsx.xlsx |
1.34Мб |
| 10.2 8. WACC.xlsx.xlsx |
38.03Кб |
| 10.2 9. Index & Match - Solved.xlsx.xlsx |
42.89Кб |
| 10.2 9. Interest expenses, Extraordinary items and Taxes – Unsolved.xlsm.xlsm |
51.62Кб |
| 10.2 Key Functions In Excel.pdf |
9.85Мб |
| 10.3 03 22 Wrap Text Solved.xlsx.xlsx |
10.20Кб |
| 10.3 05 42 Round Exercise & Text.xlsx.xlsx |
11.34Кб |
| 10.4 05 42 Round Solved.xlsx.xlsx |
11.71Кб |
| 10.4 Wrap text – Unsolved.xlsx.xlsx |
9.61Кб |
| 10.5 Wrap text - Solved.xlsx.xlsx |
9.61Кб |
| 10. Finding cost of equity.mp4 |
13.92Мб |
| 10. Finding cost of equity.vtt |
7.11Кб |
| 10. Forecasting 'energy' and 'services' revenue.mp4 |
25.30Мб |
| 10. Forecasting 'energy' and 'services' revenue.vtt |
3.15Кб |
| 10. Forecasting financials - Quiz.html |
163б |
| 10. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 |
17.12Мб |
| 10. Getting fancy with Excel slicers - Good-looking Excel slicers.vtt |
3.40Кб |
| 10. Include Round in your financial models.mp4 |
1.23Мб |
| 10. Include Round in your financial models.vtt |
1.14Кб |
| 10. Introduction to Excel formulas.html |
163б |
| 10. Learn how to use the Wrap Text button.mp4 |
908.39Кб |
| 10. Learn how to use the Wrap Text button.vtt |
869б |
| 10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4 |
5.14Мб |
| 10. Modeling other items Interest expenses, Extraordinary items and Taxes.vtt |
2.80Кб |
| 10. Use Index & Match as a substitute for Vlookup.mp4 |
12.66Мб |
| 10. Use Index & Match as a substitute for Vlookup.vtt |
4.22Кб |
| 11.1 02 12 Functions Exercise & Text.xlsx.xlsx |
13.26Кб |
| 11.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx |
22.81Мб |
| 11.1 10. Mapping - Solved.xlsx.xlsx |
47.50Кб |
| 11.1 10. Project BS items - Solved.xlsm.xlsm |
52.70Кб |
| 11.1 7. Energy and Other - Gross profit, cost of sales - Before.xlsx.xlsx |
1.35Мб |
| 11.1 9. Discounted cash flow.xlsx.xlsx |
38.06Кб |
| 11.1 Key Functions In Excel.pdf |
9.84Мб |
| 11.1 Useful Tips & Tools PDF Version.pdf |
9.43Мб |
| 11.2 05 43 Vlookup, Hlookup Solved.xlsx.xlsx |
14.19Кб |
| 11.2 10. Mapping - Unsolved.xlsx.xlsx |
39.04Кб |
| 11.2 10. Project BS items – Unsolved.xlsm.xlsm |
52.70Кб |
| 11.2 7. Energy and Other - Gross profit, cost of sales - After.xlsx.xlsx |
1.35Мб |
| 11.2 9. Discounted cash flow_unsolved.xlsx.xlsx |
37.25Кб |
| 11.2 Functions - Solved.xlsx.xlsx |
9.34Кб |
| 11.2 Set Print Area – Unsolved.xlsx.xlsx |
11.42Кб |
| 11.3 02 12 Functions Solved.xlsx.xlsx |
81.10Кб |
| 11.3 05 43 Vlookup, Hlookup Exercise & Text.xlsx.xlsx |
11.95Кб |
| 11.3 Set Print Area - Solved.xlsx.xlsx |
11.22Кб |
| 11.4 Functions – Unsolved.xlsx.xlsx |
9.24Кб |
| 11.4 Vlookup, Hlookup - Unsolved.xlsx.xlsx |
10.74Кб |
| 11.5 Vlookup, Hlookup – Solved.xlsx.xlsx |
11.13Кб |
| 11. Building a complete model - Important considerations.mp4 |
6.44Мб |
| 11. Building a complete model - Important considerations.vtt |
2.72Кб |
| 11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4 |
26.80Мб |
| 11. Calculating 'energy' and 'services' gross profit and cost of sales.vtt |
2.52Кб |
| 11. Create easily printable documents in Excel by using Set Print Area.mp4 |
1.71Мб |
| 11. Create easily printable documents in Excel by using Set Print Area.vtt |
1.50Кб |
| 11. Discounting the project's cash flows and residual value.mp4 |
22.54Мб |
| 11. Discounting the project's cash flows and residual value.vtt |
3.28Кб |
| 11. Forecasting Balance Sheet items.mp4 |
1012.43Кб |
| 11. Forecasting Balance Sheet items.vtt |
893б |
| 11. Introduction to Excel functions.mp4 |
12.06Мб |
| 11. Introduction to Excel functions.vtt |
4.36Кб |
| 11. Learn how to transfer data efficiently in Excel Vlookup and Hlookup.mp4 |
12.11Мб |
| 11. Learn how to transfer data efficiently in Excel Vlookup and Hlookup.vtt |
8.45Кб |
| 11. Mapping the rows in the Database sheet.mp4 |
9.41Мб |
| 11. Mapping the rows in the Database sheet.vtt |
2.67Кб |
| 11. This is how the report can be used in practice by high-level executives.mp4 |
19.81Мб |
| 11. This is how the report can be used in practice by high-level executives.vtt |
4.38Кб |
| 12.1 02 13 Copy Cut Paste Exercise Text.xlsx.xlsx |
11.34Кб |
| 12.1 10. Sensitivty analysis_unsolved.xlsx.xlsx |
38.63Кб |
| 12.1 11 Building A P&L.xlsx |
53.83Кб |
| 12.1 8. Opex - Before.xlsx.xlsx |
1.36Мб |
| 12.1 Solution_Index; Match; Index and Match.xlsx.xlsx |
17.03Кб |
| 12.1 Useful Tips & Tools PDF Version.pdf |
9.43Мб |
| 12.1 Working Capital Days.pptx.pptx |
121.55Кб |
| 12.2 02 13 Copy Cut Paste Solved.xlsx.xlsx |
12.56Кб |
| 12.2 03 24 Select Special (F5) Solved.xlsx.xlsx |
22.27Кб |
| 12.2 10. Sensitivty analysis.xlsx.xlsx |
38.81Кб |
| 12.2 11. Building a P&L - Solved.xlsx.xlsx |
53.83Кб |
| 12.2 8. Opex - After.xlsx.xlsx |
1.36Мб |
| 12.2 Index & Match - Unsolved.xlsx.xlsx |
11.29Кб |
| 12.3 03 24 Select Special (F5) Exercise & Text.xlsx.xlsx |
21.59Кб |
| 12.3 Index & Match – Solved.xlsx.xlsx |
11.70Кб |
| 12.4 05 44 Index, Match Solved.xlsx.xlsx |
12.08Кб |
| 12.4 Select Special.xlsx.xlsx |
10.56Кб |
| 12.5 Key Functions In Excel.pdf |
9.84Мб |
| 12.6 Exercise-Index-Match-Index-and-Match (1).xlsx.xlsx |
15.45Кб |
| 12.7 05 44 Index, Match Exercise & Text.xlsx.xlsx |
11.59Кб |
| 12. An introduction to the Days methodology.mp4 |
2.28Мб |
| 12. An introduction to the Days methodology.vtt |
1.81Кб |
| 12. Building the structure of the P&L sheet.mp4 |
3.91Мб |
| 12. Building the structure of the P&L sheet.vtt |
2.44Кб |
| 12. Cut, copy, & paste.mp4 |
7.57Мб |
| 12. Cut, copy, & paste.vtt |
2.30Кб |
| 12. Dynamic reporting with GETPIVOTDATA and slicers.html |
166б |
| 12. Find and select special types of cells with Select Special (F5).mp4 |
3.04Мб |
| 12. Find and select special types of cells with Select Special (F5).vtt |
1.83Кб |
| 12. Forecasting operating expenses.mp4 |
34.45Мб |
| 12. Forecasting operating expenses.vtt |
5.21Кб |
| 12. Index, Match and their combination - the perfect substitute for Vlookup.mp4 |
12.81Мб |
| 12. Index, Match and their combination - the perfect substitute for Vlookup.vtt |
8.22Кб |
| 12. Modeling the Income statement.mp4 |
12.44Мб |
| 12. Modeling the Income statement.vtt |
7.00Кб |
| 12. Performing sensitivity analysis and completing the exercise.mp4 |
34.11Мб |
| 12. Performing sensitivity analysis and completing the exercise.vtt |
4.85Кб |
| 13.1 12. Calculating DSO, DPO and DIO - Solved.xlsm.xlsm |
52.32Кб |
| 13.1 12. Formatting the P&L sheet - Solved.xlsx.xlsx |
53.56Кб |
| 13.1 9. PP&E forecasting and comparables_after.xlsx.xlsx |
1.37Мб |
| 13.1 Exercise_Index, Match, Match.xlsx.xlsx |
11.58Кб |
| 13.2 12. Calculating DSO, DPO and DIO - Unsolved.xlsm.xlsm |
49.85Кб |
| 13.2 12. Formatting the P&L - Unsolved.xlsx.xlsx |
49.36Кб |
| 13.2 9. PP&E forecasting and comparables_before.xlsx.xlsx |
1.37Мб |
| 13.2 Solution_Index, Match, Match.xlsx.xlsx |
12.21Кб |
| 13. A great Excel technique Index, Match, Match.mp4 |
11.76Мб |
| 13. A great Excel technique Index, Match, Match.vtt |
5.27Кб |
| 13. Build a complete capital budgeting model from scratch.html |
166б |
| 13. Building a fixed asset roll forward estimating Capex.mp4 |
56.59Мб |
| 13. Building a fixed asset roll forward estimating Capex.vtt |
6.23Кб |
| 13. Calculation of DSO, DPO and DOI for the historical period.mp4 |
2.69Мб |
| 13. Calculation of DSO, DPO and DOI for the historical period.vtt |
1.67Кб |
| 13. Cut, copy, & paste.html |
163б |
| 13. Formatting sets You apart from the competition in Excel - A Practical Example.mp4 |
5.71Мб |
| 13. Formatting sets You apart from the competition in Excel - A Practical Example.vtt |
3.30Кб |
| 13. Modeling the Balance sheet - Part 1.mp4 |
5.22Мб |
| 13. Modeling the Balance sheet - Part 1.vtt |
3.18Кб |
| 13. Select Special.html |
163б |
| 14.1 02 14 Paste Special Exercise & Text.xlsx.xlsx |
13.47Кб |
| 14.1 03 25 Assigning Dynamic Names Exercise & Text.xlsx.xlsx |
11.23Кб |
| 14.1 10. PP&E schedule_before.xlsx.xlsx |
1.37Мб |
| 14.1 13. Forecasting DSO, DPO and DIO - Solved.xlsm.xlsm |
53.65Кб |
| 14.1 13. Populating the P&L sheet - Solved.xlsm.xlsm |
59.02Кб |
| 14.2 02 14 Paste Special Solved.xlsx.xlsx |
13.46Кб |
| 14.2 10. PP&E schedule_after.xlsx.xlsx |
1.37Мб |
| 14.2 13. Forecasting DSO, DPO and DIO - Unsolved.xlsm.xlsm |
50.09Кб |
| 14.2 13. Populating the P&L sheet - Unsolved.xlsx.xlsx |
49.23Кб |
| 14.2 Dynamic Naming – Unsolved.xlsx.xlsx |
13.54Кб |
| 14.3 Dynamic Naming - Solved.xlsx.xlsx |
13.83Кб |
| 14.4 Useful Tips & Tools PDF Version.pdf |
9.44Мб |
| 14.5 03 25 Assigning Dynamic Names Solved.xlsx.xlsx |
11.73Кб |
| 14. Building a fixed asset roll forward D&A schedule.mp4 |
54.20Мб |
| 14. Building a fixed asset roll forward D&A schedule.vtt |
4.13Кб |
| 14. Congratulations!!.mp4 |
2.31Мб |
| 14. Congratulations!!.vtt |
1.50Кб |
| 14. Forecasting DSO, DPO and DOI.mp4 |
3.95Мб |
| 14. Forecasting DSO, DPO and DOI.vtt |
2.86Кб |
| 14. Index, Match and their combination - the perfect substitute for Vlookup.html |
163б |
| 14. Learn how to assign dynamic names within a financial model.mp4 |
2.33Мб |
| 14. Learn how to assign dynamic names within a financial model.vtt |
1.56Кб |
| 14. Modeling the Balance sheet - Part 2.mp4 |
9.38Мб |
| 14. Modeling the Balance sheet - Part 2.vtt |
5.72Кб |
| 14. Paste special.mp4 |
6.69Мб |
| 14. Paste special.vtt |
1.49Кб |
| 14. Populate the P&L sheet with Sumif.mp4 |
6.43Мб |
| 14. Populate the P&L sheet with Sumif.vtt |
3.02Кб |
| 15.1 10a. PP&E comparison.xlsx.xlsx |
1.37Мб |
| 15.1 14. Countif - Solved.xlsx.xlsx |
57.32Кб |
| 15.1 14. Forecasting PP&E, Other assets and Other liabilities - Unsolved.xlsm.xlsm |
51.05Кб |
| 15.1 Iferror.xlsx.xlsx |
9.61Кб |
| 15.2 05 45 IFERROR Solved.xlsx.xlsx |
15.37Кб |
| 15.2 14. Countif - Unsolved.xlsm.xlsm |
53.99Кб |
| 15.2 14. Forecasting PP&E, Other assets and Other liabilities - Solved.xlsm.xlsm |
51.03Кб |
| 15.3 05 45 IFERROR Exercise & Text.xlsx.xlsx |
14.26Кб |
| 15.4 Key Functions In Excel.pdf |
9.84Мб |
| 15.5 Iferror – Unsolved.xlsx.xlsx |
9.41Кб |
| 15. Assigning dynamic names.html |
163б |
| 15. Basic operations in Excel - 38 pages.html |
167б |
| 15. Building a financial model - Quiz.html |
163б |
| 15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4 |
4.73Мб |
| 15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.vtt |
2.99Кб |
| 15. Learn how to find mistakes with Countif.mp4 |
7.47Мб |
| 15. Learn how to find mistakes with Countif.vtt |
2.67Кб |
| 15. Peer comparison D&A as a percentage of revenues.mp4 |
13.61Мб |
| 15. Peer comparison D&A as a percentage of revenues.vtt |
1.59Кб |
| 15. Using Excel's Iferror function to trap spreadsheet errors.mp4 |
2.62Мб |
| 15. Using Excel's Iferror function to trap spreadsheet errors.vtt |
2.05Кб |
| 16.1 11. Working capital forecasting_after.xlsx.xlsx |
1.52Мб |
| 16.1 15. Adding % variations - Unsolved.xlsx.xlsx |
51.16Кб |
| 16.1 15. P&L structure - Solved.xlsm.xlsm |
55.38Кб |
| 16.1 Key Functions In Excel.pdf |
9.85Мб |
| 16.1 Naming ranges - Solved.xlsx.xlsx |
10.34Кб |
| 16.2 11. Working capital forecasting_before.xlsx.xlsx |
1.38Мб |
| 16.2 15. Adding % variations - Solved.xlsx.xlsx |
56.53Кб |
| 16.2 15. P&L structure – Unsolved.xlsm.xlsm |
50.34Кб |
| 16.2 Choose – Unsolved.xlsx.xlsx |
9.33Кб |
| 16.2 Naming ranges – Unsolved.xlsx.xlsx |
8.79Кб |
| 16.3 05 46 Choose Solved.xlsx.xlsx |
11.73Кб |
| 16.3 Useful Tips & Tools PDF Version.pdf |
9.43Мб |
| 16.4 03 26 Defining a Named Range Solved.xlsx.xlsx |
11.65Кб |
| 16.4 Choose - Solved.xlsx.xlsx |
9.69Кб |
| 16.5 03 26 Defining a Named Range Exercise & Text.xlsx.xlsx |
11.07Кб |
| 16.5 05 46 Choose Exercise & Text.xlsx.xlsx |
11.32Кб |
| 16. Calculating DSO, DIO, DPO.mp4 |
17.51Мб |
| 16. Calculating DSO, DIO, DPO.vtt |
2.10Кб |
| 16. Calculating year-on-year percentage variations the proper way.mp4 |
6.83Мб |
| 16. Calculating year-on-year percentage variations the proper way.vtt |
3.20Кб |
| 16. Creating an output P&L sheet.mp4 |
3.74Мб |
| 16. Creating an output P&L sheet.vtt |
2.49Кб |
| 16. Define a named range in Excel.mp4 |
2.12Мб |
| 16. Define a named range in Excel.vtt |
1.62Кб |
| 16. Learn how to render your models flexible with Choose.mp4 |
3.39Мб |
| 16. Learn how to render your models flexible with Choose.vtt |
2.64Кб |
| 17.1 12. P&L.xlsx.xlsx |
1.39Мб |
| 17.1 16. Populating the P&L sheet - Solved.xlsm.xlsm |
57.18Кб |
| 17.1 Goal Seek – Unsolved.xlsx.xlsx |
8.85Кб |
| 17.1 Useful Tips & Tools PDF Version.pdf |
9.43Мб |
| 17.2 03 27 Assigning Custom Formats Solved.xlsx.xlsx |
11.08Кб |
| 17.2 16. Populating the P&L sheet – Unsolved.xlsm.xlsm |
52.73Кб |
| 17.2 Key Functions In Excel.pdf |
9.84Мб |
| 17.3 03 27 Assigning Custom Formats Exercise & Text.xlsx.xlsx |
11.35Кб |
| 17.3 Goal Seek - Solved.xlsx.xlsx |
8.86Кб |
| 17.4 05 47 Goal Seek Exercise & Text.xlsx.xlsx |
16.09Кб |
| 17.5 05 47 Goal Seek Solved.xlsx.xlsx |
16.21Кб |
| 17. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4 |
2.14Мб |
| 17. Assign custom formats to specific cells within a financial model (e.g Multiples).vtt |
1.87Кб |
| 17. Create professional and good-looking charts - Introduction.mp4 |
1.19Мб |
| 17. Create professional and good-looking charts - Introduction.vtt |
461б |
| 17. Populating the output P&L sheet.mp4 |
5.36Мб |
| 17. Populating the output P&L sheet.vtt |
2.63Кб |
| 17. Producing a clean P&L output sheet.mp4 |
8.43Мб |
| 17. Producing a clean P&L output sheet.vtt |
1.63Кб |
| 17. Use Goal Seek to find the result that you are looking for.mp4 |
3.02Мб |
| 17. Use Goal Seek to find the result that you are looking for.vtt |
2.56Кб |
| 18.1 03 28 Macros Solved.xlsx.xlsx |
145.02Кб |
| 18.1 12a. P&L fill in_before.xlsx.xlsx |
1.39Мб |
| 18.1 17. Populating the Balance sheet – Unsolved.xlsm.xlsm |
54.82Кб |
| 18.1 Column Stacked Chart - Solved.xlsm.xlsm |
11.52Мб |
| 18.2 03 28 Macros Exercise & Text.xlsx.xlsx |
10.34Кб |
| 18.2 12a. P&L fill in_after.xlsx.xlsx |
1.39Мб |
| 18.2 17. Populating the BS sheet - Solved.xlsm.xlsm |
58.78Кб |
| 18.2 Case Study Building A P&L From Scratch Complete.xlsx |
12.16Мб |
| 18.3 Column Stacked Chart - Unsolved.xlsm.xlsm |
11.52Мб |
| 18.3 Creating a Macro - Unsolved.xlsx.xlsx |
9.66Кб |
| 18.4 Creating a Macro - Solved.xlsx.xlsx |
11.17Кб |
| 18.5 Useful Tips & Tools PDF Version.pdf |
9.43Мб |
| 18. Build a Column Stacked chart with a secondary line axis in Excel.mp4 |
11.30Мб |
| 18. Build a Column Stacked chart with a secondary line axis in Excel.vtt |
6.76Кб |
| 18. Fill in the P&L output sheet.mp4 |
18.34Мб |
| 18. Fill in the P&L output sheet.vtt |
1.74Кб |
| 18. Macros are a great timesaver! Here's why!.mp4 |
4.33Мб |
| 18. Macros are a great timesaver! Here's why!.vtt |
3.34Кб |
| 18. Populating the output BS sheet.mp4 |
3.39Мб |
| 18. Populating the output BS sheet.vtt |
2.10Кб |
| 18. Use Goal Seek in order to find the result that you are looking for.html |
163б |
| 19.1 13. Calculating working capital_before.xlsx.xlsx |
1.40Мб |
| 19.1 18. Completing the BS items - Solved.xlsm.xlsm |
60.02Кб |
| 19.1 Data Tables – Unsolved.xlsx.xlsx |
9.25Кб |
| 19.1 Doughnut Chart - Unsolved.xlsm.xlsm |
11.52Мб |
| 19.2 13. Calculating working capital_after.xlsx.xlsx |
1.40Мб |
| 19.2 18. Completing the BS items – Unsolved.xlsm.xlsm |
55.70Кб |
| 19.2 Doughnut Chart - Solved.xlsm.xlsm |
11.52Мб |
| 19.2 Key Functions In Excel.pdf |
9.84Мб |
| 19.3 05 48 Sensitivity Analysis Solved.xlsx.xlsx |
13.05Кб |
| 19.4 Data Tables - Solved.xlsx.xlsx |
9.46Кб |
| 19.5 05 48 Sensitivity Analysis Exercise & Text.xlsx.xlsx |
12.59Кб |
| 19. Calculating investments in working capital.mp4 |
19.03Мб |
| 19. Calculating investments in working capital.vtt |
2.11Кб |
| 19. Completing the output BS sheet for the historical period.mp4 |
7.53Мб |
| 19. Completing the output BS sheet for the historical period.vtt |
4.42Кб |
| 19. Excel Macros - quiz.html |
163б |
| 19. Include sensitivity analysis in your models through Data Tables.mp4 |
5.43Мб |
| 19. Include sensitivity analysis in your models through Data Tables.vtt |
4.65Кб |
| 19. Learn how to build effective Doughnut charts in Excel.mp4 |
7.48Мб |
| 19. Learn how to build effective Doughnut charts in Excel.vtt |
4.74Кб |
| 2.1 02 6 Overview of Excel Exercise & Text.xlsx.xlsx |
10.47Кб |
| 2.1 0aa. Inputs_after.xlsx.xlsx |
1.28Мб |
| 2.1 1. Drivers.xlsx.xlsx |
11.50Кб |
| 2.1 1. Exercise - Build an FMCG Model_Mapping.xlsx.xlsx |
14.90Мб |
| 2.1 2. Creating a Pivot Table.xlsx.xlsx |
1.43Мб |
| 2.1 Exercise Sumifs With Solutions.xlsx |
1.29Мб |
| 2.1 Formatting a worksheet – Unsolved.xlsx.xlsx |
8.98Кб |
| 2.1 Solution-IRR.xlsx.xlsx |
12.31Кб |
| 2.2 02 6 Overview of Excel Solved.xlsx.xlsx |
10.88Кб |
| 2.2 05 14 IRR.xlsx.xlsx |
11.20Кб |
| 2.2 0aa. Inputs_before.xlsx.xlsx |
1.28Мб |
| 2.2 Useful Tips & Tools PDF Version.pdf |
9.43Мб |
| 2.3 03 17 Formatting a Worksheet Exercise & Text.xlsx.xlsx |
10.63Кб |
| 2.3 Exercise-IRR.xlsx.xlsx |
11.52Кб |
| 2.4 Formatting a worksheet - Solved.xlsx.xlsx |
9.56Кб |
| 2.5 03 17 Formatting a Worksheet Solved.xlsx.xlsx |
10.76Кб |
| 2. Bonus! Welcome gift.html |
167б |
| 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.vtt |
3.25Кб |
| 2. Creating Pivot Tables easily!.mp4 |
19.37Мб |
| 2. Creating Pivot Tables easily!.vtt |
4.01Кб |
| 2. Exercise - Excel's Sumifs function - solved & explained.mp4 |
12.68Мб |
| 2. Exercise - Excel's Sumifs function - solved & explained.vtt |
10.03Кб |
| 2. Initial formatting of an Excel sheet to render it professional.mp4 |
3.35Мб |
| 2. Initial formatting of an Excel sheet to render it professional.vtt |
2.16Кб |
| 2. Introduction to the case study.mp4 |
2.42Мб |
| 2. Introduction to the case study.vtt |
1019б |
| 2. Introduction to the DCF exercise.mp4 |
4.50Мб |
| 2. Introduction to the DCF exercise.vtt |
1.29Кб |
| 2. Keyboard shortcuts in Excel.html |
167б |
| 2. Key functions in Excel If.html |
167б |
| 2. Organizing an Inputs sheet.mp4 |
11.05Мб |
| 2. Organizing an Inputs sheet.vtt |
6.04Кб |
| 2. Overview of Excel.mp4 |
13.96Мб |
| 2. Overview of Excel.vtt |
3.87Кб |
| 2. Preliminary mapping of the data extraction.mp4 |
22.60Мб |
| 2. Preliminary mapping of the data extraction.vtt |
2.43Кб |
| 2. The input data we will work with.mp4 |
15.81Мб |
| 2. The input data we will work with.vtt |
1.64Кб |
| 2. What is a financial model.mp4 |
4.60Мб |
| 2. What is a financial model.vtt |
2.35Кб |
| 2. Why we need Capital budgeting.mp4 |
6.88Мб |
| 2. Why we need Capital budgeting.vtt |
2.70Кб |
| 20.1 03 29 Drop-down List Exercise & Text.xlsx.xlsx |
11.34Кб |
| 20.1 14. Cash flow - UFCF_before.xlsx.xlsx |
1.41Мб |
| 20.1 19. Building a Cash Flow Format – Solved.xlsm.xlsm |
57.27Кб |
| 20.1 Area Chart - Solved.xlsm.xlsm |
11.52Мб |
| 20.2 03 29 Drop-down List Solved.xlsx.xlsx |
77.02Кб |
| 20.2 14. Cash flow - UFCF_after.xlsx.xlsx |
1.41Мб |
| 20.2 19. Building a Cash Flow Format – Unsolved.xlsm.xlsm |
56.20Кб |
| 20.2 Area Chart - Unsolved.xlsm.xlsm |
11.51Мб |
| 20.3 Data Validation - Solved.xlsx.xlsx |
10.84Кб |
| 20.4 Data Validation – Unsolved.xlsx.xlsx |
10.84Кб |
| 20.5 Useful Tips & Tools PDF Version.pdf |
9.43Мб |
| 20. Create a drop-down list by using Data Validation.mp4 |
3.30Мб |
| 20. Create a drop-down list by using Data Validation.vtt |
2.10Кб |
| 20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp4 |
4.07Мб |
| 20. Creating a structure for the calculation of Unlevered Free Cash Flows.vtt |
3.35Кб |
| 20. Forecasting Unlevered Free Cash Flow.mp4 |
55.93Мб |
| 20. Forecasting Unlevered Free Cash Flow.vtt |
6.04Кб |
| 20. Include sensitivity analysis in your models through Data Tables.html |
163б |
| 20. Learn how to build an Area chart in Excel.mp4 |
8.02Мб |
| 20. Learn how to build an Area chart in Excel.vtt |
4.64Кб |
| 21.1 03 30 Custom Sort Solved.xlsx.xlsx |
11.46Кб |
| 21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx |
1.41Мб |
| 21.1 20. From UFCF to Net Cash Flow – Solved.xlsm.xlsm |
60.38Кб |
| 21.1 Bridge Chart - Solved.xlsm.xlsm |
11.51Мб |
| 21.1 Key Functions In Excel.pdf |
9.84Мб |
| 21.2 05 49 Pivot Tables Intro Exercise & Text.xlsx.xlsx |
152.17Кб |
| 21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx |
1.41Мб |
| 21.2 20. From UFCF to Net Cash Flow - Unsolved.xlsm.xlsm |
56.83Кб |
| 21.2 Case Study Building A P&L From Scratch Complete.xlsx |
12.17Мб |
| 21.2 Sort data - Solved.xlsx.xlsx |
145.65Кб |
| 21.3 03 30 Custom Sort Exercise & Text.xlsx.xlsx |
11.37Кб |
| 21.3 Bridge Chart – Unsolved.xlsm.xlsm |
11.52Мб |
| 21.3 Excel Functions.xlsx |
971.02Кб |
| 21.4 05 49 Pivot Tables Intro Solved.xlsx.xlsx |
190.07Кб |
| 21.4 Useful Tips & Tools PDF Version.pdf |
9.43Мб |
| 21.5 Excel functions.xlsx.xlsx |
887.32Кб |
| 21.5 Sort data – Unsolved.xlsx.xlsx |
145.35Кб |
| 21. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 |
2.73Мб |
| 21. Bridging Unlevered Free Cash Flow to Net Cash Flow.vtt |
2.12Кб |
| 21. Excel's dynamic and interactive tables Pivot tables.mp4 |
5.32Мб |
| 21. Excel's dynamic and interactive tables Pivot tables.vtt |
2.58Кб |
| 21. Forecasting other assets.mp4 |
45.24Мб |
| 21. Forecasting other assets.vtt |
4.55Кб |
| 21. Learn how to create Bridge charts.mp4 |
18.77Мб |
| 21. Learn how to create Bridge charts.vtt |
12.38Кб |
| 21. Using Custom-sort in order to sort multiple columns within a table.mp4 |
2.79Мб |
| 21. Using Custom-sort in order to sort multiple columns within a table.vtt |
1.59Кб |
| 22.1 16. Balance Sheet forecasting liabilities_before.xlsx.xlsx |
1.41Мб |
| 22.1 21. Calculating UFCF - Unsolved.xlsm.xlsm |
59.52Кб |
| 22.1 Useful Tips & Tools PDF Version.pdf |
9.43Мб |
| 22.2 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx |
1.42Мб |
| 22.2 21. Calculating UFCF - Solved.xlsm.xlsm |
57.96Кб |
| 22.2 Useful Tips And Tools Excel File.xlsx |
2.25Мб |
| 22.3 03 31 Hyperlinks Exercise & Text.xlsx.xlsx |
136.89Кб |
| 22.4 03 31 Hyperlinks Solved.xlsx.xlsx |
137.06Кб |
| 22. Calculating Unlevered Free Cash Flow.mp4 |
10.79Мб |
| 22. Calculating Unlevered Free Cash Flow.vtt |
6.77Кб |
| 22. Case Study - Building a Complete P&L from scratch in Excel.html |
162б |
| 22. Create a great Index page at the beginning of your models - Hyperlinks.mp4 |
1.90Мб |
| 22. Create a great Index page at the beginning of your models - Hyperlinks.vtt |
1.51Кб |
| 22. Excel's key functions and functionalities made easy.html |
162б |
| 22. Forecasting other liabilities.mp4 |
21.97Мб |
| 22. Forecasting other liabilities.vtt |
2.37Кб |
| 23.1 1. SOULUTIONS - Course Challenge.xlsx.xlsx |
543.93Кб |
| 23.1 16a. Complete UFCF_after.xlsx.xlsx |
1.42Мб |
| 23.1 Cash Flow Classification By Activities.xlsx |
55.95Кб |
| 23.1 Freeze Panes - Solved.xlsx.xlsx |
643.94Кб |
| 23.2 1. Course Challenge.xlsx.xlsx |
505.49Кб |
| 23.2 16a. Complete UFCF_before.xlsx.xlsx |
1.42Мб |
| 23.2 22. From UFCF to Net Cash Flow - Unsolved.xlsm.xlsm |
57.89Кб |
| 23.2 Freeze Panes – Unsolved.xlsx.xlsx |
643.87Кб |
| 23.3 22. From UFCF to Net Cash Flow - Solved.xlsm.xlsm |
61.31Кб |
| 23.3 Useful Tips & Tools PDF Version.pdf |
9.44Мб |
| 23. Calculating Net Cash Flow.mp4 |
7.10Мб |
| 23. Calculating Net Cash Flow.vtt |
4.52Кб |
| 23. Completing Unlevered Free Cash Flow.mp4 |
40.88Мб |
| 23. Completing Unlevered Free Cash Flow.vtt |
3.52Кб |
| 23. Course Challenge - Apply your skills in practice!.mp4 |
7.92Мб |
| 23. Course Challenge - Apply your skills in practice!.vtt |
1.18Кб |
| 23. Fix the top row of your table with Freeze Panes.mp4 |
5.20Мб |
| 23. Fix the top row of your table with Freeze Panes.vtt |
1.42Кб |
| 24.1 17. Financing_after.xlsx.xlsx |
1.43Мб |
| 24.1 23. Use Find and Replace - Unsolved.xlsm.xlsm |
61.31Кб |
| 24.1 Exercise_Filter by Color.xlsx.xlsx |
20.47Кб |
| 24.2 17. Financing_before.xlsx.xlsx |
1.43Мб |
| 24.2 23. Use Find and Replace - Solved.xlsm.xlsm |
64.44Кб |
| 24.2 Solution_Filter by Color.xlsx.xlsx |
153.48Кб |
| 24. Filter by color - an excellent tool.mp4 |
9.87Мб |
| 24. Filter by color - an excellent tool.vtt |
2.02Кб |
| 24. Modeling Tesla's financing needs in the forecast period.mp4 |
42.36Мб |
| 24. Modeling Tesla's financing needs in the forecast period.vtt |
5.47Кб |
| 24. Obtaining the rest of the cash flows through Find and Replace.mp4 |
9.74Мб |
| 24. Obtaining the rest of the cash flows through Find and Replace.vtt |
4.25Кб |
| 25.1 18. P&L complete_before.xlsx.xlsx |
1.43Мб |
| 25.1 24. Introducing WACC and g - Unsolved.xlsm.xlsm |
60.94Кб |
| 25.1 Exercise_Conditional Formatting.xlsx.xlsx |
12.88Кб |
| 25.2 18. P&L complete_after.xlsx.xlsx |
1.43Мб |
| 25.2 24. Introducing WACC and g - Solved.xlsm.xlsm |
61.04Кб |
| 25.2 Solution_Conditional Formatting.xlsx.xlsx |
51.52Кб |
| 25. Calculating Net income.mp4 |
14.80Мб |
| 25. Calculating Net income.vtt |
1.39Кб |
| 25. Introducing Weighted Average Cost of Capital and Perpetuity Growth.mp4 |
2.71Мб |
| 25. Introducing Weighted Average Cost of Capital and Perpetuity Growth.vtt |
2.19Кб |
| 25. Working with conditional formatting.mp4 |
15.09Мб |
| 25. Working with conditional formatting.vtt |
5.60Кб |
| 26.1 19. Cash flow_complete_before.xlsx.xlsx |
1.43Мб |
| 26.1 25. Calculating PV of Cash Flows - Unsolved.xlsm.xlsm |
58.23Кб |
| 26.2 19. Cash flow_complete_after.xlsx.xlsx |
1.43Мб |
| 26.2 25. Calculating PV of Cash Flows - Solved.xlsm.xlsm |
62.00Кб |
| 26. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 |
50.73Мб |
| 26. Bridging Unlevered Free Cash Flow to Net Cash Flow.vtt |
4.38Кб |
| 26. Discounting Unlevered Free Cash Flows to obtain their Present Value.mp4 |
3.97Мб |
| 26. Discounting Unlevered Free Cash Flows to obtain their Present Value.vtt |
3.04Кб |
| 26. Useful tips and tools for your work in Excel - quiz.html |
162б |
| 27.1 20. Complete the BS_before.xlsx.xlsx |
1.43Мб |
| 27.1 26. Calculating CV of the business - Solved.xlsm.xlsm |
62.33Кб |
| 27.2 20. Complete the BS_after.xlsx.xlsx |
1.43Мб |
| 27.2 26. Calculating CV of the business - Unsolved.xlsm.xlsm |
62.00Кб |
| 27. Balancing the Balance sheet.mp4 |
13.27Мб |
| 27. Balancing the Balance sheet.vtt |
1.16Кб |
| 27. Calculating Continuing Value and Enterprise Value of the business.mp4 |
3.45Мб |
| 27. Calculating Continuing Value and Enterprise Value of the business.vtt |
2.43Кб |
| 28.1 21. WACC_after.xlsx.xlsx |
1.43Мб |
| 28.1 27. Calculating Equity Value - Unsolved.xlsm.xlsm |
62.33Кб |
| 28.2 21. WACC_before.xlsx.xlsx |
1.43Мб |
| 28.2 27. Calculating Equity Value - Solved.xlsm.xlsm |
62.56Кб |
| 28. Calculating Equity Value.mp4 |
2.48Мб |
| 28. Calculating Equity Value.vtt |
1.62Кб |
| 28. Estimating Weighted Average Cost of Capital (WACC).mp4 |
44.27Мб |
| 28. Estimating Weighted Average Cost of Capital (WACC).vtt |
6.79Кб |
| 29.1 22. DCF_before.xlsx.xlsx |
1.52Мб |
| 29.1 28. Sensitivity analysis - Solved.xlsm.xlsm |
63.87Кб |
| 29.2 22. DCF_after.xlsx.xlsx |
1.44Мб |
| 29.2 Sensitivity Analysis.xlsx |
60.81Кб |
| 29.3 28. Sensitivity analysis - Unsolved.xlsm.xlsm |
62.56Кб |
| 29. Performing Discounted Cash Flow valuation (DCF).mp4 |
34.90Мб |
| 29. Performing Discounted Cash Flow valuation (DCF).vtt |
3.93Кб |
| 29. Sensitivity analysis for WACC and perpetuity growth.mp4 |
8.61Мб |
| 29. Sensitivity analysis for WACC and perpetuity growth.vtt |
4.52Кб |
| 3.1 1. Deliveries_before.xlsx.xlsx |
1.29Мб |
| 3.1 2. Fast Scrolling - Solved.xlsx.xlsx |
642.51Кб |
| 3.1 2. Savings Forecast_unsolved.xlsx.xlsx |
14.74Кб |
| 3.1 3. Formatting a Pivot Table.xlsx.xlsx |
1.43Мб |
| 3.1 Solution-Loan-Schedule.xlsx.xlsx |
22.68Кб |
| 3.1 Sum, Sumif, Sumifs - Unsolved.xlsx.xlsx |
12.93Кб |
| 3.1 Valuation exercise.pdf.pdf |
411.76Кб |
| 3.2 05 15 PMT.xlsx.xlsx |
20.17Кб |
| 3.2 1. Deliveries_after.xlsx.xlsx |
1.29Мб |
| 3.2 2. Savings Forecast.xlsx.xlsx |
16.58Кб |
| 3.2 Key Functions In Excel.pdf |
9.84Мб |
| 3.2 Useful tips and tools - Excel file.xlsx.xlsx |
2.24Мб |
| 3.3 03 18 Fast Scrolling Exercise & Text.xlsx.xlsx |
43.90Кб |
| 3.3 05 37 Sum, Sumif, Sumifs Exercise & Text.xlsx.xlsx |
14.46Кб |
| 3.3 Exercise-Loan-Schedule.xlsx.xlsx |
15.81Кб |
| 3.4 Sum, Sumif, Sumifs – Solved.xlsx.xlsx |
13.01Кб |
| 3.4 Useful Tips & Tools PDF Version.pdf |
9.44Мб |
| 3.5 03 18 Fast Scrolling Solved.xlsx.xlsx |
44.35Кб |
| 3.5 05 37 Sum, Sumif, Sumifs Solved.xlsx.xlsx |
14.84Кб |
| 3. Calculating a complete loan schedule in Excel.mp4 |
14.82Мб |
| 3. Calculating a complete loan schedule in Excel.vtt |
5.85Кб |
| 3. Fast scrolling through Excel sheets.mp4 |
6.26Мб |
| 3. Fast scrolling through Excel sheets.vtt |
1.73Кб |
| 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.vtt |
3.95Кб |
| 3. Forecasting Tesla's expected deliveries.mp4 |
114.91Мб |
| 3. Forecasting Tesla's expected deliveries.vtt |
14.53Кб |
| 3. Give your Excel Pivot Tables a makeover.mp4 |
11.27Мб |
| 3. Give your Excel Pivot Tables a makeover.vtt |
2.22Кб |
| 3. Key Excel functions Sum, Sumif and Sumifs.mp4 |
6.73Мб |
| 3. Key Excel functions Sum, Sumif and Sumifs.vtt |
4.92Кб |
| 3. Overview of Excel.html |
163б |
| 3. The time value of money.mp4 |
6.69Мб |
| 3. The time value of money.vtt |
2.61Кб |
| 3. The various stages of a complete DCF Valuation.mp4 |
8.58Мб |
| 3. The various stages of a complete DCF Valuation.vtt |
7.65Кб |
| 3. Understand your data source before you start working on it.mp4 |
6.78Мб |
| 3. Understand your data source before you start working on it.vtt |
2.96Кб |
| 3. Welcome gift number 2.html |
167б |
| 3. Why use financial models.mp4 |
7.69Мб |
| 3. Why use financial models.vtt |
3.11Кб |
| 3. Working with an SAP data extraction.mp4 |
21.96Мб |
| 3. Working with an SAP data extraction.vtt |
3.84Кб |
| 30.1 23. EV, Equity value, Price per share_after.xlsx.xlsx |
1.44Мб |
| 30.1 29. Goal Seek - Unsolved.xlsm.xlsm |
63.87Кб |
| 30.2 23. EV, Equity value, Price per share_before.xlsx.xlsx |
1.44Мб |
| 30.2 29. Goal seek - Solved.xlsm.xlsm |
63.89Кб |
| 30. A possible application of Goal Seek.mp4 |
3.20Мб |
| 30. A possible application of Goal Seek.vtt |
1.86Кб |
| 30. Calculating enterprise value, equity value, and price per share.mp4 |
22.56Мб |
| 30. Calculating enterprise value, equity value, and price per share.vtt |
2.11Кб |
| 31.1 30. Charts – Unsolved.xlsm.xlsm |
63.89Кб |
| 31.2 30. Charts - Solved.xlsm.xlsm |
97.09Кб |
| 31. Final comments.mp4 |
44.88Мб |
| 31. Final comments.vtt |
4.29Кб |
| 31. Using charts to summarize the results of the DCF model.mp4 |
8.24Мб |
| 31. Using charts to summarize the results of the DCF model.vtt |
5.56Кб |
| 32. You Made It!.mp4 |
7.60Мб |
| 32. You Made It!.vtt |
2.63Кб |
| 4.1 02 7 Basic Manipulations Exercise Text.xlsx.xlsx |
11.40Кб |
| 4.1 05-38-Counts-Solved.xlsx.xlsx |
16.11Кб |
| 4.1 1a. Deliveries development.xlsx.xlsx |
1.30Мб |
| 4.1 2. Exercise - Build an FMCG Model_Structure.xlsx.xlsx |
14.92Мб |
| 4.1 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx |
18.54Кб |
| 4.1 4. Order a worksheet - Unsolved.xlsx.xlsx |
28.64Кб |
| 4.1 4. Working with Pivot Tables.xlsx.xlsx |
1.88Мб |
| 4.1 DCF Model structure.pdf.pdf |
240.80Кб |
| 4.1 Exercise-Date-Functions.xlsx.xlsx |
11.41Кб |
| 4.2 02 7 Basic Manipulations Solved.xlsx.xlsx |
32.87Кб |
| 4.2 3. Beginning of exercise.xlsm.xlsm |
48.83Кб |
| 4.2 3. Fixed Asset Rollforward.xlsx.xlsx |
19.66Кб |
| 4.2 4. Order a worksheet - Solved.xlsm.xlsm |
36.58Кб |
| 4.2 Count, Countif, Countifs – Unsolved.xlsx.xlsx |
11.29Кб |
| 4.2 Solution-Date-Functions (2).xlsx.xlsx |
12.43Кб |
| 4.3 05 38 Counts Exercise & Text.xlsx.xlsx |
15.26Кб |
| 4.3 Exercise-Date-Functions.xlsx.xlsx |
11.41Кб |
| 4.4 05 16 Date Functions.xlsx.xlsx |
12.25Кб |
| 4.4 Count, Countif, Countifs - Solved.xlsx.xlsx |
11.68Кб |
| 4.5 Key Functions In Excel.pdf |
9.84Мб |
| 4. Basic manipulations with rows and columns.mp4 |
6.90Мб |
| 4. Basic manipulations with rows and columns.vtt |
1.96Кб |
| 4. Calculating future and present Value.mp4 |
13.09Мб |
| 4. Calculating future and present Value.vtt |
6.06Кб |
| 4. Comparing delivery figures with the ones of industry peers.mp4 |
20.93Мб |
| 4. Comparing delivery figures with the ones of industry peers.vtt |
3.00Кб |
| 4. Creating an output structure of the FMCG model.mp4 |
11.66Мб |
| 4. Creating an output structure of the FMCG model.vtt |
2.80Кб |
| 4. Date functions in Excel.mp4 |
11.36Мб |
| 4. Date functions in Excel.vtt |
5.27Кб |
| 4. Description of the structure of the DCF model.mp4 |
4.48Мб |
| 4. Description of the structure of the DCF model.vtt |
3.45Кб |
| 4. Fast scrolling through Excel sheets.html |
163б |
| 4. Financial modeling - worst practices - things you should avoid.mp4 |
19.91Мб |
| 4. Financial modeling - worst practices - things you should avoid.vtt |
6.86Кб |
| 4. Fixed asset rollforward.mp4 |
12.16Мб |
| 4. Fixed asset rollforward.vtt |
5.04Кб |
| 4. Key Excel functions Count, Counta, Countif, Countifs.mp4 |
6.00Мб |
| 4. Key Excel functions Count, Counta, Countif, Countifs.vtt |
4.48Кб |
| 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.vtt |
4.39Кб |
| 4. Order the source worksheets.mp4 |
5.68Мб |
| 4. Order the source worksheets.vtt |
2.37Кб |
| 4. The approach to take this course.mp4 |
7.83Мб |
| 4. The approach to take this course.vtt |
2.37Кб |
| 5.1 2. Average price_after.xlsx.xlsx |
1.31Мб |
| 5.1 2. Exercise - Build an FMCG Model_Layout.xlsx.xlsx |
14.91Мб |
| 5.1 4. Working Capital_unsolved.xlsx.xlsx |
21.19Кб |
| 5.1 5. Creating a code - Unsolved.xlsm.xlsm |
32.76Кб |
| 5.1 5. GetPivotData.xlsx.xlsx |
1.88Мб |
| 5.1 Average, Averageif - Solved.xlsx.xlsx |
9.40Кб |
| 5.1 Beginning Of Exercise.xlsx |
42.43Кб |
| 5.1 Useful Tips & Tools PDF Version.pdf |
9.43Мб |
| 5.2 05 39 Average, AverageIF Exercise & Text.xlsx.xlsx |
14.60Кб |
| 5.2 2. Average price_before.xlsx.xlsx |
1.31Мб |
| 5.2 4. Working Capital_unsolved.xlsx.xlsx |
21.19Кб |
| 5.2 5. Creating a code - Solved.xlsx.xlsx |
33.84Кб |
| 5.2 Fixing references - Solved.xlsx.xlsx |
645.17Кб |
| 5.3 Average, Averageif – Unsolved.xlsx.xlsx |
9.03Кб |
| 5.3 Fixing references – Unsolved.xlsx.xlsx |
643.98Кб |
| 5.4 03 19 Fixing Cells Solved.xlsx.xlsx |
10.82Кб |
| 5.4 05 39 Average, AverageIF Solution.xlsx.xlsx |
15.02Кб |
| 5.5 03 19 Fixing Cells Exercise & Text.xlsx.xlsx |
10.67Кб |
| 5. A glimpse at the company we are valuing - Cheeseco.mp4 |
1.74Мб |
| 5. A glimpse at the company we are valuing - Cheeseco.vtt |
1.43Кб |
| 5. Calculating cost of equity.mp4 |
19.20Мб |
| 5. Calculating cost of equity.vtt |
7.52Кб |
| 5. Create a code the best way to organize your data and work efficiently with it.mp4 |
5.99Мб |
| 5. Create a code the best way to organize your data and work efficiently with it.vtt |
2.19Кб |
| 5. Download all course materials.html |
758б |
| 5. Estimating an average selling price of Tesla vehicles.mp4 |
41.92Мб |
| 5. Estimating an average selling price of Tesla vehicles.vtt |
5.04Кб |
| 5. Financial modeling - best practices.mp4 |
17.22Мб |
| 5. Financial modeling - best practices.vtt |
5.69Кб |
| 5. Improving the layout and appearance of the FMCG report.mp4 |
13.51Мб |
| 5. Improving the layout and appearance of the FMCG report.vtt |
4.63Кб |
| 5. Introduction to fixing of cell references.mp4 |
6.13Мб |
| 5. Introduction to fixing of cell references.vtt |
2.53Кб |
| 5. Key Excel functions Average and Averageif.mp4 |
2.77Мб |
| 5. Key Excel functions Average and Averageif.vtt |
2.24Кб |
| 5. Learn more about GetPivotData - A very important Excel function.mp4 |
18.06Мб |
| 5. Learn more about GetPivotData - A very important Excel function.vtt |
3.77Кб |
| 5. Rows and columns.html |
163б |
| 5. The impact of working capital.mp4 |
5.36Мб |
| 5. The impact of working capital.vtt |
2.94Кб |
| 6.1 02 8 The Ribbon Solved.xlsx.xlsx |
403.25Кб |
| 6.1 3. Revenue calculation and scenarios - after.xlsx.xlsx |
1.31Мб |
| 6.1 4. Exercise - Build an FMCG Model_Adding Calculations.xlsx.xlsx |
14.92Мб |
| 6.1 5. Financing.xlsx.xlsx |
30.97Кб |
| 6.1 5. Modeling revenues - Solved.xlsm.xlsm |
49.28Кб |
| 6.1 6. Creating a database - Solved.xlsx.xlsx |
35.40Кб |
| 6.1 6. Slicers.xlsx.xlsx |
1.88Мб |
| 6.2 02 8 The Ribbon Exercise & Text.xlsx.xlsx |
12.09Кб |
| 6.2 3. Revenue calculation and scenarios - before.xlsx.xlsx |
1.31Мб |
| 6.2 5. Financing_unsolved.xlsx.xlsx |
29.99Кб |
| 6.2 5. Modeling revenues - Unsolved.xlsm.xlsm |
48.62Кб |
| 6.2 6. Creating a database - Unsolved.xlsx.xlsx |
30.66Кб |
| 6.2 Database - Pivot & Slicers.xlsm.xlsm |
851.23Кб |
| 6. An introduction to slicers - The modern-day Pivot Table filters.mp4 |
22.16Мб |
| 6. An introduction to slicers - The modern-day Pivot Table filters.vtt |
4.42Кб |
| 6. Calculating automotive revenue.mp4 |
46.57Мб |
| 6. Calculating automotive revenue.vtt |
4.82Кб |
| 6. Coming up with project-specific beta.mp4 |
9.01Мб |
| 6. Coming up with project-specific beta.vtt |
3.47Кб |
| 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.vtt |
5.49Кб |
| 6. Inserting formulas and automating calculations.mp4 |
8.83Мб |
| 6. Inserting formulas and automating calculations.vtt |
4.63Кб |
| 6. Introduction to fixing of cell references.html |
163б |
| 6. Key Excel functions Average and Averageif.html |
163б |
| 6. Learn how to create a database.mp4 |
5.45Мб |
| 6. Learn how to create a database.vtt |
2.22Кб |
| 6. Modeling debt financing.mp4 |
6.18Мб |
| 6. Modeling debt financing.vtt |
3.24Кб |
| 6. Modeling the top line.mp4 |
5.14Мб |
| 6. Modeling the top line.vtt |
4.13Кб |
| 6. The Excel ribbon.mp4 |
8.80Мб |
| 6. The Excel ribbon.vtt |
2.99Кб |
| 7.1 02 9 Data Entry Exercise Text.xlsx.xlsx |
10.97Кб |
| 7.1 4. Gross profit automotive.xlsx.xlsx |
1.32Мб |
| 7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table.xlsx.xlsx |
20.82Мб |
| 7.1 6. Choose - Solved.xlsm.xlsm |
49.52Кб |
| 7.1 6. P&L_unsolved.xlsx.xlsx |
29.70Кб |
| 7.1 7. Vlookup - Solved.xlsx.xlsx |
41.26Кб |
| 7.1 Alt + Enter – Unsolved.xlsx.xlsx |
9.64Кб |
| 7.1 Key Functions In Excel.pdf |
9.84Мб |
| 7.2 02 9 Data Entry Solved.xlsx.xlsx |
32.76Кб |
| 7.2 6. Choose – Unsolved.xlsm.xlsm |
46.44Кб |
| 7.2 6. P&L.xlsx.xlsx |
31.03Кб |
| 7.2 7 Vlookup.xlsx |
40.74Кб |
| 7.2 Text Functions - Solved.xlsx.xlsx |
11.10Кб |
| 7.2 Useful Tips & Tools PDF Version.pdf |
9.43Мб |
| 7.3 7. Vlookup - Unsolved.xlsx.xlsx |
32.48Кб |
| 7.3 Alt + Enter - Solved.xlsx.xlsx |
9.65Кб |
| 7.3 Text Functions - Unsolved.xlsx.xlsx |
10.60Кб |
| 7.4 03 20 Alt+Enter Exercise & Text.xlsx.xlsx |
11.12Кб |
| 7.4 05 40 2 Left, Right etc Exercise & Text.xlsx.xlsx |
11.71Кб |
| 7.5 03 20 Alt+Enter Solved.xlsx.xlsx |
11.40Кб |
| 7.5 05 40 2 Left, Right etc Solved.xlsx.xlsx |
12.24Кб |
| 7. Adding a P&L sheet.mp4 |
4.88Мб |
| 7. Adding a P&L sheet.vtt |
2.06Кб |
| 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.vtt |
2.10Кб |
| 7. Data entry in Excel.mp4 |
10.39Мб |
| 7. Data entry in Excel.vtt |
3.32Кб |
| 7. Elaborate text efficiently Left, Right, Mid, Upper, Lower,Proper, Concatenate.mp4 |
6.31Мб |
| 7. Elaborate text efficiently Left, Right, Mid, Upper, Lower,Proper, Concatenate.vtt |
5.30Кб |
| 7. Financial modeling - Quiz.html |
163б |
| 7. Introducing scenarios to the model with Choose.mp4 |
3.20Мб |
| 7. Introducing scenarios to the model with Choose.vtt |
2.64Кб |
| 7. Peer comparison Gross profit %.mp4 |
17.17Мб |
| 7. Peer comparison Gross profit %.vtt |
2.73Кб |
| 7. Use Vlookup to fill the Database sheet.mp4 |
14.65Мб |
| 7. Use Vlookup to fill the Database sheet.vtt |
5.53Кб |
| 7. Using the 'Alt + Enter' combination.mp4 |
1.46Мб |
| 7. Using the 'Alt + Enter' combination.vtt |
1008б |
| 7. Weighted Average Cost of Capital (WACC).mp4 |
5.51Мб |
| 7. Weighted Average Cost of Capital (WACC).vtt |
2.40Кб |
| 8.1 4a. Gross profit automotive - after.xlsx.xlsx |
1.32Мб |
| 8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA.xlsx.xlsx |
20.81Мб |
| 8.1 7. Cash flow_unsolved.xlsx.xlsx |
29.64Кб |
| 8.1 7. Modeling Cogs – Unsolved.xlsm.xlsm |
48.69Кб |
| 8.1 Formatting - Solved.xlsx.xlsx |
9.85Кб |
| 8.1 Useful Tips & Tools PDF Version.pdf |
9.44Мб |
| 8.2 02 10 Formatting Solved.xlsx.xlsx |
11.59Кб |
| 8.2 4a. Gross profit automotive - before.xlsx.xlsx |
1.51Мб |
| 8.2 7. Cash flow.xlsx.xlsx |
31.36Кб |
| 8.2 7. Modeling Cogs - Solved.xlsm.xlsm |
51.89Кб |
| 8.2 Text to columns – Unsolved.xlsx.xlsx |
9.76Кб |
| 8.3 02 10 Formatting Exercise Text.xlsx.xlsx |
11.61Кб |
| 8.3 03 21 Text to Columns Exercise & Text.xlsx.xlsx |
10.57Кб |
| 8.4 03 21 Text to Columns Solved.xlsx.xlsx |
11.30Кб |
| 8.4 Formatting - Unsolved.xlsx.xlsx |
18.91Кб |
| 8. 50% Completed!.mp4 |
4.30Мб |
| 8. 50% Completed!.vtt |
51б |
| 8.5 Text to columns - Solved.xlsx.xlsx |
9.90Кб |
| 8. Calculating automotive gross profit.mp4 |
27.76Мб |
| 8. Calculating automotive gross profit.vtt |
2.87Кб |
| 8. Calculating project cash flows.mp4 |
10.14Мб |
| 8. Calculating project cash flows.vtt |
3.72Кб |
| 8. Elaborate text efficiently Left, Right, Mid, Upper, Lower,Proper, Concatenate.html |
163б |
| 8. Financial modeling The right level of detail in a model.mp4 |
5.68Мб |
| 8. Financial modeling The right level of detail in a model.vtt |
2.93Кб |
| 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.vtt |
6.68Кб |
| 8. Introduction to formatting.mp4 |
24.75Мб |
| 8. Introduction to formatting.vtt |
6.14Кб |
| 8. Learn how to organize your data with Text to Columns.mp4 |
3.94Мб |
| 8. Learn how to organize your data with Text to Columns.vtt |
2.21Кб |
| 8. Modeling other items Other revenues and Cogs.mp4 |
7.42Мб |
| 8. Modeling other items Other revenues and Cogs.vtt |
4.37Кб |
| 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.vtt |
3.88Кб |
| 9.1 5. Cost of sales and chart.xlsx.xlsx |
1.34Мб |
| 9.1 8. Exercise - Build an FMCG Model_Inserting Slicers.xlsx.xlsx |
20.77Мб |
| 9.1 8. Opex and D&A - Solved.xlsm.xlsm |
52.30Кб |
| 9.1 8. Sumif - Solved.xlsx.xlsx |
47.24Кб |
| 9.1 8. WACC.xlsx.xlsx |
38.03Кб |
| 9.1 Formulas – Unsolved.xlsx.xlsx |
9.30Кб |
| 9.1 Max, min – Solved.xlsx.xlsx |
9.23Кб |
| 9.2 05 41 MIN MAX Exercise & Text.xlsx.xlsx |
14.39Кб |
| 9.2 8. Opex and D&A - Unsolved.xlsm.xlsm |
48.95Кб |
| 9.2 8. Sumif - Unsolved.xlsx.xlsx |
37.41Кб |
| 9.2 8. WACC_unsolved.xlsx.xlsx |
35.93Кб |
| 9.2 Formulas - Solved.xlsx.xlsx |
9.36Кб |
| 9.3 02 11 Formulas Exercise Text.xlsx.xlsx |
11.72Кб |
| 9.3 05 41 MIN MAX Solved.xlsx.xlsx |
14.80Кб |
| 9.4 02 11 Formulas Solved.xlsx.xlsx |
80.13Кб |
| 9.4 Max, min - Unsolved.xlsx.xlsx |
8.95Кб |
| 9. Calculating automotive cost of sales.mp4 |
17.49Мб |
| 9. Calculating automotive cost of sales.vtt |
2.22Кб |
| 9. Combining Slicers and GetPivotData The key to our success.mp4 |
17.83Мб |
| 9. Combining Slicers and GetPivotData The key to our success.vtt |
3.40Кб |
| 9. Estimating the project's cash flows.mp4 |
18.79Мб |
| 9. Estimating the project's cash flows.vtt |
6.61Кб |
| 9. Estimating the weighted average cost of capital (WACC).mp4 |
5.58Мб |
| 9. Estimating the weighted average cost of capital (WACC).vtt |
3.29Кб |
| 9. Financial modeling Forecasting guidelines.mp4 |
6.44Мб |
| 9. Financial modeling Forecasting guidelines.vtt |
3.34Кб |
| 9. Find the minimum or maximum value in a range of cells in Excel.mp4 |
1.90Мб |
| 9. Find the minimum or maximum value in a range of cells in Excel.vtt |
1.09Кб |
| 9. Introduction to Excel formulas.mp4 |
5.85Мб |
| 9. Introduction to Excel formulas.vtt |
4.13Кб |
| 9. Learn how to organize your data with Text to Columns.html |
163б |
| 9. Modeling other items Operating expenses and D&A.mp4 |
5.27Мб |
| 9. Modeling other items Operating expenses and D&A.vtt |
2.86Кб |
| 9. Use SUMIF to complete the Database sheet.mp4 |
13.29Мб |
| 9. Use SUMIF to complete the Database sheet.vtt |
4.46Кб |