Practical guides
Long-tail how-tos tied to free tools, Gumroad kits, and Upwork delivery.
How to clean an email list before a campaign
A practical pre-campaign email hygiene checklist: normalize, dedupe, syntax-check, suppress, then bounce-verify only when needed.
How to convert receipts into an expense spreadsheet
A repeatable workflow from receipt photos and line items to an Excel expense sheet with categories, formulas, and audit-ready columns.
How to code open-ended survey responses in Excel
Learn a practical thematic coding workflow in Excel: codebook, primary themes, pivots, and when to use a quick keyword preview vs full coding.
How to clean YouTube and AI auto transcripts for publishing
Strip fillers, stage directions, and spacing issues from YouTube or Whisper transcripts, then apply a human pass for names and clarity.
How to extract invoice line items into Excel
Set a reusable invoice-to-Excel schema, convert line items to CSV, reconcile totals, and know when OCR outsourcing is worth it.
How to dedupe and clean a CSV file the safe way
Normalize keys, trim and lowercase, remove or mark duplicate CSV rows locally, and verify counts before you import anywhere.