Maximize Excel: Dealing with Duplicates
Presented by David H. Ringstrom, CPA
 
Event Date/Time: 07/31/26 12:00 PM Eastern
Duration: 100 minutes
 
If you’re tired of dealing with duplicates that show up frequently in your spreadsheets and you don’t know how to identify and manage them, you won’t want to miss this live webcast presented by Excel expert David Ringstrom, CPA. He covers a variety of topics, including identifying duplicate data visually, determining differences between two different lists using the MATCH function, applying the SUMIF function to summarize data based on a single criterion, and much more.
 
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2021, 2019, 2016 and earlier) 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.
 
Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don't change. Perpetual licensed versions have year numbers, such as Excel 2021, Excel 2019, and so on.
 
Who should attend:
Practitioners seeking to identify and manage duplicate data in Excel spreadsheets.
 
Topics covered:
 
• Copying dates within an Excel worksheet in the manner you want.
 
• Crafting self-resizing formulas with  the new Spilled Range Operator in in Excel 2021 and Microsoft 365.
 
• Creating a Data Validation rule that prevents users from entering the same data more than once in a list.
 
• Duplicating columns, rows, or cells within an Excel worksheet.
 
• Duplicating Excel worksheets in two different ways.
 
• Duplicating the formatting of one chart into a second chart.
 
• Eliminating duplicates from a list with just a few mouse clicks.
 
• Employing the SUMIF function to sum values related to multiple instances of criteria you specify.
 
• Exploring the risks and benefits of participating in the free Microsoft Office Insider program.
 
• Filtering list entries based on colors you apply manually or with Conditional Formatting.
 
• Identifying duplicates in a list using Conditional Formatting.
 
• Learning how VLOOKUP stops looking after it finds an initial match within a list.
 
Learning objectives:
• Define how to visually identify duplicate records with the Conditional Formatting feature.
• Identify which command allows you to refresh a list as you correct duplicates.
• Apply the MATCH function to identify differences in two different lists.
 
 
Level:
Intermediate
 
 
Instructional Method:
Group: Internet Based
 
NASBA Field of Study:
Computer Software & Applications (2 hours)
 
Program Prerequisites:
Experience Working with Excel Spreadsheets Is Recommended
 
Advance Preparation:
None