The COPILOT function in Microsoft Excel leverages AI to enhance spreadsheet functionality. It allows users to generate summaries, tags, and tables by inputting natural language prompts alongside specified cell ranges. Users can automate data classification and summarization tasks without manual intervention. For instance, feedback about products can be quickly classified through predefined formulas. This feature aims to streamline data analysis and improve productivity, paralleling similar capabilities introduced by Google Sheets.
The new 'COPILOT' function uses AI to generate summaries, tags, tables, and more based on a group of cells.
Microsoft Excel is testing a new AI-powered function that can automatically fill cells in spreadsheets, similar to Google Sheets.
By utilizing the COPILOT function followed by a natural language prompt, users can classify information, generate summaries, and create tables.
For example, feedback on a coffee machine can be classified using the COPILOT function with a specific formula referencing a range of cells.
Collection
[
|
...
]