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.

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
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.
Check your inbox
0 likesNo 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 inNo comments yet. What do you take away?