The project will focus on designing, developing, and implementing advanced Excel solutions that streamline reporting, improve data accuracy, and enhance decision-making. The consultant will be responsible for automating manual processes, building custom macros, and applying advanced Excel formulas to deliver efficient, reliable, and scalable outputs.

Key responsibilities will include:

1. Developing automation frameworks using Excel Macros and VBA.
2. Creating dynamic dashboards, pivot-based reports, and templates to simplify data analysis.
3. Implementing advanced lookup functions (VLOOKUP, INDEX-MATCH, XLOOKUP) and error-handling techniques.
4. Supporting data validation, consolidation, and reconciliation tasks.
5. Collaborating with stakeholders to understand reporting requirements and deliver tailored solutions.
6. Providing training and documentation to ensure smooth adoption by end-users.