• S P Naik Education and Rural Development Society(R),Ranebennur
  • +(91) 7996555105
  • +(91) 7975225114
  • venusit.co.in
1

Advance Diploma in Financial Accounting & Management

Duration: 6 Months Daily / 12 Months Alt Days

-TALLY CHAMPS 2 VOLUME Indepth & Advance COURSE is developed after a thorough research & study of the industry . By joining this course student will be able to determine where he needs to focus & career Gprospects available for him in the field of Business Accountancy.

TALLY CHAMP -B-VOLUME 2 Kit Includes :

– 2 Volumes of Books

– Tally Training CD

– 2 Online Exam

– Student Name is Registered on the Tally Website

Fundamentals:

• Fundamentals of Accounting and Tally.ERP 9
• Creating Masters in Tally.ERP 9
• Voucher Entry and Generation of Reports
• Tally Vault and Security Controls
• Export, Import and Splitting of Data
• Connectivity & Printing Reports
• Advanced Accounting and Inventory in Tally.ERP 9
• Job Costing and Job Order Processing
• Installing & Activating Tally.ERP 9
• Value Added Tax (VAT)
• Central Sales Tax (CST)
• Tax Deducted at Source, Service Tax
ADVANCED EXCEL: • Sub Total Reports, Auto Filter
• Password Protecting Worksheets
• Linking Multiple Sheets
• Sheet Referencing
• Linking Between Word/Excel/Ppt
• Functions:- LOOKUP, VLOOKUP, HLOOKUP,
• COUNTIF, SUMIF. What-if-analysis
• Goal Seek
• Pivot Tables, NESTED IF
• Reporting
• Character Functions
• Date Functions
• Age Calculations
• Consolidation of Data
• Data Validation
• MACRO’S [Intro]
• Introduction to VBA Prog.
LIVE Projects: Over 30 projects

MS-ACCESS:

• Introduction to Ms-Access
• Creating Tables
• Creating Tables
• Creating Simple Queries using QBE grid
• Prompting for selected Criteria
• Creating simple forms using Form Wizards
• Introduction to macros
• Creating Reports
• Creating graphs from your data
FINANCIAL Accounting
• Creating A Company
• Company Configuration
• Setting up a New Company
• Ledger / Creating Groups
• Account Heads / Voucher Entry
• Payment / Receipt Voucher
• Contra Entry
• Purchase / Sales Register
• Creating Cost Centres
• Cost & Ratio Analysis
• Creating Trial Balance
• Viewing Statement of Accounts
• Profit & Loss Account
• Balance Sheet
• Bank Reconciliation
• Interest Calculation
• Printing of Accounts
• Bank & Cash Books
• Display of Accounts
• Company Configuration
• Company Controls
• SERVICE TAX, TDS
• VAT CALCULATION

INVENTORY

• Features
• Stock Groups
• Stock Items
• Physical Stock Voucher
• Creating Units of Measure
• Rejections In & Out
• Purchase & Sales Order
• Multi Currency
• Invoicing, Bill or Stock Wise
• Debit / Credit Notes
• Budgets & Controls
• Multiple Godowns
• Rejection Notes
• Sales Plan / Purchase Plan
• Sales Order Processing
• Purchase Order Processing
• Maintaining Physical Stock
• Inventory Reports & Statements
• Interest Calculation
• PRINT PREVIEW
Work on LIVE PROJECTS & ASSIGNMENTS


1