Advance Excel Intern

Noida - India

Monthly Salary: Not Disclosed

Experience Required: 0-1years

Posted on: 7 hours ago

Vacancies: 1 Vacancy

Job Summary

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

Required Skills:

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

Required Education:

Any Graduate.

Analyze large datasets using advanced Excel functions and toolsCreate dynamic dashboards and reports for business insightsUse formulas such as VLOOKUP HLOOKUP INDEX-MATCH IF SUMIFS COUNTIFSWork with Pivot Tables Pivot Charts and Data ValidationAutomate repetitive tasks using Macros/VBA (preferred)Cl...