5. 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")
6. 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.
7. 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.
8. 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.'
9. 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.
10. 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.
11. 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.
Source: Computerworld UK
Sign up for CIO Asia eNewsletters.