Cheat sheet · Beginner · 5 min
Spreadsheet essentials cheat sheet
Structure, formulas and checks in one place. Syntax shown for Excel; Sheets is near-identical. 4 sections, 16 entries.
- Structure
- Formulas
- Lookups
Entries 16
Lab · Beginner · 30 min
Lab: Find the broken formula
A workbook's totals are wrong; find the cause with the tools rather than by eye.
- A colleague's revenue summary is short by a few hundred, and they have been re-adding by hand.
Tasks 3
Project · Beginner · 5h
Project: An inventory workbook with reorder alerts
Build an inventory workbook with a products table, stock movements, reorder points, a dashboard and checks.
- Build a workbook with a products table (SKU, name, cost, reorder point, lead time), a movements table (date, SKU, quantity in or out), a stock-on-hand summary with SUMIFS, reorder alerts with conditional formatting, a pivot dashboard by category, validation on all inputs and a checks block.
- Milestone 1: Structure
- Milestone 2: Calculations
Learning path · Beginner · 5h
Spreadsheets that do not break
Structure, formulas, lookups, pivots and checks — learned by building the sheets a business actually needs.
- Build spreadsheets with clean structure, correct formulas, working lookups and built-in checks, in Excel or Google Sheets.
- Skills: Structuring data as tables, Core formulas and absolute references, Lookups and conditional aggregation, Pivot tables, Validation and error checks
Time 5h

Instant delivery after paymentLicence stated on every productRe-download anytime from My LibrarySecure checkout — Polar or FungiesNew products every week

Products GamingNew Subscriptions Deals Membership Licensing

Search

Spreadsheet essentials cheat sheet

Lab: Find the broken formula

Project: An inventory workbook with reorder alerts

Spreadsheets that do not break