AppsCare | Using the Explore function in Google Sheets - AppsCare
AppsCare is a Google for Work Premier Partner in the UK and specialises in the deployment of Google Apps for Work, Google Drive for Work, Google for Education, Google Maps for Work, Chrome Devices for Work and Google Search.
google enterprise premier partner, google enterprise partner, google enterprise reseller, google apps reseller, google apps partner, google maps reseller, google maps partner, chromebooks reseller, chromebox for meetings, google maps for business, google apps for business, google apps for education, google drive for work, drive for work, google for work, google apps for work, google maps for work, chrome for work, google for work premier partner, google apps for work reseller, uk, google for work uk premier partner, google apps reseller, google apps partner
single,single-post,postid-18849,single-format-standard,ajax_fade,page_not_loaded,,wpb-js-composer js-comp-ver-4.0.5,vc_responsive

17 Sep Using the Explore function in Google Sheets

Using the Explore function in Google Sheets: As described by Google, “Spend less time trying to make sense of your data and more time acting on it with Explore in Sheets. This new feature on the web and in the Android app analyses the data in your spreadsheets and automatically creates charts and surfaces insights based on that information.”

So let’s take a look at how it works.

Open up a Google Sheets document that has data in you would like to analyse.

Screen Shot 2015-09-15 at 15.53.03

You will notice in the bottom right hand corner the green Explore button.

Screen Shot 2015-09-15 at 15.53.17

If you click on the button, a right hand side menu will automatically open which will bring up tables and charts analysing the data within your Google Sheets document.

Screen Shot 2015-09-15 at 15.53.27

For each chart or table, you can choose to input these into your Sheets, by hovering over the button on the left hand side of each image and choosing to Insert Chart.

Screen Shot 2015-09-15 at 15.53.45You can then move and edit this Chart once inserted into your Google Sheets.

Screen Shot 2015-09-15 at 15.53.55

For more tips and tricks visit our Google Apps Tips blog.

Claire Stead
No Comments

Post A Comment