DiscoveryVIPReturn to the academyAll guides

Help & getting started

Find the next action, inspect a function, or look up a term. The guides remain readable without JavaScript.

Try Copy Formula, XLOOKUP, or relative reference.

About the academy

The academy is a browser spreadsheet workshop for learning formulas, inspecting calculations, cleaning data, creating charts, and practicing automation. It is designed for beginners, analysts, educators, office professionals, and developers. Core practice needs no Google account or AI subscription. Sample data is fictional.

Getting Started

On Start Here select Your First Spreadsheet Formula. Confirm the prepared data load. Follow the presenter panel one step at a time. Follow the Learning Path opens the first lesson. Open the Spreadsheet Lab resumes the current workbook. The five navigation destinations retain your working data. One Workspace Guide explains the controls in each active area.

What you can accomplish

Practice prices, discounts, sales summaries, matching records, attendance, grades, budgets, expenses, inventory, data cleaning, charts, and reports. Automation practice reads and writes simulated ranges, prepares local document and email-draft artifacts, and exports installation source for your own Google environment.

Understand Your First Formula

Select D2. In Cell input enter =B2*C2 and predict 15. Choose Apply Input, then Recalculate. Select Inspect Formula and check the highlighted B2 and C2 values. Select B2, enter 5, and choose Apply Input. D2 becomes 25. Select D2, expand Advanced spreadsheet actions, set Copy destination to D3:D4, and choose Copy Formula. D3 becomes 8 and D4 becomes 12. Select D5 and apply =SUM(D2:D4), which gives 45. Name the workbook and choose Save Workbook. Open Projects to restore it later.

Complete spreadsheet user guide

Click a cell to select it. Use arrow keys or Tab to move the active cell. Enter or Escape focuses Cell input. Type a value or a formula and choose Apply Input to commit. A formula starts with =. Cell or range accepts A1 addresses or a top-left to bottom-right rectangle. Shift-click extends a selection. The source formula remains visible in Cell input while the grid displays its result. Recalculate rebuilds dependencies. Sheet switches tabs. Advanced actions contain formula copying, local range copying and pasting, Redo, adding a sheet, and visible row/column bounds.

Button and toolbar reference

Load Example replaces the working workbook with the first activity after confirmation. Recalculate evaluates current formulas. Inspect Formula opens the selected expression’s trace. Undo restores the last committed workbook edit. Export CSV downloads displayed values in the current visible area. Copy Formula shifts relative references from the active cell into Copy destination. Copy Range stores raw cells and an anchor locally. Paste Range applies that local copy, shifting formulas. Redo reapplies an undone edit. Add Sheet creates a distinct empty tab. Update View changes visible rows and columns. Save Workbook creates a named local snapshot. Export JSON preserves the working workbook, snapshots, progress, and workflow. The single Workspace Guide lists actual fields, button purposes, example inputs, and expected outcomes for the current screen.

Formula Inspector guide

Select a formula result and choose Inspect Formula. Referenced values lists the cells consumed by the parsed expression. The dependency map shows its input addresses. Actual evaluation steps records operations completed by the evaluator, including intermediate arrays. Previous Calculation and Next Calculation move through that trace. Parsed expression shows the abstract syntax tree. A literal input has no formula operations. A parse error has an explanation rather than an invented trace. Referenced cells on the active sheet receive a blue highlight.

Cell references and copying

A1 is relative, $A$1 anchors both axes, $A1 fixes the column, and A$1 fixes the row. Copy Formula shifts every unanchored axis by the destination displacement. String literals are preserved. Rates!$B$2 reads a fixed assumption in another tab. Copying outside A1:Z100 is rejected before applying the change. Keep one source of truth for a shared assumption.

Formula Builder guide

In Spreadsheet Lab choose Visual formula builder. Choose a function to see purpose-based arguments. Edit each argument expression, then choose Generate Formula. Calculate Formula evaluates the editor against the current workbook. Load Builder Example prepares a matching dataset after confirmation. Transfer Formula writes the expression into the selected active cell. Review that selection to avoid overwriting a source input.

Function reference

The 51 functions listed below are executable in the documented local subset. Choose Function argument inspector in the lab, select a function, load its example, and use Test Function. Edit one argument and compare the result. Transfer to Active Cell writes the exact formula into the grid. Unsupported names produce #NAME? and remain outside local execution. The official Google Sheets function list describes additional platform features.

Logical decision lab

Choose Logical decision tree. Set Score to 50, Threshold to 50, and Attendance to 8. Evaluate Logic returns Pass. Score 49 returns Review. The displayed Boolean conditions are calculated from the current values. Change one input, predict the branch, and inspect why AND requires both conditions.

Lookup and matching guide

Choose Lookup visualizer and one of 25 investigations. Read the prepared table, enter Search value, and choose XLOOKUP, VLOOKUP exact, or INDEX/MATCH exact. Run Lookup computes the formula and lists every matching source row. A missing key returns the chosen fallback. A duplicate returns the first exact match locally, so inspect whether the key is genuinely unique. The function explorer also demonstrates ascending numeric approximate matching.

Data Cleaning guide

Choose Data cleaning workbench. Paste fictional CSV, choose a capitalization rule, optionally convert plain decimal text, and decide whether exact duplicate rows should be removed. Clean Data creates a before-and-after comparison and lists missing fields and duplicates. A literal filter keeps matching rows. Split first field uses the exact delimiter. Combine first two fields changes the schema. Download Cleaned CSV exports the transformed copy. Retain the original data for review.

Chart Builder guide

Choose Chart builder, load the sales example, and set Chart range to A2:B6. Build Chart plots the actual computed values with an accessible table. Column and bar charts compare categories. A line uses the given row order. Pie requires nonnegative values and a positive total. Scatter also needs an aligned numeric x-range, such as D2:D6 for units while the main range supplies sales as y-values. Label filter restricts the selected records. Verify the data table before interpreting the visual.

AI Formula Assistant guide

Choose AI formula prompt generator. Describe the task, sheet and columns, conditions, expected results, and error behavior. Generate AI Prompt creates editable instructions locally. Copy AI Prompt copies your exact text for an assistant you are approved to use. The sample response is authored practice content. Paste a returned formula into Formula to test and choose Test Suggested Formula. Verify changed inputs, boundaries, types, and references. Remove private data before sharing a schema.

Apps Script guide

Open Automation and choose Apps Script range explorer. Load a script pattern. Read its objective and code, then Run Script. It executes JavaScript in a disposable isolated worker with simulated SpreadsheetApp services. Inspect the call trace, logs, menus, formatting metadata, and before/after workbook copy. Apply Simulated Changes writes a successful copy into the working workbook. Stop Script ends the current run. Download Script exports a runnable Code.gs entry point, the original EDITOR.js, and setup instructions in a ZIP. The real setup guide describes installation and Google authorization.

Automation Workflow guide

In Automation choose Automation workflow simulator. Load Workflow Dataset. Keep Read data before validation, filtering, transformation, and calculation. Add Stage appends a supported action. Move Up, Move Down, and Remove Stage change the order. Run Workflow produces an actual trace, local artifacts, issues, and a before/after copy. Status updates require calculated totals, an earlier Request approval stage, and the reviewer flag. Download Apps Script exports Code.gs, a manifest, setup instructions, and CSV. The real code may create documents and Gmail drafts after installation and authorization. It does not send messages.

Formula versus script decisions

Choose the decision assistant. Select external artifacts, grouped summaries, custom calculations, cleaning stages, or AI drafting support. Compare Approaches explains why a formula, multiple formulas, pivot table, custom function, Apps Script, or combined approach fits. Built-in formulas recalculate with input changes. A script writes snapshots until it runs again. Real external services require permissions and a deliberate review route. Pivot tables are taught as a Google Sheets workflow with a local SUMIFS alternative.

Learning, challenges, and projects

Learn contains fifteen modules of five lessons. Predict before revealing a result, inspect the trace, test an edited formula, record an explanation, and transfer the skill. Test Practice Formula and project challenges compare calculated outputs on original, changed, and boundary fixtures. Multiple formulas can pass. Finite tests do not establish correctness for all inputs. Projects contains 25 source datasets, completed formulas, checks, milestones, downloadable artifacts, and 150 challenges. Load Project Starter clears solution cells. Load Completed Project supplies the worked formulas. Verify Working Project checks the current workbook.

