Google’s Sheets spreadsheet application gained a number of new features aimed at making pivot tables, a powerful data analysis tool, more accessible.

Users will be able to get recommendations from Sheets’ Explore tab that aim to answer questions about the data fed into the program by spitting out a pivot table, which absorbs multiple pieces of data and outputs relevant answers. In addition, the app will automatically suggest different pivot table setups when users go to create one inside a spreadsheet.

Pivot tables are one of the key tools in spreadsheet users’ arsenals. They make it possible to quickly slice and dice data to garner important insights. For example, someone could create a pivot table that takes a spreadsheet full of sales transactions and outputs how much revenue is attributable to each salesperson. Actually setting that up, however, can be difficult, especially for people who aren’t experienced in the ways of manipulating spreadsheets.

Google hopes that these features will help make it more accessible for people who don’t have PhDs in spreadsheet manipulation to use the same features that their power user friends are already familiar with. What’s more, these new capabilities also provide novice users with a pivot table foundation they can build on going forward to meet particular use cases.

In addition, these updates show Google’s commitment to upgrading its productivity suite to serve enterprise users who are committed to Microsoft Excel. Beri Lee, a product manager for Google Sheets, said that the company is committed to adding features to sheets so that all of its…

Continue ….

[SOURCE]