Advanced Financial Analyst Training by IIM Alumni Free SAP FICO Certification
Certification
Industry acceptable certification for all training which help fresher/Experienced to up-skill at corporate.
Experienced Faculty
Techno- Functional Analyst from Top B-collage with 10+yrs of Experience conduction the Training Classes.
Placement Assistance
After completion of 70% training our dedicated placement team arrange interview till placement.
Lab Facility
Practical Training help to gain exposure like corporate level with technical test series
Workshop Sessions
Real time projects & best case study makes SLA workshop very unique and lively for learners.
Admin Support
For Learner’s, Our admin team fresh batch schedule/re-scheduling classes/arrange doubt classes.
Financial Modelling Course
Financial Analyst Course Certification
Module-1 Basic & Advanced Excel
Module-1.1 Advanced Data Handling & Cleaning
Purpose: Real-world datasets are messy. Learn to clean, transform, and prepare data efficiently.
Topics Covered
- Data Cleaning Techniques
- Data Protection Techniques
- Removing Duplicates, Blanks, and Errors
- Text-to-Columns and Flash Fill (AI Functionality in Excel)
Industry Functions
- Text & String Functions: TRIM, CLEAN, SUBSTITUTE, TEXT, LEFT, RIGHT, MID, LEN
- Case Formatting Functions: UPPER, LOWER, PROPER
- Search & Replace Functions: FIND, SEARCH, REPLACE, VALUE, TEXTJOIN
- Error & Logical Validation Functions: IFERROR, ISNUMBER, ISTEXT, ISBLANK
- Date & Time Functions: DATEDIF, EDATE, EOMONTH, NOW, TODAY, DAY, MONTH, YEAR, HOUR, MINUTE, SECOND
Additional Concepts
- Using Data Validation for Input Control
- Dynamic Data Validation
Module-1.2 Advanced Formulas & Logical Functions
Purpose: Build dynamic, decision-based reports and formulas used across corporate functions.
Industry Functions
- IF, IFS, SWITCH
- AND, OR, NOT
- CHOOSE, INDEX, MATCH, XLOOKUP
- OFFSET, INDIRECT
- Dynamic Array Functions: FILTER, SORT, UNIQUE, SEQUENCE
- Nested IF and Multi-Condition Formulas
Module 1.3: Data Analysis & Business Metrics
Purpose: Learn to analyze, summarize, and interpret business data effectively.
Topics Covered
- Understanding and Creating KPIs
- Summarizing Large Datasets
Industry Functions
- SUMIFS, COUNTIFS, AVERAGEIFS
- SUBTOTAL, AGGREGATE
- LARGE, SMALL, RANK
- ROUND, ROUNDUP, ROUNDDOWN
Module 1.4: Advanced Lookup & Reference
Purpose: Master data linking across sheets and files — essential for analytics and reporting.
Topics Covered
- VLOOKUP vs XLOOKUP (with practical applications)
- Dynamic Range Referencing using INDEX-MATCH
- Cross-Workbook Linking and Handling Broken Links
Module 1.5: Data Visualization & Dashboards
Topics Covered
- Chart Design Best Practices
- Dynamic Charts with Form Controls
- Combo Charts, Sparklines, Conditional Formatting
- KPI Indicators (Traffic Lights, Data Bars, Icons)
- What-If Analysis for Business Scenario Testing
Module 1.6: Pivot Tables & Pivot Charts
Purpose: Master Excel’s most powerful tool for data summarization and analysis.
Topics Covered
- Creating and Customizing PivotTables
- Calculated Fields and Items
- Grouping by Date, Month, and Quarter
- Using Slicers and Timelines
- Creating Hundreds of Pivot Tables in Seconds
- Making Complex Pivot Tables Neat and Insightful
Module 1.7: Power Tools in Excel (for Analysts)
Purpose: Use Excel’s advanced BI tools for large-scale analytics and automation.
Topics Covered
- Power Query (Merge, Append, Clean Data)
- Power Pivot (Data Models, KPIs, Measures)
- Connecting Excel with External Data Sources (CSV, SQL)
- Introduction to RDBMS, Primary & Foreign Keys
- Building Table Relationships and Data Modelling
Module 1.8: Professional Efficiency & Productivity
Purpose: Work faster, smarter, and more accurately.
Topics Covered
- Advanced Shortcuts for Data Analysts
- Named Ranges, Dynamic Arrays
- Workbook Linking, Auditing, and Error Tracing
- Formula Debugging and Error Checking
- Version Control, Backup, and Template Creation
Module 1.9: Excel Integration & Productivity
Purpose: Integrate Excel with modern tools and leverage automation and AI.
Topics Covered
- Excel with Google Sheets (Cloud Collaboration)
- ChatGPT + Excel (AI-Assisted Formula Writing)
- Excel with SQL (Data Import & Export)
- Learning Techniques for Excel Shortcuts
- Universal vs Non-Universal Shortcuts
Module 1.10: Excel Integration & Productivity
Purpose: Build professional, interactive dashboards.
Topics Covered
- Creating Different Types of Charts
- Designing Advanced Dashboards Using Summarized Data
- Dynamic Dashboards with Form Controls
Assignments & Live Projects
Hands-On Practice
Module-2-VBA Macros – Excel Automation
Introduction
- Flowcharts
- Step-by-Step Instructions
- Process Flow Diagrams
- KPIs
- Algorithms
VBA/Macros Basics to Advanced
Subs, Functions, Variables, Arrays, Loops, Logic,Arrays etc
- Excel Macro Language Review (VBA) Including Variables, Data Types, Constants, Arrays, Operators, Expressions, Loops, Logic Decisions and Calling
- Overview Of Commanding Excel Using VBA Including
- A Discussion Of Objects, Properties and Method
- The Power of Macros – What, When, How to use Macros.
Introduction to Object Oriented Concepts
- Objects, Its Functions, Methods and Properties Introduction to Events
- Details of Events, How & When to use of Events, Preparing to ‘Macro’ Visual Basic Editor (VBE) –Developer Tab, Security
- Introduction to the VBE, Properties window, Project Explorer, Password Protection of Code How to use the VBE – Features, Options, Intelligence Technology
- Debugging Mode, Bookmarks, Breakpoints, Watch Window, Immediate Window and Locals Window Inbuilt VBE Help Feature – Tips and Tricks
- Form Controls vs. ActiveX Controls
- Getting into the Code
- Message Box and Input Box Working with Data in Excel through VBA
Data Types
- Constants and Variables
- Different type of data type; How and When to use Variables to Store Information.
Loops
- For-Next, For-Each, Do-While, Do until, Do Loop Decision-Making and Code Branching
- If-Then-Else,
- Select-Case
- And
- Nested Conditions
- What is user’s Defined Functions?
- How to create & use them
Arrays
- Use of Arrays in VBA programming with one dimensional, two dimensional or multi-dimensional analysis
Excel VBA Power Programming For VBA Macros
- Working with Dynamic Ranges. Protecting Worksheets, Cells and Ranges. Working with Multiple Files. Opening & Saving Files
- How to Analyze Data On Multi Worksheets And Build Summary Sheets
- How to Access The Windows File And Folder System To Open And Close Workbooks
- How to Protect Your Code Against Errors
- How to Use Excel And VBA To Create Basic Dash Boards
- How to Create Your Own Custom Business Worksheet Functions In VBA
- How to Create Basic Report Generation Tools Using Excel VBA, Microsoft Word And PowerPoint
- How to Use The Excel Visual Basic Macro Recorder To Record Excel Tasks In VBA And Then Interpret The Code
Overview of User forms To Create Business Wizards
- Working with User Forms & User Forms Events like List box, Combo box, Option Buttons, Check box, Text box, Labels, Command button, Toggle button.
- How to create dynamic dashboard on user form with different controls
- How to link various user form with each other to create a complete interface between user and system
Connection between Excel VBA & other platforms
- How to Establish Connection Between VBA and Internet Explorer to Open any Internet Website through VBA
- How to Establish Connection Between Excel VBA and power presentation to create power point through VBA
- How to Establish Connection Between Excel VBA and Access database to update the data in access through VBA
- How to Establish Connection Between Excel VBA and MS Word through VBA
Testing and Debugging Your Code
- Types of Errors
- Using Breakpoints
- Debugging Techniques
Dialogue Boxes
- UsingMsgBox Function
- UsingInput Box Function
- Working with FileDialog
- Working GetOpenFile name Method
- Working GetSaveAsFilename Method
Effective Error Handling
ChatGPT AI for Excel and VBA
Live Project on VBA Macros
Module 3 - SQL Programme Modules
Module 3.1: Introduction To Databases & SQL
- What Is A Database?
- Types Of Databases (Relational, Non-Relational)
- What Is SQL? SQL Command Categories (DDL, DML, DCL, TCL)
Module 3.2: Database & Table Creation
- Creating Databases // Creating Tables
- Data Types In SQL
- Keys & Constraints: Primary Key, Foreign Key, NOT NULL, UNIQUE, CHECK, DEFAULT
Module 3.3: Insert, Update & Delete
- INSERT Statements
- UPDATE Statements
- DELETE Statements
Module 3.4: Basic Data Retrieval
- SELECT Statements
- Selecting Specific Columns
- Aliases (AS)
- DISTINCT Keyword
Module 3.5: Filtering Data
- WHERE Clause
- Comparison Operators
- Logical Operators (AND, OR, NOT)
- LIKE Pattern Matching
- IN, BETWEEN, IS NULL
Module 3.6:Sorting & Limiting
- ORDER BY
- Sorting By Multiple Columns
- LIMIT / TOP / FETCH
Module 3.7: Aggregate Functions & Grouping
- GROUP BY
- HAVING Clause
- COUNT(), SUM(), AVG(), MIN(), MAX()
- GROUP BY With Aggregates
- Filtering Aggregates (HAVING)
Module 3.8: SQL Functions – String
- CONCAT()
- LENGTH() / LEN()
- LOWER() / UPPER()
- SUBSTRING() / SUBSTR()
- TRIM(), LTRIM(), RTRIM()
- REPLACE()
- INSTR() / CHARINDEX()
Module 3.9: SQL Functions – Date/Time
- NOW(), CURRENT_TIMESTAMP
- CURRENT_DATE, CURRENT_TIME
- DATEADD(), DATEDIFF()
- EXTRACT()
- DATE_FORMAT(), FORMAT()
- DAY(), MONTH(), YEAR()
Module 3.10: SQL Functions – Math
- ABS(), ROUND()
- FLOOR(), CEILING()
- POWER(), SQRT()
- RAND()
Module 3.11: SQL Functions – Conversion
- CAST(), CONVERT()
- TO_CHAR(), TO_DATE()
Module 3.12: SQL Functions – Conditional
- CASE Expression
- NULLIF(), COALESCE()
- IIF()
Module 3.13: SQL Functions – Window
- PARTITION BY
- ORDER BY (Window)
- ROW_NUMBER()
- RANK(), DENSE_RANK()
- FIRST_VALUE(), LAST_VALUE()
Module 3.14: Working With Joins
- Inner Join // Left Join // Right Join
- Full Join // Self Join // Cross Join
- Left Anti Join // Right Anti Join
Module 3.15: Sub queries
- Subqueries In WHERE
- Subqueries In SELECT
- Subqueries In FROM
- Correlated Subqueries
Module 3.16: Views
- Creating Views
- Updating Views
- Dropping Views
Module 3.17: Introduction To RDBMS
- What Is An RDBMS?
- DBMS Vs RDBMS
- Features Of RDBMS
- Popular Systems: MySQL, PostgreSQL, SQL Server, Oracle
Database Concepts
- Tables, Rows, Columns
- Schemas & Catalogs
- Primary & Foreign Keys
- Candidate & Composite Keys
Data Models
- Relational Model
- Entities & Attributes
- 1-1, 1-Many, Many-Many Relationships
- ER Diagrams
Module 3.18: SQL Server Agent (Job Scheduling)
- Overview Of SQL Server Agent
- Creating A Job
- Adding Job Steps
- Creating A Schedule
Module-4 - MS Access
Module 4.1: Introduction to MS Access
- What is MS Access?
- Features of MS Access
- Understanding the Access interface
- Databases, tables, objects overview
- Differences between Access and other RDBMS
Module 4.2: Database Fundamentals
- Creating a new database
- Database file types (.accdb, .mdb)
- Opening, saving, and closing databases
- Navigation Pane & object organization
Module 4.3: Tables in MS Access
- Creating tables (Design View / Datasheet View)
- Field names and data types
- Field properties (size, format, input mask)
- Primary key selection
- Creating lookup fields
- Table relationships overview
Module 4.4: Data Types & Field Properties
- Short Text, Long Text // Number, Large Number
- Date/Time, Currency // Yes/No
- Hyperlink // Lookup Wizard // Attachment
- Field validation rules
Module 4.5: Working With Data
- Adding records
- Editing records
- Deleting record
- Sorting & filtering data
- Searching records
Module 4.6: Keys & Relationships
- Primary keys // Foreign keys
- One-to-One relationships // One-to-Many relationships
- Referential integrity // Relationship window
Module 4.7A: Queries – Types of Queries
- Select Queries
- Action Queries (Append, Update, Delete, Make-Table)
- Crosstab Queries
- Find Duplicates Queries // Find Unmatched Queries
Module 4.7B: Queries – Concepts
- Query Design View // Adding criteria
- Sorting, filtering //Using expressions
- Calculated fields
Module 4.8: Forms
- Introduction to forms
- Creating forms (Form Wizard, Design View)
- Form layouts
- Controls (Text box, Combo box, Buttons)
- Binding forms to data // Navigation forms
- Subforms
Module 4.9: Reports
- Creating reports // Report Wizard // Grouping & sorting
- Headers & footers // Summary reports
- Printing & exporting reports
Module 4.10: Importing & Exporting Data
- Import from Excel // Export to Excel
- Importing text files // Linking tables (external data)
- Connecting to SQL databases
8 Major Points to Learn MS Access in Analytics
- Easy Data Management for NonTechnical Users
- Relational Database Capabilities
- Connecting to SQL databases
- Powerful Querying (SQL Support)
- Perfect for Small & Medium Projects
- Integration With Excel & Business Tools
- Forms & Reports for Business Insights
- Automation Through Macros & VBA
- Best for Teaching Structured Data Concepts
Module 5: Financial Statements & Corporate Finance
Module 5.1 – Advanced Financial Statements Analysis
Introduction to Financial Statements and Navigating the Annual Report
- P/L, B/S, C/F statements reflecting operating, financing and investing activities of a business.
- Understanding the purpose
- Understanding of key headers and sub-headers
- Format of the financial statements
- General Accounting Principles and best practices
Common size Analysis
- Horizontal
- Vertical
Financial Ratios
- Activity ratios
- Liquidity ratios
- Solvency ratios
- Profitability ratios
- Rate of return
- DuPont Analysis
- Other important ratios
- Pro Forma Analysis and basic Projection technique
Pro Forma Analysis and Basic Projection Technique
Common Pro Forma Statements:
- Pro Forma Income Statement
- Pro Forma Balance Sheet
- Pro Forma Cash Flow Statement
- Basic Projection Techniques
Trend Analysis
- Percentage of Sales Method
- Regression Analysis
- Moving Averages & Smoothing
- Scenario Analysis
Module 5.2: Advanced Corporate Finance
Time value of Money
- NPV and IRR
- Future Value Excel formulas like NPV, XNPV, IRR, XIRR, PV, FV, etc
Understanding of Debt and Tax shield
- Tokenization Understanding schedules for debt repayment and interest repayment
- Developing the schedules on excel
Measure of Leverage
- Impact of leverage on cost of capital
- WACC Understanding tax shield
PCAPM model and Beta calculation
- Understanding of Beta
- Levered and Unlevered Beta
- Calculation of levered Beta
- Calculation of cost of equity
Free Cash Flow
- Free Cash flow to Firm
- Free Cash flow to Equity
- Future Value Excel formulas like NPV, XNPV, IRR, XIRR, PV, FV, etc
Valuation
- DCF Valuation
- Relative Valuation
- Transaction Valuation
Application of these techniques with real case studies
Module 6: Financial Modeling
Module 6.1 – Advanced Financial Modeling
Introduction and Context
- Understanding an integrated financial Model
- Building Integrated Model
Financial Statements & Projections for an Equity
- Creating a template for integrated model
- Making Assumptions for forecast
- Developing various schedules
- Depreciation – Capital Expenditure Phasing, SLM and % methods
- Working capital
- Debt and Interest
Module 6.2 – Integrating all the Financial Statements
Module 6.3 – Summarizing Financial Statements Technique
Module 6.4 – Case Study
Building Integrated Model – Financial Statements
- Building Integrated Model – Valuation
- Using DCF and comparable
- Summarizing financial statements
Financial Projections
- Advanced Modelling concepts and technique
- Common Modeling errors- circular reference errors to avoid
Module 6.5 – Application of these techniques with real case studies
Module-7 - Financial Data Visualization with MS Power BI or AI – Any One
Module 7.1 – MS Power BI
Module 7.1.1: Microsoft Power BI – Introduction
- What is MSPBI& Scope
- Learn the common work flow in Power BI
- Building blocks of Power BIand its relations
- Quick demo how to create a business dashboard in MSPBI
- MSPBI components
Module 7.1.2: MS Power BI – Getting Business Data
- Get data in shape for use with Power BI
- Combining two or more data sets (source data) for reporting
- Tackling messy data in MS Power BI
- Clean &Transform data
Module 7.1.3: MS Power BI -Data Visualization
- Create and customize visualization
- Use combination charts
- Create and format slicers
- Map visualizations
- Visualizations utilization
- Use tables and matrixes
- Long live bubbles
- scatter charts in action
- Advanced funnel and waterfall charts
- Drive fast dashboard insights with gauges and numbers
- Color your visualization world with colors
- shapes and scales
- Adding personal touch
- logo etc. to reports and dashboards
- Display and present your dashboard in a way you want with summarize data
- Control how your report elements overlap with each other
- Learn to drill into hierarchies
- Manage how levels are shared (Z-order in reports)
- How to use R visuals in MSPBI
Module 7.1.4: MS Power BI -Data Exploring & Sharing
- Quick insights in Power BI Service
- Create and configure a dashboard
- Share dashboard with your organization
- Display and edit visuals- tiles
- full screen
- Get more space on your dashboard
- Install and configure a personal gateway
- Excel and MSPBI
- Import and excel table into Power BI
- Import excel files with data models and power view sheets
- Connect One Drive for business to MSPBI
- Excel data in Power BI summary
Module 7.1.5: MS Power BI – DAX (Data Analysis Expression) Application Setting up Data Models with DAX
- DAX for creating tables and columns
- Rows vs. query vs. filter context
- DAX for calculated tables and columns
- Creating a date table
- Calculated column for costs
- Data cleaning with DAX
- Connecting data from different tables
- Methods to create DAX measures
- Advantages of explicit measures V2
- DAX and measures
- Using variables
- Basic statistical measures
- Quick measures
Module 7.1.6: Power BI – Common DAX Measures
- Filtering and counting with DAX
- Understanding different filter functions
- Using different filters with DAX
- Filter ALL the data
- Calculating with a filter
- Analyzing across dimensional tables
- Iterating functions
- DIY iterating functions
- Iterating functions in Power BI
- Practice with iterating functions
- More iterating functions
- Use of RANKX()
Module 7.1.7: Power BI – Redefine DAX
- Logical functions
- Interpreting SWITCH()
- Logical functions in Power BI
- IF() for formatting tables
- Exploring SWITCH()
- Grouping
- Row-level security
- Applying row-level security
- Managed roles in Power BI
- Creating an email list
- Implementing RLS
Module 7.1.8: Power BI – Advanced DAX
- Table manipulation functions
- Summary of SUMMARIZE()
- Table manipulations using DAX
- SUMMARIZE() the facts
- ADDCOLUMNS()? No problem!
- Time intelligence functions
- Time intelligence functions output
- Time intelligence in Power BI
- Use of TOTALYTD()
- Use of SAMEPERIODLASTYEAR()
Module 7.2 – Artificial Intelligence
Module 7.2.1: Introduction to Artificial Intelligence
- What is AI? History and Evolution
- Types of AI: Narrow, General, Super AI
- Key Terms: Machine Learning, Deep Learning, NLP
- Real-world Applications of AI
- Future of AI
Module 7.2.2: Mathematics & Logic Foundation
- Basics of Linear Algebra (Vectors, Matrices)
- Probability and Statistics
- Logic & Set Theory
- Graph Theory Basics
Module 7.2.3: Programming for AI
- Introduction to Python
- Python Libraries: NumPy, Pandas, Matplotlib
- Basic Programming Exercises (AI-focused)
Module 7.2.4: Machine Learning Basics
- What is Machine Learning?
- Types: Supervised, Unsupervised, Reinforcement Learning
- Common Algorithms: Linear Regression, KNN, Decision Trees
- Train-Test Split & Model Evaluation
Module 7.2.5: Data Handling for AI
- Data Collection and Cleaning
- Data Preprocessing Techniques
- Feature Selection & Engineering
- Data Visualization with Matplotlib/Seaborn
Module 7.2.6: Introduction to Neural Networks
- Basics of Neural Networks
- Activation Functions
- Forward & Backpropagation (Conceptual Level)
- Introduction to TensorFlow / Keras
Module 7.2.7: AI Tools and Platforms
- Google Colab & Jupyter Notebooks
- Intro to Scikit-Learn
- Basics of ChatGPT / OpenAI Playground
- Overview of AutoML Tools
Module 7.2.8: AI Tools and Platforms
- AI Bias and Fairness
- Ethics in AI Development
- AI in Society: Jobs, Education, Healthcare
- Emerging Trends (AI + IoT, AI + Cloud, etc.)
Mini Project
Module-8 - SAP FICO Analyst & SAP S/4 HANA Finance with AI
Module 8.1 – SAP FICO Analyst
Module 8.1.1: Introduction
- ERP & SAP Overview
- SAP FICO role in financial operations
- FI vs CO overview
Module 8.1.2: General Ledger (GL)
- Organizational structure in FI
- Chart of Accounts, Fiscal Year Variant
- Document posting & posting keys
- Recurring entries, Accrual/Deferral
- Foreign currency & parallel ledgers
- Financial reporting
Module 8.1.3: Accounts Payable (AP)
- Vendor master data
- Invoice posting, credit memo, down payments
- Payment terms & Automatic Payment Program (APP)
- Withholding Tax / TDS
- Vendor reports
Module 8.1.4: Accounts Receivable (AR)
- Customer master data
- Invoice posting, credit memo, incoming payments
- Dunning & interest calculation
- Customer credit management
- AR reports
Module 8.1.5: Asset Accounting (AA)
- Asset master data
- Acquisition, transfers, retirement
- Depreciation keys & depreciation run
- Integration with GL
- Asset reports
Module 8.1.6: Controlling (CO)
- Cost element accounting
- Cost center accounting
- Internal orders
- Profit center accounting
- Profitability analysis (CO-PA)
- Product costing
Module 8.1.7: Controlling (CO)
- Financial Closing Cockpit
- Consolidation basics
- Cash & Bank accounting
- Integration with SD, MM, PP
- Taxation (GST/VAT basics)
Module 8.2 – SAP FICO Analyst
Module 8.2.1: Overview of S/4HANA
- Difference between SAP ECC vs S/4HANA
- Data model simplification
- Universal Journal (ACDOCA)
- Business Partner approach
Module 8.2.2: General Ledger (GL) in S/4HANA
- Ledger approach with multiple currencies
- Real-time FI-CO integration
- Universal Journal postings
- Parallel accounting
Module 8.2.3: Accounts Payable in S/4HANA
- Vendor as Business Partner
- Invoice processing
- Advanced Payment management
- Integration with Treasury
Module 8.2.4: Accounts Receivable in S/4HANA
- Customer as Business Partner
- Cash application (Machine Learning)
- Predictive collections
- Real-time reconciliation
Module 8.2.5: Asset Accounting in S/4HANA
- New depreciation calculation engine
- Real-time postings to Universal Journal
- Parallel valuation in assets
Module 8.2.6: Controlling in S/4HANA
- Margin Analysis vs Costing-based CO-PA
- Real-time CO reporting
- Simplified cost elements
Module 8.2.7: Advanced S/4HANA Finance
- Group Reporting (Consolidation)
- Central Finance basics
- Cash management & liquidity planning
- Treasury & Risk management basics
Module 8.2.8: Reporting & Analytics
- Fiori apps for Finance
- Embedded Analytics with HANA
- Real-time dashboards
Module 8.2.9: AI in Finance (Basic Layer)
- SAP AI Business Services overview
- Document Information Extraction (OCR for invoices)
- Predictive Accounting in S/4HANA
- AI-based Cash Forecasting
- Chatbots
Find the Financial Modelling in Excel course details below. Classes and Course can be designed/customize as per request
Duration of Module
| Financial Modelling Course Module | Duration |
|---|---|
| Financial Analyst | 110-120 (Hours) |
Batch Timings
| Financial Modelling Course Schedule | Course Timing |
|---|---|
| Monday to Friday | 8:00 AM – 10:00 AM |
| Monday to Friday | 10:00 AM – 12:00 PM |
| Monday to Friday | 2:00 PM – 4:00 PM |
| Monday to Friday | 4:00 PM – 6:00 PM |
| Saturday/Sunday | 8:00 | 12:00 | 2:00 | 4:00 |
| Sunday | 8:00 AM – 10:00 AM |
| Sunday | 10:00 AM – 12:00 PM |
| Sunday | 2:00 PM – 4:00 PM |
| Sunday | 4:00 PM – 6:00 PM |
Download Data Analyst Course Brochure
FAQ
What is the total duration of the course?
The Financial Modeling in Excel Training is divided into 4 different modules + report which takes 135 hours to complete. It can take up to 6 month depending upon the class preference of the student.
What if I miss any class?
If you miss any class or fall behind you can request for backup classes and our administration will arrange it for you. The backup class will be scheduled as per the availability of the teacher.
Do provide valid certification after the training?
All the participants are awarded with a valid certification upon completion of the training that offers them competitive edge during interview and help them secure a high paying job.
How to register for the course?
Interested candidates can submit the quotation on our official website and we will give you a call within 24 hours or you can directly visit our centre in Noida and get yourself enrolled by providing the first installment of the course fee through cash, debit card or credit card, net banking or e-wallet.
Do you provide practical classes as well?
All the participants receive practical classes under expert supervision with live examples and projects that offers them in hand experience and comprehension in Financial Modeling.
What kind of job placement assistance you provide?
We have a dedicated team of placement who provide Interview preparation and personality development skills to the participant and send them to associated companies for job interviews until the participant get selected.
Testimonials
Aditya Pratap
I’ve completed the MIS training from SLA Consultants and now I believe that SLA provides excellent & quality training. I got placed in a reputed company with complete placement support provided the SLA placement team.
Bhavani Singh
The experience with SLA was phenomenal. It trained me to become industry ready and exposed me to various important work practices. The staff is extremely cordial and cooperative. The faculty members are the experienced and experts in the subjects taught by them. I thank SLA for the quality services and placement assistance provided by them.
Rajesh Pratap Singh
I’ve joined SLA Consultants for Advance excel and VBA It helps me to move my career. Especially Anoop Sir is very good teacher and his teaching style is awesome. One thing I want to tell you about new joiners who has no experience in Industry, they can build-up their career platform through SLA Consultants.
Abhishek Bharti
I have great experience in SLA Consultants for Excel and VBA Macros with expert trainers.
Ibadat Hussain
I want to tell you all that SLA Consultants had made my life. I was just a graduate with not so good marks when I came to them. They trained me, helped me learn and now I am a successful Accounts Executive. I hope you enjoy the Accounting Course as much as I did.
Kumar Gautam
I joined MIS/VBA training at SLA. This type of practical oriented classroom training is very helpful & who’ll follow Anoop sir classes with this approach ensures that they will learn completely about subject in short period of time. “SLA Consultants” is the best for learning job-oriented classroom programs. Thanks to Anoop sir and Swati for the best placement support.
Abhishek Pandey
SLA Consultants is a great place for young students who want a job without spending a lot of money. I have learnt a lot there and they helped me get a stable job in a company of my choice. I will forever be thankful to them for guiding me towards a great career path and helping me make a good life for myself.
Deepak Sharma
I have completed Advanced Excel & Visual Basic Automation training course from SLA Consultants. I had amazing experience after completion of training program and I would like to say thanks to the trainer, who elaborate solution for all the problems very quickly at the same time with very easy Technic to better understanding. Trainers are very kind and helpful. I would like to rank him 5 out of 5. I am so much obliged and feeling grateful, thanks a ton for the great support by trainers and thank you SLA Consultants.
Deepak Sharma
There are a lot of fake training institutes in Delhi but SLA Consultants is not one of them. SLA Consultants is a reliable institute that has a great team and awesome trainers who helped me settle in life by allowing me to work for the reputed Taj Group.
Ashish Tiwari
All trainers and staff are so good especially want to say thanks to Swati Ma’am, She always Co -operates me.
Gauri
People say that the job of an HR Generalist is very tough as the person has to take on multiple roles. Thanks to SLA Consultants, I did not feel that I cannot take on multiple roles. The trainers made me a superstar and I can deal with any HR issue right now as the trainers have shared extensive knowledge with me.
Anil Kumar Pal
Thanks to SLA consultants, my company values me a lot. I can churn out data from a huge database within a few minutes and keep the management happy. The ever cooperative trainers of SLA have made me capable of doing that and I will be grateful to them.
Santosh Kumar
When I joined, I didn’t have a clue about MIS Management and now my friends call me an expert of MIS. All thanks to SLA Consultants who filled me with great knowledge and software training without charging a lot of money.
Anil Kumar
It was one of the best decisions to join SLA consultants for my course. The course that I pursued here was very well planned and executed. I’m highly satisfied with Anoop Sir. The lectures were easy to understand & industrial based & every doubt of mine was properly explained. I would recommend SLA consultants to all those who are willing to grow in their careers and do well.
Tanzeel Mohammad
They actually do what they commit, I took classes for HR Generalist training & I am really satisfied with trainers as he explained every topic in very efficient way. Now I am utilizing his guidance and also SLA committed me that they will provide me the good placement opportunities and they did as they said. So, I am really satisfied with the classes and their efforts for SLA students.
Pawan Gupta
I think SLA Consultants is the best place for skill development. They made me a professional from a fresher and I have seen them do the same for hundreds of students. I highly recommend them to very student or professional seeking career growth.
Amrisha Priya
The SLA Consultants team is outstanding. They really help the students to achieve their objectives. I joined SLA and learnt all the desirable concepts which helped me to secure the right place in my career. I strongly recommend the students to join SLA and thus they will be able to shape their careers.
Kapil Negi
Data Management has always attracted me. SLA Consultants turned this hobby in a professional skill by teaching me all about MIS Management. I got a good job now and I am very happy with my life.
Bharti Sharma
People say that the job of an HR Executive is very tough as the person has to take on multiple roles. Thanks to SLA Consultants, I did not feel that I cannot take on multiple roles. The trainers made me a superstar and I can deal with any HR issue right now as the trainers have shared extensive knowledge with me.
Sharmistha Das
Great Institute with great teaching faculty. It has good placement. Satisfied after studying from this institute. It is the best hr training institute.
Inderveer Singh Verma
Integrated training & Career support of SLA Consultants made my career more joyful and gave me an opportunity to work with Apollo Hospitals Enterprise Ltd. Senior Executive (Accounts & Finance) at Apollo Hospitals Enterprise Limited Unit-Pharmacy
Rashmi Pal
SLA Consultants made me a better HR professional in just a few weeks. I am proudly working as an HR Payroll Executive now and have a team under me. I am really thankful to them for their constant support before and after the completion of the course.
Rajbir Sharma
SLA Consultants played the role of a friend, philosopher and guide in my career. They helped me learn complex software and complicated terminologies in such a manner that I now excel at MIS Management. I also love the job they have helped me get.
Rahul Pal
From my point of view, I’ll strongly recommend SLA Consultants, Training Institute for Analyst courses. I am pursuing my Data Analyst Course from the institute under the guidance & knowledge of Data Analyst trainers, my two modules (Advance Excel and VBA) of the course has been completed. I must say, they have good training faculty, as well as have the great infrastructure for learning and practicing.
Archit Khandelwal
Thanks to SLA consultants for giving me such type of opportunity, Great Institute with great teaching faculty. SLA is one of the class-apart institutions for those who learn something. I got a job in Fortune marketing Pvt Ltd as MIS Executive. SLA give me the confidence of ” I CAN “
Amit Kumar
I hope, my review may help to those who are searching for an institution where they can enhance their skills and get a placement as well. I have joined SLA Consultants for complete MIS course, my trainer is one of the best teacher of my life. Who are searching for an institute joined it immediately without hassle & wasting your time. Trainer will teach you both theoretical as well as practical knowledge, also prepare you for interviews. The best thing about trainer is that they help you even after you completion of your course, share queries on e-mail or Whats-App your query and you will get your problem resolved. My over all experience was awesome.
Ashutosh Saini
After I completed my schooling, I had no idea about what should I do. Then a friend told me about SLA and that was that. They helped me become a number wizard and taught me everything about Accounting which helped me get a good job at a place near my house and has made my life.
Arshad Khan
SLA Consultants made me a better HR professional in just a few weeks. I am proudly working as an HR Manager now and have a team under me. I am really thankful to them for their constant support before and after the completion of the course.
Md Sadik
SLA Consultants played the role of a friend, philosopher and guide in my career. They helped me learn complex software and complicated terminologies in such a manner that I now excel at MIS Management. I also love the job they have helped me get.
Indresh Kumar
I didn’t know anything about MIS management when I joined SLA Consultants. They helped me to learn the craft of managing, sorting and presenting data and now I am a valuable asset in my company. Thank You, SLA Consultants. I will always be grateful to you.
Vineet
I dreamed of making a career in HR but I did not want to go into a core recruitment job role. This is where SLA helped me. The trained made me a multitasker by teaching me all aspects of HR from payroll to labor law. This training helped me make my dream of working as a HR professional come true.
Anand Kumar Jha
My love for Data Management was turned into a career opportunity by SLA Consultants. They helped me learn all latest MIS software and made me a champion of Data Management. I have a great career path thanks to the SLA Team.
Kedar Pradhan
I joined MIS/VBA training at SLA Consultants. This type of practical oriented classroom training is very helpful for everybody and who will follows Anoop sir classes with practical orientation approach regularly. Finally in my words “SLA Consultants” is the best for learning professional or job oriented classroom programs.
Rachna
I wanted to make my career in HR but could not afford to do an MBA course. SLA Consultants provided me with theoretical as well as practical training in HR and I am working as HR Executive with a reputed company now even without an MBA. Thanks SLA. You made my life easier.
Neeraj Gupta
SLA Consultants is too good & very helpful. If u want to achieve something in your life so please join today SLA Consultants. Especially I would like to thank Swati Mam, Anoop Sir.
Rahul Kumar
I have done MIS & VBA Training form SLA Consultants under the guidance of MR. ANOOP YADAV, he has a very good knowledge & experience in Corporate & MNC. He is professional Trainer & his way of teaching is as per the corporate requirement. I’d great experience for me to grow my skill & work efficiency. It is very good pelt from who wants to build-up their career in MIS.
Rohit Bhagat
I strongly recommend SLA Consultants – Training Institute for doing courses. I am pursuing my Data Analyst course in SLA Institute, Head Office, till now my two modules(Advanced Excel and VBA) have been completed. Its been good experience with a trainer, as they shared me a lot of knowledge in brief. At institute the trainers and admin staff is good.
Rohit Kumar
Very good experience continuing to learn course from SLA CONSULTANT INDIA and join a company through SLA consultant India in mid during course. Thanks supporting staff like Prashant and Swati!
Vinay Tiwari
My experience in SLA is quite well.I have taken classes for both modules Advance Excel and VBA Macros. Whenever I raised for any doubt and to be honest my all queries and doubt were sorted out patiently. I must say my trainer was quite supportive and patiently explained everything. Even though I have taken classes on weekend basis, but never feel like that the course is running or missing anywhere. And now I am too confident about Excel and VBA after completion of training under expert trainers. I will always recommend everyone to Join SLA Consultants if they are interested in MIS and RPA etc..
Brijendra PATHAK
SLA Consultants has excellent trainers who are not just concentrated on finishing a class. They really helped me learn new things and were patient when I made mistakes. Thanks to the trainers I have got a job I love and I am good at it too.
Samriti Attreja
I wanted to make a career in HR and I had a knack for understanding laws and regulations. SLA Consultants helped me to become a HR law expert within a few weeks. Every rupee I spent on the course is worth it as I have gained knowledge for life.
Naveen Sharma
SLA Consultants made me a better HR professional in just a few weeks. I am proudly working as an HR Manager now and have a team under me. I am really thankful to them for their constant support before and after the completion of the course.
Prafull Jha
None of my batch mates had a good job and I was worried sick over my career. SLA Consultants came as a ray of hope for me. They honed my accounting knowledge and helped me get a good job. I was the first among my batch mates to get a job and I am very happy with SLA team.
Ummed Ali
SLA Consultants is better institute to learn practical training courses than any others. it provides the best training to their students. The teaching staff is very knowledgeable especially Anoop Sir for MIS and VBA courses. I learned a lot there and better career path.
Manish Gupta
I Joined SLA Consultants for learning GST & ITR training and my experience was very good with the institute and also they helped me to get better placement and now I am working as Accounts Executive.
Ishav Rana
SLA Consultants is one of the best place of knowledge and obtain training. I’ve completed my tally, TDS & GST Classes from the best teachers available with the institution.
YAWAR MALIK
The team of trainers working with SLA is amazing. The support staff is always there to help and Arbind Sir was a great guide. I will never forget my time at SLA and I thank them for the job they helped me get after I completed my course.
Neha Attri
SLA Consultants is a great place for young students who want a job without spending a lot of money. I have learnt a lot there and they helped me get a stable job in a company of my choice. I will forever be thankful to them for guiding me towards a great career path and helping me make a good life for myself.
Himanshu Nautiyal
I have done MIS & VBA course form SLA Consultants under the guidance of Anoop Sir, he has a very good knowledge & experience. He is a professional Trainer & his way of teaching is very good. It is great experience for me to grow with my skill & work efficiency. It is very good Platform who wants to build-up their career in MIS. Also thanks to Swati Mam for Co-ordinate with us and help me to find a good platform.
Nazia Praveen
From the first day I entered the office of SLA Consultants, they helped me. I completed the admission process swiftly and started learning MIS whenever it was convenient. Now I am working in a full time job that’s not hectic but enjoyable.
Ashwani Tripathi
My career path seemed to be stuck at the same place for months. So when I approached SLA Consultants. They trained me so well in Accounts that I got a senior position I always wished for and the bonus is that I love my job because I am so good at it.
Hemant Harshwal
I have joined SLA Consultants for Advanced Excel and VBA. Have gone through no. of classes and got good knowledge about Excel and VBA. Our trainer was very supportive and patiently explains every thing. He is very cooperative apart of training he also suggest regarding our career.
Sujata Teotia
I dreamed of making a career in HR but I did not want to go into a core recruitment job role. This is where SLA helped me. The trained made me a multitasker by teaching me all aspects of HR from payroll to labor law. This training helped me make my dream of working as a HR professional come true.
Avinash
The team of trainers working with SLA is amazing. The support staff is always there to help and Arbind Sir was a great guide. I will never forget my time at SLA and I thank them for the job they helped me get after I completed my course.
Anshuman
SLA Consultants is a name every new student or eager professional should trust. They helped me make a career switch and helped me land a job while I was about to complete the course. Their placement team is really efficient.
Tegbahadur Singh
My love for Data Management was turned into a career opportunity by SLA Consultants. They helped me learn all latest MIS software and made me a champion of Data Management. I have a great career path thanks to the SLA Team.
Ekta Sharma
It has been a good experience for me to take a professional training from SLA. I have taken the GST classes. If I talk about its placement, it is also good. The package depends on your academic performance and your interview.
Sushil kumar yadav
Thanks to SLA consultants, my company values me a lot. I can churn out data from a huge database within a few minutes and keep the management happy. The ever cooperative trainers of SLA have made me capable of doing that and I will be grateful to them.
Niraj Nandan
I had read a lot of SLA Consultants consumer complaints before signing up for a training program in HR. Thankfully, all the doubts I had were fake and the Institute helped me to get a job in a dream company. Thank you, team SLA!!
Satendra Sharma
I did not have any idea what I will do in life. SLA Consultants gave direction to my life by recognizing my skills with numbers and training me as an Accounts Executive. I have a stable job now thanks to teaming SLA and I am getting better at my job every day due to the amazing training they provided me.
Hariom Agarwal
The staff, trainers, and management of SLA Consultants is great. These people really help freshers like me to get a good job. They have changed thousands of lives and I am happy to say that mine was also changed by them. So thank you.
Manikant Jha
SLA Consultants is a boon to all the freshers who are not getting any good jobs. They trained me as an Accounts Executive by using interesting and innovative teaching methodologies. They also helped me get a job when I was in the last leg of the course which was really a pleasant surprise for me.
Priyanka Tiwari
I did not know what to do in life. Then I saw the ad of SLA Consultants. After getting knowledge of all their course offerings, I selected MIS and loved it from the start. Thank you for making my career and helping me get a good life SLA.
Neha Batra
SLA Consultants made me a better HR professional in just a few weeks. I am proudly working as an Sr.HR Executive now and have a team under me. I am really thankful to them for their constant support before and after the completion of the course.
Jyoti Yadav
I wanted to make my career in HR but could not afford to do an MBA course. SLA Consultants provided me with theoretical as well as practical training in HR and I am working as HR Executive with a reputed company now even without an MBA. Thanks SLA. You made my life easier.
Manisha Singh
Well, I take the practical training in Accounts, & GST is going. Guys, if you want to learn and enhance your skills, so it is a good institute for build or making your resume well versed in the global market.

































































