Module 4 · You are here
Placeholders, Junk, and Standardization
Catch the values that look like data but are not. "(000) -", "N/A", "unknown", and "TBD" inflate your denominator and lie to your lead organizer.
By the end of Module 4, you will be able to:
- List the eight most common placeholder values in union rosters.
- Use =IF + =LEN + =ISBLANK to flag invalid phones and emails.
- Use =IFERROR to suppress junk from breaking your downstream formulas.
- Use =PROPER to standardize name casing without losing legitimate caps.
- Standardize ZIP codes that lost their leading zeros.
Subsections in Module 4
4.1
Placeholders are not data
Open 4.2IF, LEN, ISBLANK for validation
Open 4.3Standardize names and ZIPs
Open 4.4Hands-on: build a placeholder watchlist
Open 4.5Card support % checkpoint
OpenStart here: Module 4.1 · Placeholders are not data
Begin Module 4
After Module 4: Module 5 · Stripping Formatting and Deduplicating
Next: Module 5 · Stripping Formatting and Deduplicating