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).
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