What this course is about
How to use an AI assistant to design a shared spreadsheet where five people work at once without getting in each other's way: roles, lookup lists, rules, data checks and a summary for your manager.
A shared online spreadsheet works fine while two people use it. When ten people do, the same column fills up with "Smith", "smith" and "J. Smith", dates typed as text, and formulas wiped out by accident. This course shows you how to work {AI_WITH} to plan the structure, access, lookup lists and rules in advance, so the spreadsheet stays clean six months from now. It works for Google Sheets, Excel for the web and any other online spreadsheet your organization uses.
What you will learn
- The structure of a shared spreadsheet
- Structure: example and review
- Access and roles
- Access: check and housekeeping
- Lookup lists and drop-downs
- The status list: before and after
- Rules for filling it in
- Rules: example and a test on a colleague
- Data checks
- Checks: example and test
- Version history
- Case study: a missing row
What's inside
- Four PDF versions of the course: for ChatGPT, Gemini, Claude and Microsoft Copilot — each explains where to find the features you need in that assistant.
- 13 ready-to-use prompts and a prompt library you can copy from.
- Step-by-step tasks, before-and-after examples and a one-page cheat sheet.
- Free updates when the AI assistants change.
Who it's for
Office workers, managers, teachers, freelancers and small-business owners who want practical results from AI without technical knowledge.
KHIZHNYAKOV