Google Workspace - Sheets Advanced Training

• 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