Google Sheets Now Lets You 'Do More With Your Data'

Chris CrumBusiness, Featured

Share this Post

Google announced an update to Google Sheets, its spreadsheets application. Users can now add data labels to display exact values of bars or points. When the user uses line or scatter charts, they can change the shapes of data points, including stars, triangles, pentagons, etc.

When you’re working with spreadsheets, it’s important to turn your raw data into a story. With today’s updates to Google Sheets on the web, you’ll find even more ways to visualize and analyze your data," says product manager Dan Gundrum. "Charts can make even the largest data sets digestible, so we’ve made a few improvements to help you highlight what’s most important."

sheets-data

There are also new tools for analyzing spreadsheet data, including the ability to preview formula results as you type so you can more easily spot errors.

forumulas

You can filter rows and columns by conditions such as "greater than" or "text contains" so you'll only see the numbers, dates, and text you need. You can also add calculated fieldds to "pivot tables when you want to apply formulas to pivot table data."

Finally, you can use the GETPIVOTDATA function to more easily get data from your pivot table.

"The more the merrier when it comes to collaborating in Sheets, but sometimes you need to take extra steps to preserve your hard work from accidental edits. With Sheets, you’ve been able to restrict editing to a specific set of users and a specific range, but now you can also warn folks who try to edit certain cells. This way you can collaborate with others, and remind everyone (even yourself) to edit with care."

The new features are available for Sheets on the web.

Images via Google

Chris Crum
Chris Crum has been a part of the WebProNews team and the iEntry Network of B2B Publications since 2003. Follow Chris on Twitter, on StumbleUpon, on Pinterest and/or on Google: +Chris Crum.