Sheets Microtraining

A brief look at Drive, Docs, Slides and Sheets

For those who would like to learn the basics of how spreadsheets work. Starting with simple mathematical operations and moving on to some basic functions such as SUM and COUNTA.

Find the data you are looking for without affecting the view of others.

Design pivot tables to aggregate and display your data in just a few clicks.

Automate repetitive workflows using Sheets easy-to-use Macro recorder. Learn about relative and absolute references and take a peek at the code produced.

Learn about the most powerful function in Google Sheets (and one which does not exist in competing products!). Be prepared to get familiar with SQL-like language in doing so.

Update your charts and tables with one click when the background data changes

At CTS, we don't just work in Google Sheets, we love it! We recently asked our internal Workspace Community about their favourite Sheets features. Join us for this short, hands-on tour of 5 of those favourite features.

Learn why XLOOKUP is way more powerful than VLOOKUP in this short, hands-on session.

At CTS, we don't just work in Google Sheets, we love it! We recently asked our internal Workspace Community about their favourite Sheets features. Join us for this short, hands-on tour of 5 of those favourite features.

We hope to have the most impact in the shortest possible time. Select just the session(s) most useful to you.

If you're an intermediate to advanced spreadsheet user, with a few complex formulae under your belt, this session will show you how to create custom functions and use them across different sheets.

We hope to have the most impact in the shortest possible time. Select just the session(s) most useful to you.

We hope to have the most impact in the shortest possible time. Select just the session(s) most useful to you.