Certification training

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

Prepare for your exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.

165Lectures
9h 11m 51sDuration
Vendor
The Financial Planning and Analysis Course: The Financial Planning & Analysis Course course cover Best seller
certification training 165 lessons arranged in a guided course path
Course overview

Study with a clear path.

Move through focused sections, review lecture timing, and return directly to the objectives that need more work.

Sequenced lessons

Follow the course in order or jump directly to the section you need to revisit.

Video-first prep

Use concise lecture blocks for technical review before moving into exam practice.

Fast access

Your purchased course becomes available in the member area after confirmed payment.

Curriculum

Course sections.

28 sections, 165 lessons, and lecture-level duration details.

01 Everything We Will Learn Has a Practical Application 3m 27s

01 Excel Made Easy: A Beginner's Guide to Excel Spreadsheets 3m 32s
02 Data Entry Techniques in Excel 3m
03 How to Make Your Spreadsheets Look Professional 5m 49s
04 Inserting, Deleting, and Modifying Rows & Columns 1m 44s
05 Excel Formulas for Beginners 2m 54s
06 A Beginner's Introduction to Excel Functions 3m 42s
07 Work Efficiently by Using Cut, Copy, and Paste 2m 10s
08 Pasting Values, Formulas and Formats with Paste Special 1m 28s

01 Inserting a Line Break with Alt + Enter 48s
02 Do More with Your Sales Data with Excel's Text to Columns Feature 1m 52s
03 Create Easily Printable Excel Documents 1m 12s
04 How to Wrap Text in Excel and Adjust a Cell's Size 43s
05 Insert Hyperlinks in Excel Spreadsheets 1m 16s
06 Using Excel's Freeze Panes to Handle Large Datasets 1m 12s
07 Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do 46s
08 A Quick Introduction to Excel's Pivot Tables 2m 12s

01 Initial Formatting Is Key for Creating Professional - Looking Spreadsheets 1m 59s
02 Macros Are a Great Timesaver! Here's Why. 2m 59s
03 The Secret to Faster Scrolling in Excel 1m 36s
04 Using Absolute and Relative Cell References 2m 15s
05 Find and Select Cells That Meet Specific Conditions 1m 30s
06 How to Create Dynamic Names in Excel Spreadsheets 1m 34s
07 Using Named Ranges to Make Formulas More Readable 1m 34s
08 Custom Number Formatting 1m 49s
09 How to Add a Drop-down List in Excel 1m 20s
10 Using Custom-sort to Sort Multiple Columns Within a Table 4m 15s
11 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts 1m 21s

01 Key Excel Functions: Sum, Sumif, Sumifs 4m 21s
02 Key Excel Functions: Count, Counta, Countif, Countifs 4m 1s
03 Key Excel Functions: Average & Averageif 1m 54s
04 Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate, & 4m 24s
05 Find the Highest and the Lowest Values in a Range: Max & Min 52s
06 Use Round in Your Financial Models 1m 1s
07 Excel's Lookup Functions: Vlookup & Hlookup Made Easy 7m 44s
08 Index, Match, and Their Combination - The Perfect Substitute of Vlookup 7m 27s
09 Using Excel's Iferror Function to Trap Spreadsheet Errors 1m 43s
10 Create Flexible Financial Models with Choose 2m 19s
11 Goal Seek Will Help You Find the Result You Are Looking For 2m 12s
12 Perform Sensitivity Analysis with Excel's Data Tables Functionality 4m 4s

01 Discounting cash flows in Microsoft Excel 7m 2s
02 Calculating Internal Rate of Return (IRR) in Excel 3m 30s
03 Using the PMT function in order to create a complete loan schedule 6m 16s
04 Date functions in Excel 5m 38s

01 Understand Your Data Source Before You Start Working on It 2m 26s
02 Ordering the Source Worksheet 1m 57s
03 Create a Code: The Best Way to Organize Your Data and Work Efficiently with It 1m 49s
04 Learn How to Create a Database 1m 54s
05 Using Lookup Functions (Vlookup) to Fill the Database Sheet 5m 20s
06 Use Sumif to Complete the Database Sheet 4m 5s
07 Using Index & Match as a Substitute of Vlookup 3m 59s
08 Mapping of the Rows in the Database Sheet 2m 6s
09 Building the Structure of the P&L Sheet 2m 8s
10 A Practical Example of Professional Formatting in Excel 3m 17s
11 Populate the P&L Sheet with Sumif 2m 43s
12 Learn How to Find Mistakes with Countif 2m 19s
13 Calculating Growth Rates in Excel 3m 5s

