DCA Courses

(Course Duration 3 Months)

• Computer Fundamental
• MS Office
• MS Word
• MS Excel
• Power Point
• MS DOS
• Internet etc.

Accounting Tally ERP-9/Prime

• Fundamental Of Tally, Manual Accounting
• Journal Entry, Voucher Entry, Ledger Creation, Profit & Loss, Balance Sheet, Trading A/c
• Stock (Inventory) Sales, Purchase Dr. Note, Cr. Note, Purchase Order Sales Order, Delivery Note, Rejection Out, Rejection In.
• Taxation (GST, CGST, SGCT, IGST, TDS, TCS) BRS (bank Reconciliation) Cost Center. Interest Calculation, Budgets. BOM (bill Of Material) Price List Data Import Pr Export, Payroll, POS (point Of Sales) Etc.

Module 1: Introduction of MS-Excel

• Calculations in Excel (Basic Formula's & Advanced Formula's)
• Calculations in Excel (Absolute/ Relative/Sheet Reference)
• Linking between Excel Files and Data, Chart Preparation in Excel with Details Features

Module 2: Advanced functions of MS-Excel

• Tabs and Menus of Excel, Office Button/File Menu
• Home Tab Options (Advanced Formatting & Paste Special)
• Specialized Effects like Formatting, Page Elements & Setup with Advanced Options.
• Formula Tab options with Auditing, Data Tools in Excel
• Advance Security Option from Review and View Tabs