Sorting and filtering

Put lists in the right order and show only the rows you need, including filter views your team can share.

6 lessons · 52 min · Beginner to Advanced

Get the full course The same skill in Excel

Lessons

In the order the Roadmap teaches them.

In the full course. Beginner · 8 min

Sort A to Z and by numbers

Put a list in order by name or by amount, keep the header row where it is, and sort by two columns at once.

See the lesson

In the full course. Beginner · 9 min

Filter a list

Show only the rows you need by picking values or setting a condition, and know that the hidden rows still count in your totals.

See the lesson

In the full course. Confident · 9 min

Sort by several columns

Sort a list by two or three columns in the right order, and never break your rows by sorting one column alone.

See the lesson

In the full course. Confident · 10 min

Custom sort order (Low, Medium, High)

Sort a list in an order you set yourself, like High, Medium, Low, instead of A to Z.

See the lesson

In the full course. Confident · 8 min

Filter by color and condition

Show only the rows with a color you pick, and narrow them further with a condition on another column.

See the lesson

In the full course. Advanced · 8 min

Slicers

Add a slicer to a list, filter it in one click, show several items at once and clear the filter.

See the lesson

Lessons being written

Planned for this skill. They open in the course as they're finished.

Filter views

Paths with these lessons

A path is a short list of lessons from the course, picked for one goal.

Google Sheets basics in a weekend

For starting from zero, or only typing numbers into cells today.

14 lessons · about 2 h · 4 free · Beginner to Confident

See the path

Team trackers in Google Sheets

For tracking tasks, requests or projects in a shared sheet.

10 lessons · about 1 h 40 min · 1 free · Beginner to Confident

See the path

Get the full course

Every lesson in the Google Sheets course, with new lessons added as they're written.

All 215 Google Sheets lessons open today, and every new one as it's written.
The Roadmap, Skills and all seven paths.
A cheat sheet for every lesson you finish.
At checkout, add the Excel course for US$49.

US$149

Tax included · Lifetime access

Get the full course

30-day money-back guarantee if you've opened fewer than 10 paid lessons.

No account needed to pay. Payments are handled by Link, Stripe's checkout. Your card statement shows LINK.COM.