We can host this training at your preferred location. Contact us!

In this hands-on instructor led course, you will learn about the basics of the Google sheets app.

Following the course, delegates will be confident in navigating, creating and modifying a Google sheet. Delegates will also learn about basic formatting and create basic formulas and functions.

Target Audience

This course is designed for those who wish to gain the necessary skills to create, edit, format and print basic Google sheets.
This course is suitable for users of Google Workspace. If you're attending at a QA location, the course will be delivered on Google Chrome.

Use a mouse
Type and use a keyboard
Experience in web browsing
Work with windows - minimise, maximise, open and close
Basic skills with Microsoft Office applications, or equivalent, are recommended, but not mandatory
Basic knowledge of Google drive and what it does is recommended, although not necessary

Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.

Get started with Google sheets
Create a basic worksheet
Modify a Google sheet
Use formulas and functions
Format a Google worksheet
Manage worksheets
Set up printing options

Module 1: Getting Started with Google Sheets

Introduction to Google Chrome / Google Drive
Google Sheets Environment
Introducing Google Chrome
Logging in to your Google Workspace
Accessing Google Sheets
Navigate and Selecting Cells in Worksheets
Open, Save and Close a Google Workbook

Module 2: Modifying a Google Sheet

Cut, Copy and Paste Commands
AutoFill Options
Find and Replace
Spell Check
Undo and Redo Commands
Insert and Delete Options
Column Width and Row Height
Hide and Unhide Options

Module 3: Using Formulas and Functions

Create Relative Formulas
Insert Google Functions
Copying a Formula
Creating an Absolute Formula

Module 4: Formatting a Google Sheet

Font Formatting
Add Borders and Colours to Cells
Cell Alignment
Number Formatting

Module 5: Managing Google Sheets

Managing Sheets
Freeze Panes

Module 6: Printing Google Sheets

Printing Options
Print Preview Options

Upcoming Trainings

Join our public courses in our New Zealand facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom

12 November 2024