Spreadsheets have always been a tool for working with data, but their effectiveness has largely depended on user skill. Complex formulas, macros, and the VBA programming language were a barrier for many. Now, Microsoft is breaking down these barriers by infusing artificial intelligence directly into Excel cells. This isn’t just another update, but a true revolution, enabling incredibly complex operations using everyday, natural language. With the new Copilot feature, working with data in Excel becomes more intuitive, accessible, and productive for everyone.
How is AI changing data management in Excel?
Previously, to obtain a result, users had to create a complex, multi-step formula. For example, to classify product reviews, they had to write a combination of dozens of conditions (=IF(OR(…)) or use special scripts. The new =COPILOT() function changes this process. Now, users can simply write: =COPILOT(“Separate the text into positive and negative reviews”, A2).
The neural network integrated into this feature understands text content and independently analyzes the data to provide accurate results. This allows users to focus on analysis rather than mechanically writing formulas. This is a step toward democratizing analytics, as even non-technical users can now perform highly complex tasks.
Use cases: from review analysis to resume creation
The new feature’s capabilities extend beyond simple calculations. Here are a few examples of how AI in Excel can be useful:
- Sentiment Analysis: Based on an array of customer reviews, =COPILOT() can instantly classify them as positive, negative, or neutral, helping businesses respond more quickly to customer needs.
- Data mining: If you have a long list of texts, you can ask AI to extract specific information from them, such as names, dates, or key concepts.
- Content generation: =COPILOT() can create product summaries, document summaries, or marketing copy ideas based on the data you provide.
- Summary creation: Thanks to the SHI formulas, you can automatically create short summaries of long texts, which saves a lot of time.
Limitations and Prospects
While the new feature’s capabilities are impressive, there are some limitations to keep in mind. Microsoft notes that =COPILOT() works best with text and shouldn’t be used for mathematical calculations, as the AI can make errors. Additionally, there are limits on the number of requests per minute to ensure the service remains stable.
Currently, this feature is only available to beta testers who are Microsoft 365 Copilot subscribers, but this is just the beginning. Microsoft is constantly working to expand the AI capabilities of its products. We can expect such integrations to become the norm across all Office programs in the future, transforming data management into a creative process rather than the routine entry of formulas.
0 Comments