New: Gemini July — Free Gemini training for your whole team in July →
Skip to content
Live LearningCo
For IT Teams
Drive adoption & reduce tickets
For Learning Teams
Scale training without headcount
Policy to Practice
Turn AI policies into capabilities
Technology Migration
Dedicated rollout support
Gemini July
Free Gemini training — July 2026
Microsoft Month
Free Microsoft training — May 2026
LMS Integration
Courses
Live Learning
ScheduleTrainers
Learning for Good
Free training for VCSE organisations
BlogCase Studies
PricingAbout
Free TrialBook a Demo
Live LearningCo

Live expert training for enterprise teams. Close the gap between software investment and real adoption.

Solutions
  • For IT Teams
  • For L&D Teams
  • Policy to Practice
  • Technology Migration
  • LMS Integrations
  • For Enterprise
  • Pricing
Courses
  • Microsoft 365
  • Google Workspace
  • AI & Copilot
  • View All
Company
  • About
  • Careers
  • Case Studies
  • Blog
  • Contact
  • Learning for Good
© 2026 Live LearningCo. All rights reserved.
Privacy PolicyTermsCookies
HomeCoursesGoogle SessionsAdvanced Google Sheets User
Google Sessions

Advanced Google Sheets User

1 hour
Live
All levels
Next: 2026-06-15
Book a SessionRequest Team Booking

About this course

Google Sheets: Advanced User

Extract data, automate your workflows, and build smarter, more powerful spreadsheets.

Duration 60 minutes
Level Advanced
Completion Certificate + Badge

Course Overview

This advanced session is designed for experienced Google Sheets users who are ready to take their skills even further. You'll learn how to extract structured information from smart chips, automate repetitive tasks, and create re‑usable formulas that speed up your workflow.

The session covers named ranges, macros, named functions and advanced formatting techniques, helping you build spreadsheets that are scalable, efficient and far easier to maintain. These tools are ideal for users working with large datasets or complex analytical requirements.

By the end, you'll have the skills to automate higher‑level tasks, streamline your processes, and build more powerful Sheets solutions across your organisation.

Skills Gained

Smart Chip Data Extraction Named Ranges & Structured References Macros & Automation Named Functions Advanced Conditional Formatting Spreadsheet Automation Techniques

What You'll Learn

• Extracting Data from Smart Chips - Pull structured information directly from chips embedded within your Sheets.
• Named Ranges - Simplify complex formulas by saving arrays and referencing them with ease.
• Macros - Automate repetitive tasks such as formatting or function workflows to save time.
• Named Functions - Convert complex or frequently used formulas into reusable custom functions.
• Advanced Conditional Formatting - Customise visual rules using LAMBDA-driven logic for cleaner insights.
• Enhanced Automation - Leverage advanced features to streamline data handling and accelerate your workflows.

Who Is This For?

This course is perfect for people who:

✓ are experienced Sheets users ready for advanced tools and automation
✓ need to process large or complex datasets efficiently
✓ are aiming to automate tasks and build reusable spreadsheet solutions

Prerequisites

Strong understanding of Google Sheets. Completing our beginner and intermediate Google Sheets training is recommended for maximum value.     

Upon Completion

Digital Badge

Shareable credential for LinkedIn and professional profiles

Certificate of Completion

Official certificate to showcase your achievement

You might also like

Browse all courses
Workspace Studio: Automate Your Boring Tasks with Ease

Workspace Studio: Automate Your Boring Tasks with Ease

Live
Elevate Your Campaigns: Google Workspace Tools for Outreach & Coordination

Elevate Your Campaigns: Google Workspace Tools for Outreach & Coordination

Upcoming live sessions

Jun
15
14:00 GMT
Live Session Morgan d'Arcy
Book Session
Aug
6
11:00 GMT
Live Session Morgan d'Arcy
Book Session
Sept
15
14:00 GMT
Live Session Morgan d'Arcy
Book Session

Frequently asked questions

Next Session
2026-06-15
Live
Book a SessionRequest team booking
Live interactive session
Expert certified trainer
Certificate of completion

Need help?

Not sure if this course is right for your team? Our learning specialists can help.

Chat with an expert
Live
An Intermediate Guide to Functions in Google Sheets.

An Intermediate Guide to Functions in Google Sheets.

Live