Instructor for this course
more

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.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 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.  

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.
  • Creating a Data Validation rule that prevents users from entering the same data more than once in a list.

 

 

Learning Objectives

  • Discover 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.
  • Recognize how to eliminate duplicates from a list with just a few mouse clicks.
Last updated/reviewed: November 15, 2019

1 Review (7 ratings)Reviews

5
Anonymous Author
This class was very throughout on explaining and making sure to highlight the removal of duplicate values.

Prerequisites

Course Complexity: Intermediate

Program Prerequisites: Experience Working with Excel Spreadsheets Is Recommended

Advance Preparation: None

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
  07:28Introduction to Excel Efficiency: Dealing with Duplicates
  11:17Duplicating Columns, Rows, or Cells
  10:19Copy Formatting to a Chart
  08:10Copying Dates
  07:01Advanced Filter - Duplicates in Place
  10:25UNIQUE Function (Office 365 Only)
  7:59Resolving Pivot Table Duplicate Values
  07:24Counting Text Instances in a Pivot Table
  07:00Conditional Formatting - Duplicates
  9:16Remove Conditional Formatting
  09:11Unlocking Data Validation Cells
  10:58Introduction to VLOOKUP
CONTINUOUS PLAY
  1:46:35Excel Efficiency: Dealing with Duplicates
SUPPORTING MATERIALS
  PDFSlides: Excel Efficiency: Dealing with Duplicates
  PDFExcel Efficiency: Dealing with Duplicates Glossary/Index
  XLSXWorkbook: Excel Efficiency: Dealing with Duplicates
REVIEW AND TEST
  quizReview Questions
 examFinal Exam