ADM-05Admin / Operations Assistant

Data Cleanup + Simple Report

Outline steps to clean a messy candidate spreadsheet, add useful columns, and summarise the work for a manager.

Suggested time: 1 to 2 hours

Full task instructions

A team has a messy candidate spreadsheet with inconsistent formatting, missing data and no useful summary columns. Outline the steps you would take to clean it up and make it more useful. Include the cleanup steps, the useful columns you would add (and why), and a short summary you would send to your manager explaining what you did and what the spreadsheet now shows. Think about what makes data actually usable for a team. You do not need to clean a real spreadsheet. This is a process brief.

Deliverable

A cleanup process outline, proposed new columns with rationale, and a manager summary message.

Constraints

Do not use real candidate data. Keep the process practical and realistic.

Skills assessed

Data cleanupProcess designReportingAttention to detail

Your progress

Register or login to start this Lab Brief.

Login to startRegister free

Your submission is private. Only you and employers with relevant subscription access can view your work. It will not be publicly displayed.