FileMood

Download [DesireCourse.Net] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation

DesireCourse Net Udemy Beginner to Pro in Excel Financial Modeling and Valuation

Name

[DesireCourse.Net] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation

  DOWNLOAD Copy Link

Trouble downloading? see How To

Total Size

6.1 GB

Total Files

1053

Last Seen

2025-07-22 23:44

Hash

6EFA437E6486BF66436578D3083E9748DFAA1A40

/0. Websites you may like/

[CourseClub.Me].url

0.0 KB

[DesireCourse.Net].url

0.1 KB

/1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/

1. What does the course cover.mp4

34.4 MB

1. What does the course cover.srt

5.1 KB

1.1 Course Notes - Beginner to Pro in Excel.pdf

20.0 MB

2. Bonus! Welcome gift.html

0.2 KB

3. Welcome gift number 2.html

0.2 KB

4. The best way to take this course.mp4

18.5 MB

4. The best way to take this course.srt

2.6 KB

5. Download all course materials and frequently asked questions (FAQ).html

5.5 KB

[CourseClub.Me].url

0.0 KB

[DesireCourse.Net].url

0.1 KB

/10. Introduction to Excel charts/

1. How to insert a chart in Excel.mp4

23.4 MB

1. How to insert a chart in Excel.srt

2.7 KB

1.1 95. Inserting-Charts-Lecture.xlsm

12.0 MB

2. Editing Excel charts.mp4

27.3 MB

2. Editing Excel charts.srt

3.0 KB

2.1 96. Formatting-a-Chart-Lecture.xlsm

12.0 MB

3. Excel chart formatting.mp4

34.3 MB

3. Excel chart formatting.srt

3.6 KB

3.1 97. Modifying-a-Chart-Lecture.xlsm

12.0 MB

4. How to create a bridge chart in Excel.mp4

14.3 MB

4. How to create a bridge chart in Excel.srt

1.9 KB

4.1 98. Bridge-Charts-Lecture.xlsx

13.4 KB

5. New ways to visualize your data - Treemap charts.mp4

12.0 MB

5. New ways to visualize your data - Treemap charts.srt

1.8 KB

5.1 99. Treemap-Charts-Lecture.xlsx

12.9 KB

6. Sparklines.mp4

28.9 MB

6. Sparklines.srt

4.4 KB

6.1 100. Sparklines-Lecture.xlsx

9.8 KB

/11. P&L Case Study continued - Let's create some great-looking professional charts/

1. Create professional and good-looking charts - Introduction.mp4

6.5 MB

1. Create professional and good-looking charts - Introduction.srt

0.7 KB

2. Build a column stacked chart with a secondary line axis in Excel.mp4

48.6 MB

2. Build a column stacked chart with a secondary line axis in Excel.srt

5.8 KB

2.1 102. Column stacked chart-Lecture-before.xlsm

12.1 MB

2.2 102. Column stacked chart-Lecture-after.xlsm

12.1 MB

3. Learn how to build effective doughnut charts in Excel.mp4

39.9 MB

3. Learn how to build effective doughnut charts in Excel.srt

5.6 KB

3.1 103. Doughnut chart-Lecture-after.xlsm

12.1 MB

3.2 103. Doughnut chart-Lecture-before.xlsm

12.1 MB

4. Learn how to build an area chart in Excel.mp4

30.0 MB

4. Learn how to build an area chart in Excel.srt

3.6 KB

4.1 104. Area chart-Lecture-before.xlsm

12.1 MB

4.2 104. Area chart-Lecture-after.xlsm

12.1 MB

5. Learn how to create bridge charts.mp4

54.6 MB

5. Learn how to create bridge charts.srt

7.8 KB

5.1 105. Bridge chart-Lecture-before.xlsm

12.1 MB

5.2 105. Bridge chart-Lecture-after.xlsm

12.1 MB

6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4

142.7 MB

6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.srt

13.0 KB

6.1 20. Bridge chart_after.xlsm

12.1 MB

6.2 20. Bridge chart_before.xlsm

12.1 MB

7. Case Study - Building a Complete P&L from scratch in Excel.html

0.2 KB

8. Course Challenge - Apply your skills in practice!.mp4

8.3 MB

8. Course Challenge - Apply your skills in practice!.srt

1.3 KB

8.1 107. Course-Challenge - Unsolved.xlsx

517.6 KB

8.2 107. Course-Challenge - Solved.xlsx

557.0 KB

/12. Case Study - Building an FMCG Model from Scratch/

1. Introduction to the Case Study.mp4

25.2 MB

1. Introduction to the Case Study.srt

2.6 KB

1.1 108. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx

13.9 MB

10. FAQ My GETPIVOTDATA function doesn't work.html

0.7 KB

11. Combining Slicers and GETPIVOTDATA The key to our success.mp4

35.3 MB

11. Combining Slicers and GETPIVOTDATA The key to our success.srt

3.7 KB

11.1 7. Exercise - Build an FMCG Model_Inserting Slicers_before.xlsx

21.8 MB

11.2 7. Exercise - Build an FMCG Model_Inserting Slicers_after.xlsx

21.8 MB

12. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4

34.0 MB

12. Getting fancy with Excel slicers - Good-looking Excel slicers.srt

3.7 KB

12.1 8. Exercise - Build an FMCG Model_Formatting Slicers_before.xlsx

21.8 MB

12.2 8. Exercise - Build an FMCG Model_Formatting Slicers_after.xlsx

19.1 MB

13. This is how the report can be used in practice by high-level executives.mp4

37.9 MB

13. This is how the report can be used in practice by high-level executives.srt

4.8 KB

13.1 9. Exercise - Build an FMCG Model_Complete_after.xlsx

23.9 MB

13.2 9. Exercise - Build an FMCG Model_Complete_before.xlsx

19.1 MB

14. Dynamic reporting with GETPIVOTDATA and slicers.html

0.2 KB

2. Preliminary mapping of the data extraction.mp4

31.9 MB

2. Preliminary mapping of the data extraction.srt

2.6 KB

2.1 1. Exercise - Build an FMCG Model_Mapping_before.xlsx

13.9 MB

2.2 1. Exercise - Build an FMCG Model_Mapping_after.xlsx

15.6 MB

3. Working with an SAP data extraction.mp4

38.9 MB

3. Working with an SAP data extraction.srt

4.2 KB

4. Creating an output structure of the FMCG model.mp4

20.7 MB

4. Creating an output structure of the FMCG model.srt

3.1 KB

4.1 2. Exercise - Build an FMCG Model_Layout_before.xlsx

15.6 MB

4.2 2. Exercise - Build an FMCG Model_Layout_after.xlsx

15.6 MB

5. Improving the layout and appearance of the FMCG report.mp4

26.6 MB

5. Improving the layout and appearance of the FMCG report.srt

5.1 KB

5.1 3. Exercise - Build an FMCG Model_Formatting_after.xlsx

15.6 MB

5.2 3. Exercise - Build an FMCG Model_Formatting_before.xlsx

15.6 MB

6. Inserting formulas and automating calculations.mp4

16.9 MB

6. Inserting formulas and automating calculations.srt

5.1 KB

6.1 4. Exercise - Build an FMCG Model_Adding Calculations_after.xlsx

15.6 MB

6.2 4. Exercise - Build an FMCG Model_Adding Calculations_before.xlsx

15.6 MB

7. Creating a Master Pivot Table The main data source for the FMCG report.mp4

21.1 MB

7. Creating a Master Pivot Table The main data source for the FMCG report.srt

2.3 KB

7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table_before.xlsx

15.6 MB

7.2 5. Exercise - Build an FMCG Model_Creating a Pivot Table_after.xlsx

21.8 MB

8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4

52.4 MB

8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.srt

7.3 KB

8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA_before.xlsx

21.8 MB

8.2 6a. Exercise - Build an FMCG Model_Copying Get Pivot_after.xlsx

21.8 MB

9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4

14.4 MB

9. A potential error with GETPIVOTDATA you might encounter and its fix.srt

1.5 KB

/13. Financial modeling fundamentals/

1. Financial modeling basics - Welcome lecture.mp4

2.2 MB

1. Financial modeling basics - Welcome lecture.srt

1.1 KB

10. Forecasting financials - Quiz.html

0.2 KB

11. Building a complete model - Important considerations.mp4

8.9 MB

11. Building a complete model - Important considerations.srt

3.0 KB

12. Modeling the Income statement.mp4

14.0 MB

12. Modeling the Income statement.srt

7.6 KB

13. Modeling the Balance sheet - Part 1.mp4

6.4 MB

13. Modeling the Balance sheet - Part 1.srt

3.5 KB

14. Modeling the Balance sheet - Part 2.mp4

11.1 MB

14. Modeling the Balance sheet - Part 2.srt

6.2 KB

15. Building a financial model - Quiz.html

0.2 KB

2. What is a financial model.mp4

5.7 MB

2. What is a financial model.srt

2.5 KB

3. Why use financial models.mp4

10.5 MB

3. Why use financial models.srt

3.4 KB

4. Financial modeling - worst practices - things you should avoid.mp4

20.9 MB

4. Financial modeling - worst practices - things you should avoid.srt

7.5 KB

5. Financial modeling - best practices.mp4

18.1 MB

5. Financial modeling - best practices.srt

6.2 KB

6. Financial modeling - The types of models that are built in practice.mp4

15.0 MB

6. Financial modeling - The types of models that are built in practice.srt

6.0 KB

7. Financial modeling - Quiz.html

0.2 KB

8. Financial modeling The right level of detail in a model.mp4

7.6 MB

8. Financial modeling The right level of detail in a model.srt

3.2 KB

