How to use Copilot in Excel

Microsoft Copilot is an AI assistant that can be integrated into many MS Office applications, including Excel. With Copilot, users can completely use it to summarize data, organize spreadsheets, and support formulas in Excel data tables. Thus, we have an additional support tool to process data tables in Excel. Below are instructions for using Copilot in Excel.

How to use Copilot in Excel

Step 1:

After adding Copilot to Excel  , click the Copilot icon in the upper right corner to use it.

How to use Copilot in Excel

Step 2:

Now on the right side of the interface will display a chat board with Copilot for us to use. Here the user can enter the request they want Copilot to process the data table in Excel.

How to use Copilot in Excel

For example, if you want Copilot to filter the 5 lowest revenue values, you enter Highlight the lowest 5 revenue fields. At this time, Copilot will analyze the data to find the 5 lowest values. As a result, you will see those 5 values ​​highlighted in the table.

How to use Copilot in Excel

The Copilot editing feature in Excel can also help you sort and filter data. For example, if you want to sort the budget column from largest to smallest, type Sort the budget column largest to smallest.

In addition to processing data, Copilot also has the ability to draw charts, according to your requirements. For example, if you want to draw a chart of total money spent compared to the amount earned over time, Copilot analyzes the data, identifies the date column, budget column and revenue column. Then, Copilot suggests a chart, you click Add to new sheet to insert the chart into the content .

How to use Copilot in Excel

Sign up and earn $1000 a day ⋙

Leave a Comment

Instructions to turn off Galaxy AI on Samsung phones

Instructions to turn off Galaxy AI on Samsung phones

If you no longer need to use Galaxy AI on your Samsung phone, you can turn it off with a very simple operation. Below are instructions for turning off Galaxy AI on your Samsung phone.

How to delete AI character created on Instagram

How to delete AI character created on Instagram

If you don't need to use any AI characters on Instagram, you can also quickly delete them. Here's how to delete AI characters on Instagram.

Instructions for inserting delta symbol in Excel

Instructions for inserting delta symbol in Excel

The delta symbol in Excel, also known as the triangle symbol in Excel, is used a lot in statistical data tables, expressing increasing or decreasing numbers, or any data according to the user's wishes.

Instructions for sharing a sheet on Google Sheets

Instructions for sharing a sheet on Google Sheets

In addition to sharing a Google Sheets file with all sheets displayed, users can choose to share a Google Sheets data area or share a sheet on Google Sheets.

Instructions for disabling ChatGPT storage

Instructions for disabling ChatGPT storage

Users can also customize to disable ChatGPT memory whenever they want, on both mobile and computer versions. Below are instructions for disabling ChatGPT memory.

Instructions to see the last Windows Update time

Instructions to see the last Windows Update time

By default, Windows Update will automatically check for updates and you can also see when the last update was. Here is a guide to see when Windows last updated.

Instructions to delete eSIM on iPhone are very simple

Instructions to delete eSIM on iPhone are very simple

Basically, the operation to delete eSIM on iPhone is also simple for us to follow. Below are instructions to delete eSIM on iPhone.

How to Convert Live Photo to Boomerang on iPhone

How to Convert Live Photo to Boomerang on iPhone

In addition to saving Live Photos as videos on iPhone, users can convert Live Photos to Boomerang on iPhone very simply.

How to block SharePlay on iPhone from automatically turning on

How to block SharePlay on iPhone from automatically turning on

Many apps automatically enable SharePlay when you FaceTime, which can cause you to accidentally press the wrong button and ruin the video call you're making.

How to use Click to Do on Windows 11

How to use Click to Do on Windows 11

When you enable Click to Do, the feature works and understands the text or image you click on and then makes judgments to provide relevant contextual actions.

How to turn on laptop keyboard light, activate Keyboard Backlight on Windows 10

How to turn on laptop keyboard light, activate Keyboard Backlight on Windows 10

Turning on the keyboard backlight will make the keyboard glow, useful when operating in low light conditions, or making your gaming corner look cooler. There are 4 ways to turn on the laptop keyboard light for you to choose from below.

How to enter Safe Mode Windows 10 on startup

How to enter Safe Mode Windows 10 on startup

There are many ways to enter Safe Mode on Windows 10, in case you cannot enter Windows and cannot enter. To enter Safe Mode Windows 10 when starting the computer, please refer to the article below of WebTech360.

How to create Ghibli style photos on Grok AI

How to create Ghibli style photos on Grok AI

Grok AI has now expanded its AI photo generator to transform personal photos into new styles, such as creating Studio Ghibli style photos with famous animated films.

Instructions to register for Google One AI Premium for free for 1 month

Instructions to register for Google One AI Premium for free for 1 month

Google One AI Premium is offering a 1-month free trial for users to sign up and experience many upgraded features such as the Gemini Advanced assistant.

How to turn off recent searches on Safari

How to turn off recent searches on Safari

Starting with iOS 18.4, Apple allows users to decide whether to show recent searches in Safari.