About this lesson
Gemini is Google's AI assistant, built into Google Sheets on eligible Google Workspace and Google AI plans. The Ask Gemini button at the top right opens a side panel where you describe what you need: a formula, a table, a chart, a pivot table, conditional formatting or a summary of the data. For a formula, Gemini answers with the formula and a short explanation, and Insert places it in the selected cell. AI can be confidently wrong, so the course teaches one rule from the first level: never trust a number you did not check. Test an AI formula against the quick sum or against two rows you can work out by hand, and keep private data such as phone numbers out of your prompts. The full course goes on to the AI function, =AI("prompt", range), Fill with Gemini, analysis and charts on demand. Without a Gemini plan you can ask the free Gemini app for the formula and paste it into Sheets.
Key points
- Ask in plain words: what you want and which column
- Read the explanation, then Insert
- Never trust a total you did not check