Tuesday, May 17, 2011
Over the past few months, we’ve released a string of new features in Google Docs to give your business more tools for collaborative document editing and data analysis. From simpler file uploads to discussions and mobile editing in documents, we’re making it easier for you and your colleagues to work together on the web. Continuing with this effort, we’re launching pivot tables in Google spreadsheets, which will be rolled out to all Rapid Release users over the next 24 hours.
With pivot tables, you can quickly narrow down large data sets to get high level insights. Say you run a retail chain and you have thousands of rows of sales data broken down by purchase. It could be helpful for you and your sales manager to view the total annual revenue for each region without having to enter multiple formulas. In a matter of seconds, you can create a pivot table and summarize all of your data according to the factors you specify, all while collaborating with your sales manager on the spreadsheet.
To see how pivot tables work in Google spreadsheets, check out this video:
We hope pivot tables in Google spreadsheets will help you save time analyzing your data. For more details on using pivot tables, take a look at our post on the Google Docs Blog.