Learn an Excel or PowerPoint feature step by step
The problem
You need a PivotTable or a slide master by this afternoon, and every tutorial video is 20 minutes long.
Recommended approach
Tell an AI assistant your app, version and goal, and ask for short numbered steps you can try on a copy of your file. If you have Copilot or Gemini inside the app, ask there. When a menu doesn't match, follow the vendor's official help page, which is updated with the app.
Try this now
- Say your setup. App, version (desktop, web or Mac) and your goal.
- Ask for the steps. Use the example request below.
- Practise on a copy. Never try a new feature first on the live file.
- Ask about the step you're stuck on. Say exactly what you see on screen.
- Check the official help. If a menu name doesn't match, follow the vendor's help page.
What you should get: Short numbered steps for your version and goal, with what you should see after each one.
I use [Excel for Microsoft 365 on Windows / Google Sheets / PowerPoint on Mac]. Goal: [summarize sales by region in a PivotTable]. My data: [what the columns are]. Give me numbered steps, one action per step, with the exact menu names. Tell me what I should see after each step. If menus differ by version, say so.
Check the result
- The menus named exist in your version
- The result on your copy is what you wanted
- You could repeat it next time without the AI
- Anything that didn't match was checked on the official help page
Which tool to use
Use what you already have first. These options are not ranked.
If you already have it
Use the AI built into the app you're learning
Best when: You have Microsoft 365 Copilot or Google Workspace with Gemini at work
Tools: Microsoft 365 Copilot Business, Google Workspace with Gemini
More options: plans, costs and subscriptions
Moderate: documented workflow fit; no independent head-to-head testing of these tools for this job. Prices come from each tool's record, with the date checked; always confirm on the vendor's page.
If you already have it
Use the AI built into the app you're learning
- Best when
- You have Microsoft 365 Copilot or Google Workspace with Gemini at work
- Tools
- Microsoft 365 Copilot Business, Google Workspace with Gemini
- Why it fits
- Copilot and Gemini can answer inside the app you are learning, next to your file.
- Subscription
- Only if your organization already licenses it. Don't buy it for this job alone.
- Cost (from tool records)
- Microsoft 365 Copilot Business: Promotional $18/user/month annual commitment; regular $21 shown at verification. (reported, not re-checked 2026-10-21 · source)
Google Workspace with Gemini: Workspace business pricing varies by plan; official page lists AI integrated across Workspace. (reported, not re-checked 2026-10-21 · source)
Free / already-owned option
Use one general assistant you already have (free tiers often enough)
- Best when
- You have no AI at work, or only a personal account
- Tools
- ChatGPT, Claude, Gemini
- Why it fits
- Describe your app, version and goal; check menu names against the vendor's help pages.
- Subscription
- Not required: free tiers can be sufficient; usage limits vary by plan.
- Cost (from tool records)
- ChatGPT: Free; Go $8/month U.S.; Plus $20/month. (reported, not re-checked 2026-10-21 · source)
Claude: Free; Pro $20/month billed monthly ($17/month with annual billing); Max from $100/month (U.S.). (verified 2026-10-21 · source)
Gemini: Free access plus Google AI Plus $9.99 and Pro $19.99/month U.S. (reported, not re-checked 2026-10-21 · source)
Assumptions
- You can use at least one general AI assistant (many have free tiers), or your employer already provides one.
- You are allowed to put this material into that tool. Check your workplace policy first.
Why this approach
Why it fits
- Step-by-step help fitted to your own file and goal.
- Google documents 'teach me' prompts for Gemini in Sheets.
- Official help pages are the tie-breaker when menus change.
When not to use it
- The change is to a shared or live file; practise on a copy first.
- Your organisation runs a locked or customised version; ask your IT team.
How we know
| Claim | Evidence | Source | Checked |
|---|---|---|---|
| Promptivity's own research synthesis (Research 1) lists this in its next 20 use cases to publish, drawing on published survey, behavioural and experimental studies of workplace AI use. Internal prioritization by Promptivity, not an independent evaluation and not a performance result. | Promptivity research synthesis | Source | 2026-10-26 |
| Which tools fit, and on which plans, comes from Research 2: vendor documentation plus Promptivity editorial judgement. Its rankings are editorial, not measured. No product was hands-on tested. | Editorial | Source | 2026-10-26 |
| The Google Workspace Learning Center lists example Gemini in Sheets prompts such as 'Teach me how to use conditional formatting with a color scale' and 'How can I remove duplicates?', and warns that Gemini may suggest inaccurate information. Vendor documentation, published by the vendor. Page fetched and read on 2026-10-26. Not hands-on tested by Promptivity. | Vendor-documented | Source | 2026-10-26 |
| Microsoft's Excel help & learning centre publishes official how-to articles for features such as PivotTables, XLOOKUP and drop-down lists. Vendor documentation, published by the vendor. Page fetched and read on 2026-10-26. Not hands-on tested by Promptivity. | Vendor-documented | Source | 2026-10-26 |
What we don't know yet
- No independent test measures how often AI assistants give out-of-date menu steps.
Evidence types: Vendor-documented (the vendor's own help pages) · Outside evaluation (independent published study) · Promptivity research synthesis (our own compilation of published studies) · Editorial (our judgement) · Unknown. Nothing on this page was hands-on tested by Promptivity. Revisit if credible independent testing shows one tool gives materially more accurate steps, or if a listed tool changes access or price.
How this guide was prepared
This guide is based on published sources. We have not independently tested this workflow hands-on.
Related jobs
One AI Use Case a Day
Get one useful AI use case in your inbox every day. Free.
Double opt-in: we email you a confirmation link first. Sent by Promptivity <newsletter@promptivity.ai>, once a day. Unsubscribe in one click. We never sell your address or share it with sponsors. Brevo stores and sends it for us as our data processor. When you subscribe, we may save a short label from a link used in this tab, such as X or LinkedIn, to understand how our signup links are used. Open and click tracking is optional and off unless you tick the box. How we handle your email.