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
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
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
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
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.
Sign up for CIO Asia eNewsletters.