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.
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.
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.
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 .
Tired of Microsoft Edge draining your laptop battery fast? Get instant fixes with this step-by-step troubleshooting guide for Microsoft Edge laptop battery drain fix. Boost battery life now!
Tired of Microsoft Edge crashing with "Bad Image" after Windows Update? Discover quick, step-by-step fixes to restore your browser fast. No tech skills needed!
Master how to transfer Microsoft Edge bookmarks to a new computer with foolproof methods: sync via Microsoft account, export/import HTML, or cloud backups. Quick, safe steps for seamless migration.
Tired of annoying Microsoft Edge microphone background noise ruining your calls? Discover step-by-step solutions to solve Microsoft Edge microphone background noise for flawless video conferences and recordings in Edge.
Tired of Microsoft Edge extensions crashing? This step-by-step 2026 guide delivers quick, proven fixes to restore stability. Update, reset, and troubleshoot like a pro—no tech skills needed!
Stuck with Microsoft Edge Error 404 Page Not Found? Follow our proven step-by-step troubleshooting guide to fix it fast, clear cache, reset settings, and browse without interruptions. Get back online now!
Struggling with Microsoft Edge HTTP Error 500? Discover step-by-step fixes for Internal Server Problems, from cache clearing to advanced troubleshooting. Get back online fast!
Struggling with Microsoft Edge "DirectX Runtime" compatibility errors? Discover step-by-step fixes to resolve crashes, video glitches, and performance issues in Edge. Get back to smooth browsing today!
Struggling with ERR_SSL_PROTOCOL_ERROR in Microsoft Edge? Discover step-by-step fixes for SSL protocol errors, from clearing cache to advanced resets. Get back online fast with our ultimate guide.
Tired of Microsoft Edge "Script Error" ruining your prints? Follow our proven, step-by-step guide to fix it quickly—no tech expertise required. Works on the latest Edge versions for seamless printing.
