Koshish1971
Administration
Sudharshanan.v
Hr & Legal
Sourabh77
Sr Hr Professional
Sanch
Hr,training
[email protected]
Performance Management& Payroll
+4 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Hello everyone, please help me how to use pivot table, vlookup and hlookup in MSEXL. Please send with example in EXL sheet. Thank You.
From India, Delhi
go and google it buddy i think you will find many things there and dont forget to seek the same info on youtube
From India, Delhi
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
https://www.citehr.com/231346-vlooku...need-help.html
regrads

From India, Delhi
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
From India, Hyderabad

Attached Files
File Type: xls 51_excel tutor.xls (1.19 MB, 7192 views)

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).

From India, Mumbai
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
From India, Madras

Attached Files
File Type: doc Pivot table.doc (200.0 KB, 3574 views)

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 ====
From India, Delhi
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

From Algeria, Algiers
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
From India, Lucknow
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™