This advanced session is designed for users who are already confident with foundational Google Sheets functions and are ready to take their skills further. You’ll explore some of the most powerful tools available in Sheets, including LAMBDA‑based functions, advanced lookups, and new dynamic ways to process and manipulate data.

You will learn how to build custom functions using LAMBDA, apply MAP and BYROW to automate row‑based processing, and work with XLOOKUP and XMATCH to create more robust and flexible search logic. These tools enable you to build more scalable spreadsheets, automate repetitive tasks, and work with data in far more sophisticated ways.

By the end of the session, you’ll have a firm understanding of four advanced functions and how to apply them to real scenarios to streamline your workflows and enhance your analytical capabilities.

LAMBDA Function Basics MAP & BYROW Processing Advanced Lookup Techniques Custom Function Building Data Automation Strategies Spreadsheet Optimisation

This course is perfect for people who:

A solid understanding of beginner and intermediate Google Sheets functions. You should be comfortable with formulas before advancing to this session.