FORMULAS · DATA · AUTOMATION
Spreadsheet ideas.
Visible calculations.
Build a formula, inspect the values it reads, and see how an input changes the result. Then use the same habits to clean data, create reports, and plan Google Apps Script automation.
About the academy and local spreadsheet
A formula computes a result from values or references. The Formula Inspector shows parsed operations, referenced values, intermediate results, and errors. You can practice prices, sales summaries, attendance, expenses, inventory, and reports.
The local engine implements a documented subset of spreadsheet semantics. It supports A1:Z100, selected functions, multiple sheets, and inspectable matrix results. Array results stay at one anchor. Google Sheets offers additional behaviors, formatting, and services. The Help Center explains the differences.
Apps Script practice runs with simulated spreadsheet services in an isolated browser worker. Local workflows prepare fictional document and email-draft artifacts. Google authorization is required only when you install and run exported code in your own Google environment. AI prompts help you ask for a formula and define tests. Authored samples remain labeled.
Loading the academy…
Learn Google Sheets through working experiments
Start with a line total, change a quantity, copy relative references, and inspect a real sum. Continue through 75 lessons, formula investigations, practical projects, and locally simulated automation.
Google Apps Script learning path · Google Sheets Learning Studio · Sheets AI Workflow Lab · Supported formulas and differences