Training

Duration-8 Months (I^st+II^nd Semester)

Certificate In Data Entry Operator
Semester-1 (4 Month Duration)

Fundamental of Computer

Computer & its feature, task of computer, peripherals devices, computer generation(description) memory & it measurement, commuter architecture ,binary & decimal conversion.

Networking

Networking, types of networking, topology, protocol, iso-osi model

Operating system

CUI(character User Interface)-DOS GUI(graphic User Interface)-window7,window 8,window 10

Window

Work with taskbar, task manager, work control panel, operating system accessories-notepad, WordPad ,paint.

Office automation (MS Office):2019,2021 and other upgraded version

Ms Word

Create a new document, open, save and print a document, Edit and format text, change the page layout, background and borders, format document, work with text object, work with References Insert headers and footers, Insert and edit tables, Insert clip art and pictures to document, Perform a mail merge, share and review shared document files. Project Work : Resume creation, form creation, and other professional document.

Ms – Excel

Introduction of excel workbook, shortcut key and various selection techniques, customizing Excel, Freezing panes. Using Basic Function: sum(), Average(), Max(), Min(), Count(). Mathematical function: Sumif(), Countif(), sumifs(). Other function: today(), now(), day(), date(), Upper(), Lower(), etc Formatting and proofing: Formating cell, Alignment, Border its, using conditional formatting. Managing worksheets: Data sorting & data Filtration, Excel sheet protection.

Advance Excel

Data Analysis, Goal seek, Data table (PMT Function), Logical function, data Validation, Lookup function, Pivort chart in excel chart various chart: Bar chart, pivot chart, pie chart, Line chart etc. Database function : Dsum(), Dcount(), Dmax(), Dmin() etc. Work with VBA Application(Project),Form Designing in VBA.

Power Point

Create presetation, work with colour & Theme in powerpoint, Insert clipart, Image, shapes to slide. Add sound & video, to a slide presentation, work with Animation in presentation, Final Preparation present a presentation.

Internet and Web design

Introduction of Browser, Domain name system. Work with Email : Email A/c creation & Email composing and file attachment. Online form felling and file attachment, online shopping. File upload and downloading

Semester-II:(4 Month Duration)
(Computerize Accounting & Tally)

Basic Accounting Terms

Capital,Assets,Drawing,Debit,Credit,Creditor, Debtor,Principal Of Accounting ,Ledger,Voucher,Day Book ,Balance Sheet,P&L A/C ,Journal Entries.

Tally overview

Getting Function Of Tally.ERP9,Creating/Setting Up Of Company,Accounting Master In Tally.ERP9 ,F11:Feature,F12:Configuration,Setting Up Account Heads. Inventory In Tally.ERP9:Stock Group,Stock Category,Location/Godown,Unit Of Measurement,Stock Item Voucher Entry In Tally: Accounting Voucher , Inventory Voucher,Invoicing.

Advance Accounting In Tallyerp.9

Credit Limit ,Bill Wise Detail, Interest Calculation, Cost Center & Cost Categories, Advance Inventory In Tally Erp.9

Advance Inventory

Order Processing: Purchase Order Processing ,Sale Order Processing, Additional Cost Detail, Bill Of Material(BOM),Price Level And Price List Of Stock Valuation ,Difference Actual And Billed Quantities, Zero Value Entries.

Point Of Sale (Pos)

Feature Of Point Of Sale, Entries Pos Transaction, Pos Report.

Taxation

Tax Deduction At Source (TDS)

Basic Concept Of Tds, Configuring Tds In Tally.Erp9, Processing Transaction Tds Reports.

Tax Collected At Source(TCS)

Basic Concept Of Tcs , Configuring Tcs In Tally.Erp9,Processing Transaction Tcs Reports.

Goods And Service Tax(Gst)

Basic Concept Of Gst, Basic Concept Of Cgst, Sgst, Igst, Configuration Gst In Tallyerp.9,Work With Different Rate Of Gst, Gst Implementation With Item Rate & Item Value Create Sale & Purchase Invoice With GST..

Payroll Accounting

Configuration Payroll In Tally.Erp9 ,Creating Payroll Masters ,Processing Payroll In Tally.Erp9,Generating Payroll Reports.

Other Feature

Bill Printing With Compony Logo Security & Control , Backup & Restore ,Security Control Utilization Banking Reports, Export & Import, Challan Reports, Statement Reports, Closing Stock.