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.
- IntroductionThe Sheets window and menus, cells and ranges, entering data, your first formula, saving to Drive, meeting Gemini27 slides
- BasicsFill handle, number formats, tables, SUM, AVERAGE, COUNT, absolute references, sort, filter, charts, ask Gemini42 slides
- IntermediateIF, SUMIFS, VLOOKUP and XLOOKUP, FILTER and UNIQUE, data validation, sharing, the AI function46 slides
- AdvancedPivot tables, QUERY and imports, LAMBDA, dashboards, macros and Apps Script, building and analysing with Gemini42 slides