Subscribe / Unsubscribe Enewsletters | Login | Register

Pencil Banner

11 Google Sheets tips for businesses 2016

Christina Mercer | June 28, 2016
We reveal how to use Google Sheets for business 2016

With spreadsheets being vital for business, we reveal why your business should opt for Google Sheets and provide tips on the powerful features available to users. Here's how to make QR codes, data heat maps, make a custom Google Map and easy keyboard shortcuts (to name a few).

Here are 11 top Google Sheets tips for businesses 2016.

1. Keyboard shortcuts

11 Google Sheets tips: Keyboard shortcuts
Photo: Google

Google Sheets is packed full of handy little shortcuts, but you have to be in the know first. Here's how to pull up the entire list of shortcuts:

Windows: Control and / 
Mac: Command and /

2. Make your own custom Google Map

11 Google Sheets tips: Make your own custom Google Map
Photo: Google

Google Sheets enables users to create a custom Google Mapfull of their own data. This is very useful for tracking the location of customers and also common places of interest relating to your business.

1. Download the 'Mapping Sheets' add on (just click on the add on button and type it in)

2. Enter address data into the Sheet, the headings name, category and address will work best

3. Select these three categories and click 'add-ons' then 'Mapping Sheets' and finally 'start mapping'.

You will now be able to view and build your map and select the way the information is presented via the title, location and filter buttons on the right hand side.

3. Create an app with Google Sheets

11 Google Sheets tips: Create an app with Google Sheets
Photo: Google

AppSheets is a add-on available in Google Sheets that can put your data into a readable app. Here's how:

1. Make sure your spreadsheet has a title

2. The first row should have column header names

3. Insert at least five rows with actual data

4. From the menu, choose "add-ons > AppSheet > Launch" and click "GO" in the sidebar

5. The browser opens the AppSheet site and your app is auto-created (Taken from AppSheet)

4. Create a data heat map

11 Google Sheets tips: Create a data heat map
Photo: Google

data heat map allows businesses to identify cells and important information depending on its colour. This helps businesses see trends and patterns within its own data. Here's how to do it:

1. Imput and select data in Google Sheets

2. Go to format and click 'conditional formatting'

3. This will open a panel which enables users to choose a colour for the 'minpoint', 'midpoint' and 'maxpoint'

4. You can add new rules or just click done.

 

1  2  Next Page 

Sign up for CIO Asia eNewsletters.