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

aicreatormentor Republished on Nov 16 0 Bookmarks 0 Copies
Bookmark 0

Prompt template

Usage instructions
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

Provide the Excel version and choose whether to practice with customer or order records. The record type changes the sample context; the listed data-quality issues and one-issue-at-a-time practice remain part of the exercise

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

Up to 4 results. Images up to 2 MB; MP4, WebM, or MOV videos up to 4 MB each