Excel: Filtering Data for Beginners

Make the most of the filtering capabilities in Microsoft Excel. Learn how to use filters to zero in on exactly the data you need.

Introduction

• Zero in on the right data with filters in Excel
• What you should know

1. Basic Filter Concepts

• What is a filter?
• Types of filters

2. Refining Filters

• Custom filters
• Advanced filters
• Filter for unique values
• Filter with a formula

3. Filtering Tips

• Use slicers to filter
• Use Power Query to filter
• Shortcut keys for filtering

Conclusion

• Next steps