Google Sheets

Tips & Tricks for using Google Sheets

Clarify Your Charts Using Data Labels
Creating a chart is one of the best ways to draw important conclusions from a set of data. Although visual charts are easier to digest than countless rows...
Mon, 23 May, 2016 at 6:10 PM
6 Advanced Spreadsheet Tips with Formulas and Apps Script
There are so many features inside of Google Spreadsheets that it’s really hard to say you’ve completely mastered the platform. It can be especially tough ...
Mon, 23 May, 2016 at 6:11 PM
Include hidden and filtered data in charts in Google Sheets
Hidden columns and rows were always tricky when it came to making charts from a Google Sheet. With this update you are given the option of including or ex...
Mon, 23 May, 2016 at 6:12 PM
Create Printable Shipping Labels Using Google Sheets
You probably already know countless ways that Google Apps can make life easier in the digital world. Most people don’t realize how much it can also simplify...
Mon, 21 Sep, 2015 at 12:19 PM
Google Sheets Now Automatically Analyzes Your Data For You
When it comes to creating charts and in depth analysis of your data in a Google Sheet, speed was never the first word that came to mind. I would often fin...
Mon, 23 May, 2016 at 6:13 PM
How to Password Protect a Google Sheet
Unfortunately there is currently no way to password protect a Google Document natively in Drive, but you can achieve the same using the password ...
Mon, 23 May, 2016 at 6:50 PM
ARRAYFORMULA
Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays. Sample U...
Mon, 23 May, 2016 at 5:55 PM
CONTINUE
CONTINUE returns a specified cell from an array formula result. Sample Usage CONTINUE(A2,2,1) Syntax CONTINUE(source_cell, row, column) ...
Mon, 23 May, 2016 at 5:56 PM
DETECTLANGUAGE
DETECTLANGUAGE identifies the language used in text within the specified range. Sample Usage DETECTLANGUAGE(A2:B7) DETECTLANGUAGE("Bonjour&q...
Mon, 23 May, 2016 at 5:57 PM
GOOGLECLOCK
GOOGLECLOCK Returns the current system date and time and updates automatically once per minute. GOOGLECLOCK is not available in the new Google She...
Mon, 23 May, 2016 at 6:05 PM