i
HCLTech
Filter interviews by
Clear (1)
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 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, ...
What people are saying about HCLTech
I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.
I applied via Company Website and was interviewed before Apr 2021. There were 3 interview rounds.
I applied via Walk-in and was interviewed before May 2021. There were 3 interview rounds.
I was interviewed in May 2017.
based on 1 interview
Interview experience
based on 24 reviews
Rating in categories
Software Engineer
23.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Lead
21.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
15.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Lead Engineer
15k
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
14.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Wipro
Accenture
Cognizant