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