KHIZHNYAKOV

← Courses

Excel Formulas from a Description — AI Course

Describe what you need in words and let AI write and explain the right Excel formula.

Excel Formulas from a Description — AI Course
≈ $4.99
395 ₽
ZIP with 4 PDF versions: ChatGPT, Gemini, Claude, Copilot · ready-to-use prompts · free updates
Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

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.

Questions and answers

Which AI assistant do I need?
Any of the four: ChatGPT, Gemini, Claude or Microsoft Copilot. The free plan is enough for most tasks; each PDF version notes where a paid plan helps.
What format is the course?
A ZIP archive with four PDF files, one for each AI assistant. Read on screen or print.
Do I need technical skills?
No. Every lesson shows the exact prompt to copy and an example of a good result.
Can I use the prompts at work?
Yes. Just never paste personal or confidential data into an AI assistant — the course explains how to anonymize documents.