Filter interviews by
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
lookup_value: The value to search for in the first column of the table.
table_array: The range of cells that contains the data.
col_index_num: The column number in the table from which to retrieve the value.
range_lookup: Optiona...
VBA is a programming language used to automate tasks in Excel and other Microsoft Office applications.
VBA stands for Visual Basic for Applications
It allows users to create macros to automate repetitive tasks
VBA code can be written within Excel by accessing the Developer tab
VBA can be used to manipulate data, create custom functions, and interact with other applications
Group Discussion......
Top trending discussions
I applied via AmbitionBox and was interviewed in Nov 2024. There were 4 interview rounds.
I utilize tools such as Excel, Python, SQL, and Tableau for data analysis.
Excel for basic data manipulation and visualization
Python for advanced data analysis and machine learning
SQL for querying databases
Tableau for creating interactive visualizations
Data analysis of code in the context of data analysis.
Coding logical question paper.
I applied via Campus Placement and was interviewed in Dec 2024. There were 4 interview rounds.
Two coding questions related to matrices and heaps.
posted on 21 Nov 2024
I applied via Approached by Company and was interviewed in Oct 2024. There were 2 interview rounds.
I applied via Recruitment Consulltant and was interviewed in Jul 2024. There was 1 interview round.
posted on 19 Nov 2024
I applied via campus placement at Indian Institute of Information Technology, Design and Manufacturing (IIITDM), Jabalpur and was interviewed in May 2024. There were 2 interview rounds.
DURATION 1.3 HRS WITH REASONING AND 2 CODING QUESTION
Use SQL query with ORDER BY and LIMIT to find the Nth highest salary.
Use ORDER BY clause to sort salaries in descending order
Use LIMIT to specify the Nth highest salary
Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT N,1
I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
SQL and python questions are very easy.
Quantitative aptitude test.
based on 1 interview
Interview experience
based on 12 reviews
Rating in categories
Associate Analyst
1k
salaries
| ₹3.5 L/yr - ₹10.5 L/yr |
Financial Analyst
597
salaries
| ₹2.4 L/yr - ₹11.4 L/yr |
Analyst
166
salaries
| ₹3.5 L/yr - ₹12.1 L/yr |
Senior Analyst
83
salaries
| ₹6.1 L/yr - ₹19.5 L/yr |
Junior Analyst
59
salaries
| ₹3 L/yr - ₹6.5 L/yr |
TCS
Infosys
Wipro
HCLTech