Task 1 of 5
Some orders in the export A1:D12 are recorded twice. Remove the repeats.
Lesson theory
A delivery company in Denver exported its orders from an old program: some rows appear twice, and the courier and the district share one cell. Let's tidy the table, protect the status column, and add up the totals for a single district.
Tip: clean the data first (duplicates, splitting text), then filter and calculate, so the totals are honest.
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.