AnalystOS Mission / Excel
Excel Cleaning Challenge
Clean a messy operational spreadsheet so it can support reliable reporting and stakeholder decisions.
Difficulty
Beginner
Estimated time
45-60 minutes
Reward
+50 XP
Role fit
Data Analyst / Business Analyst
Mission Brief
What you need to solve
Clean a messy operational spreadsheet so it can support reliable reporting and stakeholder decisions.
Best fit
Data Analyst
Best fit
Business Analyst
Data You Will Use
What information you get
Spreadsheet export with duplicate rows, inconsistent dates, missing categories, currency formatting issues, and free-text status fields.
Guided Steps
Follow Step 1 to Step 5
Use these beginner-friendly steps before you accept the mission.
Identify duplicate, missing, and inconsistent records.
Standardize fields needed for reporting.
Document cleaning decisions and assumptions.
Summarize remaining data quality risks.
Save your work and explain your answer in simple language.
What You Will Create
What your work should contain
A cleaned data dictionary, transformation notes, and a quality-check summary.
Cleaned table
Cleaning log
Data quality summary
Starter Question
Use this to begin
Prepare this spreadsheet for analysis and document what changed so another analyst can trust it.