Course Curriculum
- Computer Fundamentals
- Paint
- Notepad
- WordPad
- MS Word
- MS Excel
- MS PowerPoint with Practical Knowledge
- Pivot Table
- Advanced VLOOKUP
- HLOOKUP
- Financial Functions
- Salary Slip
- SUMIF Functions
- COUNTIF Functions
- Index Match
- Subtotal Functions
- Ceiling & Floor Functions
- Date Function
- Working with Lists
- Working with Charts
- Tracing Formulas
- Error Checking
- DAY 360
- ROUND
- NOW
- TODAY
- WEEKDAY
- Data Validation
- Advanced Filters
- VBA
- Macro & Developer Tab Advanced Functions
- Accounts Basic Rules
- Trial Balance
- Ledger Creation
- Day Book
- Profit and Loss Account
- Balance Sheet
- Ratio Analysis
- Inventory & Stock
- Creation of Stock Item
- Godown
- Units, Category
- Stock Group
- Inventory Vouchers
- Stock Summary
- Statement of Inventory
- Sale and Purchase Order
- Delivery and Receipt Note
- Return Inward and Outward
- Sale and Purchase Invoices
- Credit and Debit Notes
- Manufacturing Vouchers
- Transfer of Material
- Bill of Material
- Cost of Components
- Price Level List
- Manufacturing Additional Cost
- Payroll Salary
- Creation of Payroll
- Categories Salary Head
- Statement Report of Payroll
- Single & Multiple Payslips
- Taxation
- VAT & TDS
- GST Functions
- HSN Code
- Create GST Ledger
- GST Voucher
- Sale and Purchase GST and IGST
- Calculation of GST and IGST with Live Practical Knowledge
- Master's
- Balance Sheet
- Stock Items
- Voucher Entry
- BOM
- POS
- TDS
- TCS
- Multi-Currency Batch Wise Details
- GST Single
- Multi-Rates GST
- Income Tax Basics
- Tax Payers Slabs
- Income Tax Rules
- TDS
- Income Tax Returns
- Form 26AS
- Form 16
- ITR-V
- Challan 280
