Pathwise

Manuals / Spreadsheets for QA & Analysis / Chapter 1

Start · beginner · ~25 min · Chapter 1 of 3

Clean tables

One header row, no merged cells, consistent types.

Path progress
17%

Step 1 of 2

Key idea

Merged cells and mixed types break filters and pivots. Use a proper Table object.

Key ideaDrag stickies · tap for tips
Study mapDrag stickies · tap for tipsKeep it shortdrag · tap →Name the waitdrag · tap →Scope locatorsdrag · tap →Trace when stuckdrag · tap →One browser firstdrag · tap →Isolate statedrag · tap →Assert the UIdrag · tap →Retry wiselydrag · tap →Seed datadrag · tap →Close the loopdrag · tap →Keep it shortdrag · tap →Name the waitdrag · tap →Scope locatorsdrag · tap →Trace when stuckdrag · tap →One browser firstdrag · tap →Isolate statedrag · tap →Pathwise hackdrag · tap →Key ideadrag · tap →Go deeperdrag · tap →Follow the dashed drag · tap →
Docs

Quick check

Merged cells are…

Do this now

Write 3 notes on: Clean tables.

Was this step clear?
Chapter learning outcomes
  • Tables
  • Filters
  • Data validation

Clear these before you leave