Google Workspace - Sheets Intermediate Training in United States of America

  • Delivery Method: Online Instructor-Led / Classroom Based / Onsite
  • Participation Model: Public Training / Private / In-House Training
  • Duration: 1 Day
  • Level: Intermediate
  • Price: From USD 900 +TAX
  • Upcoming Date:
  • UK Based Global Training Provider

This instructor-led, hands-on course is designed for users who want to move beyond the fundamentals of Google Sheets and develop stronger spreadsheet analysis skills.

Throughout the course, participants learn how to organise, examine, and interpret data more effectively using formulas, functions, and a range of built-in analysis tools.

The programme covers named ranges, advanced cell references, date and time functions, text functions, IF and VLOOKUP, as well as sorting, filtering, charts, and Pivot Tables.

By the end of the course, learners will be more confident working with larger datasets, performing common business analysis tasks, and presenting information in a clear and meaningful way using Google Sheets.


We can organize this training at your preferred date and location.
HAVELSAN
ASELSAN
PepsiCo Türkiye
JTI TÜTÜN ÜRÜNLERİ SANAYİ A.Ş.
ING Bank
DHL
MASTERCARD
Huawei
TotalEnergies
Mercedes-Benz Türk A.Ş.
Goodyear
FORD OTOMOTIV SANAYI A.S.
3M COMPANY
Schneider Electric
Central Bank of Azerbaijan
BP Petrolleri
Procter & Gamble (P&G)
Qatar Foundation
Bank Of China
GlaxoSmithKline (GSK)
MORGAN STANLEY & CO Inc
Novo Nordisk
DEUTSCHE BANK
Azerbaycan Cumhuriyeti Emek ve Ahalinin Sosyal Güvenliği Bakanlığı
ACCENTURE

Prerequisites

Before attending the course, participants should be able to:

  • Use a mouse and keyboard confidently,
  • Work comfortably with a web browser,
  • Open, close, minimise, and maximise windows,
  • Use the fundamental features of Google Sheets,
  • Work with Google Drive and common Google applications,
  • Demonstrate knowledge equivalent to Google Sheets Introduction and Google Workspace - Cloud Essentials.

For virtual delivery, a dual-monitor setup may be required to make it easier to follow demonstrations while completing practical exercises.

Who Should Attend

This course is suitable for:

  • Users who already have a basic knowledge of Google Sheets,
  • Participants who have completed Google Sheets Essentials or have equivalent experience,
  • Professionals who regularly work with spreadsheets in Google Workspace,
  • Users who want to improve their data organisation, analysis, and reporting skills.

The course 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, learners will be able to:

  • Use Named Ranges to simplify spreadsheet management and formulas,
  • Apply Mixed References effectively,
  • Work with useful date and time functions,
  • Clean and reorganise spreadsheet data using Text Functions,
  • Build conditional calculations using the Logical IF function,
  • Use VLOOKUP to find and compare information,
  • Analyse lists using Sorting and Filtering tools,
  • Create different analytical views with Filter Views,
  • Present information visually using Charts,
  • Summarise and analyse larger datasets with Pivot Tables,
  • Extend Pivot Table analysis by using Calculated Fields.

Training Outline

Module 1: Working with Advanced Functions

  • Creating and using Range Names
  • Making formulas easier to manage with Named Ranges
  • Understanding Relative, Absolute, and Mixed References
  • Working with Mixed References
  • Using specialised functions
  • Working with date and time functions
  • Cleaning and organising information with Text Functions
  • Applying the Logical IF function
  • Looking up and comparing information with VLOOKUP

Module 2: Data and List Management

  • Organising data with Sorting
  • Displaying selected records using Filtering
  • Creating and working with Filter Views
  • Grouping Rows and Columns
  • Managing larger lists more efficiently
  • Using Explore features
  • Working with Database Functions
  • Analysing structured lists and datasets

Module 3: Working with Charts

  • Creating Charts from spreadsheet data
  • Editing chart data and settings
  • Formatting chart appearance
  • Exploring different Chart Types
  • Selecting appropriate charts for different types of information
  • Presenting analysis visually

Module 4: Analysing Data with Pivot Tables

  • Understanding why Pivot Tables are useful
  • Creating a Pivot Table from existing data
  • Working with Row, Column, and Value fields
  • Adding Date Fields
  • Analysing date-based information
  • Filtering Pivot Table results
  • Using drill-down to investigate underlying data
  • Adding Calculated Fields
  • Summarising and comparing larger datasets

Module 5: Templates and Collaborative Content

  • Working with Google Templates
  • Making use of existing templates
  • Creating Hyperlinks within spreadsheets
  • Adding Notes
  • Working with Comments
  • Using spreadsheet features that support explanation and collaboration


Hands-On Learning

The course combines instructor guidance with practical exercises. Participants work with sample datasets and apply formulas, filters, charts, and Pivot Tables to reinforce the techniques introduced during each module.

This practical approach helps learners transfer their new Google Sheets skills directly into everyday data management, analysis, and reporting activities.

Why Choose Us

Experience Google Workspace - Sheets Intermediate 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 Intermediate 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 Intermediate 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.
Contact us for more detail about our trainings and for all other enquiries!

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

Join our public courses in our United States of America facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

We can organize this training at your preferred date and location.
10 October 2026 (1 Day)
New York, San Francisco, Austin, Seattle, Chicago
USD 900 +TAX
22 October 2026 (1 Day)
New York, San Francisco, Austin, Seattle, Chicago
USD 900 +TAX
25 October 2026 (1 Day)
New York, San Francisco, Austin, Seattle, Chicago
USD 900 +TAX
09 November 2026 (1 Day)
New York, San Francisco, Austin, Seattle, Chicago
USD 900 +TAX
12 November 2026 (1 Day)
New York, San Francisco, Austin, Seattle, Chicago
USD 900 +TAX
16 November 2026 (1 Day)
New York, San Francisco, Austin, Seattle, Chicago
USD 900 +TAX
17 November 2026 (1 Day)
New York, San Francisco, Austin, Seattle, Chicago
USD 900 +TAX
18 November 2026 (1 Day)
New York, San Francisco, Austin, Seattle, Chicago
USD 900 +TAX

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

The United States continues to define the global frontier of technology and innovation, serving as the home to the world's most influential tech titans. From the legendary Silicon Valley and San Francisco Bay Area to emerging hubs like Austin, Seattle, and the Silicon Alley in New York, the US ecosystem remains unparalleled. Top-tier institutions such as MIT, Stanford, and Carnegie Mellon provide the research backbone for breakthroughs in Artificial Intelligence, Quantum Computing, and Cybersecurity. Our training programs are meticulously aligned with these industry-leading standards, ensuring that professionals can navigate the complexities of the modern digital landscape. We bridge the gap between academic theory and high-stakes corporate execution in the most competitive tech market on Earth.

Bilginç IT Academy All Rights Reserved

By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.