/pivot

Walks you step by step through building a pivot table.

The full prompt

/pivot Walk me step by step through building a pivot table in [Excel or Google Sheets]. My columns are: [column names]. The question I want answered: [question]. Tell me exactly what goes in Rows, Columns, Values, and Filters, and how to summarize the values (sum, count, or average).

Replace the highlighted [brackets] with your own details, then send.

What you're asking

You ask for click-by-click pivot table steps. You get where each field goes and how to summarize it.

Give it

  • Excel or Google Sheets
  • Your column names
  • The question you want answered

Check: Menu names vary by app version; if a step doesn't match your screen, tell the AI what you see.

Filled-in example

/pivot Walk me step by step through building a pivot table in Excel. My columns are: Date, Region, Product, Sales. The question I want answered: total sales by month and region. Tell me exactly what goes in Rows, Columns, Values, and Filters, and how to summarize the values (sum, count, or average).

Use it in any AI chat. The slash word is a label, not a built-in command; the prompt does the work, and answers vary by app. How these work