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

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

BEST SELLER 165 Lectures 9h 11m 51s

Prepare for your examination with our training course. The course contains a complete batch of videos that will provide you with profound and thorough knowledge related to certification exam. Pass the test with flying colors.

$13.99 $24.99

Curriculum For This Course

1 lectures 3m 27s
  • 1. Everything We Will Learn Has a Practical Application
    3m 27s

8 lectures 24m 19s
  • 1. Excel Made Easy: A Beginner's Guide to Excel Spreadsheets
    3m 32s
  • 2. Data Entry Techniques in Excel
    3m
  • 3. How to Make Your Spreadsheets Look Professional
    5m 49s
  • 4. Inserting, Deleting, and Modifying Rows & Columns
    1m 44s
  • 5. Excel Formulas for Beginners
    2m 54s
  • 6. A Beginner's Introduction to Excel Functions
    3m 42s
  • 7. Work Efficiently by Using Cut, Copy, and Paste
    2m 10s
  • 8. Pasting Values, Formulas and Formats with Paste Special
    1m 28s

8 lectures 10m 1s
  • 1. Inserting a Line Break with Alt + Enter
    48s
  • 2. Do More with Your Sales Data with Excel's Text to Columns Feature
    1m 52s
  • 3. Create Easily Printable Excel Documents
    1m 12s
  • 4. How to Wrap Text in Excel and Adjust a Cell's Size
    43s
  • 5. Insert Hyperlinks in Excel Spreadsheets
    1m 16s
  • 6. Using Excel's Freeze Panes to Handle Large Datasets
    1m 12s
  • 7. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do
    46s
  • 8. A Quick Introduction to Excel's Pivot Tables
    2m 12s

11 lectures 22m 12s
  • 1. Initial Formatting Is Key for Creating Professional - Looking Spreadsheets
    1m 59s
  • 2. Macros Are a Great Timesaver! Here's Why.
    2m 59s
  • 3. The Secret to Faster Scrolling in Excel
    1m 36s
  • 4. Using Absolute and Relative Cell References
    2m 15s
  • 5. Find and Select Cells That Meet Specific Conditions
    1m 30s
  • 6. How to Create Dynamic Names in Excel Spreadsheets
    1m 34s
  • 7. Using Named Ranges to Make Formulas More Readable
    1m 34s
  • 8. Custom Number Formatting
    1m 49s
  • 9. 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

12 lectures 42m 2s
  • 1. Key Excel Functions: Sum, Sumif, Sumifs
    4m 21s
  • 2. Key Excel Functions: Count, Counta, Countif, Countifs
    4m 1s
  • 3. Key Excel Functions: Average & Averageif
    1m 54s
  • 4. Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate, &
    4m 24s
  • 5. Find the Highest and the Lowest Values in a Range: Max & Min
    52s
  • 6. Use Round in Your Financial Models
    1m 1s
  • 7. Excel's Lookup Functions: Vlookup & Hlookup Made Easy
    7m 44s
  • 8. Index, Match, and Their Combination - The Perfect Substitute of Vlookup
    7m 27s
  • 9. 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

4 lectures 22m 26s
  • 1. Discounting cash flows in Microsoft Excel
    7m 2s
  • 2. Calculating Internal Rate of Return (IRR) in Excel
    3m 30s
  • 3. Using the PMT function in order to create a complete loan schedule
    6m 16s
  • 4. Date functions in Excel
    5m 38s

13 lectures 37m 8s
  • 1. Understand Your Data Source Before You Start Working on It
    2m 26s
  • 2. Ordering the Source Worksheet
    1m 57s
  • 3. Create a Code: The Best Way to Organize Your Data and Work Efficiently with It
    1m 49s
  • 4. Learn How to Create a Database
    1m 54s
  • 5. Using Lookup Functions (Vlookup) to Fill the Database Sheet
    5m 20s
  • 6. Use Sumif to Complete the Database Sheet
    4m 5s
  • 7. Using Index & Match as a Substitute of Vlookup
    3m 59s
  • 8. Mapping of the Rows in the Database Sheet
    2m 6s
  • 9. 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

