OBJECTIVE :

Upon completion of this course the participant will have a thorough knowledge in Microsoft Office suite and TallyPrime.

TARGET AUDIENCE :

School Final / Diploma / B.Com / M.Com / MBA.School Final / Diploma / B.Com / M.Com / MBA. suite and TallyPrime.

PREREQUISITES :

No prior Computer knowledge is required. suite and TallyPrime.

OVERVIEW :

This course provides the participant the knowledge of MS-Office and Accounting which is the basic requirement of any organisation.

COURSE COVERAGE :

END USER APPLICATION

WINDOWS Computer Fundamentals - Introduction to OS/GUI - Wordpad - Notepad - Paintbrush - Windows Explorer - Control Panel.

WORD :Creating Text and Documents - Indexes and Tables - Embedding Picture - Table Manipulation - Mail Merge - Macro.

EXCEL :Formatting Cells - Charts - Pivot table - Data Table - Forms - Scenarios - Goal seek - Macros and Modules.

POWERPOINT: Creating Presentations - OLE - Enhancing Presentation - Adding Audio & Video - Special Effects.

INTERNET Introduction to Internet, www, http & E-mail - Creating E-mail ID - Receiving & Sending E-mail - Chatting - Locating Information - Downloading.

TALLY PRIME
INTRODUCTION TO TALLY PRIME: Principles of Accounting – 5 Steps - Maintaining Company Data - F11 Features, F12 Configure.

MASTERS : Group-Ledger-Chart of accounts-Stock Group-Stock Category-Unit of measurement-Godown-Stock Item.

TALLY VOUCHERS : Accounting, Inventory Vouchers.

REPORTS : Balance Sheet - P & L A/c - Ratio Analysis - Cash Flow, Fund flow Statements - Ageing Analysis - Movement Analysis.

ADVANCED ACCOUNTING : Bill wise Details - Cost Centres and Cost Categories - Voucher Classes and Cost centre Classes - Multiple Currencies - Bank reconcilliation - Interest Calculation - Budgets & Scenario - Job Costing.

ADVANCED INVENTORY :Order Processing - Reorder Levels - Tracking Numbers - Batch wise Details - Additional cost Details - Bill of Materials - Price List.

SYSTEM ADMINISTRATION AND OTHER UTILITIES

CONSOLIDATION OF ACCOUNTS - Tally vault - Security Control - Tally Audit - Back up and Restore - Split company Data - Export and Import of Data - ODBC Compliance.

POINT OF SALES : Predetermination of Invoice - Multi payment Modes - Small & Smart Bills - POS Sales Register.

MULTI LANGUAGE : Supporting OS - Translation or Transliteration - System & Phonetic Keyboard - Sourcing from other Software.

GOODS & SERVICE TAX (GST) : Accounting of Purchase or Sales returns - Inter State Trade Accounting - Accounting of Exempted Items - Accounting Purchases from Unregistered Dealers - Accounting Input Credit on Capital Goods - GST Computation & Forms.

TDS & TCS : Entry - Calculator - Reports - e Returns.

PAYROLL : Introduction to Payroll - Configuring Tally for Payroll - Creation of Payroll Masters - Recording of attendance - Preparation of Payroll Vouchers based on attendance - Preparation of a Salary Disbursement Voucher - Payroll Reports (Pay slip, Pay Sheet, Payroll Statement, Payment Advice, Payroll Register, Attendance Sheet, Attendance Register) - Introduction to Provident Fund.

MINI PROJECT With our guidance, students will develop Financial Accounting System, Inventory control, etc.