Copilot in Excel - Formula columns & rows

説明

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.

主な機能

• 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

主な用途

1. 1.Calculate total cost per product in a new column
2. 2.Add total profit for marketing campaigns
3. 3.Compute days since product launch
4. 4.Add rows for average revenue, ROI, and sales
5. 5.Standardize data and identify growth rates

Copilot in Excel - Formula columns & rows はあなたに合っていますか？

ユーザーフィードバックのハイライト