MIS Executive - Advanced Excel Operator Jobs Opening in Puri Bakers Pvt Ltd at Delhi-Others, Delhi
Job Description
Job Summary:
We are seeking a skilled and detail-oriented MIS Executive with strong expertise in Advanced Excel to manage, analyze, and report business data. The MIS Executive will be responsible for preparing regular reports, dashboards, and data analysis to support management in decision-making. The ideal candidate should be proficient in Excel tools such as VLOOKUP, HLOOKUP, Pivot Tables, Macros, Charts, and more.
This role is crucial in driving data accuracy, improving reporting systems, and ensuring timely delivery of performance and operational metrics.
Key Responsibilities:
1. Data Management & Reporting:
-
Collect, compile, and analyze large volumes of operational and business data.
-
Create and maintain daily, weekly, and monthly reports for management and various departments.
-
Ensure accuracy and consistency of data across all reports and systems.
2. Excel Reporting & Automation:
-
Develop and automate Excel reports using advanced functions like:
-
VLOOKUP, HLOOKUP, INDEX, MATCH, IF, SUMIFS, COUNTIFS
-
Pivot Tables and Pivot Charts
-
Conditional Formatting
-
Data Validation
-
Formulas for dashboards and summary sheets
-
-
Write and manage basic VBA Macros for automating repetitive tasks (preferred).
3. Dashboard Creation:
-
Design and maintain dynamic dashboards to present performance metrics.
-
Visualize data using graphs, charts, and conditional formats for management review.
-
Continuously improve and optimize dashboard performance.
4. Coordination & Communication:
-
Work closely with internal departments (sales, operations, HR, finance) to gather data and deliver reports.
-
Respond to ad-hoc report requests and ensure timely delivery.
-
Support senior management with analysis and insights for business decisions.
5. Database & File Management:
-
Maintain proper documentation and file management of all MIS-related reports and trackers.
-
Ensure data security, backup, and version control.
-
Work with ERP/CRM tools or other database systems if required.
More information about this MIS Executive - Advanced Excel Operator Job
Please go through the below FAQs to get all answers related to the given MIS Executive - Advanced Excel Operator job
- What are the job requirements to apply for this MIS Executive - Advanced Excel Operator job position?
- Ans: A candidate must have a minimum of fresher as an MIS Executive - Advanced Excel Operator
- What is the qualification for this job?
- Ans: The candidate can be a Graduate from any of the following: B.Com, BA, BBA/BBM, BCA, BSc, CS
- What are the salary requirements for this job?
- Ans: The salary range is between 18000 and 25000 Monthly. The Salary will depend on the interview. This MIS Executive - Advanced Excel Operator is a Full Time in Delhi.
- What is the hiring Process of this job?
- Ans: The hiring process all depends on the company. Normally for an entry level, hiring the candidate has to go for Aptitude, GD (If they look for communication),Technical test and face to face interviews.
- This MIS Executive - Advanced Excel Operator is a work from home job?
- Ans: No ,its not a Work from Home Job.
- How many job vacancies are opening for the MIS Executive - Advanced Excel Operator position?
- Ans: There are immediate 1 job openings for MIS Executive - Advanced Excel Operator in our Organisation.