Connect with us

Hi, what are you looking for?

The American GeniusThe American Genius

Business Marketing

Google Sheets robots are helping your data be more visual

(MARKETING) Google Sheets is expanding its reach and giving users more flexibility when using their spreadsheet program.

woman working laptop sheets

Google numbers

Google Sheets, the company’s spreadsheet program akin to Microsoft Excel, has received some substantial new updates. Last year, it added the machine learning-powered “Explore” which made it easier to gain insight regarding your data.

bar
Well, it looks like Explore has done some serious studying as the feature is now even smarter, being able to build charts simply by asking it natural language questions.

Not new, but improved

Though the function was already able to build graphs, it can now also build charts and tables, as well as build visualizations that answer specific questions about your data.

Previously, the “Explore” function could only build graphs focused on the complete set of data.

In action, this would equate to typing in a query to Explore asking for a “bar chart for 2017 coffee sales,” or a “histogram of May 2017 new subscribers.”

exploring and more

Adding to the Explore function’s effectiveness is its ability to update data sets in Google’s other office programs. Instead of having to go in and manually change the data line-by-line, you can now simply copy and paste the table into Google Docs or Slides, and click “update” to sync the data.

Advertisement. Scroll to continue reading.

This will undoubtedly be useful for those times when one needs to quickly update their data tables before a big presentation, or sending in an important report.

Other new features include new keyboard shortcuts, a more customizable printing experience (adjust margins, and/or select scale and alignment options before printing), a more powerful sidebar for chart editing, and even more statistical functions (with Sheets now sitting at over 400 functions).

Check it out

The new and updated Google Sheets rolled out on June 1, so if you are already using the program, you may have noticed all its fancy new bells and whistles. Being completely honest, I do not know much in the way of spreadsheets. But, spreadsheet fans and data nerds galore, it sounds to me that at least some of your prayers have been heard and answered by the almighty Google.

And, if you have yet to try out Google’s Sheets program, it seems that now would be a great time to check it out.

#GoogleSheets

Advertisement. Scroll to continue reading.
Written By

Andrew Clausen is a Staff Writer at The American Genius and when he's not deep diving into technology and business news for you, he is a poet, enjoys rock climbing, monster movies, and spending time with his notoriously naughty cat.

3 Comments

3 Comments

  1. Pingback: Google is spicing up presentations with GIF data - The American Genius

  2. Pingback: Good guy Google will rescind email scanning - The American Genius

  3. Pingback: Google Sheets ups their game with predictive data entry

Leave a Reply

Your email address will not be published.

The
American Genius
news neatly in your inbox

Subscribe to our mailing list for news sent straight to your email inbox.

Advertisement

KEEP READING!

Business News

With strict competition and anti-trust allegations, Google is slipping down the path of layoffs and company cuts.

Tech News

The Made By Google event comes to New York in October 2022, where the tech giant will debut new tech like a smartwatch, phone,...

Business News

Expressing emotions over text has never been easier with emojis. Now, Google Docs is following suit, allowing emojis and interactive features.

Tech News

Get a first look at upcoming tools and tech with Google's new AI Test Kitchen, a curated space where users can try out beta...

The American Genius is a strong news voice in the entrepreneur and tech world, offering meaningful, concise insight into emerging technologies, the digital economy, best practices, and a shifting business culture. We refuse to publish fluff, and our readers rely on us for inspiring action. Copyright © 2005-2022, The American Genius, LLC.