Microsoft Excel with Copilot Pro AI Add-in : What does it do and is it worth subscribing?

Microsoft Copilot Pro is an AI assistant designed to enhance productivity and efficiency within Microsoft Office applications. In this article, we will explore the features and capabilities of Copilot Pro, focusing on its usage in Microsoft Excel.

Copilot Pro is available to all Microsoft 365 users via an additional monthly subscription. It offers a range of AI-powered functionalities that can assist users in performing various tasks within Excel, such as data analysis, formatting, filtering, sorting, and chart creation.

So is it worth the money? Let's take a look

With Copilot Pro, you can use natural language to tell Excel to do things like format a column as a short date or convert a column into currency, produce a chart or sort/filter your data.

Some of the key features of Copilot Pro in Excel include:

1. Formatting Data: Copilot Pro allows users to convert data into different formats, such as currency. By simply specifying the column and the desired format, Copilot Pro will apply the formatting automatically.

2. Calculations and Formulas: Users can instruct Copilot Pro to perform calculations and create formulas using natural language commands. For example, users can ask Copilot Pro to calculate the total sales by multiplying the unit price and the units sold.

3. Filtering and Sorting: Copilot Pro enables users to filter and sort data based on specific criteria. Users can specify the filter conditions, such as product type or units sold, and Copilot Pro will apply the filters accordingly.

4. Chart Creation: Copilot Pro can generate charts based on the data provided. Users can request bar charts, scatter graphs, or pie charts, and Copilot Pro will create the visual representation accordingly.