Practice Cleaning Messy Excel Data
Work through a set of messy customer or order records and clean them in Excel one issue at a time. The tutor waits for your attempts, explains corrections, and helps verify the results
Prompt template
- Format
- Text Parameterized
- Inputs
- Record_type (text) · Required Excel_version (text) · Required
- Outputs
- Guided_data_cleaning_exercise (text)
Create 15 messy ${record-type} records with duplicates, extra spaces, inconsistent dates, blank fields, and numbers stored as text. Help me clean the data in ${excel-version}, one issue at a time. Wait for my attempt, explain corrections, and help me verify the results before moving on.
Replace the ${…} placeholders with your values
before using this prompt. See parameters
and defaults below
Parameters
Replace each placeholder with your own value, or use its default when one is provided
${record-type}
record-type
Required
${excel-version}
excel-version
Required
What you'll create
This prompt creates 15 imperfect customer or order records for a step-by-step Excel data-cleaning exercise. It asks the tutor to review attempts, explain corrections, and help verify the cleaned data
Usage instructions
Frequently asked questions
What kinds of data problems are included?
The records include duplicates, extra spaces, inconsistent dates, blank fields, and numbers stored as text
Can I use customer records or order records?
Yes. Choose either record type for the practice dataset
Comments
Tried this prompt? Share what you made, compare results, or ask a question