Copilot for Excel: Beginner Skills

Key insights

• Copilot Skills: The video shows that Copilot Skills are reusable, task-specific instructions you teach Copilot to run inside Excel.
  They speed up tasks like cleaning data, building charts, and preparing dashboards by running the same steps consistently.
• Built-in skills vs custom skills: Excel includes documented built-in skills for common tasks and a preview path for custom skills you create.
  Custom skills require newer Excel builds and let you tailor behavior for specific workflows.
• Add work content and @mentions: You run a skill from the Copilot prompt by choosing Add work content → Choose plugins & skills or by typing an @mention for the skill name.
  The video demos both picking built-in skills and invoking custom ones directly.
• SKILL.md and scripts: Custom skills use a SKILL.md file with YAML metadata (including an excel tag) and optional JavaScript in a scripts folder.
  These files define how the skill behaves and what it can change in the workbook.
• OneDrive and AutoSave requirements: To use or add custom skills you place them in a OneDrive skills folder and keep the workbook saved in the cloud with AutoSave on.
  Copilot works best when your data is in a proper table.
• Repeatable workflows and reliable results: Skills let you teach Copilot a process once and reuse it to get consistent outputs.
  Practical examples in the video include cleaning messy project data and applying chart designs so results appear directly in the workbook.

Introduction: What the video covers

The YouTube video by Lisa Crosbie [MVP] introduces viewers to Copilot Skills in Excel, a way to teach Copilot repeatable workbook tasks. In clear steps, she shows how to use built-in options and how to create custom skills so Copilot follows the same instructions every time. Consequently, the video aims to help people save time on chores like cleaning data, building dashboards, and designing charts. Overall, the presentation targets beginners and focuses on practical actions rather than technical theory.

How Copilot Skills work in Excel

Lisa explains that a skill is essentially a reusable instruction set that Copilot can apply to a workbook, and she demonstrates how to access skills from the Copilot prompt via Add work content or by typing an @mention. Additionally, she highlights that custom skills live in a OneDrive folder and must follow a defined structure so Excel can find and run them. For many tasks, the result appears directly in the spreadsheet rather than only in chat, which helps keep outputs where users expect them. Therefore, skills are designed to act on workbook content, not just to produce text answers.

Demonstrations and practical examples

Throughout the video, Lisa uses hands-on demos to show a variety of built-in and custom skills, including a unit economics example and a chart design skill that standardises visuals across sheets. She also walks through creating a custom skill and enabling a sample "Make Calendar" skill, so viewers can see the folder-based setup and the moment the skill runs inside Excel. Moreover, the presenter cleans and standardises messy project data to show how skills improve consistency when you repeat the same steps. By watching these examples, beginners can grasp how skills turn a set of instructions into action inside their workbooks.

What beginners need to prepare and the setup steps

Lisa stresses some simple prerequisites before you try skills: the workbook should be saved to OneDrive or SharePoint, set to AutoSave, and opened in a version of Excel that supports Copilot skills. She also notes Microsoft’s guidance that data works best when it’s in a proper table, because many Copilot operations expect structured ranges. To add a custom skill, the video shows how to use Copilot’s Settings area under Manage plugins & skills, create a skills folder in OneDrive, and place the necessary files there. Following these steps helps avoid common errors when skills don’t appear in the skill picker or fail to run.

Tradeoffs, limitations and practical challenges

While skills bring repeatability, Lisa points out tradeoffs between automation and flexibility: a highly prescriptive skill gives consistent results but can fail if input data changes, whereas a flexible instruction set can handle more scenarios but may produce inconsistent outputs. Additionally, the preview status of custom Excel skills means you must balance the urge to experiment with the reality of version requirements and possible bugs in early features. Another challenge is the choice between simple natural-language skills and those that include optional JavaScript using Office.js; scripts increase power but also add complexity, testing needs, and maintenance work. Finally, storing skills in cloud folders simplifies sharing, but teams must manage governance, naming, and access to avoid confusion or accidental edits.

Recommendations and next steps for users

For readers new to Copilot skills, Lisa suggests starting with built-in skills and copies of real workbooks to test ideas safely before automating live files. She also recommends keeping data in tables and saving frequent transformations as skills so you can reuse them reliably across projects. Furthermore, for teams, it makes sense to document a folder structure in OneDrive, version your SKILL.md files, and test skills collaboratively so ownership and behavior remain clear. By taking these practical steps, users can get the benefits of repeatable AI workflows while reducing the risks of breakage or data surprises.

Keywords

Copilot in Excel tutorial, Excel Copilot for beginners, Microsoft Copilot Excel guide, Excel AI Copilot tips, How to use Copilot in Excel, Excel automation with Copilot, Learn Copilot Excel basics, Excel Copilot step-by-step