Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Chapter 33

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 worksheet. Sometimes they want to extract, or filter out, a subset of their sales data to answer various questions. For example:

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

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

• How can I copy all the 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 column or worksheet range?

• How can I identify ...