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
Acknowledge(0)
Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
2From India, Delhi
Acknowledge(0)Amend(0)
[QUOTE=sanch;1257698]Hello everyone,
Please help me on how to use pivot tables, VLOOKUP, and HLOOKUP in MS Excel. Please provide examples in an Excel sheet.
Thank you.
I hope you have searched for similar postings on this 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.
Regards.
From India, Delhi
Acknowledge(0)Amend(0)
Please help me on how to use pivot tables, VLOOKUP, and HLOOKUP in MS Excel. Please provide examples in an Excel sheet.
Thank you.
I hope you have searched for similar postings on this 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.
Regards.
From India, Delhi
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Pivot table is an analysis tool used when a data table is too large. For example, if you have an HR data table containing employee data, you can use it to analyze the datewise joining of employees and their CTC. Using a pivot table, you can quickly arrange the data as needed in less than a minute.
VLOOKUP and HLOOKUP are functions defined in Excel that help find records from one table to another horizontally and vertically. However, certain conditions need to be met for these functions to work correctly. Refer to Excel's help section for understanding these conditions. The VLOOKUP function syntax is as follows: @VLOOKUP(reference of data to find, reference table where the data can be found, result column number, else zero).
From India, Mumbai
Acknowledge(0)Amend(0)
VLOOKUP and HLOOKUP are functions defined in Excel that help find records from one table to another horizontally and vertically. However, certain conditions need to be met for these functions to work correctly. Refer to Excel's help section for understanding these conditions. The VLOOKUP function syntax is as follows: @VLOOKUP(reference of data to find, reference table where the data can be found, result column number, else zero).
From India, Mumbai
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Thank you, Mohana. This is really useful.
mohannsl
Follow
Join Date: Jan 2010
Posts: 2
Re: What is Pivot Table, Vlookup, Hlookup in MS Excel?
Hi All,
I have enclosed a number of Excel commands with details of their usage. This will be very useful for everyone.
Thanks & Regards,
J. Mohana Reddy
Cell No. 09849315468
From Algeria, Algiers
Acknowledge(0)Amend(0)
mohannsl
Follow
Join Date: Jan 2010
Posts: 2
Re: What is Pivot Table, Vlookup, Hlookup in MS Excel?
Hi All,
I have enclosed a number of Excel commands with details of their usage. This will be very useful for everyone.
Thanks & Regards,
J. Mohana Reddy
Cell No. 09849315468
From Algeria, Algiers
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.