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

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

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.

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

Article Contents Lifelike Video CallsCrystal Clear SpeakermicControl Your Meeting with Touch Screen Chromebox- Multitask in Your Meeting This blog was updated on February 7, 2018, to reflect the addition of the Logitech PTZ Pro 2 camera for larger rooms. Capitalizing on the success of Google Chromebox for Meetings, Google has

Article Contents Continual Google Sheets InnovationPivot to the CloudHow Will Pivot to the Cloud Change Business? 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

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.