GuidesBy professionFinance analysts and controllers building calculated columns

Describing a formula column in Excel, then verifying it

For Finance analysts and controllers building calculated columns.

Copilot in Excel can create new columns that calculate values from your existing data and explain how each formula works. It is fast for a first pass, and the numbers only become trustworthy once an analyst reconciles a few rows and a controller reviews it before it feeds a report.

When to use this

You need a margin, a running total or a reconciliation column across a large table, and you would rather describe what you want than hand write the formula.

Turns a plain description of a column into a formula plus an explanation
Creates new columns or rows that calculate values from your existing data
Explains how each formula works so you can check the logic, not just the result

Workflow

Open the table in Excel and make sure your data is in a proper table
Describe the column you want in plain words, such as gross margin per row or running total by month
Read the formula and the explanation Copilot returns, not only the numbers
Reconcile a few rows by hand against the source before you rely on the column
Have a controller review the column before it feeds any report

Prompts to try

Use it, adapt it, and make it your own.

Add a column that calculates [gross margin] for each row using [revenue] and [cost]. Show me the formula you used and explain in one line how it works, so I can check it against our source figures before I rely on it.

Ask Bit to adapt it →

Human lens

You reconcile a handful of rows by hand against the source figures
A controller reviews the column before it feeds a report
You own the tie between the calculated result and where the numbers came from

What to avoid

A plausible but wrong formula is a reporting risk, so tie results back to source
Fast output is easy to trust without checking, so reconcile before it feeds a report
As with any AI generated content, review, edit and verify anything Copilot creates for you

Related guides

View all →

AI for data analysts who need the numbers to hold up

Use AI to sharpen the question, inspect data and challenge explanations, while you keep the definitions, validation and recommendation.

AI for centre managers who still carry the responsibility

Use AI to organise information, compare operational options and prepare useful artefacts. Keep child safety, adequate supervision, family relationships, educational judgement and consequential people decisions with the authorised human.

AI for marketing teams that still need people to believe the message

Use AI to explore evidence and create distinct first drafts, while you keep the positioning, claims and audience relationship.

AI for HR and recruiting teams that still make the people decision

Use AI to structure role information and prepare comparable first passes, while people retain fairness, context, privacy and every employment decision.