Welcome! Course Introduction

1. Everything We Will Learn Has a Practical Application

03:27

Microsoft Excel - Quick Introduction

1. Excel Made Easy: A Beginner's Guide to Excel Spreadsheets

03:32

2. Data Entry Techniques in Excel

03:00

3. How to Make Your Spreadsheets Look Professional

05:49

4. Inserting, Deleting, and Modifying Rows & Columns

01:44

5. Excel Formulas for Beginners

02:54

6. A Beginner's Introduction to Excel Functions

03:42

7. Work Efficiently by Using Cut, Copy, and Paste

02:10

8. Pasting Values, Formulas and Formats with Paste Special

01:28

Microsoft Excel - Useful Tools

1. Inserting a Line Break with Alt + Enter

00:48

2. Do More with Your Sales Data with Excel's Text to Columns Feature

01:52

3. Create Easily Printable Excel Documents

01:12

4. How to Wrap Text in Excel and Adjust a Cell's Size

00:43

5. Insert Hyperlinks in Excel Spreadsheets

01:16

6. Using Excel's Freeze Panes to Handle Large Datasets

01:12

7. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do

00:46

8. A Quick Introduction to Excel's Pivot Tables

02:12

Microsoft Excel - Best Practices That Will Make a Difference

1. Initial Formatting Is Key for Creating Professional - Looking Spreadsheets

01:59

2. Macros Are a Great Timesaver! Here's Why.

02:59

3. The Secret to Faster Scrolling in Excel

01:36

4. Using Absolute and Relative Cell References

02:15

5. Find and Select Cells That Meet Specific Conditions

01:30

6. How to Create Dynamic Names in Excel Spreadsheets

01:34

7. Using Named Ranges to Make Formulas More Readable

01:34

8. Custom Number Formatting

01:49

9. How to Add a Drop-down List in Excel

01:20

10. Using Custom-sort to Sort Multiple Columns Within a Table

04:15

11. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts

01:21

Microsoft Excel - Beginner, Intermediate & Advanced Functions

1. Key Excel Functions: Sum, Sumif, Sumifs

04:21

2. Key Excel Functions: Count, Counta, Countif, Countifs

04:01

3. Key Excel Functions: Average & Averageif

01:54

4. Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate, &

04:24

5. Find the Highest and the Lowest Values in a Range: Max & Min

00:52

6. Use Round in Your Financial Models

01:01

7. Excel's Lookup Functions: Vlookup & Hlookup Made Easy

07:44

8. Index, Match, and Their Combination - The Perfect Substitute of Vlookup

07:27

9. Using Excel's Iferror Function to Trap Spreadsheet Errors

01:43

10. Create Flexible Financial Models with Choose

02:19

11. Goal Seek Will Help You Find the Result You Are Looking For

02:12

12. Perform Sensitivity Analysis with Excel's Data Tables Functionality

04:04

Microsoft Excel - Financial functions in Excel

1. Discounting cash flows in Microsoft Excel

07:02

2. Calculating Internal Rate of Return (IRR) in Excel

03:30

3. Using the PMT function in order to create a complete loan schedule

06:16

4. Date functions in Excel

05:38

Microsoft Excel - Practical Exercise "Build a P&L From Scratch"

1. Understand Your Data Source Before You Start Working on It

02:26

2. Ordering the Source Worksheet

01:57

3. Create a Code: The Best Way to Organize Your Data and Work Efficiently with It

01:49

4. Learn How to Create a Database

01:54

5. Using Lookup Functions (Vlookup) to Fill the Database Sheet

05:20

6. Use Sumif to Complete the Database Sheet

04:05

7. Using Index & Match as a Substitute of Vlookup

03:59

8. Mapping of the Rows in the Database Sheet

02:06

9. Building the Structure of the P&L Sheet

02:08

10. A Practical Example of Professional Formatting in Excel

03:17

11. Populate the P&L Sheet with Sumif

02:43

12. Learn How to Find Mistakes with Countif

02:19

13. Calculating Growth Rates in Excel

03:05

