New Google Sheets Features

May 5, 2014 | By | Reply More

Google Sheets IconI always cringe when I say “new” because one of the benefits of being part of Apps for Education is that on most Google upgrades we have a 30 day window from general release to educational release. This is great because it give us time to make announcements about upcoming changes, and let Google work the bugs out of features before we go live.  The tough part is, yes, we have to 30 days longer than the general public for some of our upgrades.

With that all out-of-the-way…

Google sheets, Google’s proprietary spreadsheet application, has stepped up existing features as well as added some new. One of the biggest is that you will have be able to edit spreadsheets offline. That means without an internet connection, you can still use and edit spreadsheets if you have set up offline access in Chrome. You can also do this, by the way, with Google documents, presentations, and drawings.

Instructions to set up offline access are found in this link.

Other new features for sheets: (From Google Support: full article to read more)

  • Speed: New spreadsheets load and scroll much faster, removing many of the limits for formula complexity and spreadsheet size.

  • Improved formula editing: Check out our new function editing tools to help you build complex formulas.

  • New spreadsheet functions: Now you can use highly requested new functions such as SUMIFS, COUNTIFS, and AVERAGEIF.

  • Filter views: Create, save, and apply multiple filter views without changing what your collaborators see.

  • Advanced conditional formatting improvements: Apply formatting to your spreadsheet based on cell contents or formulas.

  • And many more, including colored sheet tabspaste transpose, improved find and replaceadd-ons,easier linking, and lots of new number formatting options.

Tags: , , , , , ,

Category: GOOGLE SERVICES

Leave a Reply