What this course is about
How to build an Excel form that fills itself in: drop-down lists, formulas, error highlighting, protection and clean printing. The AI writes the formulas and instructions; you build the form in one evening.
Supply requests, equipment handover sheets, mileage logs, leave requests: every team has forms that get filled in dozens of times a month. Usually it is a Word or Excel file where everyone writes whatever they like: misspelled item names, no totals, forgotten signatures. This course shows you how to work {AI_WITH} to turn that form into a smart Excel form: people pick from lists, totals calculate themselves, errors light up, and the printed form always looks the same.
What you will learn
- The structure of the form
- Structure: example and check
- Drop-down lists
- Dependent lists
- Formulas
- Formulas: example and check
- Conditional formatting
- Highlighting: before and after
- Protecting the sheet
- Protection: test it on a colleague
- The printed form
- Header, signatures and details
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.
- 15 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