Google Sheets adds machine learning for natural language charts

New tools should make Google Sheets easier to use and more powerful

Pulling data out of complicated spreadsheets isn't easy for amateur data scientists, but such analysis is a requirement for many modern roles. 

Google has stepped in to help by adding machine learning tools to Sheets to let you ask questions about your spreadsheet in natural language, rather than using complicated calculations or understanding jargon. 

"Explore in Sheets, powered by machine learning, helps teams gain insights from data, instantly. Simply ask questions in words, not formulas to quickly analyse your data," said Daniel Gundrum, Sheets product manager, in a post in the Google blog. "For example, you can ask 'what is the distribution of products sold?' or 'what are average sales on Sundays?' and Explore will help you find the answers." 

Now, we're using the same powerful technology in Explore to make visualising data even more effortless. If you don't see the chart you need, just ask," Gundrum said. "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."

Advertisement
Advertisement - Article continues below
Advertisement - Article continues below

There are more updates to make life in Sheets easier. Charts made in Sheets will automatically sync in Docs and Slides, saving you that extra step when you have fresh figures. Just click the "update" button to sync data. 

Other changes include new keyboard shortcuts - you can now delete a row with "Ctrl+-" - as well as a revamped printing interface for easier settings management, new chart editing tools, and more spreadsheet functions. 

Featured Resources

Digitally perfecting the supply chain

How new technologies are being leveraged to transform the manufacturing supply chain

Download now

Three keys to maximise application migration and modernisation success

Harness the benefits that modernised applications can offer

Download now

Your enterprise cloud solutions guide

Infrastructure designed to meet your company's IT needs for next-generation cloud applications

Download now

The 3 approaches of Breach and Attack Simulation technologies

A guide to the nuances of BAS, helping you stay one step ahead of cyber criminals

Download now
Advertisement

Recommended

Visit/agile-working/33528/it-pro-panel-why-collaboration-platforms-are-so-hard-to-deploy
agile working

Why collaboration platforms are so hard to deploy

29 Apr 2019

Most Popular

Visit/operating-systems/25802/17-windows-10-problems-and-how-to-fix-them
operating systems

17 Windows 10 problems - and how to fix them

13 Jan 2020
Visit/hardware/354584/windows-10-and-the-tools-for-agile-working
Sponsored

Windows 10 and the tools for agile working

20 Jan 2020
Visit/microsoft-windows/32066/what-to-do-if-youre-still-running-windows-7
Microsoft Windows

What to do if you're still running Windows 7

14 Jan 2020
Visit/web-browser/30394/what-is-http-error-503-and-how-do-you-fix-it
web browser

What is HTTP error 503 and how do you fix it?

7 Jan 2020