PAVITRA COMPUTER INSTITUTE

Bestseller

0 rating

Certificate In Advanced Excel & Tally Prime with GST(M-AE&TPWG-3556)

Last updated Apr, 2026
Certified Course

₹6,500 ₹9,000

Enquire Now

Course Includes

Duration3 Months
Enrolled2
Lectures75
Videos0
Notes0
CertificateYes

What you'll learn

💼 Computerized Accounting with Advanced Excel & Tally Prime (GST)

👉 यह एक job-oriented professional course है जिसमें आपको accounting और data management की पूरी practical training दी जाती है 📊🧾

इस course में आप Microsoft Excel, Tally Prime और GST system को basic से advanced level तक सीखेंगे, जिससे आप किसी भी company में accounting और office work आसानी से कर सकेंगे।

📚 Course Highlights

✔ Advanced Excel (Formulas, Pivot Table, Dashboard, MIS Reporting)
✔ Tally Prime with GST (Billing, Accounting, Inventory)
✔ GST Practical Training (Returns, E-Way Bill, Filing)
✔ Real-Time Projects & Practical Work
✔ Job-Oriented Training Approach

🎓 💡 Course Benefits

💼 Accounting + Excel दोनों skills एक साथ

📈 Job Ready बनाता है (Office + Accounts दोनों roles)

🧾 GST Practical knowledge (real business use)

🚀 Fresher से Professional बनने का complete रास्ता

⏱️ Course Duration

👉 2 से 3 महीने (Fast Track + Practical Training)

💼 Career Opportunities

Accountant
MIS Executive
Billing Executive
Data Analyst (Entry Level)
Office Executive

Course Syllabus

🟢 Module 1: Computer Fundamentals (Basic Foundation)

Computer Basics & Operating System
File Management
Internet & Email Usage
Typing Basics

🟡 Module 2: Microsoft Excel (Basic to Advanced)

Workbook, Worksheet, Formatting
Basic Formulas (SUM, AVERAGE, COUNT)
Cell Referencing

🔹 Intermediate Excel

Logical Functions (IF, AND, OR)
Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
Data Sorting & Filtering

🔹 Advanced Excel

Pivot Table & Pivot Charts
Conditional Formatting
Data Validation
Dashboard Creation
MIS Reports

🟠 Module 3: Tally Prime (Accounting)

🔹 Basics of Accounting

Accounting Concepts
Types of Accounts
Golden Rules

🔹 Tally Prime Practical

Company Creation
Ledger & Group Creation
Voucher Entry (Payment, Receipt, Sales, Purchase)
Inventory Management

🔹 Banking & Reports

Bank Reconciliation
Trial Balance
Profit & Loss Account
Balance Sheet

🔵 Module 4: GST (Goods & Services Tax)

GST Introduction & Structure
GST Registration Process
GST Billing in Tally
GST Returns (GSTR-1, GSTR-3B)
E-Way Bill System
Practical GST Filing

🟣 Module 5: Advanced Practical Training (Job Ready Skills)

Real Company Data Entry Practice
Excel + Tally Data Analysis
MIS Report Preparation
Invoice & Billing Projects
Error Finding & Correction

🔴 Module 6: Professional Development

Resume Building 💼
Interview Preparation 🎯
Job Guidance & Placement Support

⏱️ Course Duration

👉 3 Months (Practical + Job Oriented)

Course Fees

₹9000/-

Discounted Fees

₹ 6500/-

Course Duration

3 Months

Review

0.0

Course Rating (0 reviews)

Featured review

No reviews yet. Be the first to review this course!

Call

Text Message

Review

CHAT

Certificate In Advanced Excel & Tally Prime with GST(M-AE&TPWG-3556)

Course Includes

What you'll learn

Course Syllabus

Course Fees

Review

Featured review

More Popular Courses

Certificate In Advance Excel with VBA(M-AEWV-2687)

Certificate In Computer Operator(M-CO-2273)

Related Courses

Certificate In Tally Prime with GST(M-CTPWG-2123)