57. Who Does What in the World of Finance/1. Who Does What in the World of Finance.mp4 680.9 MB
37. Financial Statement Analysis - Tesla Exercise/3. Calculating and Analyzing Growth and Profitability Ratios.mp4 111.7 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/2. Forecasting Tesla's Expected Deliveries.mp4 108.4 MB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.mp4 104.4 MB
48. Data Analysis with ChatGPT - Exploratory Data Analysis (EDA)/5. Crafting a Comprehensive EDA Prompt.mp4 97.6 MB
38. Working Capital Management/2. The Importance of Working Capital Optimization Case Study.mp4 84.6 MB
54. Data Analysis with ChatGPT - Complete Practical Example/4. Working on the 'Transactions' Sheet.mp4 82.6 MB
34. Financial Statement Analysis - An Introduction/2. Finding, Downloading and Going Through the Annual Report of P&G.mp4 81.3 MB
37. Financial Statement Analysis - Tesla Exercise/4. Calculating and Analyzing Liquidity Ratios.mp4 75.1 MB
22. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/1. Case Study - The Accounting Transactions of a Lemonade Stand (14).mp4 74.2 MB
40. Business Analysis in Excel/2. Trend analysis.mp4 73.7 MB
38. Working Capital Management/4. Trade Receivables Management.mp4 72.1 MB
32. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/2. Raising Equity in Different Stages of a Company's Lifecycle.mp4 71.3 MB
1. Welcome! Course Introduction/1. What Does the Course Cover.mp4 70.6 MB
40. Business Analysis in Excel/10. Time series analysis.mp4 70.6 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/21. Completing Unlevered Free Cash Flow.mp4 70.1 MB
54. Data Analysis with ChatGPT - Complete Practical Example/2. Preprocessing the 'Free plan users' Sheet (12).mp4 67.9 MB
35. Financial Statement Analysis - Subtleties/5. Using Accounting Ratios to Assess Business Performance.mp4 65.3 MB
48. Data Analysis with ChatGPT - Exploratory Data Analysis (EDA)/1. Exploratory Data Analysis - Intro.mp4 59.9 MB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/7. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.mp4 59.7 MB
36. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).mp4 58.3 MB
16. Accounting - Introduction to Accounting & Bookkeeping/1. Accounting The Science Behind Financial Figures.mp4 56.6 MB
31. Advanced Accounting - Using Leverage/1. What is Leverage and Why Companies Use Financial Leverage.mp4 56.1 MB
32. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/1. The Different Types of Equity.mp4 56.0 MB
9. Microsoft Excel - Building Professional Charts in Excel/4. Making Your Excel Charts Sexier - Proven Tips.mp4 55.9 MB
56. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/10. Practical Exercise - Creating an Organisational Chart.mp4 55.4 MB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/14. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.mp4 55.1 MB
24. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/5. Calculating Cash Flow in Practice A Complete Example.mp4 55.1 MB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/3. Types of Revenues.mp4 54.7 MB
4. Microsoft Excel - Best Practices That Will Make a Difference/28. Conditional Formatting.mp4 54.5 MB
22. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/4. Case Study - The Accounting Transactions of a Lemonade Stand (44).mp4 54.5 MB
44. Capital Budgeting - Basic Notions/5. Cost of Equity.mp4 54.0 MB
15. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model/5. Calculating Cash Flows and Completing the Model.mp4 53.5 MB
50. Data Analysis with ChatGPT - Organize Messy Data/1. Organize Messy Data.mp4 53.1 MB
18. Accounting - Revenue Recognition/4. A Practical Example.mp4 52.7 MB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/8. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.mp4 52.4 MB
47. Data Analysis with ChatGPT - Intro/2. The Limitations of ChatGPT Advanced Data Analysis.mp4 50.3 MB
41. 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 50.1 MB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/10. Using INDEX & MATCH as a Substitute for VLOOKUP.mp4 49.4 MB
22. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/3. Case Study - The Accounting Transactions of a Lemonade Stand (34).mp4 49.2 MB
42. Finance 101 - The Value of Cash Flows with Different Timing/1. Calculating the Present Value of Future Cash Flows.mp4 49.1 MB
10. Microsoft Excel - Creating Complete Professional Charts from Scratch/5. Bridge Chart.mp4 48.8 MB
49. Data Analysis with ChatGPT - Deal with Inconsistent Data/5. Dividing Cell Content into Multiple Cells.mp4 48.5 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/4. Estimating an Average Selling Price of Tesla Vehicles.mp4 48.2 MB
42. 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 48.1 MB
16. Accounting - Introduction to Accounting & Bookkeeping/2. What is Accounting and Why Do You Need It.mp4 48.0 MB
38. Working Capital Management/7. Inventory Optimization Techniques.mp4 47.3 MB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/8. Using SUMIF to Complete the Database Sheet.mp4 46.9 MB
23. Accounting - The Importance of Timing/2. Timing of Income Principles of Revenue Recognition.mp4 46.8 MB
45. Capital Budgeting - A Complete Case Study/4. Preparing a Fixed Asset Rollforward Schedule.mp4 46.7 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/19. Forecasting Other Assets.mp4 46.6 MB
22. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/2. Case Study - The Accounting Transactions of a Lemonade Stand (24).mp4 46.1 MB
14. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios/1. Calculating Historical Percentage Ratios and Use OFFSET and MATCH for Scenarios.mp4 46.1 MB
4. Microsoft Excel - Best Practices That Will Make a Difference/9. Using Absolute and Relative Cell References.mp4 45.6 MB
38. Working Capital Management/9. Working Capital Optimization - a Roadmap.mp4 45.6 MB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/5. Types of Expenses.mp4 45.4 MB
9. Microsoft Excel - Building Professional Charts in Excel/7. How to Represent Trends with Sparklines.mp4 45.0 MB
40. Business Analysis in Excel/12. Regression analysis.mp4 44.9 MB
32. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/5. What Are Share Repurchases and Why Companies Do Them.mp4 44.5 MB
32. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/3. The Types of Dividends Companies Pay to Shareholders.mp4 44.4 MB
9. Microsoft Excel - Building Professional Charts in Excel/3. Modifying Excel Charts - The Easy Way.mp4 44.2 MB
45. Capital Budgeting - A Complete Case Study/12. Performing Sensitivity Analysis and Wrapping Up the Case Study.mp4 44.0 MB
4. Microsoft Excel - Best Practices That Will Make a Difference/20. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4 43.9 MB
15. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model/2. Building a Financial Liabilities Schedule.mp4 43.9 MB
56. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/11. COURSE CHALLENGE - Part 4.mp4 43.8 MB
1. Welcome! Course Introduction/2. Everything We Will Learn Has a Practical Application.mp4 43.8 MB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/23. Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp4 43.8 MB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/1. Introduction to the Case Study.mp4 43.3 MB
10. Microsoft Excel - Creating Complete Professional Charts from Scratch/2. Stacked Column Chart with a Secondary Axis.mp4 43.3 MB
6. Microsoft Excel - Financial Functions in Excel/1. Discounting Cash Flows in Microsoft Excel.mp4 41.5 MB
14. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios/4. Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.mp4 41.3 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/13. Building a Fixed Asset Roll Forward Estimating Capex.mp4 41.2 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/22. Modeling Tesla's Financing Needs in the Forecast Period.mp4 40.7 MB
13. Modeling in Excel - Building a Complete 3-statement Model/7. Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet.mp4 39.5 MB
40. Business Analysis in Excel/6. Value-based analysis.mp4 39.4 MB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/7. Depreciation & Amortization.mp4 39.3 MB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/2. Working with an SAP Data Extraction.mp4 38.8 MB
49. Data Analysis with ChatGPT - Deal with Inconsistent Data/2. Verifying Data for Errors.mp4 38.6 MB
15. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model/1. Building a Fixed Asset Roll Forward.mp4 38.1 MB
2. Microsoft Excel - Quick Introduction/1. Microsoft Excel The World's #1 Office Software.mp4 38.1 MB
40. Business Analysis in Excel/8. Correlation analysis.mp4 38.1 MB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/13. Mapping the Rows in the Database Sheet.mp4 38.0 MB
9. Microsoft Excel - Building Professional Charts in Excel/2. Beginner's Guide to Inserting Charts in Excel.mp4 38.0 MB
11. Microsoft Excel - Working with Pivot Tables in Excel/6. Welcome to the Future - Pivot Table Slicers.mp4 38.0 MB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/13. This is How the Report Can be Used in Practice by High-level Executives.mp4 37.9 MB
45. Capital Budgeting - A Complete Case Study/10. Estimating Cost of Equity.mp4 37.8 MB
2. Microsoft Excel - Quick Introduction/4. How to Make Your Spreadsheets Look Professional.mp4 37.6 MB
52. Data Analysis with ChatGPT - Clean Text Data/4. Handling Multi-lingual Text Data.mp4 37.6 MB
11. Microsoft Excel - Working with Pivot Tables in Excel/4. Additional Techniques That Will Ease Your Work with Pivot Tables.mp4 37.6 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/6. Peer Comparison Gross Profit %.mp4 37.5 MB
54. Data Analysis with ChatGPT - Complete Practical Example/3. Preprocessing the 'Free plan users' Sheet (22).mp4 37.4 MB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/9. Balance Sheet Items.mp4 37.1 MB
6. Microsoft Excel - Financial Functions in Excel/3. Using the PMT Function to Create a Complete Loan Schedule.mp4 37.0 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/1. Organizing External Inputs in a 'Drivers' Sheet.mp4 36.8 MB
10. Microsoft Excel - Creating Complete Professional Charts from Scratch/3. Doughnut Chart.mp4 36.2 MB
32. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/6. The Idea Behind Stock Splits.mp4 35.9 MB
27. Advanced Accounting - Fixed Assets/6. The Revaluation Model - Practical Exercise.mp4 35.7 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/14. Building a Fixed Asset Roll Forward D&A Schedule.mp4 35.7 MB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/11. Combining Slicers and GETPIVOTDATA The Key to Our Success.mp4 35.2 MB
4. Microsoft Excel - Best Practices That Will Make a Difference/2. Macros Are a Great Timesaver! Here's Why..mp4 35.2 MB
32. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/4. Dividend Payments - a Timeline.mp4 35.1 MB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/11. XLOOKUP as a Substitute for VLOOKUP and INDEX&MATCH.mp4 35.0 MB
49. Data Analysis with ChatGPT - Deal with Inconsistent Data/1. Identifying and Handling Erroneous Data.mp4 34.9 MB
15. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model/3. Building an Equity Schedule.mp4 34.5 MB
13. Modeling in Excel - Building a Complete 3-statement Model/1. Introduction to the Exercise.mp4 34.4 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/12. Building a Fixed Asset Roll Forward PP&E.mp4 34.3 MB
14. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios/3. Building a Flexible Model with VLOOKUP & COLUMNS.mp4 34.2 MB
36. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).mp4 34.0 MB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/12. Getting Fancy with Excel Slicers.mp4 34.0 MB
40. Business Analysis in Excel/4. Comparative analysis.mp4 33.9 MB
27. Advanced Accounting - Fixed Assets/4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.mp4 33.8 MB
31. Advanced Accounting - Using Leverage/2. The Implications of Using Excessive Leverage.mp4 33.7 MB
45. Capital Budgeting - A Complete Case Study/3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.mp4 33.6 MB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/20. Create Flexible Financial Models with CHOOSE.mp4 33.6 MB
45. Capital Budgeting - A Complete Case Study/2. Organizing Inputs In the Drivers Sheet.mp4 33.5 MB
55. PowerPoint - Introduction to PowerPoint/4. Learn How to Insert Objects in PowerPoint.mp4 33.5 MB
44. Capital Budgeting - Basic Notions/4. Calculating Present and Future Value.mp4 33.1 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/18. Forecasting Unlevered Free Cash Flow.mp4 32.7 MB
1. Welcome! Course Introduction/3. The Best Way to Take This Course.mp4 32.6 MB
2. Microsoft Excel - Quick Introduction/11. Format Cells.mp4 32.5 MB
36. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/3. COURSE CHALLENGE - Part 2.mp4 32.1 MB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/10. Asset Categories - Practical Example.mp4 32.0 MB
55. PowerPoint - Introduction to PowerPoint/1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp4 31.9 MB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/3. Preliminary Mapping of the Data Extraction.mp4 31.7 MB
38. Working Capital Management/3. Overtrading vs. Excessive Investment.mp4 31.6 MB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/11. Liability Categories - Practical Example.mp4 31.2 MB
21. Accounting - The Core Principles of Accounting/3. T-Accounts The Best Way to Understand Debits and Credits.mp4 30.9 MB
11. Microsoft Excel - Working with Pivot Tables in Excel/2. Creating a Pivot Table Choosing Row and Column Parameters.mp4 30.8 MB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/16. Populating the P&L Sheet with SUMIF.mp4 30.6 MB
16. Accounting - Introduction to Accounting & Bookkeeping/3. The Importance of Bookkeeping - Good Accounting Records Are Essential.mp4 30.6 MB
45. Capital Budgeting - A Complete Case Study/8. The Project's Cash Flow Calculation.mp4 30.5 MB
47. Data Analysis with ChatGPT - Intro/1. How ChatGPT Advanced Data Analysis Will Boost Your Productivity.mp4 29.9 MB
38. Working Capital Management/5. Re-order Level.mp4 29.8 MB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/18. Calculating Growth Rates in Excel.mp4 29.7 MB
38. Working Capital Management/6. Economic Order Quantity (EOQ).mp4 29.5 MB
13. Modeling in Excel - Building a Complete 3-statement Model/8. Adding the Forecast Period.mp4 29.3 MB
55. PowerPoint - Introduction to PowerPoint/2. The Structure of the PowerPoint Ribbon.mp4 29.0 MB
41. Finance 101 - The Time Value of Money and Interest Rate Components/5. What Is Libor and What Purpose Does It Serve.mp4 29.0 MB
55. PowerPoint - Introduction to PowerPoint/14. Learn How to Create, Edit, Resize and Format PowerPoint Tables.mp4 29.0 MB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/17. Learn How to Find Mistakes with COUNTIF.mp4 28.9 MB
53. Data Analysis with ChatGPT - Dates and Time Data/1. Obtain Day and Month From Date.mp4 28.9 MB
13. Modeling in Excel - Building a Complete 3-statement Model/2. Let's Create a Mapping of Financials.mp4 28.5 MB
14. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios/5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.mp4 28.3 MB
13. Modeling in Excel - Building a Complete 3-statement Model/3. Building an Output P&L Sheet.mp4 28.1 MB
2. Microsoft Excel - Quick Introduction/3. Data Entry Techniques in Excel.mp4 28.1 MB
41. Finance 101 - The Time Value of Money and Interest Rate Components/1. Finance 101 Important Financial Principles That You Will Need.mp4 27.9 MB
41. Finance 101 - The Time Value of Money and Interest Rate Components/6. The Difference Between Fixed and Variable Interest Rates.mp4 27.7 MB
55. PowerPoint - Introduction to PowerPoint/3. General Considerations About Slide Structure.mp4 27.6 MB
34. Financial Statement Analysis - An Introduction/3. What Is the Role of Auditing Firms and What Are the Benefits of an Audit.mp4 27.6 MB
55. PowerPoint - Introduction to PowerPoint/8. How to Edit Shapes in Your Presentation.mp4 27.6 MB
51. Data Analysis with ChatGPT - Working with Functions/2. Data Lookup.mp4 27.6 MB
13. Modeling in Excel - Building a Complete 3-statement Model/6. Building an Output Balance Sheet.mp4 27.5 MB
41. Finance 101 - The Time Value of Money and Interest Rate Components/4. The Components Forming Interest Rates in Real Life.mp4 27.3 MB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/6. Key Excel Functions AVERAGE & AVERAGEIF.mp4 25.3 MB
45. Capital Budgeting - A Complete Case Study/11. Discounting Project Cash Flows.mp4 25.2 MB
52. Data Analysis with ChatGPT - Clean Text Data/5. Multiple Find and Replace at the Same Time with ChatGPT.mp4 25.1 MB
26. Advanced Accounting - Inventory/1. The Different Types of Inventory We Can Have.mp4 25.1 MB
13. Modeling in Excel - Building a Complete 3-statement Model/5. Calculating Percentage Variances and Applying Conditional Formatting.mp4 25.1 MB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/5. Improving the Layout and Appearance of the FMCG Report.mp4 25.0 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/10. Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.mp4 25.0 MB
56. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/3. Join Shapes Together By Using Connector Lines.mp4 25.0 MB
24. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.mp4 25.0 MB
24. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/2. The Three Parts of Cash Flow Statements Explained.mp4 24.5 MB
25. Advanced Accounting - Trade Receivables/1. Why a Company Needs to Pay Attention to Trade Receivables.mp4 24.4 MB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/15. A Practical Example of Professional Formatting in Excel.mp4 24.3 MB
50. Data Analysis with ChatGPT - Organize Messy Data/2. Data Mapping.mp4 24.2 MB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/1. The Different Types of Accounting Standards.mp4 24.1 MB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/5. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.mp4 24.0 MB
20. Accounting - Understanding the Big Picture Why, What, When, and How Much/2. The Expense Recognition Principle - When to Recognize Expenses.mp4 23.7 MB
51. Data Analysis with ChatGPT - Working with Functions/4. Fill Until Non-blank Values.mp4 23.7 MB
11. Microsoft Excel - Working with Pivot Tables in Excel/1. Pivot Tables - Excel's Dynamic and Interactive Tables.mp4 23.7 MB
55. PowerPoint - Introduction to PowerPoint/12. Using Slide Masters.mp4 23.5 MB
45. Capital Budgeting - A Complete Case Study/1. An Introduction to the Case Study.mp4 23.4 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/7. Calculating Automotive Gross Profit.mp4 23.4 MB
16. Accounting - Introduction to Accounting & Bookkeeping/4. An Introduction to Financial Accounting.mp4 23.3 MB
38. Working Capital Management/1. Introduction.mp4 23.3 MB
43. Finance 101 - Loan Calculations/1. Using Annuities.mp4 23.3 MB
4. Microsoft Excel - Best Practices That Will Make a Difference/19. Using Custom-sort to Sort Multiple Columns Within a Table.mp4 23.0 MB
4. Microsoft Excel - Best Practices That Will Make a Difference/22. Find and Replace - References.mp4 23.0 MB
44. Capital Budgeting - Basic Notions/8. The Different Cash Flow Types in a Capital Budgeting Exercise.mp4 22.9 MB
34. Financial Statement Analysis - An Introduction/1. What is a 10-K Report and Why Is It important for Investors.mp4 22.9 MB
21. Accounting - The Core Principles of Accounting/4. P&L T-Accounts.mp4 22.8 MB
41. Finance 101 - The Time Value of Money and Interest Rate Components/3. How Interest Rates Play an Important Role in the Economy.mp4 22.6 MB
9. Microsoft Excel - Building Professional Charts in Excel/5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp4 22.5 MB
55. PowerPoint - Introduction to PowerPoint/6. Add Frequently Used Buttons to the Quick Access Toolbar.mp4 22.4 MB
4. Microsoft Excel - Best Practices That Will Make a Difference/1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4 22.3 MB
56. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.mp4 22.0 MB
13. Modeling in Excel - Building a Complete 3-statement Model/4. Filling in the Output P&L Sheet with Historical Financials.mp4 21.6 MB
55. PowerPoint - Introduction to PowerPoint/7. How to Easily Align Objects in PowerPoint.mp4 21.5 MB
20. Accounting - Understanding the Big Picture Why, What, When, and How Much/3. Historical Cost vs. Fair Value Accounting.mp4 21.4 MB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/12. The Mapping Exercise.mp4 21.3 MB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.mp4 21.1 MB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/19. A Useful Tool for Financial Analysis - The RANK Function.mp4 21.1 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/20. Forecasting Other Liabilities.mp4 21.1 MB
45. Capital Budgeting - A Complete Case Study/6. Debt Repayment and Interest Expenses Calculation.mp4 20.9 MB
9. Microsoft Excel - Building Professional Charts in Excel/1. Introduction to Excel Charts.mp4 20.9 MB
55. PowerPoint - Introduction to PowerPoint/9. How to Format Text Boxes in a PowerPoint Presentation.mp4 20.9 MB
28. Advanced Accounting - Trade Payables/1. How We Account for Trade Payables.mp4 20.9 MB
6. Microsoft Excel - Financial Functions in Excel/2. Calculating Internal Rate of Return (IRR) in Excel.mp4 20.8 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/3. Comparing Delivery Figures with the Ones of industry Peers.mp4 20.7 MB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/4. Creating an Output Structure of the FMCG Model.mp4 20.7 MB
4. Microsoft Excel - Best Practices That Will Make a Difference/5. The Secret to Faster Scrolling in Excel.mp4 20.5 MB
48. Data Analysis with ChatGPT - Exploratory Data Analysis (EDA)/2. Extracting Descriptive Statistics with ChatGPT.mp4 20.3 MB
48. Data Analysis with ChatGPT - Exploratory Data Analysis (EDA)/4. Correlation Analysis Hypothesis Formulation and Feature Ideas.mp4 20.2 MB
44. Capital Budgeting - Basic Notions/2. When Do We Use Capital Budgeting.mp4 20.1 MB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18. Using Excel's IFERROR Function to Trap Spreadsheet Errors.mp4 20.1 MB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/2. The Three Financial Statements.mp4 20.1 MB
4. Microsoft Excel - Best Practices That Will Make a Difference/6. Be even quicker F5 + Enter.mp4 20.1 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/9. Forecasting 'Energy' and 'Services' Revenue.mp4 20.0 MB
49. Data Analysis with ChatGPT - Deal with Inconsistent Data/4. Addressing Unit Discrepancies in Data.mp4 19.9 MB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/6. Learn How to Create a Database.mp4 19.7 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/17. Calculating Investments in Working Capital.mp4 19.6 MB
24. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/3. Cash Flow Computations - The Direct Method.mp4 19.4 MB
27. Advanced Accounting - Fixed Assets/1. The Different Types of Fixed Assets.mp4 19.4 MB
9. Microsoft Excel - Building Professional Charts in Excel/6. New Ways to Visualize Your Data - Treemap Charts.mp4 19.2 MB
2. Microsoft Excel - Quick Introduction/10. A Beginner's Introduction to Excel Functions.mp4 19.2 MB
56. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/5. Group or Ungroup Shapes, Pictures or Other Objects.mp4 15.4 MB
52. Data Analysis with ChatGPT - Clean Text Data/7. Removing Duplicates Across Multiple Columns.mp4 15.3 MB
56. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/1. An Introduction to PowerPoint Animations.mp4 15.3 MB
21. Accounting - The Core Principles of Accounting/2. Elements of the Accounting System General Ledger.mp4 15.2 MB
3. Microsoft Excel - Useful Tools/7. Using Excel's Freeze Panes to Handle Large Datasets.mp4 15.2 MB
26. Advanced Accounting - Inventory/2. The Connection Between Cost of Goods Sold and Inventory.mp4 15.2 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/16. Producing a Clean P&L Output Sheet.mp4 15.2 MB
52. Data Analysis with ChatGPT - Clean Text Data/6. Criteria-based Duplicate Removal.mp4 15.1 MB
34. Financial Statement Analysis - An Introduction/4. Indispensable Tools for Financial Statement Analysis.mp4 15.0 MB
50. Data Analysis with ChatGPT - Organize Messy Data/3. Effective Data Classification.mp4 14.9 MB
4. Microsoft Excel - Best Practices That Will Make a Difference/13. How to Create Dynamic Names in Excel Spreadsheets.mp4 14.7 MB
44. Capital Budgeting - Basic Notions/7. The Weighted Average Cost of Capital (WACC).mp4 14.7 MB
4. Microsoft Excel - Best Practices That Will Make a Difference/18. How to Add a Drop-down List in Excel.mp4 14.7 MB
14. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios/2. Building a Flexible Model with CHOOSE & MATCH.mp4 14.6 MB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/10.2 66. Index Match-Lecture-after.xlsm 14.5 MB
46. Tesla Practical Case Study - Building a Financial Planning Model/23. Calculating Net Income.mp4 14.5 MB
38. Working Capital Management/11. Symptoms of Inefficient Working Capital - Trade Receivables.mp4 14.5 MB
25. Advanced Accounting - Trade Receivables/4. A Technique to Collect Trade Receivables Sooner.mp4 14.5 MB
56. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/6. This is How You Can Fit Text When It Is Larger Than a Shape.mp4 14.5 MB
4. Microsoft Excel - Best Practices That Will Make a Difference/21. Multiply by 1.mp4 14.4 MB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/10. Working with Text in Excel.mp4 14.0 MB
22. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/1. Case Study - The Accounting Transactions of a Lemonade Stand (14).srt 15.1 kB
45. Capital Budgeting - A Complete Case Study/3.1 2. Savings Forecast_unsolved.xlsx 15.1 kB
36. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/2.2 P-G-Financials-Before.xlsx 15.0 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/17.1 31. Assigning Custom Formats - Exercise - Solved.xlsx 11.3 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/15.2 25. Defining-a-Named-Range-Exercise - Unsolved.xlsx 11.3 kB
34. Financial Statement Analysis - An Introduction/2. Finding, Downloading and Going Through the Annual Report of P&G.srt 11.3 kB
36. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/1. Case Study - Calculating Ratios and Analyzing P&G's Financials (12).srt 11.3 kB
22. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/2. Case Study - The Accounting Transactions of a Lemonade Stand (24).srt 11.2 kB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/3. Types of Revenues.srt 11.2 kB
22. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/3. Case Study - The Accounting Transactions of a Lemonade Stand (34).srt 10.4 kB
32. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/2. Raising Equity in Different Stages of a Company's Lifecycle.srt 10.1 kB
42. Finance 101 - The Value of Cash Flows with Different Timing/1.2 3.1 Present Value of Cash Flows.xlsx 10.1 kB
22. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/4. Case Study - The Accounting Transactions of a Lemonade Stand (44).srt 10.0 kB
23. Accounting - The Importance of Timing/2. Timing of Income Principles of Revenue Recognition.srt 9.1 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/3.1 19. Another-file.xlsx 9.0 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/15.4 25. Naming-ranges-Lecture - Unsolved.xlsx 9.0 kB
37. Financial Statement Analysis - Tesla Exercise/4. Calculating and Analyzing Liquidity Ratios.srt 9.0 kB
18. Accounting - Revenue Recognition/4. A Practical Example.srt 8.9 kB
16. Accounting - Introduction to Accounting & Bookkeeping/2. What is Accounting and Why Do You Need It.srt 8.9 kB
38. Working Capital Management/9. Working Capital Optimization - a Roadmap.srt 8.8 kB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/15. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.srt 8.8 kB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/13. Mapping the Rows in the Database Sheet.srt 8.5 kB
51. Data Analysis with ChatGPT - Working with Functions/3.1 5.3_output.xlsx 8.5 kB
44. Capital Budgeting - Basic Notions/4. Calculating Present and Future Value.srt 8.4 kB
49. Data Analysis with ChatGPT - Deal with Inconsistent Data/3.1 3.3_output.xlsx 8.3 kB
38. Working Capital Management/7. Inventory Optimization Techniques.srt 8.3 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/21. Completing Unlevered Free Cash Flow.srt 8.3 kB
45. Capital Budgeting - A Complete Case Study/2. Organizing Inputs In the Drivers Sheet.srt 8.3 kB
2. Microsoft Excel - Quick Introduction/6.3 4. Data Entry - Lecture.xlsx 8.3 kB
2. Microsoft Excel - Quick Introduction/11. Format Cells.srt 8.2 kB
21. Accounting - The Core Principles of Accounting/5. The Double-Entry Principle - The Core Principle of Bookkeeping.srt 8.1 kB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/13. Equity Categories - Practical Example.srt 8.0 kB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/8. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.srt 7.9 kB
15. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model/5. Calculating Cash Flows and Completing the Model.srt 7.7 kB
55. PowerPoint - Introduction to PowerPoint/14. Learn How to Create, Edit, Resize and Format PowerPoint Tables.srt 7.6 kB
36. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/2. Case Study - Calculating Ratios and Analyzing P&G's Financials (22).srt 7.5 kB
45. Capital Budgeting - A Complete Case Study/12. Performing Sensitivity Analysis and Wrapping Up the Case Study.srt 7.5 kB
21. Accounting - The Core Principles of Accounting/3. T-Accounts The Best Way to Understand Debits and Credits.srt 7.5 kB
55. PowerPoint - Introduction to PowerPoint/2. The Structure of the PowerPoint Ribbon.srt 7.5 kB
10. Microsoft Excel - Creating Complete Professional Charts from Scratch/2. Stacked Column Chart with a Secondary Axis.srt 7.4 kB
6. Microsoft Excel - Financial Functions in Excel/4. Date Functions in Excel.srt 7.4 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/28. Conditional Formatting.srt 7.4 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/6. Peer Comparison Gross Profit %.srt 7.4 kB
31. Advanced Accounting - Using Leverage/1. What is Leverage and Why Companies Use Financial Leverage.srt 7.4 kB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/7. Depreciation & Amortization.srt 7.4 kB
6. Microsoft Excel - Financial Functions in Excel/1. Discounting Cash Flows in Microsoft Excel.srt 7.4 kB
2. Microsoft Excel - Quick Introduction/4. How to Make Your Spreadsheets Look Professional.srt 7.3 kB
55. PowerPoint - Introduction to PowerPoint/8. How to Edit Shapes in Your Presentation.srt 7.3 kB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/7. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.srt 7.2 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/4. Estimating an Average Selling Price of Tesla Vehicles.srt 7.2 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/19. Forecasting Other Assets.srt 7.1 kB
54. Data Analysis with ChatGPT - Complete Practical Example/4. Working on the 'Transactions' Sheet.srt 7.1 kB
10. Microsoft Excel - Creating Complete Professional Charts from Scratch/3. Doughnut Chart.srt 7.0 kB
40. Business Analysis in Excel/6. Value-based analysis.srt 7.0 kB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/9. Balance Sheet Items.srt 7.0 kB
6. Microsoft Excel - Financial Functions in Excel/3. Using the PMT Function to Create a Complete Loan Schedule.srt 7.0 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/22. Modeling Tesla's Financing Needs in the Forecast Period.srt 6.9 kB
45. Capital Budgeting - A Complete Case Study/4. Preparing a Fixed Asset Rollforward Schedule.srt 6.9 kB
27. Advanced Accounting - Fixed Assets/4. Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life.srt 6.7 kB
27. Advanced Accounting - Fixed Assets/6. The Revaluation Model - Practical Exercise.srt 6.7 kB
50. Data Analysis with ChatGPT - Organize Messy Data/3.1 4.3_output.xlsx 6.7 kB
40. Business Analysis in Excel/12. Regression analysis.srt 6.6 kB
54. Data Analysis with ChatGPT - Complete Practical Example/1. Intro to the Exercise and Preprocessing Ideas from ChatGPT.srt 6.5 kB
56. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/3. Join Shapes Together By Using Connector Lines.srt 6.5 kB
38. Working Capital Management/6. Economic Order Quantity (EOQ).srt 6.5 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/5. Calculating Automotive Revenue.srt 6.5 kB
55. PowerPoint - Introduction to PowerPoint/12. Using Slide Masters.srt 6.4 kB
55. PowerPoint - Introduction to PowerPoint/7. How to Easily Align Objects in PowerPoint.srt 6.4 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/11. Forecasting Operating Expenses.srt 6.4 kB
32. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/1. The Different Types of Equity.srt 6.4 kB
40. Business Analysis in Excel/4. Comparative analysis.srt 6.4 kB
15. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model/2. Building a Financial Liabilities Schedule.srt 6.3 kB
42. Finance 101 - The Value of Cash Flows with Different Timing/1. Calculating the Present Value of Future Cash Flows.srt 6.3 kB
51. Data Analysis with ChatGPT - Working with Functions/4.1 5.4_output.xlsx 6.2 kB
14. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios/1. Calculating Historical Percentage Ratios and Use OFFSET and MATCH for Scenarios.srt 5.9 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/1. Organizing External Inputs in a 'Drivers' Sheet.srt 5.9 kB
14. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios/4. Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.srt 5.8 kB
25. Advanced Accounting - Trade Receivables/2. What If Clients Do Not Pay on Time.srt 5.6 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/13. Building a Fixed Asset Roll Forward Estimating Capex.srt 5.6 kB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/10. Using INDEX & MATCH as a Substitute for VLOOKUP.srt 5.6 kB
56. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/8. PowerPoint's Smart Art Feature Offers Great Return for Your Time.srt 5.5 kB
48. Data Analysis with ChatGPT - Exploratory Data Analysis (EDA)/1. Exploratory Data Analysis - Intro.srt 5.5 kB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/11. Liability Categories - Practical Example.srt 5.5 kB
45. Capital Budgeting - A Complete Case Study/3. Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam.srt 5.5 kB
1. Welcome! Course Introduction/4. Download All Course Materials and FAQ.html 5.3 kB
27. Advanced Accounting - Fixed Assets/1. The Different Types of Fixed Assets.srt 5.3 kB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/13. This is How the Report Can be Used in Practice by High-level Executives.srt 5.2 kB
42. 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.srt 5.2 kB
44. Capital Budgeting - Basic Notions/8. The Different Cash Flow Types in a Capital Budgeting Exercise.srt 5.2 kB
56. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/1. An Introduction to PowerPoint Animations.srt 5.2 kB
45. Capital Budgeting - A Complete Case Study/11. Discounting Project Cash Flows.srt 5.2 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/20. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.srt 5.2 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/24. Bridging Unlevered Free Cash Flow to Net Cash Flow.srt 5.1 kB
11. Microsoft Excel - Working with Pivot Tables in Excel/5. One of the Most Useful Excel Functions - GETPIVOTDATA.srt 5.1 kB
32. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments/5. What Are Share Repurchases and Why Companies Do Them.srt 5.1 kB
45. Capital Budgeting - A Complete Case Study/8. The Project's Cash Flow Calculation.srt 5.1 kB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/1. The Different Types of Accounting Standards.srt 4.6 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/22. Find and Replace - References.srt 4.6 kB
25. Advanced Accounting - Trade Receivables/1. Why a Company Needs to Pay Attention to Trade Receivables.srt 4.6 kB
9. Microsoft Excel - Building Professional Charts in Excel/7. How to Represent Trends with Sparklines.srt 4.6 kB
55. PowerPoint - Introduction to PowerPoint/13. Bring to Front and Send to Back - An Important PowerPoint Technique.srt 4.6 kB
35. Financial Statement Analysis - Subtleties/2. First Steps in Financial Statement Analysis.srt 4.6 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/14. Building a Fixed Asset Roll Forward D&A Schedule.srt 4.6 kB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/2. Working with an SAP Data Extraction.srt 4.6 kB
49. Data Analysis with ChatGPT - Deal with Inconsistent Data/1. Identifying and Handling Erroneous Data.srt 4.6 kB
45. Capital Budgeting - A Complete Case Study/6. Debt Repayment and Interest Expenses Calculation.srt 4.6 kB
1. Welcome! Course Introduction/3. The Best Way to Take This Course.srt 4.5 kB
13. Modeling in Excel - Building a Complete 3-statement Model/1. Introduction to the Exercise.srt 4.5 kB
26. Advanced Accounting - Inventory/1. The Different Types of Inventory We Can Have.srt 4.5 kB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/15. A Practical Example of Professional Formatting in Excel.srt 4.5 kB
52. Data Analysis with ChatGPT - Clean Text Data/4. Handling Multi-lingual Text Data.srt 4.5 kB
2. Microsoft Excel - Quick Introduction/10. A Beginner's Introduction to Excel Functions.srt 4.5 kB
21. Accounting - The Core Principles of Accounting/4. P&L T-Accounts.srt 4.5 kB
24. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/1. Calculating Cash Flows - Understand If a Business Makes or Burns Cash.srt 4.5 kB
28. Advanced Accounting - Trade Payables/1. How We Account for Trade Payables.srt 4.4 kB
13. Modeling in Excel - Building a Complete 3-statement Model/3. Building an Output P&L Sheet.srt 4.4 kB
38. Working Capital Management/1. Introduction.srt 4.4 kB
20. Accounting - Understanding the Big Picture Why, What, When, and How Much/2. The Expense Recognition Principle - When to Recognize Expenses.srt 4.2 kB
13. Modeling in Excel - Building a Complete 3-statement Model/8. Adding the Forecast Period.srt 4.2 kB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/3. Understand Your Data Source Before You Start Working on It.srt 4.2 kB
1. Welcome! Course Introduction/2. Everything We Will Learn Has a Practical Application.srt 4.2 kB
20. Accounting - Understanding the Big Picture Why, What, When, and How Much/3. Historical Cost vs. Fair Value Accounting.srt 4.1 kB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/11. Combining Slicers and GETPIVOTDATA The Key to Our Success.srt 4.1 kB
2. Microsoft Excel - Quick Introduction/3. Data Entry Techniques in Excel.srt 4.1 kB
13. Modeling in Excel - Building a Complete 3-statement Model/6. Building an Output Balance Sheet.srt 4.1 kB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/12. Getting Fancy with Excel Slicers.srt 4.1 kB
45. Capital Budgeting - A Complete Case Study/9. Calculating WACC (Weighted Average Cost of Capital).srt 4.1 kB
37. Financial Statement Analysis - Tesla Exercise/2. How to Download Tesla's Historical Financials.srt 4.1 kB
40. Business Analysis in Excel/7. Correlation analysis - theory.html 4.0 kB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/19. A Useful Tool for Financial Analysis - The RANK Function.srt 4.0 kB
9. Microsoft Excel - Building Professional Charts in Excel/4. Making Your Excel Charts Sexier - Proven Tips.srt 3.9 kB
45. Capital Budgeting - A Complete Case Study/5. Calculating the Cash Impact of Extra Working Capital Required.srt 3.9 kB
54. Data Analysis with ChatGPT - Complete Practical Example/5. Dealing with the Country Mapping Issue.srt 3.9 kB
51. Data Analysis with ChatGPT - Working with Functions/2. Data Lookup.srt 3.9 kB
24. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/2. The Three Parts of Cash Flow Statements Explained.srt 3.9 kB
6. Microsoft Excel - Financial Functions in Excel/2. Calculating Internal Rate of Return (IRR) in Excel.srt 3.9 kB
55. PowerPoint - Introduction to PowerPoint/5. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.srt 3.9 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/10. Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.srt 3.9 kB
34. Financial Statement Analysis - An Introduction/1. What is a 10-K Report and Why Is It important for Investors.srt 3.9 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/7. Calculating Automotive Gross Profit.srt 3.8 kB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/10. Working with Text in Excel.srt 3.8 kB
41. Finance 101 - The Time Value of Money and Interest Rate Components/4. The Components Forming Interest Rates in Real Life.srt 3.8 kB
29. Advanced Accounting - Financial Liabilities/1. The Difference Between Debt and Equity.srt 3.8 kB
40. Business Analysis in Excel/5. Value-based analysis - theory.html 3.8 kB
48. Data Analysis with ChatGPT - Exploratory Data Analysis (EDA)/3. Identifying Outliers.srt 3.8 kB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/16. Populating the P&L Sheet with SUMIF.srt 3.8 kB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/17. Learn How to Find Mistakes with COUNTIF.srt 3.8 kB
50. Data Analysis with ChatGPT - Organize Messy Data/2. Data Mapping.srt 3.8 kB
14. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios/3. Building a Flexible Model with VLOOKUP & COLUMNS.srt 3.7 kB
51. Data Analysis with ChatGPT - Working with Functions/3. Data Ranking.srt 3.6 kB
38. Working Capital Management/10. Symptoms of Inefficient Working Capital - Trade Payables.srt 3.6 kB
56. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/11. COURSE CHALLENGE - Part 4.srt 3.6 kB
14. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios/5. Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.srt 3.6 kB
2. Microsoft Excel - Quick Introduction/8. Excel Formulas for Beginners.srt 3.6 kB
34. Financial Statement Analysis - An Introduction/4. Indispensable Tools for Financial Statement Analysis.srt 3.6 kB
44. Capital Budgeting - Basic Notions/3. The Time Value of Money in a Capital Budgeting Setting.srt 3.6 kB
44. Capital Budgeting - Basic Notions/2. When Do We Use Capital Budgeting.srt 3.6 kB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/4. Ordering the Source Worksheet.srt 3.3 kB
9. Microsoft Excel - Building Professional Charts in Excel/3. Modifying Excel Charts - The Easy Way.srt 3.3 kB
51. Data Analysis with ChatGPT - Working with Functions/1. COUNTIFS, SUMIFS.srt 3.3 kB
52. Data Analysis with ChatGPT - Clean Text Data/6. Criteria-based Duplicate Removal.srt 3.3 kB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/4. Creating an Output Structure of the FMCG Model.srt 3.3 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/26. Beauty Saving - The Professional Way of Saving Files.srt 3.3 kB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/6. Income Taxes.srt 3.2 kB
51. Data Analysis with ChatGPT - Working with Functions/5. Translating Logic into Excel Formulas with ChatGPT.srt 3.2 kB
17. Accounting - Types of Revenues, Costs, Assets, and Liabilities/4. Types of Revenues - Exercise.srt 3.2 kB
38. Working Capital Management/11. Symptoms of Inefficient Working Capital - Trade Receivables.srt 3.2 kB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/14. Building the Structure of the P&L Sheet.srt 3.1 kB
35. Financial Statement Analysis - Subtleties/4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).srt 3.1 kB
56. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/5. Group or Ungroup Shapes, Pictures or Other Objects.srt 3.1 kB
13. Modeling in Excel - Building a Complete 3-statement Model/4. Filling in the Output P&L Sheet with Historical Financials.srt 3.1 kB
35. Financial Statement Analysis - Subtleties/1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.srt 3.1 kB
13. Modeling in Excel - Building a Complete 3-statement Model/2. Let's Create a Mapping of Financials.srt 3.1 kB
44. Capital Budgeting - Basic Notions/7. The Weighted Average Cost of Capital (WACC).srt 3.1 kB
25. Advanced Accounting - Trade Receivables/4. A Technique to Collect Trade Receivables Sooner.srt 3.1 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/20. Forecasting Other Liabilities.srt 3.0 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/27. The Power of F2.srt 3.0 kB
58. Next Steps/1. Next Steps.html 3.0 kB
47. Data Analysis with ChatGPT - Intro/1. How ChatGPT Advanced Data Analysis Will Boost Your Productivity.srt 3.0 kB
56. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/4. Edit Points - Learn How to Customize PowerPoint Shapes.srt 3.0 kB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/6. Inserting Formulas and Automating Calculations.srt 3.0 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/15. Calculating DSO, DIO, DPO.srt 2.9 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/17. Calculating Investments in Working Capital.srt 2.9 kB
52. Data Analysis with ChatGPT - Clean Text Data/3. Standardizing Letter Capitalization.srt 2.9 kB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/5. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.srt 2.9 kB
48. Data Analysis with ChatGPT - Exploratory Data Analysis (EDA)/2. Extracting Descriptive Statistics with ChatGPT.srt 2.9 kB
50. Data Analysis with ChatGPT - Organize Messy Data/4. Order Data with ChatGPT.srt 2.9 kB
56. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User/2. Modifying the Beginning and Ending of a Line Object.srt 2.9 kB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/1. Introduction to the Case Study.srt 2.9 kB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/3. Preliminary Mapping of the Data Extraction.srt 2.8 kB
55. PowerPoint - Introduction to PowerPoint/11. Changing an Object's Size and Rotation.srt 2.8 kB
48. Data Analysis with ChatGPT - Exploratory Data Analysis (EDA)/4. Correlation Analysis Hypothesis Formulation and Feature Ideas.srt 2.8 kB
9. Microsoft Excel - Building Professional Charts in Excel/2. Beginner's Guide to Inserting Charts in Excel.srt 2.8 kB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/20. Create Flexible Financial Models with CHOOSE.srt 2.8 kB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/12. The Mapping Exercise.srt 2.8 kB
52. Data Analysis with ChatGPT - Clean Text Data/7. Removing Duplicates Across Multiple Columns.srt 2.8 kB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/21. Goal Seek Will Help You Find the Result You Are Looking For.srt 2.8 kB
52. Data Analysis with ChatGPT - Clean Text Data/2. Dealing with Trailing and Leading Spaces in Text Data.srt 2.8 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/6. Be even quicker F5 + Enter.srt 2.8 kB
45. Capital Budgeting - A Complete Case Study/7. The Project's P&L Sheet.srt 2.8 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/9. Using Absolute and Relative Cell References.srt 2.8 kB
50. Data Analysis with ChatGPT - Organize Messy Data/3. Effective Data Classification.srt 2.7 kB
7. Microsoft Excel - Practical Exercise Build a P&L From Scratch/6. Learn How to Create a Database.srt 2.7 kB
3. Microsoft Excel - Useful Tools/9. A Quick Introduction to Excel's Pivot Tables.srt 2.7 kB
40. Business Analysis in Excel/3. Comparative analysis - theory.html 2.7 kB
2. Microsoft Excel - Quick Introduction/12. Work Efficiently by Using Cut, Copy, and Paste.srt 2.7 kB
11. Microsoft Excel - Working with Pivot Tables in Excel/3. Design the Layout and Format of Your Pivot Tables.srt 2.7 kB
52. Data Analysis with ChatGPT - Clean Text Data/1. Correcting Inverted Names.srt 2.7 kB
46. Tesla Practical Case Study - Building a Financial Planning Model/8. Calculating Automotive Cost of Sales.srt 2.6 kB
49. Data Analysis with ChatGPT - Deal with Inconsistent Data/4. Addressing Unit Discrepancies in Data.srt 2.6 kB
21. Accounting - The Core Principles of Accounting/2. Elements of the Accounting System General Ledger.srt 2.6 kB
3. Microsoft Excel - Useful Tools/2. Do More with Your Sales Data with Excel's Text to Columns Feature.srt 2.5 kB
12. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting/7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.srt 2.5 kB
41. Finance 101 - The Time Value of Money and Interest Rate Components/6. The Difference Between Fixed and Variable Interest Rates.srt 2.5 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/24. Find and Replace - Formatting.srt 2.5 kB
15. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model/4. Preparing a Cash Flow Structure.srt 2.5 kB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/6. Key Excel Functions AVERAGE & AVERAGEIF.srt 2.4 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/21. Multiply by 1.srt 2.4 kB
11. Microsoft Excel - Working with Pivot Tables in Excel/1. Pivot Tables - Excel's Dynamic and Interactive Tables.srt 2.4 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/18. How to Add a Drop-down List in Excel.srt 2.4 kB
44. Capital Budgeting - Basic Notions/1. What is Capital Budgeting.srt 2.4 kB
2. Microsoft Excel - Quick Introduction/6. Inserting, Deleting, and Modifying Rows & Columns.srt 2.4 kB
28. Advanced Accounting - Trade Payables/2. What Is the Difference Between Accounts Payable and Notes Payable.srt 2.3 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/25. Green References.srt 2.3 kB
24. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/6. FAQ Why D&A Has Been Added in Capex.html 2.3 kB
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/18. Using Excel's IFERROR Function to Trap Spreadsheet Errors.srt 2.2 kB
53. Data Analysis with ChatGPT - Dates and Time Data/2. Converting Hours to Decimals.srt 2.2 kB
36. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials/3. COURSE CHALLENGE - Part 2.srt 2.2 kB
53. Data Analysis with ChatGPT - Dates and Time Data/3. Obtaining Age in Years, Months, Days.srt 2.2 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.srt 2.2 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/3. How to Use the Same Macro On Multiple Workbooks.srt 2.2 kB
41. Finance 101 - The Time Value of Money and Interest Rate Components/8. Corporate Loan Specifics.srt 2.2 kB
4. Microsoft Excel - Best Practices That Will Make a Difference/10. Using Absolute and Relative Cell References.html 147 Bytes
4. Microsoft Excel - Best Practices That Will Make a Difference/12. Find and Select Cells That Meet Specific Conditions.html 147 Bytes
4. Microsoft Excel - Best Practices That Will Make a Difference/14. How to Create Dynamic Names in Excel Spreadsheets.html 147 Bytes
4. Microsoft Excel - Best Practices That Will Make a Difference/29. Quiz Number 1.html 147 Bytes
4. Microsoft Excel - Best Practices That Will Make a Difference/4. Macros Are a Great Timesaver! Here's Why..html 147 Bytes
4. Microsoft Excel - Best Practices That Will Make a Difference/8. The Secret to Faster Scrolling in Excel.html 147 Bytes
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/16. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.html 147 Bytes
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/22. Goal Seek Will Help You Find the Result You Are Looking For.html 147 Bytes
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/24. Perform Sensitivity Analysis with Excel's Data Tables Functionality.html 147 Bytes
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/25. Quiz Number 2.html 147 Bytes
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions/7. Key Excel Functions Average & Averageif.html 147 Bytes