Excel for Analysis: PivotTables, lookups and data cleaning

Copy this, open Claude, paste it, and Claude will walk you through the lesson step by step.

For a grown-up: Claude is for adults (18+). Copy this, paste it into Claude, and use the answer to explain the lesson to your child.

I'm learning "Excel for Analysis: PivotTables, lookups and data cleaning" on The Future Market. Lesson 1: "Inspect and clean a messy export".

What the lesson teaches:
- Always keep the raw data sheet untouched. Do your cleaning in new columns or on a copy, so you can start over.
- Look for four common problems: extra spaces, odd capital letters, numbers stored as text (they often sit on the left of the cell and SUM ignores them) and dates stored as text.
- TRIM(text) removes all spaces from text except single spaces between words. It only removes the normal space (character 32), not the non-breaking space (character 160) that often comes with web pages.
- SUBSTITUTE(text, old_text, new_text, [instance_num]) replaces specific text. To remove non-breaking spaces use SUBSTITUTE(A2,CHAR(160)," "), then TRIM the result.
- CLEAN(text) removes the non-printable characters with codes 0 to 31. It does not remove every odd Unicode character.
- PROPER(text) makes the first letter of each word a capital.
- VALUE(text) turns text that looks like a number into a real number. =VALUE("$1,000") gives 1000. Text must be in a number, date or time format Excel recognises, or you get #VALUE!.

The exercise I'm working on:
Make a raw sheet of 10 rows with names that have extra spaces and mixed capitals, amounts typed as text with a dollar sign and comma (for example $1,250.00), and dates typed as 2026/03/05. On a copy, clean every column with TRIM, PROPER, VALUE and DATEVALUE, then paste as values.

I'm stuck. Please:
1. Explain the main idea in plain, simple words with one everyday example.
2. Walk me through the exercise one small step at a time. Ask me what I've done so far before giving the next step.
3. Don't just give me the final answer. Help me do it myself, and check my work when I share it.

I'm a parent helping my child (about 8 years old) with a lesson called "Inspect and clean a messy export" from the course "Excel for Analysis: PivotTables, lookups and data cleaning".

Here's what the lesson says:
When you get a box of mixed LEGO from a friend, you do not start building at once. You tip it out, look at it, and pick out the broken or dusty pieces first. A messy spreadsheet is the same: look first, clean second, analyse last.

The activity:
Make a raw sheet of 10 rows with names that have extra spaces and mixed capitals, amounts typed as text with a dollar sign and comma (for example $1,250.00), and dates typed as 2026/03/05. On a copy, clean every column with TRIM, PROPER, VALUE and DATEVALUE, then paste as values.

Please explain this so an 8-year-old understands: short sentences, a fun everyday example, and no hard words.
Then give me 3 simple questions I can ask my child to check they understood, and a way to do the activity together, one tiny step at a time.