Curious About Pivot Tables in Excel? Discover Their Uses and How to Get Started

Hi,

My name is Madhu. I need some information about Pivot table. What is the use of that and how to use it? Can anyone help me with this matter?

Thanks in advance,
Madhu

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.

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.

Hi Madhu,

You may find this Excel worksheet easy to understand and apply in a jiffy.

-Vellayan

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