11 Google Sheets tips for businesses 2016: How to use Google Sheets for business: Google Spreadsheet Gadgets

We reveal how to use Google Sheets for business 2016

Share

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.

Read on to find out how to use Google Sheets for business...

Next Previous yah
Photo: Google

11 Google Sheets tips: Keyboard shortcuts

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 /

Next Previous yah
Photo: Google

11 Google Sheets tips: Make your own custom Google Map

Google Sheets enables users to create a custom Google Map full 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.

Next Previous yah
Photo: Google

11 Google Sheets tips: Create an app with Google Sheets

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)

(See also: How to market apps)

Next Previous yah
Photo: Google

11 Google Sheets tips: Create a data heat map

A 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.

Next Previous yah
Photo: Google

11 Google Sheets tips: Upload images faster

Images can be uploaded via file upload in Google Sheets, but if you're in a rush here's how to do it quicker:

=image(“place URL here”)

Next Previous yah
Photo: Google

11 Google Sheets tips: Create QR codes

QR codes are ubiquitous these days. They're a great way to share contact details, URLs, product information, and other brief amounts of text.

1. Install the QR Code Generator add-on

2. Input the data required (i.e. name of customer and unique code)

3. Click 'ad-ons' and then 'QR Code Generator'. From there you can click 'generate' to create QR codes.

Next Previous yah
Photo: Google

11 Google Sheets tips: Get more currencies

To access more currencies couldn't be simpler, but not many people know how.

Click the '123' button and then 'more formats', you'll see a tab marked 'more currencies' click that and you can choose from a huge list.

Next Previous yah
Photo: Google

11 Google Sheets tips: Create surveys and collection its data

Many businesses rely on surveys to gather important information on its customers and market but survey creation and gathering its data can be a chore, here's how to do it faster and easier:

Click 'Insert' and then 'Form' or click 'tools' then 'create a form'

Next Previous yah
Photo: Google

11 Google Sheets tips: Get Power Tools to edit faster

The Power Tools add-on offers easy editing shortcuts from removing characters to formatting numbers, dates and split values.

Next Previous yah
Photo: Google

11 Google Sheets tips: Spell check in Google Sheets

Not automatically correcting or highlighting spelling mistakes could leave fast typers a little red faced. Now Google Sheets can spell-check entire sheets or individual cells for you.

Highlight the chosen area (or don't for whole sheet) and go to 'tools', from there click 'spelling' and it will open a panel with a familiar spell check interface.

Next Previous yah
Photo: Google

11 Google Sheets tips: Email notifications

This tip might not be for everyone, depending on how often a sheet is updated, but here's how to turn on email notifications on Google Sheets.

Go to 'tools' then 'notification rules'. From there you can choose whether to be notified when a change is made or when a user submits a form. You can also limit notifications to a 'daily digest' so not to be bombarded with emails.

Related Articles