Yiga AI

Course 6 of 11

Excel & Google Sheets for Analysts

Formulas, Pivot tables, Lookups, 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.

Introduction to SQL

Joining Data in SQL

Intermediate SQL

Window Functions & Advanced SQL

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 hoursFormulasModule 1 of 4 in Excel & Google Sheets for Analysts.

  1. Overview and set-up

    Overview and set-up — Formulas in Excel & Google Sheets for Analysts.

    Lesson

    40 min

  2. Core concepts

    Core concepts — Formulas in Excel & Google Sheets for Analysts.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Formulas in Excel & Google Sheets for Analysts.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Formulas in Excel & Google Sheets for Analysts.

    Lesson · Locked

    40 min

  5. Module quiz: Formulas

    Check what you learned in Formulas before moving on.

    Quiz · Locked

    20 min
Module 2 · 5 lessons · 3 hours LockedPivot tablesModule 2 of 4 in Excel & Google Sheets for Analysts.

  1. Overview and set-up

    Overview and set-up — Pivot tables in Excel & Google Sheets for Analysts.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Pivot tables in Excel & Google Sheets for Analysts.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Pivot tables in Excel & Google Sheets for Analysts.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Pivot tables in Excel & Google Sheets for Analysts.

    Lesson · Locked

    40 min

  5. Module quiz: Pivot tables

    Check what you learned in Pivot tables before moving on.

    Quiz · Locked

    20 min
Module 3 · 5 lessons · 3 hours LockedLookupsModule 3 of 4 in Excel & Google Sheets for Analysts.

  1. Overview and set-up

    Overview and set-up — Lookups in Excel & Google Sheets for Analysts.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Lookups in Excel & Google Sheets for Analysts.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Lookups in Excel & Google Sheets for Analysts.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Lookups in Excel & Google Sheets for Analysts.

    Lesson · Locked

    40 min

  5. Module quiz: Lookups

    Check what you learned in Lookups before moving on.

    Quiz · Locked

    20 min
Module 4 · 6 lessons · 5 hours LockedChartsModule 4 of 4 in Excel & Google Sheets for Analysts.

  1. Overview and set-up

    Overview and set-up — Charts in Excel & Google Sheets for Analysts.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Charts in Excel & Google Sheets for Analysts.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Charts in Excel & Google Sheets for Analysts.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Charts in Excel & Google Sheets for Analysts.

    Lesson · Locked

    40 min

  5. Module quiz: Charts

    Check what you learned in Charts before moving on.

    Quiz · Locked

    20 min

  6. Graded project: Excel & Google Sheets for Analysts

    Apply everything from Excel & Google Sheets for Analysts in one graded, portfolio-ready build.

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: Excel & Google Sheets for Analysts 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 Data Analyst with SQL & Power BI.

See the full chain

Next lesson

Overview and set-up

Excel & Google Sheets for Analysts

40 min · Resume

Course 7 in the track

Window Functions & Advanced SQL

RANK/ROW_NUMBER, Running totals, LAG/LEAD, and more.

Intermediate · Course · 3 weeks at 5 hrs/week

Course 8 in the track

DAX Fundamentals

Measures, CALCULATE, Time intelligence, and more.

Intermediate · Course · 4 weeks at 5 hrs/week

Course 9 in the track

Database Design Basics

Tables & keys, Normalisation, Schemas, 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 courseIntermediate SQLNext courseWindow Functions & Advanced SQL

Keep going

Other courses in this track.

View full track