Google Sheets - Advanced

This course will teach students advanced concepts and formulas in Google Sheets. Students will learn to use logical statements, lookup functions, and date and text functions. Additionally, students will learn how to link spreadsheets and Sheets files, work with range names, learn the options for spreadsheet protection, create PivotTables, work with macros and scripts. Students will also learn about conditional formatting, inserting graphics, and creating Forms.

Prerequisites

Google Sheets Introduction or equivalent experience.

Certification

This course aligns with the CAP Body of Knowledge and
should be approved for 2.25 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.