Complete Financial Analyst Course

Colleagues, the “Complete Financial Analyst Course” will equip you in Excel, Accounting, Financial Statement Analysis, Business Analysis, Financial Math and PowerPoint. Learn to 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 … more. Skill-based 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, Completing the 3-Statement Model, 2 Accounting - Introduction to Accounting & Bookkeeping - Types of Revenues, Costs, Assets, and Liabilities, Revenue Recognition, Cost Recognition, Core Principles of Accounting, Practical Exercise: The Accounting Transactions of a Lemonade Stand, The Importance of Timing, Preparing a Cash Flow Statement, Understanding Cash Flow Analysis, Trade Receivables, Inventory,  Fixed Assets Trade Payables, Financial Liabilities, Leasing Liabilties, Using Leverage, Raising Equity, Types of Equity, and Dividend Payments, 3) Subtleties, Practical Case Study "Analyzing P&G's Financials", Financial Statement Analysis - Tesla Exercise, 4) Working Capital Management - Fundamentals of Business & Financial Analysis, Business Analysis in Excel, 5) Finance 101 - The Time Value of Money and Interest Rate Components Finance, The Value of Cash Flows with Different Timing, Finance 101 - Loan Calculations, 6) Capital Budgeting - Basic Notions, Capital Budgeting - A Complete Case Study, Tesla Practical Case Study - Building a Financial Planning Model, 6) 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, 7) PowerPoint - Introduction to PowerPoint and Tips & Tricks That Will Transform You Into An Advanced User. 

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

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

Much career success, Lawrence Wilson – Financial Certification Academy (share with your team)