Call nowContact us
  •  

     

    Advance Financial Analyst Training

    Course Duration : 2 Months / 64 Hours, Course Fee : 35000

    Advance Financial Analyst Training Course with SAP – FI / CO along with Project Management has been prepared by ACLM Institute of Professional Studies, to equip customers with the important structures of modelling that include equity valuation, deal analysis, and business valuation along with post project implementation. We believe these models provide a strong foundation to build other bespoke models such as warrant valuation, payroll models, and tax models as well as Industry-Specific Models like Real Estate or Oil & Gas that are often demanded as one advances in his/her career. The course structure has been designed to prepare customers to become efficient financial modellers. After the completion of the course, customers will be able to build comprehensive dashboard on financial models from scratch and use them to aid myriad decisions, including investing, financing, and dividend.

    Topics Covered

    Financial Modelling with Excel (24 Hrs.)
    • Advanced Formulas From Financial Section, Conditional Formatting, Data Filter & Validation, Basic & Advanced Charting, Class Projects, Using Tables / Pivot Tables, Identifying Bad Data, Data Automation - Macros & VBA, Excel Dashboard, Advanced Financial Modelling, Project Finance Model, LBO Model Overview

    SAP - FI/CO (32 Hrs.)
    • Introduction, Basic Settings, General Ledger, Accounts Payable, Accounts Receivable, Asset Accounting, Controlling, Internal Orders, Profit Centre Accounting (PCA), Profitability Analysis (CO-PA), Product Costing, Integration, Reports, Real Time Scenarios, Business Scenarios (Manufacturing)
    MS Project (8 Hrs.)
    • ERP MM Introduction, Basic Settings, Master Data, Procurement of Stock and Consumable Material, Optimized Purchasing, Optimized Purchasing, Inventory Management, Configuration, Physical Inventory, Message Output Determination, Release Strategies, Batch Management, Invoice Verification, Real Time Scenarios

    Who Should Attend

    • B.Com, M.Com, Eco, MBA, CA and CFA Aspirants / Candidates who want to pursue a career in finance, Undergraduates who want to bridge the gap between theory and practice, and learn about the work streams of a research desk, Working professionals who need to build or read end-to-end financial models to make recommendations or write reports, Professionals who want to switch career to finance or students who want to get a head start before taking up a job.

    Pre-requisites

    • Must have good knowledge of Excel(Be able to build and apply basic formulas in Excel, Pivot Table and Pivot Chart knowledge is helpful)
    • Any ERP-Tally/slash/Busy/SAP-FICO will be advantages

    What You Need To Bring

    • Notepad, Pen/Pencil, Laptop

    Key Takeaways

    • Completion Certificate
    • 100% assured Interview for the position of Financial Analyst (after clearing the Financial Modelling Test)
    • Intern ship Opportunity as per requirement (after clearing the financial modelling test)
    • Project Management PDUs.
    • Other Job Assistance
    • E-Book & Study Material - CDs
    • Two DVDs on “Learning the Art of Living by Padam Shri Shri Ravi Shankar

    About Trainer

    • VBA + MIS : Mr. Amit - (Having 17+ Years in data analysis and automation)
    • SAP - FI/CO : Mr. Sunny Singh - 10+ Years in SAP FI/CO (Consulting + Training)
    • Ms Project : Mr. Bhuvneshwar - 25+ Years in Project Modelling and Management
    .

    have a question?

    PAY FEE ONLINE BY :

    Schedule

    28
    Nov
    GYANODAY-2017
    register
    29
    Nov
    HR Training
    register
    29
    Nov
    DIGITAL MARKETING
    register
    30
    Nov
    VBA WORKSHOP
    register