Advanced Excel Expertise
- Advanced Excel formulas and functions (INDEX/MATCH, XLOOKUP, SUMIFS, COUNTIFS, OFFSET, INDIRECT, Agile Arrays)
- Creation and maintenance of complex Excel-based reports and dashboards
- Strong understanding of Pivot Tables, Pivot Charts, and Data Models
- Experience handling and analyzing large datasets efficiently

VBA / Macro Development
- Advanced VBA programming skills
- Modular VBA development (standard modules, class modules, reusable code)
- Structured error handling and debugging techniques
- Event-driven programming (Workbook_Open, Worksheet_Change, Worksheet_Activate, etc.)
- VBA performance optimization (arrays, dictionaries, screen updating control, calculation management)

Excel Object Model
- Expert knowledge of:
- Workbooks
- Worksheets
- Ranges
- Tables (ListObjects)
- Named Ranges
- Charts
- Events

Data Automation & Transformation
- Power Query for data extraction, transformation,



and loading (ETL)
- Data cleansing, normalization, and validation techniques
- Automation of data refresh processes
- Dependency and workflow management

Database & Integration
- ADO/DAO connectivity
- SQL query writing and database integration
- Experience working with external data sources:
- SQL Server
- Access
- CSV/Text Files
- APIs/Web Services

Reporting & Dashboarding
- Interactive dashboard development
- MIS and operational reporting automation
- KPI and business performance reporting
- Power Pivot and Data Model development

Performance & Quality
- Data accuracy and validation controls
- Troubleshooting and resolving Excel/VBA issues
- Code documentation and maintainability
- Version control and change management practices

📌 Advanced Excel Specialist (Delhi)
🏢 Capgemini
📍 Delhi