Yiga AI

Course 6 of 6

AI in Spreadsheets

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

Yiga AI

Beginner en

Beginner · Course · 3 weeks at 5 hrs/week

Duration
3 weeks
Effort
5 hrs/week
Lessons
17
Hands-on exercises
17
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 · 22 lessons · 14 hours · 1 graded project

848 minutes of guided lesson time.

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

Module 1 · 6 lessons · 3.1 hoursCopilotModule 1 of 4 in AI in Spreadsheets.

  1. Quick start: clean a messy spreadsheet with AI

    A 5–10 minute win you can use today.

    Lesson

    8 min

  2. Overview and set-up

    Overview and set-up — Copilot in AI in Spreadsheets.

    Lesson · Locked

    40 min

  3. Core concepts

    Core concepts — Copilot in AI in Spreadsheets.

    Lesson · Locked

    40 min

  4. Worked example

    Worked example — Copilot in AI in Spreadsheets.

    Lesson · Locked

    40 min

  5. Hands-on practice

    Hands-on practice — Copilot in AI in Spreadsheets.

    Lesson · Locked

    40 min

  6. Module quiz: Copilot

    Check what you learned in Copilot before moving on.

    Quiz · Locked

    20 min
Module 2 · 5 lessons · 3 hours LockedGemini in SheetsModule 2 of 4 in AI in Spreadsheets.

  1. Overview and set-up

    Overview and set-up — Gemini in Sheets in AI in Spreadsheets.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Gemini in Sheets in AI in Spreadsheets.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Gemini in Sheets in AI in Spreadsheets.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Gemini in Sheets in AI in Spreadsheets.

    Lesson · Locked

    40 min

  5. Module quiz: Gemini in Sheets

    Check what you learned in Gemini in Sheets before moving on.

    Quiz · Locked

    20 min
Module 3 · 5 lessons · 3 hours LockedFormula generationModule 3 of 4 in AI in Spreadsheets.

  1. Overview and set-up

    Overview and set-up — Formula generation in AI in Spreadsheets.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Formula generation in AI in Spreadsheets.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Formula generation in AI in Spreadsheets.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Formula generation in AI in Spreadsheets.

    Lesson · Locked

    40 min

  5. Module quiz: Formula generation

    Check what you learned in Formula generation before moving on.

    Quiz · Locked

    20 min
Module 4 · 6 lessons · 5 hours LockedAnalysisModule 4 of 4 in AI in Spreadsheets.

  1. Overview and set-up

    Overview and set-up — Analysis in AI in Spreadsheets.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Analysis in AI in Spreadsheets.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Analysis in AI in Spreadsheets.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Analysis in AI in Spreadsheets.

    Lesson · Locked

    40 min

  5. Module quiz: Analysis

    Check what you learned in Analysis before moving on.

    Quiz · Locked

    20 min

  6. Graded project: AI in Spreadsheets

    Apply everything from AI in Spreadsheets in one graded, portfolio-ready build.

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: AI in Spreadsheets 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

Quick start: clean a messy spreadsheet with AI

AI in Spreadsheets

8 min · Resume

Learner reviews

What learners say.

Write a review

Sign in to share your experience with this course.

Sign in to review

Loading reviews…

Previous courseData Cleaning & Validation

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
Formulas & Functions cover illustration
Business

16 lessons · 14h · Beginner

Formulas & Functions

IF, VLOOKUP/XLOOKUP, SUMIFS, and more.

Yiga Plus