9. Financial modeling Forecasting guidelines.mp4

7.5 MB

9. Financial modeling Forecasting guidelines.srt

3.6 KB

/14. Introduction to Company Valuation/

1. The core theory behind Company Valuation.html

0.2 KB

/15. Introduction to Mergers & Acquisitions/

1. Introduction to Mergers & Acquisitions.html

0.2 KB

[CourseClub.Me].url

0.0 KB

[DesireCourse.Net].url

0.1 KB

/16. Learn how to build a Discounted Cash Flow model in Excel/

1. Valuation Case study - Welcome lecture.mp4

1.9 MB

1. Valuation Case study - Welcome lecture.srt

0.9 KB

10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4

31.5 MB

10. Modeling other items Interest expenses, Extraordinary items and Taxes.srt

3.1 KB

10.1 9. Interest expenses, taxes_after.xlsm

52.1 KB

10.2 9. Interest expenses, taxes_before.xlsm

51.8 KB

11. Forecasting Balance sheet items.mp4

4.9 MB

11. Forecasting Balance sheet items.srt

0.9 KB

11.1 10. Introduction to Balance sheet items.xlsm

52.2 KB

12. An introduction to the Days methodology.mp4

10.6 MB

12. An introduction to the Days methodology.srt

1.9 KB

12.1 Working Capital Days.pptx

97.0 KB

13. Calculation of DSO, DPO and DOI for the historical period.mp4

12.7 MB

13. Calculation of DSO, DPO and DOI for the historical period.srt

1.4 KB

13.1 12. Days calculation_before.xlsm

52.4 KB

13.2 12. Days calculation_after.xlsm

52.7 KB

14. Forecasting DSO, DPO and DOI.mp4

21.9 MB

14. Forecasting DSO, DPO and DOI.srt

2.6 KB

14.1 13. Forecasting DSO, DPO, DIO_before.xlsm

52.7 KB

14.2 13. Forecasting DSO, DPO, DIO_after.xlsm

53.2 KB

15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4

23.7 MB

15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.srt

2.9 KB

15.1 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm

53.2 KB

15.2 14. Forecasting PP&E, Other assets, and Other liabilities_after.xlsm

54.2 KB

16. Creating an output P&L sheet.mp4

19.7 MB

16. Creating an output P&L sheet.srt

2.4 KB

16.1 15. P&L structure_before.xlsm

54.9 KB

16.2 15. P&L structure_after.xlsm

55.0 KB

17. Populating the output P&L sheet.mp4

26.8 MB

17. Populating the output P&L sheet.srt

2.6 KB

17.1 16. Populating the P&L sheet_after.xlsm

56.6 KB

17.2 16. Populating the P&L sheet_before.xlsm

55.0 KB

18. Populating the output BS sheet.mp4

17.8 MB

18. Populating the output BS sheet.srt

1.8 KB

18.1 17. Populating BS sheet_after.xlsm

58.6 KB

18.2 17. Populating BS sheet_before.xlsm

56.6 KB

19. Completing the output BS sheet for the historical period.mp4

39.9 MB

19. Completing the output BS sheet for the historical period.srt

4.1 KB

19.1 18. Completing the Balance Sheet_before.xlsm

58.6 KB

19.2 18. Completing the Balance Sheet_after.xlsm

59.5 KB

2. Introduction to the DCF exercise.mp4

8.3 MB

2. Introduction to the DCF exercise.srt

1.3 KB

20. Creating a structure for the calculation of Unlevered free cash flows.mp4

23.9 MB

20. Creating a structure for the calculation of Unlevered free cash flows.srt

3.3 KB

20.1 19. Cash flow structure_before.xlsm

59.9 KB

20.2 19. Cash flow structure_after.xlsm

60.0 KB

21. Bridging Unlevered free cash flow to Net cash flow.mp4

15.3 MB

21. Bridging Unlevered free cash flow to Net cash flow.srt

2.1 KB

21.1 20. Bridge UFCF to Net cash flow_after.xlsm

60.1 KB

21.2 20. Bridge UFCF to Net cash flow_before.xlsm

60.0 KB

22. Calculating Unlevered free cash flow.mp4

62.6 MB

22. Calculating Unlevered free cash flow.srt

6.7 KB

22.1 21. Calculating UFCF_before.xlsm

60.1 KB

22.2 21. Calculating UFCF_after.xlsm

60.6 KB

23. Calculating Net cash flow.mp4

39.8 MB

23. Calculating Net cash flow.srt

4.4 KB

23.1 22. Calculating Net Cash Flow_before.xlsm

60.6 KB

23.2 22. Calculating Net Cash Flow_after.xlsm

60.8 KB

23.3 Cash Flow Classification By Activities.xlsx

57.3 KB

24. Obtaining the rest of the cash flows through Find and Replace.mp4

49.0 MB

24. Obtaining the rest of the cash flows through Find and Replace.srt

4.5 KB

24.1 23. Find and replace_before.xlsm

61.0 KB

24.2 23. Find and replace_after.xlsm

64.0 KB

25. Introducing Weighted average cost of capital and Perpetuity growth.mp4

13.9 MB

25. Introducing Weighted average cost of capital and Perpetuity growth.srt

2.4 KB

25.1 24. Introducing WACC and g_before.xlsm

64.0 KB

25.2 24. Introducing WACC and g_after.xlsm

64.1 KB

26. Discounting Unlevered free cash flows to obtain their Present value.mp4

21.2 MB

26. Discounting Unlevered free cash flows to obtain their Present value.srt

3.2 KB

26.1 25. Calculating PV of Cash Flows_before.xlsm

64.1 KB

26.2 25. Calculating PV of Cash Flows_after.xlsm

64.2 KB

27. Calculating Continuing value and Enterprise value of the business.mp4

18.6 MB

27. Calculating Continuing value and Enterprise value of the business.srt

2.6 KB

27.1 26. Calculating CV and EV_before.xlsm

64.2 KB

27.2 26. Calculating CV and EV_after.xlsm

64.6 KB

28. Calculating Equity value.mp4

12.8 MB

28. Calculating Equity value.srt

1.7 KB

28.1 27. Calculating equity value_before.xlsm

64.6 KB

28.2 27. Calculating equity value_after.xlsm

64.8 KB

29. Sensitivity analysis for WACC and perpetuity growth.mp4

42.5 MB

29. Sensitivity analysis for WACC and perpetuity growth.srt

4.7 KB

29.1 28. Sensitivity analysis_before.xlsm

64.8 KB

29.2 28. Sensitivity analysis_after.xlsm

66.4 KB

29.3 Sensitivity Analysis.xlsx

62.3 KB

3. The stages of a complete DCF Valuation.mp4

51.6 MB

3. The stages of a complete DCF Valuation.srt

7.5 KB

3.1 Valuation exercise.pdf

421.6 KB

30. A possible application of Goal seek.mp4

16.4 MB

30. A possible application of Goal seek.srt

2.0 KB

30.1 29. Goal seek_before.xlsm

66.4 KB

30.2 29. Goal seek_ater.xlsm

66.4 KB

31. Using charts to summarize the results of the DCF model.mp4

34.5 MB

31. Using charts to summarize the results of the DCF model.srt

5.6 KB

31.1 30. Charts.xlsm

103.6 KB

32. You made it!.mp4

11.8 MB

32. You made it!.srt

2.9 KB

4. Description of the structure of the DCF model.mp4

19.4 MB

4. Description of the structure of the DCF model.srt

3.4 KB

4.1 3. Structure of the DCF model.xlsm

49.0 KB

4.2 DCF Model structure.pdf

246.6 KB

5. A glimpse at the company we are valuing - Cheeseco.mp4

16.4 MB

5. A glimpse at the company we are valuing - Cheeseco.srt

1.4 KB

5.1 Cheeseco.pptx

82.0 KB

6. Modeling the top line.mp4

27.6 MB

6. Modeling the top line.srt

4.1 KB

6.1 5. Modeling revenues_after.xlsm

49.3 KB

6.2 5. Modeling revenues_before.xlsm

49.0 KB

7. Introducing scenarios to the model with Choose.mp4

18.7 MB

7. Introducing scenarios to the model with Choose.srt

2.7 KB

7.1 6. Choose_before.xlsm

49.3 KB

7.2 6. Choose_after.xlsm

49.5 KB

8. Modeling other items Other revenues and Cogs.mp4

46.7 MB

8. Modeling other items Other revenues and Cogs.srt

4.7 KB

8.1 7. Other revenues and Cogs_after.xlsm

51.3 KB

8.2 7. Other revenues and Cogs_before.xlsm

49.5 KB

9. Modeling other items Operating expenses and D&A.mp4

27.6 MB

9. Modeling other items Operating expenses and D&A.srt

2.8 KB

9.1 8. Opex and D&A_before.xlsm

51.3 KB

9.2 8. Opex and D&A_after.xlsm

51.8 KB

/17. Tesla valuation - Complete practical exercise/

1. Organizing external inputs in a 'Drivers' sheet.mp4

32.5 MB

1. Organizing external inputs in a 'Drivers' sheet.srt

4.5 KB

1.1 Tesla Company Valuation - Detailed walkthrough.pdf

5.3 MB

1.2 Tesla 2015.pdf

1.4 MB

1.3 0a. Drivers_before.xlsx

1.3 MB

1.4 Tesla 2016.pdf

2.3 MB

1.5 0a. Drivers_after.xlsx

1.3 MB

1.6 Tesla 2017.pdf

2.6 MB

1.7 Tesla 2018 Q2.pdf

650.3 KB

10. Forecasting 'energy' and 'services' revenue.mp4

26.5 MB

10. Forecasting 'energy' and 'services' revenue.srt

