Advanced Excel Specialist

Softcrayons IT Education; Dadri; On-site; INR 223,000 - 335,000; Full time

Job summary

Softcrayons IT Education is seeking an Advanced Excel Specialist to handle timesheet data, extract and enter hours into Excel files, and generate payroll-ready reports. The role involves coordinating with HR, payroll, and invoice teams and communicating with US candidates about their hours worked.

The ideal candidate has 0-2 years of experience, a Master’s degree, and strong skills in Pivot Tables, Power Query, and data validation, with a full-time position in Noida.

Qualifications

• Proficient in advanced Excel techniques and data analysis.
• Experience with data validation and reporting.
• Ability to produce error-free reports for payroll and HR.
• Experience interacting with US candidates re hours worked and inquiries.

Responsibilities

• Extract data and create reports in Excel for payroll and HR teams.
• Interact with US candidates about hours worked and resolve inquiries.
• Prepare payroll-ready reports and support invoice, payroll and HR teams.
• Submit error-free reports as required by management.

Skills

Pivot Tables & Pivot Chart

Power Query

Conditional Formatting

Data Validation

Education

Master's degree

Tools

Microsoft Excel

Job description

Job Description

Timesheet Specialist

Shift Timing: any time between (6 pm to 6 am) Time will be decided by Management. They have different time (Check with HR )

Extract data from the online portals.

Need enter these data into the Excel files.

Interact with US candidates regarding their hours they worked for the previous week.

Solve the queries of the candidates regarding entering of hours into the online portals via e mail and calls. Prepare various reports as required and guided by the management. Provide support and data to Invoice team, Payroll team and HR team.

Required to submit error free reports for payroll and other departments.

Professional Skills

• Pivot Tables & Pivot Chart
• Power Query
• Conditional Formatting
• Data Validation

Job Overview

Job TitleAdvanced Excel Specialist

Job TypeFULLTIME

CategoryData Science / Analytics

Experience0 - 2 Years

DegreeMaster

Offered Salary20000 - 30000

LocationNoida

HR Contact

7042502035 Call

Noida

Open Maps