Using XLOOKUP in Sheets

A full day, hands-on induction to Google Workspace for those who are new to the platform.

A hands-on exploration of Google Docs' core functionality, as well as some tips and tricks to foster best practice in collaboration.

Get hands-on with Google Sheets, as we focus on Google Sheets' core functionality, some tips and tricks to foster best practice in handling your data, and an exploration of some of the more advanced features.

Join us as we discover the flexibility of GMail to work for the individual and demonstrate some simple automations to make your life easier.

Learn the details of Google Calendar so that you can be the master of your own schedule, and those of your colleagues!

Become an expert in Google Drive and Shared Drives, and understand best practice in Google Workspace collaboration.

A hands-on exploration of Google Slides' core functionality, as well as some tips and tricks to foster best practice in collaboration.

Learn to build Google Forms to collect and collate survey data from your audience.

Become comfortable hosting and participating in meetings on Google Meet.

Discover how Google Workspace gives us modern tools to strengthen the established principles of effective meetings.

Become an advocate for Google Workspace in your organisation by learning the common pitfalls and their solutions.

Collaborating with external partners on a different platform is no longer a reason to change your Workspace ways! Let us guide you through best practice in working with non-Google users and file formats in Google Drive.

A short tour of Workspace with an intro to Mail, Chat, Drive and Calendar

A brief look at Drive, Docs, Slides and Sheets

A tour of some of Google Docs' lesser-used features - both old and new. Join us for 10 productivity tips to help you save time every day!

Make and manage suggestions, comments and action items.

Collaborate without fear of data loss. Name and retrieve previous versions of your documents.

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.

An intro to some commonly-used functions for someone who is becoming more interested in spreadsheets. Learn functions such as VLOOKUP, COUNTIF, CONCATENATE, IF, LEN, LEFT/RIGHT, SPLIT and any others that take our fancy!

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.

Set up a Slides theme and template to bring brand identity and consistency to your work

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

Collect information from hundreds of people without filling your inbox and giving yourself unnecessary administrative overheads.

Make a survey or questionnaire in which the following questions depend on the answers to the prior questions.

Using Spreadsheet Functions to Dynamically Build Pre-filled Links

We all love a good spreadsheet but it's definitely possible to have 'too much of a good thing'. For those who are already experienced with Google Sheets, we will show you how to connect live Sheets data to Looker Studio and produce your first report.

Five tips and tricks to make your life easier in Google Slides. Work with themes, diagrams and the presenter view to make the best impression!

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.

An introduction to the different event types, appointment slots and time insights in Calendar.

As a more advanced spreadsheet user, you will be making decisions in every cell! Learn the basics if IF, COUNTIF and SUMIF before learning when to use IFS and SWITCH instead!

We need to fit into busy schedules, and to leave colleagues feeling that their time has been well spent. For most people, this means avoiding that one-size-fits-all procession through every facet of the software. We've all endured it in the past, and we want to help you escape it in the future!

New recruit? It will often take time for new colleagues to get up to speed. That is, unless they join us for this one-hour, online course and learn those Workspace basics at pace.

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.

Five tips and tricks to make your life easier in Google Slides. Work with themes, diagrams and the presenter view to make the best impression!

Learn what apps script is and begin to understand its capabilities as we copy/paste some simple code samples. Suitable for those who have never written a line of code.

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.

This course will take even the most apprehensive spreadsheet user on a journey towards gaining superpowers in Google Sheets. Starting right at 'Cell One', our expert trainer will guide you through three distinct modules, each one building upon the skills gained previously.

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.