Spreadsheet data cleanup
Turn messy data into tables you can filter and summarise, using a handful of everyday techniques.
Outline
- One row per record What a tidy table looks like and the common layouts that cause trouble.
- Cleaning and splitting columns Remove stray spaces and split combined columns.
- Filtering and sorting Find the rows you need quickly.
- An introduction to pivot tables Build summary tables by dragging and dropping.
What to bring
- A laptop with spreadsheet software
- A spreadsheet you use at work (dummy data is fine)
Who it is for
Anyone who tidies spreadsheets every day and wants to spend less time copying and pasting.
Instructor
Lu (fictional)
Spreadsheet instructor
Good at breaking complex features into simple steps. Often says, "get the table layout right and the rest is easy".
All instructors →Images are AI-generated illustrations.