Charles Esther
Many AI-powered tools can feel unnecessary or even intrusive.
However, some genuinely improve productivity and user experience.
Microsoft’s Copilot has faced criticism for gimmicky features, but one of its most practical tools just became easier to use in Excel.
Introducing Explain Formula in Excel
Excel is launching a new feature called Explain Formula that integrates AI explanations directly into the spreadsheet grid.
Users can now access this tool conveniently by right-clicking any cell containing a formula.
Simplifying Complex Formula Understanding
Before, interpreting complicated formulas meant manually breaking them down, looking up documentation, or searching online.
Now, Explain Formula offers a step-by-step, context-aware breakdown of what the formula is doing, shown right next to the selected cell.
Contextual and Data-Specific Explanations
Unlike generic definitions, the AI analyzes the actual formula in its specific spreadsheet context.
It references the exact cells and ranges involved, helping users understand how the formula applies to their data.
Easy Access Through Right-Click
Users simply right-click on a formula cell and select “Explain this formula.”
A pop-up window appears with a clear explanation of the formula’s function and mechanics.
Integration With Copilot Chat Pane
If the Copilot chat sidebar is already open, the explanation shows up there to keep the interface consistent.
Users who want to dive deeper can click “Chat with Copilot” to ask follow-up questions in a more conversational space.
Not a Brand-New Capability, But More Convenient
Previously, Copilot’s side pane allowed users to ask about formulas and other spreadsheet elements.
Explain Formula now makes this functionality quicker and more accessible without opening the side panel or typing manually.
Ideal for Users Who Avoid the Side Panel
For those who typically close the Copilot sidebar when not in use, this new right-click shortcut is a welcome improvement.
It streamlines workflow by eliminating extra steps to get formula explanations.
Rolling Out Gradually to Users
Microsoft is currently rolling out Explain Formula slowly across Excel users.
Keep an eye out for updates in your version to try this handy new tool soon.
The Future of AI in Productivity Tools
Features like Explain Formula show how AI can enhance day-to-day work by simplifying complex tasks.
While some AI additions feel superfluous, practical tools integrated smoothly into existing workflows will likely win widespread adoption.
