Урок 1.00:07:17
What Does the Course Cover?
Урок 2.00:03:28
Everything We Will Learn Has a Practical Application
Урок 3.00:03:12
The Best Way to Take This Course
Урок 4.00:01:01
Microsoft Excel: The World's #1 Office Software
Урок 5.00:03:33
Excel Made Easy: A Beginner's Guide to Excel Spreadsheets
Урок 6.00:03:01
Data Entry Techniques in Excel
Урок 7.00:05:50
How to Make Your Spreadsheets Look Professional
Урок 8.00:01:45
Inserting, Deleting, and Modifying Rows & Columns
Урок 9.00:02:55
Excel Formulas for Beginners
Урок 10.00:03:42
A Beginner's Introduction to Excel Functions
Урок 11.00:05:25
Format Cells
Урок 12.00:02:11
Work Efficiently by Using Cut, Copy, and Paste
Урок 13.00:01:17
Pasting Values, Formulas and Formats with Paste Special
Урок 14.00:00:55
Inserting a Line Break with Alt + Enter
Урок 15.00:01:53
Do More with Your Sales Data with Excel's Text to Columns Feature
Урок 16.00:01:13
Create Easily Printable Excel Documents
Урок 17.00:00:44
How to Wrap Text in Excel and Adjust a Cell's Size
Урок 18.00:01:17
Insert Hyperlinks into Excel Spreadsheets
Урок 19.00:01:13
Using Excel's Freeze Panes to Handle Large Datasets
Урок 20.00:00:47
Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do
Урок 21.00:02:18
A Quick Introduction to Excel's Pivot Tables
Урок 22.00:02:06
Initial Formatting Is Key for Creating Professional-looking Spreadsheets
Урок 23.00:03:05
Macros Are a Great Timesaver! Here's Why.
Урок 24.00:01:35
How to Use the Same Macro On Multiple Workbooks
Урок 25.00:01:37
The Secret to Faster Scrolling in Excel
Урок 26.00:01:52
Be even quicker: F5 + Enter
Урок 27.00:02:21
Using Absolute and Relative Cell References
Урок 28.00:01:31
Find and Select Cells That Meet Specific Conditions
Урок 29.00:01:28
How to Create Dynamic Names in Excel Spreadsheets
Урок 30.00:01:35
Using Named Ranges to Make Formulas More Readable
Урок 31.00:06:15
Introduction to Custom Formatting in Excel
Урок 32.00:01:35
Custom Number Formatting
Урок 33.00:01:50
How to Add a Drop-down List in Excel
Урок 34.00:01:29
Using Custom-sort to Sort Multiple Columns Within a Table
Урок 35.00:04:16
Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts
Урок 36.00:01:35
Multiply by 1
Урок 37.00:03:04
Find and Replace - References
Урок 38.00:01:54
Find and Replace - Formatting
Урок 39.00:01:32
Green References
Урок 40.00:02:14
Beauty Saving - The Professional Way of Saving Files
Урок 41.00:01:51
The Power of F2
Урок 42.00:05:41
Conditional Formatting
Урок 43.00:02:36
Key Excel Functions: IF
Урок 44.00:01:04
Enlarge the Formula Bar
Урок 45.00:04:21
Key Excel Functions: SUM, SUMIF, SUMIFS
Урок 46.00:04:07
Key Excel Functions: COUNT, COUNTA, COUNTIF, COUNTIFS
Урок 47.00:02:00
Key Excel Functions: AVERAGE & AVERAGEIF
Урок 48.00:04:30
Key Excel Functions: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &
Урок 49.00:02:41
Working with Text in Excel
Урок 50.00:00:53
Find the Highest and Lowest Values in a Range: Max & Min
Урок 51.00:00:45
= and + are Interchangeable When You Start Typing a Formula
Урок 52.00:01:02
Use ROUND in Your Financial Models
Урок 53.00:07:45
Excel's Lookup Functions: VLOOKUP & HLOOKUP Made Easy
Урок 54.00:07:28
INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP
Урок 55.00:01:44
Using Excel's IFERROR Function to Trap Spreadsheet Errors
Урок 56.00:02:37
A Useful Tool for Financial Analysis - The RANK Function
Урок 57.00:02:25
Create Flexible Financial Models with CHOOSE
Урок 58.00:02:18
Goal Seek Will Help You Find the Result You Are Looking For
Урок 59.00:04:11
Perform Sensitivity Analysis with Excel's Data Tables Functionality
Урок 60.00:07:03
Discounting Cash Flows in Microsoft Excel
Урок 61.00:03:31
Calculating Internal Rate of Return (IRR) in Excel
Урок 62.00:06:17
Using the PMT Function to Create a Complete Loan Schedule
Урок 63.00:05:39
Date Functions in Excel
Урок 64.00:00:52
Introduction to the Case Study
Урок 65.00:01:07
What You Will See Next
Урок 66.00:02:43
Understand Your Data Source Before You Start Working on It
Урок 67.00:02:17
Ordering the Source Worksheet
Урок 68.00:02:00
Creating a Code: The Best Way to Organize Your Data and Work Efficiently with It
Урок 69.00:01:59
Learn How to Create a Database
Урок 70.00:05:30
Using Lookup Functions (VLOOKUP) to Fill the Database Sheet
Урок 71.00:04:07
Using SUMIF to Complete the Database Sheet
Урок 72.00:03:52
Using INDEX & MATCH as a Substitute for VLOOKUP
Урок 73.00:01:42
The Mapping Exercise
Урок 74.00:06:16
Mapping the Rows in the Database Sheet
Урок 75.00:02:22
Building the Structure of the P&L Sheet
Урок 76.00:03:18
A Practical Example of Professional Formatting in Excel
Урок 77.00:02:48
Populating the P&L Sheet with SUMIF
Урок 78.00:02:15
Learn How to Find Mistakes with COUNTIF
Урок 79.00:03:09
Calculating Growth Rates in Excel
Урок 80.00:08:06
Practical Exercise - SUMIFS
Урок 81.00:01:12
Introduction to Excel Charts
Урок 82.00:02:11
Beginner's Guide to Inserting Charts in Excel
Урок 83.00:02:30
Modifying Excel Charts - The Easy Way
Урок 84.00:03:10
Making Your Excel Charts Sexier - Proven Tips
Урок 85.00:01:43
Creating a Bridge Chart in Excel 2016 - As Easy as It Gets
Урок 86.00:01:32
New Ways to Visualize Your Data - Treemap Charts
Урок 87.00:03:53
How to Represent Trends with Sparklines
Урок 88.00:00:30
Introduction
Урок 89.00:05:31
Stacked Column Chart with a Secondary Axis
Урок 90.00:04:59
Doughnut Chart
Урок 91.00:03:35
Area Chart
Урок 92.00:06:52
Bridge Chart
Урок 93.00:01:36
Pivot Tables - Excel's Dynamic and Interactive Tables
Урок 94.00:03:31
Creating a Pivot Table: Choosing Row and Column Parameters
Урок 95.00:01:58
Design the Layout and Format of Your Pivot Tables
Урок 96.00:04:17
Additional Techniques That Will Ease Your Work with Pivot Tables
Урок 97.00:03:29
One of the Most Useful Excel Functions - GETPIVOTDATA
Урок 98.00:04:04
Welcome to the Future - Pivot Table Slicers
Урок 99.00:01:05
Introduction to the Course Challenge
Урок 100.00:01:27
COURSE CHALLENGE - Part 1
Урок 101.00:02:10
Introduction to the Case Study
Урок 102.00:03:24
Working with an SAP Data Extraction
Урок 103.00:02:11
Preliminary Mapping of the Data Extraction
Урок 104.00:02:30
Creating an Output Structure of the FMCG Model
Урок 105.00:04:00
Improving the Layout and Appearance of the FMCG Report
Урок 106.00:02:31
Inserting Formulas and Automating Calculations
Урок 107.00:01:56
Creating a Master Pivot Table: The Main Data Source for the FMCG Report
Урок 108.00:05:46
GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table
Урок 109.00:01:17
GETPIVOTDATA Fix
Урок 110.00:03:21
Combining Slicers and GETPIVOTDATA: The Key to Our Success
Урок 111.00:03:13
Getting Fancy with Excel Slicers
Урок 112.00:04:00
This is How the Report Can be Used in Practice by High-level Executives
Урок 113.00:03:16
Introduction to the Exercise
Урок 114.00:02:50
Let's Create a Mapping of Financials
Урок 115.00:04:08
Building an Output P&L Sheet
Урок 116.00:02:58
Filling in the Output P&L Sheet with Historical Financials
Урок 117.00:03:15
Calculating Percentage Variances and Applying Conditional Formatting
Урок 118.00:03:55
Building an Output Balance Sheet
Урок 119.00:05:11
Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet
Урок 120.00:04:06
Adding the Forecast Period
Урок 121.00:05:07
Calculating Historical Percentage Ratios and Use OFFSET and MATCH for Scenarios
Урок 122.00:01:45
Building a Flexible Model with CHOOSE & MATCH
Урок 123.00:03:23
Building a Flexible Model with VLOOKUP & COLUMNS
Урок 124.00:05:09
Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %
Урок 125.00:03:17
Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities
Урок 126.00:05:18
Building a Fixed Asset Roll Forward
Урок 127.00:06:25
Building a Financial Liabilities Schedule
Урок 128.00:04:29
Building an Equity Schedule
Урок 129.00:02:17
Preparing a Cash Flow Structure
Урок 130.00:06:48
Calculating Cash Flows and Completing the Model
Урок 131.00:01:30
Accounting: The Science Behind Financial Figures
Урок 132.00:05:28
What is Accounting and Why Do You Need It
Урок 133.00:02:45
The Importance of Bookkeeping - Good Accounting Records Are Essential
Урок 134.00:02:35
An Introduction to Financial Accounting
Урок 135.00:02:45
The Different Types of Accounting Standards
Урок 136.00:01:55
The Three Financial Statements
Урок 137.00:02:35
Types of Revenues
Урок 138.00:01:52
Types of Revenues - Exercise
Урок 139.00:02:16
Types of Expenses
Урок 140.00:01:48
Income Taxes
Урок 141.00:05:20
Depreciation & Amortization
Урок 142.00:01:46
Balance Sheet Items
Урок 143.00:04:49
Types of Assets
Урок 144.00:04:37
Asset Categories - Practical Example
Урок 145.00:03:36
Types of Liabilities
Урок 146.00:03:48
Liability Categories - Practical Example
Урок 147.00:03:46
Equity
Урок 148.00:02:31
Accrual Accounting
Урок 149.00:01:33
Revenue Recognition Criteria - Technical
Урок 150.00:03:41
Potential Conflicts of Interest When Recognizing Revenue
Урок 151.00:01:57
A Practical Example
Урок 152.00:05:19
Technical Aspects of Cost Recognition
Урок 153.00:02:35
The Two Types of Income Statement Formats
Урок 154.00:01:18
The Revenue Recognition Principle - Why Is It So Important?
Урок 155.00:02:29
The Expense Recognition Principle - When to Recognize Expenses
Урок 156.00:02:10
The Accounting Equation and Its Importance
Урок 157.00:02:01
Elements of the Accounting System: General Ledger
Урок 158.00:01:43
T-Accounts: The Best Way to Understand Debits and Credits
Урок 159.00:04:25
P&L T-Accounts
Урок 160.00:03:02
The Double-Entry Principle - The Core Principle of Bookkeeping
Урок 161.00:05:20
Case Study - The Accounting Transactions of a Lemonade Stand (1/4)
Урок 162.00:10:25
Case Study - The Accounting Transactions of a Lemonade Stand (2/4)
Урок 163.00:07:40
Case Study - The Accounting Transactions of a Lemonade Stand (3/4)
Урок 164.00:07:31
Case Study - The Accounting Transactions of a Lemonade Stand (4/4)
Урок 165.00:08:15
Timing of Cash Flows and Why It Plays an Important Role in a Business
Урок 166.00:01:13
Timing of Income: Principles of Revenue Recognition
Урок 167.00:06:17
Timing of Expenses: Principles of Cost Recognition
Урок 168.00:03:52
The Four Type of Accruals Arising in Accounting Transactions
Урок 169.00:06:12
Calculating Cash Flows - Understand If a Business Makes or Burns Cash
Урок 170.00:02:45
The Three Parts of Cash Flow Statements Explained
Урок 171.00:02:16
Cash Flow Computations - The Direct Method
Урок 172.00:02:03
Cash Flow Computations - The Indirect Method
Урок 173.00:03:41
Calculating Cash Flow in Practice: A Complete Example
Урок 174.00:06:19
Why a Company Needs to Pay Attention to Trade Receivables?
Урок 175.00:02:34
What If Clients Do Not Pay on Time?
Урок 176.00:03:12
How to Handle Non-paying Customers? A Case-study
Урок 177.00:02:40
A Technique to Collect Trade Receivables Sooner
Урок 178.00:01:48
The Different Types of Inventory We Can Have
Урок 179.00:02:38
The Connection Between Cost of Goods Sold and Inventory
Урок 180.00:02:35
Cost Flow Methods
Урок 181.00:04:22
Cost Flow Methods - a Practical Exercise
Урок 182.00:00:56
The Different Types of Fixed Assets
Урок 183.00:03:09
Capitalizing Interest Expenses
Урок 184.00:02:01
Fair Value Accounting
Урок 185.00:02:27
Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life
Урок 186.00:04:13
The Revaluation Model
Урок 187.00:05:14
The Revaluation Model - Practical Exercise
Урок 188.00:05:20
Intangible Assets Created Internally
Урок 189.00:02:17
How We Account for Trade Payables
Урок 190.00:02:52
What Is the Difference Between Accounts Payable and Notes Payable?
Урок 191.00:01:27
Why Use E-invoicing?
Урок 192.00:03:08
The Difference Between Debt and Equity
Урок 193.00:02:25
Amortizing a Loan
Урок 194.00:03:05
Debt Covenants
Урок 195.00:03:24
Debt Covenants - A Practical Example
Урок 196.00:01:49
The Reason Companies Lease Assets
Урок 197.00:01:20
Solving a Complete Leasing Exercise
Урок 198.00:07:08
What is Leverage and Why Companies Use Financial Leverage?
Урок 199.00:04:24
The Implications of Using Excessive Leverage
Урок 200.00:03:18
The Different Types of Equity
Урок 201.00:04:14
Raising Equity in Different Stages of a Company's Lifecycle
Урок 202.00:05:56
The Types of Dividends Companies Pay to Shareholders
Урок 203.00:03:39
Dividend Payments - a Timeline
Урок 204.00:03:06
What Are Share Repurchases and Why Companies Do Them
Урок 205.00:03:12
The Idea Behind Stock Splits
Урок 206.00:03:06
What is a 10-K Report and Why Is It important for Investors?
Урок 207.00:02:34
Finding, Downloading and Going Through the Annual Report of P&G
Урок 208.00:06:54
What Is the Role of Auditing Firms and What Are the Benefits of an Audit?
Урок 209.00:02:34
Indispensable Tools for Financial Statement Analysis
Урок 210.00:01:42
Financial Statement Analysis - A Natural Continuation of Financial Accounting
Урок 211.00:01:59
First Steps in Financial Statement Analysis
Урок 212.00:03:03
Horizontal vs. Vertical Financial Statement Analysis
Урок 213.00:03:38
Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO)
Урок 214.00:01:24
Using Accounting Ratios to Assess Business Performance
Урок 215.00:07:37
Case Study - Calculating Ratios and Analyzing P&G's Financials (1/2)
Урок 216.00:06:56
Case Study - Calculating Ratios and Analyzing P&G's Financials (2/2)
Урок 217.00:04:44
COURSE CHALLENGE - Part 2
Урок 218.00:01:43
What You Will See Next In This Section
Урок 219.00:01:03
How to Download Tesla's Historical Financials
Урок 220.00:02:38
Calculating and Analyzing Growth and Profitability Ratios
Урок 221.00:10:39
Calculating and Analyzing Liquidity Ratios
Урок 222.00:06:24
Calculating and Analyzing Solvency Ratios
Урок 223.00:02:23
Introduction
Урок 224.00:02:54
The Importance of Working Capital Optimization: Case Study
Урок 225.00:08:57
Overtrading vs. Excessive Investment
Урок 226.00:03:31
Trade Receivables Management
Урок 227.00:08:32
Re-order Level
Урок 228.00:03:21
Economic Order Quantity (EOQ)
Урок 229.00:04:06
Inventory Optimization Techniques
Урок 230.00:04:42
Trade Payables Management
Урок 231.00:01:58
Working Capital Optimization - a Roadmap
Урок 232.00:05:08
Symptoms of Inefficient Working Capital - Trade Payables
Урок 233.00:02:04
Symptoms of Inefficient Working Capital - Trade Receivables
Урок 234.00:01:52
Trend analysis
Урок 235.00:08:23
Comparative analysis
Урок 236.00:04:49
Value-based analysis
Урок 237.00:05:01
Correlation analysis
Урок 238.00:03:42
Time series analysis
Урок 239.00:08:00
Regression analysis
Урок 240.00:05:09
Finance 101: Important Financial Principles That You Will Need
Урок 241.00:00:45
Understanding the Time Value of Money
Урок 242.00:01:30
How Interest Rates Play an Important Role in the Economy?
Урок 243.00:01:28
The Components Forming Interest Rates in Real Life
Урок 244.00:03:00
What Is Libor and What Purpose Does It Serve?
Урок 245.00:01:08
The Difference Between Fixed and Variable Interest Rates
Урок 246.00:01:59
What Is Default Risk and How Does a Bank Account For It?
Урок 247.00:06:40
Corporate Loan Specifics
Урок 248.00:01:43
Calculating the Present Value of Future Cash Flows
Урок 249.00:05:12
A Tool That Helps Us Decide Whether a Project Is Feasible: Net Present Value
Урок 250.00:04:01
Using Annuities
Урок 251.00:03:19
Calculating a Complete Loan Schedule
Урок 252.00:06:33
COURSE CHALLENGE - Part 3
Урок 253.00:01:18
What is Capital Budgeting?
Урок 254.00:01:15
When Do We Use Capital Budgeting?
Урок 255.00:01:58
The Time Value of Money in a Capital Budgeting Setting
Урок 256.00:02:04
Calculating Present and Future Value
Урок 257.00:05:17
Cost of Equity
Урок 258.00:05:57
Project-specific Beta
Урок 259.00:02:54
The Weighted Average Cost of Capital (WACC)
Урок 260.00:01:49
The Different Cash Flow Types in a Capital Budgeting Exercise
Урок 261.00:02:58
Modeling Future Cash Flows
Урок 262.00:05:17
An Introduction to the Case Study
Урок 263.00:02:23
Organizing Inputs In the "Drivers" Sheet
Урок 264.00:04:58
Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam
Урок 265.00:03:23
Preparing a Fixed Asset Rollforward Schedule
Урок 266.00:04:18
Calculating the Cash Impact of Extra Working Capital Required
Урок 267.00:02:17
Debt Repayment and Interest Expenses Calculation
Урок 268.00:02:40
The Project's P&L Sheet
Урок 269.00:01:36
The Project's Cash Flow Calculation
Урок 270.00:02:57
Calculating WACC (Weighted Average Cost of Capital)
Урок 271.00:02:28
Estimating Cost of Equity
Урок 272.00:05:49
Discounting Project Cash Flows
Урок 273.00:03:06
Performing Sensitivity Analysis and Wrapping Up the Case Study
Урок 274.00:04:38
Organizing External Inputs in a 'Drivers' Sheet
Урок 275.00:03:56
Forecasting Tesla's Expected Deliveries
Урок 276.00:13:23
Comparing Delivery Figures with the Ones of industry Peers
Урок 277.00:03:16
Estimating an Average Selling Price of Tesla Vehicles
Урок 278.00:04:48
Calculating Automotive Revenue
Урок 279.00:04:08
Peer Comparison: Gross Profit %
Урок 280.00:04:52
Calculating Automotive Gross Profit
Урок 281.00:02:41
Calculating Automotive Cost of Sales
Урок 282.00:01:46
Forecasting 'Energy' and 'Services' Revenue
Урок 283.00:02:28
Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales
Урок 284.00:02:47
Forecasting Operating Expenses
Урок 285.00:04:36
Building a Fixed Asset Roll Forward: PP&E
Урок 286.00:04:08
Building a Fixed Asset Roll Forward: Estimating Capex
Урок 287.00:04:09
Building a Fixed Asset Roll Forward: D&A Schedule
Урок 288.00:03:23
Calculating DSO, DIO, DPO
Урок 289.00:01:58
Producing a Clean P&L Output Sheet
Урок 290.00:01:26
Calculating Investments in Working Capital
Урок 291.00:01:54
Forecasting Unlevered Free Cash Flow
Урок 292.00:03:08
Forecasting Other Assets
Урок 293.00:04:28
Forecasting Other Liabilities
Урок 294.00:02:08
Completing Unlevered Free Cash Flow
Урок 295.00:06:02
Modeling Tesla's Financing Needs in the Forecast Period
Урок 296.00:04:39
Calculating Net Income
Урок 297.00:01:16
Bridging Unlevered Free Cash Flow to Net Cash Flow
Урок 298.00:03:26
Balancing the Balance Sheet
Урок 299.00:00:57
Microsoft PowerPoint: The Most Popular Presentation Software for the Office
Урок 300.00:00:52
The Structure of the PowerPoint Ribbon
Урок 301.00:05:11
General Considerations About Slide Structure
Урок 302.00:03:53
Learn How to Insert Objects in PowerPoint
Урок 303.00:03:59
Shortcuts Allow Us To Be Much Faster When Working in PowerPoint
Урок 304.00:02:30
Add Frequently Used Buttons to the Quick Access Toolbar
Урок 305.00:03:11
How to Easily Align Objects in PowerPoint
Урок 306.00:03:50
How to Edit Shapes in Your Presentation
Урок 307.00:04:53
How to Format Text Boxes in a PowerPoint Presentation
Урок 308.00:03:48
Practical Learning - Exercise 1
Урок 309.00:03:58
Changing an Object's Size and Rotation
Урок 310.00:01:42
Using Slide Masters
Урок 311.00:04:00
Bring to Front and Send to Back - An Important PowerPoint Technique
Урок 312.00:02:54
Learn How to Create, Edit, Resize and Format PowerPoint Tables
Урок 313.00:05:01
An Introduction to PowerPoint Animations
Урок 314.00:02:59
Modifying the Beginning and Ending of a Line Object
Урок 315.00:01:48
Join Shapes Together By Using Connector Lines
Урок 316.00:04:12
Edit Points - Learn How to Customize PowerPoint Shapes
Урок 317.00:01:45
Group or Ungroup Shapes, Pictures or Other Objects
Урок 318.00:01:44
This is How You Can Fit Text When It Is Larger Than a Shape
Урок 319.00:01:58
Nudge Objects
Урок 320.00:00:58
PowerPoint's Smart Art Feature Offers Great Return for Your Time
Урок 321.00:03:28
Creating Eye-Catching Text Effects in PowerPoint
Урок 322.00:01:57
Practical Exercise - Creating an Organisational Chart
Урок 323.00:07:38
COURSE CHALLENGE - Part 4