Module 1: Computer Fundamentals

• Introduction to Computers
• Windows Operating System
• File & Folder Management
• Internet & Email Basics
• Keyboard Shortcuts
• Data Backup & Security

Module 2: Fundamentals of Accounting

• Introduction to Accounting
• Accounting Principles
• Golden Rules of Accounting
• Journal, Ledger & Trial Balance
• Profit & Loss Account
• Balance Sheet Basics

Module 3: TallyPrime Fundamentals

• Introduction to TallyPrime
• Company Creation
• Company Features & Configuration
• Company Backup & Restore
• Accounting Masters Creation

Module 4: Accounting in TallyPrime

• Ledger Creation
• Group Creation
• Voucher Types
• Contra Voucher
• Payment Voucher
• Receipt Voucher
• Journal Voucher
• Purchase Voucher
• Sales Voucher
• Debit Note & Credit Note

Module 5: Inventory Management in TallyPrime

• Stock Groups
• Stock Categories
• Stock Items
• Units of Measure
• Godown Management
• Purchase Orders
• Sales Orders
• Inventory Vouchers

Module 6: GST in TallyPrime

• GST Concepts
• GST Setup & Configuration
• GST Purchase Entries
• GST Sales Entries
• Input Tax Credit (ITC)
• GST Reports
• GSTR-1 & GSTR-3B Overview
• E-Way Bill Basics

Module 7: Banking & Payroll in TallyPrime

Banking

• Bank Reconciliation (BRS)
• Cheque Printing
• E-Payments & E-Receipts

Payroll

• Employee Creation
• Pay Heads
• Attendance Management
• Salary Processing
• Payslip Generation

Module 8: TallyPrime Reports & MIS

• Trial Balance
• Profit & Loss Account
• Balance Sheet
• Cash Flow Statement
• Outstanding Reports
• Ratio Analysis
• MIS Reports

Module 9: Microsoft Excel Fundamentals

• Excel Interface
• Workbook & Worksheet Management
• Data Entry Techniques
• Formatting Cells
• Rows, Columns & Sheets
• Page Setup & Printing

Module 10: Excel Formulas & Functions

• AutoSum
• Basic Mathematical Functions
• IF Function
• AND, OR Functions
• COUNT, COUNTA, COUNTIF
• SUMIF, SUMIFS
• AVERAGE Functions
• Date & Time Functions
• Text Functions

Module 11: Advanced Excel

• Conditional Formatting
• Data Validation
• Sorting & Filtering
• Remove Duplicates
• Text to Columns
• Flash Fill
• Named Ranges
• Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)

Module 12: Excel Data Analysis & Dashboard

• Pivot Tables
• Pivot Charts
• Interactive Reports
• MIS Dashboard Creation
• Slicers & Timelines
• Data Analysis Techniques
• Business Reporting

Module 13: Business Projects

Tally Projects

• Trading Business Accounting
• Service Business Accounting
• GST Accounting Project

Excel Projects

• Payroll Management Sheet
• Inventory Management Sheet
• Sales Analysis Dashboard
• Expense Tracker
• MIS Reporting Dashboard

Module 14: Job Readiness & Placement Support

• Accounts Executive Training
• GST Executive Training
• Tally Operator Skills
• Excel Interview Questions
• Resume Building
• Mock Interviews
• Practical Assessment

Course Duration

• TallyPrime: 40 Hours
• Advanced Excel: 30 Hours
• Projects & Assessment: 10 Hours

Career Opportunities

• Accounts Executive
• Tally Operator
• GST Executive
• MIS Executive
• Data Analyst (Entry Level)
• Back Office Executive
• Office Accountant

Certification

✅ Certificate in Tally & Advanced Excel

✅ Project Completion Certificate

✅ Placement Assistance Certificate (If Applicable)

Manual Accounting

Tally Software (Accountancy, Inventory, Taxation)

Advanced GST, TDS, TCS

Accounting Fundamentals

Excel Adwance