Filtering data

BeginnerFree

10 questions, about 14 minutes

Show only the rows you need, without deleting anything.

What we'll do

  • Turning on the filter buttons
  • Filtering on text
  • Filtering with greater than and less than

What you'll use

  • Filtering from the ribbon
  • Shortcuts on your keyboard

How it works

In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.

2examplesYou watch
10questionsYou do it yourself
Full explanation