CoreHRx Jobs

Apply in one click, save jobs and take free mock tests.

Register free Log in
Hiring? Post jobs with CoreHRx
My account
user

View & update profile

MIS Specialist

Happiest Resume

Full time
Location
New Delhi
Work mode
Not stated
Salary
₹1–5 LPA
Posted 1 day ago

Free · takes a minute · your resume fills your profile

CoreHRx never asks candidates for money. If anyone does, .

How well do your skills match this job?

Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.

Job description

Advanced proficiency in MS Excel (Pivot Tables, VLOOKUP/XLOOKUP, Power Query, Macros preferred and basic knowledge of AI as well).  Good knowledge of Power BI or other BI tools.  Strong analytical and data interpretation skills.  Experience in MIS reporting and dashboard creation.  Excellent attention to detail and accuracy.  Good communication and stakeholder management skills. Essential Job Functions 1.  Prepare and publish daily, weekly, monthly, MIS reports.  Analyze sales, policy issuance, claims, and operational data.  Develop and maintain dashboards using Excel, Power BI, or similar reporting tools.  Ensure data accuracy, integrity, and timely reporting.  Automate routine reports and improve reporting efficiency

Key skills

Preferred

MIS ReportingMS ExcelPivot TablesPower BIPower QueryStakeholder ManagementVLOOKUP/XLOOKUP

Job market insights

77 more open jobs at Happiest Resume

Most IT Jobs posts in New Delhi ask for 3–6 years of experience (46% of 156 that say).

Hiring most for IT Jobs in New Delhi

  • Konrad22 open jobs
  • Bitwarden16 open jobs
  • Weekday AI9 open jobs

From live job posts on CoreHRx, updated 19 Nov 2026. Skill figures count posts that list their skills; salary figures only posts that show a salary.

Questions about this job

What is the salary for this MIS Specialist job?

The post states ₹1–5 LPA.

Where is this job based?

In New Delhi.

What kind of job is this?

It is a full time job.

This guide is for freshers and experienced professionals in India preparing for the Excel round of MIS executive, accounts, operations, back-office and data analyst interviews, where a practical Excel test is common. It has 60 questions with answers in three levels: the basics every fresher must know (references, VLOOKUP, IF, SUMIFS, text and date functions, pivot tables), real work problems for 1-4 years of experience (lookup errors, dynamic arrays, slicers, Goal Seek), and senior topics such as Power Query, the Data Model, large-file performance and building a monthly MIS report. Sample data and formulas are shown as small tables with their results. Rebuild each example in Excel (Microsoft 365) as you read, then take the mock test.

Questions you may be asked

  1. What is the difference between relative, absolute and mixed cell references?
  2. How does VLOOKUP work, and why do you usually set its last argument to FALSE?
  3. How do you combine IF with AND and OR?
  4. What is the difference between SUMIF and SUMIFS?

Get IT jobs in New Delhi by email

Create a free profile and we email you new IT jobs in New Delhi, at most once a week.

Similar jobs

Free · takes a minute · your resume fills your profile