Sorting and filtering are essential tools for analysing Excel data, but applying multiple criteria manually can slow you down: especially with large datasets. In this lesson, you'll learn how to use Copilot to quickly organise and refine your data using simple prompts. You'll see how Copilot can sort data by key columns, such as ranking revenue from highest to lowest, and apply single or multiple filters to display only the records you need. Whether you're narrowing down overdue invoices or focusing on specific product categories, Copilot makes data exploration faster, easier, and more intuitive.
Ideal for those looking to streamline workflows and make more effective use of Microsoft 365 applications.
- Use Copilot in Excel to sort large datasets based on specific columns and criteria
- Create effective Copilot prompts to organise data, such as sorting values from highest to lowest
- Leverage Copilot to quickly isolate records based on conditions like status or category
