From the course: Excel: Managing and Analyzing Data

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Use the UNIQUE function to investigate data and data quality

Use the UNIQUE function to investigate data and data quality - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Use the UNIQUE function to investigate data and data quality

“

- [Instructor] Here is some data about people who studied and then took an exam. We've got Moises who took course A and passed. The instructor was Nirel, and the test location was 8th Avenue. And this was not a retake for Moises. But now look at Jody in the fifth row. Jody took course C, failed. It was a retake. The instructor was Mei, and the test location was 8th Avenue. There's a lot that we can get from this data if we can trust it. We could look at, do people prefer any test location over others? Are there any that people rarely go to? Is there any correlation between people who fail the exam and the instructor who prepared them for the exam? But before we start running pivot tables and writing formulas, we need to see how trustworthy this data is. Now the first thing we can do, my cursor is in the data set. I'm going to go to Filter, and then I'm going to go to pass fail. Okay, so we've got a 96 where we should only have a pass fail. And this is an example of where we really…

Contents