Class Enrollment

Google Sheets 2 (LIVE Remote)
Date/Time:	Tue 10/21/2025 from 8:45 AM to 4:00 PM
Location:	Virtual Classroom 1
Class Price:	$350.00

Google Sheets 2 Training

If you need to crunch numbers for sales, information, inventory, or other organizational purposes, the ability to obtain the right data from the right people at the right time can be a great competitive skill to have. Since our world, especially the business world, depends on accurate data, being able to produce the data becomes a competitive skill. Equally important is being able to analyze and make sense of the information.

This course builds upon the skills and knowledge presented in Google Sheets Part 1A and Part 1B courses. This course will help you start your path to creating advanced workbooks and spreadsheets that can help you deepen your understanding of using Google Sheets and the data collected or organized in them.

Audience

This course is intended for students who already have foundational understanding and skills of Google Sheets and who wish to use Google Sheets in a higher-level functionality to analyze and present data.

Prerequisites

To ensure success, students should have completed Google Sheets Part 1A and Part 1B or have the equivalent knowledge and experience.

Objectives

Upon successful completion of this course,

You will:

• Work with functions.
• Work with lists.
• Analyze data.
• Visualize data with charts.
• Use Pivot Charts.

Lesson 1: Working With Functions

Topic A: Working With Ranges

Topic B: Use Specialized Functions

Topic C: Work With Logical Functions

Topic D: Work With Date & Time Functions

Topic E: Work With Text Functions

Lesson 2:  Working With Lists

Topic A: Sort Data

Topic B: Filter Data

Topic C: Query Data With Database Functions

Lesson 3: Analyzing Data

Topic A: Create And Modify Tables

Topic B: Apply Intermediate Conditional Formatting

Topic C: Apply Advanced Conditional Formatting

Lesson 4:  Visualizing Data With Charts

Topic A: Create Charts

Topic B: Modify And Format Charts

Topic C: Use Advanced Chart Features

Lesson 5:  Using Pivot Tables And Pivot Charts

Topic A: Create a Pivot Table

Topic B: Analyze Pivot Table Data

Topic C: Present Data With Pivot Tables