Key Responsibilities:
Design and develop custom Excel VBA macros to automate repetitive tasks and workflows.
Create and maintain dynamic dashboards, reports, and tools using Excel and VBA.
Collaborate with stakeholders to gather requirements and translate them into functional solutions.
Troubleshoot, debug, and optimize existing Excel macros and tools.
Ensure data accuracy, integrity, and usability across all developed solutions.
Maintain clear documentation of code and processes for ongoing support and updates.
Required Skills:
Proficiency in Excel VBA programming.
Strong understanding of Excel features such as formulas, pivot tables, charts, and data validation.
Ability to build user-friendly interfaces and automate complex tasks.
Experience integrating Excel with other Office applications like Outlook, Word, or Access.
Strong problem-solving skills and attention to detail.
Ability to communicate technical concepts to non-technical users.
Preferred Skills (Optional):
Knowledge of Power Query, Power Pivot, or Power BI.
Familiarity with databases and basic SQL.
Understanding of process automation best practices.