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 [...]
  • QAGSADV-QA
  • Cena na vyžádání

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

  • 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

Mám zájem o vybraný QA kurz