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.
$6.99
$14.99
Curriculum For This Course
-
1. Everything We Will Learn Has a Practical Application3m 27s
-
1. Excel Made Easy: A Beginner's Guide to Excel Spreadsheets3m 32s
-
2. Data Entry Techniques in Excel3m
-
3. How to Make Your Spreadsheets Look Professional5m 49s
-
4. Inserting, Deleting, and Modifying Rows & Columns1m 44s
-
5. Excel Formulas for Beginners2m 54s
-
6. A Beginner's Introduction to Excel Functions3m 42s
-
7. Work Efficiently by Using Cut, Copy, and Paste2m 10s
-
8. Pasting Values, Formulas and Formats with Paste Special1m 28s
-
1. Inserting a Line Break with Alt + Enter48s
-
2. Do More with Your Sales Data with Excel's Text to Columns Feature1m 52s
-
3. Create Easily Printable Excel Documents1m 12s
-
4. How to Wrap Text in Excel and Adjust a Cell's Size43s
-
5. Insert Hyperlinks in Excel Spreadsheets1m 16s
-
6. Using Excel's Freeze Panes to Handle Large Datasets1m 12s
-
7. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do46s
-
8. A Quick Introduction to Excel's Pivot Tables2m 12s
-
1. Initial Formatting Is Key for Creating Professional - Looking Spreadsheets1m 59s
-
2. Macros Are a Great Timesaver! Here's Why.2m 59s
-
3. The Secret to Faster Scrolling in Excel1m 36s
-
4. Using Absolute and Relative Cell References2m 15s
-
5. Find and Select Cells That Meet Specific Conditions1m 30s
-
6. How to Create Dynamic Names in Excel Spreadsheets1m 34s
-
7. Using Named Ranges to Make Formulas More Readable1m 34s
-
8. Custom Number Formatting1m 49s
-
9. How to Add a Drop-down List in Excel1m 20s
-
10. Using Custom-sort to Sort Multiple Columns Within a Table4m 15s
-
11. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts1m 21s
-
1. Key Excel Functions: Sum, Sumif, Sumifs4m 21s
-
2. Key Excel Functions: Count, Counta, Countif, Countifs4m 1s
-
3. Key Excel Functions: Average & Averageif1m 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 & Min52s
-
6. Use Round in Your Financial Models1m 1s
-
7. Excel's Lookup Functions: Vlookup & Hlookup Made Easy7m 44s
-
8. Index, Match, and Their Combination - The Perfect Substitute of Vlookup7m 27s
-
9. Using Excel's Iferror Function to Trap Spreadsheet Errors1m 43s
-
10. Create Flexible Financial Models with Choose2m 19s
-
11. Goal Seek Will Help You Find the Result You Are Looking For2m 12s
-
12. Perform Sensitivity Analysis with Excel's Data Tables Functionality4m 4s
-
1. Discounting cash flows in Microsoft Excel7m 2s
-
2. Calculating Internal Rate of Return (IRR) in Excel3m 30s
-
3. Using the PMT function in order to create a complete loan schedule6m 16s
-
4. Date functions in Excel5m 38s
-
1. Understand Your Data Source Before You Start Working on It2m 26s
-
2. Ordering the Source Worksheet1m 57s
-
3. Create a Code: The Best Way to Organize Your Data and Work Efficiently with It1m 49s
-
4. Learn How to Create a Database1m 54s
-
5. Using Lookup Functions (Vlookup) to Fill the Database Sheet5m 20s
-
6. Use Sumif to Complete the Database Sheet4m 5s
-
7. Using Index & Match as a Substitute of Vlookup3m 59s
-
8. Mapping of the Rows in the Database Sheet2m 6s
-
9. Building the Structure of the P&L Sheet2m 8s
-
10. A Practical Example of Professional Formatting in Excel3m 17s
-
11. Populate the P&L Sheet with Sumif2m 43s
-
12. Learn How to Find Mistakes with Countif2m 19s
-
13. Calculating Growth Rates in Excel3m 5s
-
1. Introduction to Excel Charts56s
-
2. Beginner's Guide to Inserting Charts in Excel2m 5s
-
3. Modifying Excel Charts - The Easy Way to Do It2m 24s
-
4. Make Your Excel Charts Look Sexier - Proven Tips3m 4s
-
5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets1m 37s
-
6. New Ways to Visualize Your Data - Treemap Charts1m 26s
-
7. How to Represent Trends with Sparklines3m 47s
-
1. Pivot Tables - Excel's Dynamic and Interactive Tables1m 29s
-
2. Creating a Pivot Table: Choosing Row and Column Parameters3m 42s
-
3. Design the Layout and Format of Your Pivot Tables2m 9s
-
4. Additional Techniques That Will Ease Your Work with Pivot Tables4m 28s
-
5. One of the Most Useful Excel Functions - GetPivotData3m 39s
-
6. Welcome to the Future - Pivot Table Slicers4m 15s
-
1. Introduction to the Case Study1m 55s
-
2. Working with an SAP data extraction3m 17s
-
3. Preliminary mapping of the data extraction2m 5s
-
4. Creating an output structure of the FMCG model2m 24s
-
5. Improving the layout and appearance of the FMCG report3m 54s
-
6. Inserting formulas and automating calculations2m 25s
-
7. Creating a Master Pivot Table: The main data source for the FMCG report1m 50s
-
8. GetPivotData is great! Extracting data from the Master Pivot Table5m 39s
-
9. Combining Slicers and GetPivotData: The key to our success3m 14s
-
10. Getting fancy with Excel slicers - Good-looking Excel slicers3m 6s
-
11. This is how the report can be used in practice by high-level executives3m 54s
-
1. Introduction to the Exercise3m
-
2. Let's create a mapping of financials2m 50s
-
3. Building an output P&L sheet4m 7s
-
4. Filling in the output P&L sheet with historical financials2m 57s
-
5. Calculating percentage variances and applying conditional formatting3m 14s
-
6. Building an output Balance sheet3m 55s
-
7. Using Index, Match, Match to fill in the output Balance sheet5m 10s
-
8. Adding the forecast period4m 5s
-
1. Calculating historical percentage ratios and use Index and Match for scenarios5m 6s
-
2. Building a flexible model with Choose & Match1m 44s
-
3. Building a flexible model with Vlookup & Columns3m 22s
-
4. Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %5m 8s
-
5. Forecasting DSO, DPO, DIO, Other assets and Other liabilities3m 16s
-
1. Building a Fixed asset roll forward5m 17s
-
2. Building a Financial liabilities schedule6m 24s
-
3. Building an Equity schedule4m 28s
-
4. Preparing a Cash flow structure2m 16s
-
5. Calculating Cash flows and completing the model6m 47s
-
1. What is Accounting and Why Do You Need It5m 11s
-
2. The Importance of Bookkeeping - Good Accounting Records Are Essential2m 34s
-
3. An Introduction to Financial Accounting2m 43s
-
1. The Three Core Financial Statements: P&L, Balance Sheet and Cash Flow2m 8s
-
2. The Key Accounts You Will Find in a P&L6m 1s
-
3. The Main Balance Sheet Items4m 34s
-
1. The Revenue Recognition Principle - Why Is it so Important?2m 19s
-
2. The Expense Recognition Principle - When to Recognize Expenses2m 2s
-
3. Historical Cost vs2m 14s
-
1. The Accounting Equation and Its Importance1m 59s
-
2. Elements of the Accounting System: General Ledger1m 42s
-
3. T-Accounts: The Best Way to Understand Debits and Credits4m 18s
-
4. P&L T-Accounts2m 56s
-
5. How to Calculate Depreciation Expense4m 27s
-
6. The Double-Entry Principle - The Core Principle of Bookkeeping5m 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 cash2m 36s
-
2. The three parts of Cash Flow statements explained2m 9s
-
3. Cash Flow computations - The Direct method1m 59s
-
4. Cash Flow computations - The Indirect method3m 35s
-
5. Calculating Cash Flow in practice: A complete example6m 19s
-
1. Timing of Cash Flows and Why It Plays an Important Role for a Business1m 12s
-
2. Timing of Income: Principles of Revenue Recognition6m 11s
-
3. Timing of Expenses: Principles of Cost Recognition3m 46s
-
4. The Four Type of Accruals Arising in Accounting Transactions4m 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&G6m 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 Analysis1m 36s
-
1. Financial Statement Analysis - A Natural Continuation of Financial Accounting1m 52s
-
2. First Steps in Financial Statement Analysis2m 57s
-
3. Horizontal vs3m 32s
-
4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO)1m 23s
-
5. Using Accounting Ratios to Assess Business Performance7m 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 Money1m 18s
-
2. Why Interest Rates Play an Important Role in the Economy?1m 23s
-
3. The Components Forming Interest Rates in Real Life2m 38s
-
4. What Is Libor and What Does It Serve For?1m 3s
-
5. The Difference Between Fixed and Variable Interest Rates1m 53s
-
6. What Is Default Risk and How Does a Bank Account For It?6m 18s
-
7. Corporate Loan Specifics1m 38s
-
1. Calculating the Present Value of Future Cash Flows4m 51s
-
2. A Tool That Helps Us Decide Whether a Project Is Feasible: Net Present Value3m 56s
-
1. Calculating a Complete Loan Schedule3m 3s
-
2. COURSE CHALLENGE - Part 36m 26s
-
1. The Structure of the PowerPoint Ribbon5m 8s
-
2. General Considerations About Slide Structure3m 52s
-
3. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint2m 28s
-
4. Add Frequently Used Buttons to the Quick Access Toolbar3m 23s
-
5. How to Easily Align Objects in PowerPoint3m 53s
-
6. Editing Shapes in Your Presentation - The Format Shape Menu4m 41s
-
7. How to Format Text Boxes in a PowerPoint Presentation3m 51s
-
8. Changing an Object's Size and Learning About Rotation Options1m 39s
-
9. Work Efficiently By Using Slide Masters4m 25s
-
1. Modifying the Beginning and Ending of a Line Object1m 41s
-
2. Join Shapes Together By Using Connector Lines3m 46s
-
3. Group or Ungroup Shapes, Pircutres or Other Objects1m 45s
-
4. This is How You Can Fit Text When It Is Larger than a Shape1m 58s
-
5. PowerPoint's Smart Art Feature Offers Great Return for Your Time3m 30s
-
6. Creating Eye-Catching Text Effects in PowerPoint1m 59s
-
7. Practical Exercise - Creating an Organizational Chart7m 52s
