Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by manseer muhammed ali , Accountant General , Royal Lighting L.L.C & Royal Furnishing LLC
Date Posted: 2015/02/10
Ahmed Maher allam
by Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions

number two ofcourse the pivot table

Sameer Medda
by Sameer Medda , Team Leader , sitel-india

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.

Shujayat Khan
by Shujayat Khan , Management Accountant , Confidential

2 . PIVOT TABLE in excel allows you to extract the significance from a large, detailed data set.

Mudassar Rafiq
by Mudassar Rafiq , Administator , Tornado Computer Trading L.L.C

1. Pivot Table

2. Filter

3. V Lookup and H Lookup

     

Mary Grace Falcis
by Mary Grace Falcis , Procurement Officer , AE Arma – Elektropanc Electromechanical LLC

Pivot Table allows you to extract the significance from a large, detailed data set. it is also one of Ms Excel most powerful tools.

Gladzon Jose
by Gladzon Jose , Accountant , Max Rock Spectrum LLC

Its second one, Pivot tables enables us to sort huge amount of data's as per our requirements.

More Questions Like This