7 lectures 15m 19s
  • 1. Introduction to Excel Charts
    56s
  • 2. Beginner's Guide to Inserting Charts in Excel
    2m 5s
  • 3. Modifying Excel Charts - The Easy Way to Do It
    2m 24s
  • 4. Make Your Excel Charts Look Sexier - Proven Tips
    3m 4s
  • 5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets
    1m 37s
  • 6. New Ways to Visualize Your Data - Treemap Charts
    1m 26s
  • 7. How to Represent Trends with Sparklines
    3m 47s

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

11 lectures 33m 43s
  • 1. Introduction to the Case Study
    1m 55s
  • 2. Working with an SAP data extraction
    3m 17s
  • 3. Preliminary mapping of the data extraction
    2m 5s
  • 4. Creating an output structure of the FMCG model
    2m 24s
  • 5. Improving the layout and appearance of the FMCG report
    3m 54s
  • 6. Inserting formulas and automating calculations
    2m 25s
  • 7. Creating a Master Pivot Table: The main data source for the FMCG report
    1m 50s
  • 8. GetPivotData is great! Extracting data from the Master Pivot Table
    5m 39s
  • 9. 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

8 lectures 29m 18s
  • 1. Introduction to the Exercise
    3m
  • 2. Let's create a mapping of financials
    2m 50s
  • 3. Building an output P&L sheet
    4m 7s
  • 4. Filling in the output P&L sheet with historical financials
    2m 57s
  • 5. Calculating percentage variances and applying conditional formatting
    3m 14s
  • 6. Building an output Balance sheet
    3m 55s
  • 7. Using Index, Match, Match to fill in the output Balance sheet
    5m 10s
  • 8. Adding the forecast period
    4m 5s

5 lectures 18m 36s
  • 1. Calculating historical percentage ratios and use Index and Match for scenarios
    5m 6s
  • 2. Building a flexible model with Choose & Match
    1m 44s
  • 3. Building a flexible model with Vlookup & Columns
    3m 22s
  • 4. Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %
    5m 8s
  • 5. Forecasting DSO, DPO, DIO, Other assets and Other liabilities
    3m 16s

5 lectures 25m 12s
  • 1. Building a Fixed asset roll forward
    5m 17s
  • 2. Building a Financial liabilities schedule
    6m 24s
  • 3. Building an Equity schedule
    4m 28s
  • 4. Preparing a Cash flow structure
    2m 16s
  • 5. Calculating Cash flows and completing the model
    6m 47s

3 lectures 10m 28s
  • 1. What is Accounting and Why Do You Need It
    5m 11s
  • 2. The Importance of Bookkeeping - Good Accounting Records Are Essential
    2m 34s
  • 3. An Introduction to Financial Accounting
    2m 43s

3 lectures 12m 43s
  • 1. The Three Core Financial Statements: P&L, Balance Sheet and Cash Flow
    2m 8s
  • 2. The Key Accounts You Will Find in a P&L
    6m 1s
  • 3. The Main Balance Sheet Items
    4m 34s

3 lectures 6m 35s
  • 1. The Revenue Recognition Principle - Why Is it so Important?
    2m 19s
  • 2. The Expense Recognition Principle - When to Recognize Expenses
    2m 2s
  • 3. Historical Cost vs
    2m 14s

6 lectures 20m 41s
  • 1. The Accounting Equation and Its Importance
    1m 59s
  • 2. Elements of the Accounting System: General Ledger
    1m 42s
  • 3. T-Accounts: The Best Way to Understand Debits and Credits
    4m 18s
  • 4. P&L T-Accounts
    2m 56s
  • 5. How to Calculate Depreciation Expense
    4m 27s
  • 6. The Double-Entry Principle - The Core Principle of Bookkeeping
    5m 19s

