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) |
Frequently Asked Questions
Do I need to write formulas to use AI in Excel now?
No, the =COPILOT() function lets you call AI directly in a cell using plain language instructions, just like any other formula.
Do I need to install Python separately to use it in Excel?
No, Python is now native in Excel; just type =PY in a cell to open the editor, or ask Copilot to write the Python code for you.
What does Agent Mode do differently from a normal Copilot prompt?
Agent Mode plans and executes multi-step tasks sequentially, like cleaning data and building a PivotTable, and asks for confirmation if it spots suspicious data.
What does the "Think Deeper" feature do?
It forces the AI to take extra time to double-check its calculations before answering, reducing the chance of numeric errors on complex analysis.
Can Excel's AI features replace Power Query for data cleaning?
For many everyday cleaning tasks, yes — Agent Mode can clean, reformat, and organize data from a single prompt instead of manual Power Query steps.