Copilot in Excel - Formula columns & rows
ExternoCopilot in Excel's Generate formula rows & columns feature lets users create new table columns or rows with complex calculations using simple natural language prompts, such as total cost per product or average revenue. It suggests advanced formulas like XLOOKUP, COUNTIFS, and SWITCH, explains them, and inserts directly into spreadsheets, saving time and bridging the gap between beginners and experts. This tool matters for efficient data analysis in business environments but requires manual verification due to potential inaccuracies; note that App Skills are deprecated by Feb 2026, with Agent Mode as the alternative.
Descrição
Copilot in Excel's Generate formula rows & columns feature lets users create new table columns or rows with complex calculations using simple natural language prompts, such as total cost per product or average revenue. It suggests advanced formulas like XLOOKUP, COUNTIFS, and SWITCH, explains them, and inserts directly into spreadsheets, saving time and bridging the gap between beginners and experts. This tool matters for efficient data analysis in business environments but requires manual verification due to potential inaccuracies; note that App Skills are deprecated by Feb 2026, with Agent Mode as the alternative.
Principais capacidades
- Automatically creates new table columns or rows with formulas based on natural language prompts
- Suggests complex formulas like XLOOKUP, IFERROR, COUNTIFS, SWITCH
- Understands worksheet context for relevant suggestions on sales data, growth rates
- Supports data cleaning, trends, and charts
Principais casos de uso
- 1.Calculate total cost per product in a new column
- 2.Add total profit for marketing campaigns
- 3.Compute days since product launch
- 4.Add rows for average revenue, ROI, and sales
- 5.Standardize data and identify growth rates
A Copilot in Excel - Formula columns & rows é ideal para você?
Melhor para
- Data analysts and Excel beginners for quick formula generation and insights
- Microsoft 365 business users needing seamless spreadsheet integration
Não é ideal para
- Users requiring precise math without verification
- Advanced users with complex multi-step workflows or edge cases
Recursos de destaque
- Accessible via Home tab in Excel Copilot pane
- Provides formula explanations
- Requires Microsoft 365 business subscription, Copilot add-on, table-formatted data
- Rolling out gradually; review all suggestions
Preços
Microsoft 365 Family
Microsoft 365 Personal
Microsoft 365 Premium
Destaques do Feedback dos Usuários
Mais Elogiado
- Effectively generates and explains complex formulas
- Contextual understanding for relevant suggestions
- Bridges beginners and advanced users by automating formula creation
Reclamações Comuns
- Generates incorrect formulas or wrong cell references in complex scenarios
- COPILOT function returns text not computed values, causing math errors
- Performance variability, timeouts, and locale syntax issues