[FreeCourseLab.com] Udemy - The Complete Financial Analyst Course 2019

磁力链接/BT种子名称

[FreeCourseLab.com] Udemy - The Complete Financial Analyst Course 2019

磁力链接/BT种子简介

种子哈希：cf89f069e7d055da5c52842bc172e66049da60ea
文件大小： 9.07G
已经下载：411次
下载速度：极快
收录时间：2021-04-19
最近下载：2025-01-01

移花宫入口

移花宫.com邀月.com怜星.com花无缺.comyhgbt.icuyhgbt.top

磁力链接下载

magnet:?xt=urn:btih:CF89F069E7D055DA5C52842BC172E66049DA60EA
推荐使用PIKPAK网盘下载资源，10TB超大空间，不限制资源，无限次数离线下载，视频在线观看

下载BT种子文件

磁力链接 迅雷下载 PIKPAK在线播放 91视频 含羞草 欲漫涩 逼哩逼哩 成人快手 51品茶 抖阴破解版 暗网禁地 91短视频 TikTok成人版 PornHub 草榴社区 乱伦社区 少女初夜 萝莉岛

最近搜索

文件列表

  • 42. Tesla practical case study - Building a financial planning model/3. Forecasting Tesla's expected deliveries.mp4 120.5 MB
  • 34. Financial Statement Analysis - Tesla exercise/3. Calculating and analyzing growth and profitability ratios.mp4 110.2 MB
  • 35. Working capital management/2. The importance of working capital optimization case study.mp4 94.3 MB
  • 1. Welcome! Course Introduction/1. What Does the Course Cover.mp4 79.9 MB
  • 35. Working capital management/4. Trade receivables management.mp4 79.8 MB
  • 34. Financial Statement Analysis - Tesla exercise/4. Calculating and analyzing liquidity ratios.mp4 78.6 MB
  • 31. Financial Statement Analysis - An Introduction/2. Finding, Downloading and Going Through the Annual Report of P&G.mp4 78.5 MB
  • 30. Advanced Accounting - Raising equity, types of equity, and dividend payments/2. Raising equity in different stages of a company's lifecycle.mp4 75.4 MB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/1. Case Study - The Accounting Transactions of a Lemonade Stand (14).mp4 71.7 MB
  • 14. Accounting - Introduction to Accounting & Bookkeeping/2. What is Accounting and Why Do You Need It.mp4 67.2 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/13. Index, Match, and Their Combination - The Perfect Substitute for Vlookup.mp4 64.8 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/7. Using Lookup Functions (Vlookup) to Fill the Database Sheet.mp4 64.5 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/12. Excel's Lookup Functions Vlookup & Hlookup Made Easy.mp4 63.2 MB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/4. Case Study - The Accounting Transactions of a Lemonade Stand (44).mp4 61.8 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/25. Conditional Formatting.mp4 61.6 MB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/5. Calculating Cash flows and completing the model.mp4 60.3 MB
  • 29. Advanced Accounting - Using leverage/1. What is leverage and why companies use financial leverage.mp4 60.2 MB
  • 42. Tesla practical case study - Building a financial planning model/13. Building a fixed asset roll forward estimating Capex.mp4 59.3 MB
  • 42. Tesla practical case study - Building a financial planning model/20. Forecasting Unlevered Free Cash Flow.mp4 58.7 MB
  • 40. Capital Budgeting - Basic notions/5. Cost of Equity.mp4 58.6 MB
  • 33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).mp4 58.5 MB
  • 30. Advanced Accounting - Raising equity, types of equity, and dividend payments/1. The different types of equity.mp4 57.9 MB
  • 40. Capital Budgeting - Basic notions/9. Modeling Future Cash Flows.mp4 57.0 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/8. GetPivotData is great! Extracting data from the Master Pivot Table.mp4 56.8 MB
  • 42. Tesla practical case study - Building a financial planning model/14. Building a fixed asset roll forward D&A schedule.mp4 56.8 MB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/3. Case Study - The Accounting Transactions of a Lemonade Stand (34).mp4 56.0 MB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/7. Practical Exercise - Creating an Organisational Chart.mp4 54.1 MB
  • 42. Tesla practical case study - Building a financial planning model/26. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 53.1 MB
  • 21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/5. Calculating Cash Flow in practice A complete example.mp4 53.1 MB
  • 35. Working capital management/7. Inventory optimization techniques.mp4 52.9 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/9. Using Index & Match as a Substitute for Vlookup.mp4 52.1 MB
  • 39. Finance 101 - Loan Calculations/2. Calculating a Complete Loan Schedule.mp4 52.0 MB
  • 22. Accounting - The Importance of Timing/4. The Four Type of Accruals Arising in Accounting Transactions.mp4 52.0 MB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/1. Calculating historical percentage ratios and use Index and Match for scenarios.mp4 51.8 MB
  • 35. Working capital management/9. Working capital optimization - a roadmap.mp4 50.5 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/8. Use Sumif to Complete the Database Sheet.mp4 50.3 MB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/2. Building a Financial liabilities schedule.mp4 49.9 MB
  • 41. Capital Budgeting - A Complete Case Study/4. Preparing a fixed asset rollforward schedule.mp4 49.7 MB
  • 42. Tesla practical case study - Building a financial planning model/6. Calculating automotive revenue.mp4 48.8 MB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/2. Case Study - The Accounting Transactions of a Lemonade Stand (24).mp4 48.7 MB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/4. Additional Techniques That Will Ease Your Work with Pivot Tables.mp4 48.2 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/18. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4 48.2 MB
  • 6. Microsoft Excel - Financial functions in Excel/1. Discounting cash flows in Microsoft Excel.mp4 47.9 MB
  • 42. Tesla practical case study - Building a financial planning model/21. Forecasting other assets.mp4 47.5 MB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/6. Welcome to the Future - Pivot Table Slicers.mp4 47.4 MB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/5. Types of expenses.mp4 47.4 MB
  • 30. Advanced Accounting - Raising equity, types of equity, and dividend payments/3. The types of dividends companies pay to shareholders.mp4 47.1 MB
  • 2. Microsoft Excel - Quick Introduction/4. How to Make Your Spreadsheets Look Professional.mp4 47.0 MB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/4. Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %.mp4 46.7 MB
  • 30. Advanced Accounting - Raising equity, types of equity, and dividend payments/5. What are share repurchases and why companies do them.mp4 46.0 MB
  • 11. Modeling in Excel - Building a complete 3-statement model/7. Using Index, Match, Match to fill in the output Balance sheet.mp4 45.6 MB
  • 42. Tesla practical case study - Building a financial planning model/24. Modeling Tesla's financing needs in the forecast period.mp4 44.4 MB
  • 42. Tesla practical case study - Building a financial planning model/5. Estimating an average selling price of Tesla vehicles.mp4 44.0 MB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/1. Building a Fixed asset roll forward.mp4 42.9 MB
  • 42. Tesla practical case study - Building a financial planning model/23. Completing Unlevered Free Cash Flow.mp4 42.9 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/12. This is how the report can be used in practice by high-level executives.mp4 42.8 MB
  • 41. Capital Budgeting - A Complete Case Study/10. Estimating cost of equity.mp4 42.3 MB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/7. Depreciation & Amortization.mp4 42.1 MB
  • 19. Accounting - The Core Principles of Accounting/5. How to Calculate Depreciation Expense.mp4 42.1 MB
  • 6. Microsoft Excel - Financial functions in Excel/3. Using the PMT function to create a complete loan schedule.mp4 42.0 MB
  • 16. Accounting - Revenue recognition/5. A practical example.mp4 41.4 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/2. Working with an SAP data extraction.mp4 41.1 MB
  • 25. Advanced Accounting - Fixed Assets/5. The revaluation model.mp4 41.0 MB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/2. Creating a Pivot Table Choosing Row and Column Parameters.mp4 40.8 MB
  • 28. Advanced Accounting - Leasing Liabilties/2. Solving a complete leasing exercise.mp4 40.0 MB
  • 41. Capital Budgeting - A Complete Case Study/2. Organizing inputs in the Drivers sheet.mp4 40.0 MB
  • 25. Advanced Accounting - Fixed Assets/6. The revaluation model - practical exercise.mp4 39.8 MB
  • 40. Capital Budgeting - Basic notions/4. Calculating Present and Future Value.mp4 39.3 MB
  • 33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).mp4 38.7 MB
  • 32. Financial Statement Analysis - Subtleties/5. Using Accounting Ratios to Assess Business Performance.mp4 38.6 MB
  • 11. Modeling in Excel - Building a complete 3-statement model/1. Introduction to the Exercise.mp4 38.4 MB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/3. Building an Equity schedule.mp4 38.3 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/10. Combining Slicers and GetPivotData The key to our success.mp4 38.2 MB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/5. One of the Most Useful Excel Functions - GetPivotData.mp4 38.0 MB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/3. Building a flexible model with Vlookup & Columns.mp4 38.0 MB
  • 30. Advanced Accounting - Raising equity, types of equity, and dividend payments/4. Dividend payments - a timeline.mp4 37.9 MB
  • 30. Advanced Accounting - Raising equity, types of equity, and dividend payments/6. The idea behind stock splits.mp4 37.8 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/11. Getting fancy with Excel slicers.mp4 37.6 MB
  • 25. Advanced Accounting - Fixed Assets/4. Intangible assets with finite life vs. Intangible assets with infinite life.mp4 37.0 MB
  • 41. Capital Budgeting - A Complete Case Study/3. Modeling expected savings - Building cars in Italy vs. Building cars in Vietnam.mp4 36.4 MB
  • 42. Tesla practical case study - Building a financial planning model/12. Forecasting operating expenses.mp4 36.2 MB
  • 29. Advanced Accounting - Using leverage/2. The implications of using excessive leverage.mp4 36.2 MB
  • 43. PowerPoint - Introduction to PowerPoint/2. The Structure of the PowerPoint Ribbon.mp4 35.9 MB
  • 41. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and wrapping up the Case Study.mp4 35.8 MB
  • 43. PowerPoint - Introduction to PowerPoint/11. Using Slide Masters.mp4 35.7 MB
  • 35. Working capital management/3. Overtrading vs. excessive investment.mp4 34.7 MB
  • 14. Accounting - Introduction to Accounting & Bookkeeping/1. Accounting The Science Behind Financial Figures.mp4 34.5 MB
  • 8. Microsoft Excel - Building Professional Charts in Excel/4. Making Your Excel Charts Sexier - Proven Tips.mp4 34.3 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/11. Mapping the Rows in the Database Sheet.mp4 34.2 MB
  • 16. Accounting - Revenue recognition/3. Revenue recognition criteria - technical.mp4 33.8 MB
  • 11. Modeling in Excel - Building a complete 3-statement model/8. Adding the forecast period.mp4 33.7 MB
  • 32. Financial Statement Analysis - Subtleties/2. First Steps in Financial Statement Analysis.mp4 33.6 MB
  • 14. Accounting - Introduction to Accounting & Bookkeeping/4. An Introduction to Financial Accounting.mp4 33.5 MB
  • 35. Working capital management/6. Economic order quantity (EOQ).mp4 33.4 MB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/8. Types of assets.mp4 33.3 MB
  • 21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/4. Cash Flow computations - The Indirect method.mp4 32.9 MB
  • 35. Working capital management/5. Re-order level.mp4 32.8 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/4. Key Excel Functions Count, Counta, Countif, Countifs.mp4 32.7 MB
  • 1. Welcome! Course Introduction/3. The Best Way to Take This Course.mp4 32.7 MB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/7. What Is Default Risk and How Does a Bank Account For It.vtt 32.7 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/3. Preliminary mapping of the data extraction.mp4 32.7 MB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/7. What Is Default Risk and How Does a Bank Account For It.mp4 32.7 MB
  • 42. Tesla practical case study - Building a financial planning model/1. Organizing external inputs in a 'Drivers' sheet.mp4 32.5 MB
  • 41. Capital Budgeting - A Complete Case Study/8. The project's cash flow calculation.mp4 32.3 MB
  • 6. Microsoft Excel - Financial functions in Excel/4. Date functions in Excel.mp4 32.3 MB
  • 11. Modeling in Excel - Building a complete 3-statement model/2. Let's create a mapping of financials.mp4 32.2 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/3. Key Excel Functions Sum, Sumif, Sumifs.mp4 32.2 MB
  • 11. Modeling in Excel - Building a complete 3-statement model/3. Building an output P&L sheet.mp4 32.0 MB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/5. Forecasting DSO, DPO, DIO, Other assets and Other liabilities.mp4 32.0 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/6. Key Excel Functions Left, Right, Mid, Upper, Lower, Proper, Concatenate, &.mp4 31.9 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/14. Populate the P&L Sheet with Sumif.mp4 31.7 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/16. Calculating Growth Rates in Excel.mp4 31.4 MB
  • 38. Finance 101 - The Value of Cash Flows with Different Timing/1. Calculating the Present Value of Future Cash Flows.mp4 31.2 MB
  • 43. PowerPoint - Introduction to PowerPoint/4. Learn How to Insert Objects in PowerPoint.mp4 31.2 MB
  • 11. Modeling in Excel - Building a complete 3-statement model/6. Building an output Balance sheet.mp4 30.9 MB
  • 43. PowerPoint - Introduction to PowerPoint/8. How to Edit Shapes in Your Presentation.mp4 30.6 MB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/9. Asset categories - practical example.mp4 30.5 MB
  • 38. Finance 101 - The Value of Cash Flows with Different Timing/2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.mp4 30.5 MB
  • 24. Advanced Accounting - Inventory/3. Cost flow methods.mp4 30.1 MB
  • 32. Financial Statement Analysis - Subtleties/3. Horizontal vs. Vertical Financial Statement Analysis.mp4 29.6 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/3. Understand Your Data Source Before You Start Working on It.mp4 29.5 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/15. Learn How to Find Mistakes with Countif.mp4 29.2 MB
  • 42. Tesla practical case study - Building a financial planning model/8. Calculating automotive gross profit.mp4 29.1 MB
  • 21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/1. Calculating Cash Flows - Understand if a business makes or burns cash.mp4 29.0 MB
  • 17. Accounting - Cost recognition/2. Technical aspects of cost recognition.mp4 29.0 MB
  • 8. Microsoft Excel - Building Professional Charts in Excel/7. How to Represent Trends with Sparklines.mp4 28.9 MB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/10. Types of liabilities.mp4 28.8 MB
  • 31. Financial Statement Analysis - An Introduction/1. What is a 10-K Report and Why Is It important for Investors.mp4 28.7 MB
  • 11. Modeling in Excel - Building a complete 3-statement model/5. Calculating percentage variances and applying conditional formatting.mp4 28.5 MB
  • 40. Capital Budgeting - Basic notions/6. Project-specific Beta.mp4 28.5 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/5. Improving the layout and appearance of the FMCG report.mp4 28.5 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/8. Using Absolute and Relative Cell References.mp4 28.3 MB
  • 22. Accounting - The Importance of Timing/2. Timing of Income Principles of Revenue Recognition.mp4 28.2 MB
  • 42. Tesla practical case study - Building a financial planning model/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4 28.1 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/1. Introduction to the Case Study.mp4 28.0 MB
  • 14. Accounting - Introduction to Accounting & Bookkeeping/3. The Importance of Bookkeeping - Good Accounting Records Are Essential.mp4 28.0 MB
  • 24. Advanced Accounting - Inventory/1. The different types of Inventory we can have.mp4 28.0 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/4. Ordering the Source Worksheet.mp4 27.9 MB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/3. Types of revenues.mp4 27.8 MB
  • 23. Advanced Accounting - Trade receivables/2. What if clients do not pay on time.mp4 27.8 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/20. Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp4 27.5 MB
  • 8. Microsoft Excel - Building Professional Charts in Excel/3. Modifying Excel Charts - The Easy Way.mp4 27.3 MB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/8. COURSE CHALLENGE - Part 4.mp4 27.3 MB
  • 26. Advanced Accounting - Trade payables/3. Why use e-invoicing.mp4 27.2 MB
  • 31. Financial Statement Analysis - An Introduction/3. What is the Role of Auditing Firms and What Are the Benefits of an Audit.mp4 27.1 MB
  • 27. Advanced Accounting - Financial liabilities/3. Debt covenants.mp4 27.0 MB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/8. Corporate Loan Specifics.mp4 27.0 MB
  • 1. Welcome! Course Introduction/2. Everything We Will Learn Has a Practical Application.mp4 26.9 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/13. A Practical Example of Professional Formatting in Excel.mp4 26.7 MB
  • 3. Microsoft Excel - Useful Tools/9. A Quick Introduction to Excel's Pivot Tables.mp4 26.6 MB
  • 41. Capital Budgeting - A Complete Case Study/1. An introduction to the Case Study.mp4 26.5 MB
  • 42. Tesla practical case study - Building a financial planning model/10. Forecasting 'energy' and 'services' revenue.mp4 26.5 MB
  • 18. Accounting - Understanding the Big Picture Why, What, When, and How Much/2. The Expense Recognition Principle - When to Recognize Expenses.mp4 26.5 MB
  • 23. Advanced Accounting - Trade receivables/1. Why a company needs to pay attention to trade receivables.mp4 26.5 MB
  • 23. Advanced Accounting - Trade receivables/3. How to handle non-paying customers A case-study.mp4 26.2 MB
  • 43. PowerPoint - Introduction to PowerPoint/3. General Considerations About Slide Structure.mp4 25.8 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/5. Create a Code The Best Way to Organize Your Data and Work Efficiently with It.mp4 25.7 MB
  • 19. Accounting - The Core Principles of Accounting/1. The Accounting Equation and Its Importance.mp4 25.7 MB
  • 18. Accounting - Understanding the Big Picture Why, What, When, and How Much/1. The Revenue Recognition Principle - Why Is it so Important.mp4 25.6 MB
  • 40. Capital Budgeting - Basic notions/8. The Different Cash Flow Types in a Capital Budgeting Exercise.mp4 25.5 MB
  • 25. Advanced Accounting - Fixed Assets/3. Fair value accounting.mp4 25.4 MB
  • 18. Accounting - Understanding the Big Picture Why, What, When, and How Much/3. Historical Cost vs. Fair Value Accounting.mp4 25.4 MB
  • 39. Finance 101 - Loan Calculations/1. Using Annuities.mp4 25.4 MB
  • 19. Accounting - The Core Principles of Accounting/6. The Double-Entry Principle - The Core Principle of Bookkeeping.mp4 25.3 MB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/5. PowerPoint's Smart Art Feature Offers Great Return for Your Time.vtt 25.3 MB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/5. PowerPoint's Smart Art Feature Offers Great Return for Your Time.mp4 25.3 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/20. Find and Replace - References.mp4 25.2 MB
  • 11. Modeling in Excel - Building a complete 3-statement model/4. Filling in the output P&L sheet with historical financials.mp4 25.1 MB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/11. Liability categories - practical example.mp4 25.0 MB
  • 16. Accounting - Revenue recognition/2. The importance of timing when recognizing revenues.mp4 24.6 MB
  • 35. Working capital management/1. Introduction.mp4 24.6 MB
  • 31. Financial Statement Analysis - An Introduction/1. What is a 10-K Report and Why Is It important for Investors.vtt 24.4 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/16. A Useful Tool for Financial Analysis - The Rank Function.mp4 24.4 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/11.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx 23.9 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/12.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx 23.9 MB
  • 43. PowerPoint - Introduction to PowerPoint/6. Add Frequently Used Buttons to the Quick Access Toolbar.mp4 23.9 MB
  • 6. Microsoft Excel - Financial functions in Excel/2. Calculating Internal Rate of Return (IRR) in Excel.mp4 23.9 MB
  • 2. Microsoft Excel - Quick Introduction/2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.mp4 23.9 MB
  • 41. Capital Budgeting - A Complete Case Study/11. Discounting project cash flows.mp4 23.7 MB
  • 26. Advanced Accounting - Trade payables/1. How we account for trade payables.mp4 23.6 MB
  • 8. Microsoft Excel - Building Professional Charts in Excel/2. Beginner's Guide to Inserting Charts in Excel.mp4 23.3 MB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/2. Join Shapes Together By Using Connector Lines.mp4 23.3 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/4. Creating an output structure of the FMCG model.mp4 23.3 MB
  • 41. Capital Budgeting - A Complete Case Study/6. Debt repayment and interest expenses calculation.mp4 23.2 MB
  • 42. Tesla practical case study - Building a financial planning model/22. Forecasting other liabilities.mp4 23.1 MB
  • 2. Microsoft Excel - Quick Introduction/1. Microsoft Excel The World's #1 Office Software.mp4 23.1 MB
  • 2. Microsoft Excel - Quick Introduction/10. A Beginner's Introduction to Excel Functions.mp4 23.0 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/7. Creating a Master Pivot Table The main data source for the FMCG report.mp4 22.8 MB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/1. The different types of accounting standards.mp4 22.7 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/10. The Mapping Exercise.mp4 22.7 MB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/3. Design the Layout and Format of Your Pivot Tables.mp4 22.6 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/2. Macros Are a Great Timesaver! Here's Why..mp4 22.4 MB
  • 19. Accounting - The Core Principles of Accounting/3. T-Accounts The Best Way to Understand Debits and Credits.mp4 22.4 MB
  • 42. Tesla practical case study - Building a financial planning model/4. Comparing delivery figures with the ones of industry peers.mp4 22.0 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/12. Building the Structure of the P&L Sheet.mp4 21.9 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/5. The Secret to Faster Scrolling in Excel.mp4 21.8 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA.xlsx.xlsx 21.8 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table.xlsx.xlsx 21.8 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/10.1 8. Exercise - Build an FMCG Model_Inserting Slicers.xlsx.xlsx 21.8 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/6. Learn How to Create a Database.mp4 21.7 MB
  • 25. Advanced Accounting - Fixed Assets/1. The different types of fixed assets.mp4 21.7 MB
  • 27. Advanced Accounting - Financial liabilities/2. Amortizing a loan.mp4 21.6 MB
  • 40. Capital Budgeting - Basic notions/2. When Do We Use Capital Budgeting.mp4 21.5 MB
  • 34. Financial Statement Analysis - Tesla exercise/5. Calculating and analyzing solvency ratios.mp4 21.0 MB
  • 21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/2. The three parts of Cash Flow statements explained.mp4 21.0 MB
  • 43. PowerPoint - Introduction to PowerPoint/7. How to Easily Align Objects in PowerPoint.mp4 21.0 MB
  • 43. PowerPoint - Introduction to PowerPoint/9. How to Format Text Boxes in a PowerPoint Presentation.mp4 20.8 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/17. Create Flexible Financial Models with Choose.mp4 20.8 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/6. Be even quicker F5 + Enter.mp4 20.8 MB
  • 21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/3. Cash Flow computations - The Direct method.mp4 20.7 MB
  • 35. Working capital management/8. Trade payables management.mp4 20.2 MB
  • 42. Tesla practical case study - Building a financial planning model/19. Calculating investments in working capital.mp4 20.0 MB
  • 40. Capital Budgeting - Basic notions/3. The Time Value of Money in a Capital Budgeting Setting.mp4 19.8 MB
  • 16. Accounting - Revenue recognition/4. Potential conflicts of interest when recognizing revenue.mp4 19.7 MB
  • 33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/3. COURSE CHALLENGE - Part 2.mp4 19.7 MB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/4. Types of revenues - exercise.mp4 19.5 MB
  • 41. Capital Budgeting - A Complete Case Study/9. Calculating WACC (Weighted Average Cost of Capital).mp4 19.4 MB
  • 32. Financial Statement Analysis - Subtleties/1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.mp4 19.3 MB
  • 43. PowerPoint - Introduction to PowerPoint/1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp4 19.3 MB
  • 42. Tesla practical case study - Building a financial planning model/18. Fill in the P&L output sheet.mp4 19.2 MB
  • 41. Capital Budgeting - A Complete Case Study/5. Calculating the cash impact of extra working capital required.mp4 19.2 MB
  • 34. Financial Statement Analysis - Tesla exercise/1. What you will see next in this section.mp4 19.2 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/6. Inserting formulas and automating calculations.mp4 19.0 MB
  • 35. Working capital management/10. Symptoms of inefficient working capital - Trade payables.mp4 18.8 MB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/6. Income taxes.mp4 18.8 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/24. The Power of F2.mp4 18.6 MB
  • 25. Advanced Accounting - Fixed Assets/7. Intangible assets created internally.mp4 18.5 MB
  • 42. Tesla practical case study - Building a financial planning model/9. Calculating automotive cost of sales.mp4 18.4 MB
  • 42. Tesla practical case study - Building a financial planning model/16. Calculating DSO, DIO, DPO.mp4 18.4 MB
  • 2. Microsoft Excel - Quick Introduction/3. Data Entry Techniques in Excel.mp4 18.2 MB
  • 24. Advanced Accounting - Inventory/2. The connection between Cost of Goods Sold and Inventory.mp4 18.1 MB
  • 42. Tesla practical case study - Building a financial planning model/7. Peer comparison Gross profit %.mp4 18.0 MB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/5. What Is Libor and What Purpose Does It Serve.mp4 18.0 MB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/6. The Difference Between Fixed and Variable Interest Rates.mp4 17.9 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/1. Key Excel Functions If.mp4 17.5 MB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/4. The Components Forming Interest Rates in Real Life.mp4 17.4 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/16. How to Add a Drop-down List in Excel.mp4 17.1 MB
  • 19. Accounting - The Core Principles of Accounting/2. Elements of the Accounting System General Ledger.mp4 16.9 MB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/1. Finance 101 Important Financial Principles That You Will Need.mp4 16.9 MB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/2. Building a flexible model with Choose & Match.mp4 16.8 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18. Goal Seek Will Help You Find the Result You Are Looking For.mp4 16.8 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/8. Working with text in Excel.mp4 16.8 MB
  • 42. Tesla practical case study - Building a financial planning model/2. The input data we will work with.mp4 16.6 MB
  • 22. Accounting - The Importance of Timing/3. Timing of Expenses Principles of Cost Recognition.mp4 16.6 MB
  • 40. Capital Budgeting - Basic notions/7. The Weighted Average Cost of Capital (WACC).mp4 16.5 MB
  • 43. PowerPoint - Introduction to PowerPoint/5. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp4 16.3 MB
  • 23. Advanced Accounting - Trade receivables/4. A technique to collect trade receivables sooner.mp4 16.2 MB
  • 31. Financial Statement Analysis - An Introduction/4. Indispensable Tools for Financial Statement Analysis.mp4 16.1 MB
  • 3. Microsoft Excel - Useful Tools/7. Using Excel's Freeze Panes to Handle Large Datasets.mp4 16.0 MB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/4. Preparing a Cash flow structure.mp4 15.9 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/12. How to Create Dynamic Names in Excel Spreadsheets.mp4 15.9 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/5. Key Excel Functions Average & Averageif.mp4 15.9 MB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/1. Pivot Tables - Excel's Dynamic and Interactive Tables.mp4 15.8 MB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/12. Equity.mp4 15.8 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/5.1 3. Exercise - Build an FMCG Model_Formatting.xlsx.xlsx 15.6 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/6.1 4. Exercise - Build an FMCG Model_Adding Calculations.xlsx.xlsx 15.6 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/4.1 2. Exercise - Build an FMCG Model_Structure.xlsx.xlsx 15.6 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/3.1 1. Exercise - Build an FMCG Model_Mapping.xlsx.xlsx 15.6 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/19. Multiply by 1.mp4 15.6 MB
  • 27. Advanced Accounting - Financial liabilities/1. The difference between debt and equity.mp4 15.5 MB
  • 42. Tesla practical case study - Building a financial planning model/25. Calculating Net income.mp4 15.5 MB
  • 2. Microsoft Excel - Quick Introduction/11. Work Efficiently by Using Cut, Copy, and Paste.mp4 15.2 MB
  • 2. Microsoft Excel - Quick Introduction/8. Excel Formulas for Beginners.mp4 15.1 MB
  • 34. Financial Statement Analysis - Tesla exercise/2. How to download Tesla's historical financials.mp4 15.1 MB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/8. COURSE CHALLENGE - Part 1.mp4 15.1 MB
  • 2. Microsoft Excel - Quick Introduction/13. Pasting Values, Formulas and Formats with Paste Special.mp4 14.9 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/23. Beauty Saving - The Professional Way of Saving Files.mp4 14.7 MB
  • 41. Capital Budgeting - A Complete Case Study/7. The project's P&L sheet.mp4 14.6 MB
  • 39. Finance 101 - Loan Calculations/3. COURSE CHALLENGE - Part 3.mp4 14.6 MB
  • 3. Microsoft Excel - Useful Tools/2. Do More with Your Sales Data with Excel's Text to Columns Feature.mp4 14.5 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/9.1 9. Index Match_after.xlsm.xlsm 14.5 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4 14.5 MB
  • 17. Accounting - Cost recognition/1. Cost recognition principles.mp4 14.5 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/21. Find and Replace - Formatting.mp4 14.5 MB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/3. How Interest Rates Play an Important Role in the Economy.mp4 14.4 MB
  • 27. Advanced Accounting - Financial liabilities/4. Debt covenants - a practical example.mp4 14.3 MB
  • 16. Accounting - Revenue recognition/1. Accrual accounting.mp4 14.3 MB
  • 8. Microsoft Excel - Building Professional Charts in Excel/5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp4 14.3 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/9. GetPivotData fix.mp4 14.3 MB
  • 42. Tesla practical case study - Building a financial planning model/15. Peer comparison D&A as a percentage of revenues.mp4 14.3 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/17. Using Custom-sort to Sort Multiple Columns Within a Table.mp4 14.2 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/10. Find and Select Cells That Meet Specific Conditions.mp4 14.1 MB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/6. Creating Eye-Catching Text Effects in PowerPoint.mp4 14.0 MB
  • 19. Accounting - The Core Principles of Accounting/4. P&L T-Accounts.mp4 14.0 MB
  • 42. Tesla practical case study - Building a financial planning model/27. Balancing the Balance sheet.mp4 13.9 MB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/1.1 0. Exercise - Build an FMCG Model_before.xlsx.xlsx 13.9 MB
  • 40. Capital Budgeting - Basic notions/1. What is Capital Budgeting.mp4 13.9 MB
  • 22. Accounting - The Importance of Timing/1. Timing of Cash Flows and Why It Plays an Important Role in a Business.mp4 13.9 MB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/7. Introduction to the Course Challenge.mp4 13.8 MB
  • 8. Microsoft Excel - Building Professional Charts in Excel/1. Introduction to Excel Charts.mp4 13.6 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/3. How to Use the Same Macro On Multiple Workbooks.mp4 13.4 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/22. Green References.mp4 13.2 MB
  • 2. Microsoft Excel - Quick Introduction/6. Inserting, Deleting, and Modifying Rows & Columns.mp4 13.0 MB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/1. Modifying the Beginning and Ending of a Line Object.mp4 12.7 MB
  • 32. Financial Statement Analysis - Subtleties/4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).mp4 12.4 MB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/2. The three financial statements.vtt 12.4 MB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/2. The three financial statements.mp4 12.4 MB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/4. This is How You Can Fit Text When It Is Larger than a Shape.mp4 12.4 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15. Using Excel's Iferror Function to Trap Spreadsheet Errors.mp4 12.3 MB
  • 8. Microsoft Excel - Building Professional Charts in Excel/6. New Ways to Visualize Your Data - Treemap Charts.mp4 12.1 MB
  • 8. Microsoft Excel - Building Professional Charts in Excel/3.1 3. Formatting a Chart.xlsm.xlsm 12.0 MB
  • 8. Microsoft Excel - Building Professional Charts in Excel/2.1 2. Inserting Charts.xlsm.xlsm 12.0 MB
  • 8. Microsoft Excel - Building Professional Charts in Excel/4.1 4. Modifying a Chart.xlsm.xlsm 12.0 MB
  • 28. Advanced Accounting - Leasing Liabilties/1. The reason companies lease assets.mp4 11.7 MB
  • 26. Advanced Accounting - Trade payables/2. What is the difference between accounts payable and notes payable.mp4 11.4 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/2. What You Will See Next.mp4 10.7 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/15. Custom Number Formatting.mp4 10.4 MB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/1. Introduction to the Case Study.mp4 10.3 MB
  • 3. Microsoft Excel - Useful Tools/4. Create Easily Printable Excel Documents.mp4 9.6 MB
  • 3. Microsoft Excel - Useful Tools/8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp4 9.6 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/14. Using Named Ranges to Make Formulas More Readable.mp4 9.5 MB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/3. Group or Ungroup Shapes, Pictures or Other Objects.mp4 9.4 MB
  • 43. PowerPoint - Introduction to PowerPoint/10. Changing an Object's Size and Rotation.mp4 9.1 MB
  • 42. Tesla practical case study - Building a financial planning model/17. Producing a clean P&L output sheet.mp4 8.8 MB
  • 3. Microsoft Excel - Useful Tools/6. Insert Hyperlinks into Excel Spreadsheets.mp4 8.6 MB
  • 25. Advanced Accounting - Fixed Assets/2. Capitalizing interest expenses.mp4 8.0 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/9. Find the Highest and Lowest Values in a Range Max & Min.mp4 7.9 MB
  • 17. Accounting - Cost recognition/3. The two types of Income Statement formats.mp4 7.6 MB
  • 24. Advanced Accounting - Inventory/4. Cost flow methods - a practical exercise.mp4 7.1 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/2. Enlarge the formula bar.mp4 6.6 MB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/2. Understanding the Time Value of Money.mp4 6.5 MB
  • 3. Microsoft Excel - Useful Tools/1. Inserting a Line Break with Alt + Enter.mp4 6.5 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/10. = and + are interchangeable when you start typing a formula.mp4 6.1 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/11. Use Round in Your Financial Models.mp4 5.5 MB
  • 31. Financial Statement Analysis - An Introduction/2.1 P&G Financial Report.pdf.pdf 4.6 MB
  • 33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/1.1 P&G Financial Report.pdf.pdf 4.6 MB
  • 33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/2.2 P&G Financial Report.pdf.pdf 4.6 MB
  • 3. Microsoft Excel - Useful Tools/5. How to Wrap Text in Excel and Adjust a Cell's Size.mp4 4.0 MB
  • 3. Microsoft Excel - Useful Tools/4.2 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 3. Microsoft Excel - Useful Tools/6.1 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/14.1 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/17.5 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/8.3 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 3. Microsoft Excel - Useful Tools/1.2 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 3. Microsoft Excel - Useful Tools/2.1 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 3. Microsoft Excel - Useful Tools/5.1 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 3. Microsoft Excel - Useful Tools/7.2 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 3. Microsoft Excel - Useful Tools/8.1 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 3. Microsoft Excel - Useful Tools/9.2 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/1.4 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/10.4 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/12.5 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/15.1 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/16.1 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/18.3 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/2.1 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/5.2 Useful Tips & Tools.pdf.pdf 3.5 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/17.3 Excel Functions.pdf.pdf 3.3 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/11.4 Excel Functions.pdf.pdf 3.3 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/12.2 Excel Functions.pdf.pdf 3.3 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/13.5 Excel Functions.pdf.pdf 3.3 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15.1 Excel Functions.pdf.pdf 3.3 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18.1 Excel Functions.pdf.pdf 3.3 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/3.4 Excel Functions.pdf.pdf 3.3 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/4.1 Excel Functions.pdf.pdf 3.3 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/5.2 Excel Functions.pdf.pdf 3.3 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/9.3 Excel Functions.pdf.pdf 3.3 MB
  • 43. PowerPoint - Introduction to PowerPoint/4.2 Useful maps and Shapes.pptx.pptx 3.2 MB
  • 43. PowerPoint - Introduction to PowerPoint/10.1 Introduction to PowerPoint.pdf.pdf 2.7 MB
  • 43. PowerPoint - Introduction to PowerPoint/3.1 Introduction to PowerPoint.pdf.pdf 2.7 MB
  • 43. PowerPoint - Introduction to PowerPoint/5.2 Introduction to PowerPoint.pdf.pdf 2.7 MB
  • 43. PowerPoint - Introduction to PowerPoint/6.1 Introduction to PowerPoint.pdf.pdf 2.7 MB
  • 43. PowerPoint - Introduction to PowerPoint/8.1 Introduction to PowerPoint.pdf.pdf 2.7 MB
  • 43. PowerPoint - Introduction to PowerPoint/11.1 Introduction to PowerPoint.pdf.pdf 2.7 MB
  • 43. PowerPoint - Introduction to PowerPoint/2.1 Introduction to PowerPoint.pdf.pdf 2.7 MB
  • 43. PowerPoint - Introduction to PowerPoint/4.1 Introduction to PowerPoint.pdf.pdf 2.7 MB
  • 43. PowerPoint - Introduction to PowerPoint/7.1 Introduction to PowerPoint.pdf.pdf 2.7 MB
  • 43. PowerPoint - Introduction to PowerPoint/9.1 Introduction to PowerPoint.pdf.pdf 2.7 MB
  • 34. Financial Statement Analysis - Tesla exercise/2.3 Tesla 2017.pdf.pdf 2.6 MB
  • 2. Microsoft Excel - Quick Introduction/1.1 Introduction to Excel's basic features.pdf.pdf 2.4 MB
  • 2. Microsoft Excel - Quick Introduction/10.5 Introduction to Excel's basic features.pdf.pdf 2.4 MB
  • 2. Microsoft Excel - Quick Introduction/2.2 Introduction to Excel's basic features.pdf.pdf 2.4 MB
  • 2. Microsoft Excel - Quick Introduction/11.3 Introduction to Excel's basic features.pdf.pdf 2.4 MB
  • 2. Microsoft Excel - Quick Introduction/13.2 Introduction to Excel's basic features.pdf.pdf 2.4 MB
  • 2. Microsoft Excel - Quick Introduction/3.4 Introduction to Excel's basic features.pdf.pdf 2.4 MB
  • 2. Microsoft Excel - Quick Introduction/4.2 Introduction to Excel's basic features.pdf.pdf 2.4 MB
  • 2. Microsoft Excel - Quick Introduction/6.4 Introduction to Excel's basic features.pdf.pdf 2.4 MB
  • 2. Microsoft Excel - Quick Introduction/8.2 Introduction to Excel's basic features.pdf.pdf 2.4 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/18.2 Useful tips and tools - Excel file.xlsx.xlsx 2.3 MB
  • 34. Financial Statement Analysis - Tesla exercise/2.1 Tesla 2016.pdf.pdf 2.3 MB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/4.1 4. Working with Pivot Tables.xlsx.xlsx 2.0 MB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/6.1 6. Slicers.xlsx.xlsx 2.0 MB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/5.1 5. GetPivotData.xlsx.xlsx 2.0 MB
  • 42. Tesla practical case study - Building a financial planning model/16.1 11. Working capital forecasting_after.xlsx.xlsx 1.6 MB
  • 42. Tesla practical case study - Building a financial planning model/8.1 4a. Gross profit automotive - before.xlsx.xlsx 1.6 MB
  • 42. Tesla practical case study - Building a financial planning model/27.1 20. Complete the BS_after.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/26.1 19. Cash flow_complete_after.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/27.2 20. Complete the BS_before.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/26.2 19. Cash flow_complete_before.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/25.1 18. P&L complete_after.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/24.1 17. Financing_after.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/25.2 18. P&L complete_before.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/24.2 17. Financing_before.xlsx.xlsx 1.5 MB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/2.1 2. Creating a Pivot Table.xlsx.xlsx 1.5 MB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/3.1 3. Formatting a Pivot Table.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/23.1 16a. Complete UFCF_after.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/23.2 16a. Complete UFCF_before.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/22.2 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/22.1 16. Balance Sheet forecasting liabilities_before.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/20.2 14. Cash flow - UFCF_after.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/20.1 14. Cash flow - UFCF_before.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/19.2 13. Calculating working capital_after.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/19.1 13. Calculating working capital_before.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/18.1 12a. P&L fill in_after.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/18.2 12a. P&L fill in_before.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/17.1 12. P&L.xlsx.xlsx 1.5 MB
  • 42. Tesla practical case study - Building a financial planning model/16.2 11. Working capital forecasting_before.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/15.1 10a. PP&E comparison.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/14.1 10. PP&E schedule_after.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/13.2 9. PP&E forecasting and comparables_after.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/14.2 10. PP&E schedule_before.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/13.1 9. PP&E forecasting and comparables_before.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/12.1 8. Opex - After.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/12.2 8. Opex - Before.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/11.2 7. Energy and Other - Gross profit, cost of sales - After.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/11.1 7. Energy and Other - Gross profit, cost of sales - Before.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/10.1 6. Energy and Other revenue - After.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/10.2 6. Energy and Other revenue - Before.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/9.1 5. Cost of sales and chart.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/8.2 4a. Gross profit automotive - after.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/7.1 4. Gross profit automotive.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/6.1 3. Revenue calculation and scenarios - after.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/5.1 2. Average price_after.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/6.2 3. Revenue calculation and scenarios - before.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/5.2 2. Average price_before.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/4.1 1a. Deliveries development.xlsx.xlsx 1.4 MB
  • 34. Financial Statement Analysis - Tesla exercise/2.2 Tesla 2015.pdf.pdf 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/3.1 1. Deliveries_after.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/3.2 1. Deliveries_before.xlsx.xlsx 1.4 MB
  • 42. Tesla practical case study - Building a financial planning model/2.1 0aa. Inputs_before.xlsx.xlsx 1.3 MB
  • 34. Financial Statement Analysis - Tesla exercise/5.1 Tesla - Financial Statement Analysis - Solvency_after.xlsx.xlsx 1.3 MB
  • 42. Tesla practical case study - Building a financial planning model/2.2 0aa. Inputs_after.xlsx.xlsx 1.3 MB
  • 34. Financial Statement Analysis - Tesla exercise/5.2 Tesla - Financial Statement Analysis - Solvency_before.xlsx.xlsx 1.3 MB
  • 34. Financial Statement Analysis - Tesla exercise/4.2 Tesla - Financial Statement Analysis - Liquidity_after.xlsx.xlsx 1.3 MB
  • 34. Financial Statement Analysis - Tesla exercise/3.1 Tesla - Financial Statement Analysis - Growth and Profitability_after.xlsx.xlsx 1.3 MB
  • 34. Financial Statement Analysis - Tesla exercise/3.2 Tesla - Financial Statement Analysis - Growth and Profitability_before.xlsx.xlsx 1.3 MB
  • 34. Financial Statement Analysis - Tesla exercise/4.1 Tesla - Financial Statement Analysis - Liquidity_before.xlsx.xlsx 1.3 MB
  • 42. Tesla practical case study - Building a financial planning model/1.2 0a. Drivers_after.xlsx.xlsx 1.3 MB
  • 42. Tesla practical case study - Building a financial planning model/1.1 0a. Drivers_before.xlsx.xlsx 1.3 MB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/18.4 Microsoft Excel Shortcuts for PC.pdf.pdf 1.3 MB
  • 14. Accounting - Introduction to Accounting & Bookkeeping/1.1 Accounting & Financial Statement Analysis - Notes.pdf.pdf 1.3 MB
  • 14. Accounting - Introduction to Accounting & Bookkeeping/2.1 Accounting & Financial Statement Analysis - Notes.pdf.pdf 1.2 MB
  • 14. Accounting - Introduction to Accounting & Bookkeeping/4.1 Accounting & Financial Statement Analysis - Notes.pdf.pdf 1.2 MB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/8.2 4. Course Challenge.pptx.pptx 1.2 MB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/11.3 Excel functions.xlsx.xlsx 994.3 kB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/1.1 The Complete Financial Analyst Course - Financial items.pdf.pdf 911.4 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/7.2 Default risk.pdf.pdf 902.0 kB
  • 3. Microsoft Excel - Useful Tools/9.3 Pivot Table_solved.xlsm.xlsm 875.4 kB
  • 38. Finance 101 - The Value of Cash Flows with Different Timing/1.1 1. Calculating Future Cash Flows.pdf.pdf 829.7 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/4.2 Interest rate components.pdf.pdf 826.9 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/2.2 Time value of money.pdf.pdf 795.9 kB
  • 32. Financial Statement Analysis - Subtleties/1.1 Financial Statement Analysis - Notes.pdf.pdf 791.4 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/18.1 Microsoft Excel Shortcuts for MAC.pdf.pdf 787.7 kB
  • 43. PowerPoint - Introduction to PowerPoint/5.1 PowerPoint Master Class - Shortcuts.pdf.pdf 768.3 kB
  • 23. Advanced Accounting - Trade receivables/1.1 The Complete Financial Analyst Course - Trade receivables, Inventory, Fixed assets.pdf.pdf 723.5 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/1.1 Financial Modeling Notes.pdf.pdf 706.6 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/1.1 Finance 101 - Introduction to the World of Finance.pdf.pdf 706.3 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/2.1 Finance 101 - Introduction to the World of Finance.pdf.pdf 706.3 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/3.1 Finance 101 - Introduction to the World of Finance.pdf.pdf 706.3 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/4.1 Finance 101 - Introduction to the World of Finance.pdf.pdf 706.3 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/5.1 Finance 101 - Introduction to the World of Finance.pdf.pdf 706.3 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/6.1 Finance 101 - Introduction to the World of Finance.pdf.pdf 706.3 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/7.1 Finance 101 - Introduction to the World of Finance.pdf.pdf 706.3 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/8.1 Finance 101 - Introduction to the World of Finance.pdf.pdf 706.3 kB
  • 3. Microsoft Excel - Useful Tools/9.1 Pivot Table_unsolved.xlsm.xlsm 662.0 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/8.2 Fixing references - Solved.xlsx.xlsx 660.7 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/8.1 Fixing references – Unsolved.xlsx.xlsx 659.4 kB
  • 3. Microsoft Excel - Useful Tools/7.3 Freeze Panes - Solved.xlsx.xlsx 659.4 kB
  • 3. Microsoft Excel - Useful Tools/7.1 Freeze Panes – Unsolved.xlsx.xlsx 659.3 kB
  • 34. Financial Statement Analysis - Tesla exercise/2.4 Tesla 2018 Q2.pdf.pdf 650.3 kB
  • 33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/3.1 2. Course Challenge.xlsx.xlsx 642.7 kB
  • 1. Welcome! Course Introduction/1.1 Financial Analyst - Course Curriculum.pdf.pdf 595.3 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/4.2 Course notes - Building a financial model.pdf.pdf 589.0 kB
  • 39. Finance 101 - Loan Calculations/3.1 3. Course Challenge.xlsx.xlsx 550.6 kB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/8.1 1. Course Challenge.xlsx.xlsx 517.6 kB
  • 16. Accounting - Revenue recognition/1.1 The Complete Financial Analyst Course - Revenue recognition.pdf.pdf 506.2 kB
  • 32. Financial Statement Analysis - Subtleties/4.1 Working Capital Days.pdf.pdf 349.0 kB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/8.3 4. Course Challenge - Tasks.pdf.pdf 289.8 kB
  • 38. Finance 101 - The Value of Cash Flows with Different Timing/2.1 2. NPV.pdf.pdf 196.8 kB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/1.3 Practical Exercise - List of transactions.pdf.pdf 186.9 kB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/2.1 Practical Exercise - List of transactions.pdf.pdf 186.9 kB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/3.1 Practical Exercise - List of transactions.pdf.pdf 186.9 kB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/4.1 Practical Exercise - List of transactions.pdf.pdf 186.9 kB
  • 24. Advanced Accounting - Inventory/4.4 Inventory Cost Flow Methods – with solutions.pptx.pptx 179.2 kB
  • 24. Advanced Accounting - Inventory/4.1 Inventory Cost Flow Methods.pptx.pptx 172.6 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/16.1 Y-o-Y Function explanation.pdf.pdf 168.9 kB
  • 28. Advanced Accounting - Leasing Liabilties/2.1 Leasing exercises.pdf.pdf 159.9 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/17.4 Sort data - Solved.xlsx.xlsx 149.1 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/17.3 Sort data – Unsolved.xlsx.xlsx 148.8 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/2.2 03 28 Macros Solved.xlsx.xlsx 148.5 kB
  • 3. Microsoft Excel - Useful Tools/6.3 03 31 Hyperlinks Solved.xlsx.xlsx 140.4 kB
  • 3. Microsoft Excel - Useful Tools/6.2 03 31 Hyperlinks Exercise & Text.xlsx.xlsx 140.2 kB
  • 2. Microsoft Excel - Quick Introduction/10.2 02 12 Functions Solved.xlsx.xlsx 83.0 kB
  • 2. Microsoft Excel - Quick Introduction/8.1 02 11 Formulas Solved.xlsx.xlsx 82.1 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/16.4 03 29 Drop-down List Solved.xlsx.xlsx 78.9 kB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/5.1 1.18_after.xlsx.xlsx 74.3 kB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/4.1 1.17_after.xlsx.xlsx 72.0 kB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/3.2 1.16_after.xlsx.xlsx 71.2 kB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/5.2 1.18_before.xlsx.xlsx 69.3 kB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/2.2 1.15_after.xlsx.xlsx 69.2 kB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/4.2 1.17_before.xlsx.xlsx 67.2 kB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/1.1 1.14_after.xlsx.xlsx 63.6 kB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/2.1 1.15_before.xlsx.xlsx 60.3 kB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/3.1 1.16_before.xlsx.xlsx 60.3 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/5.1 1.13_after.xlsx.xlsx 59.1 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/7.1 1.7_after.xlsx.xlsx 58.5 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/4.3 1.12_after.xlsx.xlsx 58.0 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/16.3 15. Adding % variations_after.xlsm.xlsm 57.9 kB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/1.2 1.14_before.xlsx.xlsx 57.1 kB
  • 21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/5.1 Cash-Flow.xlsx.xlsx 56.7 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/3.2 1.11_after.xlsx.xlsx 56.4 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/8.2 1.8_after.xlsx.xlsx 56.3 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/1.2 1.9_after.xlsx.xlsx 56.3 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/15.1 14. Countif_after.xlsm.xlsm 56.1 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/16.2 15. Adding % variations_before.xlsm.xlsm 56.1 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/2.2 1.10_after.xlsx.xlsx 56.0 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/5.2 1.13_before.xlsx.xlsx 56.0 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/6.1 1.6_after.xlsx.xlsx 55.7 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/4.1 1.12_before.xlsx.xlsx 54.8 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/14.2 13. Formatting the P&L_after.xlsm.xlsm 54.8 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/15.2 14. Countif_before.xlsm.xlsm 54.8 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/2.1 1.10_before.xlsx.xlsx 54.4 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/3.1 1.11_before.xlsx.xlsx 54.4 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/1.1 1.9_before.xlsx.xlsx 54.1 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/14.1 13. Formatting the P&L_before.xlsm.xlsm 53.2 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/13.2 12. Formatting the P&L_after.xlsm.xlsm 53.2 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/13.1 12. Formatting a P&L_before.xlsm.xlsm 53.1 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/12.2 11. Building a P&L_after.xlsm.xlsm 53.1 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/10.1 10a. Mapping_before.xlsm.xlsm 52.2 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/10.2 10a. Mapping.xlsm.xlsm 52.2 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/24.1 8. F2.xlsm.xlsm 52.0 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/6.1 F5 go to.xlsm.xlsm 52.0 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/8.1 1.8_before.xlsx.xlsx 51.5 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/11.2 10. Mapping_after.xlsm.xlsm 51.4 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/12.1 11. Building a P&L_before.xlsm.xlsm 51.4 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/7.2 1.7_before.xlsx.xlsx 51.0 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/11.1 10. Mapping_before.xlsm.xlsm 50.9 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/8.2 8. Sumif_after.xlsm.xlsm 50.7 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/6.2 1.6_before.xlsx.xlsx 48.6 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/2.1 3. Enlarge the formula bar.xlsm.xlsm 48.0 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/7.1 7. Vlookup_after.xlsm.xlsm 45.5 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/8.1 8. Sumif_before.xlsm.xlsm 45.5 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/5.1 03 18 Fast Scrolling Solved.xlsx.xlsx 45.4 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/5.4 03 18 Fast Scrolling Exercise & Text.xlsx.xlsx 45.0 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/4.2 4. Order a worksheet_before.xlsm.xlsm 44.1 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/3.1 3. Get to know the data source.xlsm.xlsm 44.1 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/5.2 5. Creating a code_after.xlsm.xlsm 42.7 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/6.1 6. Creating a database_before.xlsm.xlsm 42.7 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/5.2 1.5_after.xlsx.xlsx 42.7 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/25.1 14. Clarification - conditional formatting.xlsx.xlsx 42.7 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/3.2 1.3_after.xlsx.xlsx 42.5 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/4.2 1.4_after.xlsx.xlsx 42.2 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/9.2 9. Index Match_before.xlsm.xlsm 42.0 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/4.1 4. Order a worksheet_after.xlsm.xlsm 42.0 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/5.1 5. Creating a code_before.xlsm.xlsm 42.0 kB
  • 41. Capital Budgeting - A Complete Case Study/12.2 10. Sensitivity analysis.xlsx.xlsx 41.7 kB
  • 41. Capital Budgeting - A Complete Case Study/11.2 9. Discounted cash flow.xlsx.xlsx 40.6 kB
  • 41. Capital Budgeting - A Complete Case Study/12.1 10. Sensitivity analysis_unsolved.xlsx.xlsx 40.6 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/7.2 7. Vlookup_before.xlsm.xlsm 40.5 kB
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/6.2 6. Creating a database_after.xlsm.xlsm 40.3 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/5.1 1.5_before.xlsx.xlsx 40.2 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/20.2 4. Find and Replace references_before.xlsx.xlsx 39.7 kB
  • 41. Capital Budgeting - A Complete Case Study/11.1 9. Discounted cash flow_unsolved.xlsx.xlsx 39.6 kB
  • 41. Capital Budgeting - A Complete Case Study/10.2 8. WACC.xlsx.xlsx 38.9 kB
  • 41. Capital Budgeting - A Complete Case Study/9.1 8. WACC.xlsx.xlsx 38.9 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/20.1 4. Find and Replace references_after.xlsx.xlsx 38.8 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/4.1 1.4_before.xlsx.xlsx 38.5 kB
  • 41. Capital Budgeting - A Complete Case Study/10.1 8. WACC_unsolved.xlsx.xlsx 36.8 kB
  • 41. Capital Budgeting - A Complete Case Study/9.2 8. WACC_unsolved.xlsx.xlsx 36.8 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/2.2 1.2_after.xlsx.xlsx 35.1 kB
  • 2. Microsoft Excel - Quick Introduction/6.1 02 7 Basic Manipulations Solved.xlsx.xlsx 33.7 kB
  • 2. Microsoft Excel - Quick Introduction/3.3 02 9 Data Entry Solved.xlsx.xlsx 33.5 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/1.2 1.1_after.xlsx.xlsx 33.5 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/3.1 1.3_before.xlsx.xlsx 33.1 kB
  • 41. Capital Budgeting - A Complete Case Study/8.2 7. Cash flow.xlsx.xlsx 32.1 kB
  • 41. Capital Budgeting - A Complete Case Study/7.1 6. P&L.xlsx.xlsx 31.8 kB
  • 41. Capital Budgeting - A Complete Case Study/6.1 5. Financing.xlsx.xlsx 31.7 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/2.1 1.2_before.xlsx.xlsx 31.2 kB
  • 41. Capital Budgeting - A Complete Case Study/6.2 5. Financing_unsolved.xlsx.xlsx 30.7 kB
  • 41. Capital Budgeting - A Complete Case Study/7.2 6. P&L_unsolved.xlsx.xlsx 30.4 kB
  • 41. Capital Budgeting - A Complete Case Study/8.1 7. Cash flow_unsolved.xlsx.xlsx 30.4 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/10.3 03 24 Select Special (F5) Solved.xlsx.xlsx 22.8 kB
  • 41. Capital Budgeting - A Complete Case Study/5.2 4. Working Capital.xlsx.xlsx 22.5 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/10.2 03 24 Select Special (F5) Exercise & Text.xlsx.xlsx 22.1 kB
  • 41. Capital Budgeting - A Complete Case Study/5.1 4. Working Capital_unsolved.xlsx.xlsx 21.7 kB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/4.2 Exercise - Part Four.xlsx.xlsx 21.2 kB
  • 6. Microsoft Excel - Financial functions in Excel/3.1 05 15 PMT.xlsx.xlsx 20.7 kB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/2.2 Exercise - Part Two.xlsx.xlsx 20.6 kB
  • 41. Capital Budgeting - A Complete Case Study/4.1 3. Fixed Asset Rollforward.xlsx.xlsx 20.1 kB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/3.2 Exercise - Part Three.xlsx.xlsx 19.8 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/1.3 1.1_before.xlsx.xlsx 19.2 kB
  • 41. Capital Budgeting - A Complete Case Study/4.2 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx 19.0 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/1.2 IF function_after.xlsm.xlsm 18.4 kB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/1.2 Exercise Part One.xlsx.xlsx 17.9 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/19.2 1. Multiply by 1_after.xlsx.xlsx 17.6 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/21.1 5. Find replace_after.xlsx.xlsx 17.6 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/21.2 5. Find replace_before.xlsx.xlsx 17.6 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/23.1 7. Beauty saving_before.xlsx.xlsx 17.6 kB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/1.1 Exercise - Before Solutions.xlsx.xlsx 17.5 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/23.2 7. Beauty saving_after.xlsx.xlsx 17.5 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/10.2 Show that = and + are interchangeable_after.xlsm.xlsm 17.4 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/10.1 Show that = and + are interchangeable_before.xlsm.xlsm 17.4 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/1.1 IF function_before.xlsm.xlsm 17.4 kB
  • 41. Capital Budgeting - A Complete Case Study/3.2 2. Savings Forecast.xlsx.xlsx 17.0 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/19.1 1. Multiply by 1_before.xlsx.xlsx 16.9 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18.3 05 47 Goal Seek Solved.xlsx.xlsx 16.6 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/4.2 05-38-Counts-Solved.xlsx.xlsx 16.5 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18.4 05 47 Goal Seek Exercise & Text.xlsx.xlsx 16.5 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15.5 05 45 IFERROR Solved.xlsx.xlsx 15.7 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/4.4 05 38 Counts Exercise & Text.xlsx.xlsx 15.6 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/5.1 05 39 Average, AverageIF Solution.xlsx.xlsx 15.4 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/3.2 05 37 Sum, Sumif, Sumifs Solved.xlsx.xlsx 15.2 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/9.1 05 41 MIN MAX Solved.xlsx.xlsx 15.2 kB
  • 41. Capital Budgeting - A Complete Case Study/3.1 2. Savings Forecast_unsolved.xlsx.xlsx 15.1 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/5.3 05 39 Average, AverageIF Exercise & Text.xlsx.xlsx 14.9 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/3.5 05 37 Sum, Sumif, Sumifs Exercise & Text.xlsx.xlsx 14.8 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/9.4 05 41 MIN MAX Exercise & Text.xlsx.xlsx 14.7 kB
  • 42. Tesla practical case study - Building a financial planning model/3. Forecasting Tesla's expected deliveries.vtt 14.7 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15.2 05 45 IFERROR Exercise & Text.xlsx.xlsx 14.6 kB
  • 33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/1.3 P&G Financials.xlsx.xlsx 14.6 kB
  • 33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/2.1 P&G Financials.xlsx.xlsx 14.6 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/12.5 05 43 Vlookup, Hlookup Solved.xlsx.xlsx 14.5 kB
  • 33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/1.2 P&G Financials_WithRatios.xlsx.xlsx 14.3 kB
  • 33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/2.4 P&G Financials_WithRatios.xlsx.xlsx 14.3 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/12.1 Dynamic Naming - Solved.xlsx.xlsx 14.2 kB
  • 35. Working capital management/10.2 Working capital test_solved.xlsx.xlsx 13.9 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/12.4 Dynamic Naming – Unsolved.xlsx.xlsx 13.9 kB
  • 2. Microsoft Excel - Quick Introduction/13.1 02 14 Paste Special Exercise & Text.xlsx.xlsx 13.8 kB
  • 2. Microsoft Excel - Quick Introduction/13.3 02 14 Paste Special Solved.xlsx.xlsx 13.8 kB
  • 2. Microsoft Excel - Quick Introduction/10.3 02 12 Functions Exercise & Text.xlsx.xlsx 13.6 kB
  • 8. Microsoft Excel - Building Professional Charts in Excel/5.1 Bridge Charts.xlsx.xlsx 13.4 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/20.3 05 48 Sensitivity Analysis Solved.xlsx.xlsx 13.4 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/3.1 Sum, Sumif, Sumifs – Solved.xlsx.xlsx 13.3 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/3.3 Sum, Sumif, Sumifs - Unsolved.xlsx.xlsx 13.2 kB
  • 33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/1.4 P&G Financials_Before.xlsx.xlsx 13.1 kB
  • 33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/2.3 P&G Financials_Before.xlsx.xlsx 13.1 kB
  • 35. Working capital management/10.1 Working capital test_unsolved.xlsx.xlsx 13.0 kB
  • 8. Microsoft Excel - Building Professional Charts in Excel/6.1 Treemap Charts.xlsx.xlsx 12.9 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/16.2 RANK function_after.xlsx.xlsx 12.9 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/20.4 05 48 Sensitivity Analysis Exercise & Text.xlsx.xlsx 12.9 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/3.3 How to save macros_after.xlsm.xlsm 12.9 kB
  • 2. Microsoft Excel - Quick Introduction/11.2 02 13 Copy Cut Paste Solved.xlsx.xlsx 12.9 kB
  • 24. Advanced Accounting - Inventory/4.3 Inventory Cost Flow Methods_solved.xlsx.xlsx 12.7 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/16.1 RANK function_before.xlsx.xlsx 12.6 kB
  • 6. Microsoft Excel - Financial functions in Excel/4.1 05 16 Date Functions.xlsx.xlsx 12.5 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/6.4 05 40 2 Left, Right etc Solved.xlsx.xlsx 12.5 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/13.1 05 44 Index, Match Solved.xlsx.xlsx 12.4 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/22.1 6. Green references.xlsx.xlsx 12.3 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/12.3 05 43 Vlookup, Hlookup Exercise & Text.xlsx.xlsx 12.2 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/12.3 03 25 Assigning Dynamic Names Solved.xlsx.xlsx 12.0 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/17.1 05 46 Choose Solved.xlsx.xlsx 12.0 kB
  • 2. Microsoft Excel - Quick Introduction/8.4 02 11 Formulas Exercise Text.xlsx.xlsx 12.0 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/11.2 05 42 Round Solved.xlsx.xlsx 12.0 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/6.2 05 40 2 Left, Right etc Exercise & Text.xlsx.xlsx 12.0 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/13.4 Index & Match – Solved.xlsx.xlsx 12.0 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/14.4 03 26 Defining a Named Range Solved.xlsx.xlsx 11.9 kB
  • 2. Microsoft Excel - Quick Introduction/4.3 02 10 Formatting Exercise Text.xlsx.xlsx 11.9 kB
  • 2. Microsoft Excel - Quick Introduction/4.5 02 10 Formatting Solved.xlsx.xlsx 11.9 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/13.2 05 44 Index, Match Exercise & Text.xlsx.xlsx 11.9 kB
  • 24. Advanced Accounting - Inventory/4.2 Inventory Cost Flow Methods_unsolved.xlsx.xlsx 11.8 kB
  • 41. Capital Budgeting - A Complete Case Study/2.1 1. Drivers.xlsx.xlsx 11.8 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/17.2 03 30 Custom Sort Solved.xlsx.xlsx 11.7 kB
  • 3. Microsoft Excel - Useful Tools/4.3 Set Print Area – Unsolved.xlsx.xlsx 11.7 kB
  • 2. Microsoft Excel - Quick Introduction/6.2 02 7 Basic Manipulations Exercise Text.xlsx.xlsx 11.7 kB
  • 3. Microsoft Excel - Useful Tools/1.4 03 20 Alt+Enter Solved.xlsx.xlsx 11.7 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/17.1 03 30 Custom Sort Exercise & Text.xlsx.xlsx 11.6 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/15.3 03 27 Assigning Custom Formats Exercise & Text.xlsx.xlsx 11.6 kB
  • 2. Microsoft Excel - Quick Introduction/11.1 02 13 Copy Cut Paste Exercise Text.xlsx.xlsx 11.6 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/11.1 05 42 Round Exercise & Text.xlsx.xlsx 11.6 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/16.2 03 29 Drop-down List Exercise & Text.xlsx.xlsx 11.6 kB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/1. Case Study - The Accounting Transactions of a Lemonade Stand (14).vtt 11.6 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/17.4 05 46 Choose Exercise & Text.xlsx.xlsx 11.6 kB
  • 3. Microsoft Excel - Useful Tools/2.2 03 21 Text to Columns Solved.xlsx.xlsx 11.6 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/13.3 Index & Match - Unsolved.xlsx.xlsx 11.6 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/4.3 Count, Countif, Countifs – Unsolved.xlsx.xlsx 11.6 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/12.2 03 25 Assigning Dynamic Names Exercise & Text.xlsx.xlsx 11.5 kB
  • 3. Microsoft Excel - Useful Tools/4.1 Set Print Area - Solved.xlsx.xlsx 11.5 kB
  • 6. Microsoft Excel - Financial functions in Excel/2.1 05 14 IRR.xlsx.xlsx 11.5 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/2.3 Creating a Macro - Solved.xlsx.xlsx 11.4 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/12.4 Vlookup, Hlookup – Solved.xlsx.xlsx 11.4 kB
  • 3. Microsoft Excel - Useful Tools/1.5 03 20 Alt+Enter Exercise & Text.xlsx.xlsx 11.4 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/6.1 Text Functions - Solved.xlsx.xlsx 11.4 kB
  • 28. Advanced Accounting - Leasing Liabilties/2.3 Leasing-Exercise-2-Solved.xlsx.xlsx 11.4 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/15.2 03 27 Assigning Custom Formats Solved.xlsx.xlsx 11.3 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/14.5 03 26 Defining a Named Range Exercise & Text.xlsx.xlsx 11.3 kB
  • 2. Microsoft Excel - Quick Introduction/3.1 02 9 Data Entry Exercise Text.xlsx.xlsx 11.2 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/8.1 Work with text_after.xlsx.xlsx 11.2 kB
  • 2. Microsoft Excel - Quick Introduction/2.3 02 6 Overview of Excel Solved.xlsx.xlsx 11.1 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/16.5 Data Validation - Solved.xlsx.xlsx 11.1 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/16.3 Data Validation – Unsolved.xlsx.xlsx 11.1 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/8.5 03 19 Fixing Cells Solved.xlsx.xlsx 11.1 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/1.3 03 17 Formatting a Worksheet Solved.xlsx.xlsx 11.0 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/12.1 Vlookup, Hlookup - Unsolved.xlsx.xlsx 11.0 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/8.4 03 19 Fixing Cells Exercise & Text.xlsx.xlsx 10.9 kB
  • 6. Microsoft Excel - Financial functions in Excel/1.1 05-12-FV-PV_revised.xlsx.xlsx 10.9 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/1.5 03 17 Formatting a Worksheet Exercise & Text.xlsx.xlsx 10.9 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/6.3 Text Functions - Unsolved.xlsx.xlsx 10.9 kB
  • 3. Microsoft Excel - Useful Tools/2.5 03 21 Text to Columns Exercise & Text.xlsx.xlsx 10.8 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/10.1 Select Special.xlsx.xlsx 10.8 kB
  • 34. Financial Statement Analysis - Tesla exercise/3. Calculating and analyzing growth and profitability ratios.vtt 10.7 kB
  • 2. Microsoft Excel - Quick Introduction/2.1 02 6 Overview of Excel Exercise & Text.xlsx.xlsx 10.7 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/2.5 03 28 Macros Exercise & Text.xlsx.xlsx 10.6 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/14.2 Naming ranges - Solved.xlsx.xlsx 10.6 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/8.2 Work with text_before.xlsx.xlsx 10.6 kB
  • 3. Microsoft Excel - Useful Tools/5.2 03 22 Wrap Text Solved.xlsx.xlsx 10.4 kB
  • 3. Microsoft Excel - Useful Tools/5.3 03 22 Wrap Text Exercise & Text.xlsx.xlsx 10.4 kB
  • 35. Working capital management/2. The importance of working capital optimization case study.vtt 10.4 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/5.3 Fast scrolling – Unsolved.xlsx.xlsx 10.3 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/5.5 Fast scrolling - Solved.xlsx.xlsx 10.3 kB
  • 35. Working capital management/4. Trade receivables management.vtt 10.2 kB
  • 3. Microsoft Excel - Useful Tools/2.3 Text to columns - Solved.xlsx.xlsx 10.1 kB
  • 38. Finance 101 - The Value of Cash Flows with Different Timing/1.2 3.1 Present Value of Cash Flows.xlsx.xlsx 10.1 kB
  • 2. Microsoft Excel - Quick Introduction/4.4 Formatting - Solved.xlsx.xlsx 10.1 kB
  • 3. Microsoft Excel - Useful Tools/2.4 Text to columns – Unsolved.xlsx.xlsx 10.0 kB
  • 1. Welcome! Course Introduction/2.1 Quick win.xlsx.xlsx 10.0 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/17.2 Choose - Solved.xlsx.xlsx 9.9 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/2.4 Creating a Macro - Unsolved.xlsx.xlsx 9.9 kB
  • 3. Microsoft Excel - Useful Tools/1.3 Alt + Enter - Solved.xlsx.xlsx 9.9 kB
  • 3. Microsoft Excel - Useful Tools/1.1 Alt + Enter – Unsolved.xlsx.xlsx 9.9 kB
  • 28. Advanced Accounting - Leasing Liabilties/2.2 Leasing Exercise 2 - Unsolved.xlsx.xlsx 9.9 kB
  • 3. Microsoft Excel - Useful Tools/5.4 Wrap text – Unsolved.xlsx.xlsx 9.8 kB
  • 3. Microsoft Excel - Useful Tools/5.5 Wrap text - Solved.xlsx.xlsx 9.8 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15.3 Iferror.xlsx.xlsx 9.8 kB
  • 8. Microsoft Excel - Building Professional Charts in Excel/7.1 Sparklines.xlsx.xlsx 9.8 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/1.1 Formatting a worksheet - Solved.xlsx.xlsx 9.8 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/20.2 Data Tables - Solved.xlsx.xlsx 9.7 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15.4 Iferror – Unsolved.xlsx.xlsx 9.6 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/5.5 Average, Averageif - Solved.xlsx.xlsx 9.6 kB
  • 2. Microsoft Excel - Quick Introduction/8.3 Formulas - Solved.xlsx.xlsx 9.6 kB
  • 2. Microsoft Excel - Quick Introduction/10.1 Functions - Solved.xlsx.xlsx 9.6 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/17.5 Choose – Unsolved.xlsx.xlsx 9.6 kB
  • 2. Microsoft Excel - Quick Introduction/8.5 Formulas – Unsolved.xlsx.xlsx 9.5 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/20.1 Data Tables – Unsolved.xlsx.xlsx 9.5 kB
  • 2. Microsoft Excel - Quick Introduction/10.4 Functions – Unsolved.xlsx.xlsx 9.5 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/9.5 Max, min – Solved.xlsx.xlsx 9.4 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/5.4 Average, Averageif – Unsolved.xlsx.xlsx 9.2 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/1.2 Formatting a worksheet – Unsolved.xlsx.xlsx 9.2 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/9.2 Max, min - Unsolved.xlsx.xlsx 9.2 kB
  • 2. Microsoft Excel - Quick Introduction/4.1 Formatting - Unsolved.xlsx.xlsx 9.1 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18.5 Goal Seek - Solved.xlsx.xlsx 9.1 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18.2 Goal Seek – Unsolved.xlsx.xlsx 9.1 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/3.2 Another file.xlsx.xlsx 9.0 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/14.3 Naming ranges – Unsolved.xlsx.xlsx 9.0 kB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/2. Case Study - The Accounting Transactions of a Lemonade Stand (24).vtt 8.7 kB
  • 32. Financial Statement Analysis - Subtleties/5. Using Accounting Ratios to Assess Business Performance.vtt 8.3 kB
  • 2. Microsoft Excel - Quick Introduction/3.2 Data Entry.xlsx.xlsx 8.3 kB
  • 2. Microsoft Excel - Quick Introduction/6.3 Data Entry.xlsx.xlsx 8.3 kB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/3. Case Study - The Accounting Transactions of a Lemonade Stand (34).vtt 8.1 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/12. Excel's Lookup Functions Vlookup & Hlookup Made Easy.vtt 8.0 kB
  • 21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/5. Calculating Cash Flow in practice A complete example.vtt 7.9 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/13. Index, Match, and Their Combination - The Perfect Substitute for Vlookup.vtt 7.8 kB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/7. Practical Exercise - Creating an Organisational Chart.vtt 7.7 kB
  • 20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/4. Case Study - The Accounting Transactions of a Lemonade Stand (44).vtt 7.6 kB
  • 40. Capital Budgeting - Basic notions/5. Cost of Equity.vtt 7.6 kB
  • 34. Financial Statement Analysis - Tesla exercise/4. Calculating and analyzing liquidity ratios.vtt 7.6 kB
  • 41. Capital Budgeting - A Complete Case Study/10. Estimating cost of equity.vtt 7.3 kB
  • 31. Financial Statement Analysis - An Introduction/2. Finding, Downloading and Going Through the Annual Report of P&G.vtt 7.3 kB
  • 30. Advanced Accounting - Raising equity, types of equity, and dividend payments/2. Raising equity in different stages of a company's lifecycle.vtt 7.3 kB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/5. Calculating Cash flows and completing the model.vtt 7.2 kB
  • 1. Welcome! Course Introduction/1. What Does the Course Cover.vtt 7.2 kB
  • 22. Accounting - The Importance of Timing/2. Timing of Income Principles of Revenue Recognition.vtt 6.9 kB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/8. GetPivotData is great! Extracting data from the Master Pivot Table.vtt 6.9 kB
  • 33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).vtt 6.9 kB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/5. Types of expenses.vtt 6.8 kB
  • 40. Capital Budgeting - Basic notions/9. Modeling Future Cash Flows.vtt 6.8 kB
  • 39. Finance 101 - Loan Calculations/2. Calculating a Complete Loan Schedule.vtt 6.7 kB
  • 6. Microsoft Excel - Financial functions in Excel/1. Discounting cash flows in Microsoft Excel.vtt 6.5 kB
  • 40. Capital Budgeting - Basic notions/4. Calculating Present and Future Value.vtt 6.4 kB
  • 16. Accounting - Revenue recognition/2. The importance of timing when recognizing revenues.vtt 6.4 kB
  • 16. Accounting - Revenue recognition/5. A practical example.vtt 6.4 kB
  • 41. Capital Budgeting - A Complete Case Study/2. Organizing inputs in the Drivers sheet.vtt 6.4 kB
  • 19. Accounting - The Core Principles of Accounting/6. The Double-Entry Principle - The Core Principle of Bookkeeping.vtt 6.4 kB
  • 35. Working capital management/7. Inventory optimization techniques.vtt 6.3 kB
  • 14. Accounting - Introduction to Accounting & Bookkeeping/2. What is Accounting and Why Do You Need It.vtt 6.3 kB
  • 42. Tesla practical case study - Building a financial planning model/13. Building a fixed asset roll forward estimating Capex.vtt 6.2 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/3.1 How to save macros_before.xlsx.xlsx 6.2 kB
  • 35. Working capital management/9. Working capital optimization - a roadmap.vtt 6.1 kB
  • 6. Microsoft Excel - Financial functions in Excel/3. Using the PMT function to create a complete loan schedule.vtt 6.0 kB
  • 42. Tesla practical case study - Building a financial planning model/20. Forecasting Unlevered Free Cash Flow.vtt 5.9 kB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/2. Building a Financial liabilities schedule.vtt 5.9 kB
  • 25. Advanced Accounting - Fixed Assets/5. The revaluation model.vtt 5.8 kB
  • 22. Accounting - The Importance of Timing/4. The Four Type of Accruals Arising in Accounting Transactions.vtt 5.7 kB
  • 25. Advanced Accounting - Fixed Assets/6. The revaluation model - practical exercise.vtt 5.7 kB
  • 6. Microsoft Excel - Financial functions in Excel/4. Date functions in Excel.vtt 5.7 kB
  • 24. Advanced Accounting - Inventory/3. Cost flow methods.vtt 5.7 kB
  • 19. Accounting - The Core Principles of Accounting/5. How to Calculate Depreciation Expense.vtt 5.6 kB
  • 38. Finance 101 - The Value of Cash Flows with Different Timing/1. Calculating the Present Value of Future Cash Flows.vtt 5.6 kB
  • 43. PowerPoint - Introduction to PowerPoint/2. The Structure of the PowerPoint Ribbon.vtt 5.6 kB
  • 2. Microsoft Excel - Quick Introduction/4. How to Make Your Spreadsheets Look Professional.vtt 5.6 kB
  • 29. Advanced Accounting - Using leverage/1. What is leverage and why companies use financial leverage.vtt 5.5 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/4. Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %.vtt 5.5 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/1. Calculating historical percentage ratios and use Index and Match for scenarios.vtt 5.4 kB
  • 41. Capital Budgeting - A Complete Case Study/4. Preparing a fixed asset rollforward schedule.vtt 5.4 kB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/7. Depreciation & Amortization.vtt 5.4 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/7. Using Index, Match, Match to fill in the output Balance sheet.vtt 5.4 kB
  • 28. Advanced Accounting - Leasing Liabilties/2. Solving a complete leasing exercise.vtt 5.3 kB
  • 42. Tesla practical case study - Building a financial planning model/12. Forecasting operating expenses.vtt 5.3 kB
  • 43. PowerPoint - Introduction to PowerPoint/8. How to Edit Shapes in Your Presentation.vtt 5.3 kB
  • 19. Accounting - The Core Principles of Accounting/3. T-Accounts The Best Way to Understand Debits and Credits.vtt 5.3 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/6. Key Excel Functions Left, Right, Mid, Upper, Lower, Proper, Concatenate, &.vtt 5.2 kB
  • 42. Tesla practical case study - Building a financial planning model/24. Modeling Tesla's financing needs in the forecast period.vtt 5.2 kB
  • 43. PowerPoint - Introduction to PowerPoint/11. Using Slide Masters.vtt 5.0 kB
  • 35. Working capital management/6. Economic order quantity (EOQ).vtt 5.0 kB
  • 25. Advanced Accounting - Fixed Assets/4. Intangible assets with finite life vs. Intangible assets with infinite life.vtt 4.9 kB
  • 42. Tesla practical case study - Building a financial planning model/6. Calculating automotive revenue.vtt 4.9 kB
  • 42. Tesla practical case study - Building a financial planning model/5. Estimating an average selling price of Tesla vehicles.vtt 4.9 kB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/10. Types of liabilities.vtt 4.9 kB
  • 41. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and wrapping up the Case Study.vtt 4.8 kB
  • 30. Advanced Accounting - Raising equity, types of equity, and dividend payments/1. The different types of equity.vtt 4.8 kB
  • 43. PowerPoint - Introduction to PowerPoint/7. How to Easily Align Objects in PowerPoint.vtt 4.8 kB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/2. Join Shapes Together By Using Connector Lines.vtt 4.8 kB
  • 38. Finance 101 - The Value of Cash Flows with Different Timing/2. A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.vtt 4.7 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/20. Perform Sensitivity Analysis with Excel's Data Tables Functionality.vtt 4.7 kB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/12. This is how the report can be used in practice by high-level executives.vtt 4.7 kB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/1. Building a Fixed asset roll forward.vtt 4.7 kB
  • 33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).vtt 4.6 kB
  • 43. PowerPoint - Introduction to PowerPoint/4. Learn How to Insert Objects in PowerPoint.vtt 4.6 kB
  • 43. PowerPoint - Introduction to PowerPoint/3. General Considerations About Slide Structure.vtt 4.5 kB
  • 16. Accounting - Revenue recognition/3. Revenue recognition criteria - technical.vtt 4.5 kB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/4. Additional Techniques That Will Ease Your Work with Pivot Tables.vtt 4.5 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/18. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.vtt 4.5 kB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/3. Building an Equity schedule.vtt 4.5 kB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/8. Types of assets.vtt 4.4 kB
  • 42. Tesla practical case study - Building a financial planning model/21. Forecasting other assets.vtt 4.4 kB
  • 21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/4. Cash Flow computations - The Indirect method.vtt 4.4 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/3. Key Excel Functions Sum, Sumif, Sumifs.vtt 4.4 kB
  • 42. Tesla practical case study - Building a financial planning model/1. Organizing external inputs in a 'Drivers' sheet.vtt 4.4 kB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/9. Asset categories - practical example.vtt 4.4 kB
  • 30. Advanced Accounting - Raising equity, types of equity, and dividend payments/3. The types of dividends companies pay to shareholders.vtt 4.3 kB
  • 42. Tesla practical case study - Building a financial planning model/26. Bridging Unlevered Free Cash Flow to Net Cash Flow.vtt 4.3 kB
  • 42. Tesla practical case study - Building a financial planning model/14. Building a fixed asset roll forward D&A schedule.vtt 4.2 kB
  • 23. Advanced Accounting - Trade receivables/2. What if clients do not pay on time.vtt 4.2 kB
  • 41. Capital Budgeting - A Complete Case Study/3. Modeling expected savings - Building cars in Italy vs. Building cars in Vietnam.vtt 4.2 kB
  • 27. Advanced Accounting - Financial liabilities/3. Debt covenants.vtt 4.2 kB
  • 43. PowerPoint - Introduction to PowerPoint/9. How to Format Text Boxes in a PowerPoint Presentation.vtt 4.2 kB
  • 35. Working capital management/3. Overtrading vs. excessive investment.vtt 4.2 kB
  • 8. Microsoft Excel - Building Professional Charts in Excel/7. How to Represent Trends with Sparklines.vtt 4.2 kB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/6. Welcome to the Future - Pivot Table Slicers.vtt 4.2 kB
  • 29. Advanced Accounting - Using leverage/2. The implications of using excessive leverage.vtt 4.2 kB
  • 45. Bonus lecture/1. Bonus lecture Next steps.html 4.1 kB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/5. Improving the layout and appearance of the FMCG report.vtt 4.1 kB
  • 32. Financial Statement Analysis - Subtleties/3. Horizontal vs. Vertical Financial Statement Analysis.vtt 4.1 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/3. Building an output P&L sheet.vtt 4.1 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/4. Key Excel Functions Count, Counta, Countif, Countifs.vtt 4.1 kB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/5. One of the Most Useful Excel Functions - GetPivotData.vtt 4.1 kB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/2. Creating a Pivot Table Choosing Row and Column Parameters.vtt 4.1 kB
  • 40. Capital Budgeting - Basic notions/8. The Different Cash Flow Types in a Capital Budgeting Exercise.vtt 4.0 kB
  • 30. Advanced Accounting - Raising equity, types of equity, and dividend payments/5. What are share repurchases and why companies do them.vtt 4.0 kB
  • 25. Advanced Accounting - Fixed Assets/1. The different types of fixed assets.vtt 3.9 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/8. Adding the forecast period.vtt 3.9 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/6. Building an output Balance sheet.vtt 3.8 kB
  • 35. Working capital management/5. Re-order level.vtt 3.8 kB
  • 41. Capital Budgeting - A Complete Case Study/8. The project's cash flow calculation.vtt 3.8 kB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/2. Working with an SAP data extraction.vtt 3.7 kB
  • 2. Microsoft Excel - Quick Introduction/10. A Beginner's Introduction to Excel Functions.vtt 3.7 kB
  • 30. Advanced Accounting - Raising equity, types of equity, and dividend payments/6. The idea behind stock splits.vtt 3.7 kB
  • 22. Accounting - The Importance of Timing/3. Timing of Expenses Principles of Cost Recognition.vtt 3.7 kB
  • 32. Financial Statement Analysis - Subtleties/2. First Steps in Financial Statement Analysis.vtt 3.7 kB
  • 39. Finance 101 - Loan Calculations/1. Using Annuities.vtt 3.7 kB
  • 1. Welcome! Course Introduction/2. Everything We Will Learn Has a Practical Application.vtt 3.6 kB
  • 2. Microsoft Excel - Quick Introduction/2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.vtt 3.6 kB
  • 30. Advanced Accounting - Raising equity, types of equity, and dividend payments/4. Dividend payments - a timeline.vtt 3.6 kB
  • 40. Capital Budgeting - Basic notions/6. Project-specific Beta.vtt 3.6 kB
  • 43. PowerPoint - Introduction to PowerPoint/6. Add Frequently Used Buttons to the Quick Access Toolbar.vtt 3.5 kB
  • 26. Advanced Accounting - Trade payables/1. How we account for trade payables.vtt 3.5 kB
  • 17. Accounting - Cost recognition/1. Cost recognition principles.vtt 3.5 kB
  • 14. Accounting - Introduction to Accounting & Bookkeeping/4. An Introduction to Financial Accounting.vtt 3.5 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/4. The Components Forming Interest Rates in Real Life.vtt 3.5 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/3. Building a flexible model with Vlookup & Columns.vtt 3.5 kB
  • 26. Advanced Accounting - Trade payables/3. Why use e-invoicing.vtt 3.4 kB
  • 42. Tesla practical case study - Building a financial planning model/23. Completing Unlevered Free Cash Flow.vtt 3.4 kB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/10. Combining Slicers and GetPivotData The key to our success.vtt 3.4 kB
  • 35. Working capital management/1. Introduction.vtt 3.4 kB
  • 19. Accounting - The Core Principles of Accounting/4. P&L T-Accounts.vtt 3.4 kB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/11. Getting fancy with Excel slicers.vtt 3.4 kB
  • 41. Capital Budgeting - A Complete Case Study/6. Debt repayment and interest expenses calculation.vtt 3.4 kB
  • 14. Accounting - Introduction to Accounting & Bookkeeping/3. The Importance of Bookkeeping - Good Accounting Records Are Essential.vtt 3.4 kB
  • 6. Microsoft Excel - Financial functions in Excel/2. Calculating Internal Rate of Return (IRR) in Excel.vtt 3.4 kB
  • 8. Microsoft Excel - Building Professional Charts in Excel/4. Making Your Excel Charts Sexier - Proven Tips.vtt 3.4 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/5. Forecasting DSO, DPO, DIO, Other assets and Other liabilities.vtt 3.3 kB
  • 41. Capital Budgeting - A Complete Case Study/9. Calculating WACC (Weighted Average Cost of Capital).vtt 3.3 kB
  • 24. Advanced Accounting - Inventory/1. The different types of Inventory we can have.vtt 3.3 kB
  • 1. Welcome! Course Introduction/3. The Best Way to Take This Course.vtt 3.3 kB
  • 18. Accounting - Understanding the Big Picture Why, What, When, and How Much/1. The Revenue Recognition Principle - Why Is it so Important.vtt 3.3 kB
  • 23. Advanced Accounting - Trade receivables/1. Why a company needs to pay attention to trade receivables.vtt 3.3 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/1. Introduction to the Exercise.vtt 3.3 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/5. Calculating percentage variances and applying conditional formatting.vtt 3.3 kB
  • 41. Capital Budgeting - A Complete Case Study/1. An introduction to the Case Study.vtt 3.3 kB
  • 21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/1. Calculating Cash Flows - Understand if a business makes or burns cash.vtt 3.3 kB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/11. Liability categories - practical example.vtt 3.3 kB
  • 41. Capital Budgeting - A Complete Case Study/11. Discounting project cash flows.vtt 3.3 kB
  • 27. Advanced Accounting - Financial liabilities/2. Amortizing a loan.vtt 3.3 kB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/8. COURSE CHALLENGE - Part 4.vtt 3.3 kB
  • 17. Accounting - Cost recognition/2. Technical aspects of cost recognition.vtt 3.2 kB
  • 24. Advanced Accounting - Inventory/2. The connection between Cost of Goods Sold and Inventory.vtt 3.2 kB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/1. The different types of accounting standards.vtt 3.2 kB
  • 18. Accounting - Understanding the Big Picture Why, What, When, and How Much/3. Historical Cost vs. Fair Value Accounting.vtt 3.2 kB
  • 23. Advanced Accounting - Trade receivables/3. How to handle non-paying customers A case-study.vtt 3.2 kB
  • 2. Microsoft Excel - Quick Introduction/3. Data Entry Techniques in Excel.vtt 3.1 kB
  • 42. Tesla practical case study - Building a financial planning model/4. Comparing delivery figures with the ones of industry peers.vtt 3.1 kB
  • 42. Tesla practical case study - Building a financial planning model/10. Forecasting 'energy' and 'services' revenue.vtt 3.1 kB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/3. Types of revenues.vtt 3.1 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/2. Macros Are a Great Timesaver! Here's Why..vtt 3.0 kB
  • 25. Advanced Accounting - Fixed Assets/3. Fair value accounting.vtt 3.0 kB
  • 43. PowerPoint - Introduction to PowerPoint/5. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.vtt 3.0 kB
  • 2. Microsoft Excel - Quick Introduction/8. Excel Formulas for Beginners.vtt 3.0 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/4. Filling in the output P&L sheet with historical financials.vtt 2.9 kB
  • 41. Capital Budgeting - A Complete Case Study/5. Calculating the cash impact of extra working capital required.vtt 2.9 kB
  • 42. Tesla practical case study - Building a financial planning model/8. Calculating automotive gross profit.vtt 2.9 kB
  • 8. Microsoft Excel - Building Professional Charts in Excel/3. Modifying Excel Charts - The Easy Way.vtt 2.9 kB
  • 11. Modeling in Excel - Building a complete 3-statement model/2. Let's create a mapping of financials.vtt 2.9 kB
  • 40. Capital Budgeting - Basic notions/3. The Time Value of Money in a Capital Budgeting Setting.vtt 2.9 kB
  • 31. Financial Statement Analysis - An Introduction/3. What is the Role of Auditing Firms and What Are the Benefits of an Audit.vtt 2.8 kB
  • 27. Advanced Accounting - Financial liabilities/1. The difference between debt and equity.vtt 2.8 kB
  • 18. Accounting - Understanding the Big Picture Why, What, When, and How Much/2. The Expense Recognition Principle - When to Recognize Expenses.vtt 2.8 kB
  • 8. Microsoft Excel - Building Professional Charts in Excel/2. Beginner's Guide to Inserting Charts in Excel.vtt 2.7 kB
  • 34. Financial Statement Analysis - Tesla exercise/2. How to download Tesla's historical financials.vtt 2.7 kB
  • 35. Working capital management/10. Symptoms of inefficient working capital - Trade payables.vtt 2.7 kB
  • 40. Capital Budgeting - Basic notions/2. When Do We Use Capital Budgeting.vtt 2.7 kB
  • 21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/2. The three parts of Cash Flow statements explained.vtt 2.7 kB
  • 42. Tesla practical case study - Building a financial planning model/7. Peer comparison Gross profit %.vtt 2.7 kB
  • 16. Accounting - Revenue recognition/4. Potential conflicts of interest when recognizing revenue.vtt 2.6 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/17. Create Flexible Financial Models with Choose.vtt 2.6 kB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/12. Equity.vtt 2.6 kB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/4. Creating an output structure of the FMCG model.vtt 2.6 kB
  • 21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/3. Cash Flow computations - The Direct method.vtt 2.5 kB
  • 35. Working capital management/8. Trade payables management.vtt 2.5 kB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/4. This is How You Can Fit Text When It Is Larger than a Shape.vtt 2.5 kB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/3. Preliminary mapping of the data extraction.vtt 2.5 kB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/6. Inserting formulas and automating calculations.vtt 2.5 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18. Goal Seek Will Help You Find the Result You Are Looking For.vtt 2.5 kB
  • 25. Advanced Accounting - Fixed Assets/7. Intangible assets created internally.vtt 2.5 kB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/4. Types of revenues - exercise.vtt 2.5 kB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/6. Creating Eye-Catching Text Effects in PowerPoint.vtt 2.5 kB
  • 3. Microsoft Excel - Useful Tools/9. A Quick Introduction to Excel's Pivot Tables.vtt 2.5 kB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/1. Introduction to the Case Study.vtt 2.4 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/8. Using Absolute and Relative Cell References.vtt 2.4 kB
  • 42. Tesla practical case study - Building a financial planning model/22. Forecasting other liabilities.vtt 2.4 kB
  • 42. Tesla practical case study - Building a financial planning model/11. Calculating 'energy' and 'services' gross profit and cost of sales.vtt 2.4 kB
  • 40. Capital Budgeting - Basic notions/7. The Weighted Average Cost of Capital (WACC).vtt 2.4 kB
  • 19. Accounting - The Core Principles of Accounting/1. The Accounting Equation and Its Importance.vtt 2.4 kB
  • 23. Advanced Accounting - Trade receivables/4. A technique to collect trade receivables sooner.vtt 2.4 kB
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/6. Income taxes.vtt 2.4 kB
  • 13. Modeling in Excel - We are almost there! Completing the 3-statement model/4. Preparing a Cash flow structure.vtt 2.3 kB
  • 25. Advanced Accounting - Fixed Assets/2. Capitalizing interest expenses.vtt 2.3 kB
  • 32. Financial Statement Analysis - Subtleties/1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.vtt 2.3 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/6. The Difference Between Fixed and Variable Interest Rates.vtt 2.3 kB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/3. Group or Ungroup Shapes, Pictures or Other Objects.vtt 2.3 kB
  • 27. Advanced Accounting - Financial liabilities/4. Debt covenants - a practical example.vtt 2.2 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.vtt 2.2 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/5. Key Excel Functions Average & Averageif.vtt 2.2 kB
  • 2. Microsoft Excel - Quick Introduction/11. Work Efficiently by Using Cut, Copy, and Paste.vtt 2.2 kB
  • 42. Tesla practical case study - Building a financial planning model/9. Calculating automotive cost of sales.vtt 2.2 kB
  • 41. Capital Budgeting - A Complete Case Study/7. The project's P&L sheet.vtt 2.2 kB
  • 42. Tesla practical case study - Building a financial planning model/19. Calculating investments in working capital.vtt 2.1 kB
  • 3. Microsoft Excel - Useful Tools/2. Do More with Your Sales Data with Excel's Text to Columns Feature.vtt 2.1 kB
  • 42. Tesla practical case study - Building a financial planning model/16. Calculating DSO, DIO, DPO.vtt 2.1 kB
  • 16. Accounting - Revenue recognition/1. Accrual accounting.vtt 2.1 kB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/1. Pivot Tables - Excel's Dynamic and Interactive Tables.vtt 2.1 kB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/3. Design the Layout and Format of Your Pivot Tables.vtt 2.1 kB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/7. Creating a Master Pivot Table The main data source for the FMCG report.vtt 2.1 kB
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/1. Modifying the Beginning and Ending of a Line Object.vtt 2.0 kB
  • 34. Financial Statement Analysis - Tesla exercise/5. Calculating and analyzing solvency ratios.vtt 2.0 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15. Using Excel's Iferror Function to Trap Spreadsheet Errors.vtt 2.0 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/8. Corporate Loan Specifics.vtt 2.0 kB
  • 43. PowerPoint - Introduction to PowerPoint/10. Changing an Object's Size and Rotation.vtt 2.0 kB
  • 33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/3. COURSE CHALLENGE - Part 2.vtt 2.0 kB
  • 19. Accounting - The Core Principles of Accounting/2. Elements of the Accounting System General Ledger.vtt 1.9 kB
  • 14. Accounting - Introduction to Accounting & Bookkeeping/1. Accounting The Science Behind Financial Figures.vtt 1.9 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/3. How Interest Rates Play an Important Role in the Economy.vtt 1.8 kB
  • 40. Capital Budgeting - Basic notions/1. What is Capital Budgeting.vtt 1.8 kB
  • 8. Microsoft Excel - Building Professional Charts in Excel/5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.vtt 1.8 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/16. How to Add a Drop-down List in Excel.vtt 1.8 kB
  • 42. Tesla practical case study - Building a financial planning model/18. Fill in the P&L output sheet.vtt 1.8 kB
  • 12. Modeling in Excel - Let's build a flexible model with multiple scenarios/2. Building a flexible model with Choose & Match.vtt 1.7 kB
  • 2. Microsoft Excel - Quick Introduction/6. Inserting, Deleting, and Modifying Rows & Columns.vtt 1.7 kB
  • 26. Advanced Accounting - Trade payables/2. What is the difference between accounts payable and notes payable.vtt 1.7 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/14. Using Named Ranges to Make Formulas More Readable.vtt 1.7 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/5. The Secret to Faster Scrolling in Excel.vtt 1.7 kB
  • 42. Tesla practical case study - Building a financial planning model/15. Peer comparison D&A as a percentage of revenues.vtt 1.7 kB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/8. COURSE CHALLENGE - Part 1.vtt 1.6 kB
  • 8. Microsoft Excel - Building Professional Charts in Excel/6. New Ways to Visualize Your Data - Treemap Charts.vtt 1.6 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/2. Understanding the Time Value of Money.vtt 1.6 kB
  • 42. Tesla practical case study - Building a financial planning model/2. The input data we will work with.vtt 1.6 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/17. Using Custom-sort to Sort Multiple Columns Within a Table.vtt 1.6 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/15. Custom Number Formatting.vtt 1.6 kB
  • 42. Tesla practical case study - Building a financial planning model/17. Producing a clean P&L output sheet.vtt 1.6 kB
  • 32. Financial Statement Analysis - Subtleties/4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).vtt 1.6 kB
  • 17. Accounting - Cost recognition/3. The two types of Income Statement formats.vtt 1.5 kB
  • 28. Advanced Accounting - Leasing Liabilties/1. The reason companies lease assets.vtt 1.5 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/10. Find and Select Cells That Meet Specific Conditions.vtt 1.5 kB
  • 31. Financial Statement Analysis - An Introduction/4. Indispensable Tools for Financial Statement Analysis.vtt 1.5 kB
  • 2. Microsoft Excel - Quick Introduction/13. Pasting Values, Formulas and Formats with Paste Special.vtt 1.5 kB
  • 39. Finance 101 - Loan Calculations/3. COURSE CHALLENGE - Part 3.vtt 1.5 kB
  • 22. Accounting - The Importance of Timing/1. Timing of Cash Flows and Why It Plays an Important Role in a Business.vtt 1.5 kB
  • 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/9. GetPivotData fix.vtt 1.4 kB
  • 9. Microsoft Excel - Working with Pivot Tables in Excel/7. Introduction to the Course Challenge.vtt 1.4 kB
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/12. How to Create Dynamic Names in Excel Spreadsheets.vtt 1.4 kB
  • 34. Financial Statement Analysis - Tesla exercise/1. What you will see next in this section.vtt 1.4 kB
  • 3. Microsoft Excel - Useful Tools/4. Create Easily Printable Excel Documents.vtt 1.4 kB
  • 42. Tesla practical case study - Building a financial planning model/25. Calculating Net income.vtt 1.3 kB
  • 3. Microsoft Excel - Useful Tools/7. Using Excel's Freeze Panes to Handle Large Datasets.vtt 1.3 kB
  • 24. Advanced Accounting - Inventory/4. Cost flow methods - a practical exercise.vtt 1.3 kB
  • 3. Microsoft Excel - Useful Tools/6. Insert Hyperlinks into Excel Spreadsheets.vtt 1.3 kB
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/5. What Is Libor and What Purpose Does It Serve.vtt 1.3 kB
  • 8. Microsoft Excel - Building Professional Charts in Excel/1. Introduction to Excel Charts.vtt 1.2 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/11. Use Round in Your Financial Models.vtt 1.2 kB
  • 42. Tesla practical case study - Building a financial planning model/27. Balancing the Balance sheet.vtt 1.1 kB
  • 2. Microsoft Excel - Quick Introduction/1. Microsoft Excel The World's #1 Office Software.vtt 1.1 kB
  • 43. PowerPoint - Introduction to PowerPoint/1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.vtt 1.1 kB
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/9. Find the Highest and Lowest Values in a Range Max & Min.vtt 1.0 kB
  • 3. Microsoft Excel - Useful Tools/8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.vtt 953 Bytes
  • 3. Microsoft Excel - Useful Tools/1. Inserting a Line Break with Alt + Enter.vtt 935 Bytes
  • 1. Welcome! Course Introduction/4. Download all course materials.html 903 Bytes
  • 3. Microsoft Excel - Useful Tools/5. How to Wrap Text in Excel and Adjust a Cell's Size.vtt 835 Bytes
  • 37. Finance 101 - The Time Value of Money and Interest Rate Components/1. Finance 101 Important Financial Principles That You Will Need.vtt 790 Bytes
  • 36. Fundamentals of Business & Financial Analysis/1. Fundamentals of Business & Financial Analysis.html 147 Bytes
  • 14. Accounting - Introduction to Accounting & Bookkeeping/5. Quiz Number 3.html 143 Bytes
  • 15. Accounting - Types of revenues, costs, assets, and liabilities/13. Quiz Number 4.html 143 Bytes
  • 19. Accounting - The Core Principles of Accounting/7. Quiz Number 5.html 143 Bytes
  • 2. Microsoft Excel - Quick Introduction/12. Work Efficiently by Using Cut, Copy, and Paste.html 143 Bytes
  • 2. Microsoft Excel - Quick Introduction/5. Data Entry Techniques in Excel.html 143 Bytes
  • 2. Microsoft Excel - Quick Introduction/7. Inserting, Deleting, and Modifying Rows & Columns.html 143 Bytes
  • 2. Microsoft Excel - Quick Introduction/9. Excel Formulas for Beginners.html 143 Bytes
  • 22. Accounting - The Importance of Timing/5. Quiz Number 6.html 143 Bytes
  • 3. Microsoft Excel - Useful Tools/3. Do More with Your Sales Data with Excel's Text to Columns Feature.html 143 Bytes
  • 31. Financial Statement Analysis - An Introduction/5. Quiz Number 7.html 143 Bytes
  • 32. Financial Statement Analysis - Subtleties/6. Quiz Number 8.html 143 Bytes
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/11. Find and Select Cells That Meet Specific Conditions.html 143 Bytes
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/13. How to Create Dynamic Names in Excel Spreadsheets.html 143 Bytes
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/26. Quiz Number 1.html 143 Bytes
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/4. Macros Are a Great Timesaver! Here's Why..html 143 Bytes
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/7. The Secret to Faster Scrolling in Excel.html 143 Bytes
  • 4. Microsoft Excel - Best Practices That Will Make a Difference/9. Using Absolute and Relative Cell References.html 143 Bytes
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/14. Index, Match, and Their Combination - The Perfect Substitute for Vlookup.html 143 Bytes
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/19. Goal Seek Will Help You Find the Result You Are Looking For.html 143 Bytes
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/21. Perform Sensitivity Analysis with Excel's Data Tables Functionality.html 143 Bytes
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/22. Quiz Number 2.html 143 Bytes
  • 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/7. Key Excel Functions Left, Right, Mid, Upper, Lower, Proper, Concatenate, &.html 143 Bytes
  • 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/17. Quiz Number 3.html 143 Bytes
  • [FreeCourseLab.com].url 126 Bytes
  • 44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/8.1 Sending Files with Dropbox - YouTube Tutorial.html 104 Bytes

随机展示

相关说明

本站不存储任何资源内容，只收集BT种子元数据(例如文件名和文件大小)和磁力链接(BT种子标识符)，并提供查询服务，是一个完全合法的搜索引擎系统。 网站不提供种子下载服务，用户可以通过第三方链接或磁力链接获取到相关的种子资源。本站也不对BT种子真实性及合法性负责，请用户注意甄别！
>