Promptivity

Learn an Excel or PowerPoint feature step by step

For: Anyone who needs a feature today without taking a course · Facts checked: 2026-10-26 · Use case UC084

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 ↓

Try this now

  1. Say your setup. App, version (desktop, web or Mac) and your goal.
  2. Ask for the steps. Use the example request below.
  3. Practise on a copy. Never try a new feature first on the live file.
  4. Ask about the step you're stuck on. Say exactly what you see on screen.
  5. 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.

Example input · edit before use
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
Privacy: You don't need to share the real file to learn a feature; describe the columns or use sample data.

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

Free 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

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

ClaimEvidenceSourceChecked
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 synthesisSource2026-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.EditorialSource2026-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-documentedSource2026-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-documentedSource2026-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

See this guide as a sample newsletter edition

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.