Pivot to the cloud: intelligent features in Google Sheets help businesses uncover insights
Wednesday, December 6, 2017
In addition, if you want to create a pivot table from scratch, Sheets can suggest a number of relevant tables in the pivot table editor to help you summarize your data faster.
*You can view pivot tables on all platforms, but you can only create and edit them on the web.
**The “Answers” feature in Sheets is only available in English at this time.
Suggested formulas, quicker answers
We often use basic spreadsheet formulas like =SUM or =AVERAGE for data analysis, but it takes time to make sure all inputs are written correctly. Soon, you may notice suggestions pop up when you type “=” in a cell. Using machine intelligence, Sheets provides full formula suggestions to you based on contextual clues from your spreadsheet data. We designed this to help teams save time and get answers more intuitively.
Even more Sheets features
We’re also adding more features to make Sheets even better for data analysis:
- Check out a refreshed UI for pivot tables in Sheets, and new, customizable headings for rows and columns.
- View your data differently with new pivot table features. When you create a pivot table, you can “show values as a % of totals” to see summarized values as a fraction of grand totals. Once you have a table, you can right-click on a cell to “view details” or even combine pivot table groups to aggregate data the way you need it. We’re also adding new format options, like repeated row labels, to give you more fine-tuned control of how to present your summarized data.
- Create and edit waterfall charts. Waterfall charts are good for visualizing sequential changes in data, like if you want to see the incremental breakdown of last year’s revenue month-by-month. Select Insert > Chart > Chart type picker and then choose “waterfall.”
- Quickly import or paste fixed-width formatted data files. Sheets will automatically split up the data into columns for you without needing a delimiter such as commas between data.
Launch Details
Release track:
Launching to Rapid Release, with Scheduled Release coming on January 24th, 2018*
*Due to the holidays, the launch to Scheduled Release will occur more than the standard two weeks after the launch to Rapid Release. The rollout to Scheduled Release domains will begin on January 24th, 2018.
Editions:
Available to all G Suite editions
Rollout pace:
Extended rollout (potentially longer than 15 days for feature visibility)
Impact:
All end users
Action:
Change management suggested/FYI
More Information
Help Center: See and use suggested charts and analysis in a spreadsheet
Help Center: Create and use pivot tables
Help Center: Customize a pivot table
Help Center: GETPIVOTDATA
Help Center: Chart and graph types
Help Center: Import data sets and spreadsheets
Help Center Separate cell text into columns
Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates