Industry-oriented certification Accounts & Taxation training course to furnish your career to kick-start/grow at MNCs/Non-MNCs Organization & corporate.
Professional expert 4-5 CA/FCA With 10+ Years of working experience will provide you industrial level training and online e-filing on real time.
Receive placement assistance after completion of 70% training, SLA team will arrange interviews till you’ll get the placement.
You can attain the practical training session to get the indutrial exposure & prepare for the corporate level challanges.
You’ll attain knowledge on bases of real-time scenarios, live projects & best case study to complete SLA workshop.
SLA’s 7 days working admin team co-ordinates you for the fresh batch schedule/re-scheduling classes/arrange doubt classes.
E-Accounts, E-Taxation & E-GST Practical Training With Advanced Excel/GST – Tally ERP9 By Chartered Accountant.
Course Duration: 200 – 210 Hours with Highly Skilled 3 – 5 Corporate Trainers
(CA/HR Manager/MIS Analyst) for 9 Modules
SLA Consultants Delhi – E-Accounts , E-Taxation & E-GST Practical Training Delivery Method:
NOTE: Classes are also Available on Module Basis
(Total Chapter IX, Total Section 1-25)
Provide Basic Understanding of Excel, Make user Familiar to Create Formula and give Platform to Make Good Analysis and Introduce Powerful Tools of Advance Excel so that user can Make Advance Analysis with the help of Those Tools
Advanced Excel
Lookup & Reference Functions:-VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’sSum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct.
Text Functions & Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time.
Logical Functions:-And, Or, If, Iferror, Not, Nested If, Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min
Data Management:- Data Collection Method With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality
Analysis:- Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table,
Advanced Chart, Graph & Dashboard:- Advanced Chart Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart, Two-Variable Data Table
Advanced Filter, Validation & Pivot Table:- Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data Split.
Pivot Table and Charts, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display
Lesson:Introducing SAP
Lesson:Introducing SAP FICO
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Course Module | Course Duration |
---|---|
Module 1 – GST | 35 – 40 (Hours) |
Module 2 – Income Tax & TDS | 25-30 Hours |
Module 1 & 2 GST + Income Tax+TDS | 60 – 70 (Hours) |
E-GST + Income Tax + TDS + Custom | 70 – 80 (Hours) |
E-GST + Income Tax + TDS + BSF | 80 – 85 (Hours) |
E-GST + Tally ERP 9 | 70 – 80 (Hours) |
E-GST + Tally ERP 9 + Excel-MIS | 90 – 100 (Hours) |
Module 5 + 6 (Tally ERP 9+Ad. Excel) | 40 – 50 (Hours) |
Module 5 Tally ERP 9 + Section A + B | 25 -30 (Hours) |
Module 9 – SAP FICO/Simple Finance | 20 – 25 (Hours) |
Module 5 Tally ERP 9 + Module 9 SAP | 45 – 55 (Hours) |
Tally ERP 9 + SAP + Excel | 60-65 (Hours) |
Module 1 – 4 | 100 – 110 (Hours) |
Module 1 – 5 | 125 – 130 (Hours) |
Module 1 – 6 | 145 -150 (Hours) |
Module 1 – 7 | 155 – 160 (Hours) |
Module 1 – 8 | 175 – 180 (Hours) |
Module 1 – 9 | 200 – 205 (Hours) |
Course Schedule | Batch 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 |
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.
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.
SLA Consultants is the 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.
All trainers and staff are so good especially want to say thanks to Swati Ma’am, She always Co -operates me.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.