3.2 KB

10.1 6. Energy and Other revenue - After.xlsx

1.4 MB

10.2 6. Energy and Other revenue - Before.xlsx

1.4 MB

11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4

28.1 MB

11. Calculating 'energy' and 'services' gross profit and cost of sales.srt

2.6 KB

11.1 7. Energy and Other - Gross profit, cost of sales - After.xlsx

1.4 MB

11.2 7. Energy and Other - Gross profit, cost of sales - Before.xlsx

1.4 MB

12. Forecasting operating expenses.mp4

36.6 MB

12. Forecasting operating expenses.srt

5.5 KB

12.1 8. Opex - After.xlsx

1.4 MB

12.2 8. Opex - Before.xlsx

1.4 MB

13. Building a fixed asset roll forward estimating Capex.mp4

59.3 MB

13. Building a fixed asset roll forward estimating Capex.srt

6.6 KB

13.1 9. PP&E forecasting and comparables_before.xlsx

1.4 MB

13.2 9. PP&E forecasting and comparables_after.xlsx

1.4 MB

14. Building a fixed asset roll forward D&A schedule.mp4

56.8 MB

14. Building a fixed asset roll forward D&A schedule.srt

4.6 KB

14.1 10. PP&E schedule_before.xlsx

1.4 MB

14.2 10. PP&E schedule_after.xlsx

1.4 MB

15. Peer comparison D&A as a percentage of revenues.mp4

14.3 MB

15. Peer comparison D&A as a percentage of revenues.srt

1.7 KB

15.1 10a. PP&E comparison.xlsx

1.4 MB

16. FAQ Why model D&A as a % of revenues or as a % of beginning PP&E.html

0.8 KB

17. Calculating DSO, DIO, DPO.mp4

18.4 MB

17. Calculating DSO, DIO, DPO.srt

2.2 KB

17.1 11. Working capital forecasting_before.xlsx

1.4 MB

17.2 11. Working capital forecasting_after.xlsx

1.6 MB

18. Producing a clean P&L output sheet.mp4

8.9 MB

18. Producing a clean P&L output sheet.srt

1.7 KB

18.1 12. P&L.xlsx

1.5 MB

19. Fill in the P&L output sheet.mp4

19.2 MB

19. Fill in the P&L output sheet.srt

1.9 KB

19.1 12a. P&L fill in_before.xlsx

1.5 MB

19.2 12a. P&L fill in_after.xlsx

1.5 MB

2. The input data we will work with.mp4

16.6 MB

2. The input data we will work with.srt

1.8 KB

2.1 0aa. Inputs_after.xlsx

1.3 MB

2.2 0aa. Inputs_before.xlsx

1.3 MB

20. Calculating investments in working capital.mp4

20.0 MB

20. Calculating investments in working capital.srt

2.2 KB

20.1 13. Calculating working capital_before.xlsx

1.5 MB

20.2 13. Calculating working capital_after.xlsx

1.5 MB

21. Forecasting Unlevered free cash flow.mp4

58.7 MB

21. Forecasting Unlevered free cash flow.srt

6.2 KB

21.1 14. Cash flow - UFCF_after.xlsx

1.5 MB

21.2 14. Cash flow - UFCF_before.xlsx

1.5 MB

22. Forecasting other assets.mp4

47.4 MB

22. Forecasting other assets.srt

4.7 KB

22.1 15. Balance Sheet forecasting assets_before.xlsx

1.5 MB

22.2 15. Balance Sheet forecasting assets_after.xlsx

1.5 MB

23. Forecasting other liabilities.mp4

23.0 MB

23. Forecasting other liabilities.srt

2.4 KB

23.1 16. Balance Sheet forecasting liabilities_before.xlsx

1.5 MB

23.2 16. Balance Sheet forecasting liabilities_after.xlsx

1.5 MB

24. Completing Unlevered free cash flow.mp4

42.9 MB

24. Completing Unlevered free cash flow.srt

3.8 KB

24.1 16a. Complete UFCF_before.xlsx

1.5 MB

24.2 16a. Complete UFCF_after.xlsx

1.5 MB

25. Modeling Tesla's financing needs in the forecast period.mp4

44.4 MB

25. Modeling Tesla's financing needs in the forecast period.srt

5.8 KB

25.1 17. Financing_before.xlsx

1.5 MB

25.2 17. Financing_after.xlsx

1.5 MB

26. Calculating Net income.mp4

15.5 MB

26. Calculating Net income.srt

1.4 KB

26.1 18. P&L complete_after.xlsx

1.5 MB

26.2 18. P&L complete_before.xlsx

1.5 MB

27. Bridging Unlevered free cash flow to Net cash flow.mp4

53.2 MB

27. Bridging Unlevered free cash flow to Net cash flow.srt

4.6 KB

27.1 19. Cash flow_complete_after.xlsx

1.5 MB

27.2 19. Cash flow_complete_before.xlsx

1.5 MB

28. Balancing the Balance sheet.mp4

13.9 MB

28. Balancing the Balance sheet.srt

1.2 KB

28.1 20. Complete the BS_after.xlsx

1.5 MB

28.2 20. Complete the BS_before.xlsx

1.5 MB

29. Estimating Weighted average cost of capital (WACC).mp4

46.4 MB

29. Estimating Weighted average cost of capital (WACC).srt

6.9 KB

29.1 21. WACC_before.xlsx

1.5 MB

29.2 21. WACC_after.xlsx

1.5 MB

3. Forecasting Tesla's expected deliveries.mp4

105.2 MB

3. Forecasting Tesla's expected deliveries.srt

16.4 KB

3.1 1. Deliveries_before.xlsx

1.4 MB

3.2 1. Deliveries_after.xlsx

1.4 MB

30. Performing discounted cash flow valuation (DCF).mp4

36.6 MB

30. Performing discounted cash flow valuation (DCF).srt

4.2 KB

30.1 22. DCF_before.xlsx

1.6 MB

30.2 22. DCF_after.xlsx

1.5 MB

31. Calculating enterprise value, equity value, and price per share.mp4

23.7 MB

31. Calculating enterprise value, equity value, and price per share.srt

2.2 KB

31.1 23. EV, Equity value, Price per share_after.xlsx

1.5 MB

31.2 23. EV, Equity value, Price per share_before.xlsx

1.5 MB

32. Final comments.mp4

47.1 MB

32. Final comments.srt

4.5 KB

4. Comparing delivery figures with the ones of industry peers.mp4

21.9 MB

4. Comparing delivery figures with the ones of industry peers.srt

3.2 KB

4.1 1a. Deliveries development.xlsx

1.4 MB

5. Estimating an average selling price of Tesla vehicles.mp4

44.0 MB

5. Estimating an average selling price of Tesla vehicles.srt

5.3 KB

5.1 2. Average price_after.xlsx

1.4 MB

5.2 2. Average price_before.xlsx

1.4 MB

6. Calculating automotive revenue.mp4

48.8 MB

6. Calculating automotive revenue.srt

5.1 KB

6.1 3. Revenue calculation and scenarios - after.xlsx

1.4 MB

6.2 3. Revenue calculation and scenarios - before.xlsx

1.4 MB

7. Peer comparison Gross profit %.mp4

18.0 MB

7. Peer comparison Gross profit %.srt

2.8 KB

7.1 4. Gross profit automotive.xlsx

1.4 MB

8. Calculating automotive gross profit.mp4

29.1 MB

8. Calculating automotive gross profit.srt

2.9 KB

8.1 4a. Gross profit automotive - after.xlsx

1.4 MB

8.2 4a. Gross profit automotive - before.xlsx

1.6 MB

9. Calculating automotive cost of sales.mp4

18.4 MB

9. Calculating automotive cost of sales.srt

2.3 KB

9.1 5. Cost of sales and chart.xlsx

1.4 MB

/18. Capital budgeting - The theory/

1. Introduction to Capital budgeting.mp4

5.7 MB

1. Introduction to Capital budgeting.srt

1.9 KB

2. Why we need Capital budgeting.mp4

7.2 MB

2. Why we need Capital budgeting.srt

2.8 KB

3. The time value of money.mp4

7.0 MB

3. The time value of money.srt

2.8 KB

4. Calculating future and present value.mp4

13.7 MB

4. Calculating future and present value.srt

6.8 KB

5. Calculating cost of equity.mp4

20.1 MB

5. Calculating cost of equity.srt

8.2 KB

6. Coming up with project-specific beta.mp4

9.4 MB

6. Coming up with project-specific beta.srt

3.9 KB

7. Weighted average cost of capital (WACC).mp4

5.8 MB

7. Weighted average cost of capital (WACC).srt

2.5 KB

8. The type of cash flows we will have in a project.mp4

9.8 MB

8. The type of cash flows we will have in a project.srt

4.3 KB

9. Estimating the project's cash flows.mp4

19.7 MB

9. Estimating the project's cash flows.srt

7.3 KB

/19. Capital Budgeting - A complete Case study/

1. Introduction to the Capital budgeting exercise.mp4

9.1 MB

1. Introduction to the Capital budgeting exercise.srt

3.5 KB

10. Finding cost of equity.mp4

14.6 MB

10. Finding cost of equity.srt

7.8 KB

10.1 8. WACC.xlsx

38.9 KB

10.2 8. WACC_unsolved.xlsx

36.8 KB

11. Discounting the project's cash flows and residual value.mp4

27.2 MB

11. Discounting the project's cash flows and residual value.srt

3.8 KB

11.1 9. Discounted cash flow_unsolved.xlsx

39.6 KB

11.2 9. Discounted cash flow.xlsx

40.7 KB

12. Performing sensitivity analysis and completing the exercise.mp4

