Learning Objectives

  • Sort data in ascending and descending order
  • Apply filters to analyze data
  • Use conditional formatting to highlight data
  • Convert text to columns
  • Implement data validation rules
  • Use freeze panes and print titles

Step-by-Step Guide

1) Sort Data

  1. Select full data range (including headers).
  2. Use Data → Sort.
  3. Sort by one or multiple levels (e.g., Region then Sales).

2) Apply Filters

  1. Enable Data → Filter.
  2. Filter by value, color, or condition.
  3. Use custom filters (contains, greater than, date range).

3) Conditional Formatting

  1. Select range.
  2. Use Home → Conditional Formatting.
  3. Add rules: duplicate values, top 10, data bars, color scales.

4) Text to Columns

  1. Select combined text column.
  2. Go to Data → Text to Columns.
  3. Choose delimiter or fixed width.

5) Data Validation

  1. Select input cells.
  2. Go to Data → Data Validation.
  3. Set allowed values, ranges, or date limits.

6) Freeze Panes and Print Titles

  • Freeze top row/first column for large sheets
  • Set print titles for repeated headers in printouts

Practice Task

Using a 300-row dataset:

  • Multi-level sort
  • 3 filter scenarios
  • 2 conditional formatting rules
  • 1 text split operation
  • Validation list for status column
  • Freeze panes + print-ready setup

📚 Continue to: Pivot Tables and Charts