Combo of MS-OFFICE, TALLY ERP, TALLY GST & ADVANCE EXCEL

The objective of this module is to prepare the student with in-depth knowledge of Business Automation Tools and Tally ERP, MSoffice, Tally GST & Advance Excel to handle daily business accounting system of any organization. The participant learns the use for making reports useful for management.

  • Introduction for Word Processor Packages.
  • Computer Introduction and Definition.
  • CPU, (ALU, Control Unit, Memory).
  • Hardware and Software.
  • Creating Folders.
  • Input Output Devices.
  • ROM, RAM, EPROM.
  • Operating System Fundamentals.
  • Utilities.

  • Creating, editing, saving and printing text documents
  • Font and paragraph formatting
  • Simple character formatting
  • Inserting tables, smart art, page breaks
  • Using lists and styles
  • Working with images
  • Using Spelling and Grammar check
  • Understanding document properties
  • Mail Merge

  • Spreadsheet basics
  • Creating, editing, saving and printing spreadsheets
  • Working with functions & formulas
  • Modifying worksheets with color & auto formats
  • Graphically representing data : Charts & Graphs
  • Speeding data entry : Using Data Forms
  • Analyzing data : Data Menu, Subtotal, Filtering Data
  • Formatting worksheets
  • Securing & Protecting spreadsheets

  • Opening, viewing, creating, and printing slides
  • Applying auto layouts
  • Adding custom animation
  • Using slide transitions
  • Graphically representing data : Charts & Graphs
  • Creating Professional Slide for Presentation

  • Introduction to Internet.
  • Hardware and Software Requirements.
  • Internet Types.
  • Advantage of Internet.
  • Internet Browser/WWW/Surfing/Search Engines.
  • Concept of E-mail.
  • Advantages of E-mailing.
  • Creating free E-mail

  • Introduction to MS Excel.
  • Sorting and Filtering Data
  • Conditional Formatting, Working with Styles
  • Logical functions
  • Mathematical and Statistical Functions
  • Lookup Functions
  • Data Validation
  • Working with Templates
  • Date and Time Functions
  • Text Functions
  • Database Functions
  • Financial Functions
  • Creating Pivot Tables using Pivot Table options.
  • Security and Protection for Worksheets.
  • Excel VBA Macros

  • Financial Accounting Principle.
  • Creating Company in Tally-Use of Tally Vault Password.
  • Ledgers, Groups.
  • Inventory Records, Creating Unit Measurement.
  • Concepts of Ledger Entry.
  • Creating Cost Centers.
  • Making Memo Entries.
  • Orders Entry.
  • Understanding Day Book Reports.
  • Altering and Deleting Transactions, Cheque Printing.
  • Pre-Allocation of Bills.
  • Bank Reconciliation.
  • Understanding BRS Process
  • Manufacturing Vouchers.
  • Budgets and Controls.
  • Stock Valuation-Cash Book and Bank Book.
  • Understanding Payroll.
  • Understanding Tally Audit.

  • What is GST?
  • Introduction of GST in Tally.
  • Enabling GST in F11 Features.
  • Creating Stock Item with GST.
  • Creating Purchase Ledger with GST.
  • Creating Sales Ledger with GST.
  • Creating Output GST Tax Ledger.
  • Creating Customer Ledger.
  • Creating Supplier Ledger.

  • HSC & Above
  • Graduate & Above
3 to 4 Month
  • Basic Computer Knowledge
  • Tally Operator
  • Office Assistant