Excel Data Cleanup
Clean and reshape messy sales data for a reliable handoff.
Original mini-courses. Real practice files. Clear feedback. Free, without an account.
Start a mini-courseSELECT order_id, amount FROM orders WHERE status = 'paid' AND amount > 100;
| order_id | status | amount |
|---|---|---|
| 1 | paid | 120 |
| 2 | pending | 140 |
| 3 | paid | 100 |
| 4 | paid | 180 |
Clean and reshape messy sales data for a reliable handoff.
Build a checked sales report with lookups and conditional totals.
Write and run SQL queries to answer everyday business questions.
Diagnose funnels, refunds, inventory and duplicate customer records.
Check AI-assisted work against evidence and a clear output contract.
No courses match these filters.
Practice selected data-preparation goals through four original lessons, a checked order-file project and all the materials.
Explore the data-preparation trial →