Manuals / Spreadsheets for QA & Analysis / Chapter 2

Core · beginner · ~35 min · Chapter 2 of 3

Pivot tables

Summarize defects by severity/component without writing code.

Path progress
50%

Step 1 of 2

Key idea

Pivots group and aggregate. Perfect for weekly QA reports.

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 →

Quick check

Pivots need…

Do this now

Write 3 notes on: Pivots.

Was this step clear?
Chapter learning outcomes
  • Pivot
  • Counts
  • Charts

Clear these before you leave