Get a Handle on Duplicates in Your Excel Data 2017

Topics

• Eliminate duplicates from a list with just a few mouse clicks
• The mouse trick that lets you quickly make a copy of an existing worksheet
• Filter list entries based on colors that you apply manually or with Conditional Formatting
• Identify duplicates in a list using Conditional Formatting
• Use Conditional Formatting to color-code your data, identify duplicates, and apply icons
• Use the Reapply command to refresh a list as you correct duplicate instances
• 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
• Why numeric data may appear in a pivot table more than once, and how to correct the problem
• Use the MATCH worksheet function to identify differences between two different lists
• Improve the integrity of spreadsheets with Excel’s VLOOKUP function
• How to instantly determine the number of duplicates in a list with a pivot table
• Use the SUMIF function to summarize data based on a single criterion
• How VLOOKUP stops looking after it finds an initial match within a list
• Create a data validation rule that prevents users from entering the same data more than once in a list
• Use a wildcard character with SUMIF to summarize data based on a partial match

Who should Attend

Attendees involved or interested in identifying and managing duplicate data in Excel.