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.

← Courses

Excel: Highlighting and Data Validation — AI Course

Use conditional formatting and validation to spot and prevent errors in your data.

≈ $3.09

245 ₽

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

How to make a spreadsheet point out problems by itself and keep errors out: highlighting deadlines and duplicates, color scales, drop-down lists, input validation and sheet protection.

In a big spreadsheet you can't spot a problem by eye: an expiring contract gets lost among a hundred rows, a duplicate number turns up only when the report is due, and someone has typed “TBD” in the Amount column. Conditional formatting and data validation solve this once and for all; you just need to set up the rules correctly. This course shows how to get exact rule formulas {AI_WITH} and how to check that they work.

What you will learn

Highlighting deadlines
Deadlines: sample rules and testing
Highlighting duplicates
Duplicates: example and similar names
Rows by condition
Rows by condition: errors and rule order
Color scales
Scales: a setup example
Drop-down lists
Lists: example and common failures
Validating numbers and dates
Input validation: example and messages

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.

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.