This page was translated from Dutch with AI.

Let your AI calculate on the real data

You receive an Excel file from someone else. It is full of tabs, and tomorrow you need to be able to say something sensible about it. So you copy the table into a chat and ask for an analysis. That goes quickly, and the answer usually sounds very convincing. Only you do not always know how your AI gets those numbers.

In a workshop about Copilot I showed how that works in Excel itself. I had a file that was not mine, and I just wanted to get insight into it. What Copilot does with that is, I think, something too few people know. And it changes how you give numbers to your AI.

At the bottom of this article you will find a prompt that lets your AI calculate on your file itself. Feel free to copy it.

Cartoon
Laat je AI rekenen op de echte data: een chat raadt, een script rekent

A language model guesses, also with numbers

A language model predicts text. It does that very well, and that is why an analysis in a chat sounds so fluent. If you paste a table into a chat, that table is in the context window. And then the model actually tries to guess what is there and what the sum is. With a small list that usually goes well. With a large file with many columns it becomes a guess, and you do not see where it goes wrong.

It is a bit ironic. We have used computers for decades to calculate. And now we have one that first has to learn to hold a calculator.

This is how it works in Excel itself

In Excel you choose an analysis of your entire workbook with Copilot. Copilot then looks at all the tables in it, and creates a new tab with what it finds. You can also ask it to put things in colour, create a pivot table or draw a chart. Actually it can do everything you can do in Excel.

You do not see the most important thing. It does that analysis via a script, on the data that is really in your file. So it gets to work with the actual data, instead of guessing what is there in its context window. The calculation happens in the background. And that is of course good, because we do not want it to start hallucinating about our Excel tables.

If you are not satisfied with the result, you just give feedback. Adjust this, add that, show it per month. What you used to spend hours on, you now ask in a few sentences.

Frequently asked questions

Why should I not just paste numbers into a chat?

Then they are in the context window and the model tries to guess what is there. With a large file that becomes a guess. Rather let your AI calculate with a script or with formulas on the file itself.

Does Copilot in Excel calculate on the real data?

Yes, Copilot does its analyses in Excel via a script on the data in your workbook. The calculation happens in the background, on the actual data. If you are not satisfied, you give feedback and it adjusts it.

Is it better to give my AI an Excel file or a CSV?

That depends on what you want to do next. For a lot of data that you want to process further, CSV is more convenient, because your AI does not need the layout. If you want to end up with an Excel to continue working in, ask for formulas.

Where can I learn this hands-on?

In Work smarter with Copilot in M365 you work yourself with Copilot in Excel, Word and Outlook. If you prefer to work with Claude, there is Claude AI Power User. You will find the dates at Workshops & Events.

Keep reading for free

Register free with your e-mail address and read on. Your account opens the free articles in the learning space; the rest is for subscribers, from Learn Plus up.

Already registered? No account yet?

No comments yetRead the comments

Comments

Members comment here and read each other's comments. Register for free or sign in to join the conversation.

Register for free or sign in

No comments yet. What do you take away?

    QR code of this page

    coachsteff.live/en/laat-je-ai-rekenen-op-de-echte-data

    Scan with your phone to open the page.