Certificate in Tally With GST & MS Office

Description

Course Name: Certificate in Tally With GST & MS Office

Course Id: CTGMO/Q1001.

Eligibility: 10th Grade (High School) or Equivalent.

Objective: The Certificate in Tally With GST & MS Office course is designed to provide practical knowledge and skills in computerized accounting, GST compliance, and proficiency in Microsoft Office tools. This program prepares individuals for accounting and administrative roles in businesses, helping them manage financial records, taxation, and office-related tasks effectively.

Duration: Three Months.

 How to Enroll and Get Certified in Your Chosen Course:

 Step 1: Choose the course you wish to get certified in.

 Step 2: Click on the “Enroll Now” button.

 Step 3: Proceed with the enrollment process.

 Step 4: Enter your billing details and continue to course fee payment.

 Step 5: You will be redirected to the payment gateway. Pay the course and exam fee using one of the following methods:
Debit/Credit Card, Wallet, Paytm, Net Banking, UPI, or Google Pay.

 Step 6: After successful payment, you will receive your study material login ID and password via email within 48 hours of fee payment.

 Step 7: Once you complete the course, take the online examination.

 Step 8: Upon passing the examination, you will receive:
• A soft copy (scanned) of your certificate via email within 7 days of examination.
• A hard copy (original with official seal and signature) sent to your address within 45 day of declaration of result.

 Step 9: After certification, you will be offered job opportunities aligned with your area of interest.

Online Examination Detail:

Duration- 60 minutes.
No. of Questions- 30. (Multiple Choice Questions).
Maximum Marks- 100, Passing Marks- 40%.
There is no negative marking in this module.

Marking System:
S.No.	No. of Questions			Marks Each Question		Total Marks
1	10			5		50
2	5			4		20
3	5			3		15
4	5			2		10
5	5			1		5
	30					100
How Students will be Graded:
S.No.		Marks	Grade
1		91-100	O (Outstanding)
2		81-90	A+ (Excellent)
3		71-80	A (Very Good)
4		61-70	B (Good)
5		51-60	C (Average)
6		40-50	P (Pass)
7		0-40	F (Fail)

 Key Benefits of Certification- Earning a professional certification not only validates your skills but also enhances your employability. Here are the major benefits you gain:

 Practical, Job-Ready Skills – Our certifications are designed to equip you with real-world, hands-on skills that match current industry demands — helping you become employment-ready from day one.

 Lifetime Validity – Your certification is valid for a lifetime — no renewals or expirations. It serves as a permanent proof of your skills and training.

 Lifetime Certificate Verification – Employers and institutions can verify your certification anytime through a secure and reliable verification system — adding credibility to your qualifications.

 Industry-Aligned Certification –All certifications are developed in consultation with industry experts to ensure that what you learn is current, relevant, and aligned with market needs.

 Preferred by Employers – Candidates from ISO-certified institutes are often prioritized by recruiters due to their exposure to standardized, high-quality training.

 Free Job Assistance Based on Your Career Interests – Receive personalized job assistance and career guidance in your preferred domain, helping you land the right role faster.

Syllabus

Fundamentals of Accounting & Tally: Introduction to Accounting Principles, Types of Accounts & Golden Rules, Journal Entries & Ledger Posting, Trial Balance & Financial Statements, Basics of Tally ERP 9/Tally Prime, Company Creation & Configuration in Tally, Voucher Entry & Daybook, Bank Reconciliation Statement (BRS), Inventory Management in Tally, Security Control & User Management.

GST (Goods & Services Tax) in Tally: Introduction to GST & Taxation, GST Registration & Compliance, GST Invoicing & Bill Entry, Input Tax Credit (ITC) Management, GST Returns (GSTR-1, GSTR-3B, GSTR-9), E-Way Bill Generation, Reverse Charge Mechanism (RCM), GST Reports & Reconciliation, GST Audit & Annual Filing, Practical Case Studies on GST in Tally.

Advanced Accounting in Tally: Multi-Currency Accounting, Cost Center & Cost Category, Budgeting & Control in Tally, Payroll Management & Employee Provident Fund (EPF), TDS (Tax Deducted at Source) & TCS (Tax Collected at Source), Profit & Loss Statement & Balance Sheet, Bank Transactions & Loan Management, Depreciation & Fixed Asset Management, MIS Reports & Analysis, Exporting Data & Report Customization.

