Register now or log in to join your professional community.
1. V Look Up
2. Pivot Table
3. H Look Up
number two ofcourse the pivot table
2 . PIVOT TABLE in excel allows you to extract the significance from a large, detailed data set.
1. Pivot Table
2. Filter
3. V Lookup and H Lookup
Pivot Table allows you to extract the significance from a large, detailed data set. it is also one of Ms Excel most powerful tools.
Its second one, Pivot tables enables us to sort huge amount of data's as per our requirements.