01 Introduction to Excel Charts 56s
02 Beginner's Guide to Inserting Charts in Excel 2m 5s
03 Modifying Excel Charts - The Easy Way to Do It 2m 24s
04 Make Your Excel Charts Look Sexier - Proven Tips 3m 4s
05 Creating a Bridge Chart in Excel 2016 - As Easy as It Gets 1m 37s
06 New Ways to Visualize Your Data - Treemap Charts 1m 26s
07 How to Represent Trends with Sparklines 3m 47s

01 Pivot Tables - Excel's Dynamic and Interactive Tables 1m 29s
02 Creating a Pivot Table: Choosing Row and Column Parameters 3m 42s
03 Design the Layout and Format of Your Pivot Tables 2m 9s
04 Additional Techniques That Will Ease Your Work with Pivot Tables 4m 28s
05 One of the Most Useful Excel Functions - GetPivotData 3m 39s
06 Welcome to the Future - Pivot Table Slicers 4m 15s

01 Introduction to the Case Study 1m 55s
02 Working with an SAP data extraction 3m 17s
03 Preliminary mapping of the data extraction 2m 5s
04 Creating an output structure of the FMCG model 2m 24s
05 Improving the layout and appearance of the FMCG report 3m 54s
06 Inserting formulas and automating calculations 2m 25s
07 Creating a Master Pivot Table: The main data source for the FMCG report 1m 50s
08 GetPivotData is great! Extracting data from the Master Pivot Table 5m 39s
09 Combining Slicers and GetPivotData: The key to our success 3m 14s
10 Getting fancy with Excel slicers - Good-looking Excel slicers 3m 6s
11 This is how the report can be used in practice by high-level executives 3m 54s

01 Introduction to the Exercise 3m
02 Let's create a mapping of financials 2m 50s
03 Building an output P&L sheet 4m 7s
04 Filling in the output P&L sheet with historical financials 2m 57s
05 Calculating percentage variances and applying conditional formatting 3m 14s
06 Building an output Balance sheet 3m 55s
07 Using Index, Match, Match to fill in the output Balance sheet 5m 10s
08 Adding the forecast period 4m 5s

01 Calculating historical percentage ratios and use Index and Match for scenarios 5m 6s
02 Building a flexible model with Choose & Match 1m 44s
03 Building a flexible model with Vlookup & Columns 3m 22s
04 Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities % 5m 8s
05 Forecasting DSO, DPO, DIO, Other assets and Other liabilities 3m 16s

01 Building a Fixed asset roll forward 5m 17s
02 Building a Financial liabilities schedule 6m 24s
03 Building an Equity schedule 4m 28s
04 Preparing a Cash flow structure 2m 16s
05 Calculating Cash flows and completing the model 6m 47s

01 What is Accounting and Why Do You Need It 5m 11s
02 The Importance of Bookkeeping - Good Accounting Records Are Essential 2m 34s
03 An Introduction to Financial Accounting 2m 43s

01 The Three Core Financial Statements: P&L, Balance Sheet and Cash Flow 2m 8s
02 The Key Accounts You Will Find in a P&L 6m 1s
03 The Main Balance Sheet Items 4m 34s

01 The Revenue Recognition Principle - Why Is it so Important? 2m 19s
02 The Expense Recognition Principle - When to Recognize Expenses 2m 2s
03 Historical Cost vs 2m 14s

01 The Accounting Equation and Its Importance 1m 59s
02 Elements of the Accounting System: General Ledger 1m 42s
03 T-Accounts: The Best Way to Understand Debits and Credits 4m 18s
04 P&L T-Accounts 2m 56s
05 How to Calculate Depreciation Expense 4m 27s
06 The Double-Entry Principle - The Core Principle of Bookkeeping 5m 19s

