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

Quick Overview

Excel now features a new =COPILOT() function that integrates AI directly into spreadsheets, enabling users to extract data, summarize information, and even generate creative content like itineraries and fun ratings based on specified prompts and data ranges, significantly boosting productivity and analytical capabilities.

Key Points: Excel now includes a new =COPILOT() function that integrates AI directly into spreadsheets. The =COPILOT() function can be used to extract specific data, like names and phone numbers, from text using prompts and patterns. It can also generate content, such as creating itineraries or rating activities with emojis, based on provided data and prompts. The function is dynamic, automatically recalculating results when the source data changes. Using =COPILOT() requires a Microsoft 365 Copilot license linked to a work or school account. The function is intended for everyday tasks and is not designed for heavy mathematical computations or processing massive datasets.

Context: This video introduces and demonstrates the new =COPILOT() function in Microsoft Excel, highlighting its ability to integrate artificial intelligence directly into spreadsheet tasks. The presenter, Kevin Stratvert, showcases how this function can be used for data extraction, summarization, and content generation, significantly enhancing workflow efficiency for various data analysis and planning activities.

Detailed Analysis

Microsoft Excel has introduced a powerful new AI-powered function, =COPILOT(), which allows users to leverage artificial intelligence directly within their spreadsheets. This function can perform various tasks, including data extraction, summarization, and content generation. The video demonstrates how to use =COPILOT() by inputting a prompt and referencing specific data ranges. For instance, it shows how to extract names and phone numbers from a list of customer callback requests using a regular expression pattern. It also illustrates how to generate a fun rating for different activities in a class visit itinerary by providing a prompt that specifies the desired output format (emojis). The function is dynamic, recalculating results automatically when the source data changes, and requires a Microsoft 365 Copilot license tied to a work or school account. While powerful for everyday tasks, the video notes that Copilot is not designed for heavy math or massive datasets, for which Excel has existing functions.