Teaching and demonstration mode

Start Here lists ten prepared demonstrations. Start Demonstration loads the dataset and presenter instructions. Previous Step and Next Step change narration and highlighted targets. Hide Presenter keeps a resume button. Reset Demo reloads the prepared source after confirmation. Download Demo Script exports the numbered narration. Print Worksheet uses the browser print dialog. In a lesson, Present This Lesson opens the lesson’s objective and exercise in presentation mode. Ask learners to explain and test a new input before showing the answer.

Saving and exporting

Working data saves locally in IndexedDB when available. Save Workbook creates a separate named snapshot. In Projects, select a Saved workbook and Restore Workbook after confirmation. Export JSON or Export JSON Backup includes the current workbook, snapshots, progress, and workflow. Import JSON backup validates a version 1 file under 10 MB and asks before replacing state. CSV contains a rectangular text representation and loses workbook structure and features. No XLSX export is provided. A project ZIP includes source rows, completed workbook JSON, formulas, requirements, and applicable Apps Script source.

Using examples in Google Sheets

Create a test spreadsheet and import the source CSV into a Data tab. Add a Rates tab when formulas reference it and put the specified rate in B2. Enter formulas in the named cells. Inspect separators and locale settings if your Google sheet uses different syntax. Matrix results can spill in Google Sheets, unlike the single-anchor local display. Install Apps Script through Extensions → Apps Script, read the source and setup file, then run a small fictional test and review requested access.

Supported formulas and differences

The local workbook supports up to ten sheets and A1:Z100. Formula strings use comma argument separators, decimal points, quoted text, A1 references, arithmetic, powers, percent, concatenation, and comparisons. Formulas are parsed as data. Matrix arithmetic supports equal-shaped arrays or scalar broadcasting. Array functions return matrices at one anchor and do not create spill cells. Dates use UTC day serials; TODAY uses current UTC on live recalculation and frozen assessment dates in repeatable grading. Numeric-looking text stays text for arithmetic until VALUE converts it. Aggregations ignore text values. Empty cells act as zero in scalar arithmetic. Criteria support exact values and comparison strings, with case-insensitive exact text. Wildcards, named ranges, whole-column ranges, formatting-dependent parsing, locale-specific separators, imports, network functions, and iterative circular calculations are outside this subset.

Function-specific restrictions

SPLIT accepts two arguments and treats the delimiter as one literal string, removing empty pieces. SEARCH is a literal case-insensitive substring search without wildcard semantics. LEN counts JavaScript string code units. FILTER applies Boolean conditions row-by-row. SORT supports one column and direction. UNIQUE compares full rows using stored values. XLOOKUP supports exact forward search and an optional missing value, with optional mode 0 and search direction 1 only. MATCH supports exact 0 or ascending numeric approximate 1. VLOOKUP approximate mode requires sorted numeric keys, checked locally. INDEX uses positive row and column indices and returns one scalar. ROUND family supports integer precision -10 through 10. VALUE accepts plain decimal numeric text only. Custom functions and services have separate Apps Script restrictions.

Simulation boundaries

The worker services support selecting sheets, A1 or numeric getRange, getValue/getValues, setValue/setValues, appendRow, selected formatting metadata, and menu definitions. Reads support literal values; a formula cell read raises an explicit simulation error rather than silently returning a guessed value. Use the grid engine for formula evaluation. Worker runs end after three seconds. The opaque frame blocks network connections. Triggers are explained and exported for real Google installation; none are installed locally. Documents and email drafts in a local workflow are JSON artifacts. Formatting is recorded as metadata rather than reproducing the full Google UI.

Common errors and recovery

A #REF! identifies an invalid local address or index. #DIV/0! identifies a zero divisor or an average without numeric observations. #VALUE! identifies a type, shape, or argument problem. #N/A identifies an absent match or invalid argument count. #NAME? identifies an unknown function or name. #CYCLE! explains a circular dependency. #ERROR! identifies unsupported or incomplete syntax. Inspect the formula and its source types. Fix the cause before adding a broad IFERROR that could hide it.

Troubleshooting

If a formula result is unexpected, check the active sheet, address, raw input, type, range endpoints, and copied anchors. Apply Input commits the edit. If Copy Formula fails, check that the shifted references stay inside A1:Z100. If no chart appears, use two columns with numeric y-values and an aligned x-range for scatter. If a script fails, inspect its trace, range dimensions, and literal-read restriction. If browser saving fails, export JSON. If the app does not initialize after FTP upload, confirm that assets and data uploaded and .mjs files are served with a JavaScript MIME type.

Frequently asked questions

Where is the finished formula? Inspect Cell input or the completed project formulas. Where is the finished script? Download Script exports the editor, while Download Apps Script exports the workflow implementation and setup package. Do I need to edit code? Start with a prepared example, run it unchanged, then change one rule when the exercise asks. Do I need Google authorization? Only for code you install and run in your Google environment. Did the local workflow send a message? It prepared fictional local draft artifacts. Is this full Google Sheets compatibility? The documented subset explains supported behaviors and differences.

Privacy and data handling

Use fictional records and permitted schemas. Local browser data and downloaded backups can include anything you type. Review files before sharing them. Google services are not contacted by the core lab. The optional AI instruction generator produces text for manual use elsewhere. Real exported scripts can access services only after installation and the relevant Google permission process.

SUM

Add numeric values and range contents.

SUM(value, ...)
value
A scalar or supported range. Inspect its stored type.
...
Additional supported values or criterion pairs as appropriate.

Working example

=SUM(D2:D4)

Expected — 35

Return — A scalar 35

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — ROUND, IFERROR, ROUNDUP

Open the executable function explorer

AVERAGE

Compute the arithmetic mean of numeric values.

AVERAGE(value, ...)
value
A scalar or supported range. Inspect its stored type.
...
Additional supported values or criterion pairs as appropriate.

Working example

=AVERAGE(B2:B6)

Expected — 100

Return — A scalar 100

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — MIN, MAX, ABS

Open the executable function explorer

MIN

Find the smallest numeric observation.

MIN(value, ...)
value
A scalar or supported range. Inspect its stored type.
...
Additional supported values or criterion pairs as appropriate.

Working example

=MIN(B2:B6)

Expected — 0

Return — A scalar 0

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — AVERAGE, MAX, ABS

Open the executable function explorer

MAX

Find the largest numeric observation.

MAX(value, ...)
value
A scalar or supported range. Inspect its stored type.
...
Additional supported values or criterion pairs as appropriate.

Working example

=MAX(B2:B6)

Expected — 200

Return — A scalar 200

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — AVERAGE, MIN, ABS

Open the executable function explorer

COUNT

Count numeric values while excluding text and blanks.

COUNT(value, ...)
value
A scalar or supported range. Inspect its stored type.
...
Additional supported values or criterion pairs as appropriate.

Working example

=COUNT(D2:D5)

Expected — 0

Return — A scalar 0

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNTA, LEFT, RIGHT

Open the executable function explorer

COUNTA

Count nonempty values including text.

COUNTA(value, ...)
value
A scalar or supported range. Inspect its stored type.
...
Additional supported values or criterion pairs as appropriate.

Working example

=COUNTA(A2:A5)

Expected — 4

Return — A scalar 4

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, LEFT, RIGHT

Open the executable function explorer

ROUND

Round a number to the chosen decimal precision.

ROUND(value, places)
value
A scalar or supported range. Inspect its stored type.
places
An integer precision from -10 to 10 locally.

Working example

=ROUND(5/3,2)

Expected — 1.67

Return — A scalar 1.67

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — SUM, IFERROR, ROUNDUP

Open the executable function explorer

ABS

Return a nonnegative magnitude.

ABS(value)
value
A scalar or supported range. Inspect its stored type.

Working example

=ABS(B2-B3)

Expected — 100

Return — A scalar 100

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — AVERAGE, MIN, MAX

Open the executable function explorer

IF

Choose a result using a testable condition.

IF(condition, true_result, false_result)
condition
A Boolean test such as B2>=50.
true_result
The value to return when the condition holds.
false_result
The alternative branch when the test does not hold.

Working example

