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