Description
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.
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.
- Resolving situations where data appears more than once within a pivot table.
- Creating a Data Validation rule that prevents users from entering the same data more than once in a list.
Learning Objectives:
- Define 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.
- Recall how to eliminate duplicates from a list with just a few mouse clicks.
