Which feature in Ms Excel allows you to extract the significance from a large, detailed data set?

number two ofcourse the pivot table

Pivot table allows us to design the significant data from a huge database and can be considered as the most simplest way to pull up the relevant data we need. However, the same is possible with vlookup and hlookup too till some extent with multiple conditions added. Pivot as few pre-defined formula and format whereas, with using vlookup or hlookup, we can modify the format as per our wish.

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.