O'Reilly logo

My Excel 2016 by Tracy Syrstad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

11. Filtering and Consolidating Data

Image

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:

Removing duplicate rows

→ Creating a unique list of items

→ Filtering for specific records

Consolidating information from multiple workbooks

Filtering a protected sheet

→ 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required