This session builds on your foundational Google Sheets knowledge and introduces you to a wider range of functions used for smarter, more efficient data handling. You’ll explore new date functions, logical functions, and dynamic formulas, while also learning how to combine functions into powerful compound expressions.

Alongside this, you’ll get hands-on experience with the new AI() function, which enables automated text generation, summaries, categorisation and more directly within cells. You’ll also expand your use of ARRAYFORMULA to format, structure and process entire columns of data at once.

By the end of this session, you’ll be able to plan dates, analyse data conditionally, automate formatting, and combine functions to streamline your workflows.

Intermediate Date Functions AI() Function Usage Conditional Logic Functions Compound Function Building ARRAYFORMULA for Formatting Applied Data Automation

This course is perfect for people who:

Basic familiarity with Google Sheets functions. You should understand simple formulas before attending this intermediate session.