Curriculum For This Course

Welcome! Course Introduction

1Lectures

Time 00:03:27

Microsoft Excel - Quick Introduction

8Lectures

Time 00:24:23

Microsoft Excel - Useful Tools

8Lectures

Time 00:10:12

Microsoft Excel - Best Practices That Will Make a Difference

11Lectures

Time 00:22:42

Microsoft Excel - Beginner, Intermediate & Advanced Functions

12Lectures

Time 00:42:31

Microsoft Excel - Financial functions in Excel

4Lectures

Time 00:22:26

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

13Lectures

Time 00:41:13

Microsoft Excel - Building Professional Charts in Excel

7Lectures

Time 00:16:04

Microsoft Excel - Working with Pivot Tables in Excel

6Lectures

Time 00:20:14

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

11Lectures

Time 00:34:51

Modeling in Excel - Building a complete 3-statement model

8Lectures

Time 00:29:31

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

5Lectures

Time 00:18:36

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

5Lectures

Time 00:25:12

Accounting - Introduction to Accounting & Bookkeeping

3Lectures

Time 00:10:33

Accounting - The Three Main Statements in Financial Accounting

3Lectures

Time 00:12:60

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

3Lectures

Time 00:06:35

Accounting - The Core Principles of Accounting

6Lectures

Time 00:21:03

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

4Lectures

Time 00:33:47

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

5Lectures

Time 00:16:36

Accounting - The Importance of Timing

4Lectures

Time 00:15:40

Accounting - Introduction to Financial Statement Analysis

4Lectures

Time 00:13:40

Accounting - Subtleties of Financial Statement Analysis

5Lectures

Time 00:17:36

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

2Lectures

Time 00:11:38

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

7Lectures

Time 00:17:21

Finance 101 - The Value of Cash Flows with Different Timing

2Lectures

Time 00:09:11

Finance 101 - Loan Calculations

2Lectures

Time 00:07:49

PowerPoint - Introduction to PowerPoint

9Lectures

Time 00:33:41

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

7Lectures

Time 00:22:54

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

About This Course

This training course is a video tutorial with 165 lectures created for those who want to boost their career in the financial sphere. In this exceptionally informative guide, you will find all the fundamental information a budding financial analyst should know. What’s more, during the course you will be able to gain solid practical skills in Excel and PowerPoint.

Some of the topics covered by the course:

Microsoft Excel
- Best practices
- Useful tools
- Financial functions
- Practical exercise: building a P&L from scratch
- How to build professional charts
- How to work with Pivot Tables
Slicers and Pivot Tables in practice
Modeling in Excel
- How to complete a three-statement model
- How to build a flexible model with numerous scenarios
- Completing the three-statement model
Accounting
- Introduction to bookkeeping and accounting
- Financial accounting: 3 main statements
- See the bigger picture: what, when, why, and how much
- Accounting: core principles
- Accounting transactions of a Lemonade Stand: practical exercise
- Cash flow analysis and cash flow statement: why timing is important
- Financial statement analysis: introduction
- Intricacies of financial statement analysis
- Practical case study: analyzing P&G's financials
Finance 101
- The interest rate components and time value of money
- How to calculate a loan
PowerPoint
- Introduction
- Tips and tricks

This well-structured tutorial will provide you with thorough explanations and exercises. If you want to significantly improve your skills in the field of financial analysis and planning, then welcome to the training!

Pass Finance Courses The Financial Planning and Analysis Course Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!
30 Days Free Updates, Instant Download!

Student Feedback

4.5

Good

48%

52 %

Add Comments

Name:^*

E-mail:^*

Comment:^* Comment will be moderated and published within 1-4 hours

Verification:^*

Type the characters from the picture.

Rate Course:^*

Limited Time Discount Offer
10% Off - Ends in 02:00:00

The Financial Planning and Analysis Course: The Financial Planning & Analysis Course

Curriculum For This Course

About This Course

Pass Finance Courses The Financial Planning and Analysis Course Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!
30 Days Free Updates, Instant Download!

Student Feedback

Add Comments

Limited Time Discount Offer 10% Off - Ends in 02:00:00

The Financial Planning and Analysis Course: The Financial Planning & Analysis Course

Curriculum For This Course

About This Course

Pass Finance Courses The Financial Planning and Analysis Course Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!30 Days Free Updates, Instant Download!

Student Feedback

Add Comments

Get Premium Membership

Limited Time Discount Offer
10% Off - Ends in 02:00:00

Get 100% Latest Exam Questions, Accurate & Verified Answers!
30 Days Free Updates, Instant Download!