Overview
-
Make the most of the filtering capabilities in Microsoft Excel. Learn how to use filters to zero in on exactly the data you need.
Syllabus
-
Introduction
- Zero in on the right data with filters in Excel
- What you should know
- What is a filter?
- Types of filters
- Custom filters
- Advanced filters
- Filter for unique values
- Filter with a formula
- Use slicers to filter
- Use Power Query to filter
- Shortcut keys for filtering
- Next steps
