Course 5 of 6

Data Cleaning & Validation

Text functions, Remove duplicates, Validation, and more.

Yiga AI

Beginner en

Beginner · Course · 3 weeks at 5 hrs/week

Duration: 3 weeks
Effort: 5 hrs/week
Lessons: 16
Hands-on exercises: 16
Projects: 1
Language: en

What you’ll learn

Skills you can put to work.

Spreadsheet Essentials

Formulas & Functions

Data Cleaning & Validation

Pivot Tables & Charts

Syllabus

Every module, step by step.

4 modules · 21 lessons · 14 hours · 1 graded project

840 minutes of guided lesson time.

Module 1 · 5 lessons · 3 hoursText functionsModule 1 of 4 in Data Cleaning & Validation.

Overview and set-up
Overview and set-up — Text functions in Data Cleaning & Validation.
Lesson
40 min
Core concepts
Core concepts — Text functions in Data Cleaning & Validation.
Lesson · Locked
40 min
Worked example
Worked example — Text functions in Data Cleaning & Validation.
Lesson · Locked
40 min
Hands-on practice
Hands-on practice — Text functions in Data Cleaning & Validation.
Lesson · Locked
40 min
Module quiz: Text functions
Check what you learned in Text functions before moving on.
Quiz · Locked
20 min

Module 2 · 5 lessons · 3 hours LockedRemove duplicatesModule 2 of 4 in Data Cleaning & Validation.

Overview and set-up
Overview and set-up — Remove duplicates in Data Cleaning & Validation.
Lesson · Locked
40 min
Core concepts
Core concepts — Remove duplicates in Data Cleaning & Validation.
Lesson · Locked
40 min
Worked example
Worked example — Remove duplicates in Data Cleaning & Validation.
Lesson · Locked
40 min
Hands-on practice
Hands-on practice — Remove duplicates in Data Cleaning & Validation.
Lesson · Locked
40 min
Module quiz: Remove duplicates
Check what you learned in Remove duplicates before moving on.
Quiz · Locked
20 min

Module 3 · 5 lessons · 3 hours LockedValidationModule 3 of 4 in Data Cleaning & Validation.

Overview and set-up
Overview and set-up — Validation in Data Cleaning & Validation.
Lesson · Locked
40 min
Core concepts
Core concepts — Validation in Data Cleaning & Validation.
Lesson · Locked
40 min
Worked example
Worked example — Validation in Data Cleaning & Validation.
Lesson · Locked
40 min
Hands-on practice
Hands-on practice — Validation in Data Cleaning & Validation.
Lesson · Locked
40 min
Module quiz: Validation
Check what you learned in Validation before moving on.
Quiz · Locked
20 min

Module 4 · 6 lessons · 5 hours LockedConditional formattingModule 4 of 4 in Data Cleaning & Validation.

Overview and set-up
Overview and set-up — Conditional formatting in Data Cleaning & Validation.
Lesson · Locked
40 min
Core concepts
Core concepts — Conditional formatting in Data Cleaning & Validation.
Lesson · Locked
40 min
Worked example
Worked example — Conditional formatting in Data Cleaning & Validation.
Lesson · Locked
40 min
Hands-on practice
Hands-on practice — Conditional formatting in Data Cleaning & Validation.
Lesson · Locked
40 min
Module quiz: Conditional formatting
Check what you learned in Conditional formatting before moving on.
Quiz · Locked
20 min
Graded project: Data Cleaning & Validation
Apply everything from Data Cleaning & Validation in one graded, portfolio-ready build.
Graded project · Locked
120 min

Applied learning project

Make the learning visible.

Use Graded project: Data Cleaning & Validation to apply this course to a practical challenge. You’ll finish with a clear solution and the reasoning behind your choices.

Apply the course’s core skillMake and explain practical decisionsCreate evidence you can share

Your instructor

Daniel O.

Data & analytics

Turns real African data problems into practical lessons learners can apply immediately.

“The course content made machine learning understandable, and the practice kept me moving.”
Brian Okello
Software developer, Kampala

Continue with

Your next best step.

Following the order of Excel & Google Sheets Analyst.

See the full chain

Next lesson

Overview and set-up

Data Cleaning & Validation

40 min · Resume

Course 6 in the track

AI in Spreadsheets

Copilot, Gemini in Sheets, Formula generation, and more.

Beginner · Course · 3 weeks at 5 hrs/week

Learner reviews

What learners say.

Write a review

Loading reviews…

Previous courseProject: Budget & Cash-Flow Model Next courseAI in Spreadsheets

Keep going

Other courses in this track.

View full track

Spreadsheet Essentials cover illustration

Business

16 lessons · 14h · Beginner

Spreadsheet Essentials

Navigation, Formatting, Basic formulas, and more.

Business

16 lessons · 14h · Beginner

Formulas & Functions

IF, VLOOKUP/XLOOKUP, SUMIFS, and more.

Pivot Tables & Charts cover illustration

Business

16 lessons · 14h · Beginner

Pivot Tables & Charts

Pivots, Slicers, Charts, and more.

Project: Budget & Cash-Flow Model cover illustration

Business

16 lessons · 14h · Beginner

Project: Budget & Cash-Flow Model

Build, Scenarios, Charts, and more.