Urgently hiring
Skills Must required :
Expertise in Advance formulas :
- Macros
- Pivot Tables
- Cross Reference Table
- LOOKUP Functions
- Flat data tables
- Data filters
- Advanced Charts
- Data Interpretation
- Graphics Data
- Number Series
- Worksheet
- Operators
Have deep excel expertise. Must be very fluent in spoken and written English.
Experience Requirement
- Minimum 2 years of hands-on professional experience working with Advanced Excel (formulas, data cleaning, pivot tables, reconciliation, automation, etc.)
- Experience in MIS, Reporting, Data Analysis, Accounts, Finance, Operations, or similar roles will be preferred.
- Candidates with only basic Excel knowledge or less than 2 years of experience will not be considered.
Responsibilities
- Work on large datasets (50,000+ rows) in Excel and clean, transform & format data
- Create & maintain MIS reports, dashboards, and automated templates
- Perform payment reconciliation, vendor/customer settlement & mismatch reports
- Use advanced Excel functions: IF / SUMIF / COUNTIF / VLOOKUP / XLOOKUP / INDEX-MATCH / TEXT / DATE / FILTER etc.
- Build Pivot tables, charts, and dynamic summary reports
- Automate recurring tasks using Excel Macros / VBA
- Import, merge & consolidate multiple files (CSV, Excel etc.)
- Work closely with Accounts / Finance / Operations teams to deliver reports within deadlines
- Ensure data accuracy, zero-error output and fast turnaround time
Required Skills
✅ Advanced Excel (must)
✅ Power Query / Power Pivot
✅ Excel formulas (lookup, logical, text, date, array functions)
✅ Pivot Tables & Charts
✅ VBA / Macros (automation)
✅ Financial or payment reconciliation experience
✅ Data cleaning & transformation
✅ Strong analytical and problem-solving ability
✅ Fast working speed with keyboard shortcuts & productivity hacks
✅ Must be very fluent in spoken and written English.
Preferred / Good to Have
- Google Sheets + App Script
- Excel certification or VBA course completion
Work Environment:
- We provide holidays on national holidays and festivals as per company rules. This is not a BPO / KPO job, please apply only if you want to work in the publishing industry, education industry for very long term.
- This is a High Salary Job.
Job Timings: Mon-Sat, 10am-7pm. ( Working hours are normal Day Shift only).
High salary (Take home salary of 35000-45000 per month + yearly increments, Overtime payment and incentives)
Why Work With Us
Secure job : 35+ years in business
Chance to grow your career in a stable publishing company
Work in an international friendly office environment
Opportunity to Learn
Timely Salary, Overtime Payment, Yearly Increments, Yearly Bonus, Flexibility to work Overtime
Job Types: Full-time, Permanent
Pay: ₹35,000.00 - ₹45,000.00 per month
Experience:
- Microsoft Excel: 2 years (Required)
- total work: 4 years (Preferred)
Language:
Location:
- Gorwa, Vadodara, Gujarat (Required)
Work Location: In person
