Automation Technician - IT (Advance Excel)

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

Logical Functions

IF

Nested IF

AND and OR

COUNTIF and COUNTIFS

Lookup Functions

VLOOKUP

HLOOKUP

Mathematical and Statistical Functions

SUM

SUMIF

AVERAGE

AVERAGEIF

COUNT

COUNTA

Data Management

Data Validation

Conditional Formatting

Sorting and Filtering

Duplicate Identification and Removal

Data Cleaning and Formatting

Pivot Tables and Reporting

Creating and managing Pivot Tables

Department-wise and employee-wise reports

Summary reports and data analysis

Report formatting and presentation

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

Benefits

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