Explanation
When data is converted into an Excel Table, sorting and filtering become easier.
Select the data → Ctrl + T
Excel automatically adds filter buttons to the headers.
Example Table
|
Order ID |
Date |
Customer |
City |
Product |
Category |
Qty |
Sales |
|
O101 |
01-Sep-26 |
Amit |
Sirsa |
Keyboard |
Accessories |
5 |
4000 |
|
O102 |
02-Sep-26 |
Neha |
Hisar |
Mouse |
Accessories |
10 |
5000 |
|
O103 |
03-Sep-26 |
Rahul |
Sirsa |
Monitor |
Hardware |
3 |
25500 |
|
O104 |
04-Sep-26 |
Priya |
Fatehabad |
Printer |
Hardware |
2 |
24000 |
|
O105 |
05-Sep-26 |
Amit |
Sirsa |
Keyboard |
Accessories |
5 |
4000 |
|
O106 |
06-Sep-26 |
Simran |
Hisar |
Webcam |
Accessories |
4 |
10000 |
Practical Workflow
Select Data → Ctrl + T → Sort → Filter → Analyze
Practice
Convert the dataset into an Excel Table and create:
- Highest Sales first
- Sirsa records only
- Accessories only
- Sales above ₹10,000