Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Lesson 15

Sort, filter and clean data in Excel

Put data in order, show only what you need, remove duplicates, split columns and turn a list into a table.

  1. Sort and filter.
  2. Remove duplicates.
  3. Filtered rows.
  4. Split a column: Text to Columns.
  5. Turn a list into a table.

← All lessons