Excel & Copilot for Business Users

Excel scares people because it looks like an endless grid with a thousand mysterious functions. In reality, you can do most everyday business work with one good habit and a handful of formulas — and now, with Copilot in Excel, you can even ask the spreadsheet questions in plain English. This module covers the few things worth knowing and the one rule that keeps you safe.

Start with a table

Before any formula, get into the habit of turning your data into a proper table (select your data and press Ctrl+T). A table is more than a tidy grid: it gives your columns real names, grows automatically when you add rows, and makes every formula easier to read and far less likely to break. Most spreadsheet disasters trace back to data that was never made into a table. Think of it as laying a clean foundation before you build.

Three formulas that do most of the work

You do not need to memorise hundreds of functions. Three cover an enormous share of real tasks:

• SUMIF adds up numbers, but only the ones that meet a condition. “Total sales, but only for the North region” is a SUMIF. In plain English it means “add this column, where that column equals something.”
• XLOOKUP finds a matching value in another list and pulls back the detail you want. Given an employee ID, it fetches the person’s name; given a product code, it fetches the price. It is the modern, friendlier replacement for the old VLOOKUP, and it means “look this up over there and bring back the answer.”
• A pivot table is a drag-and-drop summary machine. You point it at a long list of transactions and it instantly groups them — sales by month, headcount by department, spend by supplier — with no formulas at all. When someone asks “can you break that down by region and quarter?”, a pivot table is the answer.

Copilot in Excel

Copilot is the AI assistant built into Microsoft 365, and inside Excel it lets you talk to your data. With your data in a table, you can open the Copilot pane and type a request in ordinary words: “What were our total sales by region?” “Highlight the months where spend went up.” “Add a column showing each row as a percentage of the total.” “Create a chart of revenue over time.” Copilot then writes the formula, builds the pivot table, or draws the chart for you, and it can explain its reasoning if you ask.

The appeal is obvious: it removes the “I don’t know which function to use” barrier. You describe the answer you want, and Copilot handles the mechanics. For summarising a messy sheet or spotting a trend, it can save real time.

The one rule: verify

Here is the catch you must never forget. Copilot is confident even when it is wrong. It can misread which column you meant, total the wrong range, or summarise data in a subtly misleading way — and it will present the result with total assurance. So always check the work. Spot-check a few numbers by hand, glance at the formula it inserted, and ask yourself whether the answer is roughly the size you expected. Treat Copilot like a fast, eager junior analyst: wonderful for a first pass, never to be trusted blindly on anything that matters.

Rule of thumb: let Copilot do the work, but you sign off on the numbers — never send a figure you haven’t sanity-checked.

Spot it: Which Excel tool fits?

Read each task and decide for yourself, then tap a card to flip it and check your answer.

Sort the Excel tasks

Drag each task into the bucket that solves it best — or tap an item, then tap a bucket. Hit Check placement when you’re done.

How to use it

Make a table first, every time — it pays off immediately. When you need a conditional total, reach for SUMIF; when you need to pull a detail from another list, use XLOOKUP; when someone wants a breakdown, build a pivot table. Lean on Copilot to draft formulas and summaries, then verify before you trust. Useful phrases: “Let me turn this into a table first.” “I’ll pivot that to show it by month.” “Copilot drafted this — give me a second to sanity-check the totals.” Saying that last one out loud marks you as someone who uses AI well rather than someone who gets caught out by it.