I’ve recently returned from a fantastic week in San Francisco at Google’s Cloud Next ’19 conference, which is their annual Cloud conference for developers and vendors. It’s a huge event, with some 30,000+ attendees and 500 sessions.
Google made a 122 announcements, including some exciting developments relating to Google Sheets.
Here are the talks from the Google Cloud Next 19 conference that related to Google Sheets:
1. 30 Ways Google Sheets Can Help Your Company Uncover and Share Data Insights
If you only watch one session from next and you’re a Google Sheets user, then I’d recommend this one. It’s really well presented look at the capabilities of Google Sheets in the context of working with data and the Sheets team give plenty of sneak peeks into where the tool is going.
Here are the new features we can expect to see in the future:
Images in cells: allows you to add images anchored inside a cell, not just free-floating, and without needing to use the IMAGE function
Trim Whitespace: natively remove whitespace around data in cells, instead of having to use formulas
Remove Duplicates: natively remove duplicates in Google Sheets without needing to use an add-on or manual formula methods
Slicers: slicers are controls to add filters to pivot tables and charts
Reports & Themes: features to make dashboard reports easier in Sheets
OnPrem data connectors: data connectors to other SQL databases to easily access data from Sheets
Connected sheets: Connected Sheets connect Sheets to BigQuery and use Sheets functionality, like pivot tables, formulas and charts, with millions or even billions of rows of data inside BigQuery. The presenters showed an incredible demonstration of running a pivot table on 128 million rows of data!
View and edit history of individual cells: see how cells have changed over time
Embedding Sheets in Docs and Slides
MS Office Editing: work on Office files straight from G Suite without having to convert file types
Legacy keyboard shortcuts
2. How to Grow a Spreadsheet into an Application
Most of us use spreadsheets beyond simple data tasks. We build to-do lists, address books, scheduling apps, bug trackers, etc. Eventually, however, there comes a time when you need something more robust than a standalone Google Sheet, and this talk explores that journey, from single Google Sheet to full-blown application.
3. How to Simplify Business Processes with G Suite
4. Google Docs: Taking Collaboration Beyond Real Time
5. Open Doors to ML: How AAA Leverages BQML and Google Sheets to Predict Call Volume
An interesting session looking at how AAA uses BigQuery and Machine Learning to create predictive models that everyone can access through the Google Sheets interface. It was fascinating to see how Google Sheets has been positioned as the final step of the big data/machine learning pipelines.
6. Bring Your Favorite Enterprise Apps to G Suite with the New G Suite Add-ons
For Add-On developers, there was a big announcement about the new G Suite Add-Ons, which should make developers lives easier:
See you at Google Next 20 perhaps?