Computer Tutoring Logo
Est. 2002
Menu Button

Windows training Videos

Google Sheets Tutotirals

It's amazing how many are switching over to Google Sheets. What with sheets being better at sharing along with access to all the email features etc from the Application Script it's no wonder.

Google Sheets Filter Function

Using the Filter Function in Google sheets is a great way to extract data from one sheet, filter it, then display the data on another sheet. This tutorial will also show you how you can use the Google Sheets Filter function in conjunction with the Query function for wildcard searching.

Conditional Format the Whole Row

Conditional formatting is a tool that makes it easy for you to see data that meets a certain criteria. Say for example if somebody is already employed, or not. Or an order is overdue. This tutorial will show you how to change the colour of the row within the data.


Customer Classification Pt 1

This free tutorial will show you how to use Google Sheets to classify customers. You know give the customers an A,B or C ratinig depending on their spend. In fact you can apply the principles within this tutorial to any type of data classification.