Best Seller Icon Bestseller

Certificate In Tally Prime & MS Excel

  • Last updated Aug, 2026
  • Certified Course
₹4,500 ₹5,500

Course Includes

  • Duration3 Months
  • Enrolled3
  • Lectures30
  • Videos0
  • Notes0
  • CertificateYes

What you'll learn

Career Opportunities

After completing the course, students can apply for positions such as:

  • Tally Operator
  • Accountant
  • Accounts Executive
  • GST Assistant
  • Billing Executive
  • Back Office Executive
  • MIS Executive
  • Excel Executive
  • Data Entry & Office Executive


Course Outcome:

By the end of the course, students will be able to independently manage basic business accounting, GST transactions, inventory, financial reports in Tally Prime, and prepare professional business reports and data analysis using MS Excel.

Certification: ZNIIT Certified

Show More

Course Syllabus

Module 1: Accounting & Tally Prime Fundamentals

  • Introduction to Accounting
  • Accounting Terminology & Concepts
  • Double Entry System
  • Debit & Credit
  • Introduction to Tally Prime
  • Tally Prime Interface & Navigation
  • Company Creation & Configuration
  • Groups & Ledgers
  • Accounting & Inventory Masters
  • Opening Balances

Module 2: Accounting, Inventory & Banking

  • Contra, Payment, Receipt & Journal Vouchers
  • Sales & Purchase Vouchers
  • Debit Note & Credit Note
  • Bill-wise Details
  • Receivables & Payables
  • Stock Groups & Stock Items
  • Units of Measurement
  • Godowns & Locations
  • Purchase & Sales Orders
  • Inventory Reports
  • Bank Transactions
  • Bank Reconciliation Statement (BRS)

Module 3: Financial Reports & GST Taxation

  • Trial Balance
  • Profit & Loss Account
  • Balance Sheet
  • Day Book & Ledger Reports
  • Cost Centres & Budgets
  • Introduction to GST
  • GST Configuration in Tally Prime
  • CGST, SGST & IGST
  • GST Sales & Purchase Transactions
  • GST Invoice
  • Input Tax Credit
  • GST Reports
  • TDS & TCS Basics

Module 4: MS Excel Fundamentals

  • Introduction to MS Excel
  • Excel Interface & Workbook
  • Worksheets, Rows, Columns & Cells
  • Data Entry & Editing
  • Cell Formatting
  • Number, Date & Currency Formatting
  • Rows & Columns Management
  • Basic Formulas & Operators
  • AutoFill & Flash Fill
  • Sorting & Filtering
  • Page Setup & Printing

Module 5: Excel Formulas & Functions

  • Relative & Absolute Cell References
  • SUM, AVERAGE, MIN & MAX
  • COUNT & COUNTA
  • COUNTIF & COUNTIFS
  • SUMIF & SUMIFS
  • IF, AND & OR
  • IFERROR
  • VLOOKUP & HLOOKUP
  • XLOOKUP
  • INDEX & MATCH
  • Text Functions
  • Date & Time Functions

Module 6: Excel Data Analysis & Reporting

  • Excel Tables
  • Data Validation
  • Conditional Formatting
  • Remove Duplicates
  • Text to Columns
  • Find & Replace
  • Advanced Filter
  • Charts & Graphs
  • Pivot Tables
  • Pivot Charts
  • Slicers
  • MIS Reports
  • Sales & Purchase Analysis
  • Expense & Profit Analysis
  • Salary & Inventory Sheets
  • Basic Excel Dashboard
  • Professional Business Reports
  • Practical Exercises
  • Final Project

Eligibility

Who can apply for this course

Eligibility

  • 10th Pass (Minimum qualification)
  • Basic Computer Knowledge (Preferred)

Required Documents

  • 10th Marksheet
  • Aadhaar Card
  • Passport Size Photograph
  • Candidate Signature

Course Fees

Course Fees
:
₹5500/-
Discounted Fees
:
₹ 4500/-
Course Duration
:
3 Months

Review

5.0
Course Rating (3 reviews)
100%
0%
0%
0%
0%



Call
Text Message
Review
Brochure
Email
CHAT