Get a Handle on Duplicates in Your Excel Data 2017 is a webinar that covers topics such as:
- 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
Get a Handle on Duplicates in Your Excel Data 2017 is intended for attendees involved or interested in identifying and managing duplicate data in Excel.