Key Responsibilities

- Prepare, maintain, and automate daily, weekly, and monthly MIS reports.
- Work with large datasets and perform data cleaning, sorting, filtering, and analysis.
- Use advanced Excel formulas to automate calculations and reporting activities.
- Develop automated Excel reports using logical and lookup functions.
- Create interactive reports and summaries using Pivot Tables.
- Apply Data Validation and Conditional Formatting to maintain data accuracy.
- Identify repetitive manual tasks and suggest Excel-based automation solutions.
- Maintain employee, operational, attendance, and performance-related reports.
- Ensure accuracy, consistency, and timely delivery of reports.
- Coordinate with different departments to collect, verify, and consolidate data.

Required Technical Skills 1. Logical Functions

- IF
- Nested IF
- AND and OR
- COUNTIF and COUNTIFS

2. Lookup Functions

- VLOOKUP
- HLOOKUP

3. Mathematical and Statistical Functions

- SUM
- SUMIF
- AVERAGE
- AVERAGEIF
- COUNT
- COUNTA

4. Data Management

- Data Validation
- Conditional Formatting
- Sorting and Filtering
- Duplicate Identification and Removal
- Data Cleaning and Formatting

5. Pivot Tables and Reporting





- Creating and managing Pivot Tables
- Department-wise and employee-wise reports
- Summary reports and data analysis
- Report formatting and presentation

6. Cell References

- Relative References (A1)
- Absolute References ($A$1)
- Mixed References ($A1 and A$1)

Desired Candidate Profile
- Strong working knowledge of Microsoft Excel.
- Good analytical and problem-solving skills.
- Ability to handle large volumes of data.
- Good attention to detail and accuracy.
- Ability to automate repetitive reporting tasks.
- Good communication and coordination skills.

Preferred Skills (Additional Advantage)
- Basic knowledge of Power Query.
- Basic knowledge of Power BI.
- Basic VBA and Macro knowledge.

Basic understanding of IT operations and process automation. Pay: ₹15,000.00 - ₹25,000.00 per month

Perks

- Provident Fund

Application Question(s):
- Immediate Joiner
- Pls read JD carefully before applying for this Post
- WEST DELHI NEARBY

Education:
- Bachelor's (Required)

Experience:
- Advance Excel: 1 year (Required)

Work Location: In person

📌 Automation Technician - IT (Advance Excel) (Uttam Nagar)
🏢 Omega Biznis Support (India) Private
📍 Uttam Nagar