Excel for Data Preparation & Cleaning
Overview
Course Description
Focused course on the critical “data cleaning” phase of analytics. Covers practical techniques for transforming raw, messy data into analysis-ready datasets using Excel and Power Query. Data professionals spend 60-70% of time on data preparation; this course teaches it properly.
Prerequisites: Level 1 or basic spreadsheet experience
Career Relevance
- Essential skill for all analyst roles
- Salary impact: Good data prep skills = higher analyst salaries
- Next step: Analytics (Power BI, Python) or SQL
Level: Beginner-Intermediate
Duration: 3 weeks
Physical Fee: ₦40,000
Virtual Fee: ₦32,000