Microsoft Excel - Building Professional Charts in Excel

1. Introduction to Excel Charts

00:56

2. Beginner's Guide to Inserting Charts in Excel

02:05

3. Modifying Excel Charts - The Easy Way to Do It

02:24

4. Make Your Excel Charts Look Sexier - Proven Tips

03:04

5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets

01:37

6. New Ways to Visualize Your Data - Treemap Charts

01:26

7. How to Represent Trends with Sparklines

03:47

Microsoft Excel - Working with Pivot Tables in Excel

1. Pivot Tables - Excel's Dynamic and Interactive Tables

01:29

2. Creating a Pivot Table: Choosing Row and Column Parameters

03:42

3. Design the Layout and Format of Your Pivot Tables

02:09

4. Additional Techniques That Will Ease Your Work with Pivot Tables

04:28

5. One of the Most Useful Excel Functions - GetPivotData

03:39

6. Welcome to the Future - Pivot Table Slicers

04:15

Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here

1. Introduction to the Case Study

01:55

2. Working with an SAP data extraction

03:17

3. Preliminary mapping of the data extraction

02:05

4. Creating an output structure of the FMCG model

02:24

5. Improving the layout and appearance of the FMCG report

03:54

6. Inserting formulas and automating calculations

02:25

7. Creating a Master Pivot Table: The main data source for the FMCG report

01:50

8. GetPivotData is great! Extracting data from the Master Pivot Table

05:39

9. Combining Slicers and GetPivotData: The key to our success

03:14

10. Getting fancy with Excel slicers - Good-looking Excel slicers

03:06

11. This is how the report can be used in practice by high-level executives

03:54

Modeling in Excel - Building a complete 3-statement model

1. Introduction to the Exercise

03:00

2. Let's create a mapping of financials

02:50

3. Building an output P&L sheet

04:07

4. Filling in the output P&L sheet with historical financials

02:57

5. Calculating percentage variances and applying conditional formatting

03:14

6. Building an output Balance sheet

03:55

7. Using Index, Match, Match to fill in the output Balance sheet

05:10

8. Adding the forecast period

04:05

Modeling in Excel - Let's build a flexible model with multiple scenarios

1. Calculating historical percentage ratios and use Index and Match for scenarios

05:06

2. Building a flexible model with Choose & Match

01:44

3. Building a flexible model with Vlookup & Columns

03:22

4. Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %

05:08

5. Forecasting DSO, DPO, DIO, Other assets and Other liabilities

03:16

Modeling in Excel - We are almost there! Completing the 3-statement model

1. Building a Fixed asset roll forward

05:17

2. Building a Financial liabilities schedule

06:24

3. Building an Equity schedule

04:28

4. Preparing a Cash flow structure

02:16

5. Calculating Cash flows and completing the model

06:47

Accounting - Introduction to Accounting & Bookkeeping

1. What is Accounting and Why Do You Need It

05:11

2. The Importance of Bookkeeping - Good Accounting Records Are Essential

02:34

3. An Introduction to Financial Accounting

02:43

Accounting - The Three Main Statements in Financial Accounting

1. The Three Core Financial Statements: P&L, Balance Sheet and Cash Flow

02:08

2. The Key Accounts You Will Find in a P&L

06:01

3. The Main Balance Sheet Items

04:34

Accounting - Understanding the Big Picture: Why, What, When, and How Much

1. The Revenue Recognition Principle - Why Is it so Important?

02:19

2. The Expense Recognition Principle - When to Recognize Expenses

02:02

3. Historical Cost vs. Fair Value Accounting

02:14

Accounting - The Core Principles of Accounting

1. The Accounting Equation and Its Importance

01:59

2. Elements of the Accounting System: General Ledger

01:42

3. T-Accounts: The Best Way to Understand Debits and Credits

04:18

4. P&L T-Accounts

02:56

5. How to Calculate Depreciation Expense

04:27

6. The Double-Entry Principle - The Core Principle of Bookkeeping

05:19

Accounting - Practical Exercise: The Accounting Transactions of a Lemonade Stand

