Catalogue · Excel and data with AI

A PivotTable in one sentence

You create a PivotTable and its chart without going through the menus.

ExcelIntermediate0:45Capsule 7 of 11

SkillKapsul

The steps

The exact sequence, in order.

01
Describe the rows, the columns and the values you want.
02
Open the new sheet Copilot created.
03
Check the grand total.
04
Ask for a chart based on the PivotTable.

The prompt to copy

Word for word, exactly as shown in the video.

Create a PivotTable on a new sheet: stores in rows, weeks in columns, sum of amount incl. VAT.

The habit to keep

Compare the grand total with the total of your data.

Related capsules

You might also like

Open Copilot in Excel and pick a mode

You open Copilot in Excel and pick the right mode: edit, plan or just answer.

Ask your table a question

You ask your table a question in your own words and get the answer, without changing anything.

Clean up a table in one click

You fix inconsistent text and extra spaces in a list typed by hand.

Newsletter

Monday's capsule

One skill a week, straight to your inbox. The easiest way to keep learning without thinking about it.

Your data stays in the EU. Never sold.