Data Preparation in Excel: selected skill trial
Try selected public learning objectives through original work tasks.
Reference: DataCamp. Checked 2026-10-09.
Practice selected data-preparation outcomes in a browser CSV workbench. The original course uses Excel and also teaches logical formulas, lookups and PivotTables.
These are original lessons, synthetic datasets and assessments. Skill Workbench is independent of the source provider.
Try data preparation before choosing a course
Work through four original lessons, check your own output, then hand off a clean order file.
Selected public objectives from DataCamp’s Data Preparation in Excel. This is an independent original trial, with different lessons and fictional practice data.
Read a small table and edit a cell. No Excel installation is needed for this CSV trial.
Four lessons · Eight exercises · One final project · Complete materials
What this trial covers
- Import and inspect tabular data: Quoted CSV, stable headers and empty records; no Excel import dialogs.
- Prepare missing data: Explicit defaults and preservation of zero; no Flash Fill or inferred values.
- Remove duplicates: Declared business keys and a keep-first policy.
- Prepare text and dates: Whitespace and declared date formats; no full Excel text/date function library.
What you will need the full course for
- Native Excel import dialogs, Flash Fill and workbook protection
- Nested logical formulas and the full Excel text/date function library
- VLOOKUP, HLOOKUP and PivotTable creation
- The complete provider course, its exercises, instructor support and credentials
The provider course uses Microsoft Excel. This trial checks selected preparation outcomes in CSV, rather than teaching every Excel tool.
Your final handoff
A two-row order CSV with unique IDs, declared ISO dates, trimmed names, an explicit region default and the original amounts.
Final project checklist
- Keep one row per order_id using the first record.
- Return exactly order_id, date, region, name, amount.
- Normalize declared YYYY/MM/DD dates to YYYY-MM-DD.
- Use Unknown only for a missing region; trim names and preserve zero.
- Export your checked CSV, then compare it with the separate reference answer.
Objective coverage
Import and inspect tabular data
Quoted CSV, stable headers and empty records; no Excel import dialogs.
Import without losing data →Prepare missing data
Explicit defaults and preservation of zero; no Flash Fill or inferred values.
Handle missing values →Remove duplicates
Declared business keys and a keep-first policy.
Deduplicate by a business key →Prepare text and dates
Whitespace and declared date formats; no full Excel text/date function library.
Standardize dates and whitespace →Public objectives summarized; independent original lessons, synthetic data and assessments. No affiliation with DataCamp.
Start the original mini-course →