Even been stuck with a spreadsheet with a lot of entries and having the need for a tool which could pull summaries according to year, region or many other factors?
Need some help?
To help you out in this regard, Google has announced the ability to create pivot tables in Google Docs. The pivot table makes it easier for the user to edit documents as well as analyze data. In a post on the official blog, Josh Danziger – Software Engineer says, “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”.
Those who want a look as to how the new pivot tables work can check out the video below:
Google has stated that the pivot tables in Google Spreadsheets will be released to all users in the next 24 hours.