Practice: Real Workplace Scenarios

Let's put everything together with hands-on exercises based on real workplace situations. Complete these to solidify your AI + Google Workspace skills.

Exercise 1: Sales Report Formula

Your manager asks for a quick sales breakdown. Write a prompt to get the formula.

Exercise 2: Data Cleanup

You received a messy contact list. Write a prompt to clean it up.

Exercise 3: Document Summary

You need to summarize a long report for your team. Write the prompt.

Quick Reference Card

Save this template for your daily Google Workspace AI interactions:

FOR FORMULAS:
My Google Sheet structure:
- Column A: [description]
- Column B: [description]
Data range: Rows 2 to [X]
Goal: [What to calculate/find?]
Please give me a Google Sheets formula for cell [X].

FOR DATA CLEANUP:
Column [X] has messy data. Examples:
- '[example 1]'
- '[example 2]'
Desired format: [describe clean format]
Give me an ARRAYFORMULA for the whole column.

FOR DOCUMENTS:
Summarize/Draft [type of document]
Audience: [who will read it]
Format: [bullets, paragraphs, sections]
Tone: [formal, casual, technical]
Length: [word count or page limit]

Congratulations!

You've completed the AI for Google Sheets & Docs course. You now know how to:

• Get AI to write Google Sheets formulas from plain English
• Clean and standardize messy data with AI-generated formulas
• Draft and summarize documents in Google Docs
• Automate repetitive categorization and formatting tasks
• Use Google's built-in AI features and add-ons

Next step: Open your most-used Google Sheet and try asking AI to automate one task you've been doing manually.