June 9, 2017
Explore in Sheets, powered by machine intelligence, helps gain insights from data, instantly. Ask questions—in words, not formulas—to quickly analyze your data. For example, you can ask “what is the distribution of products sold?” or “what are average grades for a class?” and Explore will help you find the answers.
Google is using the same powerful technology in Explore to make visualizing data even more effortless. If you don’t see the chart you need, just ask. Instead of manually building charts, ask Explore to do it by typing in “histogram of 2017 customer ratings” or “bar chart for student enrolled.” Less time spent building charts means more time acting on new insights.
Whether you’re preparing a class presentation or sharing enrollment trends, keeping data up-to-date can be time-consuming, especially if you need to update charts or tables in multiple sources. Google made it easier to programmatically update charts in Docs and Slides.
Now, they have made it simple to keep tables updated, too. Just copy and paste data from Sheets to Docs or Slides and tap the “update” button to sync your data.
Google is constantly looking for ways to improve our customers’ experience in Sheets. Based on customer feedback, Google added more updates to help teams get work done faster:
Keyboard shortcuts: Change default shortcuts in your browser to the same spreadsheet shortcuts you’re already used to. For example, delete a row quickly by using “Ctrl+-.”
Powerful new chart editing experience: Create and edit charts in a new, improved sidebar. Choose from custom colors in charts or add additional trendlines to model data. You can also create more chart types, like 3D charts. This is now also available for iPhones and iPads.
More spreadsheet functions: We added new functions to help you find insights, bringing the total function count in Sheets to more than 400. Try “SORTN,” a function unique to Sheets, which can show you the top three orders or best-performing months in a sales record spreadsheet. Sheets also supports statistical functions like “GAMMADIST,” “F.TEST” and “CHISQ.INV.RT.”