Learn to use logical statements, lookup functions, and date and text functions.
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.