Excel expert David Ringstrom, CPA, teaches you how to identify and manage duplicate data within your spreadsheets in this beneficial presentation. David 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.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.  

Topics Covered:

  • Using the Reapply command to remove items that are no longer duplicated within a list.
  • Using the MATCH worksheet function to identify differences between two different lists.
  • Employing pivot tables to count the number of times an item appears in a list.
  • Duplicating the formatting of one chart into a second chart.
  • Copying dates within an Excel worksheet in the manner you want.
  • Resolving situations where data appears more than once within a pivot table.
  • Using Excel’s Advanced Filter feature to identify duplicates within a list.
  • Eliminating duplicates from a list with just a few mouse clicks.
  • Duplicating columns, rows, or cells within an Excel worksheet.
  • Unlocking Data Validation cells in anticipation of protecting a workbook.
  • Creating a Data Validation rule that prevents users from entering the same data more than once in a list.



Learning Objectives
  • Discover how to apply the Advanced Filter feature and the Remove Duplicates feature.
  • Identify how to use a pivot table to quickly ascertain how many times duplicates appear within a list.
  • Recognize how to eliminate duplicates from a list with just a few mouse clicks.
Last updated/reviewed: August 6, 2023
3 Reviews (18 ratings)


Anonymous Author
This class was very throughout on explaining and making sure to highlight the removal of duplicate values.

Anonymous Author
This is a very informative course that provide lots of great tricks to perform tasks effectively.

Anonymous Author
Covered a lot of material, good use of examples tp highlight different techniques

Course Complexity: Intermediate

Program Prerequisites: Experience Working with Excel Spreadsheets Is Recommended

Advance Preparation: None

Education Provider Information
Company: Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact: For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Instructor for this course
Course Syllabus
  Introduction to Excel Efficiency: Dealing with Duplicates07:28
  Duplicating Columns, Rows, or Cells11:17
  Copy Formatting to a Chart10:19
  Copying Dates08:10
  Advanced Filter - Duplicates in Place07:01
  UNIQUE Function (Office 365 Only)10:25
  Resolving Pivot Table Duplicate Values7:59
  Counting Text Instances in a Pivot Table07:24
  Conditional Formatting - Duplicates07:00
  Remove Conditional Formatting9:16
  Unlocking Data Validation Cells09:11
  Introduction to VLOOKUP10:58
  Excel Efficiency: Dealing with Duplicates1:46:35
  Slides: Excel Efficiency: Dealing with DuplicatesPDF
  Excel Efficiency: Dealing with Duplicates Glossary/IndexPDF
  Workbook: Excel Efficiency: Dealing with DuplicatesXLSX
  Review Questionsquiz
 Final Examexam