What is Pivot Table, Vlookup,Hlookup in MSExel?
CiteLegal
 
HOME RISE NEW ABOUT LOGIN
Home > Discussion Boards > General Discussion

What is Pivot Table, Vlookup,Hlookup in MSExel?

sanch Started The Discussion:

Hello everyone, please help me how to use pivot table, vlookup and hlookup in MSEXL. Please send with example in EXL sheet. Thank You.

NIKKI_ - Member Since: Sep 2009
go and google it buddy i think you will find many things there and dont forget to seek the same info on youtube

sourabh77 - Member Since: Feb 2006
Quote:
Originally Posted by sanch View Post
Hello everyone,
please help me how to use pivot table, vlookup and hlookup in MSEXL. Please send with example in EXL sheet.


Thank You.

I hope you have searched for simiular postings in thie site, \please follow this link, you'll find a useful presentation posted by AS Senthil Kumar

Vlookup n Pivot table(plz need help)

regrads

mohannsl - Member Since: Jan 2010
Hai All, I have enclosed No.of EXCEL commands with details of usage. This will be very useful for all. Thanks & Regards, J.Mohana Reddy Cell No.09849315468


Attached FilesProvided by community member mohannsl. Join us to learn and grow with your peers.
File Type: xls 51_excel tutor.xls (1.19 MB, 3583 views)
Sachin Kondhare - Member Since: Aug 2010
Pivot tabel is an analysis tool which will where data table is too large. for example you have a HR data table which contains employee data where in you have to find out or analyse datewise joining of employees & their CTC.
In this case if you will use pivot in less than minute you will get the data arranged as you require.

Vlookup & Hlookup are functions defined in excel which will help to find records from one table to another by horizontally & vertically. But it has some conditions which needs to satisfy. Go through the excel help for the conditions. function alias @vlookup(reference of data which need to find, reference table where reference data can be find,result column number, else zero).

ajay8587 - Member Since: Feb 2009
Great Sir, it is really a great work that you have posted. It is really very dedicated work of yours and I really appreciate the worth of it. thanks

sudharshanan.v - Member Since: Feb 2008
Mr. Sanch I hereby attach the attachment word document of how to use the pivot table. Find the attachment. Hope it will be usefull Regard Sudharshanan


Attached FilesProvided by community member sudharshanan.v. Join us to learn and grow with your peers.
File Type: doc Pivot table.doc (200.0 KB, 1372 views)
Koshish1971 - Member Since: Sep 2009
This is very good comand in excel it will help me in compare the data, copy the data in minutes time, please learn vlookup. Regards, Kosh ====

thyagu86 - Member Since: Sep 2010
Thnx Mohana really useful....

mohannsl Follow Join Date: Jan 2010
Posts: 2

Re: What is Pivot Table, Vlookup,Hlookup in MSExel?
Hai All,

I have enclosed No.of EXCEL commands with details of usage.

This will be very useful for all.

Thanks & Regards,

J.Mohana Reddy
Cell No.09849315468

nidheesh2@yahoo.co.in - Member Since: Nov 2010
What is Pivot Table, Vlookup,Hlookup in MSExel Hello everyone, please help me how to use pivot table, vlookup and hlookup in MSEXL. Please send with example in EXL shee



Found This Useful? +Vote Up This Page Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.






Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


7531
VIEWS

15
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network