ADVANCE EXCEL

Module 1: Advanced Data Management

• Data Cleaning Techniques (Text to Columns, Flash Fill)
• Data Validation (Custom Rules, Drop-downs)
• Remove Duplicates & Error Handling
• Structured Tables & Named Ranges
• Working with Large Datasets (Best Practices)

Module 2: Advanced Formulas & Functions

• Logical Functions: IF, IFS, SWITCH
• Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP
• INDEX + MATCH (Advanced Lookup Techniques)
• Text Functions: LEFT, RIGHT, MID, LEN, TRIM, CONCAT
• Date & Time Functions
• Dynamic Array Functions: FILTER, SORT, UNIQUE
• Error Handling: IFERROR, ISERROR

Module 3: Data Analysis Techniques

• Conditional Formatting (Advanced Rules)
• Pivot Tables (Advanced Features)
• Pivot Charts & Slicers
• Data Consolidation
• What-If Analysis (Goal Seek, Scenario Manager, Data Tables)

Module 4: Dashboard & Data Visualization

• Designing Interactive Dashboards
• Advanced Charting Techniques
• Dynamic Charts using Named Ranges
• Use of Form Controls (Drop-downs, Buttons)
• KPI Tracking & Business Metrics Visualization

Module 5: Power Query (Get & Transform)

• Importing Data from Multiple Sources (CSV, Web, Database)
• Data Transformation (Filtering, Merging, Appending)
• Cleaning & Reshaping Data
• Automating Data Refresh

Module 6: Power Pivot & Data Modeling

• Data Model Creation
• Relationships between Tables
• Introduction to DAX (Data Analysis Expressions)
• Calculated Columns & Measures
• Time Intelligence Functions

Module 7: Excel Automation with Macros & VBA

• Introduction to Macros
• Recording & Editing Macros
• VBA Basics (Variables, Loops, Conditions)
• Automating Reports & Tasks
• Creating User Forms (Basic)

Module 8: Advanced Reporting & MIS

• MIS Report Design
• Automated Reporting Systems
• Data Audit Techniques
• Financial & Operational Reports

Module 9: Collaboration & Security

• Workbook Protection & Encryption
• Sharing & Co-authoring
• Version Control
• Data Security Best Practices

Module 10: Integration & Productivity

• Excel with PowerPoint & Word Integration
• Import/Export with External Systems
• Keyboard Shortcuts & Productivity Hacks
• Excel Best Practices for Corporate Use 

TALLY WITH GST

Module 1: Fundamentals of Accounting

• Basic Accounting Concepts & Principles (GAAP Overview)
• Types of Accounts (Assets, Liabilities, Income, Expenses)
• Accounting Cycle & Double Entry System
• Journal, Ledger, Trial Balance
• Introduction to Financial Statements

Module 2: Introduction to Tally

• Overview of Tally Interface
• Company Creation & Configuration
• Features & Settings Customization
• Chart of Accounts (Groups & Ledgers)
• Voucher Entry System Overview

Module 3: Accounting in Tally

• Creating Ledgers & Groups
• Recording Transactions (Payment, Receipt, Contra, Journal)
• Sales & Purchase Entries
• Debit Note / Credit Note
• Bank Reconciliation

Module 4: Inventory Management

• Stock Groups, Categories & Units
• Godown (Warehouse) Management
• Stock Items Creation
• Inventory Vouchers (Purchase, Sales, Delivery Note, Receipt Note)
• Batch-wise & Expiry Management

Module 5: GST Fundamentals

• Overview of GST Structure (CGST, SGST, IGST)
• GST Registration & Compliance Basics
• GST Rates & HSN/SAC Codes
• Input Tax Credit (ITC) Concept
• Place of Supply Rules

Module 6: GST in Tally

• Enabling GST in Tally
• GST Ledger Creation
• Recording GST Transactions (Intra-state & Inter-state)
• Reverse Charge Mechanism (RCM)
• GST on Advance Receipts & Adjustments
• E-Way Bill Concept & Generation (Overview)

Module 7: GST Returns & Compliance

• GSTR-1 (Outward Supplies)
• GSTR-3B (Summary Return)
• GST Reconciliation
• Input Tax Credit Matching
• Exporting GST Reports for Filing
• Error Detection & Correction

Module 8: Advanced Accounting & MIS Reports

• Cost Centers & Cost Categories
• Budgeting & Scenario Management
• Ratio Analysis
• Cash Flow & Fund Flow Statements
• MIS & Financial Reports Customization

Module 9: Payroll Management in Tally

• Employee Creation & Payroll Setup
• Salary Structures
• Attendance & Leave Management
• Payslip Generation
• Statutory Compliance Overview (PF, ESI basics)

Module 10: Banking & Digital Accounting

• Bank Reconciliation Statement (BRS)
• E-Banking & Payment Advice
• Cheque Printing Configuration
• Digital Payment Integration Concepts

Module 11: Data Security & Audit

• User Roles & Access Control
• Data Backup & Restore
• Tally Vault (Data Encryption)
• Audit Features in Tally
• Compliance & Internal Controls

Module 12: International Accounting Perspective

• Overview of IFRS (International Financial Reporting Standards)
• Multi-Currency Accounting in Tally
• Forex Transactions Handling
• Export/Import Transactions
• Global Accounting Practices (Basic Overview)

Career Outcomes

• Data Analyst
• Business Analyst
• Accountant
• GST Executive
• MIS Executive
• Finance Analyst