📊 Excel & Spreadsheets Prompts
Formulas, reports, pivot tables, charts, VBA macros
← All Categories
1 prompts
in Data Cleaning
Clean Messy Data Checklist
Give me a complete Excel data cleaning checklist with formulas for each step: 1) Remove duplicates (explain Remove Duplicates tool + COUNTIF method), 2) Fix inconsistent text (TRIM, PROPER, UPPER, LOWER), 3) Handle blank cells (IF+ISBLANK, Go To Special), 4) Fix date formats (DATEVALUE, TEXT), 5) Separate combined columns (Text to Columns, TEXTSPLIT), 6) Remove special characters (SUBSTITUTE + CLEAN), 7) Validate data ranges (Data Validation rules), 8) Standardize categories (VLOOKUP mapping table).
💡 Always work on a copy of your data, never the original.