45.1 MB

12. Performing sensitivity analysis and completing the exercise.srt

5.7 KB

12.1 10. Sensitivity analysis_unsolved.xlsx

40.6 KB

12.2 10. Sensitivity analysis.xlsx

41.6 KB

13. FAQ Data does not change in the DCF sheet, it changes from the Drivers sheet.html

0.4 KB

14. Build a complete capital budgeting model from scratch.html

0.2 KB

15. Congratulations!!.mp4

2.4 MB

15. Congratulations!!.srt

1.6 KB

2. Organizing an Inputs sheet.mp4

11.6 MB

2. Organizing an Inputs sheet.srt

6.7 KB

2.1 1. Drivers.xlsx

11.8 KB

3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4

9.7 MB

3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.srt

4.4 KB

3.1 2. Savings Forecast_unsolved.xlsx

15.1 KB

3.2 2. Savings Forecast.xlsx

17.0 KB

4. Fixed asset rollforward.mp4

12.8 MB

4. Fixed asset rollforward.srt

5.7 KB

4.1 3. Fixed Asset Rollforward_unsolved.xlsx

19.0 KB

4.2 3. Fixed Asset Rollforward.xlsx

20.1 KB

5. The impact of working capital.mp4

5.6 MB

5. The impact of working capital.srt

3.1 KB

5.1 4. Working Capital.xlsx

22.5 KB

5.2 4. Working Capital_unsolved.xlsx

21.7 KB

6. Modeling debt financing.mp4

6.5 MB

6. Modeling debt financing.srt

3.5 KB

6.1 5. Financing.xlsx

31.7 KB

6.2 5. Financing_unsolved.xlsx

30.7 KB

7. Adding a P&L sheet.mp4

5.1 MB

7. Adding a P&L sheet.srt

2.3 KB

7.1 6. P&L.xlsx

31.8 KB

7.2 6. P&L_unsolved.xlsx

30.4 KB

8. Calculating project cash flows.mp4

10.6 MB

8. Calculating project cash flows.srt

4.1 KB

8.1 7. Cash flow_unsolved.xlsx

30.4 KB

8.2 7. Cash flow.xlsx

32.1 KB

9. Estimating the weighted average cost of capital (WACC).mp4

5.9 MB

9. Estimating the weighted average cost of capital (WACC).srt

3.6 KB

9.1 8. WACC_unsolved.xlsx

36.8 KB

9.2 8. WACC.xlsx

38.9 KB

/2. Introduction to Excel/

1. Introduction to Excel.mp4

2.1 MB

1. Introduction to Excel.srt

0.9 KB

10. Introduction to Excel formulas.html

0.2 KB

11. Introduction to Excel functions.mp4

19.6 MB

11. Introduction to Excel functions.srt

4.1 KB

11.1 13. Functions- Exercise_after.xlsx

83.0 KB

11.2 13. Functions - Lecture_after.xlsx

9.6 KB

11.3 13. Functions- Lecture_before.xlsx

9.5 KB

11.4 13. Functions-Exercise_before.xlsx

13.6 KB

11.5 Introduction to Excel.pdf

2.1 MB

12. Cut, copy, & paste.mp4

13.6 MB

12. Cut, copy, & paste.srt

2.4 KB

12.1 14. Copy-Cut-Paste-Exercise_after.xlsx

12.9 KB

12.2 Introduction to Excel.pdf

2.1 MB

12.3 14. Copy-Cut-Paste-Exercise_before.xlsx

11.6 KB

13. Cut, copy, & paste.html

0.2 KB

14. Paste special.mp4

11.4 MB

14. Paste special.srt

1.5 KB

14.1 15. Paste-Special-Exercise_after.xlsx

13.8 KB

14.2 15. Paste-Special-Exercise_before.xlsx

13.8 KB

14.3 Introduction to Excel.pdf

2.1 MB

15. Format cells.mp4

30.5 MB

15. Format cells.srt

6.7 KB

15.1 10. Format cells_before.xlsx

10.0 KB

15.2 10. Format cells_after.xlsx

10.0 KB

16. Basic operations in Excel - 38 pages.html

0.2 KB

2. Overview of Excel.mp4

21.7 MB

2. Overview of Excel.srt

4.1 KB

2.1 7. Overview-of-Excel-Exercise_before.xlsx

10.7 KB

2.2 7. Overview-of-Excel-Exercise_after.xlsx

11.1 KB

2.3 Introduction to Excel.pdf

2.1 MB

3. Overview of Excel.html

0.2 KB

4. The Excel ribbon.mp4

14.2 MB

4. The Excel ribbon.srt

2.7 KB

4.1 Introduction to Excel.pdf

2.1 MB

4.2 8. The-Ribbon-Exercise_before.xlsx

12.4 KB

4.3 8. The-Ribbon-Exercise_after.xlsx

412.9 KB

5. Basic operations with rows and columns.mp4

11.7 MB

5. Basic operations with rows and columns.srt

1.9 KB

5.1 9. Basic Manipulations - Lecture.xlsx

8.3 KB

5.2 9. Basic-Manipulations - Exercise_before.xlsx

11.3 KB

5.3 9. Basic-Manipulations - Exercise_after.xlsx

33.2 KB

5.4 Introduction to Excel.pdf

2.1 MB

6. Data entry in Excel.mp4

16.8 MB

6. Data entry in Excel.srt

3.5 KB

6.1 10. Data-Entry-Exercise_before.xlsx

11.2 KB

6.2 10. Data-Entry - Lecture.xlsx

8.3 KB

6.3 Introduction to Excel.pdf

2.1 MB

6.4 10. Data-Entry- Exercise_after.xlsx

33.5 KB

7. Introduction to formatting.mp4

40.1 MB

7. Introduction to formatting.srt

6.0 KB

7.1 11. Formatting - Lecture_after.xlsx

10.1 KB

7.2 11. Formatting- Lecture_before.xlsx

9.1 KB

7.3 Introduction to Excel.pdf

2.1 MB

7.4 11. Formatting-Exercise_before.xlsx

22.1 KB

7.5 11. Formatting- Exercise_after.xlsx

11.9 KB

8. Rows and columns.html

0.2 KB

9. Introduction to Excel formulas.mp4

21.7 MB

9. Introduction to Excel formulas.srt

44.2 MB

9.1 12. Formulas- Exercise_after.xlsx

82.1 KB

9.2 12. Formulas- Lecture_after.xlsx

9.6 KB

9.3 12. Formulas - Exercise_before.xlsx

12.0 KB

9.4 12. Formulas- Lecture_before.xlsx

9.5 KB

9.5 Introduction to Excel.pdf

2.1 MB

/20. Next steps/

1. Next steps.html

2.3 KB

[CourseClub.Me].url

0.0 KB

[DesireCourse.Net].url

0.1 KB

/21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/

1. Overview of Excel.mp4

43.2 MB

1. Overview of Excel.srt

4.2 KB

1.1 7. Overview-of-Excel-Exercise-Solved.xlsx

11.1 KB

1.2 7. Introduction to Excel.pdf

2.4 MB

1.3 7. Overview-of-Excel-Exercise-Unsolved.xlsx

10.7 KB

2. Basic manipulations with rows and columns.mp4

21.4 MB

2. Basic manipulations with rows and columns.srt

2.2 KB

2.1 8. Basic manipulations - Lecture.xlsx

8.3 KB

2.2 8. Basic-Manipulations - Exercise - Solved.xlsx

33.2 KB

2.3 8. Basic-Manipulations - Exercise - Unsolved.xlsx

11.3 KB

3. The Excel ribbon.mp4

30.3 MB

3. The Excel ribbon.srt

3.3 KB

3.1 9. The-Ribbon-Exercise-Solved.xlsx

412.9 KB

3.2 9. The-Ribbon-Exercise-Exercise - Unsolved.xlsx

12.4 KB

4. Data entry in Excel.mp4

33.0 MB

4. Data entry in Excel.srt

3.6 KB

4.1 10. Data-Entry-Exercise - Unsolved.xlsx

11.2 KB

4.2 10. Data-Entry - Lecture.xlsx

8.3 KB

4.3 10. Data-Entry- Exercise -Solved.xlsx

33.5 KB

5. Introduction to formatting.mp4

79.1 MB

5. Introduction to formatting.srt

6.8 KB

5.1 11. Formatting - Lecture - Solved.xlsx

10.1 KB

5.2 11. Formatting-Exercise - Unsolved.xlsx

11.9 KB

5.3 11. Formatting- Exercise - Solved.xlsx

11.9 KB

5.4 11. Formatting- Lecture - Unsolved.xlsx

9.1 KB

6. Introduction to Excel formulas.mp4

19.7 MB

6. Introduction to Excel formulas.srt

4.4 KB

6.1 12. Formulas - Exercise - Unsolved.xlsx

12.0 KB

6.2 12. Formulas- Lecture - Unsolved.xlsx

9.5 KB

6.3 Introduction-to-Excels-basic-features.pdf

2.4 MB

6.4 12. Formulas- Exercise - Solved.xlsx

82.1 KB

6.5 12. Formulas- Lecture - Solved.xlsx

9.6 KB

7. Introduction to Excel functions.mp4

38.9 MB

7. Introduction to Excel functions.srt

4.8 KB

7.1 13. Functions- Lecture - Unsolved.xlsx

9.5 KB

7.2 13. Functions-Exercise - Unsolved.xlsx

13.6 KB

7.3 13. Functions- Exercise - Solved.xlsx

83.0 KB

7.4 13. Functions - Lecture -Solved.xlsx

9.6 KB

7.5 Introduction-to-Excels-basic-features.pdf

2.4 MB

