Advanced Excel Faculty

Qualification and Skills for Advanced Excel

1. Educational Qualifications

• Bachelor’s degree in Commerce, Business Administration, Computer Science, Data Analytics, or related field.
• Diploma or certification in Advanced Excel / Data Analytics preferred.

2. Technical Skills

• Proficiency in Excel formulas and functions (VLOOKUP, HLOOKUP, INDEX, MATCH, IF, SUMIF, COUNTIF, etc.).
• Data analysis tools (Pivot Tables, Pivot Charts, Power Query, Power Pivot).
• Conditional formatting for data visualization.
• Data validation and error checking.
• Advanced charting techniques.
• Working with large datasets and optimizing performance.
• Creating dashboards and reports.
• Using macros and VBA for automation (optional but preferred).
• Importing and cleaning data from external sources (CSV, SQL, Power BI integration).

3. Analytical Skills

• Strong problem-solving ability to interpret and analyze data.
• Understanding of business metrics and KPIs.
• Ability to summarize complex data into actionable insights.

4. Soft Skills

• Attention to detail and accuracy.
• Good communication for presenting data findings.
• Time management and ability to work on multiple datasets.
• Team collaboration with finance, operations, or analytics teams.

5. Bonus Skills

• Experience with Google Sheets and other spreadsheet tools.
• Knowledge of database concepts and SQL.
• Familiarity with BI tools like Power BI or Tableau.

Job Types: Full-time, Part-time, Freelance

Pay: ₹5,000.00 - ₹10,000.00 per month

Work Location: In person