Our Strategic Financial Analyst Training Program (SFA) is offered in the USA in collaboration with our affiliated strategic alliance partner ICIT, Canada, and is a very comprehensive practical hands on training, designed by professional working managers with extensive experience in large multinational organisation. This training aims to provide you equal to three years of work experience in a very short period of time. All this experience you will otherwise get in many years by working in different organisations. You are learning from the experience of the experienced. They know exactly what the requirements of the managers in those companies are, and they train you exactly for those. You work on same software, same templates and same large data files. You get all the skills, tools, knowledge and experience to work at any position from junior to senior level. This is a very effective program and gets you guaranteed interview calls.

We have trained and helped in placing many qualified, CPA, CGAs, CMAs, Graduates from Schulich, Western University and UFT. We also have trained and helped in placing non Accounting background candidates as well who are now very well settled.

Our students joined these companies

Program Outline

SFA Program covers the following modules. Each of these modules can be taken separately as well.

Excel Advanced skills are assumed in any jobs in Accounting and Finance. 90% of the work is Excel based. You need Advanced Excel modeling skills. Knowing just the tools like vlookup, Pivot, macros is not enough. We start from the very basic level and assume you have no Excel knowledge and take you to advanced modeling skills. Excel outline covered in SFA course is as follows.

Excel BeginnersLevel 1
Excel IntermediateLevel 2
Excel AdvancedLevel 3

Excel Modeling in practical scenario, office projects, complex models and reports.

To work as an Analyst or to work in Accounting and Finance field, you need experience in one major ERP. We cover SAP FI & CO modules.

Since reports in ERPs are very limited in scope, you need one Reporting tool to modify your data for top management for effective decision making. We cover BI (Business Intelligence), which is a very powerful and most used with SAP.

We cover the following in SFA course:

SAP FI (Financial Information)

  • General Ledger
  • Accounts Payable
  • Accounts Receivable
  • Assets
SAP CO (Controlling)

  • Cost Element Reporting
  • Cost Center Reporting
  • Profit Center
  • Profitability Analysis
  • Internal Orders including Projects
BI (Business Intelligence)

  • Concept of Database
  • What is BI and similar tools
  • Using BI queries to update reports
  • Using BI features
Month End Activities

  • Accruals
  • Prepayments
  • Bad debt
  • Reconciliation
  • Revenue Recognition
  • Intercompany Reconciliation
  • Head Count Reports
  • Fixed Assets Continuity Schedules
  • Allocation of cost, Shared services cost
  • Allocation of salaries based on FTE
  • Foreign currency transactions
  • Projects, Internal orders, settlement
Variance Analysis

  • Price / Volume variance
  • Primary and secondary drivers
  • Cost center analysis
  • Risk & Opportunity vs Timing
  • GM Analysis
Monthly Management Reporting

  • Flash Reports
  • Dashboard
  • Scorecard
  • MBR ( Financial Deck)
  • KPI Reports
  • MD&A Report
  • Rolling Cash Flow Forecast
Budgeting, Planning LE & Forecasting

  • Cost Center Planning
  • Capital Planning
  • GM Planning
  • Forecasting
  • Latest Estimates (LE)
  • Year to Go (YTG)
SOX ( Bill 198)

Role of Financial Analyst at the time of SOX implementation and in ensuring all the prescribed controls are being observed after SOX implementation.

In Association with
ICIT Canada
Meet Course Leader Mr. Ghufran Ahmad
Want to enroll?
Buy this course now!
Financial Analyst Practical Training Course(s)