Catalogue · Excel and data with AI

Highlight, sort and filter

You make the biggest sales stand out, then sort and filter the table in a few sentences.

ExcelBeginner1:08Capsule 6 of 11

SkillKapsul

The steps

The exact sequence, in order.

01
Ask Copilot to color the highest amounts.
02
Ask it to sort the table, largest to smallest.
03
Ask it to filter on one city.
04
Clear the filter, naming the column, to see everything again.

The prompt to copy

Word for word, exactly as shown in the video.

Make the 10 highest amounts incl. VAT bold and highlight them in green.

The habit to keep

One request per move: color, sort, then filter.

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.