4 lectures 33m 32s
  • 1. Case Study - The Accounting Transactions of a Lemonade Stand (1/4)
    10m 19s
  • 2. Case Study - The Accounting Transactions of a Lemonade Stand (2/4)
    7m 39s
  • 3. Case Study - The Accounting Transactions of a Lemonade Stand (3/4)
    7m 25s
  • 4. Case Study - The Accounting Transactions of a Lemonade Stand (4/4)
    8m 9s

5 lectures 16m 38s
  • 1. Calculating Cash Flows - Understand if a business makes or burns cash
    2m 36s
  • 2. The three parts of Cash Flow statements explained
    2m 9s
  • 3. Cash Flow computations - The Direct method
    1m 59s
  • 4. Cash Flow computations - The Indirect method
    3m 35s
  • 5. Calculating Cash Flow in practice: A complete example
    6m 19s

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

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

5 lectures 17m 15s
  • 1. Financial Statement Analysis - A Natural Continuation of Financial Accounting
    1m 52s
  • 2. First Steps in Financial Statement Analysis
    2m 57s
  • 3. Horizontal vs
    3m 32s
  • 4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO)
    1m 23s
  • 5. Using Accounting Ratios to Assess Business Performance
    7m 31s

2 lectures 11m 27s
  • 1. Case Study - Calculating Ratios and Analyzing P&G's Financials (1/2)
    6m 49s
  • 2. Case Study - Calculating Ratios and Analyzing P&G's Financials (2/2)
    4m 38s

7 lectures 16m 11s
  • 1. Understanding the Time Value of Money
    1m 18s
  • 2. Why Interest Rates Play an Important Role in the Economy?
    1m 23s
  • 3. The Components Forming Interest Rates in Real Life
    2m 38s
  • 4. What Is Libor and What Does It Serve For?
    1m 3s
  • 5. The Difference Between Fixed and Variable Interest Rates
    1m 53s
  • 6. What Is Default Risk and How Does a Bank Account For It?
    6m 18s
  • 7. Corporate Loan Specifics
    1m 38s

2 lectures 8m 47s
  • 1. Calculating the Present Value of Future Cash Flows
    4m 51s
  • 2. A Tool That Helps Us Decide Whether a Project Is Feasible: Net Present Value
    3m 56s

2 lectures 9m 29s
  • 1. Calculating a Complete Loan Schedule
    3m 3s
  • 2. COURSE CHALLENGE - Part 3
    6m 26s

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

7 lectures 22m 31s
  • 1. Modifying the Beginning and Ending of a Line Object
    1m 41s
  • 2. Join Shapes Together By Using Connector Lines
    3m 46s
  • 3. Group or Ungroup Shapes, Pircutres or Other Objects
    1m 45s
  • 4. This is How You Can Fit Text When It Is Larger than a Shape
    1m 58s
  • 5. PowerPoint's Smart Art Feature Offers Great Return for Your Time
    3m 30s
  • 6. Creating Eye-Catching Text Effects in PowerPoint
    1m 59s
  • 7. Practical Exercise - Creating an Organizational Chart
    7m 52s
Hot Exams

Free Test Engine Player

How to open .dumpsarena Files

Use FREE DumpsArena Test Engine player to open .dumpsarena files

Our test engine player will always be free.

DumpsArena Test Engine

Windows
Satisfaction Guaranteed

98.4% DumpsArena users pass

Our team is dedicated to delivering top-quality exam practice questions. We proudly offer a hassle-free satisfaction guarantee.

Why choose DumpsArena?

23,812+

Satisfied Customers Since 2018

  • Always Up-to-Date
  • Accurate and Verified
  • Free Regular Updates
  • 24/7 Customer Support
  • Instant Access to Downloads
Secure Experience

Guaranteed safe checkout.

At DumpsArena, your shopping security is our priority. We utilize high-security SSL encryption, ensuring that every purchase is 100% secure.

SECURED CHECKOUT
Need Help?

Feel free to contact us anytime!

Contact Support