Mint's "AI Tool of the Week" column, written by Jaspreet Bindra and Anuj Magazine of AI&Beyond, featured the feature this week. Microsoft's own documentation supports most of the column's description. It also adds a few caveats that the newsletter's "repeat exactly" framing leaves out.
What Skill Builder actually is
A skill is a set of saved instructions for a repeatable job. In June 2026, Microsoft said skills let teams define how Copilot should handle common processes, and it named examples such as building a DCF, closing the books, refreshing a monthly reporting model and preparing a variance analysis. Microsoft says "a skill guides Copilot through the steps, applying the right structure and formatting," so the output is easier to review and reuse.
At first, making a custom skill meant writing the file yourself. Microsoft said you could build your own custom skills using an open-standard markdown file, then save a SKILL.md file in your OneDrive, and Copilot will pick it up.
Skill Builder skips the hand-written file. In Microsoft's words, you can use skill-builder to create custom skills from your instructions, previous prompts, or examples of completed work. You can also complete a multistep workflow with Copilot and then ask Copilot to save it as a skill. Microsoft says the tool captures the relevant context, steps, decision logic, and expected output.
In short: Skill Builder turns a conversation, or work you've already done, into a SKILL.md file without you having to write any YAML.
How to use it: a monthly variance pack
Here is the documented flow, using the finance example from Mint's column.
- Open Copilot in Excel. Microsoft's getting-started guide says to select the Copilot icon in the lower-right corner of Excel. Copilot opens in edit mode by default, which lets it change your workbook directly.
- Do the work once, or describe it. For example: compare actuals to budget by cost centre, add variance and variance-percentage columns, and explain the three largest movements.
- Save it as a skill. Microsoft's support page gives two sample prompts: "Save what we just did to a new skill," or a fresh request such as "Create a skill that formats monthly sales reports as tables, highlights negative variances, and adds a summary chart." You can also start with
@skill-builder. Microsoft lists it as the way to turn recurring workflows into custom skills. - Add formatting rules. Mint's example adds bold headers, thousands separators and a three-line commentary above the table.
- Check the preview before saving. Before saving the skill to OneDrive, Copilot lets you preview and refine it. After you approve the skill, Copilot saves and verifies it. This is where you'd add something like a prior-year comparison column.
- Use it next month. Open the new workbook and type
@followed by the skill's name. Microsoft's general rule is to enter @ followed by the skill name in your prompt to Copilot.
If you don't want to type, there's a menu route: select Add in the prompt field, then Choose plugins and skills.
Making Copilot use a skill without being asked
A custom skill works by @mention straight away. If you want Copilot to pick it up automatically when it fits the task, switch it on under Settings (…) > Manage plugins & skills. Microsoft notes that turning a skill off only stops Copilot from using it automatically. You can still call a disabled skill directly with an @mention.
Where skills live and what "open format" means
Custom skills are saved to a dedicated folder in your OneDrive. Each skill has its own folder with a plain-text SKILL.md file in it. That file has two parts:
- Frontmatter (between
---delimiters): this part is required. It holds the skill's name and a description that tells Copilot when to use it. - Body: free-form instructions for how to do the task. Microsoft sets no format restrictions here.
A few housekeeping details from Microsoft's documentation are worth knowing:
- Folder name must match. The folder name has to match the
namein SKILL.md. Copilot skips any folder whose name doesn't match, which also gives you a quick way to hide a skill without deleting it. - Refresh after manual edits. If you add or rename a skill in OneDrive yourself, select Refresh in the Custom skills dialog so Copilot sees the change.
- Optional extras. Skills can also include
scripts,referencesandassetsfolders. Microsoft says custom skills that include scripts, references, or assets help Copilot produce more predictable results.
You can still write skills by hand. Go to Settings > Manage plugins & skills > Custom skills > Create OneDrive folder > Open skills folder, then drop your skill folders in. That's useful if your organization already has standard skills it wants everyone to use.
Not everyone finds this smooth. One Microsoft 365 Copilot newsletter writer who uploaded hand-built skills said Copilot in Excel does not make this easy, and I hit some errors — naming mismatches. Skill Builder should avoid most of that, because it writes the file for you.
In short: Skills are plain, editable Markdown files stored in your OneDrive. You can read them, version them and share them, so they aren't locked inside an opaque blob.
Availability: rolling out, not everywhere yet
Even if a skill is perfectly built, the feature itself may not show up in your Excel yet. Microsoft's support page says Skill Builder is enabled by default in Copilot in Excel, but also warns that it is rolling out to production and may not be available for all customers. If @skill-builder doesn't appear, your account may simply not be in the rollout yet.
Some background on the timeline: when Microsoft announced custom skills in June, it said they were available today via the Insiders channel for Windows and Mac, and rolling out to general availability across Excel for Web, Windows, and Mac next month. Skill Builder is the conversational layer added on top of that.
Copilot in Excel itself also needs an eligible plan. Microsoft lists four:
| Access route | Notes |
|---|---|
| Microsoft 365 Personal or Family | Requires an AI credits plan |
| Microsoft 365 Premium | Included |
| Commercial Microsoft Copilot subscription | Labelled "M365 Copilot (Premium)" in-product |
| Copilot Chat-eligible Microsoft 365/Office 365 business or enterprise | Standard access, labelled "Basic" |
For business users, tenant configuration can also affect what you get. Microsoft says Copilot in Excel is a Copilot Chat tool and can't be turned off independently, so the admin settings that control Copilot Chat access apply to it too.
Developers will see a different label in Microsoft Learn: Office.js-based custom skills for Excel are listed there as preview. Microsoft's custom functions tutorial says they require version 2608 (Build 20305.20002) or later on Windows, or version 16.112.26070718 or later on Mac. That covers developer-built skills packaged as Microsoft 365 apps, not the everyday Skill Builder flow, but it helps explain why two Microsoft pages can describe "skills" differently.
The catch: "repeat exactly" is too strong
Mint's column says skills "reapply the same structure and formatting every month." That's what a skill is meant to do. It isn't guaranteed. A skill is a set of instructions, and Copilot still generates the results each time. Microsoft's FAQ is blunt about it: Copilot can sometimes make mistakes, misinterpret information, or produce inaccurate results and users should avoid relying on it for decisions in sensitive areas such as finance.
Microsoft's accounting-skills documentation goes further. It says Copilot doesn't replace your organization's internal controls, review or approval processes, and that you should check every calculation and account mapping against source records before sharing financial information.
For a pack going to the CFO by the fifth working day, that leaves you with a short checklist:
- Check the formulas. A skill can tell Copilot how to calculate variance percentage, but you still need to confirm it used the right base and sign convention.
- Check the source ranges. If next month's export has an extra column, a skill written around named columns may point at the wrong data.
- Check the commentary. Text explaining the "three largest movements" needs to match the actual numbers.
- Set calculation to Automatic. Copilot editing is only supported when Calculation Options are set to Automatic.
- Be careful with shared files. Copilot's edits are visible to anyone with access to the workbook, including people co-authoring it. You can undo changes or restore an earlier version. Microsoft's tips page also suggests turning off autosave if you want to experiment without saving the changes.
What IT administrators need to know
Admins will reasonably ask whether user-written Markdown files can run code. Microsoft says skills do not introduce a new code-execution mechanism to Excel, and any scripts inside a skill are resources for Copilot's existing, authorized tools. They don't give Copilot any extra abilities. That's reassuring, but it doesn't replace reviewing your data policies, because skills stored in OneDrive can be shared and copied like any other file.
How to write a skill that holds up month to month
Microsoft's general Copilot tips apply here: be specific, name the columns or ranges, and refine with follow-up prompts. For a variance skill, that means writing down:
- The source columns, and what to do if one is missing
- The formulas for absolute and percentage variance
- The threshold for what counts as a movement worth explaining
- The comparison periods (budget, prior year, forecast)
- The output layout, chart type, number formats and commentary length
Microsoft also has a built-in variance-analysis skill in its Accounting set. It is rolling out to the Frontier early-access program, so check whether you have it before building your own from scratch.
Bottom line: Skill Builder gets rid of writing SKILL.md by hand, and the files it produces are plain Markdown in your OneDrive that you can read and edit. It can cut the setup work on a recurring Excel report considerably. You still need to check the numbers before the report goes out.
References
- AI Tool of the Week: this Copilot feature can automate your monthly Excel reports Livemint · 2026-10-31T01:30:55+00:00
- excel copilot custom functions skill learn.microsoft.com
- Copilot in Excel: Built for the era of Frontier Finance microsoft.com