Google Sheets Now Leverage ML for Effortless Data Visualization

Sheets now using same powerful machine learning technology in Explore to make visualizing data even more effortless.

Share online:

Explore in Google Sheets now use machone learning (ML)

Google making it even easier to visualize and share data, and find insights for teams to act on, is rolling out Thursday to Sheets.

Explore in Google Sheets now leveraging machine learning technology instantly analyzes data to help teams gain insights by simply asking questions "in words" — like for example, you can ask "what is the distribution of products sold?" or "what are average sales on Sundays?"

Additionally, instead of manually building charts, you can ask Explore to do it for you — just type like "histogram of 2017 customer ratings" or "bar chart for ice cream sales."

It's also now easier to update charts or tables in multiple sources programmatically sync your data from Sheets to Docs or Slides. keeping tables update too become easier now —just copy and paste data from Sheets to Docs or Slides and tap the "update" button to sync the data.

Docs or Slides" src="http://res.cloudinary.com/ditii/image/upload/w_auto,f_webp,fl_awebp,fl_lossy/v1496489033/Jun%203%2C%202017/Instantly%20sync%20your%20data%20from%20Sheets%20%E2%86%92%20Docs%20or%20Slides.png">
Instantly sync data from Google Sheets -> Docs or Slides

Other updates rolled out to Sheets today include:

  • 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 supports statistical functions like "GAMMADIST," "F.TEST" and "CHISQ.INV.RT."
  • Increased support for charts in the Sheets API: Use the API to programmatically generate most charts with support for dozens of new operations.

In addition, Google has deprecated one of the lesser-used chart types: the Motion chart. Beginning July 2017, user will not be able to insert or create Motion charts, and by Sep. editing of Motion charts will also no longer available.

Finally, by December, Motion charts in Sheets will become static images, says google.

These new features in Sheets are rolling out starting today.

Soon. Google Cloud will be switching to a different Certificate Authority (CA), which will roll out gradually across Google's cloud services over the coming months.

This change, however will not impact on the vast majority of G Suite customers, "as the CA is already trusted by systems and browsers for typical desktop and mobile platforms, including Android, Chrome OS, Windows, macOS and iOS," said the team.

But, it may affect customers who operate systems with custom certificate trust stores if they're not kept up to date, google said.