How to Use Microsoft Copilot in Excel: The Best Guide

March 18, 2024 7.1K views

AI-powered tools, such as Microsoft Copilot Excel, are becoming increasingly crucial in our daily work.Yet many people don’t know how to enable Microsoft Copilot in Excel. This guide will provide you with useful information about things related to operating Microsoft Copilot in Excel.

Introduction to Microsoft Copilot

Microsoft Copilot is a recent AI-powered tool that is exclusively built to help businesses and people work smarter.

Essentially, Microsoft Copilot is an AI-powered chatbot that works by collaborating with human abilities and automating routine tasks. It can assist with the following:

  • Email management

  • Scheduling meetings and events

  • Meeting preparation & research

  • Providing personalized recommendations

You can use Microsoft Copilot in Excel to simplify data. Similar to any other AI tool, the Microsoft Copilot tool is exclusively made to improve productivity, which is why Microsoft Copilot has become a natural part of many workplaces.

When it comes to Excel, you know that Excel is used to store and perform calculations, which is where the perfect spreadsheet assistant, Microsoft Copilot, comes in. Microsoft Copilot Excel can help you in the following ways:

  • You can get formula suggestions and write complex functions.

  • You can debug complex formulas with Microsoft Copilot, which will save you loads of time.

  • Microsoft Copilot Excel can suggest font styles, data types, and colors to assist you with data formatting in the spreadsheet.

  • To visualize data, you can use Microsoft Copilot in Excel to get the most relevant chart suggestions.

How Do I Enable Microsoft Copilot in Excel?

As you already know, Microsoft Copilot in Excel is an advanced AI tool that is exclusively designed to boost the productivity in Microsoft Office Apps.

You will want to follow the below-given steps to enable Microsoft Copilot in Excel:

Step 1: On Windows, click on “Start.”

Step 2: To open the “Registry,” search for “regedit” and click on the top result. Proceed to navigate to the path:

display of navigation path

Step 3: Right-click on the Excel key, choose the “New” menu, and choose the option of “String Value.”

selecting string value

Step 4: Select the key “Microsoft.Office.Excel.Copilot” and select “Enter.”

Step 5: To enable Copilot, you will want to double-click on the newly created key and proceed to set its value to “true.”

setting value to true

Step 6: Select “OK” and restart your computer.

restarting computer

How to Use Microsoft Copilot in Excel?

You can opt for Microsoft copilot download in Excel by following the below-given steps:

Step 1: Download Microsoft 365 and select the “Copilot” icon in the spreadsheet app's toolbar.

display of copilot in spreadsheet

Step 2: You will see the chatbot popping up in the lower right corner of the spreadsheet.

display of copilot chatbot

Step 3: Proceed to ask Microsoft Copilot Excel to analyze your data, such as the top three key trends.

Step 4: You will find the answer by the Microsoft Copilot within a few seconds.

display of copilot chatbot reply

Step 5: You will want to ask Microsoft Copilot a follow-up question, which will take you to a new sheet and a sandbox to play in.

display of copilot sandbox

Step 6: Proceed to ask Microsoft Copilot Excel to visualize the data, which will make Microsoft Copilot add some color to help you trace the issue.

display of asking copilot to color code

Step 7: Ask another “what-if” question for a deeper follow-up.

asking copilot what-if question

Step 8: You will find that Microsoft Copilot will answer your question and create a simple model for your better understanding of the situation with the help of a step-by-step breakdown.

copilot breaking down answer

Step 9: You can ask Microsoft Copilot Excel to create a graph of the projected model. You will find that Microsoft Copilot in Excel can turn massive data into clear actions and insights.

displaying Microsoft Copilot in Excel

Best Free Alternative to Microsoft Copilot – WPS AI

Since Microsoft Copilot is not available for the use of the general population, you will want to look for the best alternative, which is WPS AI. WPS AI Is an AI application that is based on a big language model. You might think of it in terms of Microsoft Copilot Excel – only better.

display of WPS AI product

WPS AI enables you to generate documents, process existing documents, and support various rounds of dialogue. WPS AI is one of the greatest content collaborative editing tools, which can be integrated into the entire line of Office products.

Advantages of WPS AI

The following are the advantages of using WPS AI:

  • Seamless integration with WPS Office

  • Monthly updates

  • Integrates advanced algorithms

  • Helps users revolutionize their creative process

  • You can use it on-the-go

  • Benefit from its free basic functions

  • WPS AI is for everyone – it is not limited to Office use

Features of WPS AI

Here are the potential features of WPS AI:

Use it for Creativity

With WPS AI, you can no longer experience writer’s block. You can do so much with WPS AI, such as translating documents, resume writing, writing a letter, lyric generation, and any other area of the creative process.

Create Assessments/ Summaries

With WPS AI, you no longer feel overloaded with information, as this can help you assess and summarize lengthy informative documents by making concise summaries. This way, you can use WPS AI to save time and stay ahead of your task.

Seamless Conversations with PDFs

Another potential feature of WPS AI includes seamless conversations with PDFs and unlocking new inquiries and insights. This way, you can use the AI tool to gain new perspectives and streamline workflow.

Unleash the Data Genius in Excel

Similar to Microsoft Copilot Excel, you can use WPS AI to assess complex data sets and gain valuable information in no time. This way, you can use WPS AI to identify the latest trends, make informed decisions, and unlock detailed data insights with the help of intuitive commands.

Text Recognition OCR Reinvented

You can use WPS AI to extract document texts instantly through OCR. WPS AI incorporates the latest OCR technology, which can save you loads of time and effort as it eliminates manual data entry and essentially revolutionizes document processing.

WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
Algirdas Jasaitis

How to Download WPS AI

You will want to follow the steps given below to download WPS AI:

Step 1: Open your browser and type WPS AI.

WPS AI product display

Step 2: Proceed to sign up and secure instant access to WPS AI.

WPS AI product download option

Step 3: Proceed to fill out the registration form.

Step 4: Open your email and follow the instructions to successfully install WPS AI on your system after you have gained approval.

WPS AI approval

Step 5: Launch WPS AI and start using its amazing features.

WPS AI features display


Q1: How to install Microsoft Copilot?

Answer: Currently, the Microsoft Copilot tool is only available for the use of Visual Studio code. To install MS Copilot, you will want to go to the GitHub Copilot extension page and install it. Proceed to open Visual Studio Code and click Install.

Q2: Is Microsoft Copilot free?

Answer: GitHub Copilot offers plans for businesses and individuals alike. The pricing can range from $10 to $100 per year. Microsoft Copilot will be available for $30 for commercial customers.

WPS AI – the Best Alternative to Microsoft Copilot

WPS Office is the ultimate software suite that will boost your productivity level and save you time and effort in the long run. WPS Office is a convenient Office Suite for work and study. WPS Office has everything that you need, including PDF Editor, Presentation, and Spreadsheet.

WPS Office offers many free templates that you can use for different situations, such as Spreadsheet templates, Work templates, Word templates, and PPT templates. The best part about using WPS Office is that it can be used on Android, Mac, and PC.

Nonetheless, the WPS AI is the ultimate game-changer as it enables its users to seamlessly collaborate, assess trends, extract insights, and create reports, and ultimately speed nip the entire process.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.