Artificial Intelligence helps Google Sheets add plain-English commands – Number-crunching is getting easier as machine-learning technology spreads to a new corner of computing

If you’re a spreadsheet guru, you probably are perfectly happy writing a command like =AVERAGE(Sheet1!C2:C933). For the rest of us, an infusion of artificial intelligence in Google Sheets means you’ll just be able to ask “What are the average sales for Sunday?”

An AI update Google announced Thursday means the spreadsheet app takes its best shot at understanding commands in plain language. Other examples: “What is the distribution of products sold?”, “Histogram of 2017 customer ratings,” and “bar chart for ice cream sales.”

Accountants, scientists, financial analysts and other professionals use spreadsheets to process numeric data, but they can be a daunting tool for others who don’t spend a lot of time in calculations. But the history of computing over and over shows how making technology more accessible to ordinary folks has transformed industries and our lives. AI is a top tool today in making computers act like humans so humans don’t have to act like computers.

Google has aggressively adopted machine learning technology, which trains a brain-like “neural network” of computers to recognize patterns. The technology is as widely adaptable as human intelligence: Google uses it for everything from translating languages and taking good photos to catching dangerous phishing attacks in your email and vanquishing the top players of the ancient game of Go.

Other new improvements also are coming to Google Sheets, a cornerstone tool in the G Suite of productivity apps along with Google Docs for word processing and Google Slides for presentations. Among the changes:

  • A new interface for creating charts out of spreadsheet data. There are new chart types, too, including 3D options.
  • The ability to easily synchronize data from Google Sheets that’s copied and pasted into Google Docs or Google Slides documents.
  • Customizable keyboard shortcuts, handy if you want to get Google Sheets to behave more like Microsoft Excel.
  • More control over printing options like margins and zoom scale.


Full Article:

Contact Information:

Artificial Intelligence News

  • Home Mini bundle for $129 comes with a $50 Hulu gift card

    This discounted Google Home Hub + Google Home Mini bundle for $129 comes with a $50 Hulu gift card Control smart home devices, rock out to your favorite tunes, and more. Every so often, we'll see a stellar deal on the Google Home Hub that makes picking one up super…(read more...)

  • How did Google convince phone makers to add a Google Assistant button?

    Voice assistants like Siri, Bixby and Google Assistant have been steadily integrated into our tech, eager to help us with our everyday tasks and answering our trivial questions. They can now be found on watches, TVs, speakers and, of course, their birthplace: smartphones. It’s always been relatively easy to activate…(read more...)

  • Apple Acquires Startup Laserlike To Boost Siri: Report

    Apple has acquired a startup specializing in machine-learning technologies as part of the ramp up of its artificial intelligence group led by a former Google executive, according to a report. The startup, Laserlike, was founded by three ex-Google engineers and will join the AI group headed by Google’s former AI…(read more...)