This instructor-led, hands-on course is designed for users who want to develop their Google Sheets skills to an advanced level.

Throughout the programme, participants learn how to analyse and manipulate data using more sophisticated formulas and functions. The course also explores advanced spreadsheet capabilities including Conditional Formatting, Data Validation, Sheet Protection, and Macros.

The training builds on the knowledge developed at Google Sheets Intermediate level. Learners gain practical experience automating repetitive work, controlling user input, protecting selected areas of a spreadsheet, applying advanced logical and lookup functions, working with Array Formulas, and importing information from other sources.

By the end of the course, participants will be able to manage more complex spreadsheet solutions, perform advanced analysis, and create more controlled and automated workflows within Google Sheets.

We can organize this training at your preferred date and location.

Prerequisites

Participants should:

Be confident IT users,
Be comfortable using a web browser,
Have knowledge equivalent to Google Sheets Intermediate,
Have intermediate to advanced experience with Google Sheets or Microsoft Excel.

For virtual delivery, an additional screen is recommended so that participants can work through practical activities while viewing the training content.

Who Should Attend

This course is particularly suitable for:

Users who want to take their Google Sheets skills to an advanced level,
Participants who have completed Google Sheets Intermediate or have equivalent knowledge,
Professionals who perform advanced spreadsheet analysis,
Users who want to apply automation, validation, protection, and advanced formulas in Google Sheets.

The programme is designed for Google Workspace users and practical activities can be completed using Google Chrome.

What You Will Learn

By the end of this course, participants will be able to:

Automate repetitive Google Sheets processes using Macros,
Change spreadsheet appearance based on conditions with Conditional Formatting,
Restrict user input using Data Validation,
Create Dynamic Validation Lists,
Protect Sheets and Cell Ranges,
Keep selected cells editable within protected sheets,
Share protected spreadsheets securely with other users,
Use advanced Date & Time, Logical, and Lookup Functions,
Work with Array Formulas,
Create Sparklines for in-cell visual analysis,
Import data from other Google Sheets and web sources,
Use Google-specific functions for more advanced data analysis.

Training Outline

Module 1 – Automating Tasks in Sheets with Macros

Understanding what a Macro is
Common uses for Macros
Recording Macros
Capturing repetitive tasks
Relative Macros
Absolute Macros
Comparing Relative and Absolute Macro behaviour
Running a Macro
Editing existing Macros
Deleting Macros
Creating automation within spreadsheet workflows

Module 2 – Formatting Cells with Conditional Formatting

Introduction to Conditional Formatting
Applying formatting to a Cell Range
Creating multiple Conditional Formats
Using several rules together
Applying Colour Scales
Comparing values visually
Creating Conditional Formatting with Formulas
Applying formatting based on more complex conditions

Module 3 – Using Data Validation to Restrict User Entry

Understanding Data Validation
Restricting user entry with Numbers
Applying Text-based criteria
Preventing invalid input
Dropdown List Validation
Creating standard dropdown lists
Building Dynamic Validation Lists
Creating lists that update as source data changes
Using validation to improve data quality

Module 4 – Google Sheet Protection and Sharing

Protecting a Cell Range
Protecting an entire Google Sheet
Defining Editable Ranges within a protected sheet
Combining protected and editable areas
Managing editing permissions
Sharing a protected Sheet with a colleague
Balancing collaboration with data protection

Module 5 – Advanced Formulas and Functions

Advanced Date and Time Functions
Analysing date and time information
Logical Functions
Building formulas with multiple conditions
Lookup Functions
Searching and matching information
Working with more advanced lookup scenarios
Array Formulas
Processing multiple cells with a single formula
Combining functions for advanced analysis

Module 6 – Working with Sparklines

What are Sparklines?
Use cases for in-cell visualisations
Inserting Sparklines into a Google Sheet
Displaying trends within individual cells
Changing Sparkline Options
Adjusting Sparkline appearance and behaviour
Using Sparklines for quick visual comparison in larger tables

Module 7 – Importing and Exporting Data

Working with data across multiple Google Sheets files
Importing a selected Data Range from another Google Sheet
Using Import Functions
Connecting spreadsheet sources
Importing information from a Web Page
Bringing web-based data into Google Sheets
Using imported information for further analysis

