Book a Demo

An Intermediate Guide to Functions in Google Sheets.

Learn about more functions and how to combine them in more complex ways.

Duration 60 minutes
Level Intermediate
Completion Certificate + Badge

Course Overview

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.

Skills Gained

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

What You’ll Learn

• Date‑Based Functions – Use DATEDIF, WORKDAY, NETWORKDAYS and TODAY to plan schedules, deadlines and project timelines.
• AI() Function – Automate tasks such as summarising text, generating content, and categorising data directly inside Sheets.
• Conditional Logic – Apply COUNTIF, SUMIF, AVERAGEIF and IFS to analyse data with precision.
• Combining Functions – Build compound functions that allow multiple actions within a single formula.
• ARRAYFORMULA Techniques – Format entire columns and automate repetitive data transformations.
• Practical Use Cases – Apply your new skills to real scenarios like scheduling, reporting and automated data processing.

Who Is This For?

This course is perfect for people who:

✓already know the basics and want to advance their formula skills
✓ are working with data who need conditional and automated solutions
✓ are looking to combine functions for more efficient workflows

Prerequisites

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

Upon Completion

Digital Badge

Shareable credential for LinkedIn and professional profiles

Certificate of Completion

Official certificate to showcase your achievement

£60.00

Buy multiple seats
Scroll to Top