Tech Hub

Home
Tech Hub
Highlight, sort, and filter your data with Copilot in Excel
Microsoft CopilotHighlight, sort, and filter your data with Copilot in Excel
With Microsoft 365 Copilot, it’s easy to highlight, sort, and filter your tables (or data in another supported format) to quickly call attention to what matters to you. With a single table, you can effortlessly:
  • Sort and filter your data.
  • Apply conditional formatting.
To get started, format your data in a supported format and select the Copilot button in the ribbon. Then, tell Copilot how you’d like to manipulate the table to better view portions of your data. You can type in your own words or use the suggested prompts.

Give it a try

To highlight your data, try this:
  • Bold the top 10 values in the Sales column. Screenshot of how to bold values using Copilot in Excel.
  • Highlight the highest values in Units Sold. Screenshot of how to highlight values using Copilot in Excel.
To sort your data, try this:
  • Sort engagement rate from smallest to largest.  ​​​​​​​​​​​​​​ Screenshot of how to sort data using Copilot in Excel.
To filter your data, try this:
  • Filter to items that are due next week. Screenshot of how to filter data using Copilot in Excel.

About This Page

The Tech Hub is your go-to resource for IT support and tool training. Find how-to guides, troubleshooting tips, and best practices for platforms like Outlook, Teams, OneDrive, Calendly, and more.

Can’t Find What You’re Looking For?

If you still need help or can’t locate the info you need, submit an IT support ticket and we’ll get back to you as soon as possible.

Submit an IT Ticket

What’s New

Record-Breaking Summer at Big Think Capital 🌟
This August, Big Think Capital hit a new milestone — funding 1,075 deals totaling $32.56M. A record-breaking summer powered by teamwork, momentum, and dedication. 💪🌟
🎲 Win Your Way to Vegas! 🎲
🔥 The road to Vegas starts now! From 9/5–10/17, each sales team battles head-to-head — and the top performer from every team wins a spot to represent BTC at the B2B Finance Expo in Las Vegas. Outperform. Outshine. Vegas is the prize. 🎲✨
🏆 Introducing the Legends Club 🏆
🏆 The Legends Club celebrates agents who achieve extraordinary results, with exclusive perks like your portrait on the Legends Wall, custom gear, and annual outings. Greatness starts here.
Welcome our New Team Member: Scott Smith
🚀 Excited to welcome Scott Smith as our newest Funding Associate! With a background as a pro athlete, entrepreneur, and Johns Hopkins graduate, Scott brings energy and expertise to help businesses thrive.
Big Think Capital Launches President’s Club — Celebrate Excellence with a Tropical Getaway
The President’s Club is Big Think Capital’s newest recognition program, honoring our top performers with an exclusive tropical getaway this January. Club members earn their spot by surpassing ambitious goals, driving company success, and embodying excellence every day. This is more than a trip — it’s a celebration of hard work, teamwork, and achievement.
View All

Quick Launch

OneDrive
Outlook
Calendly
Slack
BTC U
Website
Box
Paychex
Ring Central
Salesforce
TrustPilot
Spinify

Quote of the Day