What this course is about
How to build a log or register in Excel with AI that does not fall apart: well-planned columns, drop-down lists, deadlines, numbering, totals and protection against input errors.
An incoming mail log, a contract register, a record of requests, issued certificates or safety briefings: almost every organization keeps tables like these in Excel. Most of them grow by accident. Columns get added along the way, dates are typed any old way, numbers repeat, and at the end of the year someone counts the totals by hand. This course shows how to work {AI_WITH} to design a log properly once and then keep it without hassle.
What you will learn
- The log's columns
- Checking the header row
- Table format
- Dates as text and other format traps
- Drop-down lists
- Lists: example and cleanup
- Dates and deadlines
- Deadlines: sample formulas and a test
- Numbering
- Numbering: example and duplicate check
- Totals and summary
- Summary: example and a note for your manager
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