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).
Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.
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 Hong Kong facilities. Private class trainings will be organized at the location of your preference, according to your schedule.