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 capabilities and 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!
Promevo can help your school, business, or organization achieve all of your technology goals. As a Google Premier Partner, we can outfit you with the best Chromebooks for your needs, supply you with G Suite licenses, and provide extended support, so you’ll get the most out of your Chrome devices!
Latest posts by Steph Fiorelli (see all)
- The 7 Best Cases, Sleeves, and Shells for Protecting Your Chromebooks - February 6, 2018
- Google Sheets Pivots to the Cloud - January 25, 2018
- 5 littleBits Kits to Maximize STEM Innovation - January 15, 2018