Highlighting and Filtering Data in Excel - HLS Copilot Snacks

[Mike Gannotti]

If you have a lot of data in your Excel spreadsheet and you want to focus on specific values or categories, you can use Copilot for Microsoft 365 to highlight and filter your data easily. Copilot can help you apply conditional formatting, color scales, icon sets, and data bars to your table, so you can see patterns and trends at a glance. You can also use Copilot to filter your data by text, numbers, dates, colors, or icons, and create custom filters based on your criteria. Watch this Copilot Snack to learn how to highlight and filter your data in Excel with Copilot.

To see all HLS Copilot Snacks video click here.

Resources:

• HLS Copilot Snacks (microsoft.com)
• Microsoft Copilot for Microsoft 365 documentation | Microsoft Learn
• Copilot Lab (cloud.microsoft)
• Copilot in Excel help & learning (cloud.microsoft)
• Prompts
  • Bold the top 10 values in the Gross Sales column
  • Highlight the highest values in Units Sold
  • Sort COGS from smallest to largest

To see all HLS Copilot Snacks video click here.

Thanks for visiting – Michael Gannotti LinkedIn