Filter interviews by
I was interviewed before Jan 2024.
I am a dedicated MIS executive with 5 years of experience in data analysis, reporting, and system management.
5 years of experience in MIS role
Proficient in data analysis and reporting
Skilled in system management and troubleshooting
Strong attention to detail and problem-solving abilities
Pivot table
Chart
Sum
Sumit
If
If else
Vlookup
Hookup
Max min
Top trending discussions
I applied via Indeed and was interviewed in Apr 2024. There were 2 interview rounds.
An excel workbook was given which had raw data in 2 different sheets and one reference workbook was given which had all the summary of the data in sheet1. Based on reference sheet, try to duplicate and summarize the raw data. Also raw data workbook will be in 2 separate sheets so you will have to prepare the data in a single sheet by merging those 2 raw sheets. Merging can be done manually or by power query. Things to be prepared - Pivot Table, YOY Growth in percentage, Power Query to merge sheets
posted on 20 Feb 2024
I applied via Naukri.com and was interviewed in Aug 2023. There was 1 interview round.
I applied via Company Website and was interviewed in Jan 2022. There were 2 interview rounds.
18/2/2022
I applied via Recruitment Consultant and was interviewed in May 2020. There were 3 interview rounds.
Pivot tables are used to create reports by summarizing and analyzing data.
Select the data range that you want to analyze
Go to the 'Insert' tab and click on 'PivotTable'
Choose the location where you want to place the pivot table
Drag and drop the fields you want to analyze into the 'Rows' and 'Columns' areas
Add any additional fields to the 'Values' area to calculate summaries
Customize the pivot table by applying filters,...
Data validation ensures accuracy and completeness of data. It helps in preventing errors and improving data quality.
Data validation ensures that the data entered is accurate and complete.
It helps in preventing errors and improving data quality.
It ensures that the data is consistent and conforms to predefined standards.
It helps in identifying and correcting errors before they cause problems.
Examples of data validation i...
Advance filter is a feature that allows users to apply complex criteria to filter data in a more precise way.
Advance filter allows users to filter data based on multiple criteria.
It provides options to filter data using logical operators such as AND, OR, and NOT.
Users can filter data based on specific values, text, dates, or even formulas.
Advance filter can be used in various applications like spreadsheets, databases, ...
I have 3 years of experience as a MIS Executive in a multinational company.
Managed databases to ensure accurate and timely reporting
Developed automated reports using Excel and SQL
Collaborated with cross-functional teams to analyze data and improve processes
I applied via Recruitment Consultant and was interviewed in Nov 2020. There were 3 interview rounds.
based on 2 interviews
Interview experience
based on 12 reviews
Rating in categories
Research Analyst
424
salaries
| ₹0 L/yr - ₹0 L/yr |
Sr. Demand Generation Executive
190
salaries
| ₹0 L/yr - ₹0 L/yr |
Quality Analyst
95
salaries
| ₹0 L/yr - ₹0 L/yr |
Demand Generation Executive
86
salaries
| ₹0 L/yr - ₹0 L/yr |
MIS Executive
58
salaries
| ₹0 L/yr - ₹0 L/yr |
Info Edge
JustDial
Indiamart Intermesh
Matrimony.com