=IF(B2>=50,"Pass","Review")

Expected — "Pass"

Return — A scalar Pass

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — AND, OR, NOT

Open the executable function explorer

AND

Require every supplied condition to hold.

AND(condition, ...)
condition
A Boolean test such as B2>=50.
...
Additional supported values or criterion pairs as appropriate.

Working example

=AND(B2>=50,C2>=8)

Expected — true

Return — A scalar true

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — IF, OR, NOT

Open the executable function explorer

OR

Allow any supplied condition to hold.

OR(condition, ...)
condition
A Boolean test such as B2>=50.
...
Additional supported values or criterion pairs as appropriate.

Working example

=OR(B2>=90,C2=D2)

Expected — false

Return — A scalar false

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — IF, AND, NOT

Open the executable function explorer

NOT

Reverse a Boolean condition.

NOT(condition)
condition
A Boolean test such as B2>=50.

Working example

=NOT(B2>=50)

Expected — false

Return — A scalar false

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — IF, AND, OR

Open the executable function explorer

IFERROR

Provide an explicit fallback when evaluation fails.

IFERROR(value, fallback)
value
A scalar or supported range. Inspect its stored type.
fallback
A result that communicates an expected error or missing input.

Working example

=IFERROR(1/0,"Check divisor")

Expected — "Check divisor"

Return — A scalar Check divisor

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — SUM, ROUND, ROUNDUP

Open the executable function explorer

SUMIF

Sum aligned amounts for one matching condition.

SUMIF(test_range, criterion, sum_range)
test_range
The aligned cells whose values are compared with a criterion.
criterion
An exact value or comparison such as ">=50". Wildcards are unsupported locally.
sum_range
Numeric cells aligned with the test range.

Working example

=SUMIF(A2:A6,"Red",B2:B6)

Expected — 250

Return — A scalar 250

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — AVERAGE, MIN, MAX

Open the executable function explorer

COUNTIF

Count records matching one condition.

COUNTIF(test_range, criterion)
test_range
The aligned cells whose values are compared with a criterion.
criterion
An exact value or comparison such as ">=50". Wildcards are unsupported locally.

Working example

=COUNTIF(A2:A6,"Red")

Expected — 2

Return — A scalar 2

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — AVERAGE, MIN, MAX

Open the executable function explorer

AVERAGEIF

Average matching numeric values.

AVERAGEIF(test_range, criterion, average_range)
test_range
The aligned cells whose values are compared with a criterion.
criterion
An exact value or comparison such as ">=50". Wildcards are unsupported locally.
average_range
Numeric values aligned with matching records.

Working example

=AVERAGEIF(A2:A6,"Red",B2:B6)

Expected — 125

Return — A scalar 125

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — AVERAGE, MIN, MAX

Open the executable function explorer

SUMIFS

Sum records satisfying all criterion pairs.

SUMIFS(sum_range, test_range, criterion, ...)
sum_range
Numeric cells aligned with the test range.
test_range
The aligned cells whose values are compared with a criterion.
criterion
An exact value or comparison such as ">=50". Wildcards are unsupported locally.
...
Additional supported values or criterion pairs as appropriate.

Working example

=SUMIFS(B2:B6,A2:A6,"Red",C2:C6,"West")

Expected — 150

Return — A scalar 150

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — AVERAGE, MIN, MAX

Open the executable function explorer

COUNTIFS

Count aligned rows satisfying every condition.

COUNTIFS(test_range, criterion, ...)
test_range
The aligned cells whose values are compared with a criterion.
criterion
An exact value or comparison such as ">=50". Wildcards are unsupported locally.
...
Additional supported values or criterion pairs as appropriate.

Working example

=COUNTIFS(C2:C6,"East",B2:B6,">=50")

Expected — 2

Return — A scalar 2

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — AVERAGE, MIN, MAX

Open the executable function explorer

LEFT

Take characters from the beginning.

LEFT(text, count)
text
A quoted string or a reference to text.
count
A nonnegative integer character count.

Working example

=LEFT(B2,2)

Expected — "NB"

Return — A scalar NB

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, RIGHT

Open the executable function explorer

RIGHT

Take characters from the end.

RIGHT(text, count)
text
A quoted string or a reference to text.
count
A nonnegative integer character count.

Working example

=RIGHT(B2,3)

Expected — "204"

Return — A scalar 204

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, LEFT

Open the executable function explorer

MID

Take a segment using a one-based position.

MID(text, start, count)
text
A quoted string or a reference to text.
start
A one-based integer character position.
count
A nonnegative integer character count.

Working example

=MID(B2,4,3)

Expected — "204"

Return — A scalar 204

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, LEFT

Open the executable function explorer

LEN

Count JavaScript string code units in the local model.

LEN(text)
text
A quoted string or a reference to text.

Working example

=LEN(B2)

Expected — 6

Return — A scalar 6

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, LEFT

Open the executable function explorer

TRIM

Trim edges and collapse repeated ordinary spaces.

TRIM(text)
text
A quoted string or a reference to text.

Working example

=TRIM(A2)

Expected — "ari lee"

Return — A scalar ari lee

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, LEFT

Open the executable function explorer

LOWER

Convert letters to lowercase.

LOWER(text)
text
A quoted string or a reference to text.

Working example

=LOWER(A3)

Expected — "bo ray"

Return — A scalar bo ray

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, LEFT

Open the executable function explorer

UPPER

Convert letters to uppercase.

UPPER(text)
text
A quoted string or a reference to text.

Working example

=UPPER(TRIM(A2))

Expected — "ARI LEE"

Return — A scalar ARI LEE

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, LEFT

Open the executable function explorer

CONCATENATE

Combine text without an automatic separator.

CONCATENATE(value, ...)
value
A scalar or supported range. Inspect its stored type.
...
Additional supported values or criterion pairs as appropriate.

Working example

=CONCATENATE(LEFT(B2,2)," item")

Expected — "NB item"

Return — A scalar NB item

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, LEFT

Open the executable function explorer

TEXTJOIN

Combine values with an explicit separator.

TEXTJOIN(delimiter, ignore_empty, value, ...)
delimiter
Literal text separating the pieces.
ignore_empty
TRUE skips empty values.
value
A scalar or supported range. Inspect its stored type.
...
Additional supported values or criterion pairs as appropriate.

Working example

=TEXTJOIN(" / ",TRUE,A3,B3)

Expected — "BO RAY / PN-105"

Return — A scalar BO RAY / PN-105

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, LEFT

Open the executable function explorer

SPLIT

Split text into a local matrix using a literal delimiter.

SPLIT(text, delimiter)
text
A quoted string or a reference to text.
delimiter
Literal text separating the pieces.

Working example

=SPLIT("Red,Blue",",")

Expected — [["Red","Blue"]]

Return — A matrix result retained at its anchor

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, LEFT

Open the executable function explorer

FIND

Find a case-sensitive substring and return its one-based position.

FIND(search_text, text, start)
search_text
A literal substring to locate.
text
A quoted string or a reference to text.
start
A one-based integer character position.

Working example

=FIND("-",B2)

Expected — 3

Return — A scalar 3

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, LEFT

Open the executable function explorer

SUBSTITUTE

Replace exact text, optionally at one occurrence.

SUBSTITUTE(text, old, replacement, occurrence)
text
A quoted string or a reference to text.
old
The exact substring to replace.
replacement
Text to insert in its place.
occurrence
Optional positive occurrence number.

Working example

=SUBSTITUTE(B2,"-","/")

Expected — "NB/204"

Return — A scalar NB/204

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, LEFT

Open the executable function explorer

INDEX

Read a value at a one-based location.

INDEX(range, row, column)
range
A bounded A1 rectangle such as A2:C6.
row
A one-based row index within the supplied range.
column
A one-based column index within the supplied range.

Working example

=INDEX(B2:C5,2,1)

Expected — 2

Return — A scalar 2

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — MATCH, VLOOKUP, XLOOKUP

Open the executable function explorer

MATCH

Find the position of a key using exact or ascending approximate mode.

MATCH(key, range, mode)
key
The value to find.
range
A bounded A1 rectangle such as A2:C6.
mode
0 selects exact matching. 1 selects ascending approximate matching.

Working example

=MATCH("PN",A2:A5,0)