8. Cut, copy, & paste.mp4

7.9 MB

8. Cut, copy, & paste.srt

2.5 KB

8.1 Introduction-to-Excels-basic-features.pdf

2.4 MB

8.2 14. Copy-Cut-Paste-Exercise - Unsolved.xlsx

11.6 KB

8.3 14. Copy-Cut-Paste-Exercise - Solved.xlsx

12.9 KB

9. Paste special.mp4

7.0 MB

9. Paste special.srt

1.6 KB

9.1 Introduction-to-Excels-basic-features.pdf

2.4 MB

9.2 15. Paste-Special-Exercise - Solved.xlsx

13.8 KB

9.3 15. Paste-Special-Exercise - Unsolved.xlsx

13.8 KB

/22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/

1. Initial formatting of an Excel sheet to render it professional.mp4

8.4 MB

1. Initial formatting of an Excel sheet to render it professional.srt

2.4 KB

1.1 18. Formatting-a-Worksheet-Exercise - Unsolved.xlsx

10.9 KB

1.2 18. Formatting-a-Worksheet-Exercise - Solved.xlsx

11.0 KB

1.3 18. Formatting-a-worksheet-Lecture - Solved.xlsx

9.8 KB

1.4 18. Formatting-a-worksheet-Lecture - Unsolved.xlsx

9.2 KB

1.5 Useful-Tips-Tools.pdf

3.5 MB

10. Find and select special types of cells with Select Special (F5).mp4

10.3 MB

10. Find and select special types of cells with Select Special (F5).srt

2.0 KB

10.1 26. Select-Special-F5-Exercise - Solved.xlsx

22.8 KB

10.2 Useful-Tips-Tools.pdf

3.5 MB

10.3 26. Select-Special-Lecture.xlsx

10.8 KB

10.4 26. Select-Special-F5-Exercise - Unsolved.xlsx

22.1 KB

11. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4

5.7 MB

11. Assign custom formats to specific cells within a financial model (e.g Multiples).srt

2.0 KB

11.1 Useful-Tips-Tools.pdf

3.5 MB

11.2 29. Assigning Custom Formats - Exercise - Solved.xlsx

11.3 KB

11.3 29. Assigning Custom Formats - Exercise - Unsolved.xlsx

11.6 KB

12. Define a named range in Excel.mp4

5.7 MB

12. Define a named range in Excel.srt

1.7 KB

12.1 28. Naming-ranges-Lecture - Unsolved.xlsx

9.0 KB

12.2 Useful-Tips-Tools.pdf

3.5 MB

12.3 28. Defining-a-Named-Range-Exercise - Solved.xlsx

11.9 KB

12.4 28. Naming-ranges-Lecture - Solved.xlsx

10.6 KB

12.5 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx

11.3 KB

13. Learn how to organize your data with Text to Columns.mp4

13.2 MB

13. Learn how to organize your data with Text to Columns.srt

2.4 KB

13.1 Useful-Tips-Tools.pdf

3.5 MB

13.2 23. Text-to-Columns-Exercise - Unsolved.xlsx

10.8 KB

13.3 23. Text-to-Columns-Exercise - Solved.xlsx

11.6 KB

13.4 23.Text-to-columns-Lecture - Solved.xlsx

10.1 KB

13.5 23. Text-to-columns-Lecture - Unsolved.xlsx

10.0 KB

14. Learn how to assign dynamic names within a financial model.mp4

7.7 MB

14. Learn how to assign dynamic names within a financial model.srt

1.7 KB

14.1 27. Assigning-Dynamic-Names-Exercise - Solved.xlsx

12.0 KB

14.2 Useful-Tips-Tools.pdf

3.5 MB

14.3 27. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx

11.5 KB

14.4 27. Dynamic-Naming-Lecture - Solved.xlsx

14.2 KB

14.5 27. Dynamic-Naming-Lecture - Unsolved.xlsx

13.9 KB

15. Create easily printable documents in Excel by using Set Print Area.mp4

5.0 MB

15. Create easily printable documents in Excel by using Set Print Area.srt

1.6 KB

15.1 25. Set-Print-Area-Lecture - Solved.xlsx

11.5 KB

15.2 Useful-Tips-Tools.pdf

3.5 MB

15.3 25. Set-Print-Area-Lecture - Unsolved.xlsx

11.7 KB

16. Using the 'Alt + Enter' combination.mp4

3.5 MB

16. Using the 'Alt + Enter' combination.srt

1.1 KB

16.1 22. Alt-Enter-Exercise - Unsolved.xlsx

11.4 KB

16.2 22. Alt-Enter-Exercise - Solved.xlsx

11.7 KB

16.3 22. Alt-Enter- Lecture - Solved.xlsx

9.9 KB

16.4 22. Alt-Enter- Lecture - Unsolved.xlsx

9.9 KB

2. Fast scrolling through Excel sheets.mp4

23.2 MB

2. Fast scrolling through Excel sheets.srt

1.9 KB

2.1 19. Fast-Scrolling-Exercise - Unsolved.xlsx

45.0 KB

2.2 19. Fast-Scrolling - Lecture.xlsx

658.2 KB

2.3 Useful-Tips-Tools.pdf

3.5 MB

2.4 19. Fast-Scrolling-Exercise - Solved.xlsx

45.4 KB

3. Introduction to fixing of cell references.mp4

21.4 MB

3. Introduction to fixing of cell references.srt

2.8 KB

3.1 21. Fixing-references-Lecture - Unsolved.xlsx

659.4 KB

3.2 21. Fixing-Cells-Exercise - Solved.xlsx

11.1 KB

3.3 21. Fixing-references-Lecture - Solved.xlsx

660.7 KB

3.4 Useful-Tips-Tools.pdf

3.5 MB

3.5 21. Fixing-Cells-Exercise - Unsolved.xlsx

10.9 KB

4. Learn how to use the Wrap Text button.mp4

2.3 MB

4. Learn how to use the Wrap Text button.srt

0.9 KB

4.1 24. Wrap-Text-Exercise - Solved.xlsx

10.4 KB

4.2 Useful-Tips-Tools.pdf

3.5 MB

4.3 24. Wrap-Text-Exercise - Unsolved.xlsx

10.4 KB

4.4 24. Wrap-text-Lecture - Solved.xlsx

9.8 KB

4.5 24. Wrap-text-Lecture - Unsolved.xlsx

9.8 KB

5. Create a drop-down list by using Data Validation.mp4

11.1 MB

5. Create a drop-down list by using Data Validation.srt

2.3 KB

5.1 Useful-Tips-Tools.pdf

3.5 MB

5.2 32. Drop-down-List-Exercise - Unsolved.xlsx

11.6 KB

5.3 32. Data-Validation-Lecture - Unsolved.xlsx

11.1 KB

5.4 32. Drop-down-List-Exercise - Solved.xlsx

78.9 KB

5.5 32. Data-Validation-Lecture - Solved.xlsx

11.1 KB

6. Using Custom-sort in order to sort multiple columns within a table.mp4

9.6 MB

6. Using Custom-sort in order to sort multiple columns within a table.srt

1.7 KB

6.1 33. Custom-Sort-Exercise - Unsolved.xlsx

11.6 KB

6.2 33. Sort-data-Lecture - Unsolved.xlsx

148.8 KB

6.3 33. Sort-data-Lecture - Solved.xlsx

149.1 KB

6.4 33. Custom-Sort-Exercise - Solved.xlsx

11.7 KB

6.5 Useful-Tips-Tools.pdf

3.5 MB

7. Create a great Index page at the beginning of your models - Hyperlinks.mp4

5.6 MB

7. Create a great Index page at the beginning of your models - Hyperlinks.srt

1.6 KB

7.1 34. Hyperlinks-Exercise - Solved.xlsx

140.4 KB

7.2 Useful-Tips-Tools.pdf

3.5 MB

7.3 34. Hyperlinks-Exercise - Unsolved.xlsx

140.2 KB

8. Fix the top row of your table with Freeze Panes.mp4

18.5 MB

8. Fix the top row of your table with Freeze Panes.srt

1.5 KB

8.1 Useful-Tips-Tools.pdf

3.5 MB

8.2 35. Freeze-Panes-Lecture - Unsolved.xlsx

659.3 KB

8.3 35. Freeze-Panes-Lecture - Solved.xlsx

659.4 KB

9. Macros are a great timesaver! Here's why!.mp4

11.6 MB

9. Macros are a great timesaver! Here's why!.srt

3.7 KB

9.1 Useful-Tips-Tools.pdf

3.5 MB

9.2 30. Macros-Exercise - Solved.xlsx

148.5 KB

9.3 30. Macros-Exercise - Unsolved.xlsx

10.6 KB

9.4 30. Creating-a-Macro-Lecture - Unsolved.xlsx

9.9 KB

9.5 30. Creating-a-Macro-Lecture - Solved.xlsx

11.4 KB

/23. APPENDIX - Microsoft Excel 2010 - Keyboard shortcuts/

1. Keyboard shortcuts Save LOTS of time in Excel 2010.mp4

31.9 MB

1. Keyboard shortcuts Save LOTS of time in Excel 2010.srt

5.7 KB

/3. Useful tips and tools for your work in Excel/

1. Excel best practices - Welcome lecture.mp4

2.2 MB

1. Excel best practices - Welcome lecture.srt

1.1 KB

1.1 Useful Tips & Tools.pdf

3.2 MB

10. Learn how to organize your data with text to columns.html

0.2 KB

11. The wrap text button.mp4

3.8 MB

11. The wrap text button.srt

0.9 KB

11.1 Wrap-text-Lecture - Solved.xlsx

9.8 KB

