Skip to Content

Microsoft® Excel: Filtering, sorting and duplicates

Format: On-demand

This course is for Microsoft® Windows Excel 2013 and newer versions, including 365. This course will be an overview of:

  • How to use filtering capabilities to find a subset of spreadsheet data meeting one or more criteria.
  • How to use sorting capabilities to sort a spreadsheet's rows or columns based on a single or multiple criteria.
  • Remove duplicate rows from a spreadsheet.

Becker’s Microsoft® Excel Series features Wayne Winston, Microsoft® Press author for more than a decade with 40 teaching awards for his instruction. Wayne is sought out by many of the Big 4 and larger corporations to bring their personnel to a level playing field with Microsoft® Excel, necessary today for success in the accounting profession.

Wayne’s success as a Microsoft® Excel instructor is closely tied to his teaching style that has students watch and then do realistic, engaging problems in the software. Students learn through using Microsoft® Excel to cement their understanding before progressing to the next building block.

Learning Objectives

After completing this course, the learner should be able to:

  • Master basic, number and Top 10 filters.
  • Learn how to use text, date, and color filters.
  • Learn how to sort based on single or multiple criteria involving numbers and/or text.
  • Learn how to sort based on color and/or dates.
  • Learn how to sort across, perform case sensitive sorts or use Custom Lists in sorting.
  • Learn how to remove duplicate rows based on one or multiple columns.

Available Formats