Hi All, Request you all to kindly fill in the attached Questionnaire and give your valuable feedback and also Suggestions with specific reference to the IT Sector. Thanks in advance. Regards, Preeta
From United States, Troy
From United States, Troy
Hi Amith, Can you explain the function of pivotal table and Vlookup with some examples. Regards Latha.
From India, Bangalore
From India, Bangalore
Hi Latha,
Don't have much information over Pivot Table..
But VLOOKUP is really a great tool.. which is been used to get the accurate data from a large storage of data having atleast a single similar field.. like employee code...
It is been used extensively when data is of large number of people..
Like when the data is of more than 100 employees and some left the organisation in a particular month and some join even.. then if we have to get the data for new manpower from the old one.. then it is very difficult to get it through copy n paste, as it will require a cross check and will consume time..
Whereas with VLOOKUP we may get all the data with a single formula only...
Regards,
Amit Seth.
From India, Ahmadabad
Don't have much information over Pivot Table..
But VLOOKUP is really a great tool.. which is been used to get the accurate data from a large storage of data having atleast a single similar field.. like employee code...
It is been used extensively when data is of large number of people..
Like when the data is of more than 100 employees and some left the organisation in a particular month and some join even.. then if we have to get the data for new manpower from the old one.. then it is very difficult to get it through copy n paste, as it will require a cross check and will consume time..
Whereas with VLOOKUP we may get all the data with a single formula only...
Regards,
Amit Seth.
From India, Ahmadabad
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.