Protected Learning Content

AICPE Gurukul content is created for learning purposes. Printing, copying and unauthorized reuse are restricted.

AICPE Learning Hub MS Office Applications
Chapter 18
Sorting and Filtering Data in Excel
Previous Excel Functions: SUM, AVERAGE, MIN, MAX and COUNT Next Excel Charts and Data Visualization
Chapter 18 | Excel Data Management

Sorting & Filtering Data in Excel

Sorting and filtering help you arrange, search and analyze large data quickly. In this chapter, you will learn how to sort names, numbers, dates and use filters to display only required records.

Start Learning Practice Task

Sort A to Z

Arrange names or text alphabetically.

Number Sort

Arrange values from smallest to largest or highest to lowest.

Filter

Display only selected records from a large list.

Date Filter

Find records based on dates and time periods.

Learning Objectives

After This Chapter, You Will Be Able To

This chapter helps you manage large Excel lists professionally.

Sort Text

Arrange names, cities and courses alphabetically.

Sort Numbers

Arrange fees, marks, salary or quantity values.

Apply Filter

Show only records matching a selected condition.

Analyze Records

Find paid, pending, top marks or due records quickly.

Simple Meaning

What are Sorting and Filtering?

Sorting arranges data. Filtering displays only selected data.

1 Easy Explanation

Sorting means arranging data in a specific order, such as A to Z, Z to A, smallest to largest, largest to smallest or oldest to newest. Filtering means showing only records that match selected conditions.

Definition: Sorting arranges records in order, while filtering temporarily hides unwanted records and shows only required records.
Professional Tip: Before sorting, make sure the entire table is selected or formatted as a proper data range.
student-fee-record.xlsx Filter Applied
Sort A-ZSort Smallest-LargestFilterStatus: Due
ABCDE
1Name ▼Course ▼Total Fee ▼Paid ▼Status ▼
2AmitMS Office50003000Due
3RahulExcel40002000Due
Sorting

Types of Sorting in Excel

Sorting helps arrange records in a meaningful order.

Sort Type Meaning Example Use
A to Z Arranges text alphabetically Student names from Amit to Zoya
Z to A Arranges text in reverse alphabetical order Names from Zoya to Amit
Smallest to Largest Arranges numbers in increasing order Fees from low to high
Largest to Smallest Arranges numbers in decreasing order Marks from high to low
Oldest to Newest Arranges dates from earlier to later Admission date order
Newest to Oldest Arranges dates from latest to earlier Latest payment records first
Quick Tip: Use Sort A to Z for names and Sort Largest to Smallest for ranking marks or sales.
Filtering

Using Filters in Excel

Filters show only the records you want to view.

Text Filter

Filter names, cities, courses, status or categories.

Number Filter

Filter marks, fees, salary or quantity based on value.

Date Filter

Filter admissions, payments or due dates by period.

Color Filter

Filter cells based on fill color or font color.

Example: In a fee record, filter Status column to show only “Due” students.
Custom Sort

Sorting by More Than One Column

Custom Sort is used when you want to sort data using multiple conditions.

2 What is Custom Sort?

Custom Sort allows you to sort data by more than one column. For example, first sort by Course name and then sort by Student Name inside each course.

Custom Sort: A sorting option used to arrange data using multiple levels or selected columns.

3 Custom Sort Examples

  • Sort by Course, then by Name.
  • Sort by Status, then by Balance Fee.
  • Sort by City, then by Admission Date.
  • Sort by Department, then by Salary.
  • Sort by Class, then by Marks.
Practical Uses

Where Sorting and Filtering Are Used

Sorting and filtering are daily-use tools in Excel work.

Work Area Sorting Use Filtering Use
Student Fee Record Sort by balance high to low Show only due students
Attendance Sheet Sort by attendance percentage Show students below 75%
Sales Report Sort highest sales first Show selected region or product
Stock Register Sort by quantity low to high Show low stock items
Employee List Sort names alphabetically Show department-wise employees
Before and After

Example: Finding Due Fee Students

Filtering helps find required records from a large sheet.

Without Filter

Amit - Due
Priya - Paid
Rahul - Due
Sneha - Paid
Karan - Due

Problem: You must manually search due students from the complete list.

With Filter Applied

Name Course Balance Status
Amit MS Office 2000 Due
Rahul Excel 1500 Due
Karan PowerPoint 1000 Due
Learning Point: Filtering does not delete data. It only hides records that do not match the condition.
Interactive Demo

Try Sorting and Filtering

Click buttons to sort or filter the sample data.

Name Course Balance Status
Original data is displayed.
Practical Task

Create a Sortable and Filterable Fee Record

Complete these steps inside MS Excel.

Office Task: Student Fee Sorting and Filtering

Common Mistakes

Mistakes Students Should Avoid

Sorting and filtering need clean data and careful selection.

Wrong Habits

  • Sorting only one column instead of full table.
  • Leaving blank rows inside the data table.
  • Using unclear column headings.
  • Forgetting that filters hide data temporarily.
  • Printing filtered data without checking.
  • Not clearing filters after use.

Correct Habits

  • Select the full table before sorting.
  • Keep data continuous without blank rows.
  • Use clear headings for every column.
  • Remember filters do not delete records.
  • Check visible records before printing.
  • Clear filters when complete data is needed.
Remember: If sorting is done incorrectly, row data may mismatch. Always select the complete data range.
Test Your Understanding

Quick Quiz

Select the correct answers and check your score.

1. Sorting means:

Sorting arranges data in a specific order.

2. Filtering means:

Filtering displays only records that match selected conditions.

3. A to Z sorting is useful for:

A to Z sorting is used to arrange text alphabetically.

4. Largest to Smallest sorting is useful for:

Largest to Smallest sorting arranges numeric values from high to low.

5. Before sorting, you should usually select:

Selecting the complete data range helps avoid row mismatch after sorting.

6. Filtered data is:

Filtering temporarily shows only records matching the condition.

7. Custom Sort is used to:

Custom Sort allows sorting by multiple columns or levels.

8. Which filter can show only “Due” fee students?

A text filter on the Status column can show only Due records.

9. Which is a common sorting mistake?

Sorting only one column can mismatch rows and damage the data structure.

10. Best filtering habit is:

Clear filters when you need to view the complete data list again.
Quick Revision

Remember These Points

Revise these before moving to Chapter 19.

Sorting

Arranges data in a specific order such as A to Z or high to low.

Filtering

Shows only records that match selected conditions.

Text Sort

Used to arrange names, courses, cities and categories.

Number Sort

Used to arrange marks, fees, salary, stock or sales values.

Custom Sort

Used to sort by multiple columns or levels.

Next Step

Now learn Excel charts and data visualization.

Previous Chapter Next Chapter: Excel Charts and Data Visualization