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).
For customers attending remotely via Virtual Classroom, an additional screen is required for this course to work through remote desktop labs and view training information.
Module 1 - Automating Tasks in Sheets with Macros
Module 2 - Formatting Cells with Conditional Formatting
Module 3 - Use Data Validation to Restrict User Entry
Module 4 - Google Sheet Protection and Sharing
Module 5 - Advanced Formulas and Functions
Module 6 - Working with Sparklines
Module 7 - Importing and Exporting
Join our public courses in our Singapore facilities. Private class trainings will be organized at the location of your preference, according to your schedule.