1. Case Study - The Accounting Transactions of a Lemonade Stand (1/4)

10:19

2. Case Study - The Accounting Transactions of a Lemonade Stand (2/4)

07:39

3. Case Study - The Accounting Transactions of a Lemonade Stand (3/4)

07:25

4. Case Study - The Accounting Transactions of a Lemonade Stand (4/4)

08:09

Accounting - Preparing a Cash Flow Statement: Understanding Cash Flow Analysis

1. Calculating Cash Flows - Understand if a business makes or burns cash

02:36

2. The three parts of Cash Flow statements explained

02:09

3. Cash Flow computations - The Direct method

01:59

4. Cash Flow computations - The Indirect method

03:35

5. Calculating Cash Flow in practice: A complete example

06:19

Accounting - The Importance of Timing

1. Timing of Cash Flows and Why It Plays an Important Role for a Business

01:12

2. Timing of Income: Principles of Revenue Recognition

06:11

3. Timing of Expenses: Principles of Cost Recognition

03:46

4. The Four Type of Accruals Arising in Accounting Transactions

04:15

Accounting - Introduction to Financial Statement Analysis

1. What is a 10-K Report and Why Is It important for Investors?

02:28

2. Finding, Downloading and Going Through the Annual Report of P&G

06:53

3. What is the Role of Auditing Firms and What Are the Benefits of an Audit?

02:28

4. Indispensable Tools for Financial Statement Analysis

01:36

Accounting - Subtleties of Financial Statement Analysis

1. Financial Statement Analysis - A Natural Continuation of Financial Accounting

01:52

2. First Steps in Financial Statement Analysis

02:57

3. Horizontal vs. Vertical Financial Statement Analysis

03:32

4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO)

01:23

5. Using Accounting Ratios to Assess Business Performance

07:31

Accounting - Practical Case Study "Analyzing P&G's Financials"

1. Case Study - Calculating Ratios and Analyzing P&G's Financials (1/2)

06:49

2. Case Study - Calculating Ratios and Analyzing P&G's Financials (2/2)

04:38

Finance 101 - The Time Value of Money and Interest Rate Components

1. Understanding the Time Value of Money

01:18

2. Why Interest Rates Play an Important Role in the Economy?

01:23

3. The Components Forming Interest Rates in Real Life

02:38

4. What Is Libor and What Does It Serve For?

01:03

5. The Difference Between Fixed and Variable Interest Rates

01:53

6. What Is Default Risk and How Does a Bank Account For It?

06:18

7. Corporate Loan Specifics

01:38

Finance 101 - The Value of Cash Flows with Different Timing

1. Calculating the Present Value of Future Cash Flows

04:51

2. A Tool That Helps Us Decide Whether a Project Is Feasible: Net Present Value

03:56

Finance 101 - Loan Calculations

1. Calculating a Complete Loan Schedule

03:03

2. COURSE CHALLENGE - Part 3

06:26

PowerPoint - Introduction to PowerPoint

1. The Structure of the PowerPoint Ribbon

05:08

2. General Considerations About Slide Structure

03:52

3. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint

02:28

4. Add Frequently Used Buttons to the Quick Access Toolbar

03:23

5. How to Easily Align Objects in PowerPoint

03:53

6. Editing Shapes in Your Presentation - The Format Shape Menu

04:41

7. How to Format Text Boxes in a PowerPoint Presentation

03:51

8. Changing an Object's Size and Learning About Rotation Options

01:39

9. Work Efficiently By Using Slide Masters

04:25

PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User

1. Modifying the Beginning and Ending of a Line Object

01:41

2. Join Shapes Together By Using Connector Lines

03:46

3. Group or Ungroup Shapes, Pircutres or Other Objects

01:45

4. This is How You Can Fit Text When It Is Larger than a Shape

01:58

5. PowerPoint's Smart Art Feature Offers Great Return for Your Time

03:30

6. Creating Eye-Catching Text Effects in PowerPoint

01:59

7. Practical Exercise - Creating an Organizational Chart

07:52