Google Sheets function list

What it is

The Google Sheets function list is a single official page listing every function available in Google Sheets. Each row gives the type (such as Date, Lookup, Logical, Math, Statistical, Text, Filter or Database), the function name, its syntax and a one-line description, with a "Learn more" link to a detailed help article with examples.

Why it matters for analysts

Google Sheets is free with a Google account and is used widely in startups, NGOs, schools and small businesses, so many analysts start there. It supports the functions you need for real analysis:

• Lookups: XLOOKUP, VLOOKUP, INDEX and MATCH.
• Conditional aggregation: SUMIFS, COUNTIFS, AVERAGEIFS.
• Filtering and reshaping: FILTER, UNIQUE, SORT and ARRAYFORMULA.
• QUERY, which runs a SQL-like query over a range. It is a helpful bridge to SQL, though its syntax is not standard SQL.
• Text and date cleaning: TRIM, SPLIT, REGEXEXTRACT, DATEVALUE, EOMONTH.

Pivot tables are not functions; they live in the Insert menu, and the help centre covers them separately.

How to use it

• Search the page (Ctrl+F) for a function when you see it in a tutorial, then open its help article for examples.
• Build small test sheets where you know the answer before using a function on real data.
• Where Excel and Sheets differ, such as QUERY or REGEX functions existing only in Sheets, note it; if your target employer uses Excel, practise the Excel equivalent too.

Is it worth your time?

Yes, as a reference. It is not a course: learn the concepts from a structured source, then use this page daily.

Free vs paid

Google Sheets and this reference are free with a personal Google account. Paid Google Workspace plans add administration and storage, not new functions you need for learning.

Common questions

Is Google Sheets "real" analysis? Yes, for data up to its size limits. Beyond that, move to SQL, a BI tool or Python.

Will Sheets skills transfer to Excel? Mostly. The core functions share names and logic.