Module 07: Copilot in Excel Foundations
Lesson 07.5: Sorting, Filtering, Highlighting, and Cleaning Data
Lesson Promise
Use Copilot for practical table operations while keeping a visible audit trail of what changed.
Real-World Scenario
A customer success manager needs to find risky accounts, flag late renewals, and prepare a clean view for a weekly review.
Core Concept
Sorting, filtering, highlighting, and cleaning feel simple, but they can hide rows, change context, or make a review appear more certain than it is.
Use Copilot to propose operations, not blindly perform them. Ask what will change, what rows are affected, and how to undo or verify the operation.
For review work, create a saved view or helper column rather than destroying the original context. The audience should know which criteria produced the view.
Step-By-Step Workflow
- Define the review question and risk criteria.
- Ask Copilot to recommend filters, sorts, highlights, or helper columns.
- Apply one operation at a time.
- Check row counts before and after filtering.
- Create a short criteria note near the table or in a separate sheet.
- Reset filters and confirm the original data is still available.
Prompt Lab
Bad Prompt
Find risky customers.
Better Prompt
Highlight accounts where Renewal Date is within 45 days, Health Score is below 70, or Open Tickets are above 5. Explain the criteria used.
Expert Prompt
Act as a customer success operations analyst. For this Accounts table, propose filters, highlights, and helper columns to identify renewal risk. Use Renewal Date, Health Score, ARR, Open Tickets, and Last QBR Date. Show the criteria, expected row count impact, business reason, and manual verification step before applying each change.
Hands-On Exercise
Build a risk review view using filters or highlights, then document the exact criteria used.
Deliverable
A reviewed table view with visible criteria, row-count check, and reset/undo note.
Excel Review Checklist
Common Mistakes
- Asking one broad analysis question and accepting the first answer.
- Using messy data with duplicate headers, blank columns, hidden assumptions, subtotals, or merged cells.
- Treating Copilot's formula, chart, or insight as correct before manual verification.
- Mixing private or regulated data into an unapproved workflow.
- Promising a feature before checking the learner's license, account, app version, file state, and tenant settings.
Quiz / Checkpoint
Why should you check row counts when filtering data?
Row counts help confirm that the filter affected the expected records and did not accidentally hide important data.
Official Sources To Verify
- Get started with Copilot in Excel
- Format data for Copilot in Excel
- Frequently asked questions about Copilot in Excel
- Generate formula rows and columns with Copilot in Excel
- Understand formulas with Copilot in Excel
- Visualize your data with Copilot in Excel
- Get insights about numerical data with Copilot in Excel
- Edit with Copilot in Excel
- Copilot Chat in Microsoft 365 apps
- What Copilot license do I have
Want your AI product explained to a large AI-native audience?
Kingy AI helps AI companies turn complex products into clear, useful YouTube videos that drive awareness, product understanding, demos, clicks, and search visibility.
