Skip to Main Content
Microsoft® Excel® 2010: Data Analysis and Business Modeling
book

Microsoft® Excel® 2010: Data Analysis and Business Modeling

by Wayne L. Winston
January 2011
Beginner to intermediate content levelBeginner to intermediate
720 pages
23h 29m
English
Microsoft Press
Content preview from Microsoft® Excel® 2010: Data Analysis and Business Modeling

Chapter 46. Filtering Data and Removing Duplicates

Questions answered in this chapter:

Joolas is a small company that manufactures makeup. Its managers track each sales transaction in a Microsoft Excel 2010 worksheet. Sometimes they want to extract, or “filter out,” a subset of their sales data. For example, they might want to identify sales transactions that answer the following questions:

  • How can I identify all transactions in which Jen sold lipstick in the East region?

  • How can I identify all transactions in which Cici or Colleen sold lipstick or mascara in the East or South region?

  • How can I copy all transactions in which Cici or Colleen sold lipstick or mascara in the East or South region to a different worksheet?

  • How do I clear filters from a ...

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 Excel® 2007: Data Analysis and Business Modeling, Second Edition

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition

Wayne L. Winston
Microsoft® Excel 2010 On Demand

Microsoft® Excel 2010 On Demand

Steve Johnson - Perspection Inc.

Publisher Resources

ISBN: 9780735656864Purchase book