Lumina

Manuals / Spreadsheets for QA & Analysis / Ch 1

StartBeginner25 min read

1. Clean tables

Spreadsheets for QA & Analysis · 12 pages source format

One header row, no merged cells, consistent types.

What you'll learn

  • Tables
  • Filters
  • Data validation

Key idea

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

Quick check

Merged cells are…

Do this now

Write 3 notes on: Clean tables.

Docs
Clear?

Practice

Convert a messy export into a filtered Table.

Starter
# Clean tables
# try one small experiment

Do this now

Commit one file practicing Clean tables.

Clear?

Checklist