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.

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 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 anywhere in the world or arrange a dedicated online training program for your organization.

Experience Google Workspace - Sheets Intermediate in a professional face-to-face classroom environment. Classroom Based training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class exclusively 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 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: Bilginç IT Academy trainers can travel internationally to deliver dedicated training programs at your preferred location.

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 Intermediate Training