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

11
Nov
GYANODAY-2017
register
26
Aug
HR Training
register
26
Aug
DIGITAL MARKETING
register
26
Aug
VBA WORKSHOP
register