Data Cleaning & Validation
Text functions, Remove duplicates, Validation, and more.
Course 6 of 6
Build, Scenarios, Charts, and more.
Yiga AI
Beginner · Course · 3 weeks at 5 hrs/week
What you’ll learn
Spreadsheet Essentials
Formulas & Functions
Data Cleaning & Validation
Pivot Tables & Charts
Syllabus
4 modules · 21 lessons · 14 hours · 1 graded project
840 minutes of guided lesson time.
Sign in and enrol to unlock every lesson. The first lesson is open as a preview.
Overview and set-up
Overview and set-up — Build in Project: Budget & Cash-Flow Model.
Lesson
Core concepts
Core concepts — Build in Project: Budget & Cash-Flow Model.
Lesson · Locked
Worked example
Worked example — Build in Project: Budget & Cash-Flow Model.
Lesson · Locked
Hands-on practice
Hands-on practice — Build in Project: Budget & Cash-Flow Model.
Lesson · Locked
Module quiz: Build
Check what you learned in Build before moving on.
Quiz · Locked
Overview and set-up
Overview and set-up — Scenarios in Project: Budget & Cash-Flow Model.
Lesson · Locked
Core concepts
Core concepts — Scenarios in Project: Budget & Cash-Flow Model.
Lesson · Locked
Worked example
Worked example — Scenarios in Project: Budget & Cash-Flow Model.
Lesson · Locked
Hands-on practice
Hands-on practice — Scenarios in Project: Budget & Cash-Flow Model.
Lesson · Locked
Module quiz: Scenarios
Check what you learned in Scenarios before moving on.
Quiz · Locked
Overview and set-up
Overview and set-up — Charts in Project: Budget & Cash-Flow Model.
Lesson · Locked
Core concepts
Core concepts — Charts in Project: Budget & Cash-Flow Model.
Lesson · Locked
Worked example
Worked example — Charts in Project: Budget & Cash-Flow Model.
Lesson · Locked
Hands-on practice
Hands-on practice — Charts in Project: Budget & Cash-Flow Model.
Lesson · Locked
Module quiz: Charts
Check what you learned in Charts before moving on.
Quiz · Locked
Overview and set-up
Overview and set-up — Present in Project: Budget & Cash-Flow Model.
Lesson · Locked
Core concepts
Core concepts — Present in Project: Budget & Cash-Flow Model.
Lesson · Locked
Worked example
Worked example — Present in Project: Budget & Cash-Flow Model.
Lesson · Locked
Hands-on practice
Hands-on practice — Present in Project: Budget & Cash-Flow Model.
Lesson · Locked
Module quiz: Present
Check what you learned in Present before moving on.
Quiz · Locked
Graded project: Project: Budget & Cash-Flow Model
Apply everything from Project: Budget & Cash-Flow Model in one graded, portfolio-ready build.
Graded project · Locked
Applied learning project
Use Graded project: Project: Budget & Cash-Flow Model to apply this course to a practical challenge. You’ll finish with a clear solution and the reasoning behind your choices.

Your instructor
Software & cloud
Helps new developers build reliable products through clear explanations and guided practice.

“I use what I learned in my work now, not in some distant future project.”
Continue with
Following the order of Excel & Google Sheets Analyst.
Learner reviews
Sign in to share your experience with this course.
Sign in to reviewLoading reviews…
Keep going
Text functions, Remove duplicates, Validation, and more.
Copilot, Gemini in Sheets, Formula generation, and more.
Navigation, Formatting, Basic formulas, and more.
IF, VLOOKUP/XLOOKUP, SUMIFS, and more.