Courses in Anthiyur – online, hybrid or classroom

Turmeric and agri-trade

Commission agents and traders need accounts and GST filing.

Textile and power-loom units

Maintenance staff use electrical and PLC knowledge.

Tally Prime 80–110 h

You will learn to

• Secure, back up, split and move company data to a new financial year
• Create a company, ledgers, groups and inventory masters in TallyPrime
• Use cost centres, budgets, multiple currencies, interest and bank reconciliation

Project to build: Trading firm books for a month. Record purchases, sales, receipts and payments for a small trader and produce the trial balance and final accounts.

Tools covered: Cost centres, budgets and scenarios, Backup, restore, import and export, Order processing, batches, BOM and POS, Migration from Tally.ERP 9, Bank reconciliation.

Master level: Commerce students and accounts staff who want the complete TallyPrime foundation and advanced syllabus in 80 hours, including the newer release features.

MS Office / Office Automation 24–128 h

You will learn to

• Use styles, tables, headers, citations and mail merge for letters and reports
• Manage email, contacts, rules, calendar and tasks in Outlook (Course on Office Automation)
• Record transactions, GST and payroll in TallyPrime (Advanced Certificate)

Project to build: Formatted research report. Set up a report with headings, a table of contents, headers, footers and citations.

Tools covered: TallyPrime (Advanced Certificate), Microsoft Outlook, Microsoft Excel, Microsoft PowerPoint, Microsoft Access.

Foundation level: Learners who want the full Microsoft Office 2021 suite in 64 hours – Word, Excel, PowerPoint, Access and Outlook – with hands-on projects.

Advanced Excel 24 h

You will learn to

• Record, run and manage macros to automate repeated tasks
• Summarise data with pivot tables, calculated fields, grouping and slicers
• Protect sheets and workbooks and prepare them for printing

Project to build: Sales dashboard with pivots. Summarise a year of sales by region, product and month with pivot tables, charts and slicers.

Tools covered: Microsoft Excel (Microsoft 365 / Office), Macro recorder, Pivot tables, pivot charts and slicers, Goal Seek, Data Tables, Scenario Manager, Solver add-in.

Foundation level: Students, job seekers and office users who want to go from Excel basics to lookups, pivot tables, arrays, Solver and macros in 24 hours.

Business Accounting & Taxation 256–370 h

You will learn to

• Reconcile bank accounts and manage users, backups and data security
• Process payroll and build reports with Advanced Excel pivot tables, charts and macros
• Prepare financial statements, ratio analysis and MIS reports

Project to build: TDS on expenses. Book rent and professional fees with TDS, generate the challan and prepare the TDS report (Masters level).

Tools covered: GST portal workflows (GSTR-1, GSTR-3B, GSTR-9), E-way bill and e-invoice, TDS (Form 26Q, ITNS 281 challan), Payroll in Excel, TallyPrime.

Professional level: Learners who want a 256-hour job-oriented programme covering accounting, TallyPrime, GST, income tax, ESI/EPF, advance tax, MIS, Advanced Excel and payroll.