RPA LAB / 08

Messy Excel

Remove duplicates and blank rows, normalize dates and currency, and flag invalid amounts.

Intermediate20 minutesExcelDataNormalization
WORKSPACE / READY WHEN YOU ARE

Your next test starts here.

The mission

Remove duplicates and blank rows, normalize dates and currency, and flag invalid amounts. Each run generates eight fictional business records and keeps its expected result on the server.

Accuracy carries 60% of your score. Timing contributes 20%, reliability 10%, and output quality 10%. Work correctly first.