Get a Handle on Duplicates in Your Excel Data

OVERVIEW

Excel expert David H. Ringstrom, CPA, shows you how to identify and manage duplicate data within your spreadsheets in this live Microsoft Excel training. 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 explains how to use the MATCH worksheet function to help you identify discrepancies in two different lists, how VLOOKUP will stop searching for duplicates after an initial match in found within a list, and how to use Excel’s Data Validation feature to create a rule that ensures users can’t enter the same data more than once in a given area of a spreadsheet.

WHY SHOULD YOU ATTEND

David will demonstrate techniques from Excel 2016, 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.

AREAS COVERED IN THIS WEBINAR

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

LEARNING OBJECTIVES

• 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.

WHO WILL BENEFIT

Practitioners seeking to identify and manage duplicate data in Excel.

SPEAKER PROFILE

David Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences and presents webinars to thousands of attendees annually on Excel and other topics. He has written hundreds of freelance articles on spreadsheets, some of which have been published internationally. David's catch phrase is "Either you work Excel or it works you." His goal is to make you a smarter and more effective spreadsheet user.

Others Details

For more details and updates please visit webinar website