May 17, 2011

Pivot Tables in Google Spreadsheets

Google Spreadsheets added an advanced feature that's really useful for summarizing data: pivot tables. "In essence, a pivot table does just that -- it allows you to 'pivot' or rotate data, thus looking at it from different angles and seeing a variety of patterns which may not be immediately obvious," explains Google Docs blog.

A pivot table is a powerful reporting tool that lets you group, filter, sort, count data. Google has an example of spreadsheet that includes information about some students, but it's not easy to summarize the data without using a pivot table. For example, you can group the students from each class level by gender. Just select "Pivot table report" from the "Data" menu, choose the categories of data to include (gender and class level) and the values to summarize ("class level" summarized by "COUNTA").


"A pivot table report is a dynamic table that lets you interpret data in different ways without ever having to enter a formula. Pivot table reports are particularly useful when you want to narrow down a large data set or analyze relationships between data points," suggests Google's help center, which also includes a guide for using this feature.

5 comments:

  1. This is excellent news. I've made use of pivot tables before, to help a tech support call center identify divisions that were doing well (or poorly).

    It also let us figure out which physical call center was dumping people back into the wait queue, and get that problem fixed. :D

    ReplyDelete
  2. This for me is the Microsoft Excel killing feature... even without it I was manually creating pivots with formulas. Simply awesome. When you couple this with the ability to reference worksheets across different docs you have a truly outstanding product.

    ReplyDelete
  3. Look who's growing up... Not bad Google.

    ReplyDelete
  4. Wow.. Someone is mature.

    I love the feature. Incredibly useful!

    ReplyDelete

Note: Only a member of this blog may post a comment.