Yiga AI

Course 2 of 6

Formulas & Functions

IF, VLOOKUP/XLOOKUP, SUMIFS, 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.

Sign in and enrol to unlock every lesson. The first lesson is open as a preview.

Module 1 · 5 lessons · 3 hoursIFModule 1 of 4 in Formulas & Functions.

  1. Overview and set-up

    Overview and set-up — IF in Formulas & Functions.

    Lesson

    40 min

  2. Core concepts

    Core concepts — IF in Formulas & Functions.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — IF in Formulas & Functions.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — IF in Formulas & Functions.

    Lesson · Locked

    40 min

  5. Module quiz: IF

    Check what you learned in IF before moving on.

    Quiz · Locked

    20 min
Module 2 · 5 lessons · 3 hours LockedVLOOKUP/XLOOKUPModule 2 of 4 in Formulas & Functions.

  1. Overview and set-up

    Overview and set-up — VLOOKUP/XLOOKUP in Formulas & Functions.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — VLOOKUP/XLOOKUP in Formulas & Functions.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — VLOOKUP/XLOOKUP in Formulas & Functions.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — VLOOKUP/XLOOKUP in Formulas & Functions.

    Lesson · Locked

    40 min

  5. Module quiz: VLOOKUP/XLOOKUP

    Check what you learned in VLOOKUP/XLOOKUP before moving on.

    Quiz · Locked

    20 min
Module 3 · 5 lessons · 3 hours LockedSUMIFSModule 3 of 4 in Formulas & Functions.

  1. Overview and set-up

    Overview and set-up — SUMIFS in Formulas & Functions.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — SUMIFS in Formulas & Functions.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — SUMIFS in Formulas & Functions.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — SUMIFS in Formulas & Functions.

    Lesson · Locked

    40 min

  5. Module quiz: SUMIFS

    Check what you learned in SUMIFS before moving on.

    Quiz · Locked

    20 min
Module 4 · 6 lessons · 5 hours LockedDatesModule 4 of 4 in Formulas & Functions.

  1. Overview and set-up

    Overview and set-up — Dates in Formulas & Functions.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Dates in Formulas & Functions.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Dates in Formulas & Functions.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Dates in Formulas & Functions.

    Lesson · Locked

    40 min

  5. Module quiz: Dates

    Check what you learned in Dates before moving on.

    Quiz · Locked

    20 min

  6. Graded project: Formulas & Functions

    Apply everything from Formulas & Functions in one graded, portfolio-ready build.

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: Formulas & Functions 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
Mariam K., Software & cloud

Your instructor

Mariam K.

Software & cloud

Helps new developers build reliable products through clear explanations and guided practice.

Diana Nsiiza, Yiga learner

“I use what I learned in my work now, not in some distant future project.”

Diana Nsiiza

Data analyst, Entebbe

Continue with

Your next best step.

Following the order of Excel & Google Sheets Analyst.

See the full chain

Next lesson

Overview and set-up

Formulas & Functions

40 min · Resume

Course 3 in the track

Pivot Tables & Charts

Pivots, Slicers, Charts, and more.

Beginner · Course · 3 weeks at 5 hrs/week

Course 4 in the track

Project: Budget & Cash-Flow Model

Build, Scenarios, Charts, and more.

Beginner · Course · 3 weeks at 5 hrs/week

Course 5 in the track

Data Cleaning & Validation

Text functions, Remove duplicates, Validation, and more.

Beginner · Course · 3 weeks at 5 hrs/week

Learner reviews

What learners say.

Write a review

Sign in to share your experience with this course.

Sign in to review

Loading reviews…

Previous courseSpreadsheet EssentialsNext coursePivot Tables & Charts

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.

Yiga Plus