1. Can you explain how you would use VLOOKUP and INDEX/MATCH functions in Excel to perform data lookup and retrieval tasks efficiently?
2. Describe a situation where you utilized Excel macros to automate a repetitive task, and how did it enhance your productivity or workflow?
3. How would you approach solving a complex data analysis problem in Excel, involving large datasets and multiple criteria?
4. Discuss a scenario where you had to use nested functions in Excel to manipulate data and derive meaningful insights. How did you structure your formulas?
5. In what ways have you leveraged PivotTables and PivotCharts in Excel for data summarization and visualization purposes? Can you provide an example of a challenging data analysis task you solved using these tools?
Candidatei-me por meio de uma faculdade ou universidade. Fui entrevistado pela Turing (Chennai) em dez. de 2024
Entrevista
had 2 rounds 1st aptitude and 2nd essay round took 2hrs to complete the whole process . well trained people and encouraging staff assistance interview went smoothly without any delay
It was good the process was smooth questions were also upto standard nice company... It was related to python stats and sql and some advance excel... Interview was also good
