Excel Copilot: Write Formulas 10x Faster

Key insights

• Formula Completion — The video demos a Copilot-powered autocomplete that suggests and previews formulas as you type “=” in a cell.
  It reads headers, nearby cells and tables to offer context-aware suggestions and a short natural-language description of each formula.
• Key benefits — Users can build formulas much faster, cut errors, and get help understanding function intent.
  Microsoft claims up to 10x faster formula creation, improved accuracy, and lower learning barriers for new users.
• Practical examples — The video walks through nine real workflows: extract month numbers, format dates, create custom date formats, use XLOOKUP across tables, filter by month with natural language, compute net income and year-over-year change, and extract postal codes using regex.
  Each example shows how Copilot suggests the exact formula and previews results in place.
• How it works — Copilot analyzes worksheet context in real time and updates suggestions as you type, showing a preview and natural-language explanation.
  The feature integrates with existing Excel functions so teams can adopt it without changing established workflows.
• Availability and requirements — Formula Completion is rolling out to Excel on the web (as of September 2025) and appears in desktop beta builds for Copilot subscribers.
  Full access requires a paid Microsoft 365 Copilot license and a work account.
• COPILOT function — Beyond autocomplete, the new COPILOT function lets you type natural-language prompts directly into cells and reference cell values inside those prompts.
  This ties formula suggestions into the broader Copilot suite, so AI assistance spans other Microsoft 365 workflows.

Overview

The YouTube video by Office Skills with Amy spotlights Microsoft’s new Formula Completion feature in Excel and demonstrates how it can speed up formula writing. In straightforward demonstrations, the presenter shows nine practical examples that range from date handling to lookups and text extraction. Moreover, the video frames the feature as useful for students, teachers, project managers, and small business users who want to save time on routine spreadsheet tasks. Overall, the footage aims to make the feature approachable while illustrating real-world uses.

Importantly, the presenter emphasizes that suggestions appear as soon as you start a formula and that each completion includes a short explanation and a preview of results. Consequently, novice users can reduce guesswork, while experienced users can move faster through repetitive formula creation. At the same time, the video keeps a practical tone and avoids deep technical jargon, which helps viewers quickly grasp the main benefits. This review summarizes the video’s key points and notes tradeoffs to consider before adopting the feature widely.

How the Feature Works

According to the video, Formula Completion activates when you type an equals sign and then analyzes worksheet context, such as headers, adjacent cells, and existing formulas, to suggest relevant expressions. As you type, suggestions update in real time and include a natural language description and a preview of the expected output, which helps clarify intent before you accept a suggestion. In addition, the presenter shows how the feature integrates with the broader Copilot experience in Microsoft 365, making formula assistance feel like part of the normal workflow rather than a separate tool. Therefore, users can accept or edit suggestions without changing how they usually work in Excel.

The video also highlights the newly introduced COPILOT function, which lets users write natural language prompts directly into formulas and reference cell values for dynamic results. However, the presenter points out current limits, such as the feature mainly working with data on the same worksheet for now and requiring a paid Copilot license for full functionality. Thus, while the feature feels powerful, it is still evolving and may not yet replace manual formula work in complex multi-sheet models. Still, for many daily tasks, it can cut time and reduce simple errors.

Examples Demonstrated in the Video

The video walks through nine examples that illustrate a range of everyday Excel needs, including extracting month numbers, formatting dates, creating custom date displays, using XLOOKUP for same-sheet and cross-table lookups, filtering by month using natural language, calculating Net Income, computing YoY percentage change, and extracting postal codes using regex. Each demo shows how a suggested formula appears, how the preview looks, and how to adjust the suggestion when the data isn’t standard. Consequently, viewers see both quick wins and small adjustments needed when cell formats or labels vary. The practical focus helps users judge whether the feature suits their own workflows.

Moreover, Amy demonstrates that while Copilot often provides correct formulas, some cases require human judgement to refine ranges or handle exceptions in messy data. For instance, regex-based extraction can be brittle when addresses follow inconsistent patterns, and lookup logic may need manual range checks when tables are split across sheets. Therefore, the examples serve as both a showcase of potential time savings and a reminder that automation still benefits from expert oversight. In short, the tool speeds routine work but does not eliminate the need for careful spreadsheet design.

Benefits Versus Tradeoffs

The most obvious benefit shown in the video is speed: users can write formulas much faster by accepting contextual suggestions, which reduces time spent hunting for the right function or syntax. Additionally, the real-time previews and natural language descriptions increase confidence and reduce common errors, especially for those less familiar with Excel’s full function library. However, the presenter cautions that relying too heavily on automated suggestions carries risks, such as overconfidence in results and potential privacy concerns if sensitive data feeds AI models. Consequently, teams should weigh the convenience of rapid formula generation against governance, compliance, and accuracy needs.

Furthermore, the feature’s dependence on cloud-based AI services and a paid Copilot license means organizations must consider cost, data residency, and policy implications before broad rollout. At the same time, human review remains essential because AI can suggest formulas that look plausible but do not match specific business rules or edge-case data. Thus, the real productivity gain comes from combining Copilot’s speed with clear checks and dataset validation carried out by users. Balancing these elements will determine whether Copilot delivers net time savings in practice.

Availability, Challenges, and Takeaways

The video notes that Formula Completion is available in Excel on the web and that desktop support is rolling out in beta for Copilot subscribers, while full access requires a paid Microsoft 365 Copilot license for business accounts. Consequently, early adopters can test the feature on common tasks, but wider deployment in enterprises depends on licensing, IT policy, and user training. Additionally, the presenter recommends starting with non-critical workbooks to learn how suggestions behave before applying them to financial models or regulated reports. This staged approach reduces risk while letting teams evaluate real benefits.

In conclusion, the Office Skills with Amy video provides a clear, user-focused tour of how Copilot-powered formula assistance can speed up everyday Excel work while also highlighting limits and governance considerations. Therefore, readers should view the feature as a productivity amplifier that still requires human oversight, careful dataset design, and incremental adoption. For teams willing to test it responsibly, Copilot’s formula features represent a valuable step toward more accessible spreadsheet automation.

Keywords

Excel Copilot formula completion, Excel formula autocomplete, Copilot for Excel formulas, write Excel formulas faster, Excel AI formula assistant, Formula Completion Excel feature, Excel productivity with Copilot, Excel formula suggestions AI