Advanced Excel roles focus on manipulating large datasets, automating tasks, and creating interactive dashboards to drive business decisions. Key responsibilities include utilizing VBA/Macros, pivot tables, complex formulas (VLOOKUP, Index-Match), and data visualization tools to produce MIS reports, optimize workflows, and ensure data integrity.
Required Skills & Qualifications
- Advanced Formulas: Proficient in INDEX-MATCH, VLOOKUP, HLOOKUP, SUMIFS, COUNTIFS, and nested IF statements.
- VBA & Macros: Ability to write, record, and debug code to automate processes.
- Data Tools: Expert in Pivot Tables, Data Validation, Power Query, and Solver.
- Visualization: Strong skills in creating charts, graphs, and dashboards.
- Soft Skills: Strong analytical thinking, attention to detail, and communication skills.
Pay: ₹10,000.00 - ₹16,000.00 per month
Benefits:
Work Location: In person
