Create, edit and collaborate better with these Google Sheets tips and tricks


Modified 14 June 2018 by Steve Adams

https://youtu.be/gFhuVn6mjR8

More magic added to Explore in sheets!

We have tipped before on the wonders of the Explore features in Google Sheets as Google ad AI and Machine Learning features to our everyday productivity tools.

See: GAIN INSIGHTS IN SHEETS DATA VIA EXPLORE

https://gsuitetips.com/tips/sheets/gain-insights-in-sheets-data-via-explore/

Explore in Sheets will now create Pivot Tables summarize data sets and find useful patterns.

To access Explore, open a spreadsheet.

  • In the bottom right, look for the Explore icon.

To work on a specific portion of your data you can select a range of cells.