Tally ERP9
1. Introduction of
Basic Accounting & Finance
2. Advantage of
Computer Accounting
3. Introduction of
Tally ERP9, Creation of a company with Accounts and Inventory mode.
4. Company
Modification/Deletion/Shut
6. Create of using
password and vault
7. Ledger Creation
with Single/Multiple Mode
8. Ledger view at a
Glance
9. Ledger
Modification/Deletion
10. Unit of Measure
creation
11. Inventory
creation/Viewing/Deletion
12. Vouchers
13. Purchase &
Sales Entry with/without inventory
14. Vouchers
Modification/Deletion/Date change
15. Active/Deactive
calculator and usages
16. Transactions
Entry – Purchase/Purchase Returns, Sales/Sales returns
Debit/Credit Notes,
Delivery/Receipt Note, Rejection In/
Rejection out,
Contra, Journal, Receipt.
17. Cash Book/Bank
Book, Purchase/Sales Register with Customized Features Added
18. Allow Zero
Values Entries
19. Maintain Bill
wise Details
20. Set/change
credit limit for customers
21.
Create/Alter/Delete Alternate Units
22. Godown
Creation/Alteration, Transfer items from one godown into another
23. Shortcut key for
Ledger Creation from Vouchers
24. Viewing for
Trial Balance/Profit & Loss/ Balance Sheet
25. Stock
summary/Ratio Analysis
26. Day Book, Ledger
Finance Report Status etc.
27. Cash and Bank
flow Statement
28. Bank
Reconciliation Statement
29. Single/Multiple
Vouchers Entry
30. Using shortcut
keys
31. Different
settings
GST Part
1. Basics, Basic
Terms-IGST, SGST, CGST, UTGST, Composition scheme,
Input Tax credit
etc.
2. GST settings-
company level as well as Items level
3. GST Ledger
Creation
4. GST Transactions:
Sales/Sales Return, Purchase/Purchase Returns etc.
5. GST Treatment on
Discount on Sales/Purchase items
ADVANCED EXCEL SYLLABUS WITH CLASS
SCHEDULE
|
Time Per Class 1and 1/2 hour
|
1. WORKBOOK (FILE) ABD WORKSHEET
|
|
E+A2:M54xcel
Limitation
|
1st class
|
Excel Shortcut use and
benefits
|
1st class
|
Excel Setting and
Custom List Creation
|
1st class
|
Excel Tamplate and
File Location System
|
1st class
|
Advanced Paste Special
|
2nd class
|
Calulation with Paste
Special
|
2nd class
|
Link Data range as
Picture Link
|
2nd class
|
Loopkup Picture in
Excel Worksheet
|
2nd class
|
2.
Advanced Formating for Reports and Dashboard
|
|
Formatting Triks
|
3rd class
|
Date & Time For
Trinks
|
3rd class
|
Advanced Custom
Formating (Number Format using Code)
|
3rd class
|
Conditional Formatting
|
3rd class
|
Advanced Conditional
Formatting using Formulas
|
4th class
|
File,Sheets or Cells
Protection Method
|
4th class
|
Benefits of Data Table
or Cells Style
|
4th class
|
3.
Data Handle and Data Analysis
|
|
Data Fill and
Selection Method
|
4th class
|
Advanced Sorting and
Filter Trinks
|
5th class
|
Data Summerization
with Pivot Table
|
5th class
|
Calculation with
Pivot table
|
5th class
|
Extranal Data Pivot
Table
|
5th class
|
Relationship and
Slicer in Pivot Table
|
6th class
|
Power Pivot in Excel
2016
|
6th class
|
Use SQL Query in Pivot
Table
|
6th class
|
4.
Page Setting and Form Creation
|
|
Draw Form in Excel
Sheet
|
6th class
|
Hyperlink in Excel
|
7th class
|
Text and Symbol
|
7th class
|
Page Setup
|
7th class
|
Manage View
|
7th class
|
Sheets Option and
Arrange
|
8th class
|
5.
Calculation
|
|
Mathameticals
Calculation in Excel
|
8th class
|
Logical Formulas (IF,
and, Or, Xor, IfError Formulas)
|
8th class
|
Nested If Formulas (
Multi Condition in If,and,or )
|
8th class
|
Text and Advanced
Text Formulas
|
8th class
|
Date and Time
Calculation using Data Time Formulas
|
8th class
|
Ref# Formulas and
VLookup
|
9th class
|
Lookup
Method(VLookup,HLookup,Match,Index,Offset)
|
9th class
|
Advanced VLookup and
VLookup Listing
|
9th class
|
Math &trico.
Formulas
|
9th class
|
Data
Summerization Formulas (AVERAGEIF,AVERAGEIFS,COUNTIF,COUNTIFS,LARGE,SMALL and
more)
|
|
Database and list
managment Formulas
|
10th class
|
SAP ENDUSER COURSE CONTENT
A.
BASIC KNOWLEDGE ABOUT GLOBAL SETTINGS.
B. GENERAL LEDGER ACCOUNTING
|
1. Create G/L account
|
2. Block General Ledger Account
|
3. Unblocking of General Account
|
4. Edit General Ledger Account
|
5. Display Changes of General Master Account
|
6. Journal/GL Account Entry Posting
|
7. Parking Document
|
8.Hold Document
|
9. Release the parking Document by changing the amount
|
10. Release the parking document by delete the document
|
11. Park GL Document Entry
|
12. Park Vendor Invoice Entry
|
13. Park Customer Invoice Entry
|
14. View G/L wise balances
|
15. View GL Line Item Display
|
16. REFERENCE DOCUMENTS – REVERSALS ENTRIES
|
C. RECURRING DOCUMENT CONFIGURATION
|
1. Create no. ranges for recurring documents
|
2. Create recurring document template
|
3. Change recurring documents
|
4. Display recurring document
|
5. Display changes of recurring document
|
6. Overview of recurring documents
|
7. Execute/Run the recurring document
|
8. To view document
|
9. Individual Reversal
|
10. Mass Reversal
|
10. Reversal of reversal
|
11.Sample Document
|
D. ACCOUNTS
PAYABLE CONFIGURATION
|
1. Create Vendor Account Groups
|
2. Create Number Ranges for Vendor Accounts
|
3. Assign Number Ranges to Vendor Account Groups
|
4. Create Reconciliation G/L Accounts for vendor
|
5. Create Number Ranges for Purchase Invoice Posting
|
6. Creation of Vendor Master Data
|
7. Tolerance group for Vendor
|
8. Purchase Invoice Posting
|
9. Outgoing Payments
|
10. To View Vendor wise Balances
|
11. Clear Open Item
|
E. GENERAL LEDGER POSTING
|
F. CASH DISCOUNT
|
1. Define Terms of Payment
|
2. Create G/L account for Cash Discount Account
|
3. Assignments
|
ii. Assign Automatic Postings to Cash Discount A/c.
|
4. Incoming Payments from Customers
|
5. To view G/L wise balances
|
6. To view Customer wise balance
|
G. AUTOMATIC PAYMENT PROGRAM
|
1. Creation of House Bank
|
2. Creation of Check Lots
|
3. Check Payments
|
4. To view Check Book
|
5 Check creation
|
6. To view check register
|
7. To create new void reason
|
8. All company codes
|
9. Paying company codes
|
10. Payment method in country
|
11. Payment method in company code
|
12. Bank determination
|
13. Automatic payment program run & printout documents..
|
H. SPECIAL G/L ACCOUNTS
|
1. DOWN PAYMENTS TO VENDORS
|
2. Create Down Payments to vendors A/C (Asset)
|
3 Link between down payments to Sundry Creditors
|
4. Advance made to Vendors
|
5. Purchase invoice
|
6. Transfer Special G/L A/Cs to Normal G/L A/Cs
|
7. Outgoing payments
|
MM END USER COURSE CONTENT
MM01
|
SAP MM Procurement (User)
|
MM01-01
|
Request for quotation (ME41)
|
MM01-02
|
Quotation (ME47)
|
MM01-03
|
Price comparison (ME49)
|
MM01-04
|
Create contract (ME31K)
|
MM01-05
|
Purchase requisition (ME51N)
|
MM01-06
|
Assign vendors to purchase requisitions (ME56)
|
MM01-07
|
Purchase order vendor unknown (ME25)
|
MM01-08
|
Goods receipt for purchase order (MIGO)
|
MM01-09
|
Purchase order (ME21N)
|
MM01-10
|
PO List display (ME2L)
|
MM01-11
|
PO based on Requisitions (ME58)
|
MM01-12
|
Goods receipt (MIGO)
|
MM01-13
|
Stock overview (MMBE)
|
MM01-14
|
Display vendor (XK03) and material master data (MM03)
|
MM01-15
|
Display info. record (ME12) and source list master data (ME03)
|
MM01-16
|
Return purchase order (ME21N)
|
MM01-17
|
Vendor invoice verification (MIRO)
|
MM01-18
|
Enter vendor confirmation in purchase order (ME22N)
|
MM01-19
|
Monitoring missing order acknowledgements (ME92F)
|
MM01-20
|
Monitoring overdue purchase orders (ME91F)
|
MM01-21
|
Quota arrangement (MEQ1)
|
MM01-22
|
Purchase order without material, text item purchase (ME21N)
|
MM01-23
|
Service purchase order (ME21N)
|
MM01-24
|
Service entry sheet (ML81N)
|
MM02
|
SAP MM Procurement Contract (User)
|
MM02-01
|
Create contract (ME31K)
|
MM02-02
|
Purchase requisition (ME51N)
|
MM02-03
|
Assign contract to purchase requisition (ME57)
|
MM02-04
|
Purchase order to contract (ME57)
|
MM02-05
|
Goods receipt for purchase order (MIGO)
|
MM02-06
|
Invoice receipt and invoice verification (MIRO)
|
MM02-07
|
Display purchase order history (ME23N)
|
MM02-08
|
Release blocked invoices (MRBR)
|
MM02-09
|
Display contract (ME33K)
|
MM02-10
|
Display partially completed contract (ME33K)
|
MM03
|
SAP MM Physical Inventory (User)
|
MM03-01
|
Warehouse Stock Display (MB52)
|
MM03-02
|
Physical Inventory Document w/o Special Stock (MI31)
|
MM03-03
|
Block Material (MI32)
|
MM03-04
|
Freeze Book Inventory Balance (MI33)
|
MM03-05
|
Print Physical Inventory Document (MI21)
|
MM03-06
|
Enter Inventory Count (MI04)
|
MM03-07
|
Set Zero Count (MI35)
|
MM03-08
|
Difference List (MI20)
|
MM03-09
|
Recount (MI11)
|
MM03-10
|
Post Difference (MI07)
|
MM04
|
SAP MM Inventory Stock Management (User)
|
MM04-01
|
Goods receipt of purchase order (MIGO)
|
MM04-02
|
Goods receipt without order reference (MIGO)
|
MM04-03
|
Stock quantity report – stock overview (MMBE)
|
MM04-04
|
Transfer stock to stock (MIGO)
|
MM04-05
|
Transfer plant to plant (MIGO)
|
MM04-06
|
Create stock reservation (MB21)
|
MM04-07
|
Goods issue to cost center (MIGO_GI)
|
MM04-08
|
Display material document (MB51)
|
MM04-09
|
Stock quantity and value report – warehouse stock (MMBE)
|
MM04-10
|
Physical inventory stock adjustment (MI10)
|
MM04-11
|
Create STO stock transport order (ME21N)
|
MM04-12
|
Goods issue for STO stock transport order (MIGO_GI)
|
MM04-13
|
Material transfer blocked stock to unrestricted (MIGO)
|
MM04-14
|
Goods issue for reservation (MIGO_GI)
|
MM04-15
|
Stock on posting date (MB5B)
|
MM04-16
|
|
SD END USER COURSE CONTENT
T Code
|
Description
|
XD01, XD02, XD03
|
Customer creation, Change, Display (General)
|
FD01. FD02, FD03
|
Customer
Creation, Change, Display (FI Customer)
|
VD01, VD02,VD03
|
Customer Creation, Change, Display (Sales Area)
|
MM01, MM02, MM03
|
Material Creation, Change, Display (Finished Goods)
|
VA01, VA02, VA03
|
Sales Order Creation, Change, Display (Standard Order, Cash Sales,
Rush Order, Debit Memo, Credit Memo, Return Order)
|
VA11, VA12, VA13
|
Inquiry
Creation, Change, Display
|
VA21, VA22, VA23
|
Quotation Creation, Change, Display
|
VA31. VA32,VA33
|
Scheduling
Agreement Creation, Change,Display
|
VA41, VA42, VA43
|
Contract Creation, Change, Display
|
VA51, VA52, VA53
|
Item
Proposal Creation, Change, Display
|
VL01N, VL02N, VL03N
|
Creation Delivery, Change, Display
|
VF01, VF02, VF03
|
Billing
Creation, Delivery, Change
|
VK11, VK12, VK13
|
Condition Record Maintain, Change, Display
|
VD51, VD52, VD53
|
Customer
Material Info Record Maintain, Change, Display
|
ME21N, ME22N, ME23N
|
Purchase Order Creation, Change, Display
|
MIGO
|
Goods
Receipt Note Entry
|
MB1C
|
Material Stock Upload
|
VAP1
|
Create
Contact Person
|
VB01, VB02, VB03
|
Listing/Exclusion Creation, Change, Display
|
VB11, VB12, VB13
|
Material
Determination Creation, Change, Display
|
SOFT SKILL AND COMMUNICATIONS