Data Management in Excel

Lessons in this section

1. Finding Data

   Find text and numbers, replace values safely, and replace formatting.

2. Sorting Data

   Sort A to Z, Z to A, and by number, sort by several columns, and use custom sort orders.

3. Filtering Data

   Apply and remove filters, and filter by value, number condition, date, and color.

4. Data Validation and Named Ranges

   Restrict numbers, dates, and text, create drop-down lists, and create and use named ranges. Then clean up a register in the Chapter 5 project.