Catalogue · Excel and data with AI

Ask your table a question

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

ExcelBeginner0:40Capsule 2 of 11

SkillKapsul

The steps

The exact sequence, in order.

01
Open the Copilot pane in Chat only mode.
02
Ask your question and name the columns to use.
03
Read the answer in the pane.
04
Follow up with another question in the same conversation.

The prompt to copy

Word for word, exactly as shown in the video.

Which store had the highest revenue during the pilot? Use the Store and Amount incl. VAT columns.

The habit to keep

Name the columns in your question: the answer is more reliable.

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.

Clean up a table in one click

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

ExcelIntermediate

Remove duplicates and split names

You remove duplicates from a list and split title, first name and last name in one request.

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.