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

Home › Learn Excel › Test

Excel data skills test: sort, filter, pivot tables

No hints this time. Do each task in the Excel window and see your score: 70% or more and you've passed.

  1. Sort and filter.
  2. Remove duplicates.
  3. A pivot table.
  4. Conditional formatting.
  5. Freeze Panes.
  6. Paste Special.

← All lessons