CoreBeginner35 min read
2. Pivot tables
Spreadsheets for QA & Analysis · 12 pages source format
Summarize defects by severity/component without writing code.
What you'll learn
- Pivot
- Counts
- Charts
Key idea
Pivots group and aggregate. Perfect for weekly QA reports.
Quick check
Pivots need…
Do this now
Write 3 notes on: Pivots.
Clear?
Practice
Build a severity × component pivot from sample bug data.
# Pivots
# try one small experimentDo this now
Commit one file practicing Pivots.
Clear?