Tuesday, September 19, 2017

Tutorial: Proper Filtering and Sorting using Filter Views

Data often gets corrupted when people improperly sort information so they can group items together. Discover how Filters and Filtered Views can temporarily hide and sort your data without destroying its integrity .

Wednesday, August 16, 2017

Power Searching Google Drive

Google's superpower is search and to really narrow down on what you're looking for, it's important to be familiar with the advance search function.

Google indexes any file stored in Google Drive. Not only can you search for words in the title, but within the document itself. Using the advance search, you can pinpoint your results to a specific file type, owner or date.

By combining the URL Google Drive uses to display your search results with Google Chrome's search engine function, you can start a search from any page. In other words, you don't have to go to Google Drive first to enter your query.

Discover how easy it is to create custom search engines to search Google Drive.

Tuesday, May 23, 2017

Tutorial - Create reports using the Query Function

Having Google Forms enter your information directly into a spreadsheet is a great time saver. And once it's there, you can easily filter and sort your data. However, too many times people will mess up their data when they only sort some of their columns - making the data invalid and useless.

Instead of manually sorting, you can use the QUERY function to do all the work for you, while automatically updating your data as new information comes in. Check out the video below on the details:

Monday, May 22, 2017

Import Data from One Spreadsheet to Another

With every new intake of trainers, the question always comes up about how to move data from one spreadsheet to another. For example, I have a sheet with information on grade 7, 8, 9 students in a master list, but I only want the Grade 7 student list to be available to the Grade 7 teachers.

ImportRange is one of the amazing functions available to us in Google Sheets. Think of it as a live import - always updating itself as the master sheet gets updated. You can't make any changes to the data (i.e., read-only), but you can still apply filters to the data.

Here's a video on how to use the ImportRange function to setup this process: