Job Description
Job Summary:
We are looking for a detail-oriented and highly skilled Advanced Excel Specialist to manage, analyse, and interpret large datasets. The ideal candidate will be proficient in advanced Excel functions, data visualization, and automation tools like VBA and Power Query, and will play a critical role in supporting data-driven decision-making across departments.
Key Responsibilities:
- Design, develop, and maintain complex Excel-based reports and dashboards.
- Use advanced Excel functions to manipulate and analyse large datasets.
- Automate repetitive tasks using VBA macros, Power Query, and Power Pivot.
- Perform data validation, cleaning, and transformation to ensure accuracy.
- Create dynamic reports using PivotTables, Pivot Charts, and conditional formatting.
- Develop dashboards and KPI trackers for business performance monitoring.
- Collaborate with cross-functional teams to gather requirements and delive...