01 Case Study - The Accounting Transactions of a Lemonade Stand (1/4) 10m 19s
02 Case Study - The Accounting Transactions of a Lemonade Stand (2/4) 7m 39s
03 Case Study - The Accounting Transactions of a Lemonade Stand (3/4) 7m 25s
04 Case Study - The Accounting Transactions of a Lemonade Stand (4/4) 8m 9s

01 Calculating Cash Flows - Understand if a business makes or burns cash 2m 36s
02 The three parts of Cash Flow statements explained 2m 9s
03 Cash Flow computations - The Direct method 1m 59s
04 Cash Flow computations - The Indirect method 3m 35s
05 Calculating Cash Flow in practice: A complete example 6m 19s

01 Timing of Cash Flows and Why It Plays an Important Role for a Business 1m 12s
02 Timing of Income: Principles of Revenue Recognition 6m 11s
03 Timing of Expenses: Principles of Cost Recognition 3m 46s
04 The Four Type of Accruals Arising in Accounting Transactions 4m 15s

01 What is a 10-K Report and Why Is It important for Investors? 2m 28s
02 Finding, Downloading and Going Through the Annual Report of P&G 6m 53s
03 What is the Role of Auditing Firms and What Are the Benefits of an Audit? 2m 28s
04 Indispensable Tools for Financial Statement Analysis 1m 36s

01 Financial Statement Analysis - A Natural Continuation of Financial Accounting 1m 52s
02 First Steps in Financial Statement Analysis 2m 57s
03 Horizontal vs 3m 32s
04 Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO) 1m 23s
05 Using Accounting Ratios to Assess Business Performance 7m 31s

01 Case Study - Calculating Ratios and Analyzing P&G's Financials (1/2) 6m 49s
02 Case Study - Calculating Ratios and Analyzing P&G's Financials (2/2) 4m 38s

01 Understanding the Time Value of Money 1m 18s
02 Why Interest Rates Play an Important Role in the Economy? 1m 23s
03 The Components Forming Interest Rates in Real Life 2m 38s
04 What Is Libor and What Does It Serve For? 1m 3s
05 The Difference Between Fixed and Variable Interest Rates 1m 53s
06 What Is Default Risk and How Does a Bank Account For It? 6m 18s
07 Corporate Loan Specifics 1m 38s

01 Calculating the Present Value of Future Cash Flows 4m 51s
02 A Tool That Helps Us Decide Whether a Project Is Feasible: Net Present Value 3m 56s

01 Calculating a Complete Loan Schedule 3m 3s
02 COURSE CHALLENGE - Part 3 6m 26s

01 The Structure of the PowerPoint Ribbon 5m 8s
02 General Considerations About Slide Structure 3m 52s
03 Shortcuts Allow Us To Be Much Faster When Working in PowerPoint 2m 28s
04 Add Frequently Used Buttons to the Quick Access Toolbar 3m 23s
05 How to Easily Align Objects in PowerPoint 3m 53s
06 Editing Shapes in Your Presentation - The Format Shape Menu 4m 41s
07 How to Format Text Boxes in a PowerPoint Presentation 3m 51s
08 Changing an Object's Size and Learning About Rotation Options 1m 39s
09 Work Efficiently By Using Slide Masters 4m 25s

01 Modifying the Beginning and Ending of a Line Object 1m 41s
02 Join Shapes Together By Using Connector Lines 3m 46s
03 Group or Ungroup Shapes, Pircutres or Other Objects 1m 45s
04 This is How You Can Fit Text When It Is Larger than a Shape 1m 58s
05 PowerPoint's Smart Art Feature Offers Great Return for Your Time 3m 30s
06 Creating Eye-Catching Text Effects in PowerPoint 1m 59s
07 Practical Exercise - Creating an Organizational Chart 7m 52s
Continue preparing

Connect the lessons to exam-day practice.

Use the course for structured review, then move into current questions, timed simulator sessions, and a broader vendor catalog.

VTSimu exam simulatorRehearse pacing in focused desktop sessions.
Unlimited AccessBuild a practice library across vendors and formats.
More video coursesExplore every available certification training track.