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

hangouts meet kit

Hangouts Meet Kit Takes Tech Troubles Out of Video Calls

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 just

Read More »

What’s New in Chrome OS 66?

Article Contents Display FeaturesGoogle Play FeaturesAdditional Features At the end of April, Google pushed the new Chrome OS 66 update. The most important bit? Adding security measures so that all Chrome OS devices are protected against Meltdown attacks. Along with the beefed-up safeguarding, OS 66 has added quite a few

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