Gemini for Sheets and Slides
Anyone who builds or consumes spreadsheets and decks: finance, operations, consultants, team leads
Prerequisites: Module 204 (Gemini in Workspace) or equivalent experience. A Workspace account with Gemini in Sheets and Slides enabled, or a personal account on a Google AI plan.
Last verified 2026-09-17
Learning objectives
By the end, participants can:
- Write an assumptions-first prompt and correct the assumptions before anything is built
- Use the Sheets panel for tables, formulas, charts and pivots (Ask Gemini in Sheets creates tables, formulas, charts and pivot tables, applies formatting and analyses data; Build mode drafts a whole spreadsheet from a prompt; native Sheets files only, so convert .xlsx first) and check the formulas, not the numbers
- Build a small multi-tab model where every input lives on one tab
- Generate a deck in Slides from a brief and named sources (generate a whole presentation from a prompt with Add sources from Drive and Match presentation style, or generate and edit single slides; desktop, English)
- Edit a generated deck slide by slide and know when to stop asking Gemini and start editing
- Say, for any spreadsheet or deck task, whether it belongs in the app panel, the Gemini app, or your own hands
What's in this module
7 lessons · 5 exercises · ~7 min reading
Starts withTwo tools, one discipline~1 minExecutive summary
You will learn how to get a real spreadsheet and a real deck out of Gemini: assumptions first, then formulas and tables in Sheets you can trust, then a deck in Slides generated from your own material and edited slide by slide. End state is one working model built from your own data with every input on an assumptions tab, and one deck generated from a brief and named sources that you have edited into something you would present. After this module you can write the prompt that makes Gemini list its assumptions before it builds, ask for formulas rather than numbers, inspect what came back, generate a deck from Drive files in your house style, and know which edits belong to Gemini and which belong to you.
Sources
- Google Docs Editors Help, "Collaborate with Gemini in Google Sheets", tables, formulas, charts, pivots, analysis, and the native-Sheets requirement: https://support.google.com/docs/answer/14356410?hl=en
- Google Docs Editors Help, "Build or edit entire spreadsheets with Gemini in Sheets", the build mode with its plan and template outline: https://support.google.com/docs/answer/16959434?hl=en
- Google Docs Editors Help, "Generate presentations with Gemini in Google Slides", whole-deck generation, Add sources, Match presentation style, and post-generation editing: https://support.google.com/docs/answer/17111393?hl=en
- Google Workspace Learning Center, "Using Google Workspace with Gemini", the per-app overview the side panel sits in: https://support.google.com/a/users/answer/15146419?hl=en
Prefer the live room?
This module also runs inside our in-person bootcamps and workshops in Copenhagen.
More in Track D
Claude for Excel
How to get real multi-tab spreadsheets with working formulas out of Cowork, with you controlling the assumptions.
AI Slides
The research-first pipeline that produces decks worth presenting, plus the brand setup that keeps a whole team on-style.
Claude Design
What Claude Design produces (sites, decks, video) and the design-system workflow that keeps output on-brand instead of generic.