MIS Executive + Good Comm Skills(Eng) (Dwarka)

MIS Executive + Good Comm Skills(Eng) (Dwarka)

19 Nov
|
Omega Biznis Support (India) Private
|
Dwarka

19 Nov

Omega Biznis Support (India) Private

Dwarka

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.

- 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

Benefits

- 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.

Subscribe to this job alert:

Get the latest job offers by email for: mis executive + good comm skills(eng) (dwarka) / dwarka

Subscribe to this job alert:

Get the latest job offers by email for: mis executive + good comm skills(eng) (dwarka) / dwarka