Financial Analyst Course ▷100% Job,Salary Upto 6L-SLA Noida

Featured

Financial Analyst Course with 100% Job

Popular Courses

0 Lessons

Free

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

What is the correct answer for 25 - 20

Programme Modules

Corporate Finance, Investment Banking & Financial Analyst Training Course

Module 2 - Financial Statement Analysis & Corporate Finance

Financial analysis is a process of selecting, evaluating, and interpreting financial data, with other pertinent information, in order to formulate an assessment of a company’s present and future financial condition and performance

Introduction to Financial Statements – 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
Navigating the Annual Report
Common size Analysis – Horizontal and Vertical
Financial Ratios – Financial ratio analysis is the use of relationships among financial statement accounts to gauge the financial condition and performance of a company
- Activity Ratios
- Liquidity Ratios
- Solvency Ratios
- Profitability Ratios
- Rate of return
- DuPont Analysis
- Other important ratios
Pro Forma Analysis and basic Projection technique

Corporate Finance– Understanding of capital structure and how corporate finance works is quite essential for any professional pursuing his/her career in Finance. It gives a bird’s eye view of an organisation and provides an understanding of how various financing activities impact the valuation of a firm. CFO of any company endeavours to optimize the capital structure by selecting the right financing tools to address the operating and investing needs of a company.

Time value of money
- NPV and IRR
- Future Value
- Excel formulas like NPV, XNPV, IRR, XIRR, PV, FV, etc.
Understanding of Debt
- Understanding schedules for debt repayment and interest repayment
- Developing the schedules on excel
Capital Structure and Cost of Capital
- Debt and Equity
- Cost of Debt
- Cost of Equity
- WACC
Understanding tax shield
Measure of Leverage
- Impact of leverage on cost of capital
CAPM 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
Valuation: Valuation is the Process to determine the current worth of asset. In SLA course, the asset is a company. For the valuation of companies, following are the three widely used techniques.
- DCF Valuation
- Relative Valuation
- Transaction Valuation
Application of these techniques with real case studies and companies

Module 3 - Financial Modeling

Module 4 - Advanced Dashboard & VBA / Macros Programming Objective

Advanced Dashboard & VBA / Macros Programming Objective

To Define KPIs (Key performance Indicator), Customer Service Dashboards or Project Management Dashboard (Gantt Chart)
Dashboard Reports Based on Tables and Number or Charts/Graphs or Both.

Introduction to Programming Introduction to logical thinking flowcharts & algorithms:

Define Objective, Start & End Points; Identifying Solution & Breaking it Into Sequential Steps Writing a
Step-by-Step Instructions, Flowcharts, Process Flow Diagrams. Excel Macros – an Introduction

