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
- Accounting Basics & Double Entry System
- Tally Prime Interface & Company Creation
- Ledgers, Groups & Masters
- Accounting & Inventory Configuration
Module 2: Accounting & Inventory
- Contra, Payment, Receipt & Journal Vouchers
- Sales & Purchase Entries
- Debit/Credit Notes
- Bill-wise Details
- Inventory, Stock Items & Godowns
- Purchase/Sales Orders
- Basic Manufacturing
Module 3: Reports & Banking
- Trial Balance
- Profit & Loss Account
- Balance Sheet
- Cost Centres & Budgets
- Bank Reconciliation (BRS)
- Banking & Financial Reports
Module 4: GST & Taxation
- GST Configuration
- CGST, SGST & IGST
- GST Sales & Purchase
- GST Reports
- TDS & TCS Basics
Module 5: MS Excel Fundamentals
- Excel Interface & Worksheets
- Data Entry & Formatting
- Basic Formulas
- AutoFill & Flash Fill
- Page Setup & Printing
Module 6: Excel Formulas & Functions
- SUM, AVERAGE, COUNT, IF
- SUMIF, COUNTIF
- VLOOKUP, HLOOKUP & XLOOKUP
- INDEX & MATCH
- Text & Date Functions
- Relative & Absolute References
Module 7: Excel Data Analysis
- Sorting & Filtering
- Data Validation
- Conditional Formatting
- Excel Tables
- Charts & Graphs
- Pivot Tables & Pivot Charts
- Slicers
Module 8: Advanced Excel & Projects
- MIS Reports
- Sales & Purchase Analysis
- Expense & Profit Analysis
- Salary & Inventory Sheets
- Basic Dashboard
- Practical Exercises
- Final Project
Bestseller
