Industry acceptable certification for Accounts & Taxation training which help fresher/Experienced to up-skill at corporate.
4-5 Expert CA/FCA With 10+ Years provide practical compliance training and online e-filing on real time.
After completion of 70% training our dedicated placement team arrange interview till placement.
Practical Training help to gain exposure like corporate level with technical test series
Real time projects & best case study makes SLA workshop very unique and lively for learners.
For Learner’s, Our admin team fresh batch schedule/re-scheduling classes/arrange doubt classes.
Accounts & Taxation Training By Chartered Accountant.
Course Duration: 180 – 200 Hours with Highly Skilled 3 – 5 Corporate Trainers
(CA/HR Manager/MIS Analyst) for 9 Modules
Online Training Courses(OTC) – Accounts & Taxation Training Delivery Method:
NOTE: Classes are also Available on Module Basis
(Total Chapter IX, Total Section 1-25)
Customs:
OBJECTIVE:
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 HANA and SAP S/4HANA
Lesson: Introducing SAP Fiori
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: 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 andexchange 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 28: Define a House Bank
Lesson: Modifying Master Records and Financial Accounting documents
Exercise 29: Modify Vendor Master Records
Exercise 30: Enter Invoices for Payments
Lesson: Managing the Application View for Special General Ledger Transactions
Exercise 31: Enter a Guarantee Made
Exercise 32: Post a Down Payment Request, a Received Down Payment, and a Customer Invoice, and Perform Clearing
Exercise 33: Post a Customer Invoice and Enter an Individual value Adjustment
Lesson: Maintaining Special General Ledger Transactions
Exercise 34: Configure Special G/L Transactions
Lesson: Understanding Purchasing (MM Integration)
Exercise 35: Perform an Integrated Down Payment Process
Lesson: Understanding Sales and Distribution Integration
Lesson: Managing Document Parking Basics and Document Holding
Exercise 36: Hold and Park Documents
Lesson: Processing Parked Documents
Exercise 37: Process Parked Documents
Lesson: Managing Document Parking and Workflow
Exercise 38: Enter a Financial Document Using Parking and Workflow
Lesson: Creating Balance Confirmations
Exercise 39: Create a Balance Confirmation
Lesson: Managing the Foreign Currency Valuation
Exercise 40: Manage the Foreign Currency Valuation of Open Items
Lesson: Managing Value Adjustments
Exercise 41: Execute a Flat-Rate Individual Value Adjustment
Lesson: Regrouping Receivables and Payables
Exercise 42: Regroup Receivables According to Their Remaining Life
Lesson: Posting Accruals and Deferrals
Exercise 43: 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 44: Execute the Balance Audit Reports
Lesson: Explaining the Purpose of Document Splitting in General Ledger Accounting
Lesson: Posting Ledger Group-Specific FI Documents
Exercise 45: Post to a Ledger Group
Lesson: Managing Financial Statements
Exercise 46: Create Financial Statements
Lesson: Executing Drilldown Reports
Exercise 47: Execute Drilldown Reports
Unit 3: Fixed and Current Assets
Lesson: Executing Closing Activities Within Asset Accounting
Exercise 48: Execute and Analyze the Depreciation Run
Lesson: Managing Closing Activities in Materials Management
Exercise 49: Execute Closing Activities in Materials Management
Lesson: Assigning a Chart of Accounts and a Chart of Depreciation to a Company Code
Exercise 50: 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 51: 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 52: Use Number Assignment for FI-AA
Exercise 53: Use Account Determination
Exercise 54: Maintain the Screen Layout of Asset Master Data
Exercise 55: Maintain the Screen Layout of Asset Depreciation Areas
Exercise 56: Copy Asset Classes from Reference
Exercise 57: Display Asset Class 4000
Exercise 58: Manage Asset Classes for Low-Value Assignments
Lesson: Creating and Changing Master Data in Asset Accounting
Exercise 59: Create Asset Master Records
Exercise 60: Maintain Time-Dependent Data
Lesson: Carrying Out Mass Changes to Asset Master Data Using a Worklist
Exercise 61: Define the User Fields and Mass Changes of Asset Master Records
Lesson: Processing Acquisitions
Exercise 62: 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 63: Make Various Non-Integrated Asset Acquisition Postings
Exercise 64: Make Postings Integrated with Materials Management
Lesson: Posting Integrated and Non-Integrated Asset Retirements
Exercise 65: Post Integrated Asset Retirements with Accounts Receivable (AR)
Lesson: Performing Transfers Within Company Code and Intercompany Asset Transfers
Exercise 66: Transfer Assets Within Company Code
Exercise 67: Post Intercompany Asset Transfer (Across Company Boundaries)
Exercise 68: Post Intercompany Asset Transactions (Within One company)
Lesson: Representing, Distributing, and Settling Assets Under Construction
Exercise 69: Create and Post to an Asset Under Construction (AUC) and Settle It to Completed Assets
Lesson: Entering and Analyzing Unplanned Depreciation
Exercise 70: Post Unplanned Depreciation
Lesson: Defining Depreciation Areas, Keys, Calculation, and Posting
Exercise 71: Analyze Depreciation Areas
Exercise 72: Understand and Maintain Depreciation Keys
Exercise 73: Maintain Time-Dependent Depreciation parameters
Exercise 74: Analyze Cost-Accounting Depreciation Area
Exercise 75: Execute and Analyze the Depreciation Run
Lesson: Executing Programs for Fiscal Year Change and Year-End Closing in Asset Accounting
Exercise 76: Execute Year-End Closing in Asset Accounting
Lesson: Using the Accounts Approach for Parallel Accounting in Asset Accounting
Exercise 77: Manage Parallel Accounting in FI-AA
Exercise 78: Manage Unilateral Asset Postings