Yiga AI

Course 1 of 6

Spreadsheet Essentials

Navigation, Formatting, Basic formulas, 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 hoursNavigationModule 1 of 4 in Spreadsheet Essentials.

  1. Overview and set-up

    Overview and set-up — Navigation in Spreadsheet Essentials.

    Lesson

    40 min

  2. Core concepts

    Core concepts — Navigation in Spreadsheet Essentials.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Navigation in Spreadsheet Essentials.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Navigation in Spreadsheet Essentials.

    Lesson · Locked

    40 min

  5. Module quiz: Navigation

    Check what you learned in Navigation before moving on.

    Quiz · Locked

    20 min
Module 2 · 5 lessons · 3 hours LockedFormattingModule 2 of 4 in Spreadsheet Essentials.

  1. Overview and set-up

    Overview and set-up — Formatting in Spreadsheet Essentials.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Formatting in Spreadsheet Essentials.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Formatting in Spreadsheet Essentials.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Formatting in Spreadsheet Essentials.

    Lesson · Locked

    40 min

  5. Module quiz: Formatting

    Check what you learned in Formatting before moving on.

    Quiz · Locked

    20 min
Module 3 · 5 lessons · 3 hours LockedBasic formulasModule 3 of 4 in Spreadsheet Essentials.

  1. Overview and set-up

    Overview and set-up — Basic formulas in Spreadsheet Essentials.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Basic formulas in Spreadsheet Essentials.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Basic formulas in Spreadsheet Essentials.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Basic formulas in Spreadsheet Essentials.

    Lesson · Locked

    40 min

  5. Module quiz: Basic formulas

    Check what you learned in Basic formulas before moving on.

    Quiz · Locked

    20 min
Module 4 · 6 lessons · 5 hours LockedPrintingModule 4 of 4 in Spreadsheet Essentials.

  1. Overview and set-up

    Overview and set-up — Printing in Spreadsheet Essentials.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Printing in Spreadsheet Essentials.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Printing in Spreadsheet Essentials.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Printing in Spreadsheet Essentials.

    Lesson · Locked

    40 min

  5. Module quiz: Printing

    Check what you learned in Printing before moving on.

    Quiz · Locked

    20 min

  6. Graded project: Spreadsheet Essentials

    Apply everything from Spreadsheet Essentials in one graded, portfolio-ready build.

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: Spreadsheet Essentials 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
Daniel O., Data & analytics

Your instructor

Daniel O.

Data & analytics

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

Brian Okello, Yiga learner

“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

Spreadsheet Essentials

40 min · Resume

Course 2 in the track

Formulas & Functions

IF, VLOOKUP/XLOOKUP, SUMIFS, and more.

Beginner · Course · 3 weeks at 5 hrs/week

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

Learner reviews

What learners say.

Write a review

Sign in to share your experience with this course.

Sign in to review

Loading reviews…

Next courseFormulas & Functions

Keep going

Other courses in this track.

View full track
Formulas & Functions cover illustration
Business

16 lessons · 14h · Beginner

Formulas & Functions

IF, VLOOKUP/XLOOKUP, SUMIFS, and more.

Yiga Plus