Excel's Game-Changing COPILOT Function: Why My Previous AI Recommendations Just Changed
TL;DR: Microsoft just launched the revolutionary COPILOT function in Excel, bringing AI directly into spreadsheet cells. This changes everything I recommended in my previous Copilot vs Claude comparison. While Claude still excels for complex Power Query work, Excel's new COPILOT function delivers the speed, flexibility, and native integration that transforms how we work with data - without requiring OneDrive auto-save. Just weeks after publishing my analysis of Copilot vs Claude for Excel formula building, Microsoft dropped a bombshell that fundamentally changes the AI-in-Excel landscape. The new COPILOT function isn't just an incremental update-it's a complete reimagining of how artificial intelligence integrates with spreadsheets. In my previous comparison, I noted that while Copilot offered seamless integration, its limitations around auto-save requirements, slower response times, and limited formula alternatives made Claude the superior choice for advanced users. The new COPILOT function addresses these concerns head-on while introducing capabilities that neither tool previously offered.0
What Makes the COPILOT Function Revolutionary
The COPILOT function transforms AI assistance from an external chat interface into a native Excel function that works just like VLOOKUP, SUMIF, or any other formula. Instead of asking Copilot to help you build a formula, you can now type AI prompts directly into cells and get instant results. Here's the basic syntax: =COPILOT(prompt_part1, , , , ...) But the real magic happens when you see it in action. Data Classification Made Effortless Remember spending hours categorizing expense reports or customer feedback? The COPILOT function handles this instantly. As demonstrated in Microsoft's announcement video, you can analyze credit card descriptions and automatically generate expense categories: =COPILOT("Analyze the credit card descriptions and come up with a short list of categories I can use to group the expenses", B2:B50) Within seconds, COPILOT scans your data and proposes relevant categories. The function is context-aware—it understands your business context and tailors its suggestions accordingly, even incorporating common business naming conventions and merchant categories. Data Generation and Content Creation One of the most impressive demonstrations shows COPILOT generating data it doesn't already have in your spreadsheet. You can ask it to create lists of companies in specific industries, generate marketing keywords based on product descriptions, or even brainstorm project ideas—all directly within Excel cells. For example, you might ask: "List the top 10 SaaS companies by revenue and their primary business focus." COPILOT pulls this information from its training data and creates structured output directly in your cells, something that previously required external research and manual data entry. Formula Explanations in Plain English The COPILOT function excels at demystifying complex formulas. Using the FORMULATEXT function, you can reference any formula in your spreadsheet and ask COPILOT to explain it in plain English: =COPILOT("Explain this formula in plain English", FORMULATEXT(D5)) This eliminates the guesswork when inheriting spreadsheets from colleagues or revisiting your own complex formulas months later. Data Analysis and Insights Perhaps most powerfully, COPILOT can analyze entire data ranges and provide intelligent summaries. Instead of manually scanning profit and loss statements, you can ask COPILOT to analyze the data and highlight key findings: =COPILOT("Analyze the profit and loss statement and give me a summary of notable points", A1:C20) The function uses TEXTJOIN and CHAR functions to format responses with proper line breaks, creating readable paragraph-style outputs that feel more like analyst reports than formula results. Data Cleaning Made Simple Data cleaning, historically one of the most tedious Excel tasks, becomes almost effortless. The demonstration shows COPILOT extracting ZIP codes from inconsistently formatted address data and then standardizing the formatting-tasks that typically require complex regex patterns or manual correction. Important Note for Regular Data Processing: While the COPILOT function excels at one-off data cleaning tasks, it's not the optimal solution for repeated data cleaning exercises. If you regularly receive external reports that need the same cleaning steps applied each month or quarter, Power Query remains the superior choice. Power Query allows you to build reusable data transformation workflows that can be refreshed with new data automatically. Use COPILOT for ad-hoc cleaning tasks and exploratory data work, but invest in Power Query solutions for recurring data processing workflows.
How This Changes My Previous Recommendations
Speed: The Game Changer In my previous analysis, I criticized Copilot for slow response times compared to Claude. The COPILOT function operates at the speed of Excel's calculation engine. When your data changes, results update automatically-just like any other Excel function. This represents a fundamental shift from the slower chat-based interface to instant, native performance. No More Auto-Save Requirements My biggest criticism of the original Copilot was its requirement for OneDrive auto-save, which forced a cloud-first workflow many users found restrictive. The COPILOT function works in any Excel file, whether stored locally, on network drives, or in the cloud. This addresses the primary concern that made Claude more appealing for users who prefer controlling their save workflows. Integration vs. External Tools While Claude still requires copying and pasting between applications, the COPILOT function brings AI capabilities directly into the spreadsheet grid. Results become part of your workbook, automatically update when source data changes, and can be referenced by other formulas. This level of integration was impossible with external AI tools. Best Practices for Interpretation, Not Precision Microsoft emphasizes an important limitation: the COPILOT function excels at interpretation, classification, and insights rather than precision mathematics. This aligns perfectly with how most users actually need AI assistance-for understanding data patterns, categorizing information, and generating insights rather than performing complex calculations.
Updated Recommendations: When to Use What
Choose the COPILOT Function When: Data classification tasks: Categorizing expenses, customer feedback, or survey responses Content generation: Creating lists, brainstorming ideas, or generating structured data Data analysis: Summarizing trends, highlighting key findings, or explaining patterns Formula explanations: Understanding complex formulas built by others Data cleaning: Extracting information from messy text or standardizing formats Working with files locally: When you prefer not to use OneDrive auto-save Choose Claude When: Power Query development: The COPILOT function doesn't work in Power Query editor Complex M code: Claude remains superior for data transformation scripting Multiple formula alternatives: When you want to see different approaches to the same problem Cross-platform work: When working across different applications beyond Excel Educational depth: When you need detailed explanations of Excel concepts and best practices Choose Traditional Copilot When: Conversational assistance: When you prefer chat-based interaction for guidance Template creation: For generating entire workbook structures and layouts Multi-step workflows: When you need guidance through complex multi-stage processes
Availability and Access: How to Get Started
The COPILOT function is currently rolling out to specific user groups with specific requirements: Current Availability (August 2025): Beta Channel users with Microsoft 365 Copilot licenses Windows: Version 2509 (Build 19212.20000) or later Mac: Version 16.101 (Build 25081334) or later Web version: Rolling out soon through Microsoft's Frontier program Usage Limits: 100 calls every 10 minutes Up to 300 calls per hour Single calls with larger data ranges count as one usage Dragging formulas across multiple cells counts as multiple calls Licensing Requirements: Microsoft 365 Copilot license (typically $30/user/month for business) OR Microsoft 365 Personal/Family subscription (Copilot now included as of January 2025) For business users, the COPILOT function requires the full Microsoft 365 Copilot license. However, as of January 2025, Microsoft included Copilot capabilities in Microsoft 365 Personal and Family subscriptions, making this functionality accessible to individual users through a monthly AI credit system.
The Bottom Line: A New Era for Excel
The COPILOT function represents the most significant innovation in Excel since the introduction of dynamic arrays. It transforms AI from an external assistant into a native spreadsheet capability, addressing the primary limitations that made external tools like Claude more attractive for many use cases. For most users, this changes the AI assistance landscape entirely. The combination of native integration, automatic updates, local file support, and instant performance creates a compelling case for using Excel's built-in AI capabilities over external alternatives. However, this doesn't make external AI tools obsolete. Claude retains significant advantages for Power Query development, educational explanations, and complex analysis that requires multiple approaches. The ideal workflow now involves using the COPILOT function for day-to-day data manipulation and classification while leveraging Claude for advanced development work and learning. As Microsoft CEO Satya Nadella noted, "I just love this." The COPILOT function feels like the natural evolution of what spreadsheet AI assistance should be-seamlessly integrated, contextually aware, and immediately useful. The era of choosing between integration and capability is over. Excel now offers both. Stay tuned to tirabassi.com for hands-on tutorials and advanced use cases as the COPILOT function rolls out more broadly. Have you gained access to the beta? I'd love to hear about your experiences with this game-changing feature FAQs Can I trust the accuracy of the COPILOT function’s outputs? The COPILOT function excels at interpretation, categorization, and generating insights, but it is not designed for precision mathematics or regulatory reporting. Always review and validate its results, especially for business-critical decisions. Think of it as a powerful assistant for exploration and pattern recognition, not a replacement for structured data validation. How does the COPILOT function impact collaboration in shared workbooks? When a workbook is shared, the COPILOT function behaves like any other formula—other users see the results as cell values. However, only users with the proper Copilot license will be able to refresh or modify COPILOT-based formulas. This ensures compatibility across teams while maintaining Microsoft’s licensing requirements. Can the COPILOT function replace Power Query for data cleaning and transformation? Not entirely. While COPILOT makes ad-hoc data cleaning—like extracting ZIP codes or categorizing expenses—much easier, it’s not designed for repeatable workflows. Power Query remains the best choice when you need reusable, automated transformations that refresh with new data each month or quarter. The COPILOT function is best for quick insights and one-time cleanups, while Power Query handles recurring data processes. Salvatore Tirabassi is the Managing Director at CFO Pro+Analytics. With over 24 years of experience in venture capital, private equity, and executive financial leadership, he has raised more than $400 million in capital and guided dozens of companies in optimizing their financial strategies to drive growth and create long-term value. Read the full article