Excel basics with Copilot.

For a lot of people, Excel is the app they avoid. The grid is fine, but the moment a formula is needed, the shutters come down and the spreadsheet gets handed to "whoever's good with Excel." Copilot quietly removes that wall. You can now get real answers out of your data by asking in plain English, no formulas memorised, no macros, no fear. Here's how to put it to work without overreaching.

Just ask your data a question

This is the shift that matters. Instead of working out how to calculate something, you ask. Point Copilot at a table of data and try things like:

• "Which month had the highest sales?"
• "What's the total for the east region?"
• "How many orders were over $500?"
• "Give me a quick summary of what this sheet shows."

Copilot reads the data and answers, often adding a small table or a quick breakdown. For anyone who's spent years feeling locked out of their own spreadsheets, that's a genuine unlock: the information was always there, and now you can get at it just by asking.

Simple formulas, explained

When you do need a calculation in the sheet itself, Copilot can build the formula and, crucially, explain what it does. Ask for "a formula to add up column C," or "a column that works out each sale as a percentage of the total," and it'll suggest one and tell you in plain words how it works. You get the result you need today, and you pick up a little Excel along the way instead of copying something you don't understand. Over a few weeks that adds up to real confidence.

Spotting the trend

Copilot can also help you see the story in the numbers, not just the totals. Ask what's going up or down over time, where the outliers are, or what stands out in the data, and it'll point things out you might have scrolled straight past. It can suggest a simple chart too, so a wall of figures becomes something you can actually read at a glance. For a quick read of how the month or the quarter is tracking, that's plenty.

The one habit that keeps you safe

Here's the honest bit, and it's the most important line in this lesson. Copilot is a fast, helpful assistant with your numbers, not an auditor. It can occasionally misread a column, miss a filter, or get a sum slightly off, and it'll say it with the same confidence either way. So for anything you'll actually act on, a price you'll quote, a figure for a report, a number that goes to your boss or the tax office, do a quick sanity check against the real data. Does the total look about right? Did it count the rows you meant? That ten-second look is what lets you trust Copilot for the heavy lifting while keeping the final number sound. Speed from the tool, accuracy from you.