Complete Financial Analyst Course 2025 (training)

Colleagues, in the “Complete Financial Analyst Course” you will learn Excel, Accounting, Financial Statement Analysis, Business Analysis, Financial Math, PowerPoint. [381 lectures • 22+ teaching hours]. Work comfortably with Microsoft Excel. Format spreadsheets professionally. Perform routine tasks quicker. Create professional charts in Microsoft Excel. Efficiently work with vast amounts of data. Understand accounting and bookkeeping principles. Build a company’s P&L from scratch. Create a company’s balance sheet. Perform Financial statement analysis. Understand the timing of revenue and cost recognition. Calculate liquidity, solvency, profitability, and growth ratios to analyze a company’s performance. Understand 10-K reports. Assess whether a project is feasible via the net present value (NPV) technique. Calculate a complete loan schedule. Know the difference between variable and fixed interest rates. Perform industry analysis. Realize what drives a company’s value. Know how to analyze a business. Work comfortably with Microsoft PowerPoint. Create professional company presentations in PowerPoint. Training modules include: 1) Microsoft Excel - Useful Tools, Best Practices That Will Make a Difference, Beginner, Intermediate & Advanced Functions, Financial Functions in Excel, Practical Exercise "Build a P&L From Scratch", SUMIFS, Building Professional Charts in Excel, Creating Complete Professional Charts from Scratch, Working with Pivot Tables in Excel, Pivot Tables & Slicers - World-Class Financial Reporting, Building a Complete 3-statement Model, Let's Build a Flexible Model with Multiple Scenarios, Completing the 3-Statement Model, 2) Accounting - Introduction to Accounting & Bookkeeping, Types of Revenues, Costs, Assets, and Liabilities, Revenue Recognition, Cost Recognition, Understanding the Big Picture: Why, What, When, and How Much, The Core Principles of Accounting, Practical Exercise: The Accounting Transactions of a Lemonade Stand, The Importance of Timing, Accounting - Preparing a Cash Flow Statement: Understanding Cash Flow Analysis, 3) Advanced Accounting - Trade Receivables, Inventory, Fixed Assets, Trade Payables, Financial Liabilities, Leasing Liabilities, Using Leverage, Raising Equity, Types of Equity, and Dividend Payments, 4) Assessment, 5) Financial Statement Analysis - Subtleties, Practical Case Study "Analyzing P&G's Financials", Tesla Exercise, 6) Working Capital Management, 7) Fundamentals of Business & Financial Analysis, 8) Business Analysis in Excel1, 9) The Time Value of Money and Interest Rate Components, 10) The Value of Cash Flows with Different Timing, 11) Finance 101 - Loan Calculations, 12) Capital Budgeting - Basic Notions, 13) Capital Budgeting - A Complete Case Study, 14) Tesla Practical Case Study - Building a Financial Planning Model, 14) Data Analysis with ChatGPT - Exploratory Data Analysis (EDA), Deal with Inconsistent Data, Organize Messy Data, Working with Functions, Clean Text Data, Dates and Time Data, Complete Practical Example, 15) PowerPoint - Introduction to PowerPoint, PowerPoint - Tips & Tricks That Will Transform You, and 16) Who Does What in the World of Finance?

Enroll today at (teams & execs welcome): https://tinyurl.com/57hyfy8n 

Download your free Finance, Accounting & Banking - Career Transformation Guide.

Much career success, Lawrence E. Wilson - Financial Certification Academy (share with your team)