11.2 Wrap-Text-Exercise - Solved.xlsx

10.4 KB

11.3 Wrap-text-Lecture - Unsolved.xlsx

9.8 KB

11.4 Wrap-Text-Exercise - Unsolved.xlsx

10.4 KB

12. Set print area.mp4

7.9 MB

12. Set print area.srt

1.5 KB

12.1 Set-Print-Area-Lecture - Solved.xlsx

11.5 KB

12.2 Set-Print-Area-Lecture - Unsolved.xlsx

12.1 KB

13. Custom sort helps you sort multiple columns in Excel tables.mp4

11.7 MB

13. Custom sort helps you sort multiple columns in Excel tables.srt

1.7 KB

13.1 Custom-Sort-Exercise - Solved.xlsx

11.7 KB

13.2 Custom-Sort-Exercise - Unsolved.xlsx

11.6 KB

13.3 Sort-data-Lecture - Unsolved.xlsx

148.8 KB

13.4 Sort-data-Lecture - Solved.xlsx

149.1 KB

14. Create drop-down lists with data validation.mp4

14.8 MB

14. Create drop-down lists with data validation.srt

2.0 KB

14.1 Data-Validation-Lecture - Solved.xlsx

11.5 KB

14.2 Drop-down-List-Exercise - Solved.xlsx

78.9 KB

14.3 Data-Validation-Lecture - Unsolved.xlsx

11.5 KB

14.4 Drop-down-List-Exercise - Unsolved.xlsx

11.6 KB

15. Find and select special types of cells with Select special (F5).mp4

14.6 MB

15. Find and select special types of cells with Select special (F5).srt

1.8 KB

15.1 Select-Special-Lecture-Solved.xlsx

11.2 KB

15.2 Select-Special-F5-Exercise - Unsolved.xlsx

22.1 KB

15.3 Select-Special-F5-Exercise - Solved.xlsx

22.8 KB

15.4 Select-Special-Lecture.xlsx

10.8 KB

16. Select Special.html

0.2 KB

17. Assign dynamic names in a financial model.mp4

8.1 MB

17. Assign dynamic names in a financial model.srt

1.6 KB

17.1 Dynamic-Naming-Lecture - Unsolved.xlsx

14.0 KB

17.2 Dynamic-Naming-Lecture - Solved.xlsx

12.7 KB

17.3 Assigning-Dynamic-Names-Exercise - Unsolved.xlsx

11.5 KB

17.4 Assigning-Dynamic-Names-Exercise - Solved.xlsx

12.0 KB

18. Assigning dynamic names.html

0.2 KB

19. Define a named range in Excel.mp4

8.0 MB

19. Define a named range in Excel.srt

1.8 KB

19.1 28. Defining-a-Named-Range-Exercise - Solved.xlsx

11.9 KB

19.2 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx

11.3 KB

19.3 28. Naming-ranges-Lecture - Unsolved.xlsx

9.0 KB

19.4 28. Naming-ranges-Lecture - Solved.xlsx

10.6 KB

2. Initial formatting of Excel sheets for a professional layout.mp4

12.2 MB

2. Initial formatting of Excel sheets for a professional layout.srt

2.4 KB

2.1 Useful Tips & Tools.pdf

3.2 MB

2.2 Formatting-a-Worksheet-Exercise - Solved.xlsx

11.0 KB

2.3 Formatting-a-worksheet-Lecture - Solved.xlsx

9.8 KB

2.4 Formatting-a-Worksheet-Exercise - Unsolved.xlsx

10.9 KB

2.5 Formatting-a-worksheet-Lecture - Unsolved.xlsx

9.2 KB

20. Create a great Index page at the beginning of your models - Hyperlinks.mp4

9.0 MB

20. Create a great Index page at the beginning of your models - Hyperlinks.srt

1.5 KB

20.1 Hyperlinks - Lecture - Solved.xlsx

14.7 KB

20.2 Hyperlinks - Lecture - Unsolved.xlsx

14.5 KB

20.3 Hyperlinks-Exercise - Solved.xlsx

140.4 KB

20.4 Hyperlinks-Exercise - Unsolved.xlsx

140.2 KB

21. Introduction to custom formatting in Excel.mp4

39.8 MB

21. Introduction to custom formatting in Excel.srt

8.3 KB

21.1 19. Custom formatting_before.xlsx

10.9 KB

21.2 19. Custom formatting_after.xlsx

11.0 KB

22. Apply custom formatting in a financial model.mp4

9.6 MB

22. Apply custom formatting in a financial model.srt

1.6 KB

22.1 Assigning Custom Formats - Exercise - Unsolved.xlsx

11.6 KB

22.2 Custom formats - Lecture - Solved.xlsx

9.0 KB

22.3 Assigning Custom Formats - Exercise - Solved.xlsx

11.3 KB

22.4 Custom formats - Lecture - Unsolved.xlsx

8.5 KB

23. Macros are a great timesaver! Here's why!.mp4

18.0 MB

23. Macros are a great timesaver! Here's why!.srt

3.2 KB

23.1 Recording a Macro - Lecture - Solved.ods

3.1 KB

23.2 Recording a Macro - Lecture - Unsolved.ods

2.6 KB

24. How to save macros and use them across several workbooks.mp4

13.4 MB

24. How to save macros and use them across several workbooks.srt

1.7 KB

24.1 31. Another-file.xlsx

9.0 KB

24.2 31. How-to-save-macros-Lecture-after.xlsm

12.9 KB

24.3 31. How-to-save-macros-Lecture-before.xlsx

6.2 KB

25. Excel macros - quiz.html

0.2 KB

26. Fix the top row of your table with freeze panes.mp4

15.2 MB

26. Fix the top row of your table with freeze panes.srt

1.4 KB

26.1 Freeze-Panes-Lecture - Solved.xlsx

659.6 KB

26.2 Freeze-Panes-Lecture - Unsolved.xlsx

659.6 KB

27. How to search functionalities in Excel.mp4

7.9 MB

27. How to search functionalities in Excel.srt

0.9 KB

27.1 Search.xlsx

659.6 KB

28. Filter by color - an excellent tool.mp4

10.4 MB

28. Filter by color - an excellent tool.srt

2.3 KB

28.1 36. Exercise-Filter-by-Color-Solved.xlsx

157.2 KB

28.2 36. Exercise-Filter-by-Color-Unsolved.xlsx

21.0 KB

29. Working with conditional formatting.mp4

15.8 MB

29. Working with conditional formatting.srt

6.2 KB

29.1 Exercise_Conditional Formatting.xlsx

13.2 KB

29.2 Conditional Formatting - Lecture.xlsx

12.8 KB

29.3 Solution_Conditional Formatting.xlsx

52.8 KB

3. Fast scrolling through Excel sheets.mp4

18.4 MB

3. Fast scrolling through Excel sheets.srt

1.9 KB

3.1 Fast-Scrolling - Lecture.xlsx

659.1 KB

3.2 Fast-Scrolling-Exercise - Solved.xlsx

45.4 KB

3.3 Fast-Scrolling-Exercise - Unsolved.xlsx

45.0 KB

30. Useful tips and tools for your work in Excel - quiz.html

0.2 KB

31. A neat trick - Multiply by 1.mp4

15.6 MB

31. A neat trick - Multiply by 1.srt

1.8 KB

31.1 38. Multiply-by-1-Lecture-before.xlsx

16.9 KB

31.2 38. Multiply-by-1-Lecture-after.xlsx

17.6 KB

32. Find and replace - references.mp4

25.2 MB

32. Find and replace - references.srt

3.5 KB

32.1 39. Find-and-Replace-references-Lecture-before.xlsx

39.7 KB

32.2 39. Find-and-Replace-references-Lecture-after.xlsx

38.8 KB

33. FAQ Why do we replace external references and how does this help us.html

0.7 KB

34. Find and replace - formatting.mp4

14.5 MB

34. Find and replace - formatting.srt

2.0 KB

34.1 40. Find-replace-Lecture-after.xlsx

17.6 KB

34.2 40. Find-replace-Lecture-before.xlsx

17.6 KB

35. Removing (automatic) green arrows.mp4

13.2 MB

35. Removing (automatic) green arrows.srt

1.7 KB

35.1 41. Green-references-Lecture.xlsx

22.5 KB

36. Beauty saving - The professional way of saving files.mp4

14.7 MB

36. Beauty saving - The professional way of saving files.srt

2.6 KB

36.1 42. Beauty-saving-Lecture-after.xlsx

17.5 KB

36.2 42. Beauty-saving-Lecture-before.xlsx

17.6 KB

37. Formula auditing with F2.mp4

18.6 MB

37. Formula auditing with F2.srt

2.2 KB

37.1 43. F2-Lecture.xlsm

52.0 KB

4. Fast scrolling through Excel sheets.html

0.2 KB

5. Be even quicker F5 + Enter.mp4

20.7 MB

5. Be even quicker F5 + Enter.srt

2.2 KB

5.1 20. F5-go-to - Lecture.xlsm

52.0 KB

6. Fixing cell references.mp4

25.3 MB

6. Fixing cell references.srt

2.6 KB

6.1 Fixing-references-Lecture - Solved.xlsx

660.0 KB

6.2 Fixing-references-Lecture - Unsolved.xlsx

659.6 KB

6.3 Fixing-Cells-Exercise - Unsolved.xlsx

10.9 KB

6.4 Fixing-Cells-Exercise - Solved.xlsx

11.1 KB

7. Introduction to fixing of cell references.html

0.2 KB

8. Alt + Enter.mp4

4.4 MB

8. Alt + Enter.srt

1.0 KB

8.1 Alt-Enter-Exercise - Unsolved.xlsx

