
The Financial Planning and Analysis Course: The Financial Planning & Analysis Course Certification Video Training Course
The complete solution to prepare for for your exam with The Financial Planning and Analysis Course: The Financial Planning & Analysis Course certification video training course. The The Financial Planning and Analysis Course: The Financial Planning & Analysis Course certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Finance Courses The Financial Planning and Analysis Course exam dumps, study guide & practice test questions and answers.
The Financial Planning and Analysis Course: The Financial Planning & Analysis Course Certification Video Training Course Exam Curriculum
Welcome! Course Introduction
-
1. Everything We Will Learn Has a Practical Application
Microsoft Excel - Quick Introduction
-
1. Excel Made Easy: A Beginner's Guide to Excel Spreadsheets
-
2. Data Entry Techniques in Excel
-
3. How to Make Your Spreadsheets Look Professional
-
4. Inserting, Deleting, and Modifying Rows & Columns
-
5. Excel Formulas for Beginners
-
6. A Beginner's Introduction to Excel Functions
-
7. Work Efficiently by Using Cut, Copy, and Paste
-
8. Pasting Values, Formulas and Formats with Paste Special
Microsoft Excel - Useful Tools
-
1. Inserting a Line Break with Alt + Enter
-
2. Do More with Your Sales Data with Excel's Text to Columns Feature
-
3. Create Easily Printable Excel Documents
-
4. How to Wrap Text in Excel and Adjust a Cell's Size
-
5. Insert Hyperlinks in Excel Spreadsheets
-
6. Using Excel's Freeze Panes to Handle Large Datasets
-
7. Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do
-
8. A Quick Introduction to Excel's Pivot Tables
Microsoft Excel - Best Practices That Will Make a Difference
-
1. Initial Formatting Is Key for Creating Professional - Looking Spreadsheets
-
2. Macros Are a Great Timesaver! Here's Why.
-
3. The Secret to Faster Scrolling in Excel
-
4. Using Absolute and Relative Cell References
-
5. Find and Select Cells That Meet Specific Conditions
-
6. How to Create Dynamic Names in Excel Spreadsheets
-
7. Using Named Ranges to Make Formulas More Readable
-
8. Custom Number Formatting
-
9. How to Add a Drop-down List in Excel
-
10. Using Custom-sort to Sort Multiple Columns Within a Table
-
11. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts
Microsoft Excel - Beginner, Intermediate & Advanced Functions
-
1. Key Excel Functions: Sum, Sumif, Sumifs
-
2. Key Excel Functions: Count, Counta, Countif, Countifs
-
3. Key Excel Functions: Average & Averageif
-
4. Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate, &
-
5. Find the Highest and the Lowest Values in a Range: Max & Min
-
6. Use Round in Your Financial Models
-
7. Excel's Lookup Functions: Vlookup & Hlookup Made Easy
-
8. Index, Match, and Their Combination - The Perfect Substitute of Vlookup
-
9. Using Excel's Iferror Function to Trap Spreadsheet Errors
-
10. Create Flexible Financial Models with Choose
-
11. Goal Seek Will Help You Find the Result You Are Looking For
-
12. Perform Sensitivity Analysis with Excel's Data Tables Functionality
Microsoft Excel - Financial functions in Excel
-
1. Discounting cash flows in Microsoft Excel
-
2. Calculating Internal Rate of Return (IRR) in Excel
-
3. Using the PMT function in order to create a complete loan schedule
-
4. Date functions in Excel
Microsoft Excel - Practical Exercise "Build a P&L From Scratch"
-
1. Understand Your Data Source Before You Start Working on It
-
2. Ordering the Source Worksheet
-
3. Create a Code: The Best Way to Organize Your Data and Work Efficiently with It
-
4. Learn How to Create a Database
-
5. Using Lookup Functions (Vlookup) to Fill the Database Sheet
-
6. Use Sumif to Complete the Database Sheet
-
7. Using Index & Match as a Substitute of Vlookup
-
8. Mapping of the Rows in the Database Sheet
-
9. Building the Structure of the P&L Sheet
-
10. A Practical Example of Professional Formatting in Excel
-
11. Populate the P&L Sheet with Sumif
-
12. Learn How to Find Mistakes with Countif
-
13. Calculating Growth Rates in Excel
Microsoft Excel - Building Professional Charts in Excel
-
1. Introduction to Excel Charts
-
2. Beginner's Guide to Inserting Charts in Excel
-
3. Modifying Excel Charts - The Easy Way to Do It
-
4. Make Your Excel Charts Look Sexier - Proven Tips
-
5. Creating a Bridge Chart in Excel 2016 - As Easy as It Gets
-
6. New Ways to Visualize Your Data - Treemap Charts
-
7. How to Represent Trends with Sparklines
Microsoft Excel - Working with Pivot Tables in Excel
-
1. Pivot Tables - Excel's Dynamic and Interactive Tables
-
2. Creating a Pivot Table: Choosing Row and Column Parameters
-
3. Design the Layout and Format of Your Pivot Tables
-
4. Additional Techniques That Will Ease Your Work with Pivot Tables
-
5. One of the Most Useful Excel Functions - GetPivotData
-
6. Welcome to the Future - Pivot Table Slicers
Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here
-
1. Introduction to the Case Study
-
2. Working with an SAP data extraction
-
3. Preliminary mapping of the data extraction
-
4. Creating an output structure of the FMCG model
-
5. Improving the layout and appearance of the FMCG report
-
6. Inserting formulas and automating calculations
-
7. Creating a Master Pivot Table: The main data source for the FMCG report
-
8. GetPivotData is great! Extracting data from the Master Pivot Table
-
9. Combining Slicers and GetPivotData: The key to our success
-
10. Getting fancy with Excel slicers - Good-looking Excel slicers
-
11. This is how the report can be used in practice by high-level executives
Modeling in Excel - Building a complete 3-statement model
-
1. Introduction to the Exercise
-
2. Let's create a mapping of financials
-
3. Building an output P&L sheet
-
4. Filling in the output P&L sheet with historical financials
-
5. Calculating percentage variances and applying conditional formatting
-
6. Building an output Balance sheet
-
7. Using Index, Match, Match to fill in the output Balance sheet
-
8. Adding the forecast period
Modeling in Excel - Let's build a flexible model with multiple scenarios
-
1. Calculating historical percentage ratios and use Index and Match for scenarios
-
2. Building a flexible model with Choose & Match
-
3. Building a flexible model with Vlookup & Columns
-
4. Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %
-
5. Forecasting DSO, DPO, DIO, Other assets and Other liabilities
Modeling in Excel - We are almost there! Completing the 3-statement model
-
1. Building a Fixed asset roll forward
-
2. Building a Financial liabilities schedule
-
3. Building an Equity schedule
-
4. Preparing a Cash flow structure
-
5. Calculating Cash flows and completing the model
Accounting - Introduction to Accounting & Bookkeeping
-
1. What is Accounting and Why Do You Need It
-
2. The Importance of Bookkeeping - Good Accounting Records Are Essential
-
3. An Introduction to Financial Accounting
Accounting - The Three Main Statements in Financial Accounting
-
1. The Three Core Financial Statements: P&L, Balance Sheet and Cash Flow
-
2. The Key Accounts You Will Find in a P&L
-
3. The Main Balance Sheet Items
Accounting - Understanding the Big Picture: Why, What, When, and How Much
-
1. The Revenue Recognition Principle - Why Is it so Important?
-
2. The Expense Recognition Principle - When to Recognize Expenses
-
3. Historical Cost vs. Fair Value Accounting
Accounting - The Core Principles of Accounting
-
1. The Accounting Equation and Its Importance
-
2. Elements of the Accounting System: General Ledger
-
3. T-Accounts: The Best Way to Understand Debits and Credits
-
4. P&L T-Accounts
-
5. How to Calculate Depreciation Expense
-
6. The Double-Entry Principle - The Core Principle of Bookkeeping
Accounting - Practical Exercise: The Accounting Transactions of a Lemonade Stand
-
1. Case Study - The Accounting Transactions of a Lemonade Stand (1/4)
-
2. Case Study - The Accounting Transactions of a Lemonade Stand (2/4)
-
3. Case Study - The Accounting Transactions of a Lemonade Stand (3/4)
-
4. Case Study - The Accounting Transactions of a Lemonade Stand (4/4)
Accounting - Preparing a Cash Flow Statement: Understanding Cash Flow Analysis
-
1. Calculating Cash Flows - Understand if a business makes or burns cash
-
2. The three parts of Cash Flow statements explained
-
3. Cash Flow computations - The Direct method
-
4. Cash Flow computations - The Indirect method
-
5. Calculating Cash Flow in practice: A complete example
Accounting - The Importance of Timing
-
1. Timing of Cash Flows and Why It Plays an Important Role for a Business
-
2. Timing of Income: Principles of Revenue Recognition
-
3. Timing of Expenses: Principles of Cost Recognition
-
4. The Four Type of Accruals Arising in Accounting Transactions
Accounting - Introduction to Financial Statement Analysis
-
1. What is a 10-K Report and Why Is It important for Investors?
-
2. Finding, Downloading and Going Through the Annual Report of P&G
-
3. What is the Role of Auditing Firms and What Are the Benefits of an Audit?
-
4. Indispensable Tools for Financial Statement Analysis
Accounting - Subtleties of Financial Statement Analysis
-
1. Financial Statement Analysis - A Natural Continuation of Financial Accounting
-
2. First Steps in Financial Statement Analysis
-
3. Horizontal vs. Vertical Financial Statement Analysis
-
4. Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO)
-
5. Using Accounting Ratios to Assess Business Performance
Accounting - Practical Case Study "Analyzing P&G's Financials"
-
1. Case Study - Calculating Ratios and Analyzing P&G's Financials (1/2)
-
2. Case Study - Calculating Ratios and Analyzing P&G's Financials (2/2)
Finance 101 - The Time Value of Money and Interest Rate Components
-
1. Understanding the Time Value of Money
-
2. Why Interest Rates Play an Important Role in the Economy?
-
3. The Components Forming Interest Rates in Real Life
-
4. What Is Libor and What Does It Serve For?
-
5. The Difference Between Fixed and Variable Interest Rates
-
6. What Is Default Risk and How Does a Bank Account For It?
-
7. Corporate Loan Specifics
Finance 101 - The Value of Cash Flows with Different Timing
-
1. Calculating the Present Value of Future Cash Flows
-
2. A Tool That Helps Us Decide Whether a Project Is Feasible: Net Present Value
Finance 101 - Loan Calculations
-
1. Calculating a Complete Loan Schedule
-
2. COURSE CHALLENGE - Part 3
PowerPoint - Introduction to PowerPoint
-
1. The Structure of the PowerPoint Ribbon
-
2. General Considerations About Slide Structure
-
3. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint
-
4. Add Frequently Used Buttons to the Quick Access Toolbar
-
5. How to Easily Align Objects in PowerPoint
-
6. Editing Shapes in Your Presentation - The Format Shape Menu
-
7. How to Format Text Boxes in a PowerPoint Presentation
-
8. Changing an Object's Size and Learning About Rotation Options
-
9. Work Efficiently By Using Slide Masters
PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User
-
1. Modifying the Beginning and Ending of a Line Object
-
2. Join Shapes Together By Using Connector Lines
-
3. Group or Ungroup Shapes, Pircutres or Other Objects
-
4. This is How You Can Fit Text When It Is Larger than a Shape
-
5. PowerPoint's Smart Art Feature Offers Great Return for Your Time
-
6. Creating Eye-Catching Text Effects in PowerPoint
-
7. Practical Exercise - Creating an Organizational Chart
About The Financial Planning and Analysis Course: The Financial Planning & Analysis Course Certification Video Training Course
The Financial Planning and Analysis Course: The Financial Planning & Analysis Course certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.
The video course is intended for those individuals who want to become financial analysts and build a career in finance. It sums up the most important concepts and helps the learners improve their knowledge practically. It is interactive, concise, and comprehensive.
Besides, the structure of the training is clear and logic. You will go step-by-step from introduction. During the course, you will work with Excel. First 8 lectures regarding Excel include a guide to Excel Spreadsheets for beginners, data entry techniques, formulas, functions. Moreover, you will learn how to modify, delete, or insert columns and rows, and etc. After that, you will get acquainted with Excel tools. You will know how to create printable documents, insert hyperlinks, use Freeze Panes, and so on. All these lectures are quite short, and they just help you use Excel in a more professional way.
Then, 11 lectures are about Excel best practices: to add a drop-down list, to use absolute and relative cell references, to faster scrolling, to use Excel shortcuts, and etc. The next part is dedicated to Excel functions that are beginner, intermediate and advanced. After that, you will learn Excel financial functions. The course provides you with practical exercise, knowledge of creating professional chart in Excel, Pivot Tables, modeling in Excel, and etc. After these sections, you will go on to financial accounting. Under this theme, you will learn the basic principles, cash flow analysis, financial statement analysis, and etc. Practical case study is also included. The last big topic is PowerPoint. You will know some tips and trick to become an advanced user.
Thus, the course is very informative and takes just a little time. Round out your knowledge and get new skills!
Prepaway's The Financial Planning and Analysis Course: The Financial Planning & Analysis Course video training course for passing certification exams is the only solution which you need.
Pass Finance Courses The Financial Planning and Analysis Course Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers As Seen in the Actual Exam!
30 Days Free Updates, Instant Download!
Student Feedback
Can View Online Video Courses
Please fill out your email address below in order to view Online Courses.
Registration is Free and Easy, You Simply need to provide an email address.
- Trusted By 1.2M IT Certification Candidates Every Month
- Hundreds Hours of Videos
- Instant download After Registration
A confirmation link will be sent to this email address to verify your login.
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register