Expected — 2

Return — A scalar 2

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — INDEX, VLOOKUP, XLOOKUP

Open the executable function explorer

VLOOKUP

Search the first table column and return an aligned field.

VLOOKUP(key, table, column, approximate)
key
The value to find.
table
A rectangle with search keys in its first column.
column
A one-based column index within the supplied range.
approximate
FALSE selects exact matching. TRUE requires ascending numeric keys.

Working example

=VLOOKUP("FL",A2:D5,2,FALSE)

Expected — 6

Return — A scalar 6

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — INDEX, MATCH, XLOOKUP

Open the executable function explorer

XLOOKUP

Find an exact forward match in aligned ranges.

XLOOKUP(key, lookup_range, result_range, missing)
key
The value to find.
lookup_range
The keys to inspect.
result_range
Return values aligned with the key range.
missing
A chosen fallback for an absent exact match.

Working example

=XLOOKUP("PN",A2:A5,B2:B5,"Missing")

Expected — 2

Return — A scalar 2

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — INDEX, MATCH, VLOOKUP

Open the executable function explorer

FILTER

Return rows satisfying aligned Boolean conditions.

FILTER(range, condition, ...)
range
A bounded A1 rectangle such as A2:C6.
condition
A Boolean test such as B2>=50.
...
Additional supported values or criterion pairs as appropriate.

Working example

=FILTER(A2:C6,B2:B6>=100)

Expected — [["Red",100,"East"],["Blue",200,"West"],["Red",150,"West"]]

Return — A matrix result retained at its anchor

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — AVERAGE, MIN, MAX

Open the executable function explorer

SORT

Return rows ordered by one column.

SORT(range, column, ascending)
range
A bounded A1 rectangle such as A2:C6.
column
A one-based column index within the supplied range.
ascending
TRUE orders lower values first. FALSE reverses the order.

Working example

=SORT(A2:B6,2,FALSE)

Expected — [["Blue",200],["Red",150],["Red",100],["Blue",50],["Green",0]]

Return — A matrix result retained at its anchor

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — AVERAGE, MIN, MAX

Open the executable function explorer

UNIQUE

Return distinct rows preserving first occurrence.

UNIQUE(range)
range
A bounded A1 rectangle such as A2:C6.

Working example

=UNIQUE(A2:A6)

Expected — [["Red"],["Blue"],["Green"]]

Return — A matrix result retained at its anchor

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — AVERAGE, MIN, MAX

Open the executable function explorer

DATE

Construct a UTC date serial.

DATE(year, month, day)
year
Calendar year. Values 0–1899 are offset by 1900 locally.
month
One-based month. Overflow is normalized.
day
One-based day. Overflow is normalized.

Working example

=DATE(2026,11,20)

Expected — 46346

Return — A scalar 46346

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — YEAR, MONTH, DAY

Open the executable function explorer

YEAR

Read the calendar year of a date serial.

YEAR(serial)
serial
A supported numeric date serial.

Working example

=YEAR(B2)

Expected — 2026

Return — A scalar 2026

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — DATE, MONTH, DAY

Open the executable function explorer

MONTH

Read the month number of a date serial.

MONTH(serial)
serial
A supported numeric date serial.

Working example

=MONTH(B2)

Expected — 11

Return — A scalar 11

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — DATE, YEAR, DAY

Open the executable function explorer

DAY

Read the day of month of a date serial.

DAY(serial)
serial
A supported numeric date serial.

Working example

=DAY(B2)

Expected — 20

Return — A scalar 20

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — DATE, YEAR, MONTH

Open the executable function explorer

TODAY

Return the current UTC date serial at recalculation.

TODAY()

Working example

=TODAY()

Expected — 46343

Return — A current UTC date serial

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — DATE, YEAR, MONTH

Open the executable function explorer

MOD

Calculate a remainder with the divisor’s sign convention.

MOD(value, divisor)
value
A scalar or supported range. Inspect its stored type.
divisor
A nonzero number used to divide the value.

Working example

=MOD(B2,10)

Expected — 2

Return — A scalar 2

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — IF, AND, OR

Open the executable function explorer

ROUNDUP

Round away from zero at the selected precision.

ROUNDUP(value, places)
value
A scalar or supported range. Inspect its stored type.
places
An integer precision from -10 to 10 locally.

Working example

=ROUNDUP(5/3,2)

Expected — 1.67

Return — A scalar 1.67

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — SUM, ROUND, IFERROR

Open the executable function explorer

ROUNDDOWN

Round toward zero at the selected precision.

ROUNDDOWN(value, places)
value
A scalar or supported range. Inspect its stored type.
places
An integer precision from -10 to 10 locally.

Working example

=ROUNDDOWN(5/3,2)

Expected — 1.66

Return — A scalar 1.66

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — SUM, ROUND, IFERROR

Open the executable function explorer

COUNTBLANK

Count empty cells and empty-string values locally.

COUNTBLANK(range)
range
A bounded A1 rectangle such as A2:C6.

Working example

=COUNTBLANK(D2:D5)

Expected — 1

Return — A scalar 1

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, LEFT

Open the executable function explorer

MEDIAN

Find the middle numeric value after sorting.

MEDIAN(value, ...)
value
A scalar or supported range. Inspect its stored type.
...
Additional supported values or criterion pairs as appropriate.

Working example

=MEDIAN(B2:B6)

Expected — 100

Return — A scalar 100

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — AVERAGE, MIN, MAX

Open the executable function explorer

ISNUMBER

Test whether a value is stored as a number.

ISNUMBER(value)
value
A scalar or supported range. Inspect its stored type.

Working example

=ISNUMBER(D2)

Expected — false

Return — A scalar false

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, LEFT

Open the executable function explorer

ISTEXT

Test whether a value is stored as text.

ISTEXT(value)
value
A scalar or supported range. Inspect its stored type.

Working example

=ISTEXT(D2)

Expected — true

Return — A scalar true

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, LEFT

Open the executable function explorer

VALUE

Convert plain decimal text to a number locally.

VALUE(text)
text
A quoted string or a reference to text.

Working example

=VALUE(D2)

Expected — 24

Return — A scalar 24

Inspect #VALUE! for type or shape errors, #N/A for missing matches or wrong argument counts, and #REF! for invalid locations.

The local engine uses bounded A1 ranges, comma separators, strict numeric text handling, UTC date serials, and nonspilling matrix results. See the subset guide for function-specific restrictions.

Change one relevant source value or criterion. Predict the new output, then use Inspect Formula to explain the calculation.

Related — COUNT, COUNTA, LEFT

Open the executable function explorer

Workbook

A collection of sheets kept together.

Example — The local workbook contains Data and Rates.

Related lesson

Worksheet

A tab containing cells arranged in rows and columns.

Example — Rates holds the shared tax assumption.

Related lesson

Cell

One addressable input or calculation location.

Example — D2 holds a line-total formula.

Related lesson

Row

A horizontal group of cells sharing a row number.

Example — Row 2 holds the notebook record.

Related lesson

Column

A vertical group of cells sharing a letter.

Example — B contains quantities.

Related lesson

Cell address

The column and row identifying a cell.

Example — B2 means column B, row 2.

Related lesson

A1 notation

Reference syntax using letters for columns and numbers for rows.

Example — B2:C4 identifies a rectangle.

Related lesson

Range

A rectangular set of cells including its endpoints.

Example — B2:B4 contains three quantities.

Related lesson

Range endpoint

The first or last address defining a range.

Example — D4 is the last included cell in D2:D4.

Related lesson

Selection

The cell or range currently targeted by an action.

Example — Inspect Formula uses the selected cell.

Related lesson

Active cell

The anchor cell of the current selection.

Example — D2 is the starting cell for a copy.

Related lesson

Formula bar

An editor showing the selected cell’s raw input.

Example — The bar displays =B2*C2 while the cell displays 15.

Related lesson

Formula

An expression beginning with = that computes a value.

Example — =SUM(D2:D4) totals line amounts.

Related lesson

Raw input

The text or formula stored in the cell.

Example — The raw input is =B2*C2.

Related lesson

Displayed value

The evaluated value shown in the grid.

Example — The displayed result is 15.

Related lesson

Literal

A direct value in an expression.

