What is vlookup pivotable you know about excel

Question

Accepted Answer

VLOOKUP and PivotTable are two powerful features of Excel used for data analysis and manipulation.

VLOOKUP is a function used to search for a specific value in a table and return a corresponding value from the same row.
PivotTable is a tool used to summarize and analyze large amounts of data in a table format.
VLOOKUP can be used in conjunction with PivotTable to extract specific data from a larger dataset.
For example, VLOOKUP can be used to extract customer information from a sales data table, which can then be analyzed using PivotTable to identify trends and patterns.

Accepted Answer

vlookup and pivot table are very useful in data anlysis , generating reports and also vlookup is used for one sheet to comparing to another sheet , find out put u want, pivot table is used for summarize data

What is vlookup pivotable you know about excel

Popular interview questions of MIS Executive

Top HR questions asked in Lodha Group MIS Executive