MIS Executive

Job Description – MIS Executive

Gender: Female

Time: 9:00 AM to 7:00 PM

Role: MIS Executive

Key Responsibilities

• Preparing MIS reports using Microsoft Excel
• Performing data analysis using Pivot Tables and Excel formulas
• Using VLOOKUP / XLOOKUP / INDEX-MATCH for data comparison
• Creating Excel dashboards and summary reports
• Applying Conditional Formatting and Data Validation
• Using SUMIFS, COUNTIFS, IF formulas for calculations
• Managing and analyzing large datasets in Excel
• Creating charts and graphs for data visualization
• Using Power Query / Power Pivot for data processing
• Automating reports using Excel Macros (basic)

Required Excel Skills Advanced Microsoft Excel

• Pivot Tables & Pivot Charts
• VLOOKUP / XLOOKUP
• INDEX MATCH
• Logical Functions (IF)
• SUMIFS / COUNTIFS
• Conditional Formatting
• Excel Dashboards
• Data Analysis
• Excel Charts