Catalogue · Excel and data with AI

A calculated column, with its formula explained

You add a calculated column in one sentence and understand the formula behind it.

ExcelIntermediate0:48Capsule 5 of 11

SkillKapsul

The steps

The exact sequence, in order.

01
In Allow editing mode, ask for the column with the calculation you want.
02
Check the new column, then click Done.
03
Select a cell in the column.
04
Ask Copilot to explain the formula, step by step.

The prompt to copy

Word for word, exactly as shown in the video.

Add a Margin column that calculates Amount incl. VAT minus Quantity times Unit cost.

The habit to keep

If you don’t understand a formula, don’t keep it.

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.