Google Sheets update adds option to sync files with Docs or Slides, machine learning features
The new version of Sheets adds a handful of important new features and improvements, which are supposed to make it easier to create charts or sync files with other apps.
The same machine learning the powers Explore in Sheets now builds charts for users in an instant. It's enough to ask questions using words, not formulas, to analyze the data in the Sheets much quicker.
With machine learning Sheets users can now visualize data much easier. Whenever you don't see a chart that you need, you can simply ask. Also, you can now ask Explore to build charts by typing whatever it is that you want, like for example “bar chart of 2017 smartphone sales” or “bar chart of ice cream sales.”
Also, as the title says, the update brings a new option to sync data from Sheets with Docs or Slides. Simply copy and paste the data and tap the “update” button to sync all the data.
Other highlights of the update include keyboard shortcuts, improved printing experience, along with a powerful new chart editing experience (available for iPhone and iPads too). A couple of new spreadsheet functions have been added as well, such as “SORTN” (shots the top three orders or best-performing months in a sales record spreadsheet).
All the new Sheets features announced by Google will be rolling out to all compatible devices starting today, so make sure to search for the latest version of the app.