LOOKING FOR RATES AND SCHEDULES
​TO JOIN A PUBLIC CLASS?
CLICK HERE.

NEED A PROPOSAL FOR COMPANY?
EMAIL [email protected]

Course Introduction
​
Google Sheets has become a practical tool for managing data, creating reports, collaborating with teams, and automating simple workplace tasks through the cloud. This training introduces participants to the most useful features of Google Sheets, especially for users who need to organize information, apply formulas, validate entries, and summarize data without relying only on Microsoft Excel. The program focuses on hands-on workplace applications so participants can immediately use Google Sheets for tracking, reporting, and basic data analysis.

Main Objectives

By the end of the training, participants will be able to:

1. Identify the key similarities and differences between Google Sheets and Microsoft Excel.
2. Apply commonly used text, math, logical, and lookup functions in Google Sheets.
3. Use Google Sheets-specific functions for filtering, sorting, extracting, and connecting data.
4. Manage worksheet entries using conditional formatting, validation rules, dropdown lists, and protected ranges.
5. Create basic Pivot Tables to summarize and analyze data more efficiently.

Who Should Attend
This training is ideal for employees, supervisors, administrative staff, trainers, analysts, and team members who regularly work with spreadsheets and want to use Google Sheets more effectively. It is also suitable for Excel users who are transitioning to Google Sheets or organizations that use Google Workspace for collaboration, reporting, and shared data management.

Methodologies

Guided Demonstration and Hands-On Practice
The facilitator will demonstrate each tool or function using realistic worksheet examples, followed by guided exercises where participants apply the same skills on sample data.

Workplace-Based Spreadsheet Activities
Participants will work on practical spreadsheet scenarios such as cleaning text data, creating dropdowns, validating entries, applying formulas, and summarizing records using Pivot Tables.

Module 1: Comparing Google Sheets and Microsoft Excel

• Google Sheets vs. Excel Overview
• Similarities in Spreadsheet Structure
• Formula and Function Comparison
• Feature Comparison
• Cloud-Based File Access
• Sharing and Collaboration Differences
• Importing and Exporting Excel Files

Module 2: Basic Google Sheets Functions

• Formula Structure and Syntax
• Cell and Range References
• Relative and Absolute References
• Basic Text Functions
• Basic Math Functions
• COUNTIF and SUMIF
• Basic IF Statements
• Basic Lookup Functions

Module 3: Functions Unique to Google Sheets

• Google Sheets-Specific Function Overview
• FILTER Function
• SORT Function
• UNIQUE Function
• SPLIT Function
• Basic Parser Functions
• IMPORTRANGE Function
• Basic Google Functions

Module 4: Data Management

• Conditional Formatting
• Basic Highlighting Rules
• Data Validation
• Creating Dropdown Lists
• Dropdowns from Cell Ranges
• Restricting Invalid Entries
• Checkboxes
• Basic Sorting and Filtering

Module 5: Basic Pivot Table Features

• Preparing Source Data
• Creating a Pivot Table
• Rows, Columns, Values, and Filters
• Summarizing Data
• Filtering Pivot Table Results
• Changing Summary Calculations
• Updating and Modifying Pivot Tables

Related Courses

Basic MS Excel

Advanced MS Excel

Advanced Google Sheets Training