Hasty Briefsbeta

Excel's =COPILOT

a day ago
https://techcommunity.microsoft.com/blog/microsoft365insiderblog/bring-ai-to-your-formulas-with-the-copilot-function-in-excel/4443487
Copy Link
  • #AI
  • #Excel
  • #Productivity
  • Introduction of the new COPILOT function in Excel for Windows and Mac.
  • COPILOT function integrates large language models into Excel for analyzing text, generating content, and improving workflow efficiency.
  • Function automatically updates results when data changes, eliminating the need for manual script re-runs or add-in refreshes.
  • Works seamlessly with existing Excel functions like IF, SWITCH, LAMBDA, or WRAPROWS.
  • Syntax includes prompt parts and optional context arguments for AI tasks.
  • Example use case: classifying customer feedback by sentiment or category.
  • Data privacy: Input data is not used to train AI models.
  • Scenarios for use: idea generation, data summarization, classification, and list/table creation.
  • Tips for effective prompts: clarity, specificity, and use of action words.
  • Current limitations: no live web data access, 100 calls every 10 minutes, dates returned as text.
  • Future improvements: better array support, enhanced models, user guidance, and expanded data capabilities.
  • Availability: Rolling out to Beta Channel users with specific version requirements.
  • Feedback encouraged via Excel's 'AI-generated' pop-up.
AboutLogin