Job Description
Analyze large datasets using advanced Excel functions and tools
Create dynamic dashboards and reports for business insights
Use formulas such as VLOOKUP, HLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS
Work with Pivot Tables, Pivot Charts, and Data Validation
Automate repetitive tasks using Macros/VBA (preferred)
Clean, organize, and validate data for accuracy
Collaborate with team members to understand reporting needs
Generate weekly/monthly performance reports
Requirements
Strong proficiency in Microsoft Excel (Advanced level)
Good understanding of data analysis and reporting
Familiarity with Excel functions, charts, and dashboards
Basic knowledge of VBA/Macros is a plus
Strong attention to detail and problem-solving skills
Ability to work with large datasets efficiently