Responsibilities
1. Work on large Excel sheets for product data, pricing, stock updates, and catalog management.
2. Create, clean, and format data using advanced Excel tools.
3. Analyze data and generate quick reports when needed.
4. Maintain accuracy across all product sheets.
Required Skills (Expert in Advanced Excel)
1. VLOOKUP / XLOOKUP
2. Pivot Tables
3. IF, SUMIFS, COUNTIFS
4. Text functions (LEFT, RIGHT, MID, TRIM, etc.)
5. Data Validation
6. Conditional Formatting
7. Flash Fill
8. Filters, Sorting
Should know Alt-based shortcuts, navigation shortcuts, and speed-boosting commands.
Strong attention to detail & ability to work with huge datasets.