Google Sheets - Advanced
Interactive

Google Sheets - Advanced

Learn to use logical statements, lookup functions, and date and text functions.

Intellezy Learning
Updated Feb 06, 2020

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 IAAP-certified course counts for 2.25 recertification points for the CAP certification under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.