Try it step by step
Your experiment
Examples labeled as real-Sheets exercises are not evaluated by the local formula interpreter.
GOOGLE SHEETS / FROM YOUR FIRST CELL TO YOUR OWN FUNCTIONS
Make your sheets
work smarter.
Learn by changing the data, testing a formula and explaining the result. Build skills you can take into your next real spreadsheet.
50 lessons · 5 chapters · 6 practice spaces · No sign-in required
ONE TABLE. MANY USEFUL ANSWERS.
ItemQtyPriceNotebook312Pen52
Two of the five sample records shown
=SUM(B2:B6)15 units
See the data. Understand the calculation.
A learning studio, not a live Google Sheet. The local formula lab supports a documented subset of Sheets syntax. Advanced formulas and menus are guided exercises to try in Google Sheets. No Google account is connected. Examples use English function names, decimal points and comma separators; your locale may differ.
0 / 50 knowledge checks passed
CHANGE THE INPUT. CHECK THE RESULT.
Your formula workshop
Edit the five order records and evaluate a formula against A1:D6. The grid stores literal values, not formulas. This is a small teaching interpreter, not Google Sheets; it uses stricter types and does not implement every coercion or error rule.
On narrow screens, scroll the grid sideways to reach Price and Team.
Enter a formula to begin.
Supported functions and local limits
Supports numbers, quoted text, TRUE/FALSE, A1:D6 references and rectangular ranges, parentheses, + − * /, &, and comparisons. No cross-tab references, dates, percentages, array arithmetic, wildcards, QUERY, XLOOKUP or Google services. IF uses three arguments; IFERROR uses two; SUMIF requires an explicit sum range. ROUND precision is limited to −8…8. Blank handling and type coercion are simplified; verify production formulas in Sheets.
Formula missions
Checks compare your result on the original sample data. They do not change your edited grid or require one exact formula.
MAKE THE DOLLAR SIGNS MAKE SENSE
Where does a reference move?
Try copying a row-highlighting rule such as =$B2>=3. The column remains B while the row moves. This explorer shifts one reference; it does not rewrite entire formulas or sheet names.
YOUR LOGIC. A REUSABLE NAME.
Build a named-function recipe
Choose a tested recipe, adjust inputs, then copy the setup into Data → Named functions in Google Sheets. This generates instructions; nothing is installed in your Google account.
The recipes declare their input contract. They are not universal validators. Try zeros and boundary values before using them in a report.
WHEN YOU NEED JAVASCRIPT
Custom-function code lab
Write DOUBLE_VALUES(value). Double a number, preserve an empty string, or return a two-dimensional array with each numeric value doubled and empty strings preserved. The three fixtures check those cases. Real Sheets uses a separate Apps Script project.
How to use your function in Google Sheets
- Open your practice spreadsheet and choose Extensions → Apps Script.
- Add the function, save, then return to the sheet.
- Enter
=DOUBLE_VALUES(B2:B6)in an empty output area. - Review outputs, blanks and unsupported types. Keep the output area clear.
The browser runner is isolated, blocks external requests and stops after three seconds. It provides no Sheets services. Google’s custom-function runtime has different limits and restrictions; this fixture test is not a deployment test.
FROM RECORDS TO A REPORT
Explore your order dashboard
This report uses your current formula-lab grid. Edit quantities or prices there and return here. Only finite numeric quantities and prices are accepted; team labels determine grouping.
Revenue = sum of Qty × Price for the selected records. This is a fixed educational dashboard, not a Google pivot-table emulator. Values use plain numbers; no currency is assumed.
Capstone checklist
Keep learning with official Google documentation
Function reference · Named functions · Apps Script custom functions · Conditional formatting · QUERY