CLICK BELOW 10 POINTS - DETAILS ON 100% TRAINING & PLACEMENT

• User Interface and Company Management 
• Masters – Groups and Ledgers (chart of Account) 
• Inventory Masters-Stock group, Stock category, stock Item etc 
• F11 and F12 features
• Masters – Various Vouchers (Accounting, Inventory, Pay roll and Non accounting) Account Payables and Account receivables 
• Purchase Order Processing Sales Order Processing 
• Goods and Services Tax (GST) 
• Processing of Purchase and sales with GST 
• Purchase and sales return with GST 
• Bank Reconciliation 
• Manufacturing Journal 
• Cost center and Cost Category 
• Banking Aspects- chequeprinting, Reconciliation etc 
•  Batch wise details in tally 
• Interest calculation 
• Multi currency transactions 
• Tax Deducted at Source 
• Payroll in tally 
• Closing entries-how to finalize 
• Various reports- Financial, Inventory and Statutory 
• Export of data 
• Backup and Restore 
• Tally vault and user level security features 
• Edit log

INTRODUCTION TO ADVANCE EXCEL  

• Get a head start with templates and set up an Excel Template 
• Create new default workbook and work sheet templates  
• Learn how modular templates can make your spread  sheets more consistent and much quicker to set up 
• Customizing the Excel interface to put the tools that  you need at your finger tips 
• How to build in checks and controls from the outset 
• Key techniques that reduce risk and increase  automation and efficiency 
• Documentation and review tools

 GROUPING & OUTLINING AND SUBTOTALS:

•  Outlining & grouping data
•  Using the subtotals tool

WHAT- IF ANALYSIS:

• Exploring Scenarios
• Goal Seek and Data tables
• Using Solver, Data Validation

 PIVOT TABLES:

• Getting Started with Pivot Tables
• Displaying data in Pivot Table
• Formatting a Pivot Table
• Using the Classic Pivot Table

CHARTING PIVOT TABLE:

• Getting Started with Pivot charts
• Using Pivot chart tools tabs
• Formatting a Pivot Chart 

 ADVANCED EXCEL TASKS:

• Hyperlinks
• Custom AutoFill list
• Sharing workbooks

VLOOKUP AND HLOOKUP

•  Vlookup and Hlookup functions
• Nested Vlookup

 FUNCTIONS & FORMULAS

• Stats formulas
• Text functions 
• Lookup and reference functions
• Other formulas- ( tax calculation, interest, debit & credit, depreciations etc)

 MACROS 

• Recording and Playing Macros
• Copying and Deleting Macro
• Visual Basic and Macros

 ORGANIZATIONAL STRUCTURE 

•  Define company
•  Define company code
•  Assign company code to company
• Define business area
•  Define functional area
•  Define credit control
• Assign company code to credit control 

 FI-FINANCIAL ACCOUNTING GLOBAL SETTING 

•   Maintain fiscal year variant
•  Assign company code to fiscal year variant
•  Define variants for open posting periods
• Open & close posting periods
• Assign posting period variant to company
•  Define field status variant
•  Assign company code to field status variants
•  Define posting key
•  Define document types
• Define document number ranges
•  Define tolerance group for employees
• Define tolerance group for G/L accounts
• Assign users to tolerance group
• Global parameters for company code

 SAP FI- GENERAL LEDGER

• Introduction to new general ledger
• Activation of new general ledger
•  Define chart of accounts
•  Define accounts groups
•  Define retained earnings account
• Create general ledger account
• Posting of general entries
• Holding, parking & posting of documents
• Reversal of documents
•  Reference documents
•  Parallel ledger
•  Document splitting

  SAP FI- ACCOUNTS PAYABLE 

• Create vendor account groups
•  Create number ranges for vendor accounts
•  Assign the number ranges to vendor account groups
•  Create sundry creditors account
• Define tolerance group for vendors
• Vendor payment terms
•  Create vendor master data
• Automatic payment program 

 SAP FI- ACCOUNTS RECEIVABLE

• Create customer account groups
• Create number ranges for customer accounts
• Assign number ranges to customer account groups
• Create sundry debtors
• Define tolerances group for customer
• Customer payment terms
• Create customer master record
• Dunning procedure configuration 

 SAP FI- ASSET ACCOUNTING

• Chart of depreciation
• Assign chart of depreciation to company code
• Specify account determination
• Create screen layout rules
• Maintain   asset number ranges
•  Define asset classes
• Determination depreciation area in the asset class
• Assignment  of general accounts
•  Define screen layout for asset master data
• Define screen layout for asset depreciation areas
•  Maintain depreciation key 

 CONTROLLING 

•  Controlling area settings
• Number ranges to controlling documents

 COST ELEMENT ACCOUNTING

• Automatic creation of cost elements
• Individual creation of cost elements 

 COST CENTRE ACCOUNTING 

• Creation of cost centre, planning
• Posting of cost into cost center
•  Manual reposting of cost
•  Distribution and assessment

 INTERNAL ORDER ACCOUNTING 

•  Order type, number range
•  Creation of order, planning & posting
• Defining settlement rules
•  Final settlement of internal order

 PROFIT CENTER ACCOUNTING 

• Settings for profit center
• Creation of profit center, planning
•  Posting of revenues
• Distribution and assessment

 COST POSTING OF PROFIT CENTER 

 INTEGRATION OF FI WITH MM MODULE