Excel and AI: The New Features Changing Everything
Share
1. The New =COPILOT() Function
This is the revolution of the year. Instead of using a side panel, you can now call AI directly within a cell, just like any other Excel formula.
It allows you to process text, summarize data, or clean information directly within the grid.
Real-world example: You have a column of long and messy customer comments.
Instant result: "Fast delivery, Broken product, Poor service". No need for complex macros anymore!
2. Python in Excel: Advanced Analysis for Everyone
No need to install Anaconda or master Pandas. Python is now native in Excel and driven by Copilot.
🐍 How does it work?
Simply type =PY in a cell to open the Python editor. But the real magic is asking Copilot:
"Use Python to forecast next month's sales based on the seasonality of the last two years."
The AI will:
- Write the Python code for you.
- Generate advanced charts (Violin plots, Heatmaps) impossible to create with standard Excel.
- Create a new analysis sheet without touching your raw data.
3. Agent Mode: Your Private Analyst
Agent Mode is a new Copilot capability that goes beyond simple answers. It plans and executes complex tasks.
You can tell it: "Clean this file, remove duplicates, reformat dates, and create a PivotTable of revenue by region."
The Agent will perform all these actions sequentially and ask for confirmation if data looks suspicious (e.g., a negative sales amount).
Comparison: Before vs. After AI
| Task | Traditional Method | 2025 AI Method |
|---|---|---|
| Sentiment Analysis | Export to external tool or complex formulas | =COPILOT() function |
| Forecast | Limited statistical functions | Automatic Python/Machine Learning models |
| Data Cleaning | Power Query or manual (slow) | Agent Mode (1 prompt) |