Yiga AI

Course 3 of 6

Pivot Tables & Charts

Pivots, Slicers, Charts, 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 hoursPivotsModule 1 of 4 in Pivot Tables & Charts.

  1. Overview and set-up

    Overview and set-up — Pivots in Pivot Tables & Charts.

    Lesson

    40 min

  2. Core concepts

    Core concepts — Pivots in Pivot Tables & Charts.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Pivots in Pivot Tables & Charts.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Pivots in Pivot Tables & Charts.

    Lesson · Locked

    40 min

  5. Module quiz: Pivots

    Check what you learned in Pivots before moving on.

    Quiz · Locked

    20 min
Module 2 · 5 lessons · 3 hours LockedSlicersModule 2 of 4 in Pivot Tables & Charts.

  1. Overview and set-up

    Overview and set-up — Slicers in Pivot Tables & Charts.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Slicers in Pivot Tables & Charts.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Slicers in Pivot Tables & Charts.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Slicers in Pivot Tables & Charts.

    Lesson · Locked

    40 min

  5. Module quiz: Slicers

    Check what you learned in Slicers before moving on.

    Quiz · Locked

    20 min
Module 3 · 5 lessons · 3 hours LockedChartsModule 3 of 4 in Pivot Tables & Charts.

  1. Overview and set-up

    Overview and set-up — Charts in Pivot Tables & Charts.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Charts in Pivot Tables & Charts.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Charts in Pivot Tables & Charts.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Charts in Pivot Tables & Charts.

    Lesson · Locked

    40 min

  5. Module quiz: Charts

    Check what you learned in Charts before moving on.

    Quiz · Locked

    20 min
Module 4 · 6 lessons · 5 hours LockedDashboardsModule 4 of 4 in Pivot Tables & Charts.

  1. Overview and set-up

    Overview and set-up — Dashboards in Pivot Tables & Charts.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Dashboards in Pivot Tables & Charts.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Dashboards in Pivot Tables & Charts.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Dashboards in Pivot Tables & Charts.

    Lesson · Locked

    40 min

  5. Module quiz: Dashboards

    Check what you learned in Dashboards before moving on.

    Quiz · Locked

    20 min

  6. Graded project: Pivot Tables & Charts

    Apply everything from Pivot Tables & Charts in one graded, portfolio-ready build.

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: Pivot Tables & Charts 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
Grace A., AI for professions

Your instructor

Grace A.

AI for professions

Shows working professionals how to use AI responsibly inside everyday workflows.

Samuel Mwangi, Yiga learner

“The examples felt relevant to public service and worked on the connection I actually have.”

Samuel Mwangi

Public service officer, Nairobi

Continue with

Your next best step.

Following the order of Excel & Google Sheets Analyst.

See the full chain

Next lesson

Overview and set-up

Pivot Tables & Charts

40 min · Resume

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

Course 6 in the track

AI in Spreadsheets

Copilot, Gemini in Sheets, Formula generation, 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 courseFormulas & FunctionsNext courseProject: Budget & Cash-Flow Model

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