Exclusive SALE Offer Today

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

Best Seller 165 Lectures 9h 11m 51s
Prepare for your Microsoft examination with our training course. The No_code course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft No_code test with flying colors.
$14.99$24.99
Curriculum For This Course

  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 1. Calculating a Complete Loan Schedule 3m 3s
  • 2. COURSE CHALLENGE - Part 3 6m 26s
  • 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
  • 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

How to Open Test Engine .dumpsarena Files

Use FREE DumpsArena Test Engine player to open .dumpsarena files

DumpsArena Test Engine

Windows

Refund Policy
Refund Policy

DumpsArena.com has a remarkable success record. We're confident of our products and provide a no hassle refund policy.

How our refund policy works?

safe checkout

Your purchase with DumpsArena.com is safe and fast.

The DumpsArena.com website is protected by 256-bit SSL from Cloudflare, the leader in online security.

Need Help Assistance?