zhongziso种子搜
首页
功能
磁力转BT
BT转磁力
使用教程
免责声明
关于
zhongziso
搜索
[DesireCourse.Net] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation
magnet:?xt=urn:btih:6efa437e6486bf66436578d3083e9748dfaa1a40&dn=[DesireCourse.Net] Udemy - Beginner to Pro in Excel Financial Modeling and Valuation
磁力链接详情
Hash值:
6efa437e6486bf66436578d3083e9748dfaa1a40
点击数:
220
文件大小:
4.91 GB
文件数量:
239
创建日期:
2022-10-2 19:20
最后访问:
2024-7-20 14:44
访问标签:
DesireCourse
Net
Udemy
-
Beginner
to
Pro
in
Excel
Financial
Modeling
and
Valuation
文件列表详情
1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp4 32.78 MB
1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The best way to take this course.mp4 17.62 MB
10. Introduction to Excel charts/1. How to insert a chart in Excel.mp4 22.28 MB
10. Introduction to Excel charts/2. Editing Excel charts.mp4 26.06 MB
10. Introduction to Excel charts/3. Excel chart formatting.mp4 32.74 MB
10. Introduction to Excel charts/4. How to create a bridge chart in Excel.mp4 13.66 MB
10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.mp4 11.49 MB
10. Introduction to Excel charts/6. Sparklines.mp4 27.57 MB
11. P&L Case Study continued - Let's create some great-looking professional charts/1. Create professional and good-looking charts - Introduction.mp4 6.21 MB
11. P&L Case Study continued - Let's create some great-looking professional charts/2. Build a column stacked chart with a secondary line axis in Excel.mp4 46.38 MB
11. P&L Case Study continued - Let's create some great-looking professional charts/3. Learn how to build effective doughnut charts in Excel.mp4 38.01 MB
11. P&L Case Study continued - Let's create some great-looking professional charts/4. Learn how to build an area chart in Excel.mp4 28.59 MB
11. P&L Case Study continued - Let's create some great-looking professional charts/5. Learn how to create bridge charts.mp4 52.08 MB
11. P&L Case Study continued - Let's create some great-looking professional charts/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4 136.12 MB
11. P&L Case Study continued - Let's create some great-looking professional charts/8. Course Challenge - Apply your skills in practice!.mp4 7.92 MB
12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.mp4 24.07 MB
12. Case Study - Building an FMCG Model from Scratch/11. Combining Slicers and GETPIVOTDATA The key to our success.mp4 33.63 MB
12. Case Study - Building an FMCG Model from Scratch/12. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 32.43 MB
12. Case Study - Building an FMCG Model from Scratch/13. This is how the report can be used in practice by high-level executives.mp4 36.15 MB
12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.mp4 30.45 MB
12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp4 37.13 MB
12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.mp4 19.71 MB
12. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.mp4 25.37 MB
12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.mp4 16.15 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 20.14 MB
12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4 49.98 MB
12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4 13.77 MB
13. Financial modeling fundamentals/1. Financial modeling basics - Welcome lecture.mp4 2.1 MB
13. Financial modeling fundamentals/11. Building a complete model - Important considerations.mp4 8.45 MB
13. Financial modeling fundamentals/12. Modeling the Income statement.mp4 13.33 MB
13. Financial modeling fundamentals/13. Modeling the Balance sheet - Part 1.mp4 6.15 MB
13. Financial modeling fundamentals/14. Modeling the Balance sheet - Part 2.mp4 10.61 MB
13. Financial modeling fundamentals/2. What is a financial model.mp4 5.48 MB
13. Financial modeling fundamentals/3. Why use financial models.mp4 10.04 MB
13. Financial modeling fundamentals/4. Financial modeling - worst practices - things you should avoid.mp4 19.92 MB
13. Financial modeling fundamentals/5. Financial modeling - best practices.mp4 17.23 MB
13. Financial modeling fundamentals/6. Financial modeling - The types of models that are built in practice.mp4 14.27 MB
13. Financial modeling fundamentals/8. Financial modeling The right level of detail in a model.mp4 7.29 MB
13. Financial modeling fundamentals/9. Financial modeling Forecasting guidelines.mp4 7.12 MB
16. Learn how to build a Discounted Cash Flow model in Excel/1. Valuation Case study - Welcome lecture.mp4 1.78 MB
16. Learn how to build a Discounted Cash Flow model in Excel/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4 30.02 MB
16. Learn how to build a Discounted Cash Flow model in Excel/11. Forecasting Balance sheet items.mp4 4.67 MB
16. Learn how to build a Discounted Cash Flow model in Excel/12. An introduction to the Days methodology.mp4 10.09 MB
16. Learn how to build a Discounted Cash Flow model in Excel/13. Calculation of DSO, DPO and DOI for the historical period.mp4 12.12 MB
16. Learn how to build a Discounted Cash Flow model in Excel/14. Forecasting DSO, DPO and DOI.mp4 20.87 MB
16. Learn how to build a Discounted Cash Flow model in Excel/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4 22.63 MB
16. Learn how to build a Discounted Cash Flow model in Excel/16. Creating an output P&L sheet.mp4 18.81 MB
16. Learn how to build a Discounted Cash Flow model in Excel/17. Populating the output P&L sheet.mp4 25.54 MB
16. Learn how to build a Discounted Cash Flow model in Excel/18. Populating the output BS sheet.mp4 16.94 MB
16. Learn how to build a Discounted Cash Flow model in Excel/19. Completing the output BS sheet for the historical period.mp4 38.04 MB
16. Learn how to build a Discounted Cash Flow model in Excel/2. Introduction to the DCF exercise.mp4 7.88 MB
16. Learn how to build a Discounted Cash Flow model in Excel/20. Creating a structure for the calculation of Unlevered free cash flows.mp4 22.77 MB
16. Learn how to build a Discounted Cash Flow model in Excel/21. Bridging Unlevered free cash flow to Net cash flow.mp4 14.58 MB
16. Learn how to build a Discounted Cash Flow model in Excel/22. Calculating Unlevered free cash flow.mp4 59.73 MB
16. Learn how to build a Discounted Cash Flow model in Excel/23. Calculating Net cash flow.mp4 37.91 MB
16. Learn how to build a Discounted Cash Flow model in Excel/24. Obtaining the rest of the cash flows through Find and Replace.mp4 46.73 MB
16. Learn how to build a Discounted Cash Flow model in Excel/25. Introducing Weighted average cost of capital and Perpetuity growth.mp4 13.21 MB
16. Learn how to build a Discounted Cash Flow model in Excel/26. Discounting Unlevered free cash flows to obtain their Present value.mp4 20.22 MB
16. Learn how to build a Discounted Cash Flow model in Excel/27. Calculating Continuing value and Enterprise value of the business.mp4 17.73 MB
16. Learn how to build a Discounted Cash Flow model in Excel/28. Calculating Equity value.mp4 12.21 MB
16. Learn how to build a Discounted Cash Flow model in Excel/29. Sensitivity analysis for WACC and perpetuity growth.mp4 40.49 MB
16. Learn how to build a Discounted Cash Flow model in Excel/3. The stages of a complete DCF Valuation.mp4 49.25 MB
16. Learn how to build a Discounted Cash Flow model in Excel/30. A possible application of Goal seek.mp4 15.63 MB
16. Learn how to build a Discounted Cash Flow model in Excel/31. Using charts to summarize the results of the DCF model.mp4 32.89 MB
16. Learn how to build a Discounted Cash Flow model in Excel/32. You made it!.mp4 11.27 MB
16. Learn how to build a Discounted Cash Flow model in Excel/4. Description of the structure of the DCF model.mp4 18.53 MB
16. Learn how to build a Discounted Cash Flow model in Excel/5. A glimpse at the company we are valuing - Cheeseco.mp4 15.68 MB
16. Learn how to build a Discounted Cash Flow model in Excel/6. Modeling the top line.mp4 26.31 MB
16. Learn how to build a Discounted Cash Flow model in Excel/7. Introducing scenarios to the model with Choose.mp4 17.84 MB
16. Learn how to build a Discounted Cash Flow model in Excel/8. Modeling other items Other revenues and Cogs.mp4 44.56 MB
16. Learn how to build a Discounted Cash Flow model in Excel/9. Modeling other items Operating expenses and D&A.mp4 26.34 MB
17. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.mp4 31.01 MB
17. Tesla valuation - Complete practical exercise/10. Forecasting 'energy' and 'services' revenue.mp4 25.3 MB
17. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4 26.81 MB
17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp4 34.92 MB
17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp4 56.59 MB
17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp4 54.21 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/17. Calculating DSO, DIO, DPO.mp4 17.52 MB
17. Tesla valuation - Complete practical exercise/18. Producing a clean P&L output sheet.mp4 8.44 MB
17. Tesla valuation - Complete practical exercise/19. Fill in the P&L output sheet.mp4 18.34 MB
17. Tesla valuation - Complete practical exercise/2. The input data we will work with.mp4 15.81 MB
17. Tesla valuation - Complete practical exercise/20. Calculating investments in working capital.mp4 19.04 MB
17. Tesla valuation - Complete practical exercise/21. Forecasting Unlevered free cash flow.mp4 55.94 MB
17. Tesla valuation - Complete practical exercise/22. Forecasting other assets.mp4 45.25 MB
17. Tesla valuation - Complete practical exercise/23. Forecasting other liabilities.mp4 21.97 MB
17. Tesla valuation - Complete practical exercise/24. Completing Unlevered free cash flow.mp4 40.89 MB
17. Tesla valuation - Complete practical exercise/25. Modeling Tesla's financing needs in the forecast period.mp4 42.36 MB
17. Tesla valuation - Complete practical exercise/26. Calculating Net income.mp4 14.81 MB
17. Tesla valuation - Complete practical exercise/27. Bridging Unlevered free cash flow to Net cash flow.mp4 50.72 MB
17. Tesla valuation - Complete practical exercise/28. Balancing the Balance sheet.mp4 13.27 MB
17. Tesla valuation - Complete practical exercise/29. Estimating Weighted average cost of capital (WACC).mp4 44.27 MB
17. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.mp4 100.3 MB
17. Tesla valuation - Complete practical exercise/30. Performing discounted cash flow valuation (DCF).mp4 34.91 MB
17. Tesla valuation - Complete practical exercise/31. Calculating enterprise value, equity value, and price per share.mp4 22.56 MB
17. Tesla valuation - Complete practical exercise/32. Final comments.mp4 44.88 MB
17. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.mp4 20.93 MB
17. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.mp4 41.93 MB
17. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.mp4 46.57 MB
17. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.mp4 17.18 MB
17. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.mp4 27.77 MB
17. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.mp4 17.5 MB
18. Capital budgeting - The theory/1. Introduction to Capital budgeting.mp4 5.44 MB
18. Capital budgeting - The theory/2. Why we need Capital budgeting.mp4 6.89 MB
18. Capital budgeting - The theory/3. The time value of money.mp4 6.7 MB
18. Capital budgeting - The theory/4. Calculating future and present value.mp4 13.09 MB
18. Capital budgeting - The theory/5. Calculating cost of equity.mp4 19.2 MB
18. Capital budgeting - The theory/6. Coming up with project-specific beta.mp4 9 MB
18. Capital budgeting - The theory/7. Weighted average cost of capital (WACC).mp4 5.51 MB
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/9. Estimating the project's cash flows.mp4 18.8 MB
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/10. Finding cost of equity.mp4 13.93 MB
19. Capital Budgeting - A complete Case study/11. Discounting the project's cash flows and residual value.mp4 25.91 MB
19. Capital Budgeting - A complete Case study/12. Performing sensitivity analysis and completing the exercise.mp4 43.05 MB
19. Capital Budgeting - A complete Case study/15. Congratulations!!.mp4 2.31 MB
19. Capital Budgeting - A complete Case study/2. Organizing an Inputs sheet.mp4 11.06 MB
19. Capital Budgeting - A complete Case study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4 9.22 MB
19. Capital Budgeting - A complete Case study/4. Fixed asset rollforward.mp4 12.16 MB
19. Capital Budgeting - A complete Case study/5. The impact of working capital.mp4 5.37 MB
19. Capital Budgeting - A complete Case study/6. Modeling debt financing.mp4 6.18 MB
19. Capital Budgeting - A complete Case study/7. Adding a P&L sheet.mp4 4.89 MB
19. Capital Budgeting - A complete Case study/8. Calculating project cash flows.mp4 10.14 MB
19. Capital Budgeting - A complete Case study/9. Estimating the weighted average cost of capital (WACC).mp4 5.59 MB
2. Introduction to Excel/1. Introduction to Excel.mp4 1.99 MB
2. Introduction to Excel/11. Introduction to Excel functions.mp4 18.69 MB
2. Introduction to Excel/12. Cut, copy, & paste.mp4 12.99 MB
2. Introduction to Excel/14. Paste special.mp4 10.87 MB
2. Introduction to Excel/15. Format cells.mp4 29.12 MB
2. Introduction to Excel/2. Overview of Excel.mp4 20.7 MB
2. Introduction to Excel/4. The Excel ribbon.mp4 13.59 MB
2. Introduction to Excel/5. Basic operations with rows and columns.mp4 11.19 MB
2. Introduction to Excel/6. Data entry in Excel.mp4 15.99 MB
2. Introduction to Excel/7. Introduction to formatting.mp4 38.22 MB
2. Introduction to Excel/9. Introduction to Excel formulas.mp4 20.66 MB
21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/1. Overview of Excel.mp4 41.17 MB
21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/2. Basic manipulations with rows and columns.mp4 20.42 MB
21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/3. The Excel ribbon.mp4 28.91 MB
21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/4. Data entry in Excel.mp4 31.5 MB
21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/5. Introduction to formatting.mp4 75.4 MB
21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/6. Introduction to Excel formulas.mp4 18.76 MB
21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/7. Introduction to Excel functions.mp4 37.14 MB
21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/8. Cut, copy, & paste.mp4 7.56 MB
21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/9. Paste special.mp4 6.7 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/1. Initial formatting of an Excel sheet to render it professional.mp4 7.99 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/10. Find and select special types of cells with Select Special (F5).mp4 9.79 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/11. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4 5.42 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/12. Define a named range in Excel.mp4 5.43 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/13. Learn how to organize your data with Text to Columns.mp4 12.54 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/14. Learn how to assign dynamic names within a financial model.mp4 7.32 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/15. Create easily printable documents in Excel by using Set Print Area.mp4 4.74 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/16. Using the 'Alt + Enter' combination.mp4 3.34 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/2. Fast scrolling through Excel sheets.mp4 22.17 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/3. Introduction to fixing of cell references.mp4 20.38 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/4. Learn how to use the Wrap Text button.mp4 2.15 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/5. Create a drop-down list by using Data Validation.mp4 10.59 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/6. Using Custom-sort in order to sort multiple columns within a table.mp4 9.14 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/7. Create a great Index page at the beginning of your models - Hyperlinks.mp4 5.35 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/8. Fix the top row of your table with Freeze Panes.mp4 17.68 MB
22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/9. Macros are a great timesaver! Here's why!.mp4 11.11 MB
23. APPENDIX - Microsoft Excel 2010 - Keyboard shortcuts/1. Keyboard shortcuts Save LOTS of time in Excel 2010.mp4 30.43 MB
3. Useful tips and tools for your work in Excel/1. Excel best practices - Welcome lecture.mp4 2.14 MB
3. Useful tips and tools for your work in Excel/11. The wrap text button.mp4 3.65 MB
3. Useful tips and tools for your work in Excel/12. Set print area.mp4 7.58 MB
3. Useful tips and tools for your work in Excel/13. Custom sort helps you sort multiple columns in Excel tables.mp4 11.17 MB
3. Useful tips and tools for your work in Excel/14. Create drop-down lists with data validation.mp4 14.12 MB
3. Useful tips and tools for your work in Excel/15. Find and select special types of cells with Select special (F5).mp4 13.92 MB
3. Useful tips and tools for your work in Excel/17. Assign dynamic names in a financial model.mp4 7.74 MB
3. Useful tips and tools for your work in Excel/19. Define a named range in Excel.mp4 7.68 MB
3. Useful tips and tools for your work in Excel/2. Initial formatting of Excel sheets for a professional layout.mp4 11.6 MB
3. Useful tips and tools for your work in Excel/20. Create a great Index page at the beginning of your models - Hyperlinks.mp4 8.57 MB
3. Useful tips and tools for your work in Excel/21. Introduction to custom formatting in Excel.mp4 37.96 MB
3. Useful tips and tools for your work in Excel/22. Apply custom formatting in a financial model.mp4 9.15 MB
3. Useful tips and tools for your work in Excel/23. Macros are a great timesaver! Here's why!.mp4 17.16 MB
3. Useful tips and tools for your work in Excel/24. How to save macros and use them across several workbooks.mp4 12.79 MB
3. Useful tips and tools for your work in Excel/26. Fix the top row of your table with freeze panes.mp4 14.48 MB
3. Useful tips and tools for your work in Excel/27. How to search functionalities in Excel.mp4 7.54 MB
3. Useful tips and tools for your work in Excel/28. Filter by color - an excellent tool.mp4 9.88 MB
3. Useful tips and tools for your work in Excel/29. Working with conditional formatting.mp4 15.09 MB
3. Useful tips and tools for your work in Excel/3. Fast scrolling through Excel sheets.mp4 17.52 MB
3. Useful tips and tools for your work in Excel/31. A neat trick - Multiply by 1.mp4 14.85 MB
3. Useful tips and tools for your work in Excel/32. Find and replace - references.mp4 24.04 MB
3. Useful tips and tools for your work in Excel/34. Find and replace - formatting.mp4 13.79 MB
3. Useful tips and tools for your work in Excel/35. Removing (automatic) green arrows.mp4 12.61 MB
3. Useful tips and tools for your work in Excel/36. Beauty saving - The professional way of saving files.mp4 14.03 MB
3. Useful tips and tools for your work in Excel/37. Formula auditing with F2.mp4 17.75 MB
3. Useful tips and tools for your work in Excel/5. Be even quicker F5 + Enter.mp4 19.78 MB
3. Useful tips and tools for your work in Excel/6. Fixing cell references.mp4 24.11 MB
3. Useful tips and tools for your work in Excel/8. Alt + Enter.mp4 4.16 MB
3. Useful tips and tools for your work in Excel/9. Organize your data with text to columns.mp4 13.95 MB
4. Keyboard shortcuts in Excel/1. Keyboard shortcuts save LOTS of time in Excel.mp4 51.17 MB
5. Excel's key functions and functionalities made easy/1. Excel's key functions - Welcome lecture.mp4 2.32 MB
5. Excel's key functions and functionalities made easy/11. Working with text in Excel.mp4 16.01 MB
5. Excel's key functions and functionalities made easy/12. Find the minimum or maximum value in a range of cells in Excel.mp4 5.91 MB
5. Excel's key functions and functionalities made easy/13. Include ROUND in your financial models.mp4 3.13 MB
5. Excel's key functions and functionalities made easy/14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4 34.59 MB
5. Excel's key functions and functionalities made easy/15. How to enlarge the formula bar.mp4 6.26 MB
5. Excel's key functions and functionalities made easy/16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4 38.96 MB
5. Excel's key functions and functionalities made easy/17. A great Excel technique INDEX, MATCH, MATCH.mp4 11.77 MB
5. Excel's key functions and functionalities made easy/19. Using Excel's IFERROR function to trap spreadsheet errors.mp4 7.52 MB
5. Excel's key functions and functionalities made easy/20. RANK is a valuable tool when using Excel for financial and business analysis.mp4 23.25 MB
5. Excel's key functions and functionalities made easy/21. Learn how to render your models flexible with CHOOSE.mp4 8.99 MB
5. Excel's key functions and functionalities made easy/22. Use Goal Seek to find the result that you are looking for.mp4 7.86 MB
5. Excel's key functions and functionalities made easy/24. Include sensitivity analysis in your models through Data Tables.mp4 14.29 MB
5. Excel's key functions and functionalities made easy/26. Excel's dynamic and interactive tables Pivot tables.mp4 23.19 MB
5. Excel's key functions and functionalities made easy/3. Key functions in Excel IF.mp4 16.66 MB
5. Excel's key functions and functionalities made easy/4. Key Excel functions SUM, SUMIF and SUMIFS.mp4 19.32 MB
5. Excel's key functions and functionalities made easy/5. = and + are interchangeable when you start typing a formula.mp4 5.79 MB
5. Excel's key functions and functionalities made easy/6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 16.99 MB
5. Excel's key functions and functionalities made easy/7. Key Excel functions AVERAGE and AVERAGEIF.mp4 7.86 MB
5. Excel's key functions and functionalities made easy/9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4 16.8 MB
6. Update! SUMIFS - Exercise/2. Exercise - Excel's SUMIFS function - solved & explained.mp4 35.32 MB
7. Financial functions in Excel/1. Future and present values in Excel.mp4 14.96 MB
7. Financial functions in Excel/2. Calculating the rate of return of an investment with the IRR function.mp4 7.58 MB
7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.mp4 14.82 MB
7. Financial functions in Excel/4. Date functions in Excel.mp4 11.36 MB
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/2. Creating Pivot Tables easily!.mp4 19.37 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/4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4 23.01 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/6. An introduction to slicers - The modern-day Pivot Table filters.mp4 22.17 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.14 MB
9. Case study - Building a complete P&L from scratch in Excel/11. Use INDEX & MATCH as a substitute for VLOOKUP.mp4 49.59 MB
9. Case study - Building a complete P&L from scratch in Excel/12. Mapping the rows in the database sheet.mp4 32.49 MB
9. Case study - Building a complete P&L from scratch in Excel/13. In case you have any doubts about the Mapping exercise.mp4 38.57 MB
9. Case study - Building a complete P&L from scratch in Excel/14. Building the structure of the P&L sheet.mp4 20.85 MB
9. Case study - Building a complete P&L from scratch in Excel/15. Formatting sets You apart from the competition in Excel - A Practical Example.mp4 25.43 MB
9. Case study - Building a complete P&L from scratch in Excel/16. Populate the P&L sheet with SUMIF.mp4 30.27 MB
9. Case study - Building a complete P&L from scratch in Excel/18. Learn how to find mistakes with COUNTIF.mp4 27.87 MB
9. Case study - Building a complete P&L from scratch in Excel/19. Calculating year-on-year percentage variations the proper way.mp4 29.97 MB
9. Case study - Building a complete P&L from scratch in Excel/2. Introduction to the case study.mp4 10.21 MB
9. Case study - Building a complete P&L from scratch in Excel/3. Understand your data source before you start working on it.mp4 28.17 MB
9. Case study - Building a complete P&L from scratch in Excel/4. Order the source worksheets.mp4 26.55 MB
9. Case study - Building a complete P&L from scratch in Excel/5. Create a code the best way to organize your data and work efficiently with it.mp4 24.49 MB
9. Case study - Building a complete P&L from scratch in Excel/6. Learn how to create a database.mp4 20.69 MB
9. Case study - Building a complete P&L from scratch in Excel/7. Use VLOOKUP to fill the database sheet.mp4 61.58 MB
9. Case study - Building a complete P&L from scratch in Excel/8. 50% completed!.mp4 4.31 MB
9. Case study - Building a complete P&L from scratch in Excel/9. Use SUMIF to complete the database sheet.mp4 47.94 MB
其他位置