"Using natural language prompts, users can simplify this experience, Microsoft said. Example formulas touted by the firm specifically highlighted text summarization, using '= COPILOT("Summarize this feedback", A2:A20)' Others included AI-generated text for product descriptions, using '= COPILOT("Create a description for this product based on its specs", B2:B8)' The feature also works alongside existing Excel functions, and can be used inside formulas such as LAMBDA, SWITCH, WRAPROWS, and IF."
"There is one big caveat, however. In a separate support page, Microsoft warned users not to use the new AI function "for any task requiring accuracy or reproducibility". The support page also advised users not to use the Copilot function for "tasks with legal, regulatory, or compliance implications". "Avoid using AI-generated outputs for financial reporting, legal documents, or other high-stakes scenarios," it reads."
Microsoft added a COPILOT function to Excel for Windows and Mac that lets users generate formulas and automate tasks using natural-language prompts. The function can summarize text, create product descriptions from specifications, and integrate with existing functions like LAMBDA, SWITCH, WRAPROWS, and IF. Users can include results from other formulas as part of prompts to avoid restructuring spreadsheets. Example usages include = COPILOT("Summarize this feedback", A2:A20) and = COPILOT("Create a description for this product based on its specs", B2:B8). Microsoft warns against using COPILOT for tasks requiring accuracy, reproducibility, or legal, regulatory, or financial reporting.
Read at IT Pro
Unable to calculate read time
Collection
[
|
...
]