Google Sheets Training and Certification in Birmingham

Google Sheets Training and Certification in Birmingham, England

The course covers fundamental features such as creating formulas, formatting data, and using functions like SUM, VLOOKUP, and IF statements to perform calculations.

Enroll Now

Google Sheets Training and Certification is a professional training program delivered by ProgNXT in Birmingham, England. ProgNXT, a globally recognized corporate training provider in 55+ countries, offers this Google Sheets Training and Certification course with hands-on, instructor-led sessions. Google Sheets training equips participants with the skills to efficiently organize, analyze, and collaborate on data using Google’s cloud-based...

Expert Panel

Designed and delivered by the ProgNXT Data Analysis Expert Panel — a vetted team of industry professionals with 12+ years of hands-on experience in Excel, SQL, Python, Tableau, and Power BI

ProgNXT Data Analysis Expert Panel

Course Code: PRQ60
14 Hrs
Last Updated: April 2026

Course Rating5/5

Google Sheets training equips participants with the skills to efficiently organize, analyze, and collaborate on data using Google’s cloud-based spreadsheet tool. The course covers fundamental features such as creating formulas, formatting data, and using functions like SUM, VLOOKUP, and IF statements to perform calculations. Learners gain hands-on experience in organizing data with filters, conditional formatting, and data validation to improve accuracy and presentation. The training also explores advanced topics such as pivot tables, charts, and integrating Google Sheets with other Google Workspace tools for seamless collaboration. This course is ideal for individuals looking to enhance their data management and analysis skills while leveraging the cloud-based flexibility of Google Sheets.

Basic knowledge of computers and Google Workspace.
No prior experience with Google Sheets required.

Upon completion of this course, participants will:

Gain a solid understanding of Google Sheets interface and functions.
Learn to create, format, and analyze data in Google Sheets.
Be able to collaborate in real-time and automate tasks using Google Sheets features.
Acquire skills to create advanced formulas, data visualizations, and use Google Sheets for team collaboration.

Spreadsheet Management: Ability to create, manage, and organize data in Google Sheets.
Formulas and Functions: Proficiency in using Google Sheets' built-in functions like SUM, AVERAGE, VLOOKUP, and more.
Data Visualization: Skills to create and format charts for data visualization.
Collaboration Features: Understanding how to use Google Sheets' real-time collaboration tools.
Data Validation: Ability to implement data validation rules to control user input.
Automation with Google Apps Script: Understanding how to automate tasks using Google Apps Script.

Participants will be assessed on:

Google Sheets Basics: Navigating Google Sheets and entering data.
Formulas & Functions: Applying basic and advanced functions for data calculation.
Charts & Data Visualization: Creating and customizing charts to present data.
Collaboration Features: Using sharing, comments, and version history in Google Sheets.
Data Validation: Setting up and using data validation rules.
Google Apps Script: Creating simple automations using Google Apps Script.

Certificate of Completion: Participants who attend all sessions and successfully complete the course assessments will receive a ProgNXT Certificate of Completion for Google Sheets Training.

Google Sheets Basics and Data Management

Introduction to Google Sheets

Overview of the Google Sheets interface, menus, and toolbars.
Creating, opening, and saving spreadsheets in Google Sheets.
Hands-on Exercise

Data Entry and Basic Formatting

Entering and editing data in Google Sheets (text, numbers, dates).
Formatting cells: text styles, number formats, dates, and currency.
Hands-on Exercise

Working with Functions and Formulas

Using essential functions: SUM, AVERAGE, MIN, MAX.
Reference types: relative, absolute, and mixed references.
Lookup functions: VLOOKUP and HLOOKUP.
Hands-on Exercise

Creating and Customizing Charts

Introduction to different chart types in Google Sheets: line, bar, pie, etc.
Customizing charts: labels, titles, colors, and legends.
Hands-on Exercise

Advanced Google Sheets Features and Collaboration

Advanced Functions in Google Sheets

Logical functions: IF, AND, OR.
Text functions: CONCATENATE, LEFT, RIGHT, MID.
Date and time functions: DATE, DATEDIF, TODAY.
Hands-on Exercise

Data Validation and Protection

Setting up data validation rules to restrict input types.
Protecting ranges and sheets to prevent unauthorized edits.
Hands-on Exercise

Collaboration Tools in Google Sheets

Real-time collaboration: sharing and commenting on spreadsheets.
Version history: tracking and restoring previous versions of a sheet.
Hands-on Exercise

Automating Tasks with Google Apps Script

Introduction to Google Apps Script: what it is and how to use it.
Writing simple scripts to automate repetitive tasks in Google Sheets.
Hands-on Exercise

Google Sheets training handouts and cheat sheets.
Sample spreadsheets for hands-on exercises.
Links to Google Sheets tutorials and further resources.

Evaluation based on hands-on exercises and participation.
ProgNXT Certificate of Completion will be awarded to participants who successfully complete the course and assessment.

Google Sheets Training and Certification Events in birmingham

Online Events

Global Region	Location	Start Date	End Date	Action
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌

More Upcoming Session Dates

November 2026

🌐 Online Instructor-Led

4th Nov 2026→5th Nov 2026

📍 Birmingham, England

5th Nov 2026→6th Nov 2026

📍 Birmingham, England

19th Nov 2026→20th Nov 2026

🌐 Online Instructor-Led

21st Nov 2026→22nd Nov 2026

December 2026

🌐 Online Instructor-Led

1st Dec 2026→2nd Dec 2026

📍 Birmingham, England

2nd Dec 2026→3rd Dec 2026

📍 Birmingham, England

24th Dec 2026→25th Dec 2026

🌐 Online Instructor-Led

26th Dec 2026→27th Dec 2026

Events for other courses in Birmingham, England

Global Region	Course Name	Start Date	End Date	Action
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌

Google Sheets Training and Certification in Birmingham