EMPIRES COMPUTER
ISO 9001:2015 Certified Computer Institute
+91 99138 29112 | +91 63532 52072
empirescomputer81@gmail.com
Accounting master office
Official Course Syllabus & Career Roadmap
TALLY-EXCEL
Master Tally Prime GST accounting alongside Advance Excel data analytics, lookup formulas, and financial dashboards.
Course Overview
Master Tally Prime GST accounting alongside Advance Excel data analytics, lookup formulas, and financial dashboards.
Target Audience & Who Should Join
- Commerce Students (B.Com, M.Com, BBA, MBA) aiming for Accountant jobs
- Non-commerce graduates wanting a practical accounting career
- Business owners & managers managing GST invoices & accounts
- Billing operators & finance assistants seeking skill upgrade
Detailed Course Syllabus Modules
Module 1: Tally Prime GST Accounting Core
- Tally Prime Company Creation, Ledgers & Chart of Accounts
- Real Company Purchase & Sales Invoice Voucher Entry
- GST Setup, Tax Invoices & Inventory Tracking
Module 2: Data Export & Advance Excel Lookup
- Exporting Tally Financial Reports to Excel Spreadsheets
- Advance Excel Lookup Functions (VLOOKUP, XLOOKUP, INDEX-MATCH)
- Logical & Financial Formulas (IF, SUMIFS, COUNTIFS)
Module 3: Pivot Tables & Financial Analysis
- Dynamic Pivot Tables & Slicers for Accounting Data
- Data Cleaning, Text-to-Columns & Deduplication
- Financial Data Reconciliation & Audit Techniques
Module 4: Financial Dashboards & Certification
- Interactive Financial Executive Dashboard Creation
- Practical Accounting Analytics Project
- Dual Certification in Accounting & Data Analytics
Career Opportunities & Job Profiles
Junior / Senior Accountant
GST Tax Consultant
Tally Prime Operator
Billing Specialist
Audit & Accounts Assistant
Empires Computer Rajkot - 100% Practical Training & Placement
Generated Date: 06 Nov 2026