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