Google Sheets - Advanced
interactive

Google Sheets - Advanced

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

Intellezy
Updated Jul 22, 2024

What you'll learn

  • Linking and Protecting Data
  • Working with Range Names
  • Analyzing Data with Logical Functions
  • Working with Lookup Functions
  • Working with Text Functions
  • Working with Date Functions
  • Working with Data
  • Understanding PivotTables
  • Introduction to Macros and Scripts
  • Working with Forms
Course Description

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.