Google Sheets Advanced Functions: Unlock the Hidden Power of Google Sheets

Using Advanced Functions in Google Sheets

This is an advanced session therefore it is particularly suitable for users who are already familiar with basic functions and formulas and want to take their skills to the next level.

Get an introduction to LAMBDA Functions, XLOOKUP and XMATCH.

To get the best out of Google Sheets we have created several sessions to cover all the functionality that will help you master Google Sheets.

Functions are potent tools built directly into Google Sheets and have a wide range of uses from simple calculations to advanced functions!

At the end of this training session, you will have a solid understanding of four different advanced functions in Google Sheets. You will be able to use these functions to automate tasks, solve complex problems, and create more powerful spreadsheets.

Badge earned on completion

Difficulty

Shareable Certificate

Key Takeaways

What is LAMBDA? – we take a look at how this function works in Sheets and why you would use it
MAP -Input a selection of rows and columns, process it and output it elsewhere
BYROW– Apply a function to a range and process the data row by row.
XLOOKUP – More powerful than VLOOKUP using search keys
XMATCH – New ways to find and match your data to specific criteria