Copilot in Excel: Formula by Example

Key insights

• Formula Completion: Excel suggests complete formulas as you type "=" by analyzing the worksheet context, helping you build accurate formulas faster.
  It reduces guesswork and works for both simple and complex calculations.
• Formula by Example: Enter one or two example values and Excel detects the pattern, then fills the rest of the column with the correct formula.
  This speeds up repeating tasks like formatting names, dates, or calculated columns.
• =COPILOT(): A new AI-powered function where you write what you want in plain language and Copilot generates the right calculation or transformation.
  It can replace many traditional functions, e.g., "transform these dates to YQQ" or "extract phone numbers from a column."
• Key capabilities: Copilot handles data cleaning, date and time extraction, sentiment tags, structured-data extraction, and whole-column calculations.
  It can create formulas for rows and columns, summarize financial lines, and run text analysis without deep formula knowledge.
• Benefits and time savings: These features cut repetitive work and reduce errors, with Microsoft estimating large annual time savings for users.
  They help both beginners and power users finish tasks faster and with fewer mistakes.
• Availability and requirements: Formula Completion and COPILOT() are part of Copilot in Excel (COPILOT() in beta); a basic Copilot experience is included with Microsoft 365.
  Workbooks should use tables or supported ranges and have well-formatted data for best results.

Overview of the video and author

Ami Diamond [MVP] presents a focused YouTube video that walks through Microsoft's latest AI enhancements for spreadsheets, centering on Copilot in Excel. In this news-style summary, the video is treated as a demonstration and explainer rather than original research, and it highlights two headline capabilities: Formula by Example and Formula Completion, with mention of the new =COPILOT() function. Ami, a man and recognized Microsoft MVP, frames the features by showing live examples and practical tips for both new and advanced Excel users. Consequently, the clip aims to help viewers decide if the new tools fit their workflows and what to expect when they try them.

How the new features work

First, Formula by Example detects patterns as you type and offers to fill a column when it recognizes a repeated structure, so you can complete lists or derived values quickly. For instance, when you start typing transformed names or computed results, Excel proposes a formula to repeat that logic down the column, which reduces repetitive manual edits. Meanwhile, Formula Completion kicks in when you type an equals sign and begins offering context-aware formula suggestions based on the worksheet data and selected ranges. As a result, users do not need to recall exact syntax or scan help panels for common formula constructions.

In addition to those features, the video explains the new =COPILOT() cell function, which lets you describe a transformation in natural language and have Copilot generate the appropriate calculation. For example, you could request a date format change, text extraction, or a multi-step aggregation by embedding a description and a range in the function call. Ami shows that Copilot translates the plain-language instruction into a working formula, effectively hiding complex nested functions from the user. Therefore, it aims to lower the barrier for less technical users while accelerating work for experienced users.

Practical benefits demonstrated

Ami emphasizes time savings as a primary advantage, noting that automating repetitive tasks can free hours across many spreadsheets and projects. He demonstrates common operations such as cleaning text, extracting phone numbers, deriving fiscal periods, and calculating ages, all of which the AI can suggest or produce with minimal manual formula writing. Moreover, he highlights how Copilot can generate entire columns or rows of formulas based on a single example or a brief instruction, streamlining common reporting and data-preparation tasks. Consequently, the features can make routine workflows more consistent and reduce the risk of manual errors.

Beyond mundane tasks, the video showcases more advanced applications like sentiment classification of text and extracting structure from messy inputs, which traditionally require formulas combined with helper columns or external tools. Ami demonstrates that Copilot can surface these insights directly within the workbook, saving time and keeping data in one place. He also points out that the tool helps both novices and power users by suggesting optimized approaches that might otherwise be overlooked. Thus, the features appear to expand what Excel users can accomplish without switching tools or writing scripts.

Tradeoffs and technical challenges

However, Ami also addresses important tradeoffs, starting with the reliance on properly formatted data: Copilot’s suggestions work best when ranges are set up as tables or supported ranges, so users may still need to tidy inputs first. Furthermore, the video notes that AI-generated formulas sometimes require human review because suggestions may be contextually plausible but not precisely what the user intended, which raises the need for verification and testing. In addition, advanced users may find that the black-box nature of an AI-generated approach makes auditing or debugging a bit more effortful than hand-crafted formulas. Therefore, organizations should balance the time saved with the need for traceability and governance.

Another practical challenge that the video highlights is availability and licensing: some features are part of the paid Copilot in Excel offering and the =COPILOT() function is initially in beta, which limits access for some users. Moreover, Ami encourages caution about over-reliance on automation, because errors in AI suggestions can propagate across reports if not checked. Privacy and data governance also matter, since any cloud-backed feature requires consideration of how sensitive data is processed and stored. As a result, adoption requires both technical setup and policy discussion in many workplace contexts.

Adoption considerations and next steps

Finally, Ami invites viewers to test the features and share feedback, noting that user input will help refine Copilot’s behavior during its beta and general rollout. He suggests organizations pilot the tools on non-sensitive datasets while establishing review practices so teams can validate outputs before production use. In addition, Ami recommends that power users document any AI-generated logic to maintain transparency and to help teammates who must maintain spreadsheets later. Consequently, early adopters can learn practical limits and propose improvements that shape future releases.

In summary, the YouTube video by Ami Diamond [MVP] offers a clear look at how Formula by Example, Formula Completion, and the =COPILOT() function aim to simplify formula work in Excel, while also explaining the limitations and governance considerations. Although these tools promise meaningful efficiency gains, the video makes it clear that careful oversight, data preparation, and staged rollouts are necessary for safe and effective adoption. Ultimately, the features represent a notable step in integrating AI into everyday spreadsheet work, and viewers are encouraged to try them, critique them, and help shape their evolution.

Keywords

Excel Copilot, Copilot for Excel, Formula Completion Excel, Formula by Example Excel, AI-assisted formulas Excel, Excel formula suggestions, Copilot formula builder, Automate Excel formulas