Hands-On Learning

Participants complete practical exercises throughout the programme using realistic spreadsheet scenarios.

Activities include:

Recording and running Macros,
Creating Conditional Formatting rules,
Applying Data Validation,
Managing permissions on Protected Sheets,
Using Advanced Functions and Array Formulas,
Creating Sparklines,
Importing data from external sources.

This hands-on approach helps learners apply the advanced features of Google Sheets directly to their everyday work.

Why Choose Us

Experience Google Workspace - Sheets Advanced in United States of America through Bilginç IT Academy's live and interactive virtual classroom environment. Join a Public course as an individual delegate or arrange a dedicated Private / In-house online training program exclusively for your organization.

Delivery Method: Online Instructor-Led
Participation Model: Public / Private (In-house)
Live and Interactive Training: Connect with your instructor in real time and actively participate through discussions, Q&A sessions, practical exercises, and group activities.
Flexible Participation: Join the training from your home, office, or any location with a suitable internet connection.
Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's professional training experience since 1995.
Worldwide Access: Join our live virtual classrooms from United States of America or anywhere else in the world, or arrange a dedicated online training program for your organization.

Experience Google Workspace - Sheets Advanced through face-to-face Classroom Based training in United States of America. Training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class for your organization.

Delivery Method: Classroom Based
Participation Model: Public / Private (In-house)
Face-to-Face Learning: Interact directly with your instructor and fellow delegates in an engaging classroom environment.
Experienced Trainers: Learn from specialists with extensive industry experience and practical real-world knowledge.
Professional Training Environment: Attend training in comfortable, well-equipped classrooms designed to support effective learning.
Practical Learning: Depending on the course, reinforce your knowledge through hands-on exercises, scenarios, case studies, and instructor-led activities.

Arrange Google Workspace - Sheets Advanced in United States of America as a dedicated Onsite training program for your organization. Bilginç IT Academy trainers can deliver the training at your office or another location of your choice, with the program planned around your team's requirements and business objectives.

Delivery Method: Onsite
Participation Model: Private (In-house)
Training at Your Preferred Location: Organize the training at your company's office or another location selected by your organization.
Tailored Course Content: Adapt the training program to your projects, team structure, existing skill levels, and specific business requirements.
Team-Focused Learning: Develop your team around a shared knowledge base while strengthening internal collaboration and knowledge transfer.
Flexible Scheduling: Plan the training dates, location, and program according to your organization's operational requirements.
Worldwide Onsite Delivery: Arrange the training in United States of America or at another preferred location worldwide. Bilginç IT Academy trainers can travel to your selected location to deliver the dedicated training program.

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Google Workspace - Sheets Advanced Training in United States of America

Prerequisites

Who Should Attend

What You Will Learn

Training Outline

Module 1 – Automating Tasks in Sheets with Macros

Module 2 – Formatting Cells with Conditional Formatting

Module 3 – Using Data Validation to Restrict User Entry

Module 4 – Google Sheet Protection and Sharing

Module 5 – Advanced Formulas and Functions

Module 6 – Working with Sparklines

Module 7 – Importing and Exporting Data

Hands-On Learning

Why Choose Us

Google Workspace - Sheets Advanced Training Course in United States of America Schedule

Other trainings and courses related to the Google Workspace - Sheets Advanced

Google Workspace - Sheets Advanced Training in United States of America

Prerequisites

Who Should Attend

What You Will Learn

Training Outline

Module 1 – Automating Tasks in Sheets with Macros

Module 2 – Formatting Cells with Conditional Formatting

Module 3 – Using Data Validation to Restrict User Entry

Module 4 – Google Sheet Protection and Sharing

Module 5 – Advanced Formulas and Functions

Module 6 – Working with Sparklines

Module 7 – Importing and Exporting Data

Hands-On Learning

Why Choose Us

Online Instructor-Led Training

Classroom Based Training

Onsite Training

Google Workspace - Sheets Advanced Training Course in United States of America Schedule

Other trainings and courses related to the Google Workspace - Sheets Advanced