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
Solid working knowledge of Microsoft Excel.
Valuable 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.
Pay: ₹18,000.00 - ₹26,000.00 per month
Perks
Provident Fund
Application Question(s)
Immediate Joiner
Pls read JD carefully before applying for the job
Education
Bachelor's (Required)
Experience
MIS Executive: 1 year (Required)
Language
ENGLISH FLUENT ONLY PLS (Required)
Location
Dwarka, Delhi, Delhi (Required)
Work Location: In person
📌 Mis Executive + Good Comm Skills Eng Dwarka
🏢 Omega Biznis Support (India) Private
📍 Dwarka
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.