What this course is about
Turn a raw table into a PivotTable, a clear chart and a short explanation of the numbers. Plus a template that you refresh next month with one click.
Your manager asks for "a report on requests for the quarter", and you have a log of two thousand rows. An Excel PivotTable turns it into a report in a few minutes, but many people are afraid of it: it is not clear what to drag where. In this course {AI} acts as a patient mentor: from a description of your columns, it suggests which PivotTable to build, which chart to choose, how to title it with a conclusion and how to explain the numbers in words.
What you will learn
- Your first PivotTable
- Example: requests by district
- Grouping by month and year
- Comparing months across two years
- Several measures
- Example: purchases by supplier
- Filters and slicers
- Example: a dashboard for your manager
- Choosing a chart
- Before and after: a chart by topic
- Conclusion titles and labels
- Checking that the conclusion is true
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