Shared spreadsheets, formulas and data
Budgets, trackers and reports: formulas, sorting, filtering and sharing, built for teams working in the same sheet.
30 lessons6 modules about 3 hours Everyone Certificate
30 hands-on lessons
Earn your Google Sheets certificate
Finish all 30 lessons, then pass the 20-question final exam (80% to pass). Your certificate has a public link anyone can verify.
Cells, your first formulas, formatting, shortcuts and sharing.
Cell addresses, simple math formulas and where your work is saved.
SUM, rounding averages, SUMIF and COUNTIF on a real event budget.
The everyday functions, and why COUNT and COUNTA give different answers.
Copy formulas without breaking them: when to lock a reference with $.
Currency, percentages, bold headers and banded rows, and why formatting never changes a value.
Jump to the end of your data, select whole rows, fill down and paste values.
Invite people with the right role, control link access and download copies.
IF, IFS, AND/OR, conditional counts and sums, and rounding.
Show one result or another depending on a test, and nest IFs for three outcomes.
Several conditions at once: grade bands with IFS and combined tests with AND and OR.
COUNTIF, SUMIF and AVERAGEIF with text, number and wildcard conditions.
Count, sum, average and find the maximum where several conditions are all true.
ROUND, ROUNDUP, ROUNDDOWN and INT, and why rounding beats hiding decimals.
VLOOKUP, error handling and cleaning up messy text.
Find a price or stock level by its code, and look up discount tiers.
Understand the common error codes and replace them with friendly results.
Fix stray spaces, inconsistent capitals and messy separators in imported data.
Pull pieces out of codes with LEFT, RIGHT and MID, and build labels with & and TEXTJOIN.
Freeze, filter, sort, highlight and validate.
Freeze headers, filter, sort and clean up duplicates in a few clicks.
Color cells and whole rows automatically with rules, color scales and custom formulas.
Keep data consistent with dropdown chips, checkboxes and validation rules.
Flexible lookups, dynamic arrays, QUERY, imports and dates.
Look up in any direction, handle missing values and build robust two-step lookups.
Dynamic formulas that return whole lists and update by themselves.
Filter, group and sort with a single SQL-style formula.
One formula that calculates every row, and multiply-then-add in a single step.
Pull live data from other spreadsheets and from Google Finance.
How Sheets stores dates, today's date shortcuts and the key date functions.
Pivot tables, charts, protection, version history and tables.
Summarize thousands of rows by region, rep or month in a few clicks.
Pick the right chart, use the chart editor and keep charts linked in Docs and Slides.
Readable formulas with named ranges, and protection against accidental edits.
Roll back mistakes, label milestones and get told when things change.
Structured tables, collapsible row groups, quick column statistics and recorded macros.
30 hands-on lessons
Earn your Google Sheets certificate
Finish all 30 lessons, then pass the 20-question final exam (80% to pass). Your certificate has a public link anyone can verify.
Cells, your first formulas, formatting, shortcuts and sharing.
Cell addresses, simple math formulas and where your work is saved.
SUM, rounding averages, SUMIF and COUNTIF on a real event budget.
The everyday functions, and why COUNT and COUNTA give different answers.
Copy formulas without breaking them: when to lock a reference with $.
Currency, percentages, bold headers and banded rows, and why formatting never changes a value.
Jump to the end of your data, select whole rows, fill down and paste values.
Invite people with the right role, control link access and download copies.
IF, IFS, AND/OR, conditional counts and sums, and rounding.
Show one result or another depending on a test, and nest IFs for three outcomes.
Several conditions at once: grade bands with IFS and combined tests with AND and OR.
COUNTIF, SUMIF and AVERAGEIF with text, number and wildcard conditions.
Count, sum, average and find the maximum where several conditions are all true.
ROUND, ROUNDUP, ROUNDDOWN and INT, and why rounding beats hiding decimals.
VLOOKUP, error handling and cleaning up messy text.
Find a price or stock level by its code, and look up discount tiers.
Understand the common error codes and replace them with friendly results.
Fix stray spaces, inconsistent capitals and messy separators in imported data.
Pull pieces out of codes with LEFT, RIGHT and MID, and build labels with & and TEXTJOIN.
Freeze, filter, sort, highlight and validate.
Freeze headers, filter, sort and clean up duplicates in a few clicks.
Color cells and whole rows automatically with rules, color scales and custom formulas.
Keep data consistent with dropdown chips, checkboxes and validation rules.
Flexible lookups, dynamic arrays, QUERY, imports and dates.
Look up in any direction, handle missing values and build robust two-step lookups.
Dynamic formulas that return whole lists and update by themselves.
Filter, group and sort with a single SQL-style formula.
One formula that calculates every row, and multiply-then-add in a single step.
Pull live data from other spreadsheets and from Google Finance.
How Sheets stores dates, today's date shortcuts and the key date functions.
Pivot tables, charts, protection, version history and tables.
Summarize thousands of rows by region, rep or month in a few clicks.
Pick the right chart, use the chart editor and keep charts linked in Docs and Slides.
Readable formulas with named ranges, and protection against accidental edits.
Roll back mistakes, label milestones and get told when things change.
Structured tables, collapsible row groups, quick column statistics and recorded macros.
Unlock every lesson, exam and certificate
The Basics module is free. Pro unlocks the intermediate and advanced lessons, from $3.33/month.