Skip to Main Content
Office 2013 All-In-One Absolute Beginner’s Guide
book

Office 2013 All-In-One Absolute Beginner’s Guide

by Patrice-Anne Rutledge
August 2013
Beginner content levelBeginner
704 pages
18h 22m
English
Que
Content preview from Office 2013 All-In-One Absolute Beginner’s Guide

21. Filtering and Consolidating Data

In This Chapter

Filtering Data

Managing Filters

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 create a list of unique items, delete duplicates, and consolidate data.

Filtering and consolidating data are important tools in Excel, especially when you are dealing with large amounts of data. The filtering tools can quickly reduce the data to the specific records you need to concentrate on. The consolidation tool can bring together information spread between multiple sheets or workbooks.

Filtering Data

To make the most out of Excel’s filtering capabilities, your data should adhere to a few basic formatting ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office 2013 QuickSteps, 3rd Edition

Microsoft® Office 2013 QuickSteps, 3rd Edition

Carole Matthews, Marty Matthews, Bobbi Sandberg
Office 2013: The Missing Manual

Office 2013: The Missing Manual

Nancy Conner, Matthew MacDonald

Publisher Resources

ISBN: 9780133391541Purchase book