Dealing with Duplicate Data in Excel

SKU: 06-525-01-CPE
Credit Hours: 2
Category: Specialized Knowledge and Applications
Level: Basic
Program Prerequisites: None
Delivery Method: Online Video
Instructor: David H. Ringstrom, CPA

Course Description:
This course will discuss how to create and remove duplicate data in Excel. You'll see mouse tricks for quickly duplicating rows, columns, and entire worksheets, as well as duplicating formatting to disparate cells.

This course has the following learning objectives:

State which Data Validation Error Alert prevents users from overriding the data validation rule assigned to a cell.
State what SUMIF returns if a match cannot be found.
Identify the arguments that correspond to the UNIQUE function.