Complete Review of the VBA Language (Subs, Functions, Variables, Arrays, Loops, Logic…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 Methods
The Power of Macros – What, When, How to use Macros. Introduction to Object Oriented Programming
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.
For-Next, For-Each, Do-While, Do until, Do Loop Decision-Making and Code Branching
If-Then-Else, Select-Case, And/or Nested Conditions
What is user’s Defined Functions? How to create & use them.
Use of Arrays in VBA programming with one dimensional, two dimensional or multi-dimensional analysis

Excel VBA Power Programming For VBA Macros

Overview of Using 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

Testing and Debugging Your Code

Effective Error Handling

Automation Development Reports & Live Projects

Module 5 - SAP FICO

Training Material
Question and Answer for each chapter
Real life scenario discussion

Unit 1: SAP FICO Overview

Lesson:Introducing SAP

Lesson:Introducing SAP FICO

Unit 2: Core Financial Accounting (FI) Configuration

Lesson: Managing Organizational Units in Financial Accounting (FI)

Exercise 1: Create a Company Code

Exercise 2: Create a Company ID for Your Company Code and assign it to Your Company Code

Exercise 3: Exercise 4: Check the Assignment of a Company Code to a controlling Area

Lesson: Checking the Basic Settings in General Ledger (G/L) Accounting

Exercise 4: Check the Basic Settings in G/L Accounting

Lesson: Outlining the Variant Principle

Lesson: Managing Fiscal Year Variants

Exercise 5: Create and Maintain Fiscal Year Variants

Lesson: Identifying the Basic Functionality of Currency Keys and exchange Rate Types

Lesson: Managing Currency Types

Unit 3: Master Data

Lesson: Maintaining General Ledger (G/L) Accounts

Exercise 6: Create Account Groups for G/L Accounts

Lesson: Creating Profit Centers and Segments

Exercise 7: Create Profit Centers, Cost Centers, and Segments

Lesson: Managing Business Partners

Exercise 8: Create Account Groups and Maintain Customer or vendor Accounts

Exercise 9: Maintain Field-Status Configuration

Exercise 10: Define Sensitive Fields

Unit 4: Document Control

Lesson: Configuring the Header and Line Items of Financial Accounting (FI) Documents

Exercise 11: Create a Number Range and Document Type

Exercise 12: Classify the Document Type for Document Splitting

Exercise 13: Create a Field Status Group and Assign It to a G/L Account

Lesson: Managing Posting Periods

Exercise 14: Create and Maintain Posting Period Variants

Lesson: Managing Posting Authorizations

Exercise 15: Create a Tolerance Group and Assign It to a User

Lesson: Creating Simple Documents in FI

Exercise 16: Post FI Documents

Unit 5: Posting Control

Lesson: Analyzing Document Splitting

Exercise 17: Post a Document with Document Splitting

Lesson: Maintaining Default Values

Exercise 18:Maintain Default Values

Lesson: Configuring Change Control

Exercise 19: Maintain the Change Control for a Field

Lesson: Configuring Document Reversal

Exercise 20: Post a Document Reversal

Lesson: Configuring Payment Terms and Cash Discounts

Exercise 21: Maintain Terms of Payment

Lesson: Maintaining Taxes and Tax Codes

Exercise 22: Create a Tax Code and Post a Customer Invoice

Lesson: Posting Cross-Company Code Transactions

Exercise 23: Configure Cross-Company Code Transactions

Exercise 24: Post and Display Cross-Company Code Transactions

Unit 6: Financial Document Clearing

Lesson: Performing Open Item Clearing

Exercise 25: Clear an Account

Exercise 26: Post with Clearing

Lesson: Managing Payment Differences

Exercise 27: Manage Payment Differences

Lesson:Managing Exchange Rate Differences

Unit 7: Automatic Payments

Lesson: Executing an Automatic Payment Run

Lesson: Using Bank Accounts

Exercise 1: Define a House Bank

Lesson: Modifying Master Records and Financial Accounting documents

Exercise 2: Modify Vendor Master Records

Exercise 3: Enter Invoices for Payments

Unit 8: Special General Ledger Transactions

Lesson: Managing the Application View for Special General Ledger Transactions

Exercise 17: Enter a Guarantee Made

Exercise 18: Post a Down Payment Request, a Received Down Payment, and a Customer Invoice, and Perform Clearing

Exercise 19: Post a Customer Invoice and Enter an Individual value Adjustment

Lesson: Maintaining Special General Ledger Transactions

Exercise 20: Configure Special G/L Transactions

Lesson: Understanding Purchasing (MM Integration)

Exercise 21: Perform an Integrated Down Payment Process

Lesson: Understanding Sales and Distribution Integration

Unit 9: Parking Documents

Lesson: Managing Document Parking Basics and Document Holding

Exercise 22: Hold and Park Documents

Lesson: Processing Parked Documents

Exercise 23: Process Parked Documents

Lesson: Managing Document Parking and Workflow

Exercise 24: Enter a Financial Document Using Parking and Workflow

Unit 10: Receivables and Payables

Lesson: Creating Balance Confirmations

Exercise 5: Create a Balance Confirmation

Lesson: Managing the Foreign Currency Valuation

Exercise 6: Manage the Foreign Currency Valuation of Open Items

Lesson: Managing Value Adjustments

Exercise 7: Execute a Flat-Rate Individual Value Adjustment

Lesson: Regrouping Receivables and Payables

Exercise 8: Regroup Receivables According to Their Remaining Life

Unit 11: Accruals and Deferrals

Lesson: Posting Accruals and Deferrals

Exercise 9: Post Accruals

Unit 6: Technical, Organizational, and Documentary Closing Activities

Lesson: Managing Technical Steps During the Period-End Closing Activties

Lesson: Executing the Balance Audit Trail

Exercise 10: Execute the Balance Audit Reports

Lesson: Explaining the Purpose of Document Splitting in General Ledger Accounting

Lesson: Posting Ledger Group-Specific FI Documents

Exercise 11: Post to a Ledger Group

Unit 12: Asset Accounting Organizational Structures

Lesson: Assigning a Chart of Accounts and a Chart of Depreciation to a Company Code

Exercise 1: Assign a Chart of Depreciation to a Company Code

Lesson: Assigning Management Accounting Objects to Fixed Assets

Lesson: Defining How Depreciation Areas Post to the General Ledger

Exercise 2: Define Depreciation Areas and the Update of the General Ledger

Lesson: Understanding the Importance of Asset Classes in Fixed Assets

Unit 13: Asset Accounting Master Data

Lesson: Explaining the Components of an Asset Class

Exercise 3: Use Number Assignment for FI-AA

Exercise 4: Use Account Determination

Exercise 5: Maintain the Screen Layout of Asset Master Data

Exercise 6: Maintain the Screen Layout of Asset Depreciation Areas

Exercise 7: Copy Asset Classes from Reference

Exercise 8: Display Asset Class 4000

Exercise 9: Manage Asset Classes for Low-Value Assignments

Lesson: Creating and Changing Master Data in Asset Accounting

Exercise 10: Create Asset Master Records

Exercise 11: Maintain Time-Dependent Data

Lesson: Carrying Out Mass Changes to Asset Master Data Using a Worklist

Exercise 12: Define the User Fields and Mass Changes of Asset Master Records

Unit 14: Asset Transactions

Lesson: Processing Acquisitions

Exercise 13: Post an Integrated Asset Acquisition and Analyze the Asset Value in the Asset Explorer

Lesson: Posting Non-Integrated Asset Acquisitions and understanding the Integration with Materials Management (MM)

Exercise 14: Make Various Non-Integrated Asset Acquisition Postings

Exercise 15: Make Postings Integrated with Materials Management

Lesson: Posting Integrated and Non-Integrated Asset Retirements

Exercise 16: Post Integrated Asset Retirements with Accounts Receivable (AR)

Lesson: Performing Transfers Within Company Code and Intercompany Asset Transfers

Exercise 17: Transfer Assets Within Company Code

Exercise 18: Post Intercompany Asset Transfer (Across Company Boundaries)

Exercise 19: Post Intercompany Asset Transactions (Within One company)

Lesson: Representing, Distributing, and Settling Assets Under Construction

Exercise 20: Create and Post to an Asset Under Construction (AUC) and Settle It to Completed Assets

Lesson: Entering and Analyzing Unplanned Depreciation

Exercise 21: Post Unplanned Depreciation

Unit 15: Periodic Processing and Valuation

Lesson: Defining Depreciation Areas, Keys, Calculation, and Posting

Exercise 22: Analyze Depreciation Areas

Exercise 23: Understand and Maintain Depreciation Keys

Exercise 24: Maintain Time-Dependent Depreciation parameters

Exercise 25: Analyze Cost-Accounting Depreciation Area

Exercise 26: Execute and Analyze the Depreciation Run

Lesson: Executing Programs for Fiscal Year Change and Year-End Closing in Asset Accounting

Exercise 27: Execute Year-End Closing in Asset Accounting

Lesson: Using the Accounts Approach for Parallel Accounting in Asset Accounting

Exercise 28: Manage Parallel Accounting in FI-AA

Exercise 29: Manage Unilateral Asset Postings

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 Statement Analysis & Corporate Finance	35 Hours
Financial Modeling – Equity Valuation	30 Hours
Ad. Excel + Financial Statement Analysis & Corporate Finance	50 Hours
Ad. Excel + Financial Modeling – Equity Valuation	55 Hours
Ad. Excel + Financial Statement Analysis & Corporate Finance+ Financial Modeling – Equity Valuation	75 Hours
Financial Statement Analysis & Corporate Finance+ Financial Modeling – Equity Valuation	65 Hours
Ad. Excel + Financial Statement Analysis & Corporate Finance+ Financial Modeling – Equity Valuation + VBA/Macros	90 Hours
Ad. Excel + Financial Statement Analysis & Corporate Finance+ Financial Modeling – Equity Valuation + VBA/Macros + SAP FICO	110 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

FAQ

What is the total duration of the course?

What if I miss any class?

Do provide valid certification after the training?

How to register for the course?

Do you provide practical classes as well?

What kind of job placement assistance you provide?

Testimonials

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.

Pawan Gupta

MIS Executive - Rosmerta Technology Ltd.

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

MIS & Data Analyst Executive

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.

Rahul Pal

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.

Gauri

HR Generalist at MIPS

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.

Anshuman

Accounts Executive at Serco Global Services

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.

Manish Gupta

Accountant Executive-Mituj Marketing Pvt Ltd

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.

Naveen Sharma

HR Manager - AM Mituj Marketing

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.

Tegbahadur Singh

MIS Executive at Renovision Automation

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.

Aditya Pratap

MIS Executive at CS Datamation Research Services Pvt Ltd

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.

Sujata Teotia

HR Executive - PC Solution

Ashish Tiwari

All trainers and staff are so good especially want to say thanks to Swati Ma’am, She always Co -operates me.

Ashish Tiwari

Accounts Executive at Millennium Automation

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.

Ishav Rana

Osource India Pvt.

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.

Brijendra Pathak

Accounts Executive at Vian Healthcare Products

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.

Neeraj Gupta

MIS Executive at Shriram Automall India Ltd

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.

Anil Kumar

MIS Coordinator at IQOR

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 “

Archit Khandelwal

MIS Executive at Fortune Marketing Pvt. Ltd

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

Inderveer Singh Verma

Senior Executive (Accounts & Finance) at Apollo Hospitals Enterprise Limited

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.

Bharti Sharma

HR Executive at JB Intertrade

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.

Rashmi Pal

Payroll Executive - Mynd Solution

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.

Bhavani Singh

MIS Executive at G.D. FOODS MFG. (I) PVT LTD.

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.

Ashutosh Saini

Accounts Executive at Sethi Group

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.

Rachna

HR Executive at TNS Networking Solution

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.

Sushil kumar yadav

MIS Executive at Bharti Infratel

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.

YAWAR MALIK

Accounts Executives at Menlo Logistic

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.

Ekta Sharma

Accountant Executive-Onextel Media Pvt Ltd

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.

Tanzeel Mohammad

HR Generalist-Dhwani Rural Information Systems Pvt Ltd

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.

Anil Kumar Pal

MIS Executive at Recharge it Now

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.

Amit Kumar

MIS & Data Analyst Executive

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.

Sharmistha Das

Payroll Executive at Excelity Global

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.

Kumar Gautam

MIS Coordinator at IQOR

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.

Rajesh Pratap Singh

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.

Rajbir Sharma

Sr. MIS Executive at Computer Junction Pvt. Ltd.

Vineet

HR Payroll at CYGNUS EQUIPMENTS & RENTALS PVT. LTD.

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.

Santosh Kumar

MIS Executive at Jai Shree Stationers Pvt. Ltd.

Abhishek Bharti

I have great experience in SLA Consultants for Excel and VBA Macros with expert trainers.

Abhishek Bharti

MIS Executive

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.

Hemant Harshwal

Data Analyst

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.

Prafull Jha

Accounts Executive at Akash Fashion

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.

Rahul Kumar

MIS Executive at ASIAN COLOUR COATED ISPAT LTD

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.

Himanshu Nautiyal

Fortune Marketing Pvt.Ltd.

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.

Deepak Sharma

Accounts Executive at Redstar Group

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.

Ummed Ali

MIS Executive at Evaxo pharma Pvt. Ltd

Arshad Khan

HR Manager at Mituj Marketing

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.

Manisha Singh

Accounts Executive at Sevenseas

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.

Satendra Sharma

Accounts Executive at Development Alternatives

Anand Kumar Jha

MIS Executive - Rosmerta Technology Ltd.

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.

Manikant Jha

Accounts Executive at Mituj Marketing

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.

Neha Batra

Sr. HR Executive - Abia HR Solutions

Avinash

MIS Executive at Serco Global Services

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!

Rohit Kumar

Accounts Executive at Vertex Power Control Pvt. Ltd.

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.

Priyanka Tiwari

MIS Executive at Concepts & Solutions

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.

Neha Attri

HR Generalist at Bonanza Portfolio Pvt. Ltd.

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.

Jyoti Yadav

HR Executive at Development Alternatives

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.

Ibadat Hussain

Accounts Executive at Absolut Info System Pvt Ltd

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.

Ashwani Tripathi

Accounts-AM at Rosmerta Technology Ltd.

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.

Kedar Pradhan

Accounts Executive at Aircel

Abhishek Pandey

Accounts Executive at Vian Healthcare Products

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.

Samriti Attreja

HR Executive - Abia HR Solutions

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.

Kapil Negi

MIS Executive at Genpect

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.

Amrisha Priya

Accounts Executive at JYOTHY FABRICARE SERVICES LTD

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.

Nazia Praveen

MIS Executive - Globalite Retails Pvt Ltd

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 Bhagat

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!!

Niraj Nandan

HR Gernalist at CYGNUS EQUIPMENTS & RENTALS PVT. LTD.

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.

Hariom Agarwal

MIS Executive - Globalite Retails Pvt Ltd

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.

Indresh Kumar

MIS Executive - Recharge it Now

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.

Md Sadik

MIS Executive at Evaxo Pharma Pvt. Ltd.

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..

Vinay Tiwari

MIS & Data Analyst

Financial Analyst Course with 100% Job

Advanced Financial Analyst Training by IIM Alumni Free SAP FICO Certification

Programme Modules

Corporate Finance, Investment Banking & Financial Analyst Training Course

Advanced Excel

Advanced Dashboard & VBA / Macros Programming Objective

Introduction to Programming Introduction to logical thinking flowcharts & algorithms:

Complete Review of the VBA Language (Subs, Functions, Variables, Arrays, Loops, Logic…etc.)

Excel VBA Power Programming For VBA Macros

Overview of Using User forms To Create Business Wizards

Connection between Excel VBA & other platforms

Testing and Debugging Your Code

Effective Error Handling

Automation Development Reports & Live Projects

Unit 1: SAP FICO Overview

Unit 2: Core Financial Accounting (FI) Configuration

Unit 3: Master Data

Unit 4: Document Control

Unit 5: Posting Control

Unit 6: Financial Document Clearing

Unit 7: Automatic Payments

Unit 8: Special General Ledger Transactions

Unit 9: Parking Documents

Unit 10: Receivables and Payables

Unit 11: Accruals and Deferrals

Unit 12: Asset Accounting Organizational Structures

Unit 13: Asset Accounting Master Data

Unit 14: Asset Transactions

Unit 15: Periodic Processing and Valuation

Find the Financial Modelling in Excel course details below. Classes and Course can be designed/customize as per request

Duration of Module

Batch Timings

FAQ

Testimonials

Related Courses