11.4 KB

8.2 Alt-Enter- Lecture - Solved.xlsx

10.2 KB

8.3 Alt-Enter- Lecture - Unsolved.xlsx

10.2 KB

8.4 Alt-Enter-Exercise - Solved.xlsx

11.7 KB

9. Organize your data with text to columns.mp4

14.6 MB

9. Organize your data with text to columns.srt

2.5 KB

9.1 Text-to-Columns-Exercise - Unsolved.xlsx

10.8 KB

9.2 Text-to-columns-Lecture - Unsolved.xlsx

10.0 KB

9.3 Text-to-columns-Lecture - Solved.xlsx

10.4 KB

9.4 Text-to-Columns-Exercise - Solved.xlsx

11.6 KB

9.5 Invoice example.pdf

45.5 KB

/4. Keyboard shortcuts in Excel/

1. Keyboard shortcuts save LOTS of time in Excel.mp4

53.7 MB

1. Keyboard shortcuts save LOTS of time in Excel.srt

6.0 KB

1.1 Beginner to Pro in Excel - Shortcuts for PC.pdf

1.1 MB

1.2 Beginner to Pro in Excel - Shortcuts for MAC.pdf

458.3 KB

2. Keyboard shortcuts in Excel.html

0.2 KB

/5. Excel's key functions and functionalities made easy/

1. Excel's key functions - Welcome lecture.mp4

2.4 MB

1. Excel's key functions - Welcome lecture.srt

1.1 KB

10. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.html

0.2 KB

11. Working with text in Excel.mp4

16.8 MB

11. Working with text in Excel.srt

3.2 KB

11.1 53. Work-with-text-Lecture-before.xlsx

10.6 KB

11.2 53. Work-with-text-Lecture-after.xlsx

11.2 KB

12. Find the minimum or maximum value in a range of cells in Excel.mp4

6.2 MB

12. Find the minimum or maximum value in a range of cells in Excel.srt

1.2 KB

12.1 54. Max-min-Lecture - Unsolved.xlsx

9.2 KB

12.2 54. MIN-MAX-Exercise - Unsolved.xlsx

14.7 KB

12.3 54. MIN-MAX-Exercise - Solved.xlsx

15.2 KB

12.4 54. Max-min-Lecture - Solved.xlsx

9.4 KB

13. Include ROUND in your financial models.mp4

3.3 MB

13. Include ROUND in your financial models.srt

1.2 KB

13.1 55. Excel-functions-Lecture.xlsx

911.3 KB

13.2 Excel-Functions.pdf

3.3 MB

13.3 55. Round-Exercise - Unsolved.xlsx

11.6 KB

13.4 55. Round-Exercise - Solved.xlsx

12.0 KB

14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4

36.3 MB

14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.srt

9.2 KB

14.1 56. Vlookup-Hlookup- Lecture - Unsolved.xlsx

11.0 KB

14.2 56. Vlookup-Hlookup- Lecture - Solved.xlsx

11.4 KB

14.3 Excel-Functions.pdf

3.3 MB

14.4 56. Vlookup-Hlookup-Exercise - Solved.xlsx

14.0 KB

14.5 56. Vlookup-Hlookup-Exercise - Unsolved.xlsx

12.2 KB

15. How to enlarge the formula bar.mp4

6.6 MB

15. How to enlarge the formula bar.srt

1.4 KB

15.1 57. Enlarge-the-formula-bar-Lecture.xlsm

48.0 KB

16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4

40.9 MB

16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.srt

9.0 KB

16.1 Excel-Functions.pdf

3.3 MB

16.2 58. Index-Match-Lecture - Unsolved.xlsx

11.6 KB

16.3 58. Index-Match-Lecture - Solved.xlsx

12.0 KB

16.4 58. Index-Match-Exercise - Solved.xlsx

12.4 KB

16.5 58. Index-Match-Exercise - Unsolved.xlsx

11.9 KB

17. A great Excel technique INDEX, MATCH, MATCH.mp4

12.3 MB

17. A great Excel technique INDEX, MATCH, MATCH.srt

5.8 KB

17.1 59. Exercise-Index-Match-Match-Solved.xlsx

12.5 KB

17.2 59. Exercise-Index-Match-Match-Unsolved.xlsx

11.9 KB

17.3 Index, Match, Match - Lecture.xlsx

22.9 KB

18. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.html

0.2 KB

19. Using Excel's IFERROR function to trap spreadsheet errors.mp4

7.9 MB

19. Using Excel's IFERROR function to trap spreadsheet errors.srt

2.2 KB

19.1 60. Iferror-Exercise - Solved.xlsx

15.7 KB

19.2 60. Iferror - Lecture - Unsolved.xlsm

918.8 KB

19.3 60. Iferror-Exercise - Unsolved.xlsx

14.6 KB

19.4 60. Iferror - Lecture - Solved.xlsm

917.9 KB

19.5 Excel-Functions.pdf

3.3 MB

2. A helpful consideration.html

1.5 KB

20. RANK is a valuable tool when using Excel for financial and business analysis.mp4

24.4 MB

20. RANK is a valuable tool when using Excel for financial and business analysis.srt

2.9 KB

20.1 61. Rank-function-Lecture-before.xlsx

12.6 KB

20.2 61. Rank-function-Lecture-after.xlsx

12.9 KB

21. Learn how to render your models flexible with CHOOSE.mp4

9.4 MB

21. Learn how to render your models flexible with CHOOSE.srt

2.9 KB

21.1 Excel-Functions.pdf

3.3 MB

21.2 62. Choose-Lecture - Unsolved.xlsx

3.3 MB

21.3 62. Choose-Exercise-Solved.xlsx

12.0 KB

21.4 62. Choose-Lecture - Solved.xlsx

9.9 KB

21.5 62. Choose-Exercise - Unsolved.xlsx

11.6 KB

22. Use Goal Seek to find the result that you are looking for.mp4

8.2 MB

22. Use Goal Seek to find the result that you are looking for.srt

2.8 KB

22.1 63. Goal-Seek-Exercise-Solved.xlsx

16.6 KB

22.2 63. Goal-Seek-Lecture - Solved.xlsx

9.4 KB

22.3 63. Goal-Seek-Lecture - Unsolved.xlsx

9.4 KB

22.4 Excel-Functions.pdf

3.3 MB

22.5 63. Goal-Seek-Exercise - Unsolved.xlsx

16.5 KB

23. Use Goal Seek in order to find the result that you are looking for.html

0.2 KB

24. Include sensitivity analysis in your models through Data Tables.mp4

15.0 MB

24. Include sensitivity analysis in your models through Data Tables.srt

5.1 KB

24.1 64. Sensitivity-analysis-Exercise-Solved.xlsm

65.4 KB

24.2 64. Sensitivity analysis - Lecture - Solved.xlsm

918.8 KB

24.3 64. Sensitivity analysis - Lecture - Unsolved.xlsm

918.6 KB

24.4 64. Sensitivity-analysis-Exercise-Unsolved.xlsm

68.4 KB

25. Include sensitivity analysis in your models through Data Tables.html

0.2 KB

26. Excel's dynamic and interactive tables Pivot tables.mp4

24.3 MB

26. Excel's dynamic and interactive tables Pivot tables.srt

2.7 KB

26.1 65. Pivot tables - Lecture - Unsolved.xlsm

704.3 KB

26.2 65. Pivot Tables - Exercise - Solved.xlsx

195.0 KB

26.3 65. Pivot tables - Lecture - Solved.xlsm

918.8 KB

26.4 65. Pivot Tables - Exercise - Unsolved.xlsx

155.8 KB

27. Excel's key functions and functionalities made easy.html

0.2 KB

3. Key functions in Excel IF.mp4

17.5 MB

3. Key functions in Excel IF.srt

3.0 KB

3.1 Functions - English to German.pdf

104.8 KB

3.2 Functions - English to Spanish.pdf

104.8 KB

3.3 Functions - English to Portuguese.pdf

149.6 KB

3.4 47. IF-function--Lecture-before.xlsm

17.4 KB

3.5 47. IF-function-Lecture-after.xlsm

18.4 KB

3.6 Key functions - Excel.pdf

8.9 MB

4. Key Excel functions SUM, SUMIF and SUMIFS.mp4

20.3 MB

4. Key Excel functions SUM, SUMIF and SUMIFS.srt

5.4 KB

4.1 48. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx

14.8 KB

4.2 Excel-Functions.pdf

3.3 MB

4.3 48. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx

13.2 KB

4.4 48. Sum-Sumif-Sumifs-Lecture - Solved.xlsx

13.3 KB

4.5 48. Sum-Sumif-Sumifs-Exercise - Solved.xlsx

15.2 KB

5. = and + are interchangeable when you start typing a formula.mp4

6.1 MB

5. = and + are interchangeable when you start typing a formula.srt

1.0 KB

5.1 49. = and + are interchangeable - before.xlsm

17.4 KB

5.2 49. = and + are interchangeable -after.xlsm

17.4 KB

6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4

17.8 MB

6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.srt

4.9 KB

6.1 05 38 Counts Solved.xlsx

16.4 KB

6.2 05 38 Counts Exercise & Text.xlsx

16.0 KB

6.3 Lecture-Count-Countif-Countifs-Unsolved.xlsx

11.6 KB

6.4 Excel-Functions.pdf

3.3 MB

6.5 Lecture-Count-Countif-Countifs-Solved.xlsx

12.0 KB

7. Key Excel functions AVERAGE and AVERAGEIF.mp4

8.2 MB

7. Key Excel functions AVERAGE and AVERAGEIF.srt

2.4 KB

7.1 51. Average-AverageIF-Exercise - Unsolved.xlsx

