Free demo · Google Sheets · Lesson 1 · Course overview

Learn Google Sheets with Gemini AI

From your first cell to pivot tables and automation: a step-by-step, animated course with worked examples, quizzes and hands-on assignments.

  1. IntroductionThe Sheets window and menus, cells and ranges, entering data, your first formula, saving to Drive, meeting Gemini27 slides
  2. BasicsFill handle, number formats, tables, SUM, AVERAGE, COUNT, absolute references, sort, filter, charts, ask Gemini42 slides
  3. IntermediateIF, SUMIFS, VLOOKUP and XLOOKUP, FILTER and UNIQUE, data validation, sharing, the AI function46 slides
  4. AdvancedPivot tables, QUERY and imports, LAMBDA, dashboards, macros and Apps Script, building and analysing with Gemini42 slides
Item | Qty | Price | Total Notebooks | 50 | 10 | =B2*C2→500 T-shirts | 12 | 100 | =B3*C3→1,200 Pencils | 50 | 5 | =B4*C4→250
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. Enrol

Tip: press → or Space to step through, ← to go back, R to replay.

About this lesson

This free demo previews MAVI Foundation's Google Sheets course. The full course runs over four levels: Introduction (the Sheets window, cells and ranges, entering data, the first formula, saving to Google Drive, opening Excel files), Basics (editing, number formats, tables, the core functions, relative and absolute references, sorting, filtering, charts and printing), Intermediate (IF, text and date functions, SUMIFS, VLOOKUP and XLOOKUP, ARRAYFORMULA, FILTER and UNIQUE, data validation, protection and teamwork) and Advanced (pivot tables, QUERY and the import functions, LAMBDA, dashboards, macros and Apps Script). Working with Gemini AI is taught in every level: asking for formulas, analysing data, the AI function, and always checking the numbers.

Key points

  • Four levels of animated slides, with quizzes
  • Every feature shown on the real Google Sheets screen
  • Gemini AI in every level, plus 20 assignments with starter workbooks