Kurt Shintaku's Blog

The new =COPILOT() function in #Microsoft #Excel enables users to easily leverage AI directly within their spreadsheets to quickly populate cells with data or analyze columns with #AI.

For a 5min tutorial, visit: youtu.be/hjQitMNzSr0 or read the full blog post here:

• Bring AI to your formulas with the COPILOT function in Excel – Microsoft 365 Insider Blog
  https://techcommunity.microsoft.com/blog/microsoft365insiderblog/bring-ai-to-your-formulas-with-the-copilot-function-in-excel/4443487
• COPILOT Function
  https://www.aka.ms/copilotfunctionsupport

Accessing =COPILOT() function for Excel
To access the new =COPILOT() function, you must have a #Microsoft365 #Copilot license (Business/Enterprise) & be a Microsoft 365 Insider Beta Channel participant for access which will be made available over the next month or so. Individuals without a Microsoft 365 Copilot license will see the following:

For those with Microsoft 365 Copilot licenses, visit https://aka.ms/MSFT365InsiderProgram for more information about participating in the Beta channel.

Details: (Gleaned from the above articles)

• COPILOT function for Excel uses gpt-4.1-mini (2025-04-14)
• Execution is model-grounded & does not currently leverage web-grounding or work-grounding
• You can calculate up to 100 COPILOT functions every 10 minutes – up to 300 calls per hour
• COPILOT function cannot calculate in workbooks labelled Confidential or Highly Confidential
• The COPILOT function cannot calculate in workbooks labelled Confidential or Highly Confidential
• Formula results may change over time, even with the same arguments. If you don’t want results to recalculate, consider converting them into values with Copy, Paste Values (select values, Ctrl + C, Ctrl + Shift + V).
• Your prompts and data supplied as context will not be used to train AI models.