Excel: Filtering Data for Beginners (2019)
30mBeginner2019-01-18
Authors
Dave Ludwig
Content Strategist for Microsoft Excel
Course details
Did you know Excel enables you to zero in on exactly the data you need with the click of a mouse? In this short course, Microsoft Excel content publisher Dave Ludwig shows the ins and outs of filtering in Excel. He shows how to filter for text, numeric values, and ranges of data. Dave also shows how to filter with color coding, and how to use advanced filtering options such as slicers and shortcuts. Advance your Excel skills in minutes with this mini course.
Learning objectives
Identify the purpose of a filter.
Recognize situations in which a custom filter would be most effectively utilized.
Summarize the method Excel uses to read data when an Advanced Filter is applied.
Recall the approach to take when creating a specific item for a picklist.
Explain the function of a dynamic array formula.
Name the keyboard shortcut used to make the filter menus appear in Excel.
Learning objectives
Identify the purpose of a filter.
Recognize situations in which a custom filter would be most effectively utilized.
Summarize the method Excel uses to read data when an Advanced Filter is applied.
Recall the approach to take when creating a specific item for a picklist.
Explain the function of a dynamic array formula.
Name the keyboard shortcut used to make the filter menus appear in Excel.
Skills covered
SpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoftDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Zero in on the right data with filters in Excel
- 02 - What you should know
1. Basic Filter Concepts
- 03 - What is a filter
- 04 - Types of filters
2. Refining Filters
- 05 - Custom filters
- 06 - Advanced filters
- 07 - Filter for unique values
- 08 - Filter with a formula
3. Filtering Tips
- 09 - Use slicers to filter
- 10 - Use Power Query to filter
- 11 - Shortcut keys for filtering
Conclusion
- 12 - Next steps