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

In this hands-on instructor led course, you will learn about the Google Sheets app to an advanced level.

Following the course, delegates will be confident in analysing and manipulating their data in Google sheets using various advanced formulas and functions. You will cover more advanced sheets functionality like conditional formatting, data validation and sheet protection. This course builds on the knowledge from the intermediate Google sheets course (QAGSITM).

Target Audience

This course is aimed at users who wish to enhance their knowledge and skills in Google sheets to an advance level. Delegates should have attended QA's Google Sheets Intermediate course or have equivalent knowledge.
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.

Competent IT user
Experience in web browsing
Must have attended the Google sheets intermediate course (QAGSITM) or have the equivalent knowledge
Intermediate to advanced knowledge of Google sheets or Excel spreadsheets

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

Use macros to automate processes in Google Sheets
Use conditional formatting to change the appearance of a Google sheet
Utilise data validation to restrict user entry within a Google sheet
Protect a Google sheet whilst allowing certain cells to remain editable
Share a Google sheet
Use advanced Date & Time, Logical, Lookup functions to analyse data
Understand and use Array formulas
Work with Sparklines
Use the Google Import & Export functions
Use Google specific functions to analyse data

Module 1 - Automating Tasks in Sheets with Macros

What is a Macro
Record Macros
Comparing Relative and Absolute Macros
Running a Macro
Edit or Delete a Macro

Module 2 - Formatting Cells with Conditional Formatting

Add Conditional Formatting to a Range of Cells
Add Multiple Conditional Formats
Apply a Conditional Format with Colour Scales
Apply Conditional Format with Formulas

Module 3 - Use Data Validation to Restrict User Entry

Restrict User Entry with Numbers
Restrict User Entry with Text
Dropdown List Validation
Creating Dynamic Validation Lists

Module 4 - Google Sheet Protection and Sharing

Protecting a Cell Range
Protecting a Google Sheet
Applying an Editable Range to a Protected Sheet
Share a Protected Sheet with a Colleague

Module 5 - Advanced Formulas and Functions

Date and Time Functions
Logical Functions
Lookup Functions
Array Formulas in Sheets

Module 6 - Working with Sparklines

What are Sparklines
Insert Sparklines into a Google Sheet
Change Sparkline Options

Module 7 - Importing and Exporting

Importing a Range of Data from another Google Sheet
Importing Data from a Web Page

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 July 2024