Tally Excel Training

Duration : 1.5 Months or 3 Months | Certification : ECIL - ECIT Certification

Course Description

This is course aims to develop skills in accounting and office administration. The course content includes MS Excel, Tally with GST.

Course Includes :

Hands-On Training
Live Projects
100% Placement Assistance

Course Duration :

Regular Course :   3 Months
Fast Track Course :   1.5 Months

Course Advantages

  • Govt. of India ( ECIL-ECIT) approved certificate
  • Online/Offline Facility Available
  • Latest syllabus and advanced lab facility
  • Excellent Placement Support

Course Features

  • A tally is accounting software used for Accounting purposes and making reports easily. Tally ERP. 9 is a widely used accounting software in India as well as many other international locations also.
  • Career Scope as Accounts Executive, Tally Operator, Sales Executive, Back office Executive, Sales Department, Tax Accountant, Junior Accountant, Accounts Manager, Import/Export Companies, Office Assistant, Office Executive, and Bank Clerks.

What you'll cover in this course

Ms-Excel

  • Introduction
  • Workbook
  • Worksheet
  • Spreadsheet
  • Basics
  • Modifying a worksheet
  • Formatting cells
  • Formulas and Functions
  • Sorting and filling
  • Filtering and database Tables
  • Charts
  • Pivot Table
  • Protection
  • Macros
  • Goal seek
  • Page properties and printing

Manual Accounting

  • Single column entry
  • Double column entry
  • Balance sheet
  • Profit / Loss Accounts
  • Debit / Credit
  • Income / Expense
  • Direct Income / Indirect Income
  • Direct Expense / Indirect Expense

Tally Accounting

  • Introduction to Tally
  • Tally accounting
  • Features
  • Configuration
  • Tally Inventory
  • Accounting Vouchers
  • Inventory Vouchers
  • Display and Reporting
  • VAT
  • Advanced Inventory
  • Stock Valuation Method
  • Advanced Invoicing
  • Advanced Reporting

Tally Vol 2

  • Advanced accounting
  • Bill wise details (Accounts payable, accounts receivable)
  • Cost centers And Cost Categories
  • Multiple currencies
  • Cheque printing
  • Bank reconciliation
  • Interest calculations
  • Voucher classes and cost center classes
  • Budgets and controls
  • Scenario management
  • Advanced inventory
  • Order processing
  • Reorder levels
  • Tracking numbers
  • Batch wise details
  • Additional cost details
  • Bill of materials
  • Price list
  • Stock valuation methods
  • Zero value entries in vouchers and transactions of consignment goods
  • Inventory ageing analysis
  • Advanced invoicing
  • Advanced reporting

Talk to Our Expert