Clean Up Messy Spreadsheets with Copilot in Excel’s New Skills

by | Nov 2, 2026 | AI, IT News & Insights New Zealand | Cybersecurity, AI & Microsoft Updates, TIPS TRICKS AND HINTS

Most spreadsheets that cause trouble don’t have bad formulas. They have bad data, that confuses your formulas or tables.   Examples are things like a customer name with a trailing space, a date typed in as text, an invoice number stored as a number in one row and as text in the next. The lookup returns #N/A, the PivotTable shows the same client twice, and someone loses an afternoon working out why.

Microsoft’s October 2026 Excel update, addresses that problem. Copilot in Excel now has “skills”: packaged instructions for particular jobs that you call up by name. Two of them are worth experimenting with.

Scattered number tiles forming a neat grid, representing cleaned spreadsheet data

Clean data

The “clean-data” skill checks your data for extra spaces, inconsistent text and number formats, inconsistent dates, duplicate values and values stored as the wrong data type. According to Microsoft, it explains what it found and why it matters, then proposes corrections in the workbook. You review the suggestions and pick which ones to apply.

To use it, open Copilot in Excel and type @clean-data in your prompt. You can also find it by selecting the Add menu in the prompt box, then Choose plugins and skills. A prompt such as “@clean-data check the customer list on Sheet1 before I build a pivot table” gives it enough to go on.

It’s a good habit to try out before month-end reporting, before merging two exports from different systems, or on any list that several people have edited over a few years.

Teaching Copilot your routine

The second skill, skill-builder, is for the jobs you do the same way every week. You can describe the task, hand Copilot some previous prompts or an example of finished work, or simply do the task with Copilot and then ask it to “save what we just did to a new skill”. Microsoft’s own example is a skill that formats monthly sales reports as tables, highlights negative variances and adds a summary chart.

Copilot lets you preview and refine the skill before it’s saved. Custom skills are stored in a folder in your OneDrive, and you can switch them on or off from the … menu in the Copilot pane, under Manage plugins & skills. Turning a skill off stops Copilot using it automatically, but you can still call it with an @mention.

Under the hood, each custom skill is a folder containing a SKILL.md file with a name, a description of when to use it, and the instructions. Microsoft describes this as the industry standard format for skills, so a skill written by one person in your organisation can be copied into a colleague’s skills folder.

A related feature, skill recorder, watches you work through a recurring task and turns the steps into a skill. For now it’s with Insiders on Windows and Mac, and generally available in Excel for the web.

Skills for finance teams

Microsoft has also published a set of accounting skills, including reconciliation, variance-analysis, close-management and journal-entry.

These are rolling out first through Microsoft’s Frontier early-access programme. They’ll be generally available later.

Note that Microsoft’s documentation is plain that Copilot doesn’t give accounting, tax or audit advice, and that output should be checked against source records before anyone posts an entry or files a return.

Name your tables as you create them

When you press Ctrl+T, or go to Insert > Table, the Create Table dialog in Excel for Windows and Mac now has a box for the table name. It was an Insider feature in September and became generally available in the October update.  This is regular Excel, not Copilot. 

Named tables are easier to find in the Name Box and easier to read in formulas: =SUM(Sales[Amount]) tells you far more than =SUM(C2:C418). They’re also easier for Copilot to work with when you ask it about “the Sales table”. It takes five seconds when you create the table and saves a lot of guessing later.

A few caveats

Microsoft notes that clean-data and skill-builder are still rolling out and “may not be available for all customers”, so if you can’t see them yet, check again in a few weeks. The Copilot features also depend on Copilot in Excel being available in your Microsoft 365 setup. And as with anything Copilot produces, review the proposed changes before you accept them, particularly on data that feeds invoices or payroll.