Excel Explained: Dealing with Duplicate Data

Are you frustrated with duplicates frequently showing up in your spreadsheets and don’t know how to identify and manage them? If so, you’ll want to attend this live webcast presented by Excel expert David H. Ringstrom, CPA. He covers a variety of topics, including identifying duplicate data visually by way of the Conditional Formatting feature, using a pivot table to determine how many duplicates are in a list, and applying worksheet functions like SUMIF or COUNTIF to sum or count instances of duplicates.

In addition, David shows you how to:

  • Use the MATCH worksheet function to help identify differences in two different lists.
  • Use the COUNTIF function to determine the number of times an item appears on a list.
  • Create a data validation rule that ensures users can’t enter the same data more than once in a given area of a spreadsheet.
  • Eliminate duplicates from a list with just a few mouse clicks.
  • Use Conditional Formatting to color-code your data, identify duplicates, and apply icons—and much more.
David typically demonstrates techniques from the version of Excel used by the majority of attendees. This means he uses Excel 2010, 2013, or 2016 to demonstrate techniques, but his detailed handouts identify differences in Excel 2007, 2010, 2013, and 2016 when needed. His webcasts are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants’ questions, so come ready to pick his brain.

David’s detailed handouts, with numbered steps, serve as reference material you can utilize going forward. He also provides an Excel workbook that includes most of the examples he uses during the webcast.

What You Will Learn:

  • Apply the Advanced Filter feature and the Remove Duplicates feature.
  • Define how to visually identify duplicate records with the Conditional Formatting feature.
  • Identify how to use a pivot table to quickly ascertain how many times duplicates appear within a list.
  • Create a data validation rule that prevents users from entering the same data more than once in a list.
  • Eliminate duplicates from a list with just a few mouse clicks.
  • Filter list entries based on colors that you apply manually or with Conditional Formatting.
  • Identify duplicates in a list using Conditional Formatting.
  • Improve the integrity of spreadsheets with Excel’s VLOOKUP function.
  • Learn how VLOOKUP stops looking after it finds an initial match within a list.
  • See how to instantly determine the number of duplicates in a list with a pivot table.
  • Learn the mouse trick that lets you quickly make a copy of an existing worksheet.
  • Understand why numeric data may appear in a pivot table more than once, and how to correct the problem.
  • Use a wildcard character with SUMIF to summarize data based on a partial match.
  • Use Conditional Formatting to color-code your data, identify duplicates, and apply icons.
  • Use Excel’s COUNTIF function with Conditional Formatting to highlight the second and beyond instances of entries on a list.
  • Use the COUNTIF function to determine the number of times an item appears on a list.
  • Use the MATCH worksheet function to identify differences between two different lists.
  • Use the Reapply command to refresh a list as you correct duplicate instances.
  • Use the SUMIF function to summarize data based on a single criterion.

Who Should Attend?

Practitioners seeking to identify and manage duplicate data in Excel.


Connection Error #D55. For immediate assistance, please use our online chat (lower right corner of this page).
   OnDemand Recording Only - $295   
   CD-ROM and Hardcopy Handouts - $345