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.

3 min read
5 steps
1 prompt to copy

The 2-minute version

Use it when 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

In short

What this helps you do: 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.
What you leave with: A draft formula column with sample rows and totals to reconcile.
What to check before trusting it: You reconcile a handful of rows by hand against the source figures

Ask Bit to set up this workflow

Workflow

0 of 5 done

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

Prompt to try

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

Prompt

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 accountants and bookkeepers who still sign off the numbers

Use AI to draft client communication, summarise financial documents and organise your workload faster, while every figure, reconciliation and piece of advice is still checked and owned by you.

Letting an AI agent deflect routine tickets and hand off the rest safely

Intercom's Fin answers routine queries from the knowledge sources you connect and hands off to a person when that is the safest option. Support keeps ownership of which sources Fin can draw on, and sensitive cases route to a human rather than to the agent.

Producing dozens of localised on-brand variants in an afternoon

Canva Bulk Create maps a data file onto one master template and turns each row into one complete design. It is a real time saver for localising an asset across many branches, and the accuracy of the whole set rests on proofing the source data first, because a wrong value copies to every variant.

Building no-code intake routing an ops lead owns

Asana AI Studio is a no-code builder where you can design AI-powered workflows that handle intake, routing and alerts. An ops lead sets the trigger and writes the rules in plain language, and keeps a human approval step over anything with cost, contract or customer impact.

Reviewed 18 August 2026