15.0 KB

7.2 51. Average-Averageif- Lecture - Solved.xlsx

9.6 KB

7.3 51. Average-AverageIF-Exercise - Solved.xlsx

15.4 KB

7.4 Excel-Functions.pdf

3.3 MB

7.5 51. Average-Averageif- Lecture - Unsolved.xlsx

9.2 KB

8. Key Excel functions AVERAGE and AVERAGEIF.html

0.2 KB

9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4

17.6 MB

9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.srt

5.8 KB

9.1 52. Text functions - Exercise - Solved.xlsx

12.5 KB

9.2 52. Text functions - Exercise - Unsolved.xlsx

12.0 KB

9.3 52. Text-Functions- Lecture - Solved.xlsx

11.4 KB

9.4 52. Text-Functions- Lecture - Unsolved.xlsx

10.9 KB

[CourseClub.Me].url

0.0 KB

[DesireCourse.Net].url

0.1 KB

/6. Update! SUMIFS - Exercise/

1. Exercise - Excel's SUMIFS function - unsolved.html

0.2 KB

2. Exercise - Excel's SUMIFS function - solved & explained.mp4

37.0 MB

2. Exercise - Excel's SUMIFS function - solved & explained.srt

10.9 KB

2.1 67. Exercise-Sumifs-With-Solutions.xlsx

1.4 MB

/7. Financial functions in Excel/

1. Future and present values in Excel.mp4

15.7 MB

1. Future and present values in Excel.srt

7.1 KB

1.1 68. FV and PV-Lecture.xlsx

10.9 KB

2. Calculating the rate of return of an investment with the IRR function.mp4

7.9 MB

2. Calculating the rate of return of an investment with the IRR function.srt

3.7 KB

2.1 69. Exercise-IRR-Solved.xlsx

12.6 KB

2.2 69. Exercise-IRR-Unsolved.xlsx

11.8 KB

2.3 69. IRR-Lecture.xlsx

11.5 KB

3. Calculating a complete loan schedule in Excel.mp4

15.5 MB

3. Calculating a complete loan schedule in Excel.srt

6.7 KB

3.1 70. Exercise-Loan-Schedule-Unsolved.xlsx

16.2 KB

3.2 70. Exercise-Loan-Schedule-Solved.xlsx

23.2 KB

3.3 70. Loan Schedule-Lecture.xlsx

20.7 KB

4. Date functions in Excel.mp4

11.9 MB

4. Date functions in Excel.srt

5.9 KB

4.1 71. Date Functions-Exercise-Unsolved.xlsx

11.7 KB

4.2 71. Date Functions-Exercise-Solved.xlsx

12.7 KB

4.3 71. Date Functions-Lecture.xlsx

12.5 KB

/8. Microsoft Excel's Pivot Tables in depth/

1. Introduction to Pivot Tables and the way they are applied.mp4

6.3 MB

1. Introduction to Pivot Tables and the way they are applied.srt

2.1 KB

2. Creating Pivot Tables easily!.mp4

20.3 MB

2. Creating Pivot Tables easily!.srt

4.4 KB

2.1 73. Creating-a-Pivot-Table - Lecture – before.xlsx

1.3 MB

2.2 73. Creating-a-Pivot-Table - Lecture - after.xlsx

1.5 MB

3. Give your Excel Pivot Tables a makeover.mp4

11.8 MB

3. Give your Excel Pivot Tables a makeover.srt

2.4 KB

3.1 74. Formatting-a-Pivot-Table - Lecture - before.xlsx

1.5 MB

3.2 74. Formatting-a-Pivot-Table - Lecture - after.xlsx

1.5 MB

4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4

24.1 MB

4. Modifying and pivoting fields to obtain the Pivot Table you need.srt

4.9 KB

4.1 75. Working-with-Pivot-Tables - Lecture - after.xlsx

2.0 MB

4.2 75. Working-with-Pivot-Tables - Lecture - before.xlsx

1.5 MB

5. Learn more about GETPIVOTDATA - A very important Excel function.mp4

18.9 MB

5. Learn more about GETPIVOTDATA - A very important Excel function.srt

4.1 KB

5.1 76. GetPivotData - Lecture - before.xlsx

2.0 MB

5.2 76. GetPivotData - Lecture – after.xlsx

2.0 MB

6. An introduction to slicers - The modern-day Pivot Table filters.mp4

23.2 MB

6. An introduction to slicers - The modern-day Pivot Table filters.srt

4.9 KB

6.1 77. Slicers - Lecture - after.xlsx

2.0 MB

6.2 77. Slicers - Lecture - before.xlsx

2.0 MB

/9. Case study - Building a complete P&L from scratch in Excel/

1. Case study - Build a P&L from scratch - Welcome lecture.mp4

3.3 MB

1. Case study - Build a P&L from scratch - Welcome lecture.srt

1.6 KB

10. FAQ Sum of FY2018 doens't go down to zero.html

1.3 KB

11. Use INDEX & MATCH as a substitute for VLOOKUP.mp4

52.0 MB

11. Use INDEX & MATCH as a substitute for VLOOKUP.srt

4.4 KB

11.1 87. Index Match-Lecture-before.xlsm

42.0 KB

11.2 87. Index Match-Lecture-after.xlsm

14.5 MB

12. Mapping the rows in the database sheet.mp4

34.1 MB

12. Mapping the rows in the database sheet.srt

2.8 KB

12.1 88. Mapping-Lecture-after.xlsm

51.4 KB

12.2 88. Mapping_before.xlsm

51.8 KB

13. In case you have any doubts about the Mapping exercise.mp4

40.4 MB

13. In case you have any doubts about the Mapping exercise.srt

6.9 KB

13.1 89. Mapping-Lecture-Solved.xlsx

48.6 KB

13.2 89. Mapping-exercise-explained.pdf

248.9 KB

13.3 89. Mapping-Lecture-Unsolved.xlsm

51.8 KB

14. Building the structure of the P&L sheet.mp4

21.9 MB

14. Building the structure of the P&L sheet.srt

2.4 KB

14.1 90. Building a P&L-Lecture-before.xlsm

51.4 KB

14.2 90. Building a P&L-Lecture-after.xlsm

53.1 KB

15. Formatting sets You apart from the competition in Excel - A Practical Example.mp4

26.7 MB

15. Formatting sets You apart from the competition in Excel - A Practical Example.srt

3.5 KB

15.1 91. Formatting the P&L-Lecture-after.xlsm

53.2 KB

15.2 91. Formatting a P&L-Lecture-before.xlsm

53.1 KB

16. Populate the P&L sheet with SUMIF.mp4

31.7 MB

16. Populate the P&L sheet with SUMIF.srt

3.1 KB

16.1 92. Formatting the P&L-Lecture-after.xlsm

54.8 KB

16.2 92. Formatting the P&L-Lecture-before.xlsm

53.2 KB

17. FAQ Why the sum of the check should be 0.html

0.5 KB

18. Learn how to find mistakes with COUNTIF.mp4

29.2 MB

18. Learn how to find mistakes with COUNTIF.srt

2.9 KB

18.1 93. Countif-Lecture-before.xlsm

54.8 KB

18.2 93. Countif-Lecture-after.xlsm

56.1 KB

19. Calculating year-on-year percentage variations the proper way.mp4

31.4 MB

19. Calculating year-on-year percentage variations the proper way.srt

3.4 KB

19.1 94. Adding % variations-Lecture-after.xlsm

57.9 KB

19.2 Y-o-Y Function explanation.pdf

168.9 KB

19.3 94. Adding % variations-Lecture-before.xlsm

56.1 KB

2. Introduction to the case study.mp4

10.7 MB

2. Introduction to the case study.srt

1.1 KB

20. FAQ Why do we subtract -1 when calculating year-on-year growth.html

1.3 KB

3. Understand your data source before you start working on it.mp4

29.5 MB

3. Understand your data source before you start working on it.srt

3.2 KB

3.1 80. Get to know the data source.xlsm

44.1 KB

4. Order the source worksheets.mp4

27.8 MB

4. Order the source worksheets.srt

2.6 KB

4.1 81. Order a worksheet_after.xlsm

42.0 KB

4.2 81. Order a worksheet_before.xlsm

44.1 KB

5. Create a code the best way to organize your data and work efficiently with it.mp4

25.7 MB

5. Create a code the best way to organize your data and work efficiently with it.srt

2.3 KB

5.1 82. Creating a code_before.xlsm

42.0 KB

5.2 82. Creating a code_after.xlsm

42.7 KB

6. Learn how to create a database.mp4

21.7 MB

6. Learn how to create a database.srt

2.2 KB

6.1 83. Creating a database_before.xlsm

42.7 KB

6.2 83. Creating a database_after.xlsm

40.3 KB

7. Use VLOOKUP to fill the database sheet.mp4

64.6 MB

7. Use VLOOKUP to fill the database sheet.srt

5.7 KB

7.1 84. Vlookup_before.xlsm

40.5 KB

7.2 84. Vlookup_after.xlsm

45.5 KB

8. 50% completed!.mp4

4.5 MB

8. 50% completed!.srt

0.0 KB

9. Use SUMIF to complete the database sheet.mp4

50.3 MB

9. Use SUMIF to complete the database sheet.srt

4.5 KB

9.1 86. Sumif_before.xlsm

45.5 KB

9.2 86. Sumif_after.xlsm

50.7 KB

[CourseClub.Me].url

0.0 KB

[DesireCourse.Net].url

0.1 KB

/

[CourseClub.Me].url

0.0 KB

[DesireCourse.Net].url

0.1 KB

 

Total files 1053


Copyright © 2025 FileMood.com