Download Free Download : Udemy - The Complete Financial Analyst Course 2024
mp4 | Video: h264,1280X720 | Audio: AAC, 44.1 KHz
Genre:eLearning | Language: English | Size:10.96 GB
Files Included :
1 What Does the Course Cover.mp4 (67.31 MB)
MP4
2 Everything We Will Learn Has a Practical Application.mp4 (41.78 MB)
MP4
3 The Best Way to Take This Course.mp4 (31.14 MB)
MP4
1 Introduction.mp4 (5.93 MB)
MP4
2 Stacked Column Chart with a Secondary Axis.mp4 (41.26 MB)
MP4
3 Doughnut Chart.mp4 (34.48 MB)
MP4
4 Area Chart.mp4 (25.38 MB)
MP4
5 Bridge Chart.mp4 (46.57 MB)
MP4
1 Pivot Tables - Excel's Dynamic and Interactive Tables.mp4 (22.56 MB)
MP4
2 Creating a Pivot Table Choosing Row and Column Parameters.mp4 (29.41 MB)
MP4
3 Design the Layout and Format of Your Pivot Tables.mp4 (15.56 MB)
MP4
4 Additional Techniques That Will Ease Your Work with Pivot Tables.mp4 (35.86 MB)
MP4
5 One of the Most Useful Excel Functions - GETPIVOTDATA.mp4 (27.42 MB)
MP4
6 Welcome to the Future - Pivot Table Slicers.mp4 (36.19 MB)
MP4
7 Introduction to the Course Challenge.mp4 (12.29 MB)
MP4
8 COURSE CHALLENGE - Part 1.mp4 (23.25 MB)
MP4
1 Introduction to the Case Study.mp4 (41.32 MB)
MP4
11 Combining Slicers and GETPIVOTDATA The Key to Our Success.mp4 (33.61 MB)
MP4
12 Getting Fancy with Excel Slicers.mp4 (32.41 MB)
MP4
13 This is How the Report Can be Used in Practice by High-level Executives.mp4 (36.18 MB)
MP4
2 Working with an SAP Data Extraction.mp4 (36.99 MB)
MP4
3 Preliminary Mapping of the Data Extraction.mp4 (30.22 MB)
MP4
4 Creating an Output Structure of the FMCG Model.mp4 (19.71 MB)
MP4
5 Improving the Layout and Appearance of the FMCG Report.mp4 (23.89 MB)
MP4
6 Inserting Formulas and Automating Calculations.mp4 (16.15 MB)
MP4
7 Creating a Master Pivot Table The Main Data Source for the FMCG Report.mp4 (20.14 MB)
MP4
8 GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.mp4 (49.95 MB)
MP4
9 GETPIVOTDATA Fix.mp4 (11.92 MB)
MP4
1 Introduction to the Exercise.mp4 (32.77 MB)
MP4
2 Let's Create a Mapping of Financials.mp4 (27.18 MB)
MP4
3 Building an Output P&L Sheet.mp4 (26.76 MB)
MP4
4 Filling in the Output P&L Sheet with Historical Financials.mp4 (20.62 MB)
MP4
5 Calculating Percentage Variances and Applying Conditional Formatting.mp4 (23.89 MB)
MP4
6 Building an Output Balance Sheet.mp4 (26.23 MB)
MP4
7 Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet.mp4 (37.71 MB)
MP4
8 Adding the Forecast Period.mp4 (27.98 MB)
MP4
1 Calculating Historical Percentage Ratios and Use OFFSET and MATCH for Scenarios.mp4 (43.92 MB)
MP4
2 Building a Flexible Model with CHOOSE & MATCH.mp4 (13.93 MB)
MP4
3 Building a Flexible Model with VLOOKUP & COLUMNS.mp4 (32.62 MB)
MP4
4 Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.mp4 (39.43 MB)
MP4
5 Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.mp4 (26.98 MB)
MP4
1 Building a Fixed Asset Roll Forward.mp4 (36.37 MB)
MP4
2 Building a Financial Liabilities Schedule.mp4 (41.85 MB)
MP4
3 Building an Equity Schedule.mp4 (32.88 MB)
MP4
4 Preparing a Cash Flow Structure.mp4 (12.54 MB)
MP4
5 Calculating Cash Flows and Completing the Model.mp4 (51.03 MB)
MP4
1 Accounting The Science Behind Financial Figures.mp4 (54.02 MB)
MP4
2 What is Accounting and Why Do You Need It.mp4 (45.8 MB)
MP4
3 The Importance of Bookkeeping - Good Accounting Records Are Essential.mp4 (29.14 MB)
MP4
4 An Introduction to Financial Accounting.mp4 (22.26 MB)
MP4
1 The Different Types of Accounting Standards.mp4 (23.01 MB)
MP4
10 Asset Categories - Practical Example.mp4 (30.53 MB)
MP4
11 Liability Categories - Practical Example.mp4 (29.72 MB)
MP4
12 Equity.mp4 (15.05 MB)
MP4
13 Equity Categories - Practical Example.mp4 (39.97 MB)
MP4
2 The Three Financial Statements.mp4 (19.14 MB)
MP4
3 Types of Revenues.mp4 (52.18 MB)
MP4
4 Types of Revenues - Exercise.mp4 (15.7 MB)
MP4
5 Types of Expenses.mp4 (43.29 MB)
MP4
6 Income Taxes.mp4 (15.43 MB)
MP4
7 Depreciation & Amortization.mp4 (37.45 MB)
MP4
8 The Two Types of Income Statement Formats.mp4 (10.83 MB)
MP4
9 Balance Sheet Items.mp4 (35.35 MB)
MP4
1 Accrual Accounting.mp4 (59.39 MB)
MP4
2 Revenue Recognition Criteria - Technical.mp4 (39.73 MB)
MP4
3 Potential Conflicts of Interest When Recognizing Revenue.mp4 (16.31 MB)
MP4
4 A Practical Example.mp4 (50.23 MB)
MP4
1 Cost recognition principles.mp4 (22.65 MB)
MP4
2 Technical Aspects of Cost Recognition.mp4 (23.19 MB)
MP4
1 Microsoft Excel The World's #1 Office Software.mp4 (36.31 MB)
MP4
10 A Beginner's Introduction to Excel Functions.mp4 (18.32 MB)
MP4
11 Format Cells.mp4 (30.97 MB)
MP4
12 Work Efficiently by Using Cut, Copy, and Paste.mp4 (12.5 MB)
MP4
14 Pasting Values, Formulas and Formats with Paste Special.mp4 (9.71 MB)
MP4
2 Excel Made Easy A Beginner's Guide to Excel Spreadsheets.mp4 (17.54 MB)
MP4
3 Data Entry Techniques in Excel.mp4 (26.76 MB)
MP4
4 How to Make Your Spreadsheets Look Professional.mp4 (35.9 MB)
MP4
6 Inserting, Deleting, and Modifying Rows & Columns.mp4 (9.45 MB)
MP4
8 Excel Formulas for Beginners.mp4 (12.11 MB)
MP4
1 The Revenue Recognition Principle - Why Is It So Important.mp4 (23.21 MB)
MP4
2 The Expense Recognition Principle - When to Recognize Expenses.mp4 (22.64 MB)
MP4
3 Historical Cost vs Fair Value Accounting.mp4 (20.37 MB)
MP4
1 The Accounting Equation and Its Importance.mp4 (15.03 MB)
MP4
2 Elements of the Accounting System General Ledger.mp4 (14.53 MB)
MP4
3 T-Accounts The Best Way to Understand Debits and Credits.mp4 (29.43 MB)
MP4
4 P&L T-Accounts.mp4 (21.72 MB)
MP4
5 The Double-Entry Principle - The Core Principle of Bookkeeping.mp4 (40.56 MB)
MP4
1 Case Study - The Accounting Transactions of a Lemonade Stand (14).mp4 (70.73 MB)
MP4
2 Case Study - The Accounting Transactions of a Lemonade Stand (24).mp4 (43.96 MB)
MP4
3 Case Study - The Accounting Transactions of a Lemonade Stand (34).mp4 (46.88 MB)
MP4
4 Case Study - The Accounting Transactions of a Lemonade Stand (44).mp4 (51.97 MB)
MP4
1 Timing of Cash Flows and Why It Plays an Important Role in a Business.mp4 (9.71 MB)
MP4
2 Timing of Income Principles of Revenue Recognition.mp4 (44.6 MB)
MP4
3 Timing of Expenses Principles of Cost Recognition.mp4 (23.21 MB)
MP4
1 Calculating Cash Flows - Understand If a Business Makes or Burns Cash.mp4 (23.8 MB)
MP4
2 The Three Parts of Cash Flow Statements Explained.mp4 (23.32 MB)
MP4
3 Cash Flow Computations - The Direct Method.mp4 (18.48 MB)
MP4
4 Cash Flow Computations - The Indirect Method.mp4 (25.81 MB)
MP4
5 Calculating Cash Flow in Practice A Complete Example.mp4 (52.51 MB)
MP4
1 Why a Company Needs to Pay Attention to Trade Receivables.mp4 (23.3 MB)
MP4
2 What If Clients Do Not Pay on Time.mp4 (24.36 MB)
MP4
3 How to Handle Non-paying Customers A Case-study.mp4 (22.8 MB)
MP4
4 A Technique to Collect Trade Receivables Sooner.mp4 (13.8 MB)
MP4
1 The Different Types of Inventory We Can Have.mp4 (23.95 MB)
MP4
2 The Connection Between Cost of Goods Sold and Inventory.mp4 (14.5 MB)
MP4
3 Cost Flow Methods.mp4 (24.3 MB)
MP4
4 Cost Flow Methods - a Practical Exercise.mp4 (6.46 MB)
MP4
1 The Different Types of Fixed Assets.mp4 (18.46 MB)
MP4
2 Capitalizing Interest Expenses.mp4 (7.05 MB)
MP4
3 Fair Value Accounting.mp4 (41.18 MB)
MP4
4 Intangible Assets with Finite Life vs Intangible Assets with Infinite Life.mp4 (32.23 MB)
MP4
5 The Revaluation Model.mp4 (35.15 MB)
MP4
6 The Revaluation Model - Practical Exercise.mp4 (34.09 MB)
MP4
7 Intangible Assets Created Internally.mp4 (16.26 MB)
MP4
1 How We Account for Trade Payables.mp4 (19.9 MB)
MP4
2 What Is the Difference Between Accounts Payable and Notes Payable.mp4 (9.6 MB)
MP4
3 Why Use E-invoicing.mp4 (22.71 MB)
MP4
1 The Difference Between Debt and Equity.mp4 (13.13 MB)
MP4
2 Amortizing a Loan.mp4 (18.18 MB)
MP4
3 Debt Covenants.mp4 (23.27 MB)
MP4
4 Debt Covenants - A Practical Example.mp4 (12.24 MB)
MP4
1 Inserting a Line Break with Alt + Enter.mp4 (9.87 MB)
MP4
2 Do More with Your Sales Data with Excel's Text to Columns Feature.mp4 (11.74 MB)
MP4
4 Create Easily Printable Excel Documents.mp4 (8.37 MB)
MP4
5 How to Wrap Text in Excel and Adjust a Cell's Size.mp4 (3.16 MB)
MP4
6 Insert Hyperlinks into Excel Spreadsheets.mp4 (7.2 MB)
MP4
7 Using Excel's Freeze Panes to Handle Large Datasets.mp4 (14.5 MB)
MP4
8 Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp4 (15.06 MB)
MP4
9 A Quick Introduction to Excel's Pivot Tables.mp4 (40.1 MB)
MP4
1 The Reason Companies Lease Assets.mp4 (10.05 MB)
MP4
2 Solving a Complete Leasing Exercise.mp4 (40.12 MB)
MP4
1 What is Leverage and Why Companies Use Financial Leverage.mp4 (53.54 MB)
MP4
2 The Implications of Using Excessive Leverage.mp4 (32.13 MB)
MP4
1 The Different Types of Equity.mp4 (53.43 MB)
MP4
2 Raising Equity in Different Stages of a Company's Lifecycle.mp4 (67.96 MB)
MP4
3 The Types of Dividends Companies Pay to Shareholders.mp4 (42.3 MB)
MP4
4 Dividend Payments - a Timeline.mp4 (33.52 MB)
MP4
5 What Are Share Repurchases and Why Companies Do Them.mp4 (42.42 MB)
MP4
6 The Idea Behind Stock Splits.mp4 (34.26 MB)
MP4
1 What is a 10-K Report and Why Is It important for Investors.mp4 (21.79 MB)
MP4
2 Finding, Downloading and Going Through the Annual Report of P&G.mp4 (77.51 MB)
MP4
3 What Is the Role of Auditing Firms and What Are the Benefits of an Audit.mp4 (26.34 MB)
MP4
4 Indispensable Tools for Financial Statement Analysis.mp4 (14.27 MB)
MP4
1 Financial Statement Analysis - A Natural Continuation of Financial Accounting.mp4 (16.83 MB)
MP4
2 First Steps in Financial Statement Analysis.mp4 (25.61 MB)
MP4
3 Horizontal vs Vertical Financial Statement Analysis.mp4 (27.28 MB)
MP4
4 Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).mp4 (18 MB)
MP4
5 Using Accounting Ratios to Assess Business Performance.mp4 (62.28 MB)
MP4
1 Case Study - Calculating Ratios and Analyzing P&G's Financials (12).mp4 (55.6 MB)
MP4
2 Case Study - Calculating Ratios and Analyzing P&G's Financials (22).mp4 (32.47 MB)
MP4
3 COURSE CHALLENGE - Part 2.mp4 (30.59 MB)
MP4
1 What You Will See Next In This Section.mp4 (17.64 MB)
MP4
2 How to Download Tesla's Historical Financials.mp4 (16.65 MB)
MP4
3 Calculating and Analyzing Growth and Profitability Ratios.mp4 (106.55 MB)
MP4
4 Calculating and Analyzing Liquidity Ratios.mp4 (71.62 MB)
MP4
5 Calculating and Analyzing Solvency Ratios.mp4 (24.5 MB)
MP4
1 Introduction.mp4 (22.25 MB)
MP4
10 Symptoms of Inefficient Working Capital - Trade Payables.mp4 (15.84 MB)
MP4
11 Symptoms of Inefficient Working Capital - Trade Receivables.mp4 (13.8 MB)
MP4
2 The Importance of Working Capital Optimization Case Study.mp4 (80.7 MB)
MP4
3 Overtrading vs Excessive Investment.mp4 (30.14 MB)
MP4
4 Trade Receivables Management.mp4 (68.72 MB)
MP4
5 Re-order Level.mp4 (28.37 MB)
MP4
6 Economic Order Quantity (EOQ).mp4 (28.16 MB)
MP4
7 Inventory Optimization Techniques.mp4 (45.16 MB)
MP4
8 Trade Payables Management.mp4 (17.35 MB)
MP4
9 Working Capital Optimization - a Roadmap.mp4 (43.46 MB)
MP4
1 Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4 (21.23 MB)
MP4
11 Find and Select Cells That Meet Specific Conditions.mp4 (11.9 MB)
MP4
13 How to Create Dynamic Names in Excel Spreadsheets.mp4 (14.02 MB)
MP4
15 Using Named Ranges to Make Formulas More Readable.mp4 (7.65 MB)
MP4
16 Introduction to Custom Formatting in Excel.mp4 (40.94 MB)
MP4
17 Custom Number Formatting.mp4 (8.27 MB)
MP4
18 How to Add a Drop-down List in Excel.mp4 (13.99 MB)
MP4
19 Using Custom-sort to Sort Multiple Columns Within a Table.mp4 (21.95 MB)
MP4
2 Macros Are a Great Timesaver! Here's Why.mp4 (33.56 MB)
MP4
20 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4 (41.91 MB)
MP4
21 Multiply by 1.mp4 (13.73 MB)
MP4
22 Find and Replace - References.mp4 (21.94 MB)
MP4
24 Find and Replace - Formatting.mp4 (12.55 MB)
MP4
25 Green References.mp4 (11.5 MB)
MP4
26 Beauty Saving - The Professional Way of Saving Files.mp4 (12.95 MB)
MP4
27 The Power of F2.mp4 (16.72 MB)
MP4
28 Conditional Formatting.mp4 (52.02 MB)
MP4
3 How to Use the Same Macro On Multiple Workbooks.mp4 (10.68 MB)
MP4
5 The Secret to Faster Scrolling in Excel.mp4 (19.52 MB)
MP4
6 Be even quicker F5 + Enter.mp4 (19.12 MB)
MP4
9 Using Absolute and Relative Cell References.mp4 (43.47 MB)
MP4
10 Time series analysis.mp4 (67.28 MB)
MP4
12 Regression analysis.mp4 (42.82 MB)
MP4
2 Trend analysis.mp4 (70.31 MB)
MP4
4 Comparative analysis.mp4 (32.34 MB)
MP4
6 Value-based analysis.mp4 (37.53 MB)
MP4
8 Correlation analysis.mp4 (36.31 MB)
MP4
1 Finance 101 Important Financial Principles That You Will Need.mp4 (26.57 MB)
MP4
2 Understanding the Time Value of Money.mp4 (9.65 MB)
MP4
3 How Interest Rates Play an Important Role in the Economy.mp4 (21.54 MB)
MP4
4 The Components Forming Interest Rates in Real Life.mp4 (25.99 MB)
MP4
5 What Is Libor and What Purpose Does It Serve.mp4 (27.66 MB)
MP4
6 The Difference Between Fixed and Variable Interest Rates.mp4 (26.42 MB)
MP4
7 What Is Default Risk and How Does a Bank Account For It.mp4 (47.78 MB)
MP4
8 Corporate Loan Specifics.mp4 (40.85 MB)
MP4
1 Calculating the Present Value of Future Cash Flows.mp4 (46.83 MB)
MP4
2 A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.mp4 (45.9 MB)
MP4
1 Using Annuities.mp4 (22.22 MB)
MP4
2 Calculating a Complete Loan Schedule.mp4 (44.72 MB)
MP4
3 COURSE CHALLENGE - Part 3.mp4 (22.43 MB)
MP4
1 What is Capital Budgeting.mp4 (12.32 MB)
MP4
2 When Do We Use Capital Budgeting.mp4 (19.21 MB)
MP4
3 The Time Value of Money in a Capital Budgeting Setting.mp4 (16.9 MB)
MP4
4 Calculating Present and Future Value.mp4 (31.56 MB)
MP4
5 Cost of Equity.mp4 (51.47 MB)
MP4
6 Project-specific Beta.mp4 (24.78 MB)
MP4
7 The Weighted Average Cost of Capital (WACC).mp4 (14.01 MB)
MP4
8 The Different Cash Flow Types in a Capital Budgeting Exercise.mp4 (21.84 MB)
MP4
9 Modeling Future Cash Flows.mp4 (50.47 MB)
MP4
1 An Introduction to the Case Study.mp4 (22.35 MB)
MP4
10 Estimating Cost of Equity.mp4 (36.02 MB)
MP4
11 Discounting Project Cash Flows.mp4 (24.01 MB)
MP4
12 Performing Sensitivity Analysis and Wrapping Up the Case Study.mp4 (41.98 MB)
MP4
2 Organizing Inputs In the Drivers Sheet.mp4 (31.99 MB)
MP4
3 Modeling Expected Savings - Building Cars In Italy vs Building Cars In Vietnam.mp4 (32.08 MB)
MP4
4 Preparing a Fixed Asset Rollforward Schedule.mp4 (44.52 MB)
MP4
5 Calculating the Cash Impact of Extra Working Capital Required.mp4 (16.31 MB)
MP4
6 Debt Repayment and Interest Expenses Calculation.mp4 (19.95 MB)
MP4
7 The Project's P&L Sheet.mp4 (12.9 MB)
MP4
8 The Project's Cash Flow Calculation.mp4 (29.05 MB)
MP4
9 Calculating WACC (Weighted Average Cost of Capital).mp4 (16.33 MB)
MP4
1 Organizing External Inputs in a 'Drivers' Sheet.mp4 (35.09 MB)
MP4
10 Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.mp4 (23.85 MB)
MP4
11 Forecasting Operating Expenses.mp4 (27.45 MB)
MP4
12 Building a Fixed Asset Roll Forward PP&E.mp4 (32.74 MB)
MP4
13 Building a Fixed Asset Roll Forward Estimating Capex.mp4 (39.3 MB)
MP4
14 Building a Fixed Asset Roll Forward D&A Schedule.mp4 (34.02 MB)
MP4
15 Calculating DSO, DIO, DPO.mp4 (16.67 MB)
MP4
16 Producing a Clean P&L Output Sheet.mp4 (14.47 MB)
MP4
17 Calculating Investments in Working Capital.mp4 (18.69 MB)
MP4
18 Forecasting Unlevered Free Cash Flow.mp4 (31.22 MB)
MP4
19 Forecasting Other Assets.mp4 (44.47 MB)
MP4
2 Forecasting Tesla's Expected Deliveries.mp4 (103.4 MB)
MP4
20 Forecasting Other Liabilities.mp4 (20.11 MB)
MP4
21 Completing Unlevered Free Cash Flow.mp4 (66.81 MB)
MP4
22 Modeling Tesla's Financing Needs in the Forecast Period.mp4 (38.83 MB)
MP4
23 Calculating Net Income.mp4 (13.81 MB)
MP4
24 Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 (40.56 MB)
MP4
25 Balancing the Balance Sheet.mp4 (11.92 MB)
MP4
3 Comparing Delivery Figures with the Ones of industry Peers.mp4 (19.77 MB)
MP4
4 Estimating an Average Selling Price of Tesla Vehicles.mp4 (45.99 MB)
MP4
5 Calculating Automotive Revenue.mp4 (40.52 MB)
MP4
6 Peer Comparison Gross Profit %.mp4 (35.72 MB)
MP4
7 Calculating Automotive Gross Profit.mp4 (22.27 MB)
MP4
8 Calculating Automotive Cost of Sales.mp4 (12.71 MB)
MP4
9 Forecasting 'Energy' and 'Services' Revenue.mp4 (19.1 MB)
MP4
1 How ChatGPT Advanced Data Analysis Will Boost Your Productivity.mp4 (28.52 MB)
MP4
2 The Limitations of ChatGPT Advanced Data Analysis.mp4 (47.93 MB)
MP4
1 Exploratory Data Analysis - Intro.mp4 (57.15 MB)
MP4
2 Extracting Descriptive Statistics with ChatGPT.mp4 (19.32 MB)
MP4
3 Identifying Outliers.mp4 (18.07 MB)
MP4
4 Correlation Analysis Hypothesis Formulation and Feature Ideas.mp4 (19.23 MB)
MP4
5 Crafting a Comprehensive EDA Prompt.mp4 (93.11 MB)
MP4
1 Identifying and Handling Erroneous Data.mp4 (33.28 MB)
MP4
2 Verifying Data for Errors.mp4 (36.79 MB)
MP4
3 Eliminating Duplicate Rows.mp4 (12.4 MB)
MP4
4 Addressing Unit Discrepancies in Data.mp4 (19.01 MB)
MP4
5 Dividing Cell Content into Multiple Cells.mp4 (46.27 MB)
MP4
1 Key Excel Functions IF.mp4 (14.91 MB)
MP4
10 Working with Text in Excel.mp4 (13.37 MB)
MP4
11 Find the Highest and Lowest Values in a Range Max & Min.mp4 (12.39 MB)
MP4
12 = and + are Interchangeable When You Start Typing a Formula.mp4 (5.03 MB)
MP4
13 Use ROUND in Your Financial Models.mp4 (8.48 MB)
MP4
14 Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.mp4 (52.57 MB)
MP4
15 INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.mp4 (99.54 MB)
MP4
17 XLOOKUP a Solid Substitute of VLOOKUP (Office 365 only).mp4 (40.27 MB)
MP4
18 Using Excel's IFERROR Function to Trap Spreadsheet Errors.mp4 (19.2 MB)
MP4
19 A Useful Tool for Financial Analysis - The RANK Function.mp4 (20.14 MB)
MP4
2 Enlarge the Formula Bar.mp4 (5.71 MB)
MP4
20 Create Flexible Financial Models with CHOOSE.mp4 (32 MB)
MP4
21 Goal Seek Will Help You Find the Result You Are Looking For.mp4 (25.39 MB)
MP4
23 Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp4 (41.74 MB)
MP4
3 Key Excel Functions SUM, SUMIF, SUMIFS.mp4 (27.42 MB)
MP4
5 Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 (49.87 MB)
MP4
6 Key Excel Functions AVERAGE & AVERAGEIF.mp4 (24.15 MB)
MP4
8 Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.mp4 (48.96 MB)
MP4
1 Organize Messy Data.mp4 (50.64 MB)
MP4
2 Data Mapping.mp4 (23.04 MB)
MP4
3 Effective Data Classification.mp4 (14.18 MB)
MP4
4 Order Data with ChatGPT.mp4 (18.11 MB)
MP4
1 COUNTIFS, SUMIFS.mp4 (24.75 MB)
MP4
2 Data Lookup.mp4 (26.32 MB)
MP4
3 Data Ranking.mp4 (24.5 MB)
MP4
4 Fill Until Non-blank Values.mp4 (22.56 MB)
MP4
5 Translating Logic into Excel Formulas with ChatGPT.mp4 (11.78 MB)
MP4
1 Correcting Inverted Names.mp4 (15.57 MB)
MP4
2 Dealing with Trailing and Leading Spaces in Text Data.mp4 (17.89 MB)
MP4
3 Standardizing Letter Capitalization.mp4 (15.7 MB)
MP4
4 Handling Multi-lingual Text Data.mp4 (35.89 MB)
MP4
5 Multiple Find and Replace at the Same Time with ChatGPT.mp4 (23.96 MB)
MP4
6 Criteria-based Duplicate Removal.mp4 (14.44 MB)
MP4
7 Removing Duplicates Across Multiple Columns.mp4 (14.62 MB)
MP4
1 Obtain Day and Month From Date.mp4 (27.54 MB)
MP4
2 Converting Hours to Decimals.mp4 (9.87 MB)
MP4
3 Obtaining Age in Years, Months, Days.mp4 (9.14 MB)
MP4
4 Order Dates Chronologically.mp4 (12.52 MB)
MP4
1 Intro to the Exercise and Preprocessing Ideas from ChatGPT.mp4 (39.78 MB)
MP4
2 Preprocessing the 'Free plan users' Sheet (12).mp4 (64.71 MB)
MP4
3 Preprocessing the 'Free plan users' Sheet (22).mp4 (35.66 MB)
MP4
4 Working on the 'Transactions' Sheet.mp4 (78.82 MB)
MP4
5 Dealing with the Country Mapping Issue.mp4 (23.26 MB)
MP4
1 Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp4 (30.45 MB)
MP4
10 Practical Learning - Exercise 1.mp4 (27.48 MB)
MP4
11 Changing an Object's Size and Rotation.mp4 (11.24 MB)
MP4
12 Using Slide Masters.mp4 (22.45 MB)
MP4
13 Bring to Front and Send to Back - An Important PowerPoint Technique.mp4 (15.3 MB)
MP4
14 Learn How to Create, Edit, Resize and Format PowerPoint Tables.mp4 (27.64 MB)
MP4
2 The Structure of the PowerPoint Ribbon.mp4 (27.68 MB)
MP4
3 General Considerations About Slide Structure.mp4 (26.37 MB)
MP4
4 Learn How to Insert Objects in PowerPoint.mp4 (31.97 MB)
MP4
5 Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp4 (16.65 MB)
MP4
6 Add Frequently Used Buttons to the Quick Access Toolbar.mp4 (21.36 MB)
MP4
7 How to Easily Align Objects in PowerPoint.mp4 (20.49 MB)
MP4
8 How to Edit Shapes in Your Presentation.mp4 (26.32 MB)
MP4
9 How to Format Text Boxes in a PowerPoint Presentation.mp4 (19.91 MB)
MP4
1 An Introduction to PowerPoint Animations.mp4 (14.57 MB)
MP4
10 Practical Exercise - Creating an Organisational Chart.mp4 (52.83 MB)
MP4
11 COURSE CHALLENGE - Part 4.mp4 (41.79 MB)
MP4
2 Modifying the Beginning and Ending of a Line Object.mp4 (10.17 MB)
MP4
3 Join Shapes Together By Using Connector Lines.mp4 (23.83 MB)
MP4
4 Edit Points - Learn How to Customize PowerPoint Shapes.mp4 (8.28 MB)
MP4
5 Group or Ungroup Shapes, Pictures or Other Objects.mp4 (14.66 MB)
MP4
6 This is How You Can Fit Text When It Is Larger Than a Shape.mp4 (13.79 MB)
MP4
7 Nudge Objects.mp4 (4.38 MB)
MP4
8 PowerPoint's Smart Art Feature Offers Great Return for Your Time.mp4 (20.97 MB)
MP4
9 Creating Eye-Catching Text Effects in PowerPoint.mp4 (12.49 MB)
MP4
1 Who Does What in the World of Finance.mp4 (649.34 MB)
MP4
1 Discounting Cash Flows in Microsoft Excel.mp4 (39.56 MB)
MP4
2 Calculating Internal Rate of Return (IRR) in Excel.mp4 (19.85 MB)
MP4
3 Using the PMT Function to Create a Complete Loan Schedule.mp4 (35.28 MB)
MP4
4 Date Functions in Excel.mp4 (27.47 MB)
MP4
1 Introduction to the Case Study.mp4 (9.54 MB)
MP4
10 Using INDEX & MATCH as a Substitute for VLOOKUP.mp4 (47.1 MB)
MP4
11 XLOOKUP as a Substitute for VLOOKUP and INDEX&MATCH.mp4 (33.39 MB)
MP4
12 The Mapping Exercise.mp4 (20.3 MB)
MP4
13 Mapping the Rows in the Database Sheet.mp4 (36.27 MB)
MP4
14 Building the Structure of the P&L Sheet.mp4 (17.96 MB)
MP4
15 A Practical Example of Professional Formatting in Excel.mp4 (23.17 MB)
MP4
16 Populating the P&L Sheet with SUMIF.mp4 (29.18 MB)
MP4
17 Learn How to Find Mistakes with COUNTIF.mp4 (27.58 MB)
MP4
18 Calculating Growth Rates in Excel.mp4 (28.3 MB)
MP4
2 What You Will See Next.mp4 (9.73 MB)
MP4
3 Understand Your Data Source Before You Start Working on It.mp4 (25.5 MB)
MP4
4 Ordering the Source Worksheet.mp4 (24.75 MB)
MP4
5 Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.mp4 (22.92 MB)
MP4
6 Learn How to Create a Database.mp4 (18.8 MB)
MP4
7 Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.mp4 (56.93 MB)
MP4
8 Using SUMIF to Complete the Database Sheet.mp4 (44.77 MB)
MP4
1 Practical Exercise - SUMIFS.mp4 (68.93 MB)
MP4
1 Introduction to Excel Charts.mp4 (19.92 MB)
MP4
2 Beginner's Guide to Inserting Charts in Excel.mp4 (36.21 MB)
MP4
3 Modifying Excel Charts - The Easy Way.mp4 (42.11 MB)
MP4
4 Making Your Excel Charts Sexier - Proven Tips.mp4 (53.34 MB)
MP4
5 Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp4 (21.42 MB)
MP4
6 New Ways to Visualize Your Data - Treemap Charts.mp4 (18.33 MB)
MP4
7 How to Represent Trends with Sparklines.mp4 (42.94 MB)
MP4
MP4
2 Everything We Will Learn Has a Practical Application.mp4 (41.78 MB)
MP4
3 The Best Way to Take This Course.mp4 (31.14 MB)
MP4
1 Introduction.mp4 (5.93 MB)
MP4
2 Stacked Column Chart with a Secondary Axis.mp4 (41.26 MB)
MP4
3 Doughnut Chart.mp4 (34.48 MB)
MP4
4 Area Chart.mp4 (25.38 MB)
MP4
5 Bridge Chart.mp4 (46.57 MB)
MP4
1 Pivot Tables - Excel's Dynamic and Interactive Tables.mp4 (22.56 MB)
MP4
2 Creating a Pivot Table Choosing Row and Column Parameters.mp4 (29.41 MB)
MP4
3 Design the Layout and Format of Your Pivot Tables.mp4 (15.56 MB)
MP4
4 Additional Techniques That Will Ease Your Work with Pivot Tables.mp4 (35.86 MB)
MP4
5 One of the Most Useful Excel Functions - GETPIVOTDATA.mp4 (27.42 MB)
MP4
6 Welcome to the Future - Pivot Table Slicers.mp4 (36.19 MB)
MP4
7 Introduction to the Course Challenge.mp4 (12.29 MB)
MP4
8 COURSE CHALLENGE - Part 1.mp4 (23.25 MB)
MP4
1 Introduction to the Case Study.mp4 (41.32 MB)
MP4
11 Combining Slicers and GETPIVOTDATA The Key to Our Success.mp4 (33.61 MB)
MP4
12 Getting Fancy with Excel Slicers.mp4 (32.41 MB)
MP4
13 This is How the Report Can be Used in Practice by High-level Executives.mp4 (36.18 MB)
MP4
2 Working with an SAP Data Extraction.mp4 (36.99 MB)
MP4
3 Preliminary Mapping of the Data Extraction.mp4 (30.22 MB)
MP4
4 Creating an Output Structure of the FMCG Model.mp4 (19.71 MB)
MP4
5 Improving the Layout and Appearance of the FMCG Report.mp4 (23.89 MB)
MP4
6 Inserting Formulas and Automating Calculations.mp4 (16.15 MB)
MP4
7 Creating a Master Pivot Table The Main Data Source for the FMCG Report.mp4 (20.14 MB)
MP4
8 GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.mp4 (49.95 MB)
MP4
9 GETPIVOTDATA Fix.mp4 (11.92 MB)
MP4
1 Introduction to the Exercise.mp4 (32.77 MB)
MP4
2 Let's Create a Mapping of Financials.mp4 (27.18 MB)
MP4
3 Building an Output P&L Sheet.mp4 (26.76 MB)
MP4
4 Filling in the Output P&L Sheet with Historical Financials.mp4 (20.62 MB)
MP4
5 Calculating Percentage Variances and Applying Conditional Formatting.mp4 (23.89 MB)
MP4
6 Building an Output Balance Sheet.mp4 (26.23 MB)
MP4
7 Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet.mp4 (37.71 MB)
MP4
8 Adding the Forecast Period.mp4 (27.98 MB)
MP4
1 Calculating Historical Percentage Ratios and Use OFFSET and MATCH for Scenarios.mp4 (43.92 MB)
MP4
2 Building a Flexible Model with CHOOSE & MATCH.mp4 (13.93 MB)
MP4
3 Building a Flexible Model with VLOOKUP & COLUMNS.mp4 (32.62 MB)
MP4
4 Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %.mp4 (39.43 MB)
MP4
5 Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities.mp4 (26.98 MB)
MP4
1 Building a Fixed Asset Roll Forward.mp4 (36.37 MB)
MP4
2 Building a Financial Liabilities Schedule.mp4 (41.85 MB)
MP4
3 Building an Equity Schedule.mp4 (32.88 MB)
MP4
4 Preparing a Cash Flow Structure.mp4 (12.54 MB)
MP4
5 Calculating Cash Flows and Completing the Model.mp4 (51.03 MB)
MP4
1 Accounting The Science Behind Financial Figures.mp4 (54.02 MB)
MP4
2 What is Accounting and Why Do You Need It.mp4 (45.8 MB)
MP4
3 The Importance of Bookkeeping - Good Accounting Records Are Essential.mp4 (29.14 MB)
MP4
4 An Introduction to Financial Accounting.mp4 (22.26 MB)
MP4
1 The Different Types of Accounting Standards.mp4 (23.01 MB)
MP4
10 Asset Categories - Practical Example.mp4 (30.53 MB)
MP4
11 Liability Categories - Practical Example.mp4 (29.72 MB)
MP4
12 Equity.mp4 (15.05 MB)
MP4
13 Equity Categories - Practical Example.mp4 (39.97 MB)
MP4
2 The Three Financial Statements.mp4 (19.14 MB)
MP4
3 Types of Revenues.mp4 (52.18 MB)
MP4
4 Types of Revenues - Exercise.mp4 (15.7 MB)
MP4
5 Types of Expenses.mp4 (43.29 MB)
MP4
6 Income Taxes.mp4 (15.43 MB)
MP4
7 Depreciation & Amortization.mp4 (37.45 MB)
MP4
8 The Two Types of Income Statement Formats.mp4 (10.83 MB)
MP4
9 Balance Sheet Items.mp4 (35.35 MB)
MP4
1 Accrual Accounting.mp4 (59.39 MB)
MP4
2 Revenue Recognition Criteria - Technical.mp4 (39.73 MB)
MP4
3 Potential Conflicts of Interest When Recognizing Revenue.mp4 (16.31 MB)
MP4
4 A Practical Example.mp4 (50.23 MB)
MP4
1 Cost recognition principles.mp4 (22.65 MB)
MP4
2 Technical Aspects of Cost Recognition.mp4 (23.19 MB)
MP4
1 Microsoft Excel The World's #1 Office Software.mp4 (36.31 MB)
MP4
10 A Beginner's Introduction to Excel Functions.mp4 (18.32 MB)
MP4
11 Format Cells.mp4 (30.97 MB)
MP4
12 Work Efficiently by Using Cut, Copy, and Paste.mp4 (12.5 MB)
MP4
14 Pasting Values, Formulas and Formats with Paste Special.mp4 (9.71 MB)
MP4
2 Excel Made Easy A Beginner's Guide to Excel Spreadsheets.mp4 (17.54 MB)
MP4
3 Data Entry Techniques in Excel.mp4 (26.76 MB)
MP4
4 How to Make Your Spreadsheets Look Professional.mp4 (35.9 MB)
MP4
6 Inserting, Deleting, and Modifying Rows & Columns.mp4 (9.45 MB)
MP4
8 Excel Formulas for Beginners.mp4 (12.11 MB)
MP4
1 The Revenue Recognition Principle - Why Is It So Important.mp4 (23.21 MB)
MP4
2 The Expense Recognition Principle - When to Recognize Expenses.mp4 (22.64 MB)
MP4
3 Historical Cost vs Fair Value Accounting.mp4 (20.37 MB)
MP4
1 The Accounting Equation and Its Importance.mp4 (15.03 MB)
MP4
2 Elements of the Accounting System General Ledger.mp4 (14.53 MB)
MP4
3 T-Accounts The Best Way to Understand Debits and Credits.mp4 (29.43 MB)
MP4
4 P&L T-Accounts.mp4 (21.72 MB)
MP4
5 The Double-Entry Principle - The Core Principle of Bookkeeping.mp4 (40.56 MB)
MP4
1 Case Study - The Accounting Transactions of a Lemonade Stand (14).mp4 (70.73 MB)
MP4
2 Case Study - The Accounting Transactions of a Lemonade Stand (24).mp4 (43.96 MB)
MP4
3 Case Study - The Accounting Transactions of a Lemonade Stand (34).mp4 (46.88 MB)
MP4
4 Case Study - The Accounting Transactions of a Lemonade Stand (44).mp4 (51.97 MB)
MP4
1 Timing of Cash Flows and Why It Plays an Important Role in a Business.mp4 (9.71 MB)
MP4
2 Timing of Income Principles of Revenue Recognition.mp4 (44.6 MB)
MP4
3 Timing of Expenses Principles of Cost Recognition.mp4 (23.21 MB)
MP4
1 Calculating Cash Flows - Understand If a Business Makes or Burns Cash.mp4 (23.8 MB)
MP4
2 The Three Parts of Cash Flow Statements Explained.mp4 (23.32 MB)
MP4
3 Cash Flow Computations - The Direct Method.mp4 (18.48 MB)
MP4
4 Cash Flow Computations - The Indirect Method.mp4 (25.81 MB)
MP4
5 Calculating Cash Flow in Practice A Complete Example.mp4 (52.51 MB)
MP4
1 Why a Company Needs to Pay Attention to Trade Receivables.mp4 (23.3 MB)
MP4
2 What If Clients Do Not Pay on Time.mp4 (24.36 MB)
MP4
3 How to Handle Non-paying Customers A Case-study.mp4 (22.8 MB)
MP4
4 A Technique to Collect Trade Receivables Sooner.mp4 (13.8 MB)
MP4
1 The Different Types of Inventory We Can Have.mp4 (23.95 MB)
MP4
2 The Connection Between Cost of Goods Sold and Inventory.mp4 (14.5 MB)
MP4
3 Cost Flow Methods.mp4 (24.3 MB)
MP4
4 Cost Flow Methods - a Practical Exercise.mp4 (6.46 MB)
MP4
1 The Different Types of Fixed Assets.mp4 (18.46 MB)
MP4
2 Capitalizing Interest Expenses.mp4 (7.05 MB)
MP4
3 Fair Value Accounting.mp4 (41.18 MB)
MP4
4 Intangible Assets with Finite Life vs Intangible Assets with Infinite Life.mp4 (32.23 MB)
MP4
5 The Revaluation Model.mp4 (35.15 MB)
MP4
6 The Revaluation Model - Practical Exercise.mp4 (34.09 MB)
MP4
7 Intangible Assets Created Internally.mp4 (16.26 MB)
MP4
1 How We Account for Trade Payables.mp4 (19.9 MB)
MP4
2 What Is the Difference Between Accounts Payable and Notes Payable.mp4 (9.6 MB)
MP4
3 Why Use E-invoicing.mp4 (22.71 MB)
MP4
1 The Difference Between Debt and Equity.mp4 (13.13 MB)
MP4
2 Amortizing a Loan.mp4 (18.18 MB)
MP4
3 Debt Covenants.mp4 (23.27 MB)
MP4
4 Debt Covenants - A Practical Example.mp4 (12.24 MB)
MP4
1 Inserting a Line Break with Alt + Enter.mp4 (9.87 MB)
MP4
2 Do More with Your Sales Data with Excel's Text to Columns Feature.mp4 (11.74 MB)
MP4
4 Create Easily Printable Excel Documents.mp4 (8.37 MB)
MP4
5 How to Wrap Text in Excel and Adjust a Cell's Size.mp4 (3.16 MB)
MP4
6 Insert Hyperlinks into Excel Spreadsheets.mp4 (7.2 MB)
MP4
7 Using Excel's Freeze Panes to Handle Large Datasets.mp4 (14.5 MB)
MP4
8 Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp4 (15.06 MB)
MP4
9 A Quick Introduction to Excel's Pivot Tables.mp4 (40.1 MB)
MP4
1 The Reason Companies Lease Assets.mp4 (10.05 MB)
MP4
2 Solving a Complete Leasing Exercise.mp4 (40.12 MB)
MP4
1 What is Leverage and Why Companies Use Financial Leverage.mp4 (53.54 MB)
MP4
2 The Implications of Using Excessive Leverage.mp4 (32.13 MB)
MP4
1 The Different Types of Equity.mp4 (53.43 MB)
MP4
2 Raising Equity in Different Stages of a Company's Lifecycle.mp4 (67.96 MB)
MP4
3 The Types of Dividends Companies Pay to Shareholders.mp4 (42.3 MB)
MP4
4 Dividend Payments - a Timeline.mp4 (33.52 MB)
MP4
5 What Are Share Repurchases and Why Companies Do Them.mp4 (42.42 MB)
MP4
6 The Idea Behind Stock Splits.mp4 (34.26 MB)
MP4
1 What is a 10-K Report and Why Is It important for Investors.mp4 (21.79 MB)
MP4
2 Finding, Downloading and Going Through the Annual Report of P&G.mp4 (77.51 MB)
MP4
3 What Is the Role of Auditing Firms and What Are the Benefits of an Audit.mp4 (26.34 MB)
MP4
4 Indispensable Tools for Financial Statement Analysis.mp4 (14.27 MB)
MP4
1 Financial Statement Analysis - A Natural Continuation of Financial Accounting.mp4 (16.83 MB)
MP4
2 First Steps in Financial Statement Analysis.mp4 (25.61 MB)
MP4
3 Horizontal vs Vertical Financial Statement Analysis.mp4 (27.28 MB)
MP4
4 Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO).mp4 (18 MB)
MP4
5 Using Accounting Ratios to Assess Business Performance.mp4 (62.28 MB)
MP4
1 Case Study - Calculating Ratios and Analyzing P&G's Financials (12).mp4 (55.6 MB)
MP4
2 Case Study - Calculating Ratios and Analyzing P&G's Financials (22).mp4 (32.47 MB)
MP4
3 COURSE CHALLENGE - Part 2.mp4 (30.59 MB)
MP4
1 What You Will See Next In This Section.mp4 (17.64 MB)
MP4
2 How to Download Tesla's Historical Financials.mp4 (16.65 MB)
MP4
3 Calculating and Analyzing Growth and Profitability Ratios.mp4 (106.55 MB)
MP4
4 Calculating and Analyzing Liquidity Ratios.mp4 (71.62 MB)
MP4
5 Calculating and Analyzing Solvency Ratios.mp4 (24.5 MB)
MP4
1 Introduction.mp4 (22.25 MB)
MP4
10 Symptoms of Inefficient Working Capital - Trade Payables.mp4 (15.84 MB)
MP4
11 Symptoms of Inefficient Working Capital - Trade Receivables.mp4 (13.8 MB)
MP4
2 The Importance of Working Capital Optimization Case Study.mp4 (80.7 MB)
MP4
3 Overtrading vs Excessive Investment.mp4 (30.14 MB)
MP4
4 Trade Receivables Management.mp4 (68.72 MB)
MP4
5 Re-order Level.mp4 (28.37 MB)
MP4
6 Economic Order Quantity (EOQ).mp4 (28.16 MB)
MP4
7 Inventory Optimization Techniques.mp4 (45.16 MB)
MP4
8 Trade Payables Management.mp4 (17.35 MB)
MP4
9 Working Capital Optimization - a Roadmap.mp4 (43.46 MB)
MP4
1 Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4 (21.23 MB)
MP4
11 Find and Select Cells That Meet Specific Conditions.mp4 (11.9 MB)
MP4
13 How to Create Dynamic Names in Excel Spreadsheets.mp4 (14.02 MB)
MP4
15 Using Named Ranges to Make Formulas More Readable.mp4 (7.65 MB)
MP4
16 Introduction to Custom Formatting in Excel.mp4 (40.94 MB)
MP4
17 Custom Number Formatting.mp4 (8.27 MB)
MP4
18 How to Add a Drop-down List in Excel.mp4 (13.99 MB)
MP4
19 Using Custom-sort to Sort Multiple Columns Within a Table.mp4 (21.95 MB)
MP4
2 Macros Are a Great Timesaver! Here's Why.mp4 (33.56 MB)
MP4
20 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4 (41.91 MB)
MP4
21 Multiply by 1.mp4 (13.73 MB)
MP4
22 Find and Replace - References.mp4 (21.94 MB)
MP4
24 Find and Replace - Formatting.mp4 (12.55 MB)
MP4
25 Green References.mp4 (11.5 MB)
MP4
26 Beauty Saving - The Professional Way of Saving Files.mp4 (12.95 MB)
MP4
27 The Power of F2.mp4 (16.72 MB)
MP4
28 Conditional Formatting.mp4 (52.02 MB)
MP4
3 How to Use the Same Macro On Multiple Workbooks.mp4 (10.68 MB)
MP4
5 The Secret to Faster Scrolling in Excel.mp4 (19.52 MB)
MP4
6 Be even quicker F5 + Enter.mp4 (19.12 MB)
MP4
9 Using Absolute and Relative Cell References.mp4 (43.47 MB)
MP4
10 Time series analysis.mp4 (67.28 MB)
MP4
12 Regression analysis.mp4 (42.82 MB)
MP4
2 Trend analysis.mp4 (70.31 MB)
MP4
4 Comparative analysis.mp4 (32.34 MB)
MP4
6 Value-based analysis.mp4 (37.53 MB)
MP4
8 Correlation analysis.mp4 (36.31 MB)
MP4
1 Finance 101 Important Financial Principles That You Will Need.mp4 (26.57 MB)
MP4
2 Understanding the Time Value of Money.mp4 (9.65 MB)
MP4
3 How Interest Rates Play an Important Role in the Economy.mp4 (21.54 MB)
MP4
4 The Components Forming Interest Rates in Real Life.mp4 (25.99 MB)
MP4
5 What Is Libor and What Purpose Does It Serve.mp4 (27.66 MB)
MP4
6 The Difference Between Fixed and Variable Interest Rates.mp4 (26.42 MB)
MP4
7 What Is Default Risk and How Does a Bank Account For It.mp4 (47.78 MB)
MP4
8 Corporate Loan Specifics.mp4 (40.85 MB)
MP4
1 Calculating the Present Value of Future Cash Flows.mp4 (46.83 MB)
MP4
2 A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.mp4 (45.9 MB)
MP4
1 Using Annuities.mp4 (22.22 MB)
MP4
2 Calculating a Complete Loan Schedule.mp4 (44.72 MB)
MP4
3 COURSE CHALLENGE - Part 3.mp4 (22.43 MB)
MP4
1 What is Capital Budgeting.mp4 (12.32 MB)
MP4
2 When Do We Use Capital Budgeting.mp4 (19.21 MB)
MP4
3 The Time Value of Money in a Capital Budgeting Setting.mp4 (16.9 MB)
MP4
4 Calculating Present and Future Value.mp4 (31.56 MB)
MP4
5 Cost of Equity.mp4 (51.47 MB)
MP4
6 Project-specific Beta.mp4 (24.78 MB)
MP4
7 The Weighted Average Cost of Capital (WACC).mp4 (14.01 MB)
MP4
8 The Different Cash Flow Types in a Capital Budgeting Exercise.mp4 (21.84 MB)
MP4
9 Modeling Future Cash Flows.mp4 (50.47 MB)
MP4
1 An Introduction to the Case Study.mp4 (22.35 MB)
MP4
10 Estimating Cost of Equity.mp4 (36.02 MB)
MP4
11 Discounting Project Cash Flows.mp4 (24.01 MB)
MP4
12 Performing Sensitivity Analysis and Wrapping Up the Case Study.mp4 (41.98 MB)
MP4
2 Organizing Inputs In the Drivers Sheet.mp4 (31.99 MB)
MP4
3 Modeling Expected Savings - Building Cars In Italy vs Building Cars In Vietnam.mp4 (32.08 MB)
MP4
4 Preparing a Fixed Asset Rollforward Schedule.mp4 (44.52 MB)
MP4
5 Calculating the Cash Impact of Extra Working Capital Required.mp4 (16.31 MB)
MP4
6 Debt Repayment and Interest Expenses Calculation.mp4 (19.95 MB)
MP4
7 The Project's P&L Sheet.mp4 (12.9 MB)
MP4
8 The Project's Cash Flow Calculation.mp4 (29.05 MB)
MP4
9 Calculating WACC (Weighted Average Cost of Capital).mp4 (16.33 MB)
MP4
1 Organizing External Inputs in a 'Drivers' Sheet.mp4 (35.09 MB)
MP4
10 Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales.mp4 (23.85 MB)
MP4
11 Forecasting Operating Expenses.mp4 (27.45 MB)
MP4
12 Building a Fixed Asset Roll Forward PP&E.mp4 (32.74 MB)
MP4
13 Building a Fixed Asset Roll Forward Estimating Capex.mp4 (39.3 MB)
MP4
14 Building a Fixed Asset Roll Forward D&A Schedule.mp4 (34.02 MB)
MP4
15 Calculating DSO, DIO, DPO.mp4 (16.67 MB)
MP4
16 Producing a Clean P&L Output Sheet.mp4 (14.47 MB)
MP4
17 Calculating Investments in Working Capital.mp4 (18.69 MB)
MP4
18 Forecasting Unlevered Free Cash Flow.mp4 (31.22 MB)
MP4
19 Forecasting Other Assets.mp4 (44.47 MB)
MP4
2 Forecasting Tesla's Expected Deliveries.mp4 (103.4 MB)
MP4
20 Forecasting Other Liabilities.mp4 (20.11 MB)
MP4
21 Completing Unlevered Free Cash Flow.mp4 (66.81 MB)
MP4
22 Modeling Tesla's Financing Needs in the Forecast Period.mp4 (38.83 MB)
MP4
23 Calculating Net Income.mp4 (13.81 MB)
MP4
24 Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4 (40.56 MB)
MP4
25 Balancing the Balance Sheet.mp4 (11.92 MB)
MP4
3 Comparing Delivery Figures with the Ones of industry Peers.mp4 (19.77 MB)
MP4
4 Estimating an Average Selling Price of Tesla Vehicles.mp4 (45.99 MB)
MP4
5 Calculating Automotive Revenue.mp4 (40.52 MB)
MP4
6 Peer Comparison Gross Profit %.mp4 (35.72 MB)
MP4
7 Calculating Automotive Gross Profit.mp4 (22.27 MB)
MP4
8 Calculating Automotive Cost of Sales.mp4 (12.71 MB)
MP4
9 Forecasting 'Energy' and 'Services' Revenue.mp4 (19.1 MB)
MP4
1 How ChatGPT Advanced Data Analysis Will Boost Your Productivity.mp4 (28.52 MB)
MP4
2 The Limitations of ChatGPT Advanced Data Analysis.mp4 (47.93 MB)
MP4
1 Exploratory Data Analysis - Intro.mp4 (57.15 MB)
MP4
2 Extracting Descriptive Statistics with ChatGPT.mp4 (19.32 MB)
MP4
3 Identifying Outliers.mp4 (18.07 MB)
MP4
4 Correlation Analysis Hypothesis Formulation and Feature Ideas.mp4 (19.23 MB)
MP4
5 Crafting a Comprehensive EDA Prompt.mp4 (93.11 MB)
MP4
1 Identifying and Handling Erroneous Data.mp4 (33.28 MB)
MP4
2 Verifying Data for Errors.mp4 (36.79 MB)
MP4
3 Eliminating Duplicate Rows.mp4 (12.4 MB)
MP4
4 Addressing Unit Discrepancies in Data.mp4 (19.01 MB)
MP4
5 Dividing Cell Content into Multiple Cells.mp4 (46.27 MB)
MP4
1 Key Excel Functions IF.mp4 (14.91 MB)
MP4
10 Working with Text in Excel.mp4 (13.37 MB)
MP4
11 Find the Highest and Lowest Values in a Range Max & Min.mp4 (12.39 MB)
MP4
12 = and + are Interchangeable When You Start Typing a Formula.mp4 (5.03 MB)
MP4
13 Use ROUND in Your Financial Models.mp4 (8.48 MB)
MP4
14 Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.mp4 (52.57 MB)
MP4
15 INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.mp4 (99.54 MB)
MP4
17 XLOOKUP a Solid Substitute of VLOOKUP (Office 365 only).mp4 (40.27 MB)
MP4
18 Using Excel's IFERROR Function to Trap Spreadsheet Errors.mp4 (19.2 MB)
MP4
19 A Useful Tool for Financial Analysis - The RANK Function.mp4 (20.14 MB)
MP4
2 Enlarge the Formula Bar.mp4 (5.71 MB)
MP4
20 Create Flexible Financial Models with CHOOSE.mp4 (32 MB)
MP4
21 Goal Seek Will Help You Find the Result You Are Looking For.mp4 (25.39 MB)
MP4
23 Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp4 (41.74 MB)
MP4
3 Key Excel Functions SUM, SUMIF, SUMIFS.mp4 (27.42 MB)
MP4
5 Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4 (49.87 MB)
MP4
6 Key Excel Functions AVERAGE & AVERAGEIF.mp4 (24.15 MB)
MP4
8 Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.mp4 (48.96 MB)
MP4
1 Organize Messy Data.mp4 (50.64 MB)
MP4
2 Data Mapping.mp4 (23.04 MB)
MP4
3 Effective Data Classification.mp4 (14.18 MB)
MP4
4 Order Data with ChatGPT.mp4 (18.11 MB)
MP4
1 COUNTIFS, SUMIFS.mp4 (24.75 MB)
MP4
2 Data Lookup.mp4 (26.32 MB)
MP4
3 Data Ranking.mp4 (24.5 MB)
MP4
4 Fill Until Non-blank Values.mp4 (22.56 MB)
MP4
5 Translating Logic into Excel Formulas with ChatGPT.mp4 (11.78 MB)
MP4
1 Correcting Inverted Names.mp4 (15.57 MB)
MP4
2 Dealing with Trailing and Leading Spaces in Text Data.mp4 (17.89 MB)
MP4
3 Standardizing Letter Capitalization.mp4 (15.7 MB)
MP4
4 Handling Multi-lingual Text Data.mp4 (35.89 MB)
MP4
5 Multiple Find and Replace at the Same Time with ChatGPT.mp4 (23.96 MB)
MP4
6 Criteria-based Duplicate Removal.mp4 (14.44 MB)
MP4
7 Removing Duplicates Across Multiple Columns.mp4 (14.62 MB)
MP4
1 Obtain Day and Month From Date.mp4 (27.54 MB)
MP4
2 Converting Hours to Decimals.mp4 (9.87 MB)
MP4
3 Obtaining Age in Years, Months, Days.mp4 (9.14 MB)
MP4
4 Order Dates Chronologically.mp4 (12.52 MB)
MP4
1 Intro to the Exercise and Preprocessing Ideas from ChatGPT.mp4 (39.78 MB)
MP4
2 Preprocessing the 'Free plan users' Sheet (12).mp4 (64.71 MB)
MP4
3 Preprocessing the 'Free plan users' Sheet (22).mp4 (35.66 MB)
MP4
4 Working on the 'Transactions' Sheet.mp4 (78.82 MB)
MP4
5 Dealing with the Country Mapping Issue.mp4 (23.26 MB)
MP4
1 Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp4 (30.45 MB)
MP4
10 Practical Learning - Exercise 1.mp4 (27.48 MB)
MP4
11 Changing an Object's Size and Rotation.mp4 (11.24 MB)
MP4
12 Using Slide Masters.mp4 (22.45 MB)
MP4
13 Bring to Front and Send to Back - An Important PowerPoint Technique.mp4 (15.3 MB)
MP4
14 Learn How to Create, Edit, Resize and Format PowerPoint Tables.mp4 (27.64 MB)
MP4
2 The Structure of the PowerPoint Ribbon.mp4 (27.68 MB)
MP4
3 General Considerations About Slide Structure.mp4 (26.37 MB)
MP4
4 Learn How to Insert Objects in PowerPoint.mp4 (31.97 MB)
MP4
5 Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp4 (16.65 MB)
MP4
6 Add Frequently Used Buttons to the Quick Access Toolbar.mp4 (21.36 MB)
MP4
7 How to Easily Align Objects in PowerPoint.mp4 (20.49 MB)
MP4
8 How to Edit Shapes in Your Presentation.mp4 (26.32 MB)
MP4
9 How to Format Text Boxes in a PowerPoint Presentation.mp4 (19.91 MB)
MP4
1 An Introduction to PowerPoint Animations.mp4 (14.57 MB)
MP4
10 Practical Exercise - Creating an Organisational Chart.mp4 (52.83 MB)
MP4
11 COURSE CHALLENGE - Part 4.mp4 (41.79 MB)
MP4
2 Modifying the Beginning and Ending of a Line Object.mp4 (10.17 MB)
MP4
3 Join Shapes Together By Using Connector Lines.mp4 (23.83 MB)
MP4
4 Edit Points - Learn How to Customize PowerPoint Shapes.mp4 (8.28 MB)
MP4
5 Group or Ungroup Shapes, Pictures or Other Objects.mp4 (14.66 MB)
MP4
6 This is How You Can Fit Text When It Is Larger Than a Shape.mp4 (13.79 MB)
MP4
7 Nudge Objects.mp4 (4.38 MB)
MP4
8 PowerPoint's Smart Art Feature Offers Great Return for Your Time.mp4 (20.97 MB)
MP4
9 Creating Eye-Catching Text Effects in PowerPoint.mp4 (12.49 MB)
MP4
1 Who Does What in the World of Finance.mp4 (649.34 MB)
MP4
1 Discounting Cash Flows in Microsoft Excel.mp4 (39.56 MB)
MP4
2 Calculating Internal Rate of Return (IRR) in Excel.mp4 (19.85 MB)
MP4
3 Using the PMT Function to Create a Complete Loan Schedule.mp4 (35.28 MB)
MP4
4 Date Functions in Excel.mp4 (27.47 MB)
MP4
1 Introduction to the Case Study.mp4 (9.54 MB)
MP4
10 Using INDEX & MATCH as a Substitute for VLOOKUP.mp4 (47.1 MB)
MP4
11 XLOOKUP as a Substitute for VLOOKUP and INDEX&MATCH.mp4 (33.39 MB)
MP4
12 The Mapping Exercise.mp4 (20.3 MB)
MP4
13 Mapping the Rows in the Database Sheet.mp4 (36.27 MB)
MP4
14 Building the Structure of the P&L Sheet.mp4 (17.96 MB)
MP4
15 A Practical Example of Professional Formatting in Excel.mp4 (23.17 MB)
MP4
16 Populating the P&L Sheet with SUMIF.mp4 (29.18 MB)
MP4
17 Learn How to Find Mistakes with COUNTIF.mp4 (27.58 MB)
MP4
18 Calculating Growth Rates in Excel.mp4 (28.3 MB)
MP4
2 What You Will See Next.mp4 (9.73 MB)
MP4
3 Understand Your Data Source Before You Start Working on It.mp4 (25.5 MB)
MP4
4 Ordering the Source Worksheet.mp4 (24.75 MB)
MP4
5 Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.mp4 (22.92 MB)
MP4
6 Learn How to Create a Database.mp4 (18.8 MB)
MP4
7 Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.mp4 (56.93 MB)
MP4
8 Using SUMIF to Complete the Database Sheet.mp4 (44.77 MB)
MP4
1 Practical Exercise - SUMIFS.mp4 (68.93 MB)
MP4
1 Introduction to Excel Charts.mp4 (19.92 MB)
MP4
2 Beginner's Guide to Inserting Charts in Excel.mp4 (36.21 MB)
MP4
3 Modifying Excel Charts - The Easy Way.mp4 (42.11 MB)
MP4
4 Making Your Excel Charts Sexier - Proven Tips.mp4 (53.34 MB)
MP4
5 Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp4 (21.42 MB)
MP4
6 New Ways to Visualize Your Data - Treemap Charts.mp4 (18.33 MB)
MP4
7 How to Represent Trends with Sparklines.mp4 (42.94 MB)
MP4
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!