Duration: 6 Months
Course Code: 1027
Advanced Excel
- Excel Interface & Advanced Shortcuts
- Advanced Formulas (IF, Nested IF, SUMIF, COUNTIF, Lookups)
- Data Validation & Conditional Formatting
- Pivot Table, Charts & MIS Reports
- Salary Sheet & GST Working Sheet
- Data Sorting, Filtering & What-If Analysis
- Basic Dashboard & Sheet Security
- Practical Assignments & Projects
Advanced Accounting in Tally Prime
- Company Creation, Alteration & Configuration
- Advanced Group & Ledger Management
- Purchase, Sales & GST Entries
- Payment, Receipt, Contra & Journal
- Debit/Credit Note & Bill Wise Management
- Inventory with GST & Bank Reconciliation (BRS)
- Payroll Management & GST Reports
- Financial Statements (Trial Balance, P&L, Balance Sheet)
- Data Backup, Security Control & Project Work