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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.