资源详情

返回首页 | 相关搜索
[Tutorialsplanet.NET] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation
大小 3.99 GB
文件数 574
Info Hash: 4A18FFAC8C8C5777672D93A02657B7C9E1C7602B
收录时间 2026-02-04 03:02:56
更新时间 2026-02-04 03:02:56
文件列表 (574)
10. Introduction to Excel charts/3. Excel chart formatting.vtt
0 B
11/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4
128.34 MB
1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1.1 Course Notes - Beginner to Pro in Excel.pdf.pdf
3.05 MB
1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The best way to take this course.mp4
16.02 MB
10. Introduction to Excel charts/1. How to insert a chart in Excel.mp4
19.86 MB
10. Introduction to Excel charts/1.1 95. Inserting-Charts-Lecture.xlsm.xlsm
11.45 MB
10. Introduction to Excel charts/2. Editing Excel charts.mp4
26.05 MB
10. Introduction to Excel charts/2. Editing Excel charts.vtt
2.9 KB
10. Introduction to Excel charts/2.1 96. Formatting-a-Chart-Lecture.xlsm.xlsm
11.45 MB
10. Introduction to Excel charts/3. Excel chart formatting.mp4
28.63 MB
1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp4
8.94 MB
10. Introduction to Excel charts/4. How to create a bridge chart in Excel.mp4
12.48 MB
10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.mp4
11.49 MB
10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.vtt
1.67 KB
10. Introduction to Excel charts/5.1 99. Treemap-Charts-Lecture.xlsx.xlsx
12.62 KB
10. Introduction to Excel charts/6. Sparklines.mp4
27.56 MB
10. Introduction to Excel charts/6. Sparklines.vtt
4.17 KB
10. Introduction to Excel charts/6.1 100. Sparklines-Lecture.xlsx.xlsx
9.59 KB
11/1. Create professional and good-looking charts - Introduction.mp4
6.21 MB
11/1. Create professional and good-looking charts - Introduction.vtt
727 B
11/2. Build a column stacked chart with a secondary line axis in Excel.mp4
46.37 MB
11/2. Build a column stacked chart with a secondary line axis in Excel.vtt
5.63 KB
11/2.1 102. Column stacked chart-Lecture-before.xlsm.xlsm
11.5 MB
11/2.2 102. Column stacked chart-Lecture-after.xlsm.xlsm
7.65 MB
11/3. Learn how to build effective doughnut charts in Excel.mp4
32.14 MB
11/3.1 103. Doughnut chart-Lecture-after.xlsm.xlsm
10.13 MB
11/3.2 103. Doughnut chart-Lecture-before.xlsm.xlsm
10.62 MB
11/4. Learn how to build an area chart in Excel.mp4
28.58 MB
11/4. Learn how to build an area chart in Excel.vtt
3.48 KB
11/4.1 104. Area chart-Lecture-after.xlsm.xlsm
10.52 MB
11/5. Learn how to create bridge charts.mp4
52.07 MB
11/5. Learn how to create bridge charts.vtt
7.45 KB
11/5.1 105. Bridge chart-Lecture-after.xlsm.xlsm
11.54 MB
11/5.2 105. Bridge chart-Lecture-before.xlsm.xlsm
7.87 MB
1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.vtt
3.11 KB
11/8. Course Challenge - Apply your skills in practice!.mp4
7.92 MB
11/8. Course Challenge - Apply your skills in practice!.vtt
1.17 KB
11/8.1 107. Course-Challenge - Solved.xlsx.xlsx
543.93 KB
11/8.2 107. Course-Challenge - Unsolved.xlsx.xlsx
505.49 KB
12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.mp4
12.06 MB
12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.vtt
2.45 KB
12. Case Study - Building an FMCG Model from Scratch/1.1 108. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx.xlsx
11.2 MB
12. Case Study - Building an FMCG Model from Scratch/10. Combining Slicers and GETPIVOTDATA The key to our success.mp4
17.84 MB
12. Case Study - Building an FMCG Model from Scratch/10. Combining Slicers and GETPIVOTDATA The key to our success.vtt
3.4 KB
12. Case Study - Building an FMCG Model from Scratch/10.1 117. Exercise-Build-an-FMCG-Model-Inserting-Slicers-Lecture.xlsx.xlsx
16.1 MB
12. Case Study - Building an FMCG Model from Scratch/11.1 118. Exercise-Build-an-FMCG-Model-Complete-Lecture.xlsx.xlsx
22.81 MB
12. Case Study - Building an FMCG Model from Scratch/12. This is how the report can be used in practice by high-level executives.mp4
19.81 MB
12. Case Study - Building an FMCG Model from Scratch/12. This is how the report can be used in practice by high-level executives.vtt
4.38 KB
12. Case Study - Building an FMCG Model from Scratch/12.1 119. Exercise-Build-an-FMCG-Model-Complete.xlsx.xlsx
19.57 MB
12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.mp4
22.6 MB
12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.vtt
2.43 KB
12. Case Study - Building an FMCG Model from Scratch/2.1 109. Exercise-Build-an-FMCG-Model-Mapping-Lecture.xlsx.xlsx
14.16 MB
12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp4
21.95 MB
12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.vtt
3.84 KB
12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.mp4
11.65 MB
12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.vtt
2.8 KB
12. Case Study - Building an FMCG Model from Scratch/4.1 111. Exercise-Build-an-FMCG-Model-Structure-Lecture.xlsx.xlsx
14.91 MB
12. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.mp4
6.75 MB
12. Case Study - Building an FMCG Model from Scratch/5.1 112. Exercise-Build-an-FMCG-Model-Formatting-Lecture.xlsx.xlsx
9.24 MB
12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.mp4
8.84 MB
12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.vtt
4.63 KB
12. Case Study - Building an FMCG Model from Scratch/6.1 113. Exercise-Build-an-FMCG-Model-Adding-Calculations-Lecture.xlsx.xlsx
5.49 MB
12. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.mp4
13.83 MB
12. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.vtt
2.1 KB
12. Case Study - Building an FMCG Model from Scratch/7.1 114. Exercise-Build-an-FMCG-Model-Creating-a-Pivot-Table-Lecture.xlsx.xlsx
20.81 MB
12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4
31.04 MB
12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.vtt
6.68 KB
12. Case Study - Building an FMCG Model from Scratch/8.1 115. Exercise-Build-an-FMCG-Model-GETPIVOTDATA-Lecture.xlsx.xlsx
16.89 MB
12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4
13.76 MB
12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.vtt
1.48 KB
13. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.mp4
2.1 MB
13. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.vtt
1.07 KB
13. Financial Modeling Fundamentals/10. Forecasting financials - Quiz.html
160 B
13. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.mp4
6.44 MB
13. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.vtt
2.72 KB
13. Financial Modeling Fundamentals/12. Modeling the Income statement.mp4
1.79 MB
13. Financial Modeling Fundamentals/3. Why use financial models.mp4
7.69 MB
13. Financial Modeling Fundamentals/3. Why use financial models.vtt
3.11 KB
13. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.mp4
19.91 MB
13. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.vtt
6.86 KB
13. Financial Modeling Fundamentals/5. Financial modeling - best practices.mp4
17.22 MB
13. Financial Modeling Fundamentals/5. Financial modeling - best practices.vtt
5.69 KB
13. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.mp4
12.51 MB
13. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.vtt
5.49 KB
13. Financial Modeling Fundamentals/7. Financial modeling - Quiz.html
160 B
13. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.mp4
5.68 MB
13. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.vtt
2.93 KB
13. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.mp4
6.44 MB
13. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.vtt
3.34 KB
14. Introduction to Company Valuation/1. The core theory behind Company Valuation.html
164 B
15. Introduction to Mergers & Acquisitions/1. Introduction to Mergers & Acquisitions.html
164 B
16/1. Valuation Case study - Welcome lecture.mp4
1.78 MB
16/1. Valuation Case study - Welcome lecture.vtt
869 B
16/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4
30.01 MB
16/10. Modeling other items Interest expenses, Extraordinary items and Taxes.vtt
2.92 KB
16/10.1 9. Interest expenses, taxes_before.xlsm.xlsm
50.57 KB
16/10.2 9. Interest expenses, taxes_after.xlsm.xlsm
50.89 KB
16/11. Forecasting Balance sheet items.mp4
4.66 MB
16/11. Forecasting Balance sheet items.vtt
914 B
16/11.1 10. Introduction to Balance sheet items.xlsm.xlsm
51.02 KB
16/12. An introduction to the Days methodology.mp4
73.78 KB
16/14. Forecasting DSO, DPO and DOI.mp4
20.86 MB
16/14. Forecasting DSO, DPO and DOI.vtt
2.73 KB
16/14.1 13. Forecasting DSO, DPO, DIO_before.xlsm.xlsm
51.47 KB
16/14.2 13. Forecasting DSO, DPO, DIO_after.xlsm.xlsm
51.98 KB
16/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4
22.63 MB
16/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.vtt
2.6 KB
16/15.1 14. Forecasting PP&E, Other assets, and Other liabilities_after.xlsm.xlsm
52.88 KB
16/15.2 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm.xlsm
51.98 KB
16/16. Creating an output P&L sheet.mp4
18.8 MB
16/16. Creating an output P&L sheet.vtt
2.32 KB
16/16.1 15. P&L structure_after.xlsm.xlsm
53.67 KB
16/16.2 15. P&L structure_before.xlsm.xlsm
53.6 KB
16/17. Populating the output P&L sheet.mp4
25.53 MB
16/17. Populating the output P&L sheet.vtt
2.44 KB
16/17.1 16. Populating the P&L sheet_after.xlsm.xlsm
55.32 KB
16/17.2 16. Populating the P&L sheet_before.xlsm.xlsm
53.67 KB
16/18. Populating the output BS sheet.mp4
16.93 MB
16/18. Populating the output BS sheet.vtt
1.75 KB
16/18.1 17. Populating BS sheet_before.xlsm.xlsm
55.32 KB
16/18.2 17. Populating BS sheet_after.xlsm.xlsm
57.18 KB
16/19. Completing the output BS sheet for the historical period.mp4
36.4 MB
16/20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp4
22.38 MB
16/21. Bridging Unlevered free cash flow to Net cash flow.mp4
14.58 MB
16/21. Bridging Unlevered free cash flow to Net cash flow.vtt
2.11 KB
16/21.1 20. Bridge UFCF to Net cash flow_before.xlsm.xlsm
58.58 KB
16/21.2 20. Bridge UFCF to Net cash flow_after.xlsm.xlsm
58.7 KB
16/22. Calculating Unlevered free cash flow.mp4
59.72 MB
16/22. Calculating Unlevered free cash flow.vtt
6.63 KB
16/22.1 21. Calculating UFCF_after.xlsm.xlsm
59.18 KB
16/22.2 21. Calculating UFCF_before.xlsm.xlsm
58.66 KB
16/23. Calculating Net cash flow.mp4
35.62 MB
16/24. Obtaining the rest of the cash flows through Find and Replace.mp4
46.73 MB
16/24. Obtaining the rest of the cash flows through Find and Replace.vtt
4.18 KB
16/24.1 23. Find and replace_after.xlsm.xlsm
62.5 KB
16/24.2 23. Find and replace_before.xlsm.xlsm
59.55 KB
16/25. Introducing Weighted average cost of capital and Perpetuity growth.mp4
4.03 MB
16/26. Discounting Unlevered free cash flows to obtain their Present value.mp4
20.22 MB
16/26. Discounting Unlevered free cash flows to obtain their Present value.vtt
2.99 KB
16/26.1 25. Calculating PV of Cash Flows_after.xlsm.xlsm
62.71 KB
16/26.2 25. Calculating PV of Cash Flows_before.xlsm.xlsm
62.58 KB
16/27. Calculating Continuing value and Enterprise value of the business.mp4
17.72 MB
16/27. Calculating Continuing value and Enterprise value of the business.vtt
2.33 KB
16/27.1 26. Calculating CV and EV_after.xlsm.xlsm
63.1 KB
16/27.2 26. Calculating CV and EV_before.xlsm.xlsm
62.71 KB
16/28. Calculating Equity value.mp4
522.65 KB
16/29. Sensitivity analysis for WACC and perpetuity growth.mp4
40.48 MB
16/29. Sensitivity analysis for WACC and perpetuity growth.vtt
4.56 KB
16/29.1 28. Sensitivity analysis_before.xlsm.xlsm
63.27 KB
16/29.2 28. Sensitivity analysis_after.xlsm.xlsm
64.83 KB
16/29.3 Sensitivity Analysis.xlsx
60.81 KB
16/3. The stages of a complete DCF Valuation.mp4
49.24 MB
16/3. The stages of a complete DCF Valuation.vtt
6.61 KB
16/3.1 Valuation exercise.pdf.pdf
411.76 KB
16/30. A possible application of Goal seek.mp4
15.62 MB
16/30. A possible application of Goal seek.vtt
1.94 KB
16/30.1 29. Goal seek_before.xlsm.xlsm
64.83 KB
16/30.2 29. Goal seek_ater.xlsm.xlsm
64.84 KB
16/31. Using charts to summarize the results of the DCF model.mp4
32.88 MB
16/31.1 30. Charts.xlsm.xlsm
101.22 KB
16/32. You made it!.mp4
11.27 MB
16/32. You made it!.vtt
2.9 KB
16/4. Description of the structure of the DCF model.mp4
13.88 MB
16/5. A glimpse at the company we are valuing - Cheeseco.mp4
15.67 MB
16/5. A glimpse at the company we are valuing - Cheeseco.vtt
1.35 KB
16/5.1 Cheeseco.pptx.pptx
80.09 KB
16/6. Modeling the top line.mp4
11.32 MB
16/8. Modeling other items Other revenues and Cogs.mp4
42.99 MB
16/9.1 8. Opex and D&A_before.xlsm.xlsm
50.08 KB
16/9.2 8. Opex and D&A_after.xlsm.xlsm
50.57 KB
17. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.mp4
3.9 MB
17. Tesla valuation - Complete practical exercise/1.1 Tesla 2017.pdf.pdf
2.51 MB
17. Tesla valuation - Complete practical exercise/1.2 Tesla 2016.pdf.pdf
2.21 MB
17. Tesla valuation - Complete practical exercise/1.3 0a. Drivers_before.xlsx.xlsx
1.27 MB
17. Tesla valuation - Complete practical exercise/1.4 Tesla 2018 Q2.pdf.pdf
635.07 KB
17. Tesla valuation - Complete practical exercise/1.5 Tesla Company Valuation - Detailed walkthrough.pdf.pdf
2.27 MB
17. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4
14.64 MB
17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp4
33.13 MB
17. Tesla valuation - Complete practical exercise/12.2 8. Opex - After.xlsx.xlsx
1.36 MB
17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp4
47.5 MB
17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp4
54.2 MB
17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.vtt
4.13 KB
17. Tesla valuation - Complete practical exercise/14.1 10. PP&E schedule_after.xlsx.xlsx
1.37 MB
17. Tesla valuation - Complete practical exercise/14.2 10. PP&E schedule_before.xlsx.xlsx
1.37 MB
17. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.mp4
13.61 MB
17. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.vtt
1.62 KB
17. Tesla valuation - Complete practical exercise/15.1 10a. PP&E comparison.xlsx.xlsx
1.37 MB
17. Tesla valuation - Complete practical exercise/16. Calculating DSO, DIO, DPO.mp4
16.24 MB
17. Tesla valuation - Complete practical exercise/18. Fill in the P&L output sheet.mp4
17.99 MB
17. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.mp4
19.03 MB
17. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.vtt
2.09 KB
17. Tesla valuation - Complete practical exercise/19.1 13. Calculating working capital_after.xlsx.xlsx
1.4 MB
17. Tesla valuation - Complete practical exercise/19.2 13. Calculating working capital_before.xlsx.xlsx
1.4 MB
17. Tesla valuation - Complete practical exercise/2. The input data we will work with.mp4
15.05 MB
17. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered free cash flow.mp4
55.93 MB
17. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered free cash flow.vtt
5.79 KB
17. Tesla valuation - Complete practical exercise/20.1 14. Cash flow - UFCF_after.xlsx.xlsx
1.41 MB
17. Tesla valuation - Complete practical exercise/20.2 14. Cash flow - UFCF_before.xlsx.xlsx
1.41 MB
17. Tesla valuation - Complete practical exercise/21. Forecasting other assets.mp4
45.24 MB
17. Tesla valuation - Complete practical exercise/21. Forecasting other assets.vtt
4.33 KB
17. Tesla valuation - Complete practical exercise/21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx
1.41 MB
17. Tesla valuation - Complete practical exercise/21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx
1.41 MB
17. Tesla valuation - Complete practical exercise/22. Forecasting other liabilities.mp4
21.84 MB
17. Tesla valuation - Complete practical exercise/23. Completing Unlevered free cash flow.mp4
33.05 MB
17. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.mp4
42.35 MB
17. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.vtt
5.04 KB
17. Tesla valuation - Complete practical exercise/24.1 17. Financing_before.xlsx.xlsx
1.43 MB
17. Tesla valuation - Complete practical exercise/24.2 17. Financing_after.xlsx.xlsx
1.43 MB
17. Tesla valuation - Complete practical exercise/25. Calculating Net income.mp4
14.8 MB
17. Tesla valuation - Complete practical exercise/25. Calculating Net income.vtt
1.29 KB
17. Tesla valuation - Complete practical exercise/25.1 18. P&L complete_before.xlsx.xlsx
1.43 MB
17. Tesla valuation - Complete practical exercise/25.2 18. P&L complete_after.xlsx.xlsx
1.43 MB
17. Tesla valuation - Complete practical exercise/26. Bridging Unlevered free cash flow to Net cash flow.mp4
50.72 MB
17. Tesla valuation - Complete practical exercise/26. Bridging Unlevered free cash flow to Net cash flow.vtt
4.17 KB
17. Tesla valuation - Complete practical exercise/26.1 19. Cash flow_complete_after.xlsx.xlsx
1.43 MB
17. Tesla valuation - Complete practical exercise/26.2 19. Cash flow_complete_before.xlsx.xlsx
1.43 MB
17. Tesla valuation - Complete practical exercise/27. Balancing the Balance sheet.mp4
13.27 MB
17. Tesla valuation - Complete practical exercise/27. Balancing the Balance sheet.vtt
1.12 KB
17. Tesla valuation - Complete practical exercise/27.1 20. Complete the BS_before.xlsx.xlsx
1.43 MB
17. Tesla valuation - Complete practical exercise/27.2 20. Complete the BS_after.xlsx.xlsx
1.43 MB
17. Tesla valuation - Complete practical exercise/28. Estimating Weighted average cost of capital (WACC).mp4
32.71 MB
17. Tesla valuation - Complete practical exercise/28.1 21. WACC_before.xlsx.xlsx
1.43 MB
17. Tesla valuation - Complete practical exercise/28.2 21. WACC_after.xlsx.xlsx
1.43 MB
17. Tesla valuation - Complete practical exercise/29. Performing discounted cash flow valuation (DCF).mp4
34.9 MB
17. Tesla valuation - Complete practical exercise/29. Performing discounted cash flow valuation (DCF).vtt
3.83 KB
17. Tesla valuation - Complete practical exercise/29.1 22. DCF_after.xlsx.xlsx
1.44 MB
17. Tesla valuation - Complete practical exercise/29.2 22. DCF_before.xlsx.xlsx
1.23 MB
17. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.mp4
99.71 MB
17. Tesla valuation - Complete practical exercise/3.1 1. Deliveries_before.xlsx.xlsx
1.29 MB
17. Tesla valuation - Complete practical exercise/3.2 1. Deliveries_after.xlsx.xlsx
1.29 MB
17. Tesla valuation - Complete practical exercise/30. Calculating enterprise value, equity value, and price per share.mp4
22.55 MB
17. Tesla valuation - Complete practical exercise/30. Calculating enterprise value, equity value, and price per share.vtt
2.01 KB
17. Tesla valuation - Complete practical exercise/30.1 23. EV, Equity value, Price per share_before.xlsx.xlsx
1.44 MB
17. Tesla valuation - Complete practical exercise/30.2 23. EV, Equity value, Price per share_after.xlsx.xlsx
1.44 MB
17. Tesla valuation - Complete practical exercise/31. Final comments.mp4
44.88 MB
17. Tesla valuation - Complete practical exercise/31. Final comments.vtt
4.18 KB
17. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.mp4
19.91 MB
17. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.mp4
37.66 MB
17. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.mp4
45.13 MB
17. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.mp4
15.95 MB
17. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.mp4
25.45 MB
17. Tesla valuation - Complete practical exercise/8.2 4a. Gross profit automotive - after.xlsx.xlsx
1.32 MB
17. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.mp4
6.84 MB
18. Capital budgeting - The theory/1. Introduction to Capital budgeting.mp4
5.43 MB
18. Capital budgeting - The theory/1. Introduction to Capital budgeting.vtt
1.79 KB
18. Capital budgeting - The theory/2. Why we need Capital budgeting.mp4
6.57 MB
18. Capital budgeting - The theory/4. Calculating future and present Value.mp4
13.08 MB
18. Capital budgeting - The theory/4. Calculating future and present Value.vtt
6.27 KB
18. Capital budgeting - The theory/5. Calculating cost of equity.mp4
19.21 MB
18. Capital budgeting - The theory/5. Calculating cost of equity.vtt
7.44 KB
18. Capital budgeting - The theory/6. Coming up with project-specific beta.mp4
684.53 KB
18. Capital budgeting - The theory/8. The type of cash flows we will have in a project.mp4
9.34 MB
18. Capital budgeting - The theory/8. The type of cash flows we will have in a project.vtt
3.88 KB
18. Capital budgeting - The theory/9. Estimating the project's cash flows.mp4
18.79 MB
18. Capital budgeting - The theory/9. Estimating the project's cash flows.vtt
6.68 KB
19. Capital Budgeting - A Complete Case Study/1. Introduction to the Capital budgeting exercise.mp4
8.63 MB
19. Capital Budgeting - A Complete Case Study/1. Introduction to the Capital budgeting exercise.vtt
3.23 KB
19. Capital Budgeting - A Complete Case Study/10. Finding cost of equity.mp4
13.92 MB
19. Capital Budgeting - A Complete Case Study/10. Finding cost of equity.vtt
7.16 KB
19. Capital Budgeting - A Complete Case Study/10.1 8. WACC_unsolved.xlsx.xlsx
35.93 KB
19. Capital Budgeting - A Complete Case Study/10.2 8. WACC.xlsx.xlsx
38.03 KB
19. Capital Budgeting - A Complete Case Study/11. Discounting the project's cash flows and residual value.mp4
23.37 MB
19. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and completing the exercise.mp4
41.39 MB
19. Capital Budgeting - A Complete Case Study/14. Congratulations!!.mp4
2.3 MB
19. Capital Budgeting - A Complete Case Study/14. Congratulations!!.vtt
1.5 KB
19. Capital Budgeting - A Complete Case Study/2. Organizing an Inputs sheet.mp4
11.05 MB
19. Capital Budgeting - A Complete Case Study/2. Organizing an Inputs sheet.vtt
6.22 KB
19. Capital Budgeting - A Complete Case Study/2.1 1. Drivers.xlsx.xlsx
11.5 KB
19. Capital Budgeting - A Complete Case Study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4
9.21 MB
19. Capital Budgeting - A Complete Case Study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.vtt
4.12 KB
19. Capital Budgeting - A Complete Case Study/3.1 2. Savings Forecast.xlsx.xlsx
16.58 KB
19. Capital Budgeting - A Complete Case Study/3.2 2. Savings Forecast_unsolved.xlsx.xlsx
14.74 KB
19. Capital Budgeting - A Complete Case Study/4. Fixed asset rollforward.mp4
12.15 MB
19. Capital Budgeting - A Complete Case Study/4. Fixed asset rollforward.vtt
5.28 KB
19. Capital Budgeting - A Complete Case Study/4.1 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx
18.54 KB
19. Capital Budgeting - A Complete Case Study/4.2 3. Fixed Asset Rollforward.xlsx.xlsx
19.66 KB
19. Capital Budgeting - A Complete Case Study/5. The impact of working capital.mp4
5.37 MB
19. Capital Budgeting - A Complete Case Study/5. The impact of working capital.vtt
2.85 KB
19. Capital Budgeting - A Complete Case Study/5.1 4. Working Capital.xlsx.xlsx
21.93 KB
19. Capital Budgeting - A Complete Case Study/5.2 4. Working Capital_unsolved.xlsx.xlsx
21.19 KB
19. Capital Budgeting - A Complete Case Study/6. Modeling debt financing.mp4
6.18 MB
19. Capital Budgeting - A Complete Case Study/6. Modeling debt financing.vtt
3.3 KB
19. Capital Budgeting - A Complete Case Study/6.1 5. Financing_unsolved.xlsx.xlsx
29.99 KB
19. Capital Budgeting - A Complete Case Study/6.2 5. Financing.xlsx.xlsx
30.97 KB
19. Capital Budgeting - A Complete Case Study/7. Adding a P&L sheet.mp4
4.88 MB
19. Capital Budgeting - A Complete Case Study/7. Adding a P&L sheet.vtt
2.12 KB
19. Capital Budgeting - A Complete Case Study/7.1 6. P&L.xlsx.xlsx
31.03 KB
19. Capital Budgeting - A Complete Case Study/7.2 6. P&L_unsolved.xlsx.xlsx
29.7 KB
19. Capital Budgeting - A Complete Case Study/8. Calculating project cash flows.mp4
2.87 MB
2. Introduction to Excel/11. Introduction to Excel functions.mp4
9 MB
2. Introduction to Excel/11.3 Introduction-to-Excels-basic-features.pdf.pdf
2.27 MB
2. Introduction to Excel/11.4 13. Functions- Lecture - Unsolved.xlsx.xlsx
9.24 KB
2. Introduction to Excel/11.5 13. Functions-Exercise - Unsolved.xlsx.xlsx
13.26 KB
2. Introduction to Excel/12. Cut, copy, & paste.mp4
6.57 MB
2. Introduction to Excel/14.3 Introduction-to-Excels-basic-features.pdf.pdf
2.27 MB
2. Introduction to Excel/15. Basic operations in Excel - 38 pages.html
164 B
2. Introduction to Excel/2. Overview of Excel.mp4
7.72 MB
2. Introduction to Excel/2.1 7. Introduction to Excel.pdf.pdf
2.26 MB
2. Introduction to Excel/2.2 7. Overview-of-Excel-Exercise-Solved.xlsx.xlsx
10.88 KB
2. Introduction to Excel/2.3 7. Overview-of-Excel-Exercise-Unsolved.xlsx.xlsx
10.47 KB
2. Introduction to Excel/3. Overview of Excel.html
160 B
2. Introduction to Excel/4. Basic manipulations with rows and columns.mp4
3.49 MB
2. Introduction to Excel/6. The Excel ribbon.mp4
8.81 MB
2. Introduction to Excel/6. The Excel ribbon.vtt
2.99 KB
2. Introduction to Excel/6.1 9. The-Ribbon-Exercise-Solved.xlsx.xlsx
403.25 KB
2. Introduction to Excel/6.2 9. The-Ribbon-Exercise-Exercise - Unsolved.xlsx.xlsx
12.09 KB
2. Introduction to Excel/7. Data entry in Excel.mp4
10.39 MB
2. Introduction to Excel/7. Data entry in Excel.vtt
3.32 KB
2. Introduction to Excel/7.1 10. Data-Entry - Lecture.xlsx.xlsx
8.07 KB
2. Introduction to Excel/7.2 10. Data-Entry-Exercise - Unsolved.xlsx.xlsx
10.97 KB
2. Introduction to Excel/7.3 10. Data-Entry- Exercise -Solved.xlsx.xlsx
32.76 KB
2. Introduction to Excel/8. Introduction to formatting.mp4
24.75 MB
2. Introduction to Excel/8. Introduction to formatting.vtt
6.14 KB
2. Introduction to Excel/8.1 11. Formatting - Lecture - Solved.xlsx.xlsx
9.85 KB
2. Introduction to Excel/8.2 11. Formatting-Exercise - Unsolved.xlsx.xlsx
11.61 KB
2. Introduction to Excel/8.3 11. Formatting- Exercise - Solved.xlsx.xlsx
11.59 KB
2. Introduction to Excel/8.4 11. Formatting- Lecture - Unsolved.xlsx.xlsx
8.91 KB
2. Introduction to Excel/9. Introduction to Excel formulas.mp4
20.07 MB
3/11.5 Useful-Tips-Tools.pdf.pdf
3.31 MB
3/12. Create easily printable documents in Excel by using Set Print Area.mp4
4.74 MB
3/12. Create easily printable documents in Excel by using Set Print Area.vtt
1.5 KB
3/12.1 25. Set-Print-Area-Lecture - Unsolved.xlsx.xlsx
11.42 KB
3/12.2 25. Set-Print-Area-Lecture - Solved.xlsx.xlsx
11.22 KB
3/12.3 Useful-Tips-Tools.pdf.pdf
3.31 MB
3/13. Find and select special types of cells with Select Special (F5).mp4
6.31 MB
3/13.4 Useful-Tips-Tools.pdf.pdf
3.31 MB
3/14. Select Special.html
160 B
3/15. Learn how to assign dynamic names within a financial model.mp4
7.32 MB
3/15. Learn how to assign dynamic names within a financial model.vtt
1.56 KB
3/15.1 27. Dynamic-Naming-Lecture - Unsolved.xlsx.xlsx
13.54 KB
3/15.2 Useful-Tips-Tools.pdf.pdf
1.83 MB
3/18.2 Useful-Tips-Tools.pdf.pdf
3.3 MB
3/18.3 29. Assigning Custom Formats - Exercise - Solved.xlsx.xlsx
11.08 KB
3/19. Macros are a great timesaver! Here's why!.mp4
4.95 MB
3/19.1 Useful-Tips-Tools.pdf.pdf
3.3 MB
3/19.2 30. Creating-a-Macro-Lecture - Solved.xlsx.xlsx
11.17 KB
3/19.3 30. Macros-Exercise - Solved.xlsx.xlsx
145.02 KB
3/19.4 30. Creating-a-Macro-Lecture - Unsolved.xlsx.xlsx
9.66 KB
3/19.5 30. Macros-Exercise - Unsolved.xlsx.xlsx
10.34 KB
3/2. Initial formatting of an Excel sheet to render it professional.mp4
7.99 MB
3/2. Initial formatting of an Excel sheet to render it professional.vtt
2.16 KB
3/2.1 18. Formatting-a-Worksheet-Exercise - Unsolved.xlsx.xlsx
10.63 KB
3/2.2 18. Formatting-a-Worksheet-Exercise - Solved.xlsx.xlsx
10.76 KB
3/2.3 Useful-Tips-Tools.pdf.pdf
3.3 MB
3/2.4 18. Formatting-a-worksheet-Lecture - Solved.xlsx.xlsx
9.56 KB
3/2.5 18. Formatting-a-worksheet-Lecture - Unsolved.xlsx.xlsx
8.98 KB
3/20. How to save macros and use them across several workbooks.mp4
12.78 MB
3/20. How to save macros and use them across several workbooks.vtt
1.72 KB
3/20.1 31. Another-file.xlsx.xlsx
8.81 KB
3/20.2 31. How-to-save-macros-Lecture-before.xlsx.xlsx
6.02 KB
3/20.3 31. How-to-save-macros-Lecture-after.xlsm.xlsm
12.59 KB
3/21. Excel Macros - quiz.html
160 B
3/22. Create a drop-down list by using Data Validation.mp4
10.23 MB
3/23. Using Custom-sort in order to sort multiple columns within a table.mp4
8.22 MB
3/23.4 Useful-Tips-Tools.pdf.pdf
3.31 MB
3/23.5 33. Custom-Sort-Exercise - Solved.xlsx.xlsx
11.46 KB
3/24. Create a great Index page at the beginning of your models - Hyperlinks.mp4
5.35 MB
3/24. Create a great Index page at the beginning of your models - Hyperlinks.vtt
1.51 KB
3/24.1 34. Hyperlinks-Exercise - Unsolved.xlsx.xlsx
136.89 KB
3/24.2 34. Hyperlinks-Exercise - Solved.xlsx.xlsx
137.06 KB
3/24.3 Useful-Tips-Tools.pdf.pdf
1.83 MB
3/25. Fix the top row of your table with Freeze Panes.mp4
17.67 MB
3/25. Fix the top row of your table with Freeze Panes.vtt
1.42 KB
3/25.1 35. Freeze-Panes-Lecture - Unsolved.xlsx.xlsx
643.87 KB
3/25.2 35. Freeze-Panes-Lecture - Solved.xlsx.xlsx
643.94 KB
3/25.3 Useful-Tips-Tools.pdf.pdf
3.31 MB
3/26. Filter by color - an excellent tool.mp4
9.88 MB
3/26. Filter by color - an excellent tool.vtt
1.99 KB
3/26.1 36. Exercise-Filter-by-Color-Unsolved.xlsx.xlsx
20.47 KB
3/26.2 36. Exercise-Filter-by-Color-Solved.xlsx.xlsx
153.48 KB
3/27. Working with conditional formatting.mp4
14.23 MB
3/28. A neat trick - Multiply by 1.mp4
14.84 MB
3/28. A neat trick - Multiply by 1.vtt
1.64 KB
3/28.1 38. Multiply-by-1-Lecture-before.xlsx.xlsx
16.47 KB
3/28.2 38. Multiply-by-1-Lecture-after.xlsx.xlsx
17.21 KB
3/29. Useful tips and tools for your work in Excel - quiz.html
159 B
3/3. Fast scrolling through Excel sheets.mp4
22.16 MB
3/3. Fast scrolling through Excel sheets.vtt
1.73 KB
3/3.1 Useful-Tips-Tools.pdf.pdf
3.31 MB
3/3.2 19. Fast-Scrolling-Exercise - Unsolved.xlsx.xlsx
43.9 KB
3/3.3 19. Fast-Scrolling-Exercise - Solved.xlsx.xlsx
44.35 KB
3/3.4 19. Fast-Scrolling - Lecture.xlsx.xlsx
642.82 KB
3/30. Find and replace - references.mp4
24.04 MB
3/30. Find and replace - references.vtt
3.32 KB
3/30.1 39. Find-and-Replace-references-Lecture-after.xlsx.xlsx
37.91 KB
3/30.2 39. Find-and-Replace-references-Lecture-before.xlsx.xlsx
38.79 KB
3/31. Find and replace - formatting.mp4
13.78 MB
3/31. Find and replace - formatting.vtt
1.88 KB
3/31.1 40. Find-replace-Lecture-before.xlsx.xlsx
17.19 KB
3/31.2 40. Find-replace-Lecture-after.xlsx.xlsx
17.19 KB
3/32. Removing (automatic) green arrows.mp4
12.6 MB
3/32. Removing (automatic) green arrows.vtt
1.63 KB
3/32.1 41. Green-references-Lecture.xlsx.xlsx
12 KB
3/33. Beauty saving - The professional way of saving files.mp4
14.02 MB
3/33. Beauty saving - The professional way of saving files.vtt
2.59 KB
3/33.1 42. Beauty-saving-Lecture-before.xlsx.xlsx
17.17 KB
3/33.2 42. Beauty-saving-Lecture-after.xlsx.xlsx
17.05 KB
3/34. Formula auditing with F2.mp4
17.74 MB
3/34. Formula auditing with F2.vtt
2.14 KB
3/34.1 43. F2-Lecture.xlsm.xlsm
50.76 KB
3/4. Be even quicker F5 + Enter.mp4
19.78 MB
3/4. Be even quicker F5 + Enter.vtt
2.11 KB
3/4.1 20. F5-go-to - Lecture.xlsm.xlsm
50.76 KB
3/5. Fast scrolling through Excel sheets.html
160 B
3/6. Introduction to fixing of cell references.mp4
20.37 MB
3/6. Introduction to fixing of cell references.vtt
2.53 KB
3/6.1 Useful-Tips-Tools.pdf.pdf
3.31 MB
3/6.2 21. Fixing-Cells-Exercise - Unsolved.xlsx.xlsx
10.67 KB
3/6.3 21. Fixing-references-Lecture - Unsolved.xlsx.xlsx
643.98 KB
3/6.4 21. Fixing-Cells-Exercise - Solved.xlsx.xlsx
10.82 KB
3/6.5 21. Fixing-references-Lecture - Solved.xlsx.xlsx
645.17 KB
3/7. Introduction to fixing of cell references.html
160 B
3/8. Using the 'Alt + Enter' combination.mp4
3.33 MB
3/8. Using the 'Alt + Enter' combination.vtt
1008 B
3/8.1 22. Alt-Enter-Exercise - Unsolved.xlsx.xlsx
11.12 KB
3/8.2 22. Alt-Enter- Lecture - Unsolved.xlsx.xlsx
9.64 KB
3/8.3 22. Alt-Enter- Lecture - Solved.xlsx.xlsx
9.65 KB
3/8.4 22. Alt-Enter-Exercise - Solved.xlsx.xlsx
11.4 KB
3/9. Learn how to organize your data with Text to Columns.mp4
12.54 MB
3/9. Learn how to organize your data with Text to Columns.vtt
2.21 KB
3/9.1 23. Text-to-Columns-Exercise - Solved.xlsx.xlsx
11.3 KB
3/9.2 23. Text-to-Columns-Exercise - Unsolved.xlsx.xlsx
10.57 KB
3/9.3 23. Text-to-columns-Lecture - Unsolved.xlsx.xlsx
9.76 KB
3/9.4 Useful-Tips-Tools.pdf.pdf
3.31 MB
3/9.5 23.Text-to-columns-Lecture - Solved.xlsx.xlsx
9.9 KB
4. Keyboard shortcuts in Excel/1. Keyboard shortcuts Save LOTS of time in Excel.mp4
27.55 MB
5/11. Find the minimum or maximum value in a range of cells in Excel.mp4
5.91 MB
5/11. Find the minimum or maximum value in a range of cells in Excel.vtt
1.09 KB
5/11.1 54. Max-min-Lecture - Unsolved.xlsx.xlsx
8.95 KB
5/11.2 54. MIN-MAX-Exercise - Unsolved.xlsx.xlsx
14.39 KB
5/11.3 54. Max-min-Lecture - Solved.xlsx.xlsx
9.23 KB
5/11.4 54. MIN-MAX-Exercise - Solved.xlsx.xlsx
14.8 KB
5/12. Include ROUND in your financial models.mp4
839.76 KB
5/13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4
34.59 MB
5/13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.vtt
8.45 KB
5/13.1 56. Vlookup-Hlookup- Lecture - Unsolved.xlsx.xlsx
10.74 KB
5/13.2 56. Vlookup-Hlookup- Lecture - Solved.xlsx.xlsx
11.13 KB
5/13.3 Excel-Functions.pdf.pdf
3.19 MB
5/13.4 56. Vlookup-Hlookup-Exercise - Solved.xlsx.xlsx
13.68 KB
5/13.5 56. Vlookup-Hlookup-Exercise - Unsolved.xlsx.xlsx
11.95 KB
5/14. How to enlarge the formula bar.mp4
6.26 MB
5/14. How to enlarge the formula bar.vtt
1.37 KB
5/14.1 57. Enlarge-the-formula-bar-Lecture.xlsm.xlsm
46.89 KB
5/15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4
38.95 MB
5/15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.vtt
8.22 KB
5/15.1 58. Index-Match-Lecture - Solved.xlsx.xlsx
11.7 KB
5/15.2 Excel-Functions.pdf.pdf
3.18 MB
5/15.3 58. Index-Match-Exercise - Solved.xlsx.xlsx
12.08 KB
5/15.4 58. Index-Match-Lecture - Unsolved.xlsx.xlsx
11.29 KB
5/15.5 58. Index-Match-Exercise - Unsolved.xlsx.xlsx
11.59 KB
5/16. A great Excel technique INDEX, MATCH, MATCH.mp4
11.76 MB
5/16. A great Excel technique INDEX, MATCH, MATCH.vtt
5.27 KB
5/16.1 59. Exercise-Index-Match-Match-Solved.xlsx.xlsx
12.21 KB
5/16.2 59. Exercise-Index-Match-Match-Unsolved.xlsx.xlsx
11.58 KB
5/17. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.html
160 B
5/18. Using Excel's IFERROR function to trap spreadsheet errors.mp4
3.51 MB
5/18.4 Excel-Functions.pdf.pdf
3.19 MB
5/18.5 60. Iferror - Lecture - Solved.xlsm.xlsm
896.43 KB
5/19. RANK is a valuable tool when using Excel for Financial and Business analysis.mp4
23.24 MB
5/19. RANK is a valuable tool when using Excel for Financial and Business analysis.vtt
2.82 KB
5/19.1 61. Rank-function-Lecture-after.xlsx.xlsx
12.61 KB
5/19.2 61. Rank-function-Lecture-before.xlsx.xlsx
12.27 KB
5/2. Key functions in Excel IF.mp4
16.25 MB
5/20.4 Excel-Functions.pdf.pdf
3.19 MB
5/20.5 62. Choose-Exercise - Unsolved.xlsx.xlsx
11.32 KB
5/21. Use Goal Seek to find the result that you are looking for.mp4
2.06 MB
5/21.2 Excel-Functions.pdf.pdf
3.19 MB
5/21.3 63. Goal-Seek-Exercise-Solved.xlsx.xlsx
16.21 KB
5/21.4 63. Goal-Seek-Lecture - Solved.xlsx.xlsx
9.17 KB
5/21.5 63. Goal-Seek-Lecture - Unsolved.xlsx.xlsx
9.15 KB
5/22. Use Goal Seek in order to find the result that you are looking for.html
160 B
5/23. Include sensitivity analysis in your models through Data Tables.mp4
10.96 MB
5/23.1 64. Sensitivity analysis - Lecture - Solved.xlsm.xlsm
897.3 KB
5/23.2 64. Sensitivity-analysis-Exercise-Unsolved.xlsm.xlsm
66.82 KB
5/23.3 64. Sensitivity-analysis-Exercise-Solved.xlsm.xlsm
63.87 KB
5/23.4 64. Sensitivity analysis - Lecture - Unsolved.xlsm.xlsm
897.09 KB
5/24. Include sensitivity analysis in your models through Data Tables.html
160 B
5/25. Excel's dynamic and interactive tables Pivot tables.mp4
16.59 MB
5/25. Excel's dynamic and interactive tables Pivot tables.vtt
2.58 KB
5/25.1 65. Pivot tables - Lecture - Unsolved.xlsm.xlsm
687.83 KB
5/25.2 65. Pivot Tables - Exercise - Unsolved.xlsx.xlsx
152.17 KB
5/25.3 65. Pivot tables - Lecture - Solved.xlsm.xlsm
897.26 KB
5/25.4 65. Pivot Tables - Exercise - Solved.xlsx.xlsx
190.47 KB
5/26. Excel's key functions and functionalities made easy.html
159 B
5/3. Key Excel functions SUM, SUMIF and SUMIFS.mp4
19.32 MB
5/3. Key Excel functions SUM, SUMIF and SUMIFS.vtt
4.92 KB
5/3.1 48. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx.xlsx
12.93 KB
5/3.2 48. Sum-Sumif-Sumifs-Lecture - Solved.xlsx.xlsx
13.01 KB
5/3.3 48. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx.xlsx
14.46 KB
5/3.4 Excel-Functions.pdf.pdf
3.18 MB
5/3.5 48. Sum-Sumif-Sumifs-Exercise - Solved.xlsx.xlsx
14.84 KB
5/4. = and + are interchangeable when you start typing a formula.mp4
5.79 MB
5/4. = and + are interchangeable when you start typing a formula.vtt
975 B
5/4.1 49. = and + are interchangeable -after.xlsm.xlsm
17.04 KB
5/4.2 49. = and + are interchangeable - before.xlsm.xlsm
17.01 KB
5/5. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4
15.93 MB
5/8. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4
12.61 MB
6. Update! SUMIFS - Exercise/2. Exercise - Excel's SUMIFS function - solved & explained.mp4
31.76 MB
6. Update! SUMIFS - Exercise/2.1 67. Exercise-Sumifs-With-Solutions.xlsx.xlsx
1.29 MB
7. Financial functions in Excel/1. Future and present values in Excel.mp4
7.15 MB
7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.mp4
14.82 MB
7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.vtt
5.9 KB
7. Financial functions in Excel/3.1 70. Loan Schedule-Lecture.xlsx.xlsx
20.17 KB
7. Financial functions in Excel/3.2 70. Exercise-Loan-Schedule-Solved.xlsx.xlsx
22.68 KB
7. Financial functions in Excel/3.3 70. Exercise-Loan-Schedule-Unsolved.xlsx.xlsx
15.81 KB
7. Financial functions in Excel/4. Date functions in Excel.mp4
11.35 MB
7. Financial functions in Excel/4. Date functions in Excel.vtt
5.51 KB
7. Financial functions in Excel/4.1 71. Date Functions-Exercise-Solved.xlsx.xlsx
12.43 KB
7. Financial functions in Excel/4.2 71. Date Functions-Lecture.xlsx.xlsx
12.25 KB
7. Financial functions in Excel/4.3 71. Date Functions-Exercise-Unsolved.xlsx.xlsx
11.41 KB
8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.mp4
6 MB
8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.vtt
1.99 KB
8. Microsoft Excel's Pivot Tables in Depth/2. Creating Pivot Tables easily!.mp4
16.29 MB
8. Microsoft Excel's Pivot Tables in Depth/2.1 73. Creating-a-Pivot-Table - Lecture - after.xlsx.xlsx
1.43 MB
8. Microsoft Excel's Pivot Tables in Depth/2.2 73. Creating-a-Pivot-Table - Lecture – before.xlsx.xlsx
1.23 MB
8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.mp4
11.28 MB
8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.vtt
2.22 KB
8. Microsoft Excel's Pivot Tables in Depth/3.1 74. Formatting-a-Pivot-Table - Lecture - after.xlsx.xlsx
1.43 MB
8. Microsoft Excel's Pivot Tables in Depth/3.2 74. Formatting-a-Pivot-Table - Lecture - before.xlsx.xlsx
1.43 MB
8. Microsoft Excel's Pivot Tables in Depth/4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4
8.1 MB
8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GETPIVOTDATA - A very important Excel function.mp4
18.06 MB
8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GETPIVOTDATA - A very important Excel function.vtt
3.77 KB
8. Microsoft Excel's Pivot Tables in Depth/5.1 76. GetPivotData - Lecture - before.xlsx.xlsx
1.88 MB
8. Microsoft Excel's Pivot Tables in Depth/5.2 76. GetPivotData - Lecture – after.xlsx.xlsx
1.88 MB
8. Microsoft Excel's Pivot Tables in Depth/6. An introduction to slicers - The modern-day Pivot Table filters.mp4
15.97 MB
8. Microsoft Excel's Pivot Tables in Depth/6.1 77. Slicers - Lecture - after.xlsx.xlsx
1.88 MB
8. Microsoft Excel's Pivot Tables in Depth/6.2 77. Slicers - Lecture - before.xlsx.xlsx
1.88 MB
9/1. Case study - Build a P&L from scratch - Welcome lecture.mp4
3.14 MB
9/1. Case study - Build a P&L from scratch - Welcome lecture.vtt
1.53 KB
9/10. Use INDEX & MATCH as a substitute for VLOOKUP.mp4
49.58 MB
9/10. Use INDEX & MATCH as a substitute for VLOOKUP.vtt
4.24 KB
9/10.1 87. Index Match-Lecture-before.xlsm.xlsm
41.04 KB
9/10.2 87. Index Match-Lecture-after.xlsm.xlsm
13.86 MB
9/11. Mapping the rows in the Database sheet.mp4
27.41 MB
9/12. In case you have any doubts about the Mapping exercise.mp4
38.56 MB
9/12. In case you have any doubts about the Mapping exercise.vtt
6.34 KB
9/12.1 89. Mapping-Lecture-Unsolved.xlsm.xlsm
50.55 KB
9/12.2 89. Mapping-exercise-explained.pdf.pdf
243.03 KB
9/12.3 89. Mapping-Lecture-Solved.xlsx.xlsx
47.5 KB
9/13. Building the structure of the P&L sheet.mp4
11.94 MB
9/14. Formatting sets You apart from the competition in Excel - A Practical Example.mp4
25.42 MB
9/14. Formatting sets You apart from the competition in Excel - A Practical Example.vtt
13.56 MB
9/15. Populate the P&L sheet with SUMIF.mp4
23.44 MB
9/16. Learn how to find mistakes with COUNTIF.mp4
27.87 MB
9/16. Learn how to find mistakes with COUNTIF.vtt
2.8 KB
9/16.1 93. Countif-Lecture-after.xlsm.xlsm
54.78 KB
9/16.2 93. Countif-Lecture-before.xlsm.xlsm
53.51 KB
9/17. Calculating year-on-year percentage variations the proper way.mp4
29.98 MB
9/17. Calculating year-on-year percentage variations the proper way.vtt
3.24 KB
9/17.1 94. Adding % variations-Lecture-after.xlsm.xlsm
56.51 KB
9/17.2 94. Adding % variations-Lecture-before.xlsm.xlsm
54.78 KB
9/17.3 Y-o-Y Function explanation.pdf.pdf
164.92 KB
9/2. Introduction to the case study.mp4
6.84 MB
9/3. Understand your data source before you start working on it.mp4
24.63 MB
9/4. Order the source worksheets.mp4
26.54 MB
9/4. Order the source worksheets.vtt
2.41 KB
9/4.1 81. Order a worksheet_before.xlsm.xlsm
43.08 KB
9/4.2 81. Order a worksheet_after.xlsm.xlsm
41.01 KB
9/5. Create a code the best way to organize your data and work efficiently with it.mp4
9.8 MB
9/6. Learn how to create a database.mp4
20.7 MB
9/6. Learn how to create a database.vtt
2.15 KB
9/6.1 83. Creating a database_after.xlsm.xlsm
39.39 KB
9/6.2 83. Creating a database_before.xlsm.xlsm
41.73 KB
9/7. Use VLOOKUP to fill the Database sheet.mp4
61.57 MB
9/7. Use VLOOKUP to fill the Database sheet.vtt
5.4 KB
9/7.1 84. Vlookup_before.xlsm.xlsm
39.5 KB
9/7.2 84. Vlookup_after.xlsm.xlsm
44.45 KB
9/8. 50% Completed!.mp4
4.31 MB
9/8. 50% Completed!.vtt
51 B
9/9. Use SUMIF to complete the Database sheet.mp4
47.94 MB
9/9. Use SUMIF to complete the Database sheet.vtt
4.17 KB
9/9.1 86. Sumif_after.xlsm.xlsm
49.53 KB
9/9.2 86. Sumif_before.xlsm.xlsm
44.45 KB
[Tutorialsplanet.NET].url
128 B
相关资源

免责声明

本网站仅提供DHT网络磁力资源索引服务，不存储任何资源文件。所有资源均来自DHT网络，本站无法控制其内容。请遵守当地法律法规，合理使用网络资源。如涉及版权问题，请联系 lulutang@protonmail.com。

© 2026 鹿鹿堂