Google Sheets Gets Machine Learning for Instant Data Visualization

Google is today rolling out new features in Sheets, that make it even easier for you to visualize and share your data. Powered by machine learning, Google Sheets can now help teams gain insights from data, instantly. This means that you can now simply ask Sheets to give you a “bar chart for products sold this month” and it will automatically build one for you. 

Google sheets

Google is also making it easier to keep your tables updated. Just copy and paste data from Sheets to Docs or Slides and tap the “update” button to sync your data. Other improvements include improved printing options, new keyboard shortcuts and new spreadsheet functions

We’re constantly looking for ways to improve our customers’ experience in Sheets. Based on your feedback, we’re rolling out more updates today to help teams get work done faster:

  • 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.”

These new features in Sheets are rolling out starting today. To learn more, click here.

“Technology runs through my veins...” | Follow me: @DrUsmanQ usman@iPhoneinCanada.ca