Apple Numbers learning centre

Apple Numbers Practical Tutorials

Choose a practical Apple Numbers task below. Check the guide’s version, prerequisites and verification notes before following the steps.

For individual formulas, browse the Apple Numbers function directory.

10 practical tutorials

Data entry and controls

Count Checkboxes and Percent Complete in Apple NumbersBuild a Numbers checklist with a reliable task denominator, count completed tasks, and check blank-row and zero-task cases.Beginner · Apple Numbers Make a Pop-Up Menu from Existing Values in Apple NumbersTurn existing status values into Numbers pop-up menus, keep the current selections, and maintain the choices without overwriting your records.Beginner · Apple Numbers

Data management

Sort and Filter Numbers Tables by Multiple ConditionsUse all-versus-any filters, checkbox values, blank notes, and multi-column sorting in Apple Numbers, with a small order table and exact expected rows.Beginner · Apple Numbers

File compatibility

Export Apple Numbers to Excel and Check That Totals MatchExport a Numbers workbook to Excel, choose table or sheet mapping, and reconcile formulas, totals and chart inputs with a reproducible audit.Intermediate · Apple Numbers

Formulas and references

Reference Another Table or Sheet in Apple NumbersLink Numbers tables and sheets with qualified references, preserve a shared rate when copying formulas, and verify every source target.Beginner · Apple Numbers

Import and data integrity

Preserve Long Order IDs When Importing CSV into NumbersProtect leading zeros and long identifiers with a text transport column, exact-character checks, and a careful Numbers CSV export review.Beginner · Apple Numbers

Pivot tables and analysis

Create and Refresh a Pivot Table in Apple NumbersBuild a Numbers sales summary and diagnose missing new rows by checking refresh, the source table or selected range, filters, and aggregation.Intermediate · Apple Numbers

Printing and PDF output

Print Several Apple Numbers Tables on One PDF PageArrange several Numbers tables on one sheet, check page boundaries and scale, then save a readable one-page PDF without hiding overflow.Beginner · Apple Numbers

Recovery and file management

Recover a Deleted Numbers Sheet Without Losing Newer EditsRecover missing Numbers sheet content from an earlier version while retaining current work, using selective copying or Restore a Copy.Beginner · Apple Numbers

Sheet and cell protection

Protect Formula Tables While Keeping Inputs Editable in NumbersUnderstand Numbers' table-level locking, build separate input and calculation tables, and distinguish accidental-edit protection from access permissions.Beginner · Apple Numbers