Microsoft Copilot in Excel offers customisation options and a rules sheet to help design worksheets and automate tasks, while requiring careful testing and reviewing of outputs since it can produce unreliable results.
Every finance team operates on a familiar monthly rhythm. Actual numbers arrive, an analyst rebuilds the variance pack, reapplies formatting, rewrites the commentary, and repeats the entire cycle four weeks later. Because the underlying logic often lives entirely in one analyst’s head, the final output shifts depending on who prepares it. Microsoft aims to tackle this inconsistency through updates to its Copilot in Excel tool, which requires a separate subscription beyond standard Microsoft 365 and also covers Copilot for Word, PowerPoint, and Outlook.
Interface Modes and Task Pane Controls
If you have Excel Copilot, you will see the Copilot icon in the bottom-right corner of the Excel screen. The tool operates across three distinct modes to handle different workflow stages.
The full power of Office is coming to Copilot. Create, edit, and collaborate with Word, Excel, and PowerPoint in one connected experience, without losing context or switching tools. Now rolling out in Frontier. https://t.co/nkQC8cg6c3
— https://x.com/MSFTCopilot/status/2108637326981345381
- Allow editing: Permits the assistant to build fully functioning, formatted sheets from scratch based on user rules, or modify existing files, occasionally asking for clarification first.
- Chat only: Functions as a traditional prompt-and-response window used for questions, answers, and configuring personal settings.
Custom Instructions and the Rules Sheet
Professionals can establish permanent rules and role details by switching the interface to chat mode, selecting settings through the ellipsis next to the close button, and opening the personalization menu. A recent update also introduces a specialized sheet named .Rules
to govern how the assistant builds solutions. Using a standard .Rules sheet throughout an organisation could ensure consistent guidelines and formatting. The top section of the .Rules sheet could hold organisational guidelines, while the bottom section could hold specific requirements for the file involved.
Rules are listed in column A, where text-based formulas can reference input cells across the workbook. This setup reduces the prompt instructions needed for each task while maintaining uniform formatting. You can ask Copilot if the rules are specific enough.
Technical Limitations and Validation Safeguards
This mainly impacts VBA code, Power Query M code, protection, and passwords. Used correctly, it can help design worksheets, write formulas, create instructions, suggest improvements and automate repetitive tasks. Used poorly, it can produce confident but unreliable outputs.
Helper cells are cells and ranges that make the final formulas shorter and easier to understand, splitting calculations across multiple cells instead of relying on one long complex formula.