Friday, June 2, 2017

Google Sheets easily builds charts with a simple question thanks to machine learning.

Google Sheets on Android received some major improvements today. Thanks to machine learning, Sheets is now capable of manipulating data and displaying them in a meaningful way without much effort from the user. For example, creating tables in spreadsheets requires several steps, but thanks to machine learning and a simple question, and without the use of formulas, Google Sheets is capable building a chart for you. By a simple question, I mean something like "what are average sales on Sundays?". Just take a look above the Gif to get an idea of how it all works.

Google also improved the synchronization mechanism between Sheets, Docs and Slides. If you copied a table say between Sheets and Docs, a simple press of an update button will keep the two files or data source in sync.

This update also some more features to improve users' experience and efficiency:
  • 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+-.”  
  • 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.
  • 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
  • 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.”
Learn more over on Google Blog.

No comments:

Post a Comment