Course Syllabus
Module 1: Tally Prime with GST
अवधि: 6–8 सप्ताह
- Introduction to Accounting एवं Accounting Principles
- Golden Rules of Accounting
- Company Creation, Alteration एवं Configuration
- Groups, Ledgers एवं Voucher Entries
- Contra, Payment, Receipt, Journal एवं Sales/Purchase Vouchers
- Inventory Management, Stock Groups एवं Stock Items
- GST Setup, CGST, SGST एवं IGST
- GST Sales/Purchase Invoices एवं HSN/SAC
- Credit Note, Debit Note एवं Return Entries
- Bank Reconciliation Statement (BRS)
- Cost Centre एवं Cost Category
- Payroll एवं Employee Records
- Trial Balance, Profit & Loss Account एवं Balance Sheet
- Outstanding Reports, Day Book एवं Cash/Bank Book
- GST Reports एवं GSTR-1/GSTR-3B संबंधित रिपोर्ट
Module 2: Advanced Excel
अवधि: 4–6 सप्ताह
- Workbook, Worksheet, Rows, Columns एवं Cell Formatting
- Number, Date, Currency एवं Custom Formatting
- Basic Formulas: SUM, AVERAGE, MIN, MAX, COUNT
- Logical Functions: IF, AND, OR, IFERROR
- Conditional Functions: SUMIF, SUMIFS, COUNTIF, COUNTIFS
- Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP
- INDEX एवं MATCH
- Text Functions: LEFT, RIGHT, MID, LEN, TRIM, CONCAT
- Date Functions: TODAY, NOW, DATE, DAY, MONTH, YEAR
- Sorting, Filtering एवं Advanced Filter
- Data Validation एवं Drop-down List
- Conditional Formatting
- Remove Duplicates एवं Text to Columns
- Pivot Table एवं Pivot Chart
- Charts, Reports एवं Dashboard
- What-if Analysis एवं Goal Seek
- Protect Sheet/Workbook एवं Print Settings
Bestseller