MS Word – Advanced Document Processing: Introduction to MS Word & Interface, Document Formatting & Styles, Tables, Charts & SmartArt, Page Setup & Layout Management, Header, Footer & Page Numbering, Mail Merge & Label Printing, Track Changes & Collaboration Tools, Protecting & Securing Documents, Macros & Automation, Printing & Exporting Documents.

MS Excel – Data Analysis & Reporting: Introduction to MS Excel & Interface, Data Entry & Formatting Techniques, Formulas & Functions (SUM, IF, VLOOKUP, HLOOKUP, INDEX-MATCH), Data Validation & Conditional Formatting, Pivot Tables & Pivot Charts, Data Sorting & Filtering, Charts & Graphs for Data Visualization, Macros & Automation using VBA, Excel Security & Protection, Importing & Exporting Data in Excel.

MS PowerPoint – Presentation Design: Introduction to PowerPoint & Interface, Slide Design & Themes, Text Formatting & SmartArt, Image, Video & Audio Integration, Animations & Slide Transitions, Charts & Diagrams in Presentations, Hyperlinks & Action Buttons, Slide Show Settings & Presenter View, Exporting & Sharing Presentations, Tips for Effective Presentations.

After successful completion of the Certificate in Tally with GST & MS Office program, graduates gain practical skills in accounting, taxation, GST compliance, and office productivity tools such as MS Word, Excel, and PowerPoint. This blend of skills prepares them for finance, admin, and data management roles across diverse sectors.

---

🎓 Career Options After Certificate in Tally with GST & MS Office

1. Accounts Executive / Junior Accountant

• Role: Maintain books of accounts, ledger entries, voucher recording, GST invoices, and financial statements using Tally.

• Salary Range: ₹2 – ₹4.5 LPA (fresher); up to ₹6.5 LPA with 3–5 years of experience

2. Tally Operator

• Role: Data entry of sales/purchase, inventory management, reconciliation, and report generation in Tally ERP or Tally Prime.

• Salary Range: ₹1.8 – ₹3.5 LPA

3. GST Assistant / Tax Executive

• Role: Prepare and file GST returns, manage invoices, calculate input/output GST, and help with compliance tasks.

• Salary Range: ₹2.2 – ₹4.5 LPA

4. Back Office Executive (Finance/Admin)

• Role: Document handling, Excel reporting, admin support using MS Office, and accounting documentation.

• Salary Range: ₹2 – ₹4 LPA

5. Data Entry Operator (Accounts Department)

• Role: Input financial data, maintain customer/vendor records, and create spreadsheets for reconciliation.

• Salary Range: ₹1.5 – ₹3 LPA

6. Office Assistant / Administrative Executive

• Role: Manage communication, reporting, filing, Excel spreadsheets, and assist with payroll/billing.

• Salary Range: ₹2 – ₹4.2 LPA

7. Billing & Invoicing Executive

• Role: Prepare tax-compliant bills using Tally, update accounts receivable/payable, and track payments.

• Salary Range: ₹2 – ₹3.8 LPA

8. MIS Executive (Junior Level)

• Role: Generate management reports, data summaries, and dashboards using Excel and Word.

• Salary Range: ₹2.5 – ₹5 LPA

9. Payroll Assistant

• Role: Use Tally Payroll or Excel to calculate salaries, deductions, PF/ESI, and maintain employee records.

• Salary Range: ₹2 – ₹4.5 LPA

10. Freelance Accountant / GST Return Filer

• Role: Manage books for small businesses, file GST, prepare reports, and offer Tally-based support.

• Earning Potential: ₹15,000 – ₹60,000/month depending on clients and experience

---

🧠 Key Skills Acquired

• Tally ERP 9 / Tally Prime (Accounting, GST, Payroll)

• GST concepts: input/output tax, GSTR filing, HSN/SAC codes

• MS Excel: VLOOKUP, Pivot Tables, Basic Formulas

• MS Word: Report and invoice preparation

• MS PowerPoint: Presentations for office and reporting

• Communication and email drafting skills

---

🏢 Industries Hiring Tally + MS Office Professionals

• Chartered Accountant (CA) Firms

• Manufacturing & Trading Companies

• Retail & Wholesale Businesses

• Real Estate, Hospitality, and Service Sector

• Educational Institutions, NGOs, and Startups

• Government & PSU Projects (contractual basis)

---

📈 Career Growth Path