Learn Essential and Advanced Features of Excel 2007


show more Removing duplicates provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Removing duplicates

In this chapter, we're going to take a look at some of the advanced formatting options in Excel 2007. I'm going to open up a new spreadsheet, underneath my office button. And for those of you that would like to follow along, it's included in folder 05_Advanced_Formatting, and it's called EatCake. E-mail list.. And What it's going to show here is a list of the employees that are working for our eat cake organization. We're tracking their last name, their first name, their e-mail address, and When they started with the company. I kept the list fairly small so that it's easy to see commands that were going to be exploring in a moment. Filtering for unique values and removing duplicates.

The real power of these two commands are going to be seen when you have hundreds of rows of data to work with. What we want to do is we want to make sure that we don't have any duplicate information included in our list. And if you take a look at the information that I've g...

Removing duplicates
Video duration: 6m 1s 5h 13m Beginner

Viewers:

Removing duplicates provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...