Excel Just Got Smarter — Meet the NEW =COPILOT() Function

About this video

Kevin introduces Excel’s new =COPILOT() function, which uses AI directly in the grid like any other formula: type =COPILOT, give it a quoted prompt, and optionally reference cells as context. Simple examples generate three cookie types that spill into adjacent cells, then generate a description for each referenced cookie type. On Kevin Cookie Company feedback, a prompt to evaluate reviews, combined with a second prompt referencing the sentiment and category headers, returns sentiment and category per review; changing a header to ask for symbols instead of words changes the output format. Combined with GROUPBY and COUNTA, the results summarize to four negative, one neutral and five positive pieces of feedback out of 10 total. Because the function is dynamic, changing the source prompt to request only positive feedback regenerates the reviews and the GROUPBY summary updates to 10 positive. For extraction, =COPILOT() pulls names and phone numbers from callback-request text, but for hundreds or thousands of rows he instead asks Copilot to return a regex pattern, then uses REGEXEXTRACT with that pattern — locked as an absolute reference with F4 — to extract phone numbers, or just area codes, at scale without calling Copilot per row. A final example builds a class-visit itinerary from referenced time slots and a grade-level cell, changing high school to kindergarten updates the whole itinerary, plus fun ratings from one to four exclamation marks and an emoji per activity. Caveats: it is not designed for heavy math or massive data sets, results recalculate every time the sheet opens so save results you like, and it requires a Microsoft 365 Copilot license tied to a work or school account, with no personal accounts yet.

Key takeaways

• Use =COPILOT(prompt, context) directly in a cell; you can chain multiple prompts and cell references in one function call.
• Header text can steer output format, and results recalculate dynamically when referenced source cells or prompts change.
• Combine =COPILOT() with native functions like GROUPBY and COUNTA to summarize AI classifications.
• For large-scale extraction, have Copilot generate a regex pattern once and apply REGEXEXTRACT down the column instead of calling Copilot per row.
• It requires a Microsoft 365 Copilot license on a work or school account, is not meant for heavy math or massive data sets, and recalculates on open.

Episode details: published August 18, 2025 · 15:03 long. Summary written by Self Growth Videos from the episode itself. Business results and any income figures mentioned are Kevin Stratvert’s own claims, shared for education — they are not typical or guaranteed.

← Previous: Best Free Scanner App (iPhone & Android) – No Ads, Unlimited PDFs · Next: BEST AI Video Generator (Most Realistic) →

All Kevin Stratvert videos · Kevin Stratvert profile · Kevin Stratvert on YouTube