How to use Microsoft Copilot in Excel

Copilot As a tool AI has many features, such as priority access to GPT-4 and GPT-4 Turbo, creating an advanced AI image and access to chatbot from the Microsoft 365 app.

The features of Copilot will depend on each application. In the case of Microsoft Excel, people can ask Chatbot to better understand the information by allowing the analysis and exploration of data in the spreadsheet. In addition, users can ask almost everything in natural language.

This chatbot is also smart enough to propose formulas based on user query, predict scenarios and find data correlation. In addition, people will be able to immediately create SWOT or Pivottable analysis based on data.

In this article, let’s find out How to activate and use Copilot on Microsoft Excelhelping to promote productivity and more intelligent work efficiency.

Table of Contents

How to activate Microsoft Copilot in Excel

Microsoft Copilot in Excel is an advanced AI tool designed specifically to increase productivity in the Microsoft Office app. Follow the steps below to turn on Microsoft Copilot in Excel:

Step 1: On Windows, click on Start.

Step 2: To open Registrysearch “RegeditAnd click on the top results. Conducting on the path:

Step 3: Right -click on the Excel key, select the menu New and select the option String Value.

Step 4: Choose the key Microsoft.office.excel.copilot and press Enter.

Step 5: To turn on Copilot, Double click on the newly created key and proceed to put its value into True.

Step 6: Select OK And restart the computer.

How to turn on Copilot Pro in Excel

Copilot Pro is a US $ 20 registration package based on Copilot (free) but there are many new features, such as priority access to GPT-4 and GPT-4 Turbo, enhanced AI image, the ability to create custom GPT and access chatbot access from Microsoft 365 application. To activate Copilot Pro in Excel, follow the steps below:

Have permission options

Open Excel on Windows 11, click on File and choose Account.

Click the button Update license.

Continue click on Sign in.

Microsoft account confirmation is linked to Microsoft 365 and Copilot Pro registration. Then select Close.
Close all versions of the Microsoft 365 and Open Excel To access Copilot Pro.

After completing the steps, the product license will update and Copilot Pro will appear on Microsoft Excel. AI assistant is available from the tab Homenext to the Microsoft Editor button.

There is no license option

If the option Update license Not appearing, it may be because users do not use the right version of the application that allows accessilot access in Excel. In this case, users will need to completely uninstall the Microsoft 365 (Office) applications and install a new copy by downloading the installation process from the Microsoft account.

Uninstall Microsoft 365

To completely uninstall the Microsoft 365 applications on Windows 11, follow these steps:

Click the button Agree To confirm the terms
Choose a product version, for example: Office 2021, 2019 or 365

Click the button Next
Confirmation of Office settings by checking the option you have saved your job.
Click the button Next and choose Restart.

After completing the steps, applications will be removed from the computer and users can continue to install the latest version of Microsoft 365 applications.

Reinstall the Microsoft 365 applications

To download and install Microsoft 365 applications on Windows 11, follow these steps:
Open Microsoft account and log in with Microsoft 365 account
Click the tab Account
Click the option Manage For Microsoft 365 registration.

Click the button Install In settings Microsoft 365 Apps for Your Device.

Select language Install and click Microsoft 365 64-bit (may vary depending on the device)

Click the button Install To download the installer on your computer
Double click Officesetup.exe To install the application
Click the button Finish

After completing the steps, the application supported by the application will be installed on the computer. Now, people can check if Copilot Pro is currently available or not, but if not, it is possible to update the license by the steps below.

How to use MS Copilot in Excel

People can choose to download Microsoft Copilot in Excel by following the following steps:

Step 1: Download Microsoft 365 and choose Copilot icon On the toolbar of the spreadsheet application. Chatbot will appear in the lower right corner of the spreadsheet.

Step 2: Conduct Microsoft Copilot Excel an analysis of data analysis, such as the top three main trends.

Step 3: The answer will be provided by Microsoft Copilot within a few seconds.

Step 4: If you want to ask Microsoft Copilot the next question, this question will take the user to a new page and sand box to use.

Step 5: Conduct a request for Microsoft Copilot Excel to visualize data, this will cause Microsoft Copilot to add some colors to help monitor the problem.

Step 6: Ask questions “What-IF“Other to follow more deeply.

Step 7: Microsoft Copilot will answer the question and create a simple model to better understand the situation with step -by -step analytical assistance.

Step 8: Microsoft Copilot Excel creates charts of the expected model. Users will find that Copilot in Excel can turn big data into clear intensive actions and information.