Financial Analysis - April - FA S20

Service Description

What you will learn Build a 3-Statement Financial Model Use Pivot tables to analyze data Learn all types of Financial Ratio Analysis Most used Excel Financial Formulas Build a full Financial Dashboard Present your work in meaningful Dashboards Course Description In this course, you will learn how to use excel in daily financial functions like building a 3-statement Financial model (Balance Sheet, Profit & Loss, Cash Flow Statements) and use the famous NPV and IRR formuals in addition to excel formulas for calculating interest rates and use excel charts and pivot charts to present data in a visual way and also be able to create a professional presentation to hand your work. Choosing this course will enable you to analyze any financial statements, build a model, make all the necessary ratio analysis calculations, derive meaningful insights from it, and report to higher management. This course will enable you to work as a financial accountant and financial analyst in the Finance Department. Course Content Section 1: Creating a P&l from scratch Section 2: Professional charts in excel Section 3: Financial reporting Section 4: Building 3 statement model Section 5: Vertical Ratio Analysis Dashboard Section 6: Horizontal Ratio Analysis Dashboard Section 7: Financial formulas

Contact Details