Example — 5 and "Pass" are literals.

Related lesson

Numeric value

A stored number available for arithmetic.

Example — The quantity 3 is numeric.

Related lesson

Text value

A stored string, even when it looks numeric.

Example — An apostrophe preserves '24 as text.

Related lesson

Boolean

A true-or-false value.

Example — B2>=50 returns TRUE or FALSE.

Related lesson

Blank cell

A cell with no stored content.

Example — The first D2 starts blank.

Related lesson

Empty string

Text with zero characters.

Example — IF can return "" as a deliberately empty result.

Related lesson

Relative reference

A reference that shifts with the copy displacement.

Example — B2 becomes B3 when copied down one row.

Related lesson

Absolute reference

A reference with both axes anchored.

Example — $B$2 keeps the assumption fixed.

Related lesson

Mixed reference

A reference with one anchored axis.

Example — $B2 fixes the column while its row can move.

Related lesson

Dollar anchor

A $ marker fixing the following row or column during copying.

Example — C$2 keeps row 2.

Related lesson

Cross-sheet reference

A reference naming a different worksheet.

Example — Rates!B2 reads the rate tab.

Related lesson

Dependency

A cell whose value is needed by another calculation.

Example — D2 depends on B2 and C2.

Related lesson

Dependent cell

A cell that reads another cell’s result.

Example — D5 depends on D2:D4.

Related lesson

Dependency graph

A map of input-to-result relationships.

Example — The graph connects quantity and price to total.

Related lesson

Recalculation

Evaluating formulas again using current inputs.

Example — Changing quantity to 5 makes D2 equal 25.

Related lesson

Cache

A stored result reused within a computation pass.

Example — Repeated references to B2 use the same pass value.

Related lesson

Circular reference

A calculation that eventually depends on itself.

Example — D2 refers to E2 while E2 refers to D2.

Related lesson

Parser

Code that turns formula tokens into a structured expression.

Example — The parser recognizes SUM and its range argument.

Related lesson

Token

A meaningful piece of formula syntax.

Example — B2, *, and C2 are separate tokens.

Related lesson

Abstract syntax tree

A nested representation of an expression’s operations.

Example — The tree groups multiplication before addition.

Related lesson

Operator

A symbol performing an operation on operands.

Example — * multiplies quantity by price.

Related lesson

Operand

A value or expression used by an operator.

Example — B2 and C2 are multiplication operands.

Related lesson

Precedence

The rule deciding which operations bind first.

Example — Multiplication precedes addition.

Related lesson

Parentheses

Symbols that group an expression or enclose arguments.

Example — =(B2+C2)*2 changes the grouping.

Related lesson

Function

A named operation with arguments.

Example — SUM adds numeric inputs.

Related lesson

Argument

An input supplied to a function.

Example — D2:D4 is the argument of SUM.

Related lesson

Arity

The permitted number of function arguments.

Example — IFERROR needs two arguments.

Related lesson

Return value

The result produced by a function.

Example — COUNTIF returns a count.

Related lesson

Nested function

A function used inside another expression.

Example — SUM(FILTER(...)) totals selected values.

Related lesson

Short-circuit evaluation

Evaluating only the branch selected by a condition.

Example — IF(TRUE,1,1/0) returns 1 locally.

Related lesson

Comparison

An operation checking a relation between values.

Example — B2>=50 checks a boundary.

Related lesson

Criterion

A condition used to select records.

Example — ">=50" selects amounts at least 50.

Related lesson

Criteria range

The cells tested against a criterion.

Example — A2:A6 contains team names.

Related lesson

Sum range

The aligned numeric cells to total after testing.

Example — B2:B6 contains corresponding sales.

Related lesson

Aggregation

Combining observations into a summary.

Example — SUM creates a total from line amounts.

Related lesson

Sum

The result of adding numeric values.

Example — 15+8+12 equals 35.

Related lesson

Arithmetic mean

The sum divided by the numeric observation count.

Example — 500 divided by 5 equals 100.

Related lesson

Median

The middle numeric value after sorting.

Example — The median of 0,50,100,150,200 is 100.

Related lesson

Minimum

The smallest included numeric value.

Example — The minimum sales value is 0.

Related lesson

Maximum

The largest included numeric value.

Example — The maximum sales value is 200.

Related lesson

Count

The number of observations satisfying a counting rule.

Example — COUNT counts numbers while COUNTA counts nonempty values.

Related lesson

Denominator

The quantity used as the divisor in a ratio.

Example — Attendance divides attended sessions by offered sessions.

Related lesson

Ratio

One quantity compared by division with another.

Example — 8/10 is an attendance ratio of 0.8.

Related lesson

Percentage

A quantity expressed per hundred.

Example — 20% is 0.2.

Related lesson

Percentage change

A difference divided by its starting value.

Example — Moving from 20 to 25 is a 25% increase.

Related lesson

Percentage point

The direct difference between percentage values.

Example — 10% to 15% is five percentage points.

Related lesson

Discount

A reduction relative to an original price.

Example — 20% off 5 gives 4.

Related lesson

Markup

An increase expressed relative to cost.

Example — Cost 4 with 25% markup gives price 5.

Related lesson

Margin

A profit amount expressed relative to revenue.

Example — Profit 1 on price 5 gives a 20% margin.

Related lesson

Rounding

Representing a numeric value at a chosen precision.

Example — ROUND(5/3,2) gives 1.67.

Related lesson

Decimal precision

The number of decimal places retained.

Example — Two places are commonly used for displayed currency.

Related lesson

Floating-point number

A finite binary representation of many numeric values.

Example — Some decimal sums have small representation differences.

Related lesson

Tolerance

An allowed numeric difference in a test.

Example — The grader accepts small floating-point discrepancies.

Related lesson

Error value

A visible signal that a formula could not produce its intended result.

Example — #DIV/0! identifies zero division.

Related lesson

Division by zero

An undefined division with a zero denominator.

Example — =1/0 returns #DIV/0!.

Related lesson

Invalid reference

An address that does not identify a supported cell.

Example — A101 exceeds the local row bound.

Related lesson

Missing match

A lookup request with no corresponding key.

Example — A request for ZZ produces #N/A without a fallback.

Related lesson

Fallback

An explicit alternative for an expected failure.

Example — XLOOKUP can return "Missing".

Related lesson

Error propagation

An upstream failure affecting a dependent formula.

Example — A bad line total can prevent the invoice sum.

Related lesson

Lookup key

The value used to find a record.

Example — PN identifies the pen catalog row.

Related lesson

Lookup table

A table associating keys with returned attributes.

Example — SKU and price columns form a price lookup.

Related lesson

Exact match

A key comparison requiring equality under the engine’s text rules.

Example — FALSE requests exact VLOOKUP matching.

Related lesson

Approximate match

A lookup selecting an eligible boundary key.

Example — A score 72 matches the threshold 50 in an ascending table.

Related lesson

Duplicate key

A key occurring in multiple records.

Example — Two NB rows have different prices.

Related lesson

First-match policy

Returning the earliest eligible matching record.

Example — Local exact lookup selects the first NB row.

Related lesson

Index

A one-based position within a selected range for INDEX or MATCH.

Example — The second matched row has position 2.

Related lesson

Array

An ordered collection of values.

Example — A row result contains several values.

Related lesson

Matrix

A two-dimensional array with rows and columns.

Example — getValues returns a matrix.

Related lesson

Dynamic array

An array result whose shape depends on inputs.

Example — FILTER returns a variable number of rows.

Related lesson

Spill

Placing an array result into neighboring cells.

Example — The local academy displays matrices at one anchor instead.

Related lesson

Filter

Selecting records satisfying a rule.

Example — Keep only West-region sales.

Related lesson

Sort

Ordering complete records by a chosen field.

Example — Sort rows by sales descending.

Related lesson

Unique row

A row distinct under the selected columns.

Example — UNIQUE returns one row per first-seen team label.

Related lesson

Data type

The kind of value stored or produced.

Example — Text, number, and Boolean behave differently.

Related lesson

Type conversion

Changing a value into another supported type.

Example — VALUE("24") produces numeric 24.

Related lesson

Data cleaning

Preparing consistent values while preserving meaning.

Example — Trim spaces before comparing names.

Related lesson

Normalization

Applying a consistent representation rule.

Example — Lowercase cleaned keys before matching.

Related lesson

Delimiter

Text separating fields or pieces.

Example — A comma separates CSV fields.

Related lesson

Concatenation

Joining text values.

Example — A product code and label can be combined with &.

Related lesson

Substring

A contiguous part of a string.

Example — NB is the first two characters of NB-204.

Related lesson

One-based position

An index whose first item is numbered one.

Example — FIND returns 3 for the hyphen in NB-204.

Related lesson

Required field

An input that must be present for a record to be usable.

Example — A workflow needs a valid email-like destination.

Related lesson

Validation

Checking inputs against explicit requirements.

Example — A score must be numeric and between 0 and 100.

Related lesson

Boundary case

An input at or near a rule cutoff.

Example — Test the score 50 with >=50.

Related lesson

Date serial

A numeric day value relative to a defined epoch.

Example — DATE returns a local UTC serial.

Related lesson

Epoch

The starting point of a time representation.

Example — The academy date epoch is 1899-12-30.

Related lesson

UTC

A time reference used by the local date engine.

Example — TODAY reads the current UTC date.

Related lesson

Timezone

Rules relating local calendar time to a reference time.

Example — A real Google spreadsheet’s timezone may affect dates.

Related lesson

Chart series

The numeric values plotted together.

Example — Sales amounts form one series.

Related lesson

Category label

A name identifying a chart observation.

Example — A team name labels a column.

Related lesson

Scatterplot

A chart pairing numeric x and y values.

Example — Plot units against sales for each record.

Related lesson

Line chart

A chart connecting values in an ordered sequence.

Example — Use an ordered date series when the sequence matters.

Related lesson

Pivot table

A grouped interactive summary available in Google Sheets.

Example — Summarize sales by team and region.

Related lesson

CSV

A delimited text format for rows and fields.

Example — A CSV download retains values but not all workbook features.

Related lesson

TSV

Text fields separated by tabs.

Example — A pasted grid selection commonly uses TSV.

Related lesson

JSON

A structured text format for portable data.

Example — The academy backup stores versioned workbook data.

Related lesson

Schema

A description of the fields and structure expected in data.

Example — A workflow uses name, email, quantity, price, approval, and status.

Related lesson

Workbook snapshot

A named stored version of a workbook.

Example — Save the first completed experiment before further edits.

Related lesson

Undo

Restoring the previous workbook edit state.

Example — Undo reverses the last committed cell change.

Related lesson

Redo

Reapplying an edit reversed by Undo.

Example — Redo restores the changed quantity.

Related lesson

IndexedDB

A browser database for structured local data.

Example — The academy saves workbooks and progress locally.

Related lesson

JavaScript

The language used for the local engine and Apps Script examples.

Example — Array.map prepares a matrix of totals.

Related lesson

Variable

A named binding used by code.

Example — const sheet names the current simulated worksheet.

Related lesson

Array.map

A JavaScript operation creating one output per input element.

Example — Convert each quantity-price row into a one-cell total row.

Related lesson

Array.filter

A JavaScript operation keeping elements that pass a test.

Example — Keep only New records.

Related lesson

Array.reduce

A JavaScript operation combining elements into an accumulated result.

Example — Sum a batch of row totals.

Related lesson

Exception

A code-level error that interrupts normal processing.

Example — Invalid setValues dimensions throw an error.

Related lesson

Worker

A separate browser execution context.

Example — Practice code runs in a disposable isolated worker.

Related lesson

Timeout

A limit ending a run that takes too long.

Example — The runner stops a nonterminating loop after three seconds.

Related lesson

Apps Script

Google’s scripting environment for supported Workspace automation.

Example — A bound script can prepare a document from sheet rows.

Related lesson

SpreadsheetApp

The Apps Script service for spreadsheet operations.

Example — getActive returns the bound spreadsheet in an exported example.

Related lesson

getValue

A range method returning its top-left value.

Example — Read the quantity from B2.

Related lesson

getValues

A range method returning a matrix of values.

Example — Read B2:C4 in one call.

Related lesson

setValue

A range method writing one value into its cells.

Example — Write a numeric total into D2.

Related lesson

setValues

A range method writing an aligned matrix.

Example — Write three one-cell totals into D2:D4.

Related lesson

appendRow

A sheet method adding a record after the last used row.

Example — Append a batch summary row.

Related lesson

Batch processing

Handling multiple records with grouped reads and writes.

Example — Read a table, transform an array, then write once.

Related lesson

Custom function

A function called from a spreadsheet cell under platform restrictions.

Example — LINE_TOTAL(3,5) returns 15.

Related lesson

Custom menu

A menu defined by an Apps Script UI handler.

Example — An onOpen handler adds a review action.

Related lesson

Trigger

A configured event or schedule that starts a script handler.

Example — A time-based trigger prepares a daily report.

Related lesson

Authorization

A user permission process for service access.

Example — Running document creation may request Google account access.

Related lesson

OAuth scope

A description of a category of access requested by a script.

Example — A script’s services determine relevant permission requests.

Related lesson

Human approval

An explicit reviewer decision before a specified action.

Example — A simulated approval allows status updates.

Related lesson

Execution trace

A record of operations actually performed.

Example — The trace shows getValues followed by setValues.

Related lesson

Idempotency

A design property where repeating an action avoids unwanted duplicates.

Example — Check for an existing trigger before installing another.

Related lesson

AI prompt

Instructions and context given to an AI assistant.

Example — Describe the sheet schema and expected outputs.

Related lesson

Synthetic data

Invented records used for practice or testing.

Example — ari@example.test is a fictional example address.

Related lesson

Hallucination

Generated content that is inadequately grounded and may be wrong.

Example — An assistant invents a nonexistent formula function.

Related lesson

Privacy

Appropriate handling of information about people.

Example — Use fictional records when requesting formula help.

Related lesson

Test fixture

Fixed input data used to repeat an assessment.

Example — The discount example always starts with the same values.

Related lesson

Regression test

A check that previously correct behavior still works.

Example — Recheck reference copying after changing the parser.

Related lesson

Switch Theme

Change light or dark colors. The preference saves in this browser. Example: . The active workspace updates.

Start Here

Open Start Here while retaining the workbook. Example: Continue your current experiment.. The selected workspace opens.

Learn

Open Learn while retaining the workbook. Example: Continue your current experiment.. The selected workspace opens.

Spreadsheet Lab

Open Spreadsheet Lab while retaining the workbook. Example: Continue your current experiment.. The selected workspace opens.

Automation

Open Automation while retaining the workbook. Example: Continue your current experiment.. The selected workspace opens.

Projects

Open Projects while retaining the workbook. Example: Continue your current experiment.. The selected workspace opens.

Learning mode

Beginner keeps the grid small and explains the first calculation. Guided and Advanced expose more experiments without clearing the workbook. Example: Choose Beginner..

Learning object

Choose a practical experiment. The grid retains your workbook when you change areas. Use Load Prepared Example inside an object to change its dataset. Example: Formula execution visualizer..

Load Example

Replace the workbook with the three-product first-formula example after confirmation. Example: . The active workspace updates.

Recalculate

Evaluate all current formulas and rebuild dependencies using the current inputs. Example: . The active workspace updates.

Inspect Formula

Show parsed operations, referenced values, intermediate results, and errors for the active cell. Example: . The active workspace updates.

Undo

Restore the previous committed workbook edit. Example: . The active workspace updates.

Export CSV

Download displayed values from the current visible sheet area. CSV loses workbook structure, formulas, and formatting. Example: . The active workspace updates.

Sheet

Choose an existing sheet in this workbook. Example: Data.

Cell or range

Enter an A1 cell or top-left to bottom-right rectangle. Shift-click a cell to extend the selection. Example: D2:D4.

Active cell

The anchor cell edited by Cell input. Use Cell or range to change the selection. Example: D2.

Cell input

Enter a number, text, or a formula starting with =. Apply Input commits the edit and recalculates. Example: =B2*C2.

Apply Input

Store Cell input in the active cell, then recalculate dependencies. Example: Enter =B2*C2 in D2.. The active workspace updates.

Copy destination

Copy the active cell formula into this bounded range, shifting unanchored references. Example: D3:D4.

New sheet name

Add a sheet with a distinct alphanumeric name. Example: Forecast.

Visible rows

Choose how many rows to show, from 5 to 100. Example: 12.

Visible columns

Choose how many columns to show, from 4 to 26. Example: 8.

Copy Formula

Copy the active raw value or formula into Copy destination, shifting relative references. Example: D2 to D3:D4.. The active workspace updates.

Copy Range

Keep the selected raw cells and source location in the local clipboard. Also attempt a system clipboard copy. Example: . The active workspace updates.

Paste Range

Paste the local copied cells into the active anchor, shifting copied formulas. Example: . The active workspace updates.

Redo

Reapply an edit that Undo reversed. Example: . The active workspace updates.

Add Sheet

Create a distinct sheet with an empty cell map. Example: . The active workspace updates.

Update View

Change visible rows and columns within the documented bounds. Example: . The active workspace updates.

Workbook name

Name the current workbook snapshot. Saving creates a separate local snapshot. Example: First formula experiment.

Save Workbook

Store a named snapshot of the workbook in this browser. Open Projects to restore it. Example: . The active workspace updates.

Export JSON

Download the current workbook, snapshots, progress, and workflow as a versioned backup. Example: . The active workspace updates.

Function to build

Choose the function that matches the calculation task. Parameters appear below with their purposes. Example: SUMIF.

value

A scalar or supported range. Inspect its stored type. Example: D2:D4.

Generate Formula

Assemble the selected function and configured argument expressions. The result is evaluated by the parser. Example: . The active workspace updates.

Load Builder Example

Load this function’s prepared dataset after confirmation. Example: . The active workspace updates.

Generated formula

Review and edit the formula before testing or transferring it. Example: =SUM(D2:D4).

Calculate Formula

Compute the generated formula against the current workbook. Example: . The active workspace updates.

Transfer Formula

Write the generated formula into the active spreadsheet cell. Example: . The active workspace updates.

Function

Choose a locally executable function and inspect its syntax, arguments, limitations, and expected result. Example: SUM.

Load Function Example

Load the prepared dataset for this function, including needed reference values. Example: . The active workspace updates.

Editable function formula

Change a function argument and test the actual result. The sample is written for the named example dataset. Example: =SUM(D2:D4).

Test Function

Evaluate the editor in a temporary result cell using the current workbook. Example: . The active workspace updates.

Transfer to Active Cell

Put this formula in the selected spreadsheet cell and recalculate. Example: . The active workspace updates.

Score

A numeric assessment score. Test 49, 50, and 51 around the threshold. Example: 50.

Threshold

The inclusive minimum passing score. Example: 50.

Attendance

Attended sessions. The rule requires at least eight. Example: 8.

Evaluate Logic

Calculate the condition in a temporary workbook and show both intermediate Boolean values. Example: . The active workspace updates.

Lookup investigation

Choose one of 25 prepared key-matching tasks. Example: Product price.

Search value

Use the exact key from the prepared source. Missing and duplicate keys are deliberately included. Example: K1B.

Lookup method

Compare forward exact lookup implementations. For approximate matching, use VLOOKUP with TRUE and the sorted numeric Rates table in the function explorer. Example: XLOOKUP.

Run Lookup

Calculate the selected exact lookup using the prepared table and show every matching source row. Example: . The active workspace updates.

CSV input

Use rows separated by newlines and comma-separated fields. Quote fields containing commas. Example: "Ari Lee",24.

Capitalization

Apply the same case rule across text values. Example: lowercase.

Keep rows containing

A literal text filter applied after transformation. Leave blank to keep every row. Example: ari.

Split first field on

Use one literal delimiter to split the first field. Leave blank to keep it intact. Example: .

Remove exact duplicate rows

Remove repeated transformed rows only when that policy suits the task. Example: Unchecked preserves all observations..

Convert plain numeric text

Convert finite decimal text to numeric values. Keep missing values blank. Example: 24 becomes the number 24..

Combine first two fields

Join the first two fields using one space. This changes the table schema. Example: First and last name become one field..

Clean Data

Trim whitespace, apply selected transformations, and show before/after rows and issues. Example: . The active workspace updates.

Error investigation

Choose one of 75 reproducible cases. Each uses its own named dataset and an intended task. Example: Division by zero.

Repair formula

Edit the broken expression and test it on the prepared dataset. It is evaluated in Z1, so =Z1 reproduces a circular reference. Example: =B2.

Test Formula

Evaluate the edited repair against the prepared case and compare the actual output with its expected result. Example: . The active workspace updates.

Chart range

Use a bounded rectangle containing labels and numeric values. The range excludes the header in this example. Example: A2:B6.

Chart type

Choose a comparison chart, an ordered line, a positive-part pie, or a numeric-pair scatterplot. Example: Column.

Scatter x-range

For a scatterplot, select a numeric range aligned row-for-row with the y-range. Example: D2:D6 contains units..

Label filter

Keep labels containing this literal text. Leave blank to include the full range. Example: Red.

Load Sales Example

Replace the workbook with the sales chart dataset after confirmation. Example: . The active workspace updates.

Build Chart

Read the selected range, plot its actual numeric values, and show an accessible data table. Example: . The active workspace updates.

Calculation task

Name the output and the business rule. Example: Multiply quantity by unit price..

Sheet and columns

Name the sheet, headers, and exact data rows. Example: Data!B2:C4.

Conditions and constraints

State eligibility conditions, fixed assumptions, and missing-data behavior. Example: Use Rates!$B$2 for the shared tax assumption..

Expected results and tests

Supply concrete expected values, changed inputs, and an error case. Example: Test blank quantity and numeric-looking text..

Error behavior

Describe whether to report, hold, or replace an expected error. Example: Return a review message for invalid records..

Generate AI Prompt

Assemble an editable instruction using the task, schema, constraints, and verification criteria. Example: . The active workspace updates.

Copy AI Prompt

Copy the exact instruction editor to use in an approved external assistant. Example: . The active workspace updates.

Editable AI instructions

Review and remove restricted data before copying. Check every returned formula against expected outputs. Example: Ask for a formula and explain each reference..

Formula to test

Paste an externally suggested or handwritten formula. It is parsed by the local engine and never executed as JavaScript. Example: =B2*C2.

Test Suggested Formula

Evaluate the formula against the current workbook in a temporary result cell. Example: . The active workspace updates.

External document or message artifacts

External service actions generally need Apps Script and appropriate authorization. Example: Prepare a Google Doc or Gmail draft..

Grouped interactive summary

A pivot table can provide an exploratory summary. Use SUMIFS for a transparent formula alternative. Example: Sales by team and region..

Reusable pure custom calculation

A pure custom function can return a value without external side effects. Example: A repeated domain-specific computation..

Multiple cleaning and calculation stages

Separate transformations into readable steps with intermediate checks. Example: Normalize keys before matching..

AI assistance for drafting a formula

Use a permitted synthetic schema and verify any suggested formula. Example: Ask for a SUMIFS pattern with tests..

Compare Approaches

Apply transparent task rules and show why each suggested implementation fits. Example: . The active workspace updates.

Automation workspace

Choose isolated JavaScript practice, an ordered workflow simulation, or a formula-versus-script comparison. Example: Apps Script range explorer.

Code example

Load a complete readable example. Changing this selector replaces the editor after confirmation. Example: Calculate and write totals.

Load Script Dataset

Load the three-product source table. Existing workbook changes are replaced after confirmation. Example: . The active workspace updates.

Run Script

Execute the current JavaScript in an isolated disposable worker with simulated SpreadsheetApp. The run has a three-second limit. Example: . The active workspace updates.

Stop Script

Terminate the current isolated run. Example: . The active workspace updates.

Download Script

Download a runnable Code.gs entry point, the exact local editor source, and setup instructions in a ZIP. Example: . The active workspace updates.

JavaScript / Apps Script editor

Use supported simulated SpreadsheetApp operations. Formula strings in cells are not evaluated by the service simulator; use the formula engine for those. Example: Read B2:C4, map row totals, write D2:D4..

Load Workflow Dataset

Replace the workbook with complete fictional order-processing records. Example: . The active workspace updates.

Minimum quantity

Keep records whose quantity meets this threshold. Example: 1.

Only New records

Filter on the source Status column before preparing artifacts. Example: Checked keeps New records..

Simulated reviewer approval

Allow Update status only after Request approval has occurred and totals are calculated. This is a local review flag. Example: Unchecked holds status changes..

Stage to add

Choose one supported action and append it to the ordered sequence. Example: Validate records.

Add Stage

Append the selected stage. Reorder using the Move controls below. Example: . The active workspace updates.

Move Up

Move this stage one position earlier. Example: Verify before approval.. The sequence changes.

Move Down

Move this stage one position later. Example: . The sequence changes.

Remove Stage

Remove this stage from the working workflow. Save a JSON backup to keep an older configuration. Example: . The active workspace updates.

Move Up

Move this stage one position earlier. Example: Verify before approval.. The sequence changes.

Move Down

Move this stage one position later. Example: . The sequence changes.

Remove Stage

Remove this stage from the working workflow. Save a JSON backup to keep an older configuration. Example: . The active workspace updates.

Move Up

Move this stage one position earlier. Example: Verify before approval.. The sequence changes.

Move Down

Move this stage one position later. Example: . The sequence changes.

Remove Stage

Remove this stage from the working workflow. Save a JSON backup to keep an older configuration. Example: . The active workspace updates.

Move Up

Move this stage one position earlier. Example: Verify before approval.. The sequence changes.

Move Down

Move this stage one position later. Example: . The sequence changes.

Remove Stage

Remove this stage from the working workflow. Save a JSON backup to keep an older configuration. Example: . The active workspace updates.

Move Up

Move this stage one position earlier. Example: Verify before approval.. The sequence changes.

Move Down

Move this stage one position later. Example: . The sequence changes.

Remove Stage

Remove this stage from the working workflow. Save a JSON backup to keep an older configuration. Example: . The active workspace updates.

Move Up

Move this stage one position earlier. Example: Verify before approval.. The sequence changes.

Move Down

Move this stage one position later. Example: . The sequence changes.

Remove Stage

Remove this stage from the working workflow. Save a JSON backup to keep an older configuration. Example: . The active workspace updates.

Move Up

Move this stage one position earlier. Example: Verify before approval.. The sequence changes.

Move Down

Move this stage one position later. Example: . The sequence changes.

Remove Stage

Remove this stage from the working workflow. Save a JSON backup to keep an older configuration. Example: . The active workspace updates.

Move Up

Move this stage one position earlier. Example: Verify before approval.. The sequence changes.

Move Down

Move this stage one position later. Example: . The sequence changes.

Remove Stage

Remove this stage from the working workflow. Save a JSON backup to keep an older configuration. Example: . The active workspace updates.

Move Up

Move this stage one position earlier. Example: Verify before approval.. The sequence changes.

Move Down

Move this stage one position later. Example: . The sequence changes.

Remove Stage

Remove this stage from the working workflow. Save a JSON backup to keep an older configuration. Example: . The active workspace updates.

Move Up

Move this stage one position earlier. Example: Verify before approval.. The sequence changes.

Move Down

Move this stage one position later. Example: . The sequence changes.

Remove Stage

Remove this stage from the working workflow. Save a JSON backup to keep an older configuration. Example: . The active workspace updates.

Run Workflow

Execute the listed stages against the current fictional workbook and show real before/after state and artifacts. Example: . The active workspace updates.

Download Apps Script

Export Code.gs, setup instructions, a manifest, and the current source CSV in one ZIP. Example: . The active workspace updates.

Module

Choose one of fifteen five-lesson modules. Example: Cells, ranges, and references.

Lesson

Open a lesson with a dataset, worked formula, prediction, practice, and independent challenge. Example: Values and formulas.

Predicted result

Select the value you expect before inspecting the worked trace. Example: Compare the source values..

Check Prediction

Compare your prediction with the computed worked result and explain the key relationship. Example: . The active workspace updates.

Load Lesson Workbook

Replace the workbook with this lesson dataset and place the worked formula in H8 for inspection. Example: . The active workspace updates.

Your practice formula

Edit the expression and test it on the original, changed, and boundary datasets. Multiple implementations can pass when they produce the required results. Example: =B2.

Test Practice Formula

Evaluate the current formula against this lesson’s output-based test fixtures. Example: . The active workspace updates.

Saved explanation

Explain the relationship in your own words. This note saves with the lesson. Example: B2 changed, so the quantity-times-price result changed..

Next Lesson

Open the next lesson in curriculum order. Example: . The active workspace updates.

Print Worksheet

Print the visible lesson as a learner worksheet using the browser print dialog. Example: . The active workspace updates.

Present This Lesson

Use a compact presentation view for this lesson and its worked dataset. Example: . The active workspace updates.

AI coaching purpose

Choose explanation, guided extension, or review of your edited code. Example: Explain the formula.

Editable coaching prompt

Includes the task, source data, current formula, expected result, and test criteria. Remove private information before sharing. Example: Use the fictional source data..

Copy Coaching Prompt

Copy the exact current prompt editor. Example: . The active workspace updates.

Project

Choose one of 25 projects with source data, completed formulas, expected results, and exportable artifacts. Example: Invoice calculator.

Load Project Starter

Load the project source data and clear its solution cells. This replaces the current workbook after confirmation. Example: . The active workspace updates.

Load Completed Project

Load the source plus all completed formulas for inspection after confirmation. Example: . The active workspace updates.

Verify Working Project

Compare the current workbook result cells with this project’s stated expected results. Example: . The active workspace updates.

Download Project

Download source data, completed workbook, formulas, expected results, and project instructions. Automation projects also include Code.gs and installation notes. Example: . The active workspace updates.

Challenge

Choose a construction or repair task. Assessment computes results across multiple datasets and accepts equivalent formulas. Example: Build and verify a line total..

Challenge formula

Write a formula for the displayed task. The tests evaluate output values, including changed and boundary inputs. Example: =B2.

Grade Challenge

Run the current formula on this challenge’s original, changed, and boundary fixtures. Example: . The active workspace updates.

Workbook snapshot name

Use a recognizable name before saving another workbook version. Example: Invoice verified v1.

Save Workbook Snapshot

Save the complete current workbook as a separate named local snapshot. Example: . The active workspace updates.

Export JSON Backup

Download the workbook, snapshots, progress, and workflow in a versioned format. Example: . The active workspace updates.

Saved workbook

Select a saved snapshot to restore or delete. Example: First formula experiment.

Restore Workbook

Replace the current workbook with the selected snapshot after confirmation. Example: . The active workspace updates.

Delete Snapshot

Remove one saved snapshot after confirmation. A prior JSON backup can restore it. Example: . The active workspace updates.

Import JSON backup

Choose a version 1 academy backup under 10 MB. Validated content replaces the working workbook and saved collections after confirmation. Example: A prior academy JSON export..

Your First Spreadsheet Formula

Load the three-product activity and open the guided steps. This replaces the working workbook after confirmation. Example: D2 becomes =B2*C2.. The active workspace updates.

Follow the Learning Path

Open the first of 75 lessons with sample data and a worked formula. Example: . The active workspace updates.

Open the Spreadsheet Lab

Continue with the current workbook and the selected learning object. Example: . The active workspace updates.

Demonstration

Choose a three-to-seven-minute demonstration with exact actions, narration, and expected observations. Times are planning estimates. Example: Your first spreadsheet formula..

Start Demonstration

Load the selected fictional dataset and show its presenter script. Example: . The active workspace updates.

Resume Guided Activity

Resume the saved step without replacing your current workbook. Example: . The active workspace updates.

First row contains headers

Keep the first CSV row outside duplicate, filter, and sorting operations. Example: Name,Amount.

Sort by first field

Sort complete transformed records by the first field while preserving the header. Example: Alphabetical names or numeric IDs..

Download Cleaned CSV

Download the transformed copy as CSV. Review its schema and missing values before importing. Example: . The active workspace updates.

Open Automation Example

Load this lesson’s fictional dataset and matching script or workflow after confirmation. Example: . The active workspace updates.

Official learning references

The fictional data and authored exercises belong to this academy. These primary references explain Google platform behavior and installation boundaries.

Google Sheets function list · Apps Script custom functions · Service authorization · Installable triggers