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 chromebook tab 10

Acer Chromebook Tab 10 Conquers the Classroom Tablet Competition

We are thrilled to have the first ever Chrome OS tablet—Acer’s Chromebook Tab 10—in our shop! With a 9.7-inch, 2048 x 1536 resolution screen and the ability to use Chrome or Android apps, we can’t wait for the Chromebook Tab 10 to be a classroom staple! Acer Chromebook Tab 10 Features Front 2-megapixel

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