11. Filtering and Consolidating Data
This chapter shows you how to use Excel’s filtering functionality to look at just the desired records. It also shows you how to filter by text, values, and dates. Topics in this chapter include the following:
→ Creating a unique list of items
→ Filtering for specific records
→ Focusing on specific data by filtering by color or icon
Filtering and consolidating data are important tasks in Excel, especially when you are dealing with large amounts of data. The filtering tools can quickly reduce the data to ...