What this course is about
Describe the task in words and get a ready formula with an explanation. Conditions, counting, lookups, dates, text, fixing errors and data validation.
You do not need to remember function names or the order of arguments to write a formula. Just explain {AI_WITH} what is in your columns and what you want to get. The AI suggests a formula, explains how it works and tells you how to check it. This course has ten lessons, from simple math to drop-down lists, and each one has a prompt you can copy right away.
What you will learn
- Simple calculations
- Percentages, shares and locking a cell
- Conditions: IF and nested IFs
- Testing the formula at the boundaries
- Counting and summing by condition
- Monthly summary by site
- Looking up a value: VLOOKUP and friends
- Why VLOOKUP shows #N/A
- Dates and deadlines
- Tracking task deadlines
- Text: join, split, clean up
- Before and after: number and date from one cell
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.
- 12 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