Google Sheets Pivots to the Cloud

Google has just released a new update to Google Sheets which will revolutionize using spreadsheets. No longer is Sheets’s data analysis functions only for accountants, engineers, and STEM-enthusiasts. With new natural language recognition, Google Sheets will let even people without spreadsheet experience get meaningful insights from their data.

Continual Google Sheets Innovation

Google Sheets on multiple devices imageSince its development in 2006, Google has continually enhanced and improved the app. In 2016 Google released the Explore button, which uses machine learning to answer text-based equations for quick data filtering and analysis. However, user queries need to be formula base. In a spreadsheet of Promevo Best Sellers, we couldn’t ask “What were our average software sales?” We had to type “Average of QTY software”. Sheet’s latest release will refine this system, taking it from using text-based equations to everyday language.

Related>>Google’s Jamboard is HERE!

Pivot to the Cloud

Google referred to this release as “Pivot to the cloud” because of the update’s focus on pivot tables. The charts will have more capabilitiesand be easier to use. Natural language queries let you ask questions like you’re asking a coworker: “How much more did we sell in Q4 than Q2?”, “Which team member had the highest sales?”,”What was the best day for sales?”  Initially, Sheets will show you values as a percent of the whole (for example, the percent of sales per team member). Then, you’ll be able to take a deeper dive with the “View Details” option. If you aren’t sure where to start, Google’s AI will automatically suggest pivot charts based on key data points.

Additionally, Sheets is adding auto-formula suggestions, making it simpler and quicker for number-minded users to gather statistics.

How Will Pivot to the Cloud Change Business?

These changes will make Google Sheets and data analysis much more accessible to lay-people. By streamlining insights, anyone with access to a spreadsheet can use it to get a fast answer, even if they’re new to a project.

Google Sheets’s pivot to the cloud will help bring data analysis to the masses. By making it easier to get meaningful insights without using cell-based numerical formulas, Google is making information accessible to people who might not understand what an entire spreadsheet’s data means.

If you’re trying the pivot to the cloud update for the first time today, how are you liking it? What challenges have you had? Comment below, or sign up for our newsletter to stay up-to-date with all Promevo & Chrome news!

 

Share this post

About Promevo

Promevo is here to solve your toughest technology challenges by providing matchless services for all of your Google needs. We offer the very best Google solutions, focusing on productivity tools, like G Suite and gPanel, and hardware for Chromebooks, video conferencing, digital signage, and kiosks. We’re here to take you through your entire Google life-cycle, from basic needs with G Suite to advanced custom app creation.

You May Also Like...

acer chromebox CXI3

Introducing the Acer Chromebox CXI3: Easy to Use, Fast, and Secure

We’ve been getting a ton of interest about the new Acer Chromebox CXI3 line. It’s easy to use, faster than ever, keeps your data secure, and is simple to manage. We’re excited to offer four different models, so you’ll be able to find the right one for your storage and price requirements. Acer Chromebox

Read More »

8 Chrome Apps and Extensions You Never Knew You Needed!

Article Contents gPanelGrammarlyGoogle Hangouts FireShotMomentum Strict WorkflowThe Great SuspenderEye Care-Protect Your Vision You’ve got your Chromebooks, but how do you get the most out of it? Through applications and extensions! These apps and extensions will enhance your Chrome experience and help keep you and your colleagues working efficiently and productively.

Read More »

About Promevo

Promevo is here to solve your toughest technology challenges by providing matchless services for all of your Google needs. We offer the very best Google solutions, focusing on productivity tools, like G Suite and gPanel, and hardware for Chromebooks, video conferencing, digital signage, and kiosks. We’re here to take you through your entire Google life-cycle, from basic needs with G Suite to advanced custom app creation.

You may also like...