Hi, My name is Madhu.. I need some information about Pivot tabel. What is the use of that..? & how to use that..? Please, cna anyone help me in this matter.. thanks in advance Madhu
Acknowledge(0)
Amend(0)
2Acknowledge(0)Amend(0)
Hi Madhu,
Kindly check the link below: http://www.microsoft.com/dynamics/us...s_collins.mspx.
My simple explanation is that it is used to convert row titles into column titles and vice versa.
From India, Madras
Acknowledge(0)Amend(0)
Kindly check the link below: http://www.microsoft.com/dynamics/us...s_collins.mspx.
My simple explanation is that it is used to convert row titles into column titles and vice versa.
From India, Madras
Acknowledge(0)Amend(0)
Hi Madhu,
When you have a large source of information in an Excel spreadsheet, a pivot table will help you arrange the data that needs to be retrieved based on headings and linked sources of information. The best option is to take the data source and work on the same.
Thank you.
From India
Acknowledge(0)Amend(0)
When you have a large source of information in an Excel spreadsheet, a pivot table will help you arrange the data that needs to be retrieved based on headings and linked sources of information. The best option is to take the data source and work on the same.
Thank you.
From India
Acknowledge(0)Amend(0)
hi madhu you may find this excel worksheet easy to understand and to apply in a jiffy -vellayan
Acknowledge(0)Amend(0)
Acknowledge(0)Amend(0)
Dear Madhu,
Good question! A pivot table is used to summarize data, such as count, sum, and average. For example, if you have data about B.Tech college students and you want to know how many students are in each department like CSC, Civil, EEE at a time, you can use a pivot table in Excel.
To create a pivot table, first, select the data and go to Data Menu > PivotTable & PivotChart Report > Pivot Table. Click next and choose suitable options.
Regards,
Bhuvana
From India, Visakhapatnam
Acknowledge(0)Amend(0)
Good question! A pivot table is used to summarize data, such as count, sum, and average. For example, if you have data about B.Tech college students and you want to know how many students are in each department like CSC, Civil, EEE at a time, you can use a pivot table in Excel.
To create a pivot table, first, select the data and go to Data Menu > PivotTable & PivotChart Report > Pivot Table. Click next and choose suitable options.
Regards,
Bhuvana
From India, Visakhapatnam
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Pivot Table Secrets.pdf
PIVOT TABLE SAMPLE.zip