Intern - Excel & VBA Specialist

Job Description: Excel & VBA Specialist

Position Overview
We are seeking a detail-oriented and technically skilled professional with strong expertise in Microsoft Excel and VBA to support our business operations. The ideal candidate will be responsible for developing, maintaining, and optimizing data models, dashboards, and automation solutions that enhance reporting accuracy, efficiency, and decision-making.

Key Responsibilities
Develop and maintain advanced Excel reports, dashboards, and templates to support business needs.

Create and optimize VBA macros to automate repetitive tasks, improve reporting processes, and enhance data accuracy.

Work with large datasets to perform data cleaning, validation, and analysis.

Collaborate with cross-functional teams (Sales, Finance, Operations, etc.) to gather requirements and provide actionable insights.

Troubleshoot and maintain existing Excel/VBA applications, ensuring minimal downtime.

Implement best practices in data handling, automation, and documentation.

Support migration of manual reports into automated tools and dashboards.

Required Skills & Qualifications
Strong proficiency in Microsoft Excel (Pivot Tables, Power Query, advanced formulas, conditional formatting, what-if analysis).

Hands-on experience in VBA programming (creating macros, user forms, error handling, automation scripts).

Good understanding of data analysis, reporting, and visualization.

Ability to manage multiple tasks with attention to detail and deadlines.

Strong problem-solving and analytical skills.

Bachelors degree in Computer Science, Information Systems, Business, or related field (preferred).

Preferred Skills (Good to Have)
Experience with Power BI, SQL, or Python for advanced analytics.

Knowledge of ERP/CRM systems and data integration.

Exposure to dashboarding and business reporting for management.