Pin It

5 New Google Sheets Updates Teachers Should Know about

June 1, 2017
Google announced today the release of a number of interesting updates to Google Sheets. The most important of them all is the ability to visualize data using Explore. As you know, Explore is a relatively new feature in Google Drive that empowers users with a variety of helpful functionalities in Docs, Sheets, and Slides. Explore in Sheets allows you to access quick answers to questions about the data in your spreadsheets,  easily generate charts and analysis showing trends and patterns in your data and many more. Check out this page to learn more about Explore.


In today’s update to Explore in Sheets, users will be able to easily generate different visualizations of their data. For instance, ‘Instead of manually building charts, ask Explore to do it by typing in “histogram of 2017 customer ratings” or “bar chart for ice cream sales.” Less time spent building charts means more time acting on new insights.’ Other interesting updates include:

1- Instant syncing of data from Sheets to Docs or Slides
You can now instantly sync tables and charts from Sheets to Docs or Slides. You simply copy and paste data from Sheets to Docs or Slides and then tap ‘Update’ button to sync everything.

2-‘Keyboard shortcuts
 Change default shortcuts in your browser to the same spreadsheet shortcuts you’re already used to. For example, delete a row quickly by using “Ctrl+-.”

3- Upgraded printing experience
 Preview Sheet data in today’s new print interface. Adjust margins, select scale and alignment options or repeat frozen rows and columns before you print your work.

4- Powerful new chart editing experience
Create and edit charts in a new, improved sidebar. Choose from custom colors in charts or add additional trendlines to model data. You can also create more chart types, like 3D charts. This is now also available for iPhones and iPads.

5- More spreadsheet functions
 We added new functions to help you find insights, bringing the total function count in Sheets to more than 400. Try “SORTN,” a function unique to Sheets, which can show you the top three orders or best-performing months in a sales record spreadsheet. Sheets also support statistical functions like “GAMMADIST,” “F.TEST” and “CHISQ.INV.RT.”’

Source: Google Blog