“If you’re trying to prepare for an eventual career in finance, but are still looking to round out your knowledge of the subject, The Complete Financial Analyst Course might be a perfect fit for you.”, Business Insider
“A Financial Analyst Career is one of the top-paying entry-level jobs on the market.”
“Even in the toughest job markets, the best candidates find great positions.”, Forbes
You simply have to find a way to acquire practical skills that will give you an edge over the other candidates.
- 1. Introduction to the Case Study.mp4 Đã khóa
- 2. Working with an SAP data extraction.mp4 Đã khóa
- 3. Preliminary mapping of the data extraction.mp4 Đã khóa
- 4. Creating an output structure of the FMCG model.mp4 Đã khóa
- 5. Improving the layout and appearance of the FMCG report.mp4 Đã khóa
- 6. Inserting formulas and automating calculations.mp4 Đã khóa
- 7. Creating a Master Pivot Table The main data source for the FMCG report.mp4 Đã khóa
- 8. GetPivotData is great! Extracting data from the Master Pivot Table.mp4 Đã khóa
- 9. GetPivotData fix.mp4 Đã khóa
- 10. Combining Slicers and GetPivotData The key to our success.mp4 Đã khóa
- 11. Getting fancy with Excel slicers.mp4 Đã khóa
- 12. This is how the report can be used in practice by high-level executives.mp4 Đã khóa
- 1. Introduction to the Exercise.mp4 Đã khóa
- 2. Let's create a mapping of financials.mp4 Đã khóa
- 3. Building an output P&L sheet.mp4 Đã khóa
- 4. Filling in the output P&L sheet with historical financials.mp4 Đã khóa
- 5. Calculating percentage variances and applying conditional formatting.mp4 Đã khóa
- 6. Building an output Balance sheet.mp4 Đã khóa
- 7. Using Index, Match, Match to fill in the output Balance sheet.mp4 Đã khóa
- 8. Adding the forecast period.mp4 Đã khóa
- 1. Calculating historical percentage ratios and use Index and Match for scenarios.mp4 Đã khóa
- 2. Building a flexible model with Choose & Match.mp4 Đã khóa
- 3. Building a flexible model with Vlookup & Columns.mp4 Đã khóa
- 4. Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %.mp4 Đã khóa
- 5. Forecasting DSO, DPO, DIO, Other assets and Other liabilities.mp4 Đã khóa
- 1. The different types of accounting standards.mp4 Đã khóa
- 2. The three financial statements.mp4 Đã khóa
- 3. Types of revenues.mp4 Đã khóa
- 4. Types of revenues - exercise.mp4 Đã khóa
- 5. Types of expenses.mp4 Đã khóa
- 6. Income taxes.mp4 Đã khóa
- 7. Depreciation & Amortization.mp4 Đã khóa
- 8. Types of assets.mp4 Đã khóa
- 9. Asset categories - practical example.mp4 Đã khóa
- 10. Types of liabilities.mp4 Đã khóa
- 11. Liability categories - practical example.mp4 Đã khóa
- 12. Equity.mp4 Đã khóa
- 1. The Accounting Equation and Its Importance.mp4 Đã khóa
- 2. Elements of the Accounting System General Ledger.mp4 Đã khóa
- 3. T-Accounts The Best Way to Understand Debits and Credits.mp4 Đã khóa
- 4. P&L T-Accounts.mp4 Đã khóa
- 5. How to Calculate Depreciation Expense.mp4 Đã khóa
- 6. The Double-Entry Principle - The Core Principle of Bookkeeping.mp4 Đã khóa
- 1. Case Study - The Accounting Transactions of a Lemonade Stand (14).mp4 Đã khóa
- 2. Case Study - The Accounting Transactions of a Lemonade Stand (24).mp4 Đã khóa
- 3. Case Study - The Accounting Transactions of a Lemonade Stand (34).mp4 Đã khóa
- 4. Case Study - The Accounting Transactions of a Lemonade Stand (44).mp4 Đã khóa
- 1. Calculating Cash Flows - Understand if a business makes or burns cash.mp4 Đã khóa
- 2. The three parts of Cash Flow statements explained.mp4 Đã khóa
- 3. Cash Flow computations - The Direct method.mp4 Đã khóa
- 4. Cash Flow computations - The Indirect method.mp4 Đã khóa
- 5. Calculating Cash Flow in practice A complete example.mp4 Đã khóa
- 1. The different types of fixed assets.mp4 Đã khóa
- 2. Capitalizing interest expenses.mp4 Đã khóa
- 3. Fair value accounting.mp4 Đã khóa
- 4. Intangible assets with finite life vs. Intangible assets with infinite life.mp4 Đã khóa
- 5. The revaluation model.mp4 Đã khóa
- 6. The revaluation model - practical exercise.mp4 Đã khóa
- 7. Intangible assets created internally.mp4 Đã khóa
- 1. Microsoft Excel The World's #1 Office Software.mp4 Đã khóa
- 2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.mp4 Đã khóa
- 3. Data Entry Techniques in Excel.mp4 Đã khóa
- 4. How to Make Your Spreadsheets Look Professional.mp4 Đã khóa
- 6. Inserting, Deleting, and Modifying Rows & Columns.mp4 Đã khóa
- 8. Excel Formulas for Beginners.mp4 Đã khóa
- 10. A Beginner's Introduction to Excel Functions.mp4 Đã khóa
- 11. Work Efficiently by Using Cut, Copy, and Paste.mp4 Đã khóa
- 13. Pasting Values, Formulas and Formats with Paste Special.mp4 Đã khóa
- 1. The different types of equity.mp4 Đã khóa
- 2. Raising equity in different stages of a company's lifecycle.mp4 Đã khóa
- 3. The types of dividends companies pay to shareholders.mp4 Đã khóa
- 4. Dividend payments - a timeline.mp4 Đã khóa
- 5. What are share repurchases and why companies do them.mp4 Đã khóa
- 6. The idea behind stock splits.mp4 Đã khóa
- 1. What is a 10-K Report and Why Is It important for Investors.mp4 Đã khóa
- 2. Finding, Downloading and Going Through the Annual Report of P&G.mp4 Đã khóa
- 3. What is the Role of Auditing Firms and What Are the Benefits of an Audit.mp4 Đã khóa
- 4. Indispensable Tools for Financial Statement Analysis.mp4 Đã khóa
- 1. Financial Statement Analysis - A Natural Continuation of Financial Accounting.mp4 Đã khóa
- 2. First Steps in Financial Statement Analysis.mp4 Đã khóa
- 3. Horizontal vs. Vertical Financial Statement Analysis.mp4 Đã khóa
- 4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).mp4 Đã khóa
- 5. Using Accounting Ratios to Assess Business Performance.mp4 Đã khóa
- 1. What you will see next in this section.mp4 Đã khóa
- 2. How to download Tesla's historical financials.mp4 Đã khóa
- 3. Calculating and analyzing growth and profitability ratios.mp4 Đã khóa
- 4. Calculating and analyzing liquidity ratios.mp4 Đã khóa
- 5. Calculating and analyzing solvency ratios.mp4 Đã khóa
- 1. Introduction.mp4 Đã khóa
- 2. The importance of working capital optimization case study.mp4 Đã khóa
- 3. Overtrading vs. excessive investment.mp4 Đã khóa
- 4. Trade receivables management.mp4 Đã khóa
- 5. Re-order level.mp4 Đã khóa
- 6. Economic order quantity (EOQ).mp4 Đã khóa
- 7. Inventory optimization techniques.mp4 Đã khóa
- 8. Trade payables management.mp4 Đã khóa
- 9. Working capital optimization - a roadmap.mp4 Đã khóa
- 10. Symptoms of inefficient working capital - Trade payables.mp4 Đã khóa
- 1. Finance 101 Important Financial Principles That You Will Need.mp4 Đã khóa
- 2. Understanding the Time Value of Money.mp4 Đã khóa
- 3. How Interest Rates Play an Important Role in the Economy.mp4 Đã khóa
- 4. The Components Forming Interest Rates in Real Life.mp4 Đã khóa
- 5. What Is Libor and What Purpose Does It Serve.mp4 Đã khóa
- 6. The Difference Between Fixed and Variable Interest Rates.mp4 Đã khóa
- 7. What Is Default Risk and How Does a Bank Account For It.mp4 Đã khóa
- 8. Corporate Loan Specifics.mp4 Đã khóa
- 1. Inserting a Line Break with Alt + Enter.mp4 Đã khóa
- 2. Do More with Your Sales Data with Excel's Text to Columns Feature.mp4 Đã khóa
- 4. Create Easily Printable Excel Documents.mp4 Đã khóa
- 5. How to Wrap Text in Excel and Adjust a Cell's Size.mp4 Đã khóa
- 6. Insert Hyperlinks into Excel Spreadsheets.mp4 Đã khóa
- 7. Using Excel's Freeze Panes to Handle Large Datasets.mp4 Đã khóa
- 8. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp4 Đã khóa
- 9. A Quick Introduction to Excel's Pivot Tables.mp4 Đã khóa
- 1. What is Capital Budgeting.mp4 Đã khóa
- 2. When Do We Use Capital Budgeting.mp4 Đã khóa
- 3. The Time Value of Money in a Capital Budgeting Setting.mp4 Đã khóa
- 4. Calculating Present and Future Value.mp4 Đã khóa
- 5. Cost of Equity.mp4 Đã khóa
- 6. Project-specific Beta.mp4 Đã khóa
- 7. The Weighted Average Cost of Capital (WACC).mp4 Đã khóa
- 8. The Different Cash Flow Types in a Capital Budgeting Exercise.mp4 Đã khóa
- 9. Modeling Future Cash Flows.mp4 Đã khóa
- 1. An introduction to the Case Study.mp4 Đã khóa
- 2. Organizing inputs in the Drivers sheet.mp4 Đã khóa
- 3. Modeling expected savings - Building cars in Italy vs. Building cars in Vietnam.mp4 Đã khóa
- 4. Preparing a fixed asset rollforward schedule.mp4 Đã khóa
- 5. Calculating the cash impact of extra working capital required.mp4 Đã khóa
- 6. Debt repayment and interest expenses calculation.mp4 Đã khóa
- 7. The project's P&L sheet.mp4 Đã khóa
- 8. The project's cash flow calculation.mp4 Đã khóa
- 9. Calculating WACC (Weighted Average Cost of Capital).mp4 Đã khóa
- 10. Estimating cost of equity.mp4 Đã khóa
- 11. Discounting project cash flows.mp4 Đã khóa
- 12. Performing sensitivity analysis and wrapping up the Case Study.mp4 Đã khóa
- 1. Organizing external inputs in a 'Drivers' sheet.mp4 Đã khóa
- 2. The input data we will work with.mp4 Đã khóa
- 3. Forecasting Tesla's expected deliveries.mp4 Đã khóa
- 4. Comparing delivery figures with the ones of industry peers.mp4 Đã khóa
- 5. Estimating an average selling price of Tesla vehicles.mp4 Đã khóa
- 6. Calculating automotive revenue.mp4 Đã khóa
- 7. Peer comparison Gross profit %.mp4 Đã khóa
- 8. Calculating automotive gross profit.mp4 Đã khóa
- 9. Calculating automotive cost of sales.mp4 Đã khóa
- 10. Forecasting 'energy' and 'services' revenue.mp4 Đã khóa
- 11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4 Đã khóa
- 12. Forecasting operating expenses.mp4 Đã khóa
- 13. Building a fixed asset roll forward estimating Capex.mp4 Đã khóa
- 14. Building a fixed asset roll forward D&A schedule.mp4 Đã khóa
- 15. Peer comparison D&A as a percentage of revenues.mp4 Đã khóa
- 16. Calculating DSO, DIO, DPO.mp4 Đã khóa
- 17. Producing a clean P&L output sheet.mp4 Đã khóa
- 18. Fill in the P&L output sheet.mp4 Đã khóa
- 19. Calculating investments in working capital.mp4 Đã khóa
- 20. Forecasting Unlevered Free Cash Flow.mp4 Đã khóa
- 21. Forecasting other assets.mp4 Đã khóa
- 22. Forecasting other liabilities.mp4 Đã khóa
- 23. Completing Unlevered Free Cash Flow.mp4 Đã khóa
- 24. Modeling Tesla's financing needs in the forecast period.mp4 Đã khóa
- 25. Calculating Net income.mp4 Đã khóa
- 26. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 Đã khóa
- 27. Balancing the Balance sheet.mp4 Đã khóa
- 1. Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp4 Đã khóa
- 2. The Structure of the PowerPoint Ribbon.mp4 Đã khóa
- 3. General Considerations About Slide Structure.mp4 Đã khóa
- 4. Learn How to Insert Objects in PowerPoint.mp4 Đã khóa
- 5. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp4 Đã khóa
- 6. Add Frequently Used Buttons to the Quick Access Toolbar.mp4 Đã khóa
- 7. How to Easily Align Objects in PowerPoint.mp4 Đã khóa
- 8. How to Edit Shapes in Your Presentation.mp4 Đã khóa
- 9. How to Format Text Boxes in a PowerPoint Presentation.mp4 Đã khóa
- 10. Changing an Object's Size and Rotation.mp4 Đã khóa
- 11. Using Slide Masters.mp4 Đã khóa
- 1. Modifying the Beginning and Ending of a Line Object.mp4 Đã khóa
- 2. Join Shapes Together By Using Connector Lines.mp4 Đã khóa
- 3. Group or Ungroup Shapes, Pictures or Other Objects.mp4 Đã khóa
- 4. This is How You Can Fit Text When It Is Larger than a Shape.mp4 Đã khóa
- 5. PowerPoint's Smart Art Feature Offers Great Return for Your Time.mp4 Đã khóa
- 6. Creating Eye-Catching Text Effects in PowerPoint.mp4 Đã khóa
- 7. Practical Exercise - Creating an Organisational Chart.mp4 Đã khóa
- 8. COURSE CHALLENGE - Part 4.mp4 Đã khóa
- 1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4 Đã khóa
- 2. Macros Are a Great Timesaver! Here's Why.mp4 Đã khóa
- 3. How to Use the Same Macro On Multiple Workbooks.mp4 Đã khóa
- 5. The Secret to Faster Scrolling in Excel.mp4 Đã khóa
- 6. Be even quicker F5 + Enter.mp4 Đã khóa
- 8. Using Absolute and Relative Cell References.mp4 Đã khóa
- 10. Find and Select Cells That Meet Specific Conditions.mp4 Đã khóa
- 12. How to Create Dynamic Names in Excel Spreadsheets.mp4 Đã khóa
- 14. Using Named Ranges to Make Formulas More Readable.mp4 Đã khóa
- 15. Custom Number Formatting.mp4 Đã khóa
- 16. How to Add a Drop-down List in Excel.mp4 Đã khóa
- 17. Using Custom-sort to Sort Multiple Columns Within a Table.mp4 Đã khóa
- 18. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4 Đã khóa
- 19. Multiply by 1.mp4 Đã khóa
- 20. Find and Replace - References.mp4 Đã khóa
- 21. Find and Replace - Formatting.mp4 Đã khóa
- 22. Green References.mp4 Đã khóa
- 23. Beauty Saving - The Professional Way of Saving Files.mp4 Đã khóa
- 24. The Power of F2.mp4 Đã khóa
- 25. Conditional Formatting.mp4 Đã khóa
- 1. Key Excel Functions If.mp4 Đã khóa
- 2. Enlarge the formula bar.mp4 Đã khóa
- 3. Key Excel Functions Sum, Sumif, Sumifs.mp4 Đã khóa
- 4. Key Excel Functions Count, Counta, Countif, Countifs.mp4 Đã khóa
- 5. Key Excel Functions Average & Averageif.mp4 Đã khóa
- 6. Key Excel Functions Left, Right, Mid, Upper, Lower, Proper, Concatenate, &.mp4 Đã khóa
- 8. Working with text in Excel.mp4 Đã khóa
- 9. Find the Highest and Lowest Values in a Range Max & Min.mp4 Đã khóa
- 10. = and + are interchangeable when you start typing a formula.mp4 Đã khóa
- 11. Use Round in Your Financial Models.mp4 Đã khóa
- 12. Excel's Lookup Functions Vlookup & Hlookup Made Easy.mp4 Đã khóa
- 13. Index, Match, and Their Combination - The Perfect Substitute for Vlookup.mp4 Đã khóa
- 15. Using Excel's Iferror Function to Trap Spreadsheet Errors.mp4 Đã khóa
- 16. A Useful Tool for Financial Analysis - The Rank Function.mp4 Đã khóa
- 17. Create Flexible Financial Models with Choose.mp4 Đã khóa
- 18. Goal Seek Will Help You Find the Result You Are Looking For.mp4 Đã khóa
- 20. Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp4 Đã khóa
- 1. Introduction to the Case Study.mp4 Đã khóa
- 2. What You Will See Next.mp4 Đã khóa
- 3. Understand Your Data Source Before You Start Working on It.mp4 Đã khóa
- 4. Ordering the Source Worksheet.mp4 Đã khóa
- 5. Create a Code The Best Way to Organize Your Data and Work Efficiently with It.mp4 Đã khóa
- 6. Learn How to Create a Database.mp4 Đã khóa
- 7. Using Lookup Functions (Vlookup) to Fill the Database Sheet.mp4 Đã khóa
- 8. Use Sumif to Complete the Database Sheet.mp4 Đã khóa
- 9. Using Index & Match as a Substitute for Vlookup.mp4 Đã khóa
- 10. The Mapping Exercise.mp4 Đã khóa
- 11. Mapping the Rows in the Database Sheet.mp4 Đã khóa
- 12. Building the Structure of the P&L Sheet.mp4 Đã khóa
- 13. A Practical Example of Professional Formatting in Excel.mp4 Đã khóa
- 14. Populate the P&L Sheet with Sumif.mp4 Đã khóa
- 15. Learn How to Find Mistakes with Countif.mp4 Đã khóa
- 16. Calculating Growth Rates in Excel.mp4 Đã khóa
- 1. Introduction to Excel Charts.mp4 Đã khóa
- 2. Beginner's Guide to Inserting Charts in Excel.mp4 Đã khóa
- 3. Modifying Excel Charts - The Easy Way.mp4 Đã khóa
- 4. Making Your Excel Charts Sexier - Proven Tips.mp4 Đã khóa
- 5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp4 Đã khóa
- 6. New Ways to Visualize Your Data - Treemap Charts.mp4 Đã khóa
- 7. How to Represent Trends with Sparklines.mp4 Đã khóa
- 1. Pivot Tables - Excel's Dynamic and Interactive Tables.mp4 Đã khóa
- 2. Creating a Pivot Table Choosing Row and Column Parameters.mp4 Đã khóa
- 3. Design the Layout and Format of Your Pivot Tables.mp4 Đã khóa
- 4. Additional Techniques That Will Ease Your Work with Pivot Tables.mp4 Đã khóa
- 5. One of the Most Useful Excel Functions - GetPivotData.mp4 Đã khóa
- 6. Welcome to the Future - Pivot Table Slicers.mp4 Đã khóa
- 7. Introduction to the Course Challenge.mp4 Đã khóa
- 8. COURSE CHALLENGE - Part 1.mp4 Đã khóa