About Course
Transform raw administrative or survey data into traceable, analysis-ready datasets using Excel.
Build practical capability in data cleaning in Excel
This DatalytIQs Academy course provides a structured learning pathway around data cleaning in Excel. The curriculum below shows the learning areas and activities currently included in the course.
What you will explore
- Explore Data audit and preservation.
- Explore Standardisation.
- Explore Validation and exceptions.
- Explore Cleaning decisions.
- Explore Analysis-ready export.
- Explore Professional evidence checkpoint.
Course curriculum
The current Tutor LMS curriculum contains the following learning areas and activities.
Data audit and preservation
- Create a read-only raw-data copy and cleaning log
- Profile structure, missingness and apparent errors
- Quiz: DTQ-105 Theory Quiz: Data Cleaning in Excel
Standardisation
- Standardise dates, text, codes and categories
- Use Excel functions to remove common entry inconsistencies
Validation and exceptions
- Apply rules to identify duplicates, outliers and invalid values
- Build exception flags rather than silently changing data
Cleaning decisions
- Document correction, recoding and exclusion decisions
- Retain reproducible before-and-after evidence
Analysis-ready export
- Build a tidy analysis sheet and codebook
- Validate final record counts and key distributions
Professional evidence checkpoint
- Submit a cleaned workbook, cleaning log and exception summary
Learning with DatalytIQs
DatalytIQs Academy connects structured learning with applied analysis, evidence-based thinking and professional practice. Use the course curriculum and learning activities as your primary pathway through this course.
Course Content
Data audit and preservation
-
Create a read-only raw-data copy and cleaning log
-
Profile structure, missingness and apparent errors
-
DTQ-105 Theory Quiz: Data Cleaning in Excel
Standardisation
Validation and exceptions
Cleaning decisions
Analysis-ready export
Professional evidence checkpoint
